User:SqlPac/databases

Modified Database Template

Rearranging the "Implementations of database management systems" section.

align="center" class="toccolours" cellspacing="0" width="90%" style="text-align:center"

colspan="4" style="background-color:#ccccff;"| Topics in database management systems (DBMS) ({{navbar|Databases|plain=1|nodiv=1}})

style="width:28;background-color:#B2B4F4" | Image:concepts_db1.png

|colspan="3" style="font-size:small; border-bottom:1px solid #ccccff;vertical-align:middle;"|

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

style="width:28;background-color:#B2B4F4" | Image:objects_db1.png

|style="font-size:small; width:45%; vertical-align:middle; border-right:1px solid #ccccff"|

Trigger •

View •

Table •

Cursor •

Log •

Transaction •

Index •

Stored procedure •

Partition

|style="width:28;background-color:#B2B4F4" | Image:topics_sql_db1.png

|style="font-size:small; width:45%; vertical-align:middle;"|

Select •

Insert •

Update •

Merge •

Delete •

Join •

Union •

Create •

Drop

colspan="4" style="background-color:#ccccff"| Implementations of database management systems

style="width:28;background-color:#B2B4F4" | Image:implementation_types_db1.png

|colspan="3" style="font-size:small; width:50%; vertical-align:middle; border-bottom:1px solid #ccccff"|

Relational •

Flat file •

Deductive •

Dimensional •

Hierarchical •

Object oriented •

Temporal •

XML data stores

style="width:28;background-color:#B2B4F4" | Image:components_db1.png

|style="font-size:small; width:50%; vertical-align:middle;"|

Query language •

Query optimizer •

Query plan •

ODBC •

JDBC

|style="width:28;background-color:#B2B4F4" | Image:database_products_db1.png

|style="font-size:small; width:50%; vertical-align:middle; border-right:1px solid #ccccff"|

Object-oriented (comparison) •

Relational (comparison)