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...
Recommended Reading
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.
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
© 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