entities - What's the best way to store custom objects in relational database? -


I have the properties of my objects Objects can change their structure: Assets can be added / removed / changed objects Can be dropped completely, call the object's metadata (description, classes, call them as you want).

The database should store the object schema and examples of these objects.

What is the best way?

  1. Store object schemas in some tables: Schema Normal data, schema properties, possible attribute types store examples located in your tables: Data, some tables - to store example properties from each type of potential properties type table. And so on.
  2. Store in Object Schema such as P1, but store examples in a table like XML files: with a table and example table XML for general example information.

Please ask me why do I need this? Just custom items need to be stored and DB should work fast :)

Serialize In Java, literally, serialize in python, pickle in other languages, use whatever they get. Store the results in a blanket column, go out for beer.


Comments