Data warehousing refers to

2011

Data warehousing refers to

Answer: C. is related to data miningConcept — what a data warehouse is: a data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data assembled to support…

  1. A.

    storing data offline at a separate site

  2. B.

    backing up data regularly

  3. C.

    is related to data mining

  4. D.

    uses tape as opposed to disk

Attempted by 11 students.

Show answer & explanation

Correct answer: C

Concept — what a data warehouse is: a data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data assembled to support management decision-making (Inmon’s classical definition). Data warehousing is therefore an analytical data-architecture discipline: many operational sources are consolidated and transformed into one historical, query-friendly model that analysis runs over. Nothing in that definition concerns storage media, backup schedules, or the physical site at which bytes are kept.

Application — matching the stem: the stem asks what the term "data warehousing" refers to, so each offered notion must be matched against that analytical purpose. Discovering patterns, associations and predictive models across large volumes of consolidated historical data is precisely the activity called data mining, and a warehouse is the standard substrate over which OLAP and mining workloads run — the warehouse supplies the integrated history, mining supplies the analysis. So the notion to look for among the four offered is the one that names warehousing’s analytical purpose rather than a storage, media or data-protection practice.

Contrast — why the other notions do not define warehousing:

  • "storing data offline at a separate site" describes off-site, offline placement — a disaster-recovery and archival arrangement measured in recovery time. A warehouse is deliberately online and continuously queried by reporting and analysis tools.

  • "backing up data regularly" describes a scheduled point-in-time recovery copy of operational data. A warehouse is a transformed, integrated analytical model with its own schema and history, not a restorable copy of the source system.

  • "uses tape as opposed to disk" names a storage medium. Media choice is an implementation detail, and warehouses are normally built on high-throughput disk or columnar storage precisely because analytical queries need fast random access.

Cross-check: test the four defining properties one at a time — subject-oriented, integrated, time-variant, non-volatile. Not one of them refers to a backup schedule, a remote site, or a tape drive; all four describe organising historical data so that it can be analysed, which is exactly the domain data mining operates in. The definition therefore separates warehousing from every placement, copying or media practice.

Result: the notion that matches data warehousing’s analytical purpose is "is related to data mining", and that is the accepted answer. Note that the option’s wording is loose ("related to" rather than a full definition), but among the four notions offered it is the only one pointing at warehousing’s analytical purpose, and it is the option marked correct in the official UGC NET June 2011 Paper II answer key.

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…