Data Warehouse Design and Implementation Research Paper

Data Warehouse Design and Implementation - Research Paper Example Additionally, the online analytical processing systems offer a technique to produce ad-hoc queries beside the data-warehouse in an attempt to respond to significant business questions. In the same way, data mining offers a wide variety of techniques and algorithms for finding knowledge in a huge bulk of corporate data. In addition, in order to develop a data warehouse system, we need to put into operation a reliable technology structure where corporate operational data can be managed effectively with real and enterprise-wide aspects and to get into reorganization of a handful application policies to offer a high quality system. However, the implementation and design of a data warehouse system has occasionally been a very big challenge in theory as well as in practice (Charles, 2010; Turban, Leidner, McLean, & Wetherbe, 2005; Olamendy, 2010). This paper discusses some of the important aspects related to the design and implementation of a data warehouse system. The basic purpose of thi s research is to investigate some of the important aspects such as theories, initiatives, models and techniques for better and improved data warehouse system design and implementations. Introduction A data warehouse is normally recognized as an integrated and time-varying set of information and data that is basically used for strategic decision making through OLAP (online analytical processing) methods. ... this perspective, however hardly any technique exists to date for applying similar methods from an operational database (Charles, 2010; Husemann, Lechtenborger, & Vossen, 2000; Laudon & Laudon, 1999; Inmon, 2002). Without a doubt, there are many standards and methods to implement and design a relational data model for a business system which are flexible to design and implement data warehouse technology based modeling, however they cannot be employed as a natural method, consequently data warehouse development modeling is novel regulation that is improving with the passage of time. Basically, the starting point for the design and development of the data-warehouse environment is the data model. In absence data model, the implementation of a data warehouse is almost impossible. In this scenario, the data model works like a roadmap for technology based system development (Charles, 2010; Husemann, Lechtenborger, & Vossen, 2000; Laudon & Laudon, 1999; Inmon, 2002). Moreover, in order to d evelop a data warehouse system, we need to form a reliable technology based environment where organization’s operational data will be maintained effectively in an enterprise and integrated view and to get into recognition a handful accomplishment policy to offer a high quality system. However, the implementation and design of a data warehouse system frequently is a very complex issue in theory as well as practice (Charles, 2010). This paper will present a detailed analysis of data warehouse design and implementation. This research will cover some of the major aspects that need to be considered while designing implementing models of the data warehouse. Data Warehouse Design This section discusses some of the approaches and methods those can be adopted for the data warehouse design which