
An organization may have a number of different systems like TPS, ERP, Accounting Systems and so on. Each of these systems collect data but the data collected through these systems are not always in the same format. So we need to combine all these data from different sources into a single standard form and this process of combining multiple databases into a single homogenous form is called data warehousing.
A data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of data in support of management’s decision making process.Subject-oriented The data in the data warehouse is organized so that all the data elements relating to the same real-world event or object are linked together.Time-variant The changes to the data in the data warehouse are tracked and recorded so that reports can be produced showing changes over time.Non-volatile Data in the data warehouse is never over-written or deleted - once committed, the data is static, read-only, and retained for future reporting.Integrated The data warehouse contains data from most or all of an organization's operational systems and this data is made consistent.
5 comments:
Thanks for sharing.
Data Mining software service providers
Thankyou for sharingData Mining Companies
Thanks for sharing your valuable blog, it is really stunning. But, i want to share an amazing process mining platform that opens the new door of new business opportunities.
Data Mining is the process of discovering hidden patterns, relationships, and useful knowledge from large datasets stored in databases or data warehouses. It uses techniques such as classification, clustering, association rule mining, regression, and prediction to analyze data. Data mining helps organizations identify trends, customer behavior, fraud detection, market opportunities, and future predictions.
Data Warehousing and Data Mining are two important concepts in Business Intelligence that help organizations store, Big Data Projects.manage, and analyze large amounts of data for better decision-making.
Post a Comment