A guide to the SQL standard
Principles of database and knowledge-base systems, Vol. I
Principles of database and knowledge-base systems, Vol. I
A software tool for modular database design
ACM Transactions on Database Systems (TODS)
Temporal databases: theory, design, and implementation
Temporal databases: theory, design, and implementation
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
Building the data warehouse (2nd ed.)
Building the data warehouse (2nd ed.)
Ordered functional dependencies in relational databases
Information Systems
Joe Celko's SQL for Smarties: Advanced SQL Programming
Joe Celko's SQL for Smarties: Advanced SQL Programming
IBM Smalltalk: The Language
Relational Database Writings, 1991-1994
Relational Database Writings, 1991-1994
A Guided Tour of Relational Databases and Beyond
A Guided Tour of Relational Databases and Beyond
ICDE '96 Proceedings of the Twelfth International Conference on Data Engineering
A Semantics-based Approach to Design of Query Languages for Partial Information
Selected Papers from a Workshop on Semantics in Databases
The role of tools in development of a data warehouse
SAST '96 Proceedings of the Proceedings of the Fourth International Symposium on Assessment of Software Tools (SAST '96)
An extension of SQL to support ordered domains in relational databases
IDEAS '97 Proceedings of the 1997 International Symposium on Database Engineering & Applications
Hi-index | 0.00 |
Data warehousing is a corporate strategy that needs to integrate information from several sources of separately developed Database Management Systems (DBMSs). A future DBMS of a data warehouse should provide adequate facilities to manage a wide range of information arising from such integration. We propose that the capabilities of database languages should be enhanced to manipulate user-defined data orderings, since business queries in an enterprise usually involve order. We extend the relational model to incorporate partial orderings into data domains and describe the ordered relational model. We have already defined and implemented a minimal extension of SQL, called OSQL, which allows querying over ordered relational databases. One of the important facilities provided by OSQL is that it allows users to capture the underlying semantics of the ordering of the data for a given application. Herein we demonstrate that OSQL aided with a package discipline can be an effective means to manage the inter-related operations and the underlying data domains of a wide range of advanced applications that are vital in data warehousing, such as temporal, incomplete and fuzzy information. We present the details of the generic operations arising from these applications in the form of three OSQL packages called: OSQL_TIME, OSQL__INCOMP and OSQL_FUZZY.