Introduction to QUEL
- QUEL stands for Query Language.
- It is a data definition and data manipulation for INGRES.
- INGRES stands for Interactive Graphics and Retrieval System.
- INGRES is a relational database management system developed by Michael Stonebraker.
- QUEL does not support relational algebraic operations such as intersection, minus or union.
- It is based on tuple calculus and does not support nested sub queries.
Data Definition in QUEL
Following are the data definition statements used in QUEL,1. CREATE
2. RANGE
3. INDEX
4. DESTROY
5. MODIFY
| Statements | Description | Syntax |
|---|---|---|
| CREATE | It is used to create tables or relations. | CREATE <table-name> <list-of-column-name> |
| RANGE | It allows to declare a range variable and restricts to assume the values that are rows from the specified table. Row variables are called Range variables in QUEL. | RANGE OF <variable-name> IS <relation-name> |
| INDEX | It is used to specify the name of the secondary index to be built and the columns in the table on which the index is to be created. | INDEX ON <table-name> IS <index-name> (column-name [, column-name, ...]) |
| DESTROY | It is used to eliminate a table, index or view. | DESTROY name [, name, ...] |
| MODIFY | It is used to modify the structure of a table. The storage structure supported by INGRES are B-tree, hash, ISAM and heap. The storage structure will be modified from the current one to the one specified in the statement. | MODIFY <table-name> TO <storage-structure> ON <column-name> |