Optimisation Strategies for Functional Queries in a Distributed Environment

  • Graham J. L. Kemp
  • Peter M. D. Gray
  • Suzanne M. Embury


In this chapter we describe the architecture of two distributed systems based on the Functional Data Model (FDM): the P/FDM database management system and the P/FDM mediator. These systems are closely related to one another and they share several source modules. In describing these systems we shall focus on their modular design, and the different kinds of optimisation that can be performed when processing queries and constraints. Both systems make use of an internal intermediate code for queries and constraints that is based on ZF-expressions. We describe how different query processing strategies can be adopted to improve performance when using different kinds of storage module. In describing the architecture of the P/FDM mediator we explain and how modules from the Daplex compiler have been reused in the P/FDM mediator’s own architecture, and the different kinds of optimisation that can be performed when processing queries that will be executed in a federated system.


Query Optimisation Rule Syntax Intelligent Information System Intermediate Code Remote Database 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 8.1
    P. Buneman, S.B. Davidson, K. Hart, G.C. Overton, and L. Wong. A Data Transformation System for Biological Data Sources. In U. Dayal, P.M.D. Gray, and S. Nishio, editors, VLDB’95, Proceedings of 21th International Conference on Very Large Data Bases, pages 158–169. Morgan Kaufmann, 1995.Google Scholar
  2. 8.2
    J. Claußen, A. Kemper, G. Moerkotte, and K. Peithner. Optimizing queries with universal quantification in object-oriented and object-relational databases. In M. Jarke, M.J. Carey, K.R. Dittrich, F.H. Lochovsky, P. Loucopoulos, and M.A. Jeusfeld, editors, VLDB’97, Proceedings of 23rd International Conference on Very Large Data Bases, Athens, Greece, pages 286–295. Morgan Kaufmann, 1997.Google Scholar
  3. 8.3
    S.M. Embury and P.M.D Gray. A Modular Compiler Architecture for a Data Manipulation Language. In Proceedings of 14th British National Conference on Databases (BNCOD 14), Edinburgh, Scotland, July 1996, pages 170–188. Springer-Verlag.Google Scholar
  4. 8.4
    T. Etzold and P. Argos. SRS an indexing and retrieval tool for flat file data libraries. CABIOS, 9:49–57, 1993.Google Scholar
  5. 8.5
    J.C. Freytag. A Rule-Based View of Query Optimization. In U. Dayal and I. Traiger, editors, Proceedings of the ACM SIGMOD 87 Conference, pages 173–180. ACM Press, 1987.CrossRefGoogle Scholar
  6. 8.6
    R.A. Ganski and H.K.T. Wong. Optimization of Nested SQL Queries Revisited. In U. Dayal and I.L. Traiger, editors, Proceedings of the ACM SIGMOD 87 Conference, pages 23–33. ACM Press, 1987.Google Scholar
  7. 8.7
    I. Gil, P.M.D. Gray, and G.J.L Kemp. A Visual Interface and Navigator for the P/FDM Object Database. In N.W. Paton and T Griffiths, editors, Proceedings of User Interfaces to Data Intensive Systems (UIDIS’99), pages 54–63. IEEE Computer Society Press, 1999.Google Scholar
  8. 8.8
    P.M.D. Gray, S.M. Embury, K.Y. Hui, and G.J.L. Kemp. The Evolving Role of Constraints in the Functional Data Model. Journal of Intelligent Information Systems, 12:113–137, 1999.CrossRefGoogle Scholar
  9. 8.9
    P.M.D. Gray, P.J.H. King, and L. Kerschberg. Guest Editor Introduction: Functional Approach to Intelligent Information Systems. Journal of Intelligent Information Systems, 12:107–111, 1999.Google Scholar
  10. 8.10
    P.M.D. Gray, K.G. Kulkarni, and N.W. Paton. Object-Oriented Databases: a Semantic Data Model Approach. Prentice Hall Series in Computer Science. Prentice Hall International, 1992.MATHGoogle Scholar
  11. 8.11
    L.M. Haas, P. Kodali, J.E. Rice, P.M. Schwarz, and W.C. Swope. Integrating Life Sciences Data—With a Little Garlic. In Proceedings IEEE International Symposium on Bio-Informatics and Biomedical Engineering, pages 5–12. IEEE Computer Society Press, 2000.CrossRefGoogle Scholar
  12. 8.12
    Z.G. Ives, D. Florescu, M. Friedman, A.Y. Levy, and D.S. Weld. An adaptive query execution system for data integration. In A. Delis, C. Faloutsos, and S. Ghandeharizadeh, editors, SIGMOD 1999, Proceedings of the ACM SIGMOD Conference, pages 299–310. ACM Press, 1999.CrossRefGoogle Scholar
  13. 8.13
    M. Jarke and J. Koch. Range nesting: A fast method to evaluate quantified queries. In D. J. DeWitt and G. Gardarin, editors, SIGMOD’83, Proceedings of Annual Meeting, San Jose, California, pages 196–206. ACM Press, 1983.Google Scholar
  14. 8.14
    Z. Jiao. Optimisation Studies in a Prolog Object-Oriented Database. PhD thesis, University of Aberdeen, Department of Computing Science, November 1992.Google Scholar
  15. 8.15
    Z. Jiao and P.M.D. Gray. Optimisation of Methods in a Navigational Query Language. In C. Delobel, M. Kifer, and Y. Masunaga, editors, Second International Conference on Deductive and Object-Oriented Databases, pages 22–42. Springer-Verlag, 1991.CrossRefGoogle Scholar
  16. 8.16
    P.D. Karp. A Vision of DB Interoperation. Meeting on the Interconnection of Molecular Biology Databases, 1995.Google Scholar
  17. 8.17
    G.J.L. Kemp, N. Angelopoulos, and P.M.D. Gray. A Schema-based Approach to Building a Bioinformatics Database Federation. In Proceedings IEEE International Symposium on Bio-Informatics and Biomedical Engineering, pages 13–20. IEEE Computer Society Press, 2000.CrossRefGoogle Scholar
  18. 8.18
    G.J.L. Kemp, N. Angelopoulos, and P.M.D. Gray. Architecture of a Mediator for a Bioinformatics Database Federation. IEEE Transactions on Information Technology in Biomedicine, 6:116–122, 2002.CrossRefGoogle Scholar
  19. 8.19
    G.J.L. Kemp, P.M.D. Gray, and A.R. Sjöstedt. Rewrite Rules for Quantified Subqueries in a Federated Database. In L. Kerschberg and M. Kafatos, editors, Proceedings Thirteenth International Conference on Scientific and Statistical Database Management, pages 134–143. IEEE Computer Society Press, 2001.Google Scholar
  20. 8.20
    G.J.L. Kemp, J.J. Iriarte, and P.M.D. Gray. Efficient Access to FDM Objects Stored in a Relational Database. In D.S. Bowers, editor, Directions in Databases: Proceedings of the Twelfth British National Conference on Databases, pages 170–186. Springer-Verlag, 1994.Google Scholar
  21. 8.21
    G.J.L. Kemp, Z. Jiao, P.M.D. Gray, and J.E. Fothergill. Combining Computation with Database Access in Biomolecular Computing. In W. Litwin and T. Risch, editors, Applications of Databases: Proceedings of the First International Conference, pages 317–335. Springer-Verlag, 1994.Google Scholar
  22. 8.22
    G.J.L. Kemp, C.J. Robertson, P.M.D. Gray, and N. Angelopoulos. CORBA and XML: Design Choices for Database Federations. In B. Lings and K. Jeffery, editors, Proceedings of the Seventeenth British National Conference on Databases, pages 191–208. Springer-Verlag, 2000.Google Scholar
  23. 8.23
    W. Kim. On Optimizing an SQL-like Nested Query. ACM Transactions on Database Systems, 7:443–469, 1982.MATHCrossRefGoogle Scholar
  24. 8.24
    J.J. King. Query Optimisation by Semantic Reasoning. UMI Research Press, 1984.Google Scholar
  25. 8.25
    T. Landers and R. L. Rosenberg. An Overview of MULTIBASE. In H.-J. Schneider, editor, Distributed Data Bases. North-Holland, 1982.Google Scholar
  26. 8.26
    M. Muralikrishna. Improved Unnesting Algorithms for Join Aggregate SQL Queries. In L. Yuan, editor, 18th International Conference on Very Large Data Bases, August 23–27, 1992, Vancouver, Canada, Proceedings, pages 91–102. Morgan Kaufmann, 1992.Google Scholar
  27. 8.27
    N.W. Paton and P.M.D. Gray. Optimising and Executing Daplex Queries Using Prolog. The Computer Journal, 33:547–555, 1990.CrossRefGoogle Scholar
  28. 8.28
    N.W. Paton, R. Stevens, P. Baker, C.A. Goble, S. Bechhofer, and A. Brass. Query Processing in the TAMBIS Bioinformatics Source Integration System. In 11th International Conference on Scientific and Statistical Database Management, Proceedings, pages 138–147. IEEE Computer Society Press, 1999.CrossRefGoogle Scholar
  29. 8.29
    H. Pirahesh, J.M. Hellerstein, and W. Hasan. Extensible/Rule Based Query Rewrite Optimization in Starburst. In M. Stonebraker, editor, Proceedings of the 1992 ACM SIGMOD International Conference, pages 39–48. ACM Press, 1992.CrossRefGoogle Scholar
  30. 8.30
    T. Risch, V. Josifovski, and T. Katchaounov. AMOS II Concepts. Available at, November 1999.Google Scholar
  31. 8.31
    R. J. Robbins. Bioinformatics: Essential Infrastructure for Global Biology. Journal of Computational Biolology, 3:465–478, 1996.CrossRefGoogle Scholar
  32. 8.32
    A.P. Sheth and J.A. Larson. Federated database systems for managing distributed, heterogeneous and autonomous databases. ACM Computing Surveys, 22:183–236, 1990.CrossRefGoogle Scholar
  33. 8.33
    D.W. Shipman. The Functional Data Model and the Data Language DAPLEX. ACM Transactions on Database Systems, 6(1):140–173, 1981.CrossRefGoogle Scholar
  34. 8.34
    Sjöstedt, A.R. Using AMOS II as Data Source for P/FDM and Rewriting Quantified AMOSQL Queries. Project Report, Department of Computing Science, University of Aberdeen, 2000.Google Scholar
  35. 8.35
    L. Wong. Kleisli, a Functional Query System. Journal of Functional Programming, 10(l):19–56, 2000.CrossRefGoogle Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2004

Authors and Affiliations

  • Graham J. L. Kemp
    • 1
  • Peter M. D. Gray
    • 2
  • Suzanne M. Embury
    • 3
  1. 1.Department of Computing ScienceChalmers University of TechnologyGöteborgSweden
  2. 2.Department of Computing Science, King’s CollegeUniversity of AberdeenAberdeenUK
  3. 3.Department of Computer ScienceUniversity of ManchesterManchesterUK

Personalised recommendations