Questions tagged [data-modeling]
Elaborating passive data structures based on the analysis of data requirements for the purpose of designing and implementing standardised data formats, databases and data processing systems.
111
questions
2
votes
4
answers
1k
views
How would you model an objects representing different phases of an entity life cycle?
I believe the scenario is common mostly in business workflows - for example: loan management
the process starts with a loan application, then there's the loan offer, the 'live' loan, and maybe also ...
3
votes
1
answer
182
views
Algorithm/Strategy or Data structure to capture priorities sub priorities in an app
I am working on a CMS that is starting to evolve a bit.
We started off with content that had the following priorities ( columnn in the db on the content table): HIGH MED LOW. Data was fetched by ...
3
votes
2
answers
459
views
What's a good format for documenting hundreds of data feeds?
Several governments are starting to publish open data: datasets generated by the goverment, made freely available for citizens to use for value-added app development, analysis, and feedback. For ...
2
votes
5
answers
8k
views
Is it Considered Good SQL practice to use GUID to link multiple tables to same Id field?
I want to link several tables to a many-to-many(m2m) table.
One table would be called location and this table would always be on one side of the m2m table.
But I will have a list of several tables ...
-1
votes
3
answers
1k
views
How to show or direct a business analyst to do data modelling? [closed]
Our business analysts pushed hard to collect data through a spreadsheet. I am the programmer responsible for importing that data. Usually when they push hard for something like this, I never know ...
3
votes
5
answers
611
views
In a "Revisional Data Model," where does code that preserves a previous record's state belong?
When I say "Revisional Data Model", I mean a data model where information is never lost: Deletes never destroy any rows, and updates always cause an insert somewhere else to preserve a row's previous ...