Relational Data Modeling - Generic Data Model
Table of Contents
About
The generic data model is a relation data model that represent any object in a database using just four tables.
Articles Related
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) );