Which term refers to the fundamental difference in the purpose of an operational database system and a data warehouse?

Which term refers to the fundamental difference in the purpose of an operational database system and a data warehouse?

• A. Structured repository
• B. Subject orientated
• C. Enterprise wide
• D. Time variant

Answer: (B)

The main idea is subject orientation: a data warehouse is built to support analysis by organizing data around major subjects like customers, products, or sales, making it easier to perform cross-subject queries and decision-making. An operational database, by contrast, is designed to support day-to-day transactions for specific applications and processes, so its structure follows these operational needs rather than broad subject areas. This focus on subjects enables analysts to pull together information from across the organization for reporting and insight. So the best term to describe the fundamental purpose difference is subject-oriented. The other terms describe related characteristics—for example, time variant notes that warehouses store historical data, while enterprise-wide and structured are broader properties rather than the core purpose distinction.

The main idea is subject orientation: a data warehouse is built to support analysis by organizing data around major subjects like customers, products, or sales, making it easier to perform cross-subject queries and decision-making. An operational database, by contrast, is designed to support day-to-day transactions for specific applications and processes, so its structure follows these operational needs rather than broad subject areas. This focus on subjects enables analysts to pull together information from across the organization for reporting and insight. So the best term to describe the fundamental purpose difference is subject-oriented. The other terms describe related characteristics—for example, time variant notes that warehouses store historical data, while enterprise-wide and structured are broader properties rather than the core purpose distinction.