User:SqlPac/databases

From Wikipedia, the free encyclopedia
Jump to: navigation, search

Modified Database Template[edit]

Rearranging the "Implementations of database management systems" section.

Topics in database management systems (DBMS) ( )
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

Objects db1.png

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

Topics sql db1.png

Select • Insert • Update • Merge • Delete • Join • Union • Create • Drop

Implementations of database management systems
Implementation types db1.png

Relational • Flat file • Deductive • Dimensional • Hierarchical • Object oriented • Temporal • XML data stores

Components db1.png

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

Database products db1.png

Object-oriented (comparison) • Relational (comparison)