Transcript Transaction Processing in Large Database Systems TP Monitor

Transaction Processing in Large Database Systems
TP Monitor
Presented by Jin Fei Yin, Shuai Liu
Topics
Transaction processing in large database
 The role of transaction processing monitors
Overview
 Transactions Properties ---> ensure Reliability
 Transaction processing monitors
(Purpose & Architecture)
 Three popular monitor products(features and benefits)
- Tuxedo from BEA Systems
- Microsoft Transaction Server
- CICS from IBM
 Criteria for choosing/applying TPM
Transaction processing (TP) monitor
* Definition
A program that monitors a transaction as it passes
from one stage in a process to another. (Operating
System for TP)
* Functionality
1) Manage the transfer of data
2) Manage applications programs that serve data
3) Guarantee all databases are updated as a single unit
E.g. Tour agency
Transaction processing (TP) monitor (Cont'd)
* Purpose
- ' Manage transactions from their point of origin, on
the client, across one or more servers and then back to
the original client '
- 'ensure the ACID properties of transactions'
Architecture of the application system
Application architecture that use a transaction
processing monitor consists of three parts
1) A graphic interface layer(on client's computer)
2) An application layer(on numerous separate
application servers)
3) A data layer(on separate database servers)
Architecture of the application system (cont'd)
TPM - Utility & Merit
Solving problems regarding to high volumes of transactions
- airline reservations, security systems
- customer service, order/delivery process systems
 Efficient & Effective Managment
- Using resources efficiently(lower hardware requirements)
- Reduced downtimes(increased profits)
 Higher Scalablity
- Building systems with three-tier architecture
(development and maintenance time is reduced)
Case Study
Product
Tuxedo
(BEA)
Origin
Features
Compatibility
administrate online
e-commerce
transaction
processing systems
C, C++, CORBA
C++, C#,
Visual Basic
TCP/IP, Java
distributed SQL
MTS(MS) support for
Microsoft Visual
transactions to be
transaction support Basic, Visual
easily implemented through application
C++, Visual J++
in other applications code
CICS(IBM) provide transaction
processing for IBM
mainframes
screen displays
COBOL, C, C++,
developments
Java
seperated from
terminal knowledge
TPM - Choosing Criterion
Costs
Resource compatibility: compatible with current resources
Platform support: supports the existing platform
Internet support: If required
Staff expertise: compatible with familiar PL
Usability: easy to learn and use
Company future: maintenance & upgrading
TPM - Utility Scope
a) Efficiency lies in
managing processes with very high volume of transactions
b) Not reasonable to apply to
Systems with few users/low drain on processes
Summary
The uses of TPM within a large database system
o Service
o Architecture
o Products Comparison
o Criteria
o Scope
References
•
•
•
•
•
•
•
•
•
•
•
•
•
BEA Systems 2006, BEA Tuxedo® 9.1, viewed 29 September 2006,
http://www.bea.com/framework.jsp?CNT=features.htm&FP=/content/products/tux/
Begg,C & Connolly, T 2002, Database Systems: A Practical Approach to Design, Implementation, and Management, Pearson Education,
England.
Carnegie Mellon Software Engineering Institute, Client/Server Software Architectures: An Overview, viewed 23 September 2006,
http://www.sei.cmu.edu/str/descriptions/clientserver_body.html
IBM 2006, CICS: Customer information control system, viewed 25 September 2006, http://www-306.ibm.com/software/htp/cics/
Krakowiak, S 2003, What is middleware, viewed 22 September 2006, http://middleware.objectweb.org/
Kroenke, D 2004, Database Processing: Fundamentals, Design, and Implementation, Pearson Education, New Jersey.
Micromax Information Services 1999, 'TP Monitors', viewed 28 September 2006, http://n-tier.com/articles/tp.html
Microsoft 2006, MTS Documentation, viewed 30 September 2006, http://windowssdk.msdn.microsoft.com/enus/library/ms704722.aspx
Nance, W 1997, Balance the load with Transaction Server, viewed 24 September 2006, http://www.byte.com/art/9706/sec6/art1.htm
Pachowicz, P, 'Client/Server Architectures and Applications', viewed 23 September 2006, http://teal.gmu.edu/~ppach/sp06/TCOM510Part-1.ppt
Plew,R & Stephens, R 2003, Sams Teach Yourself SQL in 24 Hours, Sams Publishing
Skeen, D, Unblocking commit protocols, University California, viewed 26 September 2006,
http://delivery.acm.org/10.1145/590000/582339/p133skeen.pdf?key1=582339&key2=6273669511&coll=&dl=ACM&CFID=15151515&CFTOKEN=6184618
Strahl, M, Using Microsoft Transaction Server with VFP, viewed 22 September 2006, http://www.westwind.com/presentations/mts/mts.htm
4/11/2016