New answers tagged database
1
vote
How to avoid data corruption with dual parent/child foreign keys
Foreign key relationships don't have to be single columns, you can have "extra" columns in the relations to enforce your requirement.
Persons table with (PersonId, ...)
PersonEmails table ...
- 10.2k
-1
votes
How to avoid data corruption with dual parent/child foreign keys
Databases are great at capturing the result of some business operation. They store data. They are really good at this. The problem you have pertains to the business operation, not the end result ...
- 32.5k
1
vote
Secondary indexes vs Using elastic search
I was given good advice by an architect, early in my career: design and extra complexity, to improve performance, before you’ve discovered where the actual bottle decks in the system are. Otherwise, ...
- 414
2
votes
Accepted
How can I design a data access layer that connects to two different databases?
Well, we don't know much about your application, its size and requirements in regards to database access. But the usual standard approach I would recommend here is:
Start creating some DBMS ...
- 194k
2
votes
Accepted
Adding new column(s) to DB Table breaks existing queries
This is of-course subjective, and opinions may differ. There is no one size fits all, and what is a good practice for some might not be so for you. But I have attempted to give my input.
It appears ...
- 693
Top 50 recent answers are included