Explain object query language (OQL) with suitable example.

-

Object query language (OQL) 

OQL is an SQL-like declarative language that provides a rich environment for efficient querying of database objects, including high-level primitives for object sets and structures.OQL also includes object extensions for object identity, complex objects, path expressions, operation invocation, and inheritance. OQL's queries can invoke operations in ODMG language bindings, and OQL may be embedded in an ODMG language binding.

The object query language OQL is the query language proposed for the ODMG object model. It is designed to work closely with the programming languages for which an ODMG binding is defined, such as C++, Smalltalk, and Java. Hence, an OQL query embedded into one of these programming languages can return objects that match the type system of that language. Additionally, the implementations of class operations in an ODMG schema can have their code written in these programming languages. The OQL syntax for queries is similar to the syntax of the relational standard query language SQL, with additional features for ODMG concepts, such as object identity, complex objects, operations, inheritance, polymorphism, and relationships.

Below is an example of an OQL query

SELECT  c.address

FROM    Persons p,

p.children c

WHERE p.address.street="Main Street" AND

COUNT (p.children) >= 2 AND

c.address.city != p.address.city;


SELECT=> can construct new objects and arbitrary structures.

FROM=> tuple variables can range over any collection; may have subqueries.

WHERE=> pretty much the same as in SQL.



Comments

Post a Comment

Popular posts from this blog

Explain CORBA architecture briefly.

-
Image
  ARCHITECTURE OF CORBA The major components that make up the CORBA architecture include the: Interface Definition Language (IDL), Object Request Broker (ORB), The Portable Object Adaptor (POA), Naming Service, and Inter-ORB Protocol (IIOP). Interface Definition languages: CORBA uses the concept of an interface Definition language to implement the services. IDL is a neutral programming language method of defining how a service is implemented. The syntax of this language is independent of any programming language. IDL is used to define an interface, which describes the methods that are available and the parameters that are required when a call is made for a remote object. Object Request Broker (ORB): The foundation of CORBA architecture is based on the Object Request Broker (ORB). The ORB is prime mechanism that acts as a middleware between the client and the server. It provides a heterogeneous environment in which a client can remotely communicate with the server irrespective of t...
Read more

Explain the architecture of data mining system with block diagram./Describe the Data Mining Architecture with figure.

-
Image
Data Mining Architecture The process of extracting information to identify patterns, trends, and useful data that would allow the business to take the data-driven decision from huge sets of data is called Data Mining. The data mining process involves several components, and these components constitute a data mining system architecture. The significant components of data mining systems are a data source, data mining engine, data warehouse server, the pattern evaluation module, graphical user interface, and knowledge base. The major component of a data mining system architecture is as follows:- Database, Data Warehouse, or Other Information Repository:  This is one or a set of databases, data warehouses, spreadsheets, or other kinds of information repositories. Data cleaning and data integration techniques may be performed on the data. Database or Data Warehouse Server: It fetches the data as per the users’ requirement which one needs for data mining task. Knowledge Base:  ...
Read more

Describe management functions and explain how each of them is interrelated./ Four key functions (planning, organizing, directing and controlling) make up the process of management. It is possible that the controlling function can affect the organizing function and organizing function can affect the leading functions? Explain.

-
Image
   Functions/Process of Management The management system is a system or process of interrelated and sequential components or function of management. The function of management have been specified and defined variously by different authors. Fayol has specified planning, organizing, commanding, coordinating and controlling as the function of management. Likewise, according to Koontz and O'donnell, planning, organizing, developing, coordinating and staffing as the functions of management. According to Linder Urbick, forecasting, planning, organizing, commanding, coordinating and controlling as the function of management. Luther Gulick has summarized the function of management as POSDCORB where P = Planning, O = Organizing, S = CO = Coordinating, R = Reporting and B = Staffing, D = Directing, Budgeting. In general, the following are the functions of management. 1. Planning Planning is the basic function of management. It is outlining the future course of action and decides in adva...
Read more