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.
61 questions
-1
votes
3
answers
542
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 ...
- 31.1k
1
vote
1
answer
150
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
104
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
677
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? What is theory that you can't automate normalizing?
What is the normal form of a typical JSON object?
We often need to convert JSON objects to some set of tables. Once they are tables, the tables have measurable normal forms based on all the usual ...
- 213
2
votes
3
answers
314
views
What type of normalization is it if I "flip" columns to rows [closed]
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
973
views
Applying Edgar Codd’s 1NF normalization procedure [closed]
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
75
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
144
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
75
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
197
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
191
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