Masters Theses

Abstract

“Shortly after the installation of a 24x7 online transaction processing (OLTP) database system for wholesale energy sales operations, business users found the operations data extremely useful for reporting, analysis and ad-hoc queries. These business users have been allowed to access the OLTP system for some period of time. Because of the potential impact on the performance of the OLTP system due to an increasing number business users and queries, the database administrator decided to develop a plan for separating the business use from the operational use of the OLTP system. A decision was made to utilize data replication services to create and maintain an operational data store (ODS) to be used solely for business users with read intensive queries. The desired result was a system in which each user group would not impact the other and so the performance for each user group could be tuned individually. After reviewing the literature a plan was developed and implemented that would utilize asynchronous data replication services to provide an ODS in which historical data was allowed to accumulate regardless of the fact that the OLTP was pruned of historical data. The result was a combined historical and operational data store (HODS). The problems of availability of the 24x7 system and of maintaining data consistency between the OLTP and the HDS were addressed with optimization goals of high application transparency, near real-time latency, low custom programming and administrative requirements”--Abstract, page iii.

Advisor(s)

Kluczny, Raymond Michael

Committee Member(s)

Daily, Madison
Fu, Yongjian

Department(s)

Engineering Management and Systems Engineering

Degree Name

M.S. in Engineering Management

Publisher

University of Missouri--Rolla

Publication Date

Fall 2000

Pagination

x, 73 pages

Note about bibliography

Includes bibliographical references (pages 71-72).

Rights

© 2000 James Kiemel Brake, All rights reserved.

Document Type

Thesis - Restricted Access

File Type

text

Language

English

Thesis Number

T 7837

Print OCLC #

45902034

Download
Off-campus S&T users

Share My Thesis If you are the author of this work and would like to grant permission to make it openly accessible to all, please click the button above.

Share

 
COinS