BibTeX:

@article{IJIRSTV2I9062,
     title={Data Mining & Data Warehousing: An Exhaustive Elucidation},
     author={Rydhm Beri and Veerawali Behal},
     journal={International Journal for Innovative Research in Science & Technology},
     volume={2},
     number={9},
     pages={324--328},
     year={},
     url={http://www.ijirst.org/articles/IJIRSTV2I9062.pdf},
     publisher={IJIRST (International Journal for Innovative Research in Science & Technology)},
}

Now a day, bigger or even smaller organizations rely more on database applications to maintain their data. These databases are referred to as the operational data and are responsible for daily transactions. However, there is a need for storage of historical data so that the decision making activities becomes easy. To store the historical data the data ware house is used. The concept of data warehousing include the tools and techniques related to extract data collected from different sources and required in decision support systems. In order to extract data from the data warehouse the procedure named Data Mining is used. Data mining applies set of algorithms and procedures to the data warehouse to extract information stored in larger data warehouse. Moreover, Data mining techniques are applied by Data Mining Query Language (DMQL), that is actually based on Structured Query Language (SQL). DMQL provides the commands for the procedure of data mining. This paper includes the description about the different concepts related to the data warehousing and data mining. This paper also enlists some of the feature or methods of using the data warehouse or data mining. Moreover, this study also includes the study of short slices of data warehouse known as “Data Marts”.

Data warehouse, Data Mining, Design model of data ware house, Data Marts