Adding time dimension to relational model and extending relational algebra
Information Systems
Principles of database and knowledge-base systems, Vol. I
Principles of database and knowledge-base systems, Vol. I
Relational database writings (1985–1989)
Relational database writings (1985–1989)
An extension of SQL for querying graph relations
Computer Languages
Using powerdomains to generalize relational databases
Theoretical Computer Science
Temporal databases: theory, design, and implementation
Temporal databases: theory, design, and implementation
Relational database theory
PODS '93 Proceedings of the twelfth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
ACM SIGMOD Record
Recent design trade-offs in SQL3
ACM SIGMOD Record
Fuzzy sets and fuzzy logic: theory and applications
Fuzzy sets and fuzzy logic: theory and applications
Extending the database relational model to capture more meaning
ACM Transactions on Database Systems (TODS)
A relational model of data for large shared data banks
Communications of the ACM
Joe Celko's SQL for Smarties: Advanced SQL Programming
Joe Celko's SQL for Smarties: Advanced SQL Programming
ICDE '96 Proceedings of the Twelfth International Conference on Data Engineering
A Multi-Resolution Relational Data Model
VLDB '92 Proceedings of the 18th International Conference on Very Large Data Bases
A Semantics-based Approach to Design of Query Languages for Partial Information
Selected Papers from a Workshop on Semantics in Databases
The Development of Ordered SQL Packages for Modelling Advanced Applications
DEXA '97 Proceedings of the 8th International Conference on Database and Expert Systems Applications
Partial-order databases
Analysis and modelling of aspects of imperfection and time in databases
Analysis and modelling of aspects of imperfection and time in databases
Lexicographically Ordered Functional Dependencies and Their Application to Temporal Relations
IDEAS '99 Proceedings of the 1999 International Symposium on Database Engineering & Applications
| Hi-index | 0.00 |
The ordered relational model is an extension of the relational model which incorporates partial orderings into data domains. Herein 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.