Object Query Language (OQL)
Filed Under Databases, Language, SQL | Posted on September 14, 2009
Object Query Language (OQL) is a query language standard for object-oriented databases modelled 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 [...]
Object Definition language (ODL)
Filed Under Design, Language | Posted on September 14, 2009
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. – Class Declarations * interface < name > {elements = attributes, relationships,methods } – Element Declarations * [...]
Structured Query Language (SQL)
Filed Under Databases, Language, SQL | Posted on September 9, 2009
The structured query language (SQL) is the language used to query and manipulate information within a SQL Server database. SQL is actually an ISO and ANSI standardised language. However, a lot of RDBMS software use their own proprietary extensions within their own Transact-SQL (T-SQL) variant of SQL. The basic building block of the structured query [...]
Database (DBMS) Languages
Filed Under DDL, DML, Data, Databases, Language, Schemas | Posted on August 6, 2009
Once the design of the database is completed and a DBMS is chosen to implement the database, the next step is to define the conceptual and internal schema for the data and any mappings between the two. The languages that are used to do so are : • Data Definition Language (DDL): To specify the [...]
