International Journal of Emerging Trends & Technology in Computer Science
A Motivation for Recent Innovation & Research
ISSN 2278-6856
www.ijettcs.org

Call for Paper, Published Articles, Indexing Infromation Improving Resource Management & Solving Scheduling Problem in Data Warehouse Using OLAP & OLTP, Authors : Rekha, Dr. Rajendar Singh Chhillar, International Journal of Emerging Trends & Technology in Computer Science (IJETTCS), www.ijettcs.org
Volume & Issue no: Volume 6, Issue 2, March - April 2017

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