>> The data warehouse is an informational environment that provides an integrated and total view of the enterprise Makes the enterpriseâ€™s current and historical information easily available for decision making Makes decision-support transactions possible without hindering operational systems Renders the organizationâ€™s information consistent Presents a flexible and interactive source of strategic information OR a warehouse is a Subject oriented Integrated Time variant Non volatile for doing decision support.
>> Collection of data in support of managementâ€™s decision making processâ€. He defined the terms in the sentence as follows.
>> Subject oriented: It defines the specific business domain ex: banking, retail, insurance, etcâ€¦..
>> Integrated:It should be in a position to integrated data from various source systems. Ex: sql,oracle,db2 etcâ€¦â€¦
>> Time variant: It should be in a position to maintain the data the various time periods.
>> Non volatile: Once data is inserted it canâ€™t be changed
Posted Date:- 2021-09-28 06:31:15