sign in
 
   
 
 
 
  QUERY LANGUAGES  
   
 

A query language is a language in which a user requests information from the database. Query languages can be categorized into

• Procedural language
• Non-procedural language

In a procedural language, the user instructs the system to perform a sequence of operations on the database to compute the desired result. That is we need to specify what is required and how to get it.

But in non-procedural language, the user describes the desired information without giving a specific procedure for obtaining that information.

 
 
 
  The Relational Algebra:

The relational algebra is a procedural language. It consists of a set of basic operations used to manipulate the data in relational model by taking one or two relations as input and produce a new relation as their result.

The Fundamental Operations in the relational algebra:
• Select
• Project
• Union
• Set Difference
• Cartesian product
• Rename

Other operations:
• Set intersection
• Natural Join
• Division
• Assignment

Extended Operations:
• Generalized Projection
• Aggregate Functions
• Outer Join