Supporting Agile Organizations with a Decision Guidance Query Language

  • Authors:
  • Alexander Brodsky;Nathan Egge;X. Wang

  • Affiliations:
  • Center for Smart Power Grids, Computer Science, George Mason University;George Mason University;School of Computer Science, Fudan University, Shanghai, China

  • Venue:
  • Journal of Management Information Systems
  • Year:
  • 2012

Quantified Score

Hi-index 0.00

Visualization

Abstract

Decision optimization is widely used in many decision guidance and support systems DGSS to support business decisions such as procurement, scheduling, and planning. In spite of rapid changes in users' requirements, the implementation of DGSS is typically rigid, expensive, and not easily extensible, which is in stark contrast to the agile implementation of management information systems MIS based on the database management systems DBMS and SQL technologies. This paper focuses on the Decision Guidance Query Language DGQL designed to re-use SQL programs for decision optimization with the goals of making DGSS implementation agile and intuitive and leveraging existing investment in SQL-implemented MIS. The paper addresses two related technical issues with DGQL: 1 how to annotate existing queries to precisely express the optimization semantics, and 2 how to translate the annotated queries into equivalent mathematical programming formulations that can be solved efficiently.