A decisions query language (DQL): high-level abstraction for mathematical programming over databases

  • Authors:
  • Alexander Brodsky;Mayur M. Bhot;Manasa Chandrashekar;Nathan E. Egge;X. Sean Wang

  • Affiliations:
  • George Mason University, Fairfax, VT, USA;George Mason University, Fairfax, VT, USA;George Mason University, Fairfax, VT, USA;George Mason University, Fairfax, VT, USA;University of Vermont, Burlington, VT, USA

  • Venue:
  • Proceedings of the 2009 ACM SIGMOD International Conference on Management of data
  • Year:
  • 2009

Quantified Score

Hi-index 0.00

Visualization

Abstract

The demonstrated, high-level decisions query language DQL combines the decision optimization capability of mathematical programming and the data manipulation capability of traditional database query languages. DQL benefits application developers in two aspects. First, it avoids a conceptual impedance mismatch between mathematical programming and data access and makes decision optimization functionality readily accessible to database programmers with no prior experience in operations research. Second, a tight integration provides unique opportunities for more efficient evaluation as compared to a loosely coupled system. This demonstration uses an emergency response scenario to illustrate the power of the language and its implementation.