1 / 13

Transaction Processing in Large Database Systems TP Monitor Presented by Jin Fei Yin, Shuai Liu

Transaction Processing in Large Database Systems TP Monitor Presented by Jin Fei Yin, Shuai Liu. Topics. T ransaction processing in large database T he role of transaction processing monitors. Overview. T ransactions P roperties ---> ensure R eliability Transaction processing monitors

skyler
Download Presentation

Transaction Processing in Large Database Systems TP Monitor Presented by Jin Fei Yin, Shuai Liu

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Transaction Processing in Large Database SystemsTP MonitorPresented by Jin Fei Yin, Shuai Liu

  2. Topics • Transaction processing in large database • The role of transaction processing monitors

  3. 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/applyingTPM

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

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

  6. Architecture of the application system • Application architecture that use a transaction processing monitor consists of three parts • 1) Agraphic interface layer(on client's computer) • 2) An application layer(on numerous separate application servers) • 3) A data layer(on separate database servers)

  7. Architecture of the application system (cont'd)

  8. TPM - Utility & Merit • Solving problemsregarding tohigh volumesof transactions • - airline reservations, security systems • - customer service, order/delivery process systems • Efficient & Effective Managment - Using resources efficiently(lower hardware requirements) - Reduced downtimes(increased profits) • HigherScalablity - Building systems with three-tier architecture (development and maintenance time is reduced)

  9. Case Study

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

  11. TPM - Utility Scope • a) Efficiency lies in • managing processes with very high volumeof transactions • b) Not reasonable to apply to • Systems with few users/low drain on processes

  12. Summary The uses of TPM within a large database system • Service • Architecture • Products Comparison • Criteria • Scope

  13. 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/en-us/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/TCOM510-Part-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/p133-skeen.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.west-wind.com/presentations/mts/mts.htm

More Related