BIROn - Birkbeck Institutional Research Online

    An extension of SQL to support ordered domains in relational databases

    Ng, W. and Levene, Mark (1997) An extension of SQL to support ordered domains in relational databases. In: UNSPECIFIED (ed.) Proceedings of the International Database Engineering and Applications Symposium. IEEE Computer Society, pp. 358-367. ISBN 0818681144.

    Full text not available from this repository.

    Abstract

    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.

    Metadata

    Item Type: Book Section
    School: Birkbeck Faculties and Schools > Faculty of Science > School of Computing and Mathematical Sciences
    Depositing User: Sarah Hall
    Date Deposited: 08 Jun 2021 09:47
    Last Modified: 09 Aug 2023 12:51
    URI: https://eprints.bbk.ac.uk/id/eprint/44651

    Statistics

    Activity Overview
    6 month trend
    0Downloads
    6 month trend
    84Hits

    Additional statistics are available via IRStats2.

    Archive Staff Only (login required)

    Edit/View Item Edit/View Item