Database - Model

Data System Architecture

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.

List

Types of databases:

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.

Desktop Databases

  • Excel
  • OpenOffice





Discover More
Data System Architecture
Database management system (DBMS)

A DBMS is an application that controls: the organization, storage, management, and retrieval of data. A database is a collection of permanently stored data used by an application or enterprise....
Relational Data Model
RDBMS - Relational Model

The relational model for database management: is a set of principles for relational databases formalized by Dr. E.F. Codd in the late 1960s. is a database model based on first-order predicate logic...



Share this page:
Follow us:
Task Runner