|
|
|
|
|
|
by osigurdson
2148 days ago
|
|
|
In some cases it is difficult to define the table columns up front. Instead, a few tables: Object, Property, Time and Value (example below) are defined which make it possible to create new items on the fly. This works reasonably well up to a few billion records in the value table. However it does end up taking a lot of space (covering indexes/requisite memory are required for performance). It would be great to see a Postgres compatible solution that solves this problem in a more optimal way than a stock RDMS. Object
objectId
objectName
other... Property
propertyId
objectId FK
propertyName
other... Time
timeId
time
other.. Value
timeId FK
propertyId FK
value |
|
|