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

Performance Tunning Mechanisms for Data Warehouse: Query cache

by Vishal Gour, Dr. S.S.Sarangdevot, Govind Singh Tanwar
journal cover thumbnail

International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 2 - Number 2
Year of Publication: 2010
Authors: Vishal Gour, Dr. S.S.Sarangdevot, Govind Singh Tanwar
10.5120/623-887

Vishal Gour, Dr. S.S.Sarangdevot, Govind Singh Tanwar . Performance Tunning Mechanisms for Data Warehouse: Query cache. International Journal of Computer Applications. 2, 2 ( May 2010), 70-75. DOI=10.5120/623-887

@article{ 10.5120/623-887,
author = { Vishal Gour, Dr. S.S.Sarangdevot, Govind Singh Tanwar },
title = { Performance Tunning Mechanisms for Data Warehouse: Query cache },
journal = { International Journal of Computer Applications },
issue_date = { May 2010 },
volume = { 2 },
number = { 2 },
month = { May },
year = { 2010 },
issn = { 0975-8887 },
pages = { 70-75 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume2/number2/623-887/ },
doi = { 10.5120/623-887 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T19:49:45.884562+05:30
%A Vishal Gour
%A Dr. S.S.Sarangdevot
%A Govind Singh Tanwar
%T Performance Tunning Mechanisms for Data Warehouse: Query cache
%J International Journal of Computer Applications
%@ 0975-8887
%V 2
%N 2
%P 70-75
%D 2010
%I Foundation of Computer Science (FCS), NY, USA
Abstract

Data warehousing encompasses architectures, algorithms, and tools for bringing together selected data from multiple databases or other information sources into a single repository, called a data warehouse suitable for direct querying or analysis. In recent years data warehousing has become a prominent buzzword in the database industry, but attention from the database research community has been limited. At the warehouse, queries can be answered and data analysis can be performed quickly and efficiently since the information is directly available, with model and semantic differences already resolved. The primary goal of data warehouse is to free the information locked up in the operational database so that decision makers and business analyst can make queries, analysis and planning regardless of the data changes in operational database. As the number of queries is large, therefore, in certain cases there is reasonable probability that same query submitted by the one or multiple users at different times. Each time when query is executed, all the data of warehouse is analyzed to generate the result of that query.

References
  1. System Analysis and Design. 2nd Edition. 1999. Elias M. Awad.
  2. The evolving data warehouse market: Part1. Charlie Garry copyright 2004 Meta Delta.
  3. The data warehouse toolkit. 2nd edition. Ralph Kimball, Margy Ross. 2002 Wiley computer publishing.
  4. Data Warehouse Management Handbook by Richard Kachur. 2000 Prentice Hall
  5. Building, using, and managing the data warehouse. Ramon Barquin, George Zagelow, Katherine hammer, Mark sweiger, George Burch, Dennis Berg, Christopher Heagele, Katherine Glassey-Edholm, David Menninger, Paul Barth, J.D. Welch, Narsim ganti, Herb Edelstein, Bernard Boar, Robert Small. Data warehousing institute series from Prentice Hall.
  6. Data warehouse, Practical advice from the experts. 1997. Prentice hall by Joyce Bischoff & Ted Alexander
  7. Lessons from a successful data warehouse implementation. Dr. John. D Porter and john. J Rome. Arizona State University.
  8. Building a data warehouse for decision support. 1996 Prentice Hall. By Vidette Poe with contributions from Laura L. Reeves.
  9. Wikipedia, the web’s free encyclopedia http://en.wikipedia.org/wiki/Data_warehouse
  10. The concise technical dictionary http://www.thetechdictionary.com/ term/etl_%28data_integration%29
  11. The computer world magazine http://www.computerworld.com/databasetopics/businessintelligence/datawarehouse/story/0,10801,89534,00.html
  12. Fundamentals of database systems. 4th Edition. Persons international and Addison Wesley. Ramez Elmasri and Shamkant B. Navathe
  13. Ideal Strategy to Improve Datawarehouse Performance by Fahad Sultan & Dr. Abdul Aziz. (IJCSE) International Journal on Computer Science and Engineering Vol. 02, No. 02, 2010, 409-415
  14. Efficient incremental view maintenance in data warehouses. Ki Yong Lee, Jin HyunSon, Myoung Ho Kim. Korea Advanced Institute of Science and Technology.
  15. R. Winter and B. Strauch. A method for demand-driven information requirements analysis in data warehousing Projects. In Proc. HICSS, pages 1359–1365, Hawaii, 2003.
  16. Albrecht, J.; Hümmer, W.; Lehner, W.; Schlesinger, L.: Using Semantics for Query Derivability in Data Warehouse Applications, appears in: Proceedings of the 4th International Conference on Flexible Query Answering Systems (FQAS’00, Warsaw, Poland, October 25 - 25), 2000.
  17. Adiba, M.E., and Lindsay, B.G. "Database Snapshots," Proceedings of the 6thInternational Conference on VLDB, pp. 86-91, 1980
  18. Strategy to make superior Data ware house by Vishal Gour in International Conference on advance computing and creating entrepreneurs Feb2010.
Index Terms

Computer Science
Information Sciences

Keywords

Data warehouse Operational database Response time Performance

Powered by PhDFocusTM