Join the social network of Tech Nerds, increase skill rank, get work, manage projects...

• # Query Languages

• 0
• 0
• 0
• 0
• 0
• 0
• 0
• 0
• 384
Comment on it

1. QUEL

It is the query language in the system INGRES. It is based on relational calculus. The fundamental aspect of the query languages based on the relational calculus is tuple variable ( which is a variable that "ranges over" some named relation).

e.g. query "Get  supplier number for supplier in London" can be expressed in QUEL as:

``````                                RANGE of SX is S
RETRIEVE(SE. S#) where SX .CITY='LONDON'.``````

The tuple here is SX that ranges over relation S.

2.SEQUEL

In SEQUEL, the expression following WHERE can be any expression involving the attribute of the relation following FROM, arithmetic comparison and operations.

Boolean connectives (AND, OR NOT) set operations (UNION,INTERSECT,MINUS), set membership (X IN S, where S is a set or equivalently S CONTAINS X)

and negation of set membership (X NOT IN S OR S DOES NOT CONTAIN X).

When SEQUEL applies a mapping it does not eliminate duplicate unless told to do so by the keyword UNIQUE. In SEQUEL assignment is indicated by preceding a query by

``                                    ASSIGN TO R``

To assign the result to relation R, any relational algebra expression in SEQUEL can be evaluated by applying one operator at a time and thereby computing each subexpression,  hence SEQUEL is complete.

3.QBE QUERY

QBE is specifically designed for use with a visual display terminal. QBE has two-dimensional syntax since operation are specified in tabular form.

The basic idea is that the user formulates the query by entering an example of a possible answer in appropriate place in an empty table.

e.g. consider the query 'Get supplier numbers for supplier in Paris'.  First by pressing a certain function key on the terminal, the user can have a blank "skeleton" table displaced on the screen. Then the user enters S as the table-name gets QBE to respond by filling in the column names . The query is expressed as

 S S# SNAME STATUS CITY P.S7 PARIS

The "P" stands for "print" , indicating the target of the query. S7 is an "example element" , i.e. an example of a possible answer to the query (indicated by underlining). PARIS is a "constant element". QBE automatically eliminates redundant duplicates from a query result. To suppress each elimination the user can specify the keyword "ALL".

4. SQL

This  language consist of commands, each command  has an operational part and condition part.  Operation is executed through a search in all relations defined in relational database. Required solution (list of data) is returned by the command. The data listed in solution satisfies all condition given in that command.

SYSTEM R SQL is now the standard language for commercial relational DBMS. A joint effort by ANSI and ISO has led to a standard version of SQL,called SQL-86 or SQL1. A revised and much expanded standard called SQL@ has subsequently been developed. Plans are already well underway called SQL2 has subsequently been developed. Plans are already well underway for SQL2  has subseqently been developed. Plans are already well underway for SQL3, which will further extend SQL with object-oriented and other recent database concepts.

## 0 Comment(s)

OR
OR
Register

OR
Fill out the form below and instructions to reset your password will be emailed to you:

• Hire
• Post Projects

### Post Projects

• All at 0 Cost ....
• Post Tech Job
• Select Best Bidder
• Track the Project
• Approve Work and Pay safely
• Browse Nerds
• Work
• Find Projects Find Projects
• UI Design and UX
• Software Engineering
View more...
View less...
• Marketing
• General
• Manage
• Company Company

### Manage Company

• All at 0 Cost ....
• Manage Company and Employee Profiles
• Company wide Employee Productivity Reports
• Knowledge Sharing and Collaboration Tools
• Get Sales Lead and Bid for Tech Projects
• Send Invoices and Receive Payment Safely
• Learn
• Nerd Digest Nerd Digest
• UI Design and UX
• Software Engineering
View more...
View less...
• Marketing
• General
• Tech Q & A Tech Q & A
• UI Design and UX
• Software Engineering
View more...
View less...
• Marketing
• General