Object Query Language
Object Query Language (OQL) is a query language standard for object-oriented databases modeled after SQL and developed by the Object Data Management Group (ODMG).
≈ 2 min read
Names in other languages
No names in other languages are held for this entry yet.
Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.
Object Query Language (OQL) is a query language standard for object-oriented databases modeled after SQL and developed by the Object Data Management Group (ODMG). Because of its overall complexity the complete OQL standard has not yet been fully implemented in any software. The OQL standard influenced the design of later query languages such as JDOQL and EJB QL, though none are considered to be any version of OQL.
General rules
edit edit sourceThe following rules apply to OQL statements:
- All complete statements must be terminated by a semi-colon.
- A list of entries in OQL is usually separated by commas but not terminated by a comma.
- Strings of text are enclosed by matching quotation marks.
Examples
edit edit sourceSimple query
edit edit sourceThe following example illustrates how one might retrieve the CPU-speed of all PCs with more than 64MB of RAM from a fictional PC database:
SELECT pc.cpuspeed FROM PCs pc WHERE pc.ram > 64;Query with grouping and aggregation
edit edit sourceThe following example illustrates how one might retrieve the average amount of RAM on a PC, grouped by manufacturer:
SELECT manufacturer, AVG(SELECT part.pc.ram FROM partition part) FROM PCs pc GROUP BY manufacturer: pc.manufacturer;Note the use of the keyword partition, as opposed to aggregation in traditional SQL.
See also
edit edit source- Object Data Management Group (ODMG)
- Object Definition Language
References
edit edit source- Dietrich, Suzanne; Urban, Susan (31 May 2022). "2.4 The ODMG Query Language". Fundamentals of Object Databases. Springer Nature. pp. 31–52. ISBN 978-3-031-01844-2.
- Cattell, Roderic Geoffrey Galton; Barry, Douglas K.; Berler, Mark (2000). "Object Query Language". The Object Data Standard: ODMG 3.0. Morgan Kaufmann. pp. 89–152. ISBN 978-1-55860-647-0. Retrieved 31 March 2025.
Text derived from https://en.wikipedia.org/w/index.php?oldid=1329628224 under CC BY-SA 4.0; modifications have been made.