Data Aggregation Cont'd

  • Aggregated data is not likely to be stored in the same shape as it is in a Rdbms
  • Rdbms more likely to store data in related tables using foreign key relationship, whether enforced or not
  • Aggregating data in ElasticSearch from Rdbms is likely to result in data de-normalization
  • Rdbms likely data model:

  • Movies

AssetId Title ShortSynopsis ...
86c1bba8-d18f-4bbc-9cb4-a90a4220f59c My First Mister Desperate to escape the.. ...
  • Cast Members
MemberId Name ...
b42e5484-e7e1-4eaf-b9a2-b8f25487533b Leelee Sobieski ...
1290de91-2bc3-4b72-9a0d-6fa0e04b44ab Albert Brooks ...
  • Movie Cast Members
AssetId MemberId Role
86c1bba8-d18f-4bbc-9cb4-a90a4220f59c b42e5484-e7e1-4eaf-b9a2-b8f25487533b Cast
86c1bba8-d18f-4bbc-9cb4-a90a4220f59c 1290de91-2bc3-4b72-9a0d-6fa0e04b44ab Cast
  • Document databases such as Couchbase and MongoDb may store data aggregated neatly already

results matching ""

    No results matching ""