Improving Resource Management And Solving Scheduling Problem In Data Ware House Using OLAP And OLTP

Authors

  • Asha Rani Department of CSE, IITB College, Sonipat
  • Ritika Saroha Assistant Prof., Department of CSE, IITB College, Sonipat

Keywords:

warehousing, multidimensional, administering, monitoring

Abstract

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

17-05-2024

How to Cite

Asha Rani, & Ritika Saroha. (2024). Improving Resource Management And Solving Scheduling Problem In Data Ware House Using OLAP And OLTP. International Journal for Research Publication and Seminar, 7(7), 27–32. Retrieved from https://jrps.shodhsagar.com/index.php/j/article/view/932

Issue

Section

Original Research Article