Data mining and Data warehousing are used daily in a wide variety of contexts. In today’s corporate world, decisions must be made rapidly and with the maximum amount of knowledge. Data warehousing is the process in which data from multiple sources is combined and stored in one common database (Gutierrez). The fundamental concept of data warehousing is the distinction between data and information. Data is observable and recordable facts but only comes to have value when it is presented as information.
Data warehousing begins with the information acquired from source databases such as transactional and operational systems. This information is then transformed, organized further and loaded into a central depository. Some data warehousing techniques and tools including data warehouse appliances, platforms, architectures, data stores (Data Warehousing, n.d.).
A data warehouse appliance is a combination hardware and software product that is designed for analytical processing.
Data warehousing includes retrieving data, analyzing, extracting, loading, transforming and managing the data. In the Figure 1.1, its shows the process for data mining and data warehousing.
The structure of a data warehouse can be simple data sources going directly into a warehouse, which then is directly visible by the users, to data sources being filed through a staging area before going into the warehouse, and then being categorized for the viewing of the users by the usage of data marts. A staging area is the component data must run through before being gathered in the warehouse.
In the staging area, the data is simplified before it is deposited into the warehouse. Since there may be so much data stored in a warehouse. .n the deployment phase, insight and usable information can be derived from data. Deployment can involve the integration of data mining models within applications, data warehouse infrastructure, or query and reporting tools.
There is so much stored digital data in the world today, but we are starving for knowledge.
The process’ of data warehousing and data mining brings a lot of benefits to businesses, society, governments as well as individuals. There are many everyday business uses of data warehousing and data mining and particular tools available. In the future, companies need to evaluate the costs associated with data warehousing and data mining and the resources needed along with any other considerations. For now, data warehousing and data mining technology will continue to bring profits to businesses that choose to utilize the technology.