Masters Theses


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


Kluczny, Raymond Michael

Committee Member(s)

Daily, Madison
Fu, Yongjian


Engineering Management and Systems Engineering

Degree Name

M.S. in Engineering Management


University of Missouri--Rolla

Publication Date

Fall 2000


x, 73 pages

Note about bibliography

Includes bibliographical references (pages 71-72).


© 2000 James Kiemel Brake, All rights reserved.

Document Type

Thesis - Restricted Access

File Type




Thesis Number

T 7837

Print OCLC #


Link to Catalog Record

Electronic access to the full-text of this document is restricted to Missouri S&T users. Otherwise, request this publication directly from Missouri S&T Library or contact your local library.

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.