A query language and optimization techniques for unstructured data
Peter Buneman, Susan B. Davidson, Gerd G. Hillebrand et al. · Proceedings - ACM-SIGMOD International Conference on Management of Data · 1996
A new kind of data model has recently emerged in which the database is not constrained by a conventional schema. Systems like ACeDB, which has become very popular with biologists, and the recent Tsimmis proposal for data integration organize data in tree-like structures whose components can be used equally well to represent sets and tuples. Such structures allow great flexibility y in data representation.What query language is appropriate for such structures? Here we propose a simple language UnQL for querying data organized as a rooted, edge-labeled graph. In this model, relational data may be represented as fixed-depth trees, and on such trees UnQL is equivalent to the relational algebra. The novelty of UnQL consists in its programming constructs for arbitrarily deep data and for cyclic structures. While strictly more powerful than query languages with path expressions like XSQL, UnQL can still be efficiently evaluated. We describe new optimization techniques for the deep or "vertical" dimension of UnQL queries. Furthermore, we show that known optimization techniques for operators on flat relations apply to the "horizontal" dimension of UnQL.
Cited by 533 works. doi:10.1145/233269.233368
Authors
References
- Communication and Concurrency
- Object exchange across heterogeneous information sources
- Querying object-oriented databases
- GraphLog
- F-logic: a higher-order language for reasoning about objects, inheritance, and scheme
- Programming Constructs for Unstructured Data
- A Data Transformation System for Biological Data Sources
- Comprehension syntax
- Naturally embedded query languages
- Logical and computational aspects of programming with sets/bags/lists