On parallel processing of aggregate and scalar functions in object-relational DBMS
SIGMOD '98 Proceedings of the 1998 ACM SIGMOD international conference on Management of data
An extension of the relational data model to incorporate ordered domains
ACM Transactions on Database Systems (TODS)
Complex Visual Activity Recognition Using a Temporally Ordered Database
VISUAL '99 Proceedings of the Third International Conference on Visual Information and Information Systems
The development of ordered SQL packages to support data warehousing
Data warehousing and web engineering
New concepts for parallel object-relational query processing
New concepts for parallel object-relational query processing
Hi-index | 0.00 |
The ordered relational model is an extension of the relational model which incorporates partial orderings into data domains. We demonstrate that the ordered relational model is suitable for modelling advanced applications involving tree-structured information, incomplete information and temporal information. We describe OSQL, which is an extension of SQL for the ordered relational model, and show that OSQL combines the capabilities of standard SQL with the power of user-defined semantic orderings. The syntax of OSQL is a minimal extension of SQL and thus it should be easy for current SQL users to adapt to OSQL. Although it is a minimal extension, OSQL allows the users to formulate a wide range of queries, such as fuzzy or temporal, which are either very awkward or impossible to formulate in standard SQL. We also discuss the experimental implementation of OSQL and the further development of the capabilities of OSQL via the notion of an OSQL package in databases, which utilises semantic orderings to define the set of core operations associated with a specific application.