>> 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-27 23:31:15