Relational Data Modeling - Generic Data Model

Data System Architecture

About

The generic data model is a relation data model that represent any object in a database using just four tables.

Pro/cons

It's really good for the flexibility but not good for the database performance and for the simplicity of the SQL statement.

Data Model

Create table objects ( oid int primary key, name varchar2(255) );

Create table attributes 
( attrId int primary key, attrName varchar2(255), 
datatype varchar2(25) );

Create table object_Attributes 
( oid int, attrId int, value varchar2(4000), 
primary key(oid,attrId) );

Create table Links ( oid1 int, oid2 int, 
primary key (oid1, oid2) );  

Documentation / Reference





Discover More
Datavault
Relational Data Modeling - Data Model

data model in a relational environment The difference between model (ER, Dimensional, Vault) has everything to do with terminology and method. There are two basic types of physical models : (E-R)...



Share this page:
Follow us:
Task Runner