SQL-based semantics for path expressions over hierarchical data in relational databases

Hierarchical part-of relationships/aggregation structures and related queries are essential parts of information systems. However, relational database query languages do not explicitly support hierarchical relationships and queries. A hierarchical query may require a great number of join operations, which increases the effort in query formulation. Therefore, we propose path expressions in formulating hierarchical views over relational data because path expressions are a conventional and compact way to represent hierarchical relationships. We embed path expressions within SQL queries and compile them to standard SQL. This ensures that the path expressions can straightforwardly be implemented on the top of standard relational database systems. The compilation of a path expression is given by an attribute grammar, a conventional formalism to define the semantics of a language.

[1]  Abraham Silberschatz,et al.  Extended algebra and calculus for nested relational databases , 1988, TODS.

[2]  Marko Junkkari,et al.  PSE: An Object-Oriented Representation for Modeling and Managing Part-of Relationships , 2005, Journal of Intelligent Information Systems.

[3]  Kemal Koymen,et al.  SQL*: a recursive SQL , 1993, Inf. Syst..

[4]  Sophie Cluet,et al.  Designing OQL: Allowing Objects to be Queried , 1998, Inf. Syst..

[5]  Jianwen Su,et al.  Incremental maintenance of recursive views using relational calculus/SQL , 2000, SGMD.

[6]  Sabina Petride,et al.  Binary XML Storage and Query Processing in Oracle 11g , 2009, Proc. VLDB Endow..

[7]  Klaus R. Dittrich,et al.  On the Migration of Relational Schemas and Data to Object-OrientedDatabase Systems , 1997 .

[8]  Volker Linnemann.  Non first normal form relations and recursive queries: An SQL-based approach , 1987, 1987 IEEE Third International Conference on Data Engineering.

[9]  Marie-Christine Rousset,et al.  Modeling and Verifying Complex Objects: A Declarative Approach Based on Description Logics , 1996, ECAI.

[10]  Christelle Urtado,et al.  Complex Entity Versioning at Two Granularity Levels , 1998, Inf. Syst..

[11]  P. Burrough,et al.  Principles of geographical information systems , 1998 .

[12]  Jukka Teuhola,et al.  Path Signatures: A Way to Speed Up Recursion in Relational Databases , 1996, IEEE Trans. Knowl. Data Eng..

[13]  Shankar Pal,et al.  Indexing XML Data Stored in a Relational Database , 2004, VLDB.

[14]  Franco Civello,et al.  Roles for composite objects in object-oriented analysis and design , 1993, OOPSLA '93.

[15]  Scott Boag,et al.  XQuery 1.0 : An XML Query Language , 2007 .

[16]  S. Sudarshan,et al.  Keyword searching and browsing in databases using BANKS , 2002, Proceedings 18th International Conference on Data Engineering.

[17]  Donald E. Knuth,et al.  Semantics of context-free languages , 1968, Mathematical systems theory.

[18]  Renate Motschnig,et al.  Part-Whole Relationship Categories and Their Application in Object-Oriented Analysis , 1999, IEEE Trans. Knowl. Data Eng..

[19]  Steven J. DeRose,et al.  XML Path Language (XPath) Version 1.0 , 1999 .

[20]  Patrick Valduriez,et al.  Evaluation of Recursive Queries Using Join Indices , 1986, Expert Database Conf..

[21]  Timo Niemi,et al.  A Straightforward NF² Relational Interface with Applications in Information Retrieval , 1995, Inf. Process. Manag..

[22]  Uwe Kastens.  Attributed Grammars as a Specification Method , 1991, Attribute Grammars, Applications and Systems.

[23]  Michael M. David.  ANSI SQL hierarchical processing can fully integrate native XML , 2003, SGMD.

[24]  David W. Stemple,et al.  Human factors comparison of a procedural and a nonprocedural query language , 1981, TODS.

[25]  Jukka Paakki,et al.  Attribute grammar paradigms—a high-level methodology in language implementation , 1995, CSUR.

[26]  E. F. CODD,et al.  A relational model of data for large shared data banks , 1970, CACM.

[27]  Martti Tienari,et al.  On the definition of attribute grammar , 1980, Semantics-Directed Compiler Generation.

[28]  Carlos Ordonez.  Optimizing recursive queries in SQL , 2005, SIGMOD '05.

[29]  PaakkiJukka.  Attribute grammar paradigmsa high-level methodology in language implementation , 1995 .

[30]  Yangjun Chen,et al.  A new algorithm for transitive closures and computation of recursion in relational databases , 2003, Proceedings on Seventh International Conference on Information Visualization, 2003. IV 2003..

[31]  William E. Lorensen,et al.  Object-Oriented Modeling and Design , 1991, TOOLS.

[32]  Roger King,et al.  Semantic database modeling: survey, applications, and research issues , 1987, CSUR.

[33]  Zahir Tari,et al.  QAL: A Query Algebra of Complex Objects , 1999, Data Knowl. Eng..

[34]  R. G. G. Cattell,et al.  Recent books , 2000, IEEE Spectrum.

[35]  Keng Siau,et al.  Unified modeling language : systems analysis, design and development issues , 2001 .

[36]  Alfred V. Aho,et al.  Compilers: Principles, Techniques, and Tools , 1986, Addison-Wesley series in computer science / World student series edition.

[37]  Luca Pazzi,et al.  Implicit versus Explicit Characterization of Complex Entities and Events , 1999, Data Knowl. Eng..

[38]  Jochen Bernauer,et al.  Analysis of Part-Whole Relation and Subsumption in the Medical Domain , 1996, Data Knowl. Eng..

[39]  Martin Andersson,et al.  Extracting an Entity Relationship Schema From a Relational Database Through Reverse Engineering , 1994, Int. J. Cooperative Inf. Syst..