“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
Engineering Management and Systems Engineering
M.S. in Engineering Management
University of Missouri--Rolla
x, 73 pages
© 2000 James Kiemel Brake, All rights reserved.
Thesis - Restricted Access
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.http://merlin.lib.umsystem.edu/record=b4511499~S5
Brake, James Kiemel, "Implementing a combined historical and operational data store utilizing data replication services and dynamic temporal fragments" (2000). Masters Theses. 1984.
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.