Hybrid Data-Flow Graphs for Procedural Domain-Specific Query Languages

  • Bernhard Jaecksch
  • Franz Faerber
  • Frank Rosenthal
  • Wolfgang Lehner
Part of the Lecture Notes in Computer Science book series (LNCS, volume 6809)

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.

Copyright information

© Springer-Verlag Berlin Heidelberg 2011

Authors and Affiliations

  • Bernhard Jaecksch
    • 1
  • Franz Faerber
    • 1
  • Frank Rosenthal
    • 2
  • Wolfgang Lehner
    • 2
  1. 1.SAP AGWalldorfGermany
  2. 2.Database Technology GroupTU Dresden, Institute for System ArchitectureDresdenGermany

Personalised recommendations