Object Query Language
 | This article includes a list of references, related reading, or external links, but its sources remain unclear because it lacks inline citations. (March 2025) |
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
The 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
Simple query
The 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
The 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
- Object Data Management Group (ODMG)
- Object Definition Language
References
- 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.
 | This software-engineering-related article is a stub. You can help Wikipedia by adding missing information. |
 | This programming-language-related article is a stub. You can help Wikipedia by adding missing information. |
Content Disclaimer
Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.
- The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
- There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
- It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
- Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
- Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.