REVIEW ON RESOURCE MANAGEMENT AND SOLVING SCHEDULING PROBLEM IN DATA WARE HOUSE USING OLAP AND OLAP

Authors

  • Himanshi Kataria Research Scholar Department Of CSE, IIET, Jind
  • Amit Garg Asst. Professor, Department Of CSE, IIET, Jind

Keywords:

business data, Data warehouses, Query throughput, capability, metadata

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 modeling.

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

Han, Jiawei, Micheline Kamber, and Jian Pei. Data mining: concepts and techniques. Morgan kaufmann, 2006.

Hastie, Trevor, Tibshirani, Robert and Friedman, Jerome (2001); The Elements of Statistical Learning: Data Mining, Inference, and Prediction, Springer, ISBN 0-387-95284-5

Liu, Bing (2007); Web Data Mining: Exploring Hyperlinks, Contents and Usage Data, Springer, ISBN 3-540-37881-2

Murphy, Chris (16 May 2011). "Is Data Mining Free Speech?". InformationWeek (UMB): 12.

Nisbet, Robert; Elder, John; Miner, Gary (2009); Handbook of Statistical Analysis & Data Mining Applications, Academic Press/Elsevier, ISBN 978-0-12-374765-5

Downloads

Published

30-09-2016

How to Cite

Himanshi Kataria, & Amit Garg. (2016). REVIEW ON RESOURCE MANAGEMENT AND SOLVING SCHEDULING PROBLEM IN DATA WARE HOUSE USING OLAP AND OLAP. International Journal for Research Publication and Seminar, 7(5), 129–134. Retrieved from https://jrps.shodhsagar.com/index.php/j/article/view/906

Issue

Vol. 7 No. 5 (2016): July - Sept 2016

Section

Original Research Article

License

Copyright (c) 2016 International Journal for Research Publication and Seminar

Creative Commons License

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.