Jump to content

User:SqlPac/databases

From Wikipedia, the free encyclopedia

Modified Database Template

[edit]

Rearranging the "Implementations of database management systems" section.

Topics in database management systems (DBMS) ()

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

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

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

Implementations of database management systems

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

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

Object-oriented (comparison) • Relational (comparison)