Skip to main content

OSQL

  • Living reference work entry
  • First Online:
Encyclopedia of Database Systems
  • 116 Accesses

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 via an institution to check access.

Access this chapter

Institutional subscriptions

Recommended Reading

  1. Beech D. A foundation of evolution from relational to object databases. In Advances in database technology. In: Proceedings of the 1st international conference on extending database technology. 1988. p. 251–70.

    Google Scholar 

  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. 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. Wilkinson K, Lyngbaek P, Hasan W. The iris architecture and implementation. IEEE Trans Knowl Data Eng. 1990;2(1):63–75.

    Article  Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Corresponding author

Correspondence to Tore Risch .

Editor information

Editors and Affiliations

Section Editor information

Rights and permissions

Reprints and permissions

Copyright information

© 2016 Springer Science+Business Media LLC

About this entry

Cite this entry

Risch, T. (2016). OSQL. In: Liu, L., Özsu, M. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4899-7993-3_1109-2

Download citation

  • DOI: https://doi.org/10.1007/978-1-4899-7993-3_1109-2

  • Received:

  • Accepted:

  • Published:

  • Publisher Name: Springer, New York, NY

  • Online ISBN: 978-1-4899-7993-3

  • eBook Packages: Springer Reference Computer SciencesReference Module Computer Science and Engineering

Publish with us

Policies and ethics