Data Warehousing Training in Bangalore

Published: 01st June 2011
Views: N/A

Data Warehousing a database used for reporting. Today we have need to store lots of data for future analysis. A data warehouse maintains its functions in three layers: staging, integration, and access. Staging is used to store raw data for use by developers (analysis and support). The integration layer is used to integrate data and to have a level of abstraction from users. The access layer is for getting data out for users.

This definition of the data warehouse focuses on data storage. The main source of the data is cleaned, transformed, catalogued and made available for use by managers and other business professionals for data mining, online analytical processing, market research and decision support (Marakas & OBrien 2009). However, the means to retrieve and analyze data, to extract, transform and load data, and to manage the data dictionary are also considered essential components of a data warehousing system. Many references to data warehousing use this broader context. Thus, an expanded definition for data warehousing includes business intelligence tools, tools to extract, transform and load data into the repository, and tools to manage and retrieve metadata.

Key developments in early years of data warehousing

1960s General Mills and Dartmouth College, in a joint research project, develop the terms dimensions and facts.

1970s ACNielsen and IRI provide dimensional data marts for retail sales.

1970s Bill Inmon begins to define and discuss the term: Data Warehouse

1983 Teradata introduces a database management system specifically designed for decision support.

1988 Barry Devlin and Paul Murphy publish the article An architecture for a business and information systems in IBM Systems Journal where they introduce the term "business data warehouse".

1990 Daniel Linstedt begins work on Developing the Data Vault model and methodology for data warehouses

1990 Red Brick Systems introduces Red Brick Warehouse, a database management system specifically for data warehousing.

1991 Prism Solutions introduces Prism Warehouse Manager, software for developing a data warehouse.

1991 Bill Inmon publishes the book Building the Data Warehouse.

1995 The Data Warehousing Institute, a for-profit organization that promotes data warehousing, is founded.

1995 Daniel Linstedt adds SEI/CMMI and Six Sigma to the Data Vault Methodology to manage projects in data warehousing.

1996 Ralph Kimball publishes the book The Data Warehouse Toolkit.

2000 Daniel Linstedt releases the Data Vault, enabling real time auditable Data Warehouses warehouse.

In Bangalore we have few very good training centers who can help you in learning Data Warehousing very fast. And have this skill almost gives guarantee of a high paying job in Bangalore. Sapware Technologies Pvt. Ltd. is training, consulting and outsourcing company headquartered in Bengaluru with 3 delivery centers in BTM, Koramangala & Vijayanagar.

For more information on Data Warehousig Training in Bangalore you can visit

Report this article Ask About This Article

More to Explore