LITERATURE SURVEY ON DATA WAREHOUSE AND ITS TECHNIQUES

Data warehouse and online analytical processing (OLAP) both are core component for decision making and support which had become focus of attraction in the data base management industry. By increasing demand of these two thing in data base there are now there is much these type of products in commercial and user base and as well as this type of services are available in market as well as to the vendors of data base management systems has offered in these area. Whereas the decision making support have some different requirement in database technology as we can compare with traditional online transaction processing application. In this literature survey data warehousing and OLAP technologies have been gathered with new requirement. The literature survey I have also described about the back end tools which are used for extraction, cleaning and loading into data warehouse and making multidimensional data models typically of the OLAP. Where as in the front end client tools are of the query execution and it also include data analysis where as the server extension are efficient in query processing also in other type of tools for metadata management as well but also for the managing that data ware house.