Property Table

Created on Feb. 23, 2013, 12:54 p.m. by Hevok & updated by Hevok on May 2, 2013, 5:20 p.m.

Property Table aggregate similar properties into Subjects. For all possible Property there is another Column. In there Clustering of all similar subjects is not a trivial task to do and is most time performed by hand. If there are multivalued Properties it becomes difficult as it results in several rows with the same item or Entity which makes the complexity even worse.

  • Combining all (or some) Properties of similar Subjects in n-ary Tables
  • Use ID based encoding for efficiency.
  • Pros
    • Fewer joins
    • If the data is structured, we have a relational DB
  • Cons
    • Potentially a lot of NULLS
    • Clustering is not trivial
    • Multi-value Properties are complicated

Tags: architecture, storage, database, format, data
Categories: Tutorial
Parent: Storing RDF Data

Update entry (Admin) | See changes

Comment on This Data Unit