First off, data are currently modelled
Posted: Sun Feb 09, 2025 5:59 am
There are several considerations. and stored within a relational database structure which does not lend itself easily to modelling attachment of attributes. Different modelling solutions were examined and the pros and cons of duplicate tables versus multiple table joins were presented, taking into account the effect on disk space, import time, and ease of data extraction.
Also for consideration is how data import files would be israel rcs data structured to include attributes, whether to allow free text as used in abstracts, descriptions, and titles, whether current datasets would need to be re-created to include attributes, and what would be the effect of including attributes on the data extraction process.
Ultimately, the solution that provides the best data extraction experience for the user is deemed to outweigh considerations of complexity of data loading and cost of storage space, and work continues to find the optimal solution.
Also for consideration is how data import files would be israel rcs data structured to include attributes, whether to allow free text as used in abstracts, descriptions, and titles, whether current datasets would need to be re-created to include attributes, and what would be the effect of including attributes on the data extraction process.
Ultimately, the solution that provides the best data extraction experience for the user is deemed to outweigh considerations of complexity of data loading and cost of storage space, and work continues to find the optimal solution.