Database - Model

> (Data|State) Management and Processing > Database management system (DBMS)

1 - Model

This article is a draft containing a collection of fact.

  • 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.
Advertising

3 - List

Types of databases:

4 - Type

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

5 - Data Structure

Database representation:

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

6 - Type of Database

6.1 - Relational Database

6.2 - 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.

Advertising

6.3 - Desktop Databases

  • Excel
  • OpenOffice
data/database/model.txt · Last modified: 2017/10/23 16:19 by gerardnico