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...
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Recommended Reading
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.
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.
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.
Wilkinson K, Lyngbaek P, Hasan W. The iris architecture and implementation. IEEE Trans Knowl Data Eng. 1990;2(1):63–75.
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Section Editor information
Rights and permissions
Copyright information
© 2018 Springer Science+Business Media, LLC, part of Springer Nature
About this entry
Cite this entry
Risch, T. (2018). OSQL. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_1109
Download citation
DOI: https://doi.org/10.1007/978-1-4614-8265-9_1109
Published:
Publisher Name: Springer, New York, NY
Print ISBN: 978-1-4614-8266-6
Online ISBN: 978-1-4614-8265-9
eBook Packages: Computer ScienceReference Module Computer Science and Engineering