The data-modeling tag has no wiki summary.
2
votes
1answer
65 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 ...
0
votes
0answers
59 views
which of the following mongo documents structures are more suited for storing business rules for a loyalty program?
I have been going through MongoDB to evaluate it as an option for storing business rules which are to be applied before we calculate reward for an end-user. The platform in questions is a loyalty ...
3
votes
2answers
86 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 ...
1
vote
5answers
361 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 ...
0
votes
1answer
254 views
What schema documentation tools exist for PostgreSQL [closed]
MySQL has MySQL Workbench for designing and documenting your schema, and generates CREATE and ALTER scripts based on your design. We're looking at migrating to PostgreSQL in the near future, and we ...
4
votes
3answers
146 views
How to architect this simple problem in high level
I need help with setting up the models(associations), on this problem.Write an application which displays these events in descending chronological order, For example, they can choose to see every ...
1
vote
2answers
249 views
How to show or direct a business analyst to do data modelling?
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 ...
