Database - Model

Model

• relational model
• the hierarchical model
• and network model.
• object-oriented databases. Object-Relation type-Object model is based on the assumption that any fact can be expressed in the form of one or more binary relationships. The model is used in Object Role Modeling (ORM), RDF/Notation 3 (N3) and in Gellish English.

Articles Related

List

Types of databases:

• column-family stores (Hbase, BigTable, Cassandra, …)
• key value stores (Redis, Oracle NoSQL, Amazon DynamoDB, …)
• document databases (MongoDB, …)
• graph databases (Neo4j, …)

Type

• Distributed Graph & document (OrientDB, …)
• Document (Couchbase, …)
• Key/value : Riak
• Odbms (db4o, ….)
• XML (Sedna, …)
• RDF (Sesame, …)
• Clustered RDBMS (Cubrid, …)

Data Structure

Database representation:

• Parents, siblings, and children (Tree, Xml)
• Rows and Columns (Relational Database)
• Records and Pointers (Network Database)
• Nodes and Edges

Type of Database

Relational Database

(Relation|Table) - Tabular data

Multidimensional Database (Olap/Molap Server)

Multidimensional databases, generally smaller and minder scalable than relational databases, offer sophisticated analytic capabilities. By integrating data from a relational database in an Multidimensional database, you can leverage the scalability of the relational database with the analytic power of the multidimensional database.

• The Multidimensional Database
  • Oracle Olap
  • Oracle Hyperion - Essbase

Desktop Databases

• Excel
• OpenOffice