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

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 658
    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)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

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