Efficient data access and performance improvement model for virtual data warehouse

Fakhri Alam Khan*, Awais Ahmad, Muhammad Imran, Mafawez Alharbi, Mujeeb-ur-rehman, Bilal Jan

*Corresponding author for this work

Research output: Contribution to journalArticlepeer-review

12 Scopus citations

Abstract

This paper presents a model for improving query performance in Virtual Data Warehouse (VDW) by simulating VDW environment on a cellular phone billing and customer care system which involves processing millions of Call Detail Records (CDRs) generated by thousands of counters across the country. Processing aggregations on millions of CDRs requires expensive systems, especially when analysing customers’ traffic trends and encompasses several performance optimization techniques used for improvement of query performance in VDW. In this regard, VDW offers several advantages such as real-time analytic reports, reduced maintenance, low cost solution and flexible data integration, but performance is still one of its critical shortcomings. This paper enhances performance of VDW by using techniques like partitioned materialized views, index performance optimization, query rewrite in materialized views, analytic functions, sub-queries and enabling parallel execution etc. The study uses Oracle 10 g as a backend database; Oracle management console and SQL query analyser are used for monitoring performance concerns during validation of VDW model; standard PL/SQL developer is used for extracting and loading test data; and finally, Hyperion Development suite is used for testing time comparisons of datasets both in normal OLTP and simulated VDW environments.

Original languageEnglish
Pages (from-to)232-240
Number of pages9
JournalSustainable Cities and Society
Volume35
DOIs
StatePublished - Nov 2017
Externally publishedYes

Bibliographical note

Publisher Copyright:
© 2017 Elsevier Ltd

Keywords

  • Business intelligence
  • OLTP
  • Performance optimization
  • Query optimization
  • Virtual data warehouse

ASJC Scopus subject areas

  • Geography, Planning and Development
  • Civil and Structural Engineering
  • Renewable Energy, Sustainability and the Environment
  • Transportation

Fingerprint

Dive into the research topics of 'Efficient data access and performance improvement model for virtual data warehouse'. Together they form a unique fingerprint.

Cite this