Questions tagged [normalization]
Normalization refers to transformations which aim to reduce variation of various types of data and thereby allow more consistent processing, searching, sorting, comparison, etc. Courtesy of [SO Normalization tag](http://stackoverflow.com/tags/normalization/info).
61 questions
-1
votes
3
answers
451
views
Are there existing term(s) for a 1-1 child-parent table anti-pattern?
NOTE: Please don't respond by telling me that I probably don't understand what I am looking at. You can't possibly know that and it's wrong. Just don't answer if that's all you have to say.
I'm ...
1
vote
1
answer
131
views
Aggregating embedded documents in MongoDB
I'm designing a mongo database and I have a dilemma if I should go for normalization.
Let's say that there is a database with images and descriptions. Many alternative descriptions can belong to one ...
- 127
4
votes
2
answers
1k
views
Thoughts on database denormalization via short-circuit key
In the simplified database schema depicted below, I'm considering denormalizing by adding a short-circuit key (EventId, relation shown in red) on Appointment.
One advantage is not needing a join to ...
- 238
52
votes
6
answers
12k
views
Is denormalising a database for speed an anti-pattern?
I have a database with a 1:m relationship.
I have to display a list of parents to the user rapidly on a home screen at startup. The parent shows a single piece of information that is a sum of a ...
- 631
-2
votes
1
answer
89
views
How to set only one foreign key for every record where the table has 2 foreign keys?
I know that this question has been asked before and is the same or at least almost the same but I just want to know: Is it the only method or is there any other way to do it?
I have these tables: ...
0
votes
1
answer
631
views
Is it ok to have 3 foreign keys in a table from one only table?
So... Le's say I have 3 tables named:
Member
Bus
AutorizeMember
ID Member is referenced to Bus and ID Bus is referenced to AutorizeMember which is also referenced to Member 3 times. Thats is because ...
4
votes
5
answers
3k
views
What is the normal form of JSON?
This is going to sound like a trivial question, but I like to think it's actually a deep one. The simple quesiton is, "What is the normal form of a typical JSON object?" For reference, I ...
- 213
2
votes
3
answers
281
views
What type of normalization is it if I "flip" columns to rows
Suppose I have this:
ID
A_Type
B_Type
C_Type
1
Y
N
N
2
N
Y
Y
And I "flip" those columns into this:
ID
Type
Value
1
A
Y
1
B
N
1
C
N
2
A
N
2
B
Y
2
C
Y
I know this is fine to do. I know it ...
- 213
2
votes
5
answers
900
views
Applying Edgar Codd’s 1NF normalization procedure
In 1970, Edgar Codd published his landmark paper ‘A Relational Model of Data for Large Shared Data Banks’ where he defined relational databases as well as their normalization to first normal form (1NF)...
- 612
-1
votes
1
answer
65
views
Equivalent attributes and normal forms
A relation R(A,B,C,D) is given.
C and D are equivalent (C is the course ID and D is the course name, one implies the other).
C and D are prime attributes.
Does that violate the requirement of 1NF ...
- 137
1
vote
1
answer
126
views
Should I perform some minor denormalization to save myself several queries in the future?
I'm in charge of designing the entire backend for the REST API of an application that works more or less like an online browser game (think OGAME, Travian, and the likes). In this game, players are ...
- 11
-2
votes
1
answer
59
views
Simple OO/normalization question - common fields in new table/separate object?
I am working on an app and creating models now. I think this is a basic 1N normalization question but am not sure. Should I break location/address out as a separate table?
Let's say I have Parents ...
- 9
1
vote
1
answer
184
views
Denormalized history (ledger) table with tax - yes or no?
We are designing a system, in which we need to store amount of SalesTax applied as well as Tax percentage value. We decided that we will keep tax value in separate table (simplified example):
Taxes ...
-3
votes
2
answers
175
views
How to structure a database where a record can be a child of a parent or a grand parent record
I have these concepts for a database application: Session, Subsession and File
A session can have multiple files
A session can have multiple subsessions
A subsession can have multiple files
A session ...
- 175
1
vote
1
answer
1k
views
How/when to normalize during ETL?
Let's say you're loading a denormalized flat file of purchase transactions that looks like this:
| location_name | location_zip | product | product_price |
|---------------|--------------|---------|--...
- 11