Improving Resource Management And Solving Scheduling Problem In Data Ware House Using OLAP And OLTP
Keywords:
warehousing, multidimensional, administering, monitoringAbstract
Data in the warehouse and data marts is stored and managed by one or more warehouse servers, which present multidimensional views of data to a variety of front end tools: query tools, report writers, analysis tools, and data mining tools. Finally, there is a repository for storing and managing metadata, and tools for monitoring and administering the warehousing system. Data warehouses, in contrast, had been targeted for decision support. Historical, summarized & consolidated data would be more important than detailed, individual records. Work load had been query intensive within mostly ad hoc, complex queries that could access millions of records & perform lot of scans, joins, & aggregates. Query throughput & response times had been more important than transaction throughput.
OLAP performs multidimensional analysis of business data & provides capability for complex calculations, trend analysis, & sophisticated data modelling.
References
Mr. Dishek Mankad “The Study on Data Warehouse Design and Usage” International Journal of Scientific and Research Publications , Volume 3, Issue 3, March 2013 ISSN 2250- 3153
Surajit Chaudhuri wrote on An Overview of Data Warehousing and OLAP Technology (Appears in ACM Sigmod Record, March 1997).
Manjunath T. N. wrote on Realistic Analysis of Data Warehousing and Data Mining Application in Education Domain
Weiss, Sholom M.; and Indurkhya, Nitin (1998); Predictive Data Mining, Morgan Kaufmann
Kimball, R.The Data Warehouse Toolkit. John Wiley, 1996.
Barclay, T., R. Barnes, J. Gray, P. Sundaresan, “Loading Databases using Dataflow Parallelism.” SIGMOD Record, Vol.23, No. 4, Dec.1994.
Blakeley, J.A., N. Coburn, P. Larson. “Updating Derived Relations: Detecting Irrelevant and Autonomously ComputableUpdates.” ACM TODS, Vol.4, No. 3, 1989.
]Gupta, A., I.S. Mumick, “Maintenance of Materialized Views: Problems, Techniques, and Applications.” Data Eng. Bulletin, Vol. 18, No. 2, June 1995.
Zhuge, Y., H. Garcia-Molina, J. Hammer, J. Widom, “View Maintenance in a Warehousing Environment, Proc. Of SIGMOD Conf., 1995.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2016 International Journal for Research Publication and Seminar
This work is licensed under a Creative Commons Attribution 4.0 International License.
Re-users must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use. This license allows for redistribution, commercial and non-commercial, as long as the original work is properly credited.