Encyclopedia of Database Systems

2018 Edition
| Editors: Ling Liu, M. Tamer Özsu

OSQL

  • Tore Risch
Reference work entry
DOI: https://doi.org/10.1007/978-1-4614-8265-9_1109

Definition

OSQL [1, 2] is an functional query language and data model similar to Daplex, first implemented in the Iris DBMS [4]. The data model of OSQL is object oriented with three kinds of system entities: objects, types, and functions. A database consists of a set of objects, the objects are classified into types, and functions define the semantics of types. The data model is similar to an ER model with the difference that both entity relationships and attributes are represented as functions and that (multiple) inheritance among entity types is supported. OSQL provide object identifiers (OIDs) as first class objects, and, unlike Daplex, queries can return OIDs in results. Queries are expressed using a SELECT syntax similar to SQL. Derived functions are also defined using select statements similar to functions in SQL-2003.

Key Points

With the OSQL data model a database consists of a set of objects. The objects are classified into subsets by types and each type has an extent...

This is a preview of subscription content, log in to check access.

Recommended Reading

  1. 1.
    Beech D. A foundation of evolution from relational to object databases. In: Advances in Database Technology, Proceedings of the 1st International Conference on Extending Database Technology; 1988. p. 251–70.Google Scholar
  2. 2.
    Fishman DH, Beech D, Cate HP, Chow EC, Connors T, Davis JW, Derrett N, Hoch CG, Kent W, Lyngbaek P, Mahbod B, Neimat MA, Ryan TA, Shan Iris MC. An object-oriented database management system. ACM Trans Off Inf Syst. 1987;5(1):48–69.Google Scholar
  3. 3.
    Risch T, Josifovski V, Katchaounov T. Functional data integration in a distributed mediator system. In: Gray P, Kerschberg L, King P, Poulovassilis A, editors. Functional approach to data management – modeling, analyzing and integrating heterogeneous data. Berlin: Springer; 2003.Google Scholar
  4. 4.
    Wilkinson K, Lyngbaek P, Hasan W. The iris architecture and implementation. IEEE Trans Knowl Data Eng. 1990;2(1):63–75.CrossRefGoogle Scholar

Copyright information

© Springer Science+Business Media, LLC, part of Springer Nature 2018

Authors and Affiliations

  1. 1.Department of Information TechnologyUppsala UniversityUppsalaSweden

Section editors and affiliations

  • Tore Risch
    • 1
  1. 1.Dept. of Inf. TechnologyUppsala Univ.UppsalaSweden