Misplaced Pages

Template:Databases

Article snapshot taken from Wikipedia with creative commons attribution-sharealike license. Give it a read and then ask your questions in the chat. We can research this topic together.

This is an old revision of this page, as edited by Fred Bradstadt (talk | contribs) at 07:46, 18 October 2007 (code cleanup). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Revision as of 07:46, 18 October 2007 by Fred Bradstadt (talk | contribs) (code cleanup)(diff) ← Previous revision | Latest revision (diff) | Newer revision → (diff)
Topics in database management systems (DBMS)

Major subtopics
Database models • Database normalization • Database storage • Distributed DBMS • Referential integrity • Relational algebra • Relational calculus • Relational database • Relational DBMS • Relational model • Transaction processing

Concepts
Database • ACID • Null • Candidate key • Foreign key • Primary key • Superkey • Surrogate key

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

Topics in SQL
Select • Insert • Update • Merge • Delete • Join • Union • Create • Drop
Begin work • Commit • Rollback • Truncate • Alter

Implementations of database management systems

Types of implementations
Relational • Flat file • Deductive • Dimensional • Hierarchical • Object oriented • Object relational • Temporal • XML data stores

Database products
Object-oriented (comparison) • Relational (comparison)

Components
Concurrency control • Query language • Query optimizer • Query plan • ODBC • JDBC

Categories: