demonstration

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 WangAuthors Info & Claims

SIGMOD '09: Proceedings of the 2009 ACM SIGMOD International Conference on Management of data

Pages 1059 - 1062

https://doi.org/10.1145/1559845.1559981

Published: 29 June 2009 Publication History

Get Access

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.

References

[1]

Alexander Brodsky and X. Sean Wang: Decision-Guidance Management Systems (DGMS): Seamless Integration of Data Acquisition, Learning, Prediction and Optimization. HICSS 2008.

Digital Library

Google Scholar

[2]

http://www.ampl.com

Google Scholar

Cited By

View all

Shao GBrodsky AShin SKim D(2017)Decision guidance methodology for sustainable manufacturing using process analytics formalismJournal of Intelligent Manufacturing10.1007/s10845-014-0995-328:2(455-472)Online publication date: 1-Feb-2017
https://dl.acm.org/doi/10.1007/s10845-014-0995-3
Ngan CBrodsky AEgge NBackus E(2014)Optimizing Power, Heating, and Cooling Capacity on a Decision-Guided Energy Investment FrameworkEnterprise Information Systems10.1007/978-3-319-09492-2_10(154-173)Online publication date: 25-Jul-2014
https://doi.org/10.1007/978-3-319-09492-2_10
Egge NMotro ABrodsky AD'Atri A(2012)Optimizing Procurement Decisions in Networked Virtual EnterprisesInternational Journal of Decision Support System Technology10.4018/jdsst.20120701044:3(43-67)Online publication date: 1-Jul-2012
https://dl.acm.org/doi/10.4018/jdsst.2012070104
Show More Cited By

Index Terms

A decisions query language (DQL): high-level abstraction for mathematical programming over databases
1. Software and its engineering
  1. Software creation and management
    1. Software development techniques

Recommendations

An Archetype Query Language interpreter into MongoDB: Managing NoSQL standardized Electronic Health Record extracts systems
Graphical abstract

Display Omitted
Highlights
- Archetype Query Language queries can be translated to the MongoDB query language.
Abstract
The fast development of today’s healthcare and the need to extract new medical knowledge from exponentially-growing volumes of standardized Electronic Health Records data, as required by studies in Precision Medicine, brings up a ...
Query containment under bag and bag-set semantics

Conjunctive queries (CQs) are at the core of query languages encountered in many logic-based research fields such as AI, or database systems. The majority of existing work assumes set semantics but often in real applications the manipulation of ...
Extending Database Programming Language with Ad hoc Query Facilities

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

SIGMOD '09: Proceedings of the 2009 ACM SIGMOD International Conference on Management of data

June 2009

1168 pages

ISBN:9781605585512

DOI:10.1145/1559845

Editors:
Carsten Binnig,
Benoit Dageville,
General Chairs:
Uğur Çetintemel
Brown University, USA
,
Stan Zdonik
Brown University, USA
,
Program Chair:
Donald Kossmann
ETH Zurich, Switzerland

Permission to make digital or hard copies of part or all of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for third-party components of this work must be honored. For all other uses, contact the Owner/Author.

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 29 June 2009

Check for updates

Author Tags

Qualifiers

Demonstration

Conference

SIGMOD/PODS '09

Sponsor:

SIGMOD/PODS '09: International Conference on Management of Data

June 29 - July 2, 2009

Rhode Island, Providence, USA

Acceptance Rates

Overall Acceptance Rate 785 of 4,003 submissions, 20%

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

11
Total Citations
View Citations
428
Total Downloads

Downloads (Last 12 months)4
Downloads (Last 6 weeks)1

Reflects downloads up to 31 Dec 2024

Other Metrics

View Author Metrics

Citations

Cited By

View all

Shao GBrodsky AShin SKim D(2017)Decision guidance methodology for sustainable manufacturing using process analytics formalismJournal of Intelligent Manufacturing10.1007/s10845-014-0995-328:2(455-472)Online publication date: 1-Feb-2017
https://dl.acm.org/doi/10.1007/s10845-014-0995-3
Ngan CBrodsky AEgge NBackus E(2014)Optimizing Power, Heating, and Cooling Capacity on a Decision-Guided Energy Investment FrameworkEnterprise Information Systems10.1007/978-3-319-09492-2_10(154-173)Online publication date: 25-Jul-2014
https://doi.org/10.1007/978-3-319-09492-2_10
Egge NMotro ABrodsky AD'Atri A(2012)Optimizing Procurement Decisions in Networked Virtual EnterprisesInternational Journal of Decision Support System Technology10.4018/jdsst.20120701044:3(43-67)Online publication date: 1-Jul-2012
https://dl.acm.org/doi/10.4018/jdsst.2012070104
Egge NBrodsky AGriva I(2012)Distributed Manufacturing NetworksInternational Journal of Decision Support System Technology10.4018/jdsst.20120701034:3(25-42)Online publication date: 1-Jul-2012
https://dl.acm.org/doi/10.4018/jdsst.2012070103
Egge NBrodsky AGriva I(2012)Online Optimization through Preprocessing for Multi-stage Production Decision Guidance QueriesProceedings of the 2012 IEEE 28th International Conference on Data Engineering Workshops10.1109/ICDEW.2012.61(41-48)Online publication date: 1-Apr-2012
https://dl.acm.org/doi/10.1109/ICDEW.2012.61
Haller AStrazdins PZhang MGeorgakopoulos DRanjan R(2012)Investigating decision support techniques for automating Cloud service selectionProceedings of the 2012 IEEE 4th International Conference on Cloud Computing Technology and Science (CloudCom)10.1109/CloudCom.2012.6427501(759-764)Online publication date: 3-Dec-2012
https://dl.acm.org/doi/10.1109/CloudCom.2012.6427501
Zhang MRanjan RNepal SMenzel MHaller A(2012)A declarative recommender system for cloud infrastructure services selectionProceedings of the 9th international conference on Economics of Grids, Clouds, Systems, and Services10.1007/978-3-642-35194-5_8(102-113)Online publication date: 27-Nov-2012
https://dl.acm.org/doi/10.1007/978-3-642-35194-5_8
Ngan CBrodsky ALin J(2012)An Event-Based Service Framework for Learning, Querying and Monitoring Multivariate Time SeriesEnterprise Information Systems10.1007/978-3-642-29958-2_14(208-223)Online publication date: 2012
https://doi.org/10.1007/978-3-642-29958-2_14
Arinez JBiller SBrodsky AMenasce DGuodong Shao Sousa J(2011)Decision-Guided Self-Architecting Framework for integrated distribution and Energy ManagementISGT 201110.1109/ISGT.2011.5759190(1-8)Online publication date: Jan-2011
https://doi.org/10.1109/ISGT.2011.5759190
Alrazgan ANagarajan ABrodsky AEgge N(2011)Learning Occupancy Prediction Models with Decision-Guidance Query LanguageProceedings of the 2011 44th Hawaii International Conference on System Sciences10.1109/HICSS.2011.281(1-10)Online publication date: 4-Jan-2011
https://dl.acm.org/doi/10.1109/HICSS.2011.281
Show More Cited By

View Options

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Cited By

Index Terms

Recommendations

An Archetype Query Language interpreter into MongoDB: Managing NoSQL standardized Electronic Health Record extracts systems

Query containment under bag and bag-set semantics

Extending Database Programming Language with Ad hoc Query Facilities