期刊名称：SCHOLARLY RESEARCH JOURNAL FOR INTERDISCIPLINARY STUDIES
印刷版ISSN：2319-4766
电子版ISSN：2278-8808
出版年度：2017
卷号：4
期号：35
页码：6138-6146
语种：English
出版社：SCHOLARLY RESEARCH JOURNAL'S
摘要：A data warehouse is a subject-oriented, integrated, time-variant, non-volatile collection of data in support of management's decision making process. Data warehousing is the data management and analysis technology. Data in the data warehouse is preprocessed and presented such that it facilitates the cross functional monitoring and assessment of the overall direction of the organization. Thus, it is the hub for an intelligent management decision support. Successful implementation of a data warehouse requires a high-performance, scale able combination of hardware and software, which can integrate easily with existing systems, so that users can use data warehouse to improve their decision-making. A data warehouse is incomplete until it provides the exploitation tools that enable end users to view analyze and report on data in ways that support their decision-making. Data marts, data mining, data modeling and metadata are some other important concepts attached with data warehousing, the knowledge of which helps to a great extent in data warehouse implementation. Business intelligence data warehouse is the combination of two terms frequently used in the data mining and analysis field. When used together, vendors are trying to emphasize that they offer more services than just data warehousing alone. Because business intelligence can encapsulate a wide variety of services and tools, combining the terms into business intelligence data warehouse reflects that the vendor offers everything an organization needs, including the basics of data warehousing. Many organizations prefer to purchase business intelligence tools and data warehousing as a combined business intelligence data warehouse system in order to increase the efficiency of the integrated system. The key advantages of using a Data warehouse business intelligence system is that it makes it much simpler to analyze and report on the information extracted from the data entered into the system. In the cleansing stage of the data warehousing process, all inconstancies in the data are determined and taken care of before the data enters the ETL stage. The effectiveness of the data warehouse application intensifies especially when the operational data resides in distributed, non-homogenous systems and replace manual data gathering and reconciliation procedures. Therefore, data warehousing can be useful to not only commercial sectors but also to sectors like government, health care, insurance, manufacturing, finance, distribution, education The goal of a data warehouse application in an organization is to increase the effectiveness of the Decision-making and direction setting process. Data in the data warehouse is preprocessed and presented such that it facilitates the cross functional monitoring and assessment of the overall direction of the organization. Thus, it is the hub for an intelligent management decision support. A data warehouse is incomplete until it provides the exploitation tools that enable end users to view analyze and report on data in ways that support their decision-making. The aim of the paper is to generate the knowledge of data warehousing concept and its advantages in the era of globalization. To study the structure and application of data warehousing. Acquiring right information at the right time from the huge ocean of data is becoming difficult day by day. Data warehouse helps to convert the information overload in to meaningful strategic information
