| Topics in database management systems (DBMS)
|
| Concepts:
|
Database • Database model • Relational database • Relational model • Relational algebra • Primary key, Foreign key, Surrogate key, Superkey, Candidate key • Database normalization • Referential integrity • Relational DBMS • Distributed DBMS • ACID
|
| Objects:
|
Trigger • View • Table • Cursor • Log • Transaction • Index • Stored procedure • Partition
|
| SQL:
|
Select • Insert • Update • Merge • Delete • Join • Union • Create • Drop
|
| Implementations:
|
Relational • Flat file • Deductive • Dimensional • Hierarchical • Object oriented • Temporal • XML data stores
|
| Components:
|
Query language • Query optimizer • Query plan • ODBC • JDBC
|
| Products:
|
Apache Derby • Berkeley DB • Caché • DB2 • DBase • Filemaker Pro • Firebird • H2 • Helix • Informix • Ingres • InterBase • Microsoft Access • Microsoft SQL Server • MySQL • NonStop SQL • OpenLink Virtuoso • OpenOffice.org Base • Oracle • Oracle Rdb • Paradox • Perst • PostgreSQL • SQLite • Sybase IQ • Sybase • Teradata • Visual FoxPro
|