Subject-oriented data is organized around major areas of an organization, such as customers, sales, or products. Time-variant data stores values from different points or periods in time, allowing users to analyze historical changes and trends.
The Reasoning
A data warehouse combines data from operational databases and other sources for analysis and decision-making. Unlike a transactional database, it is designed mainly for complex queries rather than frequent processing of current transactions.
| Characteristic | Meaning | Example |
|---|---|---|
| Subject-oriented | Data is grouped by a significant subject rather than by the application or process that originally collected it. | A “customer” subject may combine customer details, purchases, returns, and support interactions from several systems. |
| Time-variant | Data is associated with a time period or timestamp and retained over a long period. | A sales warehouse may store monthly revenue from 2022 to 2026, enabling comparison between years. |
Subject orientation gives analysts a unified view of one area. For example, sales data may originally be separated across an online store, physical shops, and a returns system. The warehouse integrates these sources under the subject “sales,” making organization-wide analysis possible.
Time variation means the warehouse preserves historical data rather than continually replacing old values. If a product costs \20$25$ in June, both values may be stored with their relevant dates. This supports trend analysis, forecasting, and comparisons across time.
A common misconception is that “time-variant” means data changes constantly. It actually means that data represents different times; warehouse records are generally non-volatile, so historical entries are stable and are not routinely overwritten.
Exam Technique
For IB Computer Science HL subtopic A3.4, define each characteristic separately and apply it to a concrete example. Do not merely state that a warehouse “stores lots of data”: explain that it organizes integrated data by subject and retains dated historical records for analysis.
