Scholion.ai

SQLMP: A Data Sublanguage for Representation and Formulation of Linear Mathematical Models

Joobin Choobineh

ORSA Journal on Computing · 1991 · Volume 3 · Issue 4

DOI: 10.1287/ijoc.3.4.358

Abstract

We show how algebraic linear optimization models can be mapped to the relational model of data. We then introduce SQLMP, a new language for model description and manipulation. SQLMP (SQL for Mathematical Programming) is the result of endowing the Structured Query Language (SQL) with additional constructs for the definition of the objective functions and the constraints of optimization models. Features of SQLMP enable 1) smooth integration of mathematical models with SQL-based databases, 2) model manipulation, and 3) attainment of a high degree of model independence. Formal syntax of the SQLMP is given. INFORMS Journal on Computing , ISSN 1091-9856, was published as ORSA Journal on Computing from 1989 to 1995 under ISSN 0899-1499.

Keywords

data bases: SQL is extended for mathematical programming, linear programming, linear mathematical models, SQL, model description, model manipulation

Enable JavaScript for citation tools and additional paper interactions.