Database optimization orders

by

This is not just about users (and their addresses) but also about prices and other information about products you are selling, that can change after the order has been placed, yet the order itself must remain intact.

Generally, there are 2 approaches to this:

  1. Copy everything you need in the order (and its items). Even if the “master” data changes, you still have a copy within the order that you can use.
  2. “Version” or “historize” the whole database, similar to this.

(1) is the more “practical” approach, but can lead to data redundancies (e.g. when address doesn’t change, you are nonetheless making separate copies of it).

(2) is the more “purist” approach, but may require more JOINing and generally be more complex.

More Related Contents:

  1. What’s the difference between identifying and non-identifying relationships?
  2. Can I have multiple primary keys in a single table?
  3. What’s wrong with foreign keys?
  4. What are database normal forms and can you give examples? [closed]
  5. Difference between scaling horizontally and vertically for databases [closed]
  6. NoSql vs Relational database
  7. Multiple schemas versus enormous tables [closed]
  8. Best practices for storing postal addresses in a database (RDBMS)?
  9. Techniques for database inheritance?
  10. What is the most efficient way to store tags in a database?
  11. Microservices with shared database? using multiple ORM’s? [closed]
  12. Why use a 1-to-1 relationship in database design?
  13. What is the optimal length for an email address in a database?
  14. What are the advantages of using a single database for EACH client?
  15. How should international geographical addresses be stored in a relational database?
  16. Still Confused About Identifying vs. Non-Identifying Relationships
  17. Which is a good design for a database table that can be owned by two different resources, and therefore needs two different foreign keys? [closed]
  18. What’s wrong with nullable columns in composite primary keys?
  19. Ideas on database design for capturing audit trails [closed]
  20. Alternatives to Entity-Attribute-Value (EAV)?
  21. Is it better to use multiple databases with one schema each, or one database with multiple schemas? [closed]
  22. Is it a good idea to use an integer column for storing US ZIP codes in a database?
  23. Versioning Database Persisted Objects, How would you? [closed]
  24. Best design for a changelog / auditing database table? [closed]
  25. What’s the better database design: more tables or more columns?
  26. Should OLAP databases be denormalized for read performance? [closed]
  27. Best beginner resources for understanding the EAV database model? [closed]
  28. Derived account balance vs stored account balance for a simple bank account?
  29. In a StackOverflow clone, what relationship should a Comments table have to Questions and Answers?
  30. uncertainty in developing a database model

Leave a Comment