A company is setting up a new reporting database. They prioritize query speed over concerns about data redundancy. Which database design approach might they consider?
- Denormalization
- Entity-Relationship Modeling
- In-Memory Databases
- Normalization
When query speed is a priority and data redundancy concerns are secondary, a company might consider denormalization. This database design approach involves reducing the number of tables and increasing data redundancy to improve query performance.
Loading...
Related Quiz
- A retail company wants to analyze the past 10 years of transaction data to forecast future sales. They are considering big data solutions due to the volume of data. Which storage and processing model would be most suitable?
- Which term refers to the process of identifying and correcting (or removing) errors and inconsistencies in data?
- One of the methods to increase query performance in columnar databases is by using _______ encoding techniques.
- Which of the following is a primary reason for organizations to use ETL processes?
- One of the challenges in the Extract phase of ETL is dealing with _______ data sources, where data structures may vary.