New answers tagged

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 ...
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 ...

Top 50 recent answers are included