Database model

From Wikipedia, the free encyclopedia

Database models
Common models Hierarchical Network Relational Object-relational Object
Other models Associative Concept-oriented Multi-dimensional Star schema

A database model is a theory or specification describing how a database is structured and used. Several such models have been suggested.

Common models include:

• Hierarchical model
• Network model
• Relational model
• Object-Relational model
• Object model

Other models include:

• Associative
• Concept-oriented
• Entity-Attribute-Value
• Multi-dimensional model
• Semi-structured
• Star schema

Topics in database management systems (DBMS) ( view • talk • edit )

Concepts Database | Database model | Relational database | Relational model | Relational algebra | Primary key - Foreign key - Surrogate key - Superkey Database normalization | Referential integrity | Relational DBMS | Distributed DBMS | ACID Objects Trigger | View | Table | Cursor | Log | Transaction | Index | Stored procedure | Partition Topics in SQL Select | Insert | Update | Merge | Delete | Join | Union | Create | Drop Comparison of syntax

Implementations of database management systems

Types of implementations Relational | Flat file | Deductive | Dimensional | Hierarchical | Object oriented | Temporal Products Caché | db4o | dBASE | Firebird | Helix database | DB2 | Informix | Ingres | InterBase | Microsoft SQL Server | MySQL | OpenLink Virtuoso | Oracle | PostgreSQL | SQLite | Sybase IQ | Sybase | Teradata | Visual FoxPro | Comparison - relational | Comparison - object-relational Components Query language | Query optimizer | Query plan | ODBC | JDBC Lists List of object-oriented database management systems List of relational database management systems