Improving Resource Management & Solving Scheduling Problem in Data Warehouse Using OLAP & OLTP

Rekha, Dr. Rajendar Singh Chhillar

ABSTRACT: Data in warehouse[1] & data marts is stored & managed by one or more warehouse servers, which present multidimensional are views of data to a variety of front end tools: query tools, report writers, analysis & data mining tools. Finally, there is a repository for storing & managing metadata[11] & tools for monitoring & administering[7] 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 perform multidimensional analysis of business data & provides capability for complex calculations, trend analysis, & sophisticated data modeling.

Title:	Improving Resource Management & Solving Scheduling Problem in Data Warehouse Using OLAP & OLTP
Author Name:	Rekha, Dr. Rajendar Singh Chhillar
Abstract:	ABSTRACT: Data in warehouse[1] & data marts is stored & managed by one or more warehouse servers, which present multidimensional are views of data to a variety of front end tools: query tools, report writers, analysis & data mining tools. Finally, there is a repository for storing & managing metadata[11] & tools for monitoring & administering[7] 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 perform multidimensional analysis of business data & provides capability for complex calculations, trend analysis, & sophisticated data modeling.
Cite this article:	Rekha, Dr. Rajendar Singh Chhillar , " Improving Resource Management & Solving Scheduling Problem in Data Warehouse Using OLAP & OLTP " , International Journal of Emerging Trends & Technology in Computer Science (IJETTCS), Volume 6, Issue 2, March - April 2017 , pp. 150-154 , ISSN 2278-6856.
Full Text [PDF] Home