A Data Warehouse is a subject-oriented,integrated,time-variant,non-volatile collection of data used in support of management decision making processes.
Subject-Oriented:-The data warehouse is organized around the key subjects (or high-level entities) of the enterprise.
Major subjects includea) Customersb) Patientsc) Studentsd) Productse) Etc.
Data support :-
Stored collection of diverse dataA solution to data integration problemSingle repository of informationSubject-orientedOrganized by subject, not by applicationUsed for analysis, data mining, etc.Optimized differently from transaction-oriented dbUser interface aimed at executive decision makers and analysts.
Data mining :-
It is an attempt to find patterns and relationships hidden in data.Data mining tools use data to build a model of the real world. The result of this modeling is a description of patterns and relationships in data.
No comments:
Post a Comment