1
|
Query languages are computer languages used to make queries into databases and information systems.
Broadly, query languages can be classified according to whether they are database query languages or information retrieval query languages. Examples include:
| Database management systems | |
|---|---|
| Database models · Database normalization · Database storage · Distributed DBMS · Referential integrity · Relational algebra · Relational calculus · Relational database · Relational DBMS · Relational model · Object-relational database · Transaction processing | |
| Concepts | Database · ACID · Null · Candidate key · Foreign key · Primary key · Superkey · Surrogate key |
| Objects | Trigger · View · Table · Cursor · Log · Transaction · Index · Stored procedure · Partition |
| SQL | Select · Insert · Update · Merge · Delete · Join · Union · Create · Drop · Begin work · Commit · Rollback · Truncate · Alter |
| Implementations | Relational · Flat file · Deductive · Dimensional · Hierarchical · Network · Document-oriented · Object-oriented · Object-relational · Temporal · XML data stores |
| Components | Concurrency control · Data dictionary · JDBC · ODBC · Query language · Query optimizer · Query plan |
| Database products: Object-oriented (comparison) · Relational (comparison) · Document-oriented | |
| Types of Computer languages |
|---|
| Programming · Specification · Query · Markup · Transformation · Template processing · Hardware description · Stylesheet · Data modeling |
This article is licensed under the GNU Free Documentation License. It uses material from Wikipedia