For questions about structuring the data within a database. How to lay out tables, whether to use a relational DB or not, etc.
0
votes
2answers
48 views
How should I structure my database to gain maximum efficiently in this scenario?
I'm developing a PHP script that analyzes the web traffic of my clients websites. By placing a link to a javascript on the clients website (think of Google Analyses), my script harvests information ...
1
vote
1answer
96 views
Java Desktop Application For Network users
I'm developing a desktop application using Java. My application will run in a network environment where multiple users will access the same database through the application.
There will be basic CRUD ...
4
votes
3answers
114 views
How to conciliate OOAD and Database Design?
Recently I've studied object oriented analysis and design and I liked a lot about it. In every place I've read people say that the idea is to start with the minimum set of requirements and go ...
0
votes
0answers
17 views
If all variables are a subset of the superkey, is the database design 5NF? [migrated]
I have a table called LogMessages, which has the following columns:
Level
A numeric value which represents Trace, Debug, Info, Warning, Error or Fatal
Time
A UTC time
Message
Foreign key to a ...
0
votes
0answers
39 views
Database model for keeping track of likes/shares/comments on blog posts over time
My goal is to keep track of the popular posts on different blog sites based on social network activity at any given time. The goal is not to simply get the most popular now, but instead find posts ...
0
votes
0answers
7 views
How to manage primary key while updating [closed]
In the following table primaryKeyColumn is primary key.
To maintain the data history I always uses the values with WHERE condition(WHERE StatusColumn=1) And will set the StatusColumn to 0 if the data ...
0
votes
1answer
99 views
Implementing new required feature after software release
Fake Scenario
There is a software that was released 1 year ago. The software is to map and register all kind of animals on our planet. When the software was released, the client only needed to know ...
1
vote
1answer
58 views
Store data for multiple User Type
I am developing an app where four types of user share same module. So is it a good idea to create:
one table and user_type and user_id (something like that)
table prefixes basically 4 diff tables of ...
2
votes
0answers
47 views
Best Way to Handle Meta Information in a SQL Database [duplicate]
I've got a database where I want to store user information and user_meta information.
The reason behind setting it up in this way was because the user_meta side may change over time and I would like ...
0
votes
0answers
57 views
Best way to implement database design for a set of entities
Lets say I have a scenario like so:
I have many claims to get money from another entity and this claim has to go through two gateways. This claim is sent from an origin system and can possibly be ...
7
votes
4answers
340 views
What exactly does it mean that storing “large blobs in the database reduces performance”?
To someone who knows database internals this may be an easy question, but can someone explain in a clear way why storing large blobs (say 400 MB movies) in the database is supposed to decrease ...
9
votes
7answers
60 views
Nested Entities and calculation on leaf entity property - SQL or NoSQL approach
I am working on a hobby project called Menu/Recipe Management.
This is how my entities and their relations look like.
A Nutrient has properties Code and Value
An Ingredient has a collection of ...
0
votes
3answers
107 views
Modeling a Student Application/Committee Relationship
I'm developing an ERD for a graduate student manager program (it's for a university class, so it's a fairly trivial implementation).
In this snippet of the model, I'm trying to work out the ...
1
vote
0answers
25 views
How to validate (and group) User Listings in Marketplace
I am building a hobby marketplace (comic books). Users are able to list comic books they own for trading with other members. The problem I'm running into is that I would like to standardize the ...
15
votes
4answers
1k views
Why many designs ignore normalization in RDBMS?
I got to see many designs that normalization wasn't the first consideration in decision making phase.
In many cases those designs included more than 30 columns, and the main approach was "to put ...
