User:SqlPac/databases

From Wikipedia, the free encyclopedia

[edit] Modified Database Template

Rearranging the "Implementations of database management systems" section.

Topics in database management systems (DBMS) ( view • talk • edit )
Image:concepts_db1.png

Database • Database model • Relational database • Relational model • Relational algebra • Relational calculus • Primary key, Foreign key, Surrogate key, Superkey, Candidate key • Database normalization • Referential integrity • Relational DBMS • Distributed DBMS • ACID • Null
Image:objects_db1.png

Trigger • View • Table • Cursor • Log • Transaction • Index • Stored procedure • Partition

 Image:topics_sql_db1.png

Select • Insert • Update • Merge • Delete • Join • Union • Create • Drop
Implementations of database management systems
Image:implementation_types_db1.png

Relational • Flat file • Deductive • Dimensional • Hierarchical • Object oriented • Temporal • XML data stores
Image:components_db1.png

Query language • Query optimizer • Query plan • ODBC • JDBC

 Image:database_products_db1.png

Object-oriented (comparison) • Relational (comparison)