Manuscript Number : CSEIT1831261
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.
Deep Kumar Data Warehousing, SQL query, Craftsmanship, Warehouse Architectures, Health care service, Telecommunication services Publication Details Published in : Volume 2 | Issue 1 | January-February 2017 Article Preview
Assistant Professor, Computer Science, Post Graduate Department of Computer Science and Applications, R.S.D College, Ferozepur, Punjab, India
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