CFP last date
20 May 2024
Call for Paper
June Edition
IJCA solicits high quality original research papers for the upcoming June edition of the journal. The last date of research paper submission is 20 May 2024

Submit your paper
Know more
The week's pick
Responsive image
Enhancing Privacy Preservation: Multi-Attribute Protection with P-Sensitive K-Anonymity

Twinkle Patel Kiran Amin
Random Articles
Reseach Article

Issues of Materialized Views in Datawarehousing for Efficient Management of Information

Published on February 2013 by G. Prabagaran, N. Venkatesan
journal_cover_thumbnail

National Conference on Future Computing 2013
Foundation of Computer Science USA
NCFC - Number 1
February 2013
Authors: G. Prabagaran, N. Venkatesan
fb542dc6-d037-41e9-8f11-91c7e93447a6

G. Prabagaran, N. Venkatesan . Issues of Materialized Views in Datawarehousing for Efficient Management of Information. National Conference on Future Computing 2013. NCFC, 1 (February 2013), 15-18.

@article{
author = { G. Prabagaran, N. Venkatesan },
title = { Issues of Materialized Views in Datawarehousing for Efficient Management of Information },
journal = { National Conference on Future Computing 2013 },
issue_date = { February 2013 },
volume = { NCFC },
number = { 1 },
month = { February },
year = { 2013 },
issn = 0975-8887,
pages = { 15-18 },
numpages = 4,
url = { /proceedings/ncfc/number1/10403-1004/ },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Proceeding Article
%1 National Conference on Future Computing 2013
%A G. Prabagaran
%A N. Venkatesan
%T Issues of Materialized Views in Datawarehousing for Efficient Management of Information
%J National Conference on Future Computing 2013
%@ 0975-8887
%V NCFC
%N 1
%P 15-18
%D 2013
%I International Journal of Computer Applications
Abstract

Multiple Views can be formed and materialized from a data warehouses per the user requirements specified in the queries being generated against the information contained in the warehouse. Selecting Views to be materialized is one of the most important decisions in designing a warehouse. Due to change in user requirements and constraints over time View definitions stored in a data warehouse are dynamic in nature. This paper focus on the issues of materialized views in Data warehousing to enable efficient Information Management. The issues include selection, maintenance and updating of Materialized views and how these issues create an impact in Business scenarios.

References
  1. H. Gupta, "Selection of Views to Materialize in a Data Warehouse," Proceedings of ICDT, pp. 98-112, 1997
  2. A. N. M. Bazlur Rashid and M. S. Islam ,"An Incremental View Materialization Approach in ORDBMS" International Conference on Recent Trends in Information, Telecommunication and Computing 2010
  3. Mr. P. PKarde and Dr. V. M. Thakare "Selection of Materialized View Using Query Optimization In Database Management: An Efficient methodology International Journal of Database Management Sysems(IJDMS),Vol. 2, No. 4, November 2010 DOI: 10. 5121/ijdms. 2010. 2410 116.
  4. J. Goldstein and P. A. Larson. Optimizing queries using materialized views :A practical, scalable Solution. In Proceedings of SIGMOD Conference, 2001.
  5. H. Gupta, "Selection of Views to Materialize in a Data Warehouse," Proceedings of ICDT, pp. 98-112, 1997.
  6. H. Gupta and I. S. Mumick, "Selection of Views to Materialize under a Maintenance Cost Constraint," Proceedings of ICDT, pp. 453-473, 1999.
  7. T. Griffin and L. Libkin. Incremental maintenance of views with duplicates. In Proceedings of SIGMOD Conference, 1995.
  8. A. Gupta. I. S. Mumick. and V. S. Subrahmanian. Maintaining views incrementally. In Proceedings Of SIGMOD Conference, 1993
  9. P. A. Larson and J. Zhou. Efficient maintenance of materialized outer-join views. In Proceedings of ICDE Conference, 2007.
  10. W. Lehner. R. Sidle. H. Pirahesh and R. Cochrane. Maintenance of automatic summary tables in Proceedings of SIGMOD Conference, 2000.
Index Terms

Computer Science
Information Sciences

Keywords

Data Warehouse Views Information Management