Hybrid data-flow graphs for procedural domain-specific query languages

  • Authors:
  • Bernhard Jaecksch;Franz Faerber;Frank Rosenthal;Wolfgang Lehner

  • Affiliations:
  • SAP AG, Walldorf, Germany;SAP AG, Walldorf, Germany;TU Dresden, Institute for System Architecture, Database Technology Group, Dresden, Germany;TU Dresden, Institute for System Architecture, Database Technology Group, Dresden, Germany

  • Venue:
  • SSDBM'11 Proceedings of the 23rd international conference on Scientific and statistical database management
  • Year:
  • 2011

Quantified Score

Hi-index 0.00

Visualization

Abstract

Domain-specific query languages (DSQL) let users express custom business logic. Relational databases provide a limited set of options to execute business logic. Usually, stored procedures or a series of queries with some glue code. Both methods have drawbacks and often business logic is still executed on application side transferring large amounts of data between application and database, which is expensive. We translate a DSQL into a hybrid data-flow execution plan, containing relational operators mixed with procedural ones. A cost model is used to drive the translation towards an optimal mixture of relational and procedural plan operators.