User:Mikeblas/databases
| class="toccolours" style="margin:1em auto; clear:both;width:90%;"
! style="background:#ccccff;" align="center" colspan="2" | Topics in database management systems (DBMS) |
| align="right" style="vertical-align:top;" | Concepts:
| align="left" | 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 |
| align="right" style="vertical-align:top;" | Objects:
| align="left" | Trigger • View • Table • Cursor • Log • Transaction • Index • Stored procedure • Partition |
| align="right" style="vertical-align:top;" | SQL:
| align="left" | Select • Insert • Update • Merge • Delete • Join • Union • Create • Drop |
| align="right" style="vertical-align:top;" | Implementations:
| align="left" | Relational • Flat file • Deductive • Dimensional • Hierarchical • Object oriented • Temporal • XML data stores |
| align="right" style="vertical-align:top;" | Components:
| align="left" | Query language • Query optimizer • Query plan • ODBC • JDBC |
| align="right" style="vertical-align:top;" | Products:
| align="left" | 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 |