A Survey on Data Warehousing

Authors(1) :-Deep Kumar

Data warehousing is a phenomenon that grew from the huge amount of electronic data stored in recent years and from the urgent need to use that data to accomplish goals that go beyond the routine tasks linked to daily processing. In a typical scenario, a large corporation has many branches, and senior managers need to quantify and evaluate how each branch contributes to the global business performance. The corporate database stores detailed data on the tasks performed by branches. To meet the managers' needs, tailor-made queries can be issued to retrieve the required data. In order for this process to work, database administrators must first formulate the desired query (typically an aggregate SQL query) after closely studying database catalogs. Then the query is processed. This can take a few hours because of the huge amount of data, the query complexity, and the concurrent effects of other regular workload queries on data. Finally, a report is generated and passed to senior managers in the form of a spreadsheet.

Authors and Affiliations

Deep Kumar
Assistant Professor, Computer Science, Post Graduate Department of Computer Science and Applications, R.S.D College, Ferozepur, Punjab, India

Data Warehousing, SQL query, Craftsmanship, Warehouse Architectures, Health care service, Telecommunication services

  1. Dedic, N. and Stanier C., 2016., "An Evaluation of the Challenges of Multilingualism in Data Warehouse Development" in 18th International Conference on Enterprise Information Systems - ICEIS 2016, p. 196.
  2. Jump up to:a b "9 Reasons Data Warehouse Projects Fail". blog.rjmetrics.com. Retrieved 2017-04-30.
  3. Jump "Exploring Data Warehouses and Data Quality". spotlessdata.com. Retrieved 2017-04-30.
  4. Jump "What is Big Data". spotlessdata.com. Retrieved 2017-04-30.
  5. Jump Patil, Preeti S.; Srikantha Rao; Suryakant B. Patil (2011). "Optimization of Data Warehousing System: Simplification in Reporting and Analysis"

Publication Details

Published in : Volume 2 | Issue 1 | January-February 2017
Date of Publication : 2018-02-28
License:  This work is licensed under a Creative Commons Attribution 4.0 International License.
Page(s) : 298-300
Manuscript Number : CSEIT1831261
Publisher : Technoscience Academy

ISSN : 2456-3307

Cite This Article :

Deep Kumar, "A Survey on Data Warehousing", International Journal of Scientific Research in Computer Science, Engineering and Information Technology (IJSRCSEIT), ISSN : 2456-3307, Volume 2, Issue 1, pp.298-300, January-February-2017. |          | BibTeX | RIS | CSV

Article Preview