ER Knowledge Graph Grid

Draft Paper: graph_database.pdf 

 An entity-relationship (type) diagram

with an existing association

can be generalized in the following way:

 (TO): Topic / Entity

 [TT]: Topic Type / Entity Type

 {OT}: Occurrence Type / Attribute Type

 <<AT>>: Association Type / Relationship

 <RT>: Role Type / Role

This "typed" hypergraph can be implemented with the following relational database schema and primary keys:

• 1.  TOPIC_TYPE  [ TYPE_ID, TYPE_NAME ]

  2.  OCC_TYPE  [ OCC_TYPE_ID, OCC_TYPE_NAME ]

  3.  ROLE_TYPE  [ ROLE_TYPE_ID, ASSOC_TYPE_ID, ROLE_TYPE_NAME ]

  4.  ASSOC_TYPE  [ ASSOC_TYPE_ID, ASSOC_TYPE_NAME ]

  5.  TOPIC  [ TOPIC_ID, TOPIC_NAME, TYPE_ID ]

  6.  OCC  [ OCC_ID, OCC_TYPE_ID, OCC_VALUE, TOPIC_ID ]

  7.  ASSOC_ROLE  [ ASSOC_ID, TOPIC_ID, ROLE_TYPE_ID ]

  8.  *OCC_BYTES  [ OCC_BYTES_ID, OCC_BVALUE ]               *(for binary data)