CFP last date
22 April 2024
Reseach Article

Improvement of Query Processing Speed in Data Warehousing with the Usage of Components-Bitmap Indexing, Iceberg and Uncertain Data

Published on May 2015 by Uma Pavan Kumar, Lakshma Reddy, Sreedevi.s.erady
An Architectural Framework for Workload Demand Prediction in Scalable Federated Clouds
Foundation of Computer Science USA
ICCTAC2015 - Number 1
May 2015
Authors: Uma Pavan Kumar, Lakshma Reddy, Sreedevi.s.erady
86102cf0-afdc-4102-b470-10db2699b9f2

Uma Pavan Kumar, Lakshma Reddy, Sreedevi.s.erady . Improvement of Query Processing Speed in Data Warehousing with the Usage of Components-Bitmap Indexing, Iceberg and Uncertain Data. An Architectural Framework for Workload Demand Prediction in Scalable Federated Clouds. ICCTAC2015, 1 (May 2015), 27-31.

@article{
author = { Uma Pavan Kumar, Lakshma Reddy, Sreedevi.s.erady },
title = { Improvement of Query Processing Speed in Data Warehousing with the Usage of Components-Bitmap Indexing, Iceberg and Uncertain Data },
journal = { An Architectural Framework for Workload Demand Prediction in Scalable Federated Clouds },
issue_date = { May 2015 },
volume = { ICCTAC2015 },
number = { 1 },
month = { May },
year = { 2015 },
issn = 0975-8887,
pages = { 27-31 },
numpages = 5,
url = { /proceedings/icctac2015/number1/20922-2009/ },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Proceeding Article
%1 An Architectural Framework for Workload Demand Prediction in Scalable Federated Clouds
%A Uma Pavan Kumar
%A Lakshma Reddy
%A Sreedevi.s.erady
%T Improvement of Query Processing Speed in Data Warehousing with the Usage of Components-Bitmap Indexing, Iceberg and Uncertain Data
%J An Architectural Framework for Workload Demand Prediction in Scalable Federated Clouds
%@ 0975-8887
%V ICCTAC2015
%N 1
%P 27-31
%D 2015
%I International Journal of Computer Applications
Abstract

Data warehousing is a huge collection of data sources meant for handling strategic decisions with historical and current data. The recent trend in information technology market is big data analytics. Huge amounts of data available with the companies but the proper information as per the requirements is still a challenging issue. The current article is dealing with the implementation of iceberg queries, slowly changing dimensions and uncertain data processing. The idea behind the integration of these aspects is processing subsets of the data from the huge amounts of the data. In case of iceberg querying the main theme is aggregate query processing such as count, sum, average, maximum and minimum kind of calculations. In most of the cases the analysis of the data and comparison of the performance aspects between aggregations only, so usage of iceberg querying will improve the processing speed of the data warehousing. The second component we are considering to process data warehousing is slowly changing dimensions. The dimension tables are the basic things of the data warehousing construction, usually dimensions will change slowly not frequently. If we are able to track the changes done to the dimensions such as maintenance of historical and current data, with the tracking of data we can get the subset of data which got modified or which we need to process, which will greatly reduce the number of records to process. The third component we are considering is uncertain data processing. The data which is not having any structure and no information about the format is known as uncertain data, now a days the data population of the data like reviews, likes or shares in social media, MS response all are recorded in uncertain format. The processing of uncertain data with softest computing will give the identification of missing data, parameterization aspects are possible.

References
  1. Bhosale"Efficient Indexing Techniques on Data Warehousing" International Journal of Scientific & Engineering Research vol 4, Issue 5, May-2013, ISSN 2229-5518.
  2. NaveenGar,PhDscholar,SNUniversity,Jharkhand,"Bitmap Indexing technique for data warehousing and data mining", International Journal of Latest trends in engineering& Technology vol 2. Issue 1,January 2013,ISSN:2278-621X
  3. Zanab qays abdulhadi, school of information systems and engineering, central south university, china. "Bitmap index as effective indexing for low cardinality column in data warehouse", International Journal of computer applications, vol 68, April 2013, ISSN: 0975-8887).
  4. Jesus Camacho- Rodriguez "Web data indexing in the cloud: Efficiency and Cost reductions", ©ACM 2013, March 18-22.
  5. Naveen Garg, PhD Scholar, "An Efficient Approach for data indexing in DWH&DM", International Journal of Innovations in engineering and Technology, vol-1, Issue 4, Dec 2012.
  6. Biyramjit paul, Asst. Prof Dept. of CA,Westbengal "Comparative study of various Bitmap Indexing techniques used in Data warehouse" , ,International Journal of Emerging trends & Technology in computers,ISSN 2278-6856,Vol-1,Issue-3,Sep-2012.
  7. Amorntep Keawpibal "Enhanced Encoded Bitmap Index For equality Query", Thailand, IEEE, 2012.
  8. T. P. Latchoumi, "Multi Agent Systems In Distributed Data warehousing", International Conf. on Computer & Communication Technology
  9. Andrea Campagna,"Frequent Pairs in Data Streams: Exploiting Parallelism and Skew", 2011 11th IEEE International Conference on Data Mining Workshops
  10. Gehad Galal ,"Exploiting Parallelism in Knowledge Discovery Systems to Improve Scalability", ,1060-3425/98 (c) 1998 IEEE
  11. Marco Vieira, Henrique Madeira" Integrating GQM and Data Warehousing for the Definition of Software Reuse Metrics", ,2011 34th IEEE Software Engineering Workshop
  12. Munawar " Towards Data Quality into the Data Warehouse development", 2011 Ninth IEEE International Conference on Dependable,
  13. Abdolreza Hajmoosaei, "Autonomic and Secure Computing978-0-7695-4612-4/11© 2011 IEEEDOI 10. 1109/DASC. 2011. 1941200-2011 IEEE Ninth International Conference on Dependable,
  14. COMPARISON PLAN FOR DATAWAREHOUSE SYSTEM ARCHITECTURES Data sheet© 2011 Microsoft Corporation
  15. Satkaur , Research scholar, S. K. I. E. T. ,Kurukshetra, Haryana "International Journal of Advanced Research in computer Science and Software Engineering" , , Volume 3, Issue 5, May 2013 ISSN: 2277 128X .
  16. Jens Dittrich JorgeArnulfo,Quian´eRuizInformation Systems Group Saarland University "Efficient Big Data Processing in Hadoop Map Reduce, Proceedings of the VLDB Endowment", Vol. 5, No. 12Copyright 2012 VLDB
  17. Lizhe Wang, School of Computer, China University of Geosciences, "G-Hadoop: Map Reduce across distributed data centers for data-intensive computing, Future Generation Computer Systems", the international journal of grid computing and esciences 2012 Elsevier.
  18. Bo Dong, Department of Computer Science and Technology, Xi'an Jiaotong University, Xi'an, China, "A Novel Approach to Improving the Efficiency of Storing and Accessing Small Files on Hadoop: a Case Study by PowerPoint Files", , 2010 IEEE International Conference on Services Computing.
  19. Muhammad Inayat Ullah, Gomal University, "Transformation of Flat File into Data Warehouse", Global Journal of Computer Science and Technology, Volume 11 Issue 13 Version 1. 0 August 2011.
  20. Sheetal ganu, Punjabi university, "Improved Extraction mechanism in ETL process for building of a Data Warehouse", IEEE international conference, Mumbai.
  21. Ranjit Singh, Research Scholar, University College of Engineering (UCoE), Punjabi University, "A Descriptive Classification of Causes of Data Quality Problems in Data Warehousing", IJCSI International Journal of Computer Science Issues, Vol. 7, Issue 3, No 2, May 2010 41ISSN (Online): 1694-0784
  22. Md AL Mamun, "Performance improvement techniques for customized data warehouse", IOSR-JCE, April 2013.
  23. Bin He "Efficient Iceberg query evaluation using compressed bitmap index", , IEEE Transactions,Sept,2012
  24. Chuyang Wei, "Efficient Cube computing on an extended multi-dimensional model over uncertain data," IEEE 2012
  25. http://www. tgc. com/dsstar/01/0109/102533. html
Index Terms

Computer Science
Information Sciences

Keywords

Slowly Changing Dimensions Ice Berg Queries Uncertain Data Bitmap Indexing Soft Set Computing