Object Query Language OQL is a query language standard for object database object oriented databases modeled after SQL . OQL was developed by the Object Data Management Group ODMG . Because of its overall complexity no vendor has ever fully implemented the complete OQL. OQL has influenced the design of some of the newer query languages like JDOQL and EJB QL , but they can t be considered as different flavors of OQL. General Rules of OQL 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 Random access memory RAM from a fictional Personal computer PC database code SELECT pc.cpuspeed br FROM PCs pc br WHERE pc.ram 64 br code Query with grouping and aggregation The following example illustrates how one might retrieve the average amount of RAM on a Personal computer PC , grouped by manufacturer code SELECT manufacturer, AVG SELECT part.pc.ram FROM partition part br FROM PCs pc br GROUP BY manufacturer pc.manufacturer code Note the use of the keyword code partition code , as opposed to aggregation in traditional SQL . References reflist See also ODMG Object Data Management Group Object Definition Language Query languages Soft eng stub Compu lang stub Category Computer languages Category Query languages de Object Query Language es Object Query Language eu Object Query Language fr Object Query Language it Object Query Language ja pl Object Query Language ... more details
to invoke OQL. Smalltalk Language Binding. This defined the mapping between the ODMG ODL and Smalltalk ... IDL . The Smalltalk binding also provided a mechanism to invoke OQL. Java Language Binding. This defined ... by the Java 2 Platform. The Java binding also provided a mechanism to invoke OQL. Status ODMG ... more details
Unreferenced date November 2006 Object Definition Language ODL is the specification language defining the interface to object types conforming to the ODMG Object Model . Often abbreviated by the acronym ODL . This language s purpose is to define the structure of an Entity relationship diagram . Language Class declarations Interface name elements attributes, relationships, methods Element Declarations attributes type name relationships rangetype name Example Type Date Tuple year, day, month Type year, day, month integer Class Manager attributes id string unique name string phone string set employees Tuple Employee , Start Date Date Class Employee attributes id string unique name string Start Date Date manager Manager See also ODMG Object Data Management Group OQL Object Query Language Category Object oriented programming Category Data modeling Compu lang stub ja pl Object Definition Language ... more details
Group ODMG with the Object Query Language , OQL. Access to data can be faster because Join SQL joins ... as Object Query Language OQL . ref R. G. G. Cattell, Douglas K. Barry, Mark Berler, Jeff Eastman ... Standard ODMG 3.0. Morgan Kaufman, San Francisco, CA, 2000. ref OQL supports all the mandatory features .... OQL is a very efficient way of expressing object queries, it keeps object s integrity by using objects implemented methods, rather than its own operations. OQL can also be embedded in other languages like C , Java programming language Java ,... OQL is a functional expression oriented language, in which each query is a typed expression type can be atomic object,collection object, or literal . OQL .... Polymorphism OQL supports the polymorphism feature of the object oriented programming.The various ... more details
Infobox programming language logo File dotql.png name .QL age number paradigm multi paradigm programming language multi paradigm , logic programming language logic paradigm , object oriented programming language object oriented paradigm year 2007 developer Semmle typing static typing static , strong typing strong implementations SemmleCode influenced by Datalog .QL pronounced dot cue el is an object oriented query language used to retrieve data from relational database management system s. It is reminiscent of the standard query language SQL and the object oriented programming language Java programming language Java . .QL is an object oriented variant of a logic programming language known in the databases community as Datalog . Hierarchical data can therefore be naturally queried in .QL in a recursive manner. Queries written in .QL are optimised, compiled into SQL and can then be executed on any major relational database management system. .QL query language is being used in SemmleCode to query a relational representation of Java programs. .QL is developed at Semmle Limited and is based on the company s proprietary technology. Language Features .QL has several language features to make queries concise, intuitive and reusable Extensible type hierarchy Methods and predicates Definition before use Example query The sample query below illustrates use of .QL to query a Java program. This is how one would select all classes that contain more than ten public methods from Class c, int numofm where numofm count Method m m.getDeclaringType c and m.hasModifier public and numofm 10 select c.getPackage , c, numofm In fact, this query selects not only all classes with more than ten public methods, but also their corresponding packages and the number of methods each class has. See also SQL Structured Query Language OQL Object Query Language Datalog logic programming language SemmleCode Software testing tool that uses .QL language References Herv Gallaire and Jack Minker. Logic an ... more details
Infobox Radio Station image Image koqllogo.jpg name KOQL city Ashland, Missouri area Columbia, Missouri Columbia and Vicinity branding Q 106.1 slogan The Hit Music Channel airdate 2001 frequency 106.1 megahertz MHz format Contemporary Hit Radio erp 69,000 watt s class C1 owner Cumulus Media licensee Cumulus Licensing, LLC website http www.q1061.com q1061.com sister stations KBBM , KBXR , KFRU , KJMO , KLIK , KPLA KOQL Q 106.1 is a Top 40 formatted station owned by Cumulus Media . The station broadcasts from Columbia, Missouri , with an ERP of 69,000 kW. The station serves Central Missouri . Its transmitter is located about 20 miles west of Jefferson City, Missouri Jefferson City . The station uses the following slogans Your 20 in a row hit music channel All the hits FCC Violation On March 21, 2003, from 8 10 a.m. to 8 15 a.m., former morning show hosts Cosmo & JC aired a prank phone call between the radio station and Life Crisis Services, a gambling addiction hot line. The FCC complaint stated that the radio station personality pretended to have a legitimate gambling problem. Once the representative from Life Crisis realized it was a prank phone call, she hung up. The station did not inform the hot line the call was for broadcast, which is a violation of Federal Communication Commission FCC law Section 73.1206. On April 4, 2003, Mid Missouri Broadcasting made an official on air apology to Life Crisis and provided a link on its website for its services, but even so, on November 23, 2004, the FCC fined Mid Missouri Broadcasting 4000. Mid Missouri Broadcasting later sold the station along with others to Cumulus Media . Notes div style font size 90 references div External links http www.q1061.com Q 106.1 Official Site FM station data KOQL Columbia MO Radio Cumulus Media Contemporary Hit Radio Stations in Missouri coord 38.750 N 92.559 W type landmark region US source FCC display title Category Radio stations in Missouri OQL Category Contemporary hit radio stations in th ... more details
ODABA is a terminology oriented database management system, which is a conceptual extension of an object oriented database system, and implements concepts defined in a terminology model ref cite conference url http www.odaba.com content downloads documentation P2 TerminologyModel v1.pdf title A terminology model approach for defining and managing statistical metadata first R. last Karge month April year 2005 conference Eighth Open Forum on Metadata Registries conferenceurl www.berlinopenforum.de location Berlin format pdf ref . ODABA supports typical standards and technologies for object oriented databases , but also terminology oriented database extensions. ODABA also behaves like an object relational database management system, i.e. data is seen as being stored in a database rather than accessing persistent objects in a programming environment. ODABA supports active data link ref http www.odaba.com content downloads documentation 1.7 ActiveDataLink.pdf Active Data Link ref ADL and provides an ADL based GUI frame work. Features Database access is supported via an application program interface for C or .NET programming languages and via the ODABA Script Interface ref http www.odaba.com content downloads documentation 4.4 OSI.pdf ODABA Script Interface ref OSI . Object Definition Language ODL and Object Query Language OQL provided with OSI are ODMG 3.0 ref Cite book last Cattell first R.J.J. coauthor D.K. Barry title The Object Data Standard ODMG 3.0 publisher Morgan Kaufmann Publishers year 2000 isbn 1 55860 647 5 ref conform. Beside standard models object model , functional model and dynamic model , ODABA supports a documentation model and an administration model. In order to be terminology model compliant, several conceptual extensions are supported as set relations, multilingual attributes, weak typed collections or hierarchical enumeration s classifications . ODABA supports semi automatic conversion from terminology model s to object model s and schema conversio ... more details
, JDOQL , EJBQL and OQL . In C Versant provides VQL and OQL , with C Sharp programming language C support for VQL , OQL and LINQ . VOD will do optimization of query execution based on available attribute ... more details
as vendor lock in . OQL for the Object model Main OQL An Object database Object model language standard ... like JDOQL and EJB QL , though they cannot be considered as different flavors of OQL. XQuery ... more details
In use See also Jetstar destinations Infobox aviation name Qantas destinations image image Qantas A380 800 VH OQL SIN 2012 4 1.png caption A Qantas Airbus A380 800 on approach to Singapore Changi Airport in startdate 2012 4 . Following is a list of destinations Qantas flies to as part of its scheduled services, As of 2012 4 lc y . ref cite web title Qantas Worldwide Timetable Effective date 2012 4 16 spaced ndash date 2012 5 18 work Qantas Airways Limited url http www.qantas.com.au flightinfo qf pdfTimetable.pdf date date 2012 4 16 accessdate date 2012 4 18 ref It also includes destinations served by Qantas subsidiaries Jetstar and QantasLink . Terminated destinations are also listed. List class wikitable bgcolor FFE6BD width 20pt align center sup sup Airline hub Hub bgcolor DDFFDD width 20pt align center sup sup Secondary hub bgcolor D0E7FF width 20pt align center sup sup Focus city bgcolor FFFF99 width 20pt align center Future destination bgcolor DCDCDC width 20pt align center sup sup Terminated destination File A380 Qantas LHR May2011.jpg thumb A Qantas Airbus A380 at Heathrow Airport , London , United Kingdom . 2011 inc transport class wikitable sortable toccolors style background color E8000D color white City style background color E8000D color white Country style background color E8000D color white width 50px IATA style background color E8000D color white width 50px ICAO style background color E8000D color white Airport style background color E8000D color white class unsortable Refs bgcolor DCDCDC Acapulco MEX align center ACA align center MMAA bgcolor DCDCDC Acapulco International Airport sup sup align center ref name FI1972 38 cite journal title World Airlines spaced ndash Qantas Airways Ltd journal Flight International date date 1972 5 18 pages 38 format pdf url http www.flightglobal.com pdfarchive view 1972 1972 20 201298.html accessdate date 2011 8 22 ref Adelaide AUS align center ADL align center YPAD bgcolor DDFFDD Adelaide Airport sup sup align center ... more details
Encyclopedia
top
