Abstract: In computing, a data warehouse is a system used for reporting and data analysis. DWs are central repositories of integrated data from one or more disparate sources. Data warehouse acting as a decision support systems. Data warehouses standardize the data across the organization so that there will be one view of information. Data warehouses can provide the information required by the decision makers. The data warehousing module is intended for centralizing the storage location of the organization’s data. This allows the business to maintain one version of the truth for reporting and analysis.
The paper focuses on different components in the Data warehouse and its schemas. The main components include the ETL process, OLAP and other client applications residing on the Data warehouse. Extraction–transformation–loading (ETL) tools are pieces of software responsible for the extraction of data from several sources, its cleansing, customization, reformatting, integration, and insertion into a data warehouse. Building the ETL process is potentially one of the biggest tasks of building a warehouse; it is complex, time consuming, and consumes most of data warehouse project's implementation efforts, costs, and resources. Building a data warehouse requires focusing closely on understanding three main areas: the source area, the destination area, and the mapping area (ETL processes).
OLAP is a trend in database technology, based on the multidimensional view of data. Multidimensional data (called multi cubes) form the basic logical data model for OLAP applications and a significant number of proposals exist for cube models, without – in most cases – the distinct description of an equivalent “presentational” layer or model for the presentation of multidimensional data and their hierarchies.
Keywords: ETL process, OLAP, Call Management Data Warehousing.
Title: Call Management Data Warehousing
Author: Pooja Jaiswal
International Journal of Computer Science and Information Technology Research
ISSN 2348-1196 (print), ISSN 2348-120X (online)
Research Publish Journals
