Relational Data Modeling - Generic Data Model

Data System Architecture


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


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