Predicting advantages of database denormalization
I was always taught to strive for the highest Normal Form of database normalization, and we were taught Bernstein’s Synthesis algorithm to achieve 3NF. This is all very well and it feels nice to normalize your database, knowing that fields can be modified while retaining consistency.
What’s a good scheme for multi-user database synchronization?
I’m working on a system to allow multiple users to collaborate on an online project. Everything is fairly straightforward, except for keeping the users in sync. Each user has their own local copy of the project database, which allows them to make changes and test things out, and then send the updates to the central server. But this runs into the classic synchronization question: how do you keep two users from editing the same thing and stomping each other’s work?
Why aren’t Object Oriented databases used as much as Relational Databases? [closed]
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for […]
Will SSD make the distinction between column oriented DB and row oriented DB obsolete? [closed]
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for […]
Do these specific tables need surrogate keys?
Background I have this tables +————————-+ +————————+ |Airport | |Country | |————————-| |————————| |airport_code string (PK) | |country_code string (PK)| |address string | |name string | |name string | +————————+ +————————-+ +————————-+ |Currency | |————————-| |currency_code string (PK)| |name string | +————————-+ airport_code is the IATA (International Air Transport Association ) airport code, you can […]
Do these specific tables need surrogate keys?
Background I have this tables +————————-+ +————————+ |Airport | |Country | |————————-| |————————| |airport_code string (PK) | |country_code string (PK)| |address string | |name string | |name string | +————————+ +————————-+ +————————-+ |Currency | |————————-| |currency_code string (PK)| |name string | +————————-+ airport_code is the IATA (International Air Transport Association ) airport code, you can […]
Do these specific tables need surrogate keys?
Background I have this tables +————————-+ +————————+ |Airport | |Country | |————————-| |————————| |airport_code string (PK) | |country_code string (PK)| |address string | |name string | |name string | +————————+ +————————-+ +————————-+ |Currency | |————————-| |currency_code string (PK)| |name string | +————————-+ airport_code is the IATA (International Air Transport Association ) airport code, you can […]
Do these specific tables need surrogate keys?
Background I have this tables +————————-+ +————————+ |Airport | |Country | |————————-| |————————| |airport_code string (PK) | |country_code string (PK)| |address string | |name string | |name string | +————————+ +————————-+ +————————-+ |Currency | |————————-| |currency_code string (PK)| |name string | +————————-+ airport_code is the IATA (International Air Transport Association ) airport code, you can […]
Why should a column in a Relational Database have a single purpose?
Consider a table in which a column represents a monetary value in some cases and a link to the value of another record in other cases so that we have the following:
Why should a column in a Relational Database have a single purpose?
Consider a table in which a column represents a monetary value in some cases and a link to the value of another record in other cases so that we have the following: