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