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.

Talk to us

Join us for a 30 min session where you can share your feedback and ask us any queries you have

Schedule a call

Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.