Bulgarian Association of Software Developers

and

Bulgarian Java User Group (BGJUG)

kindly invites you to take part in a seminar

Database Transactions and Transaction Management

19 January 2008 (Saturday), 15:00h

Hotel Hyundai, Vitosha

Agenda

Introduction to Database Transaction Management

In this talk the speaker will introduce the fundamental concepts of database concurrency and transactions: ACID transactions and their properties, locking mechanisms, transaction isolation, etc. Transactions and locking will be demonstrated in SQL Server 2005.

Case Study: Managing Transactions in a Supermarket Pay-desk

In the second part of this seminar the speaker will present a classical case study: managing transactions at the supermarket’s pay-desk where orders are processed. An order is a set of order items (product, quantity) entered with a bar-code reader. Processing a set of order items can take few minutes but we should keep the transactions small to allow high concurrency. What we can do? Several different solutions to this situation will be discussed along with their pros and cons.

Distributed Transactions and Long Running Transactions

What if you need a single transaction that spans multiple resources – a SQL Server database, an Oracle database, a message queue and a Web service? Deep dive into how distributed transactions are implemented using the 2-phase commit protocol, transaction managers & resource managers?

What if you need a transaction that lasts for days or months? How to implement long-running transactions with optimistic concurrency control and “undo operations” called compensation actions.

And all this in an interesting “live” demo.

Distributed transactions in Java EE

The speaker will introduce the transaction management model in Java EE and will discuss how applications can use transactions and how transaction management is implemented in Java application servers. The general API-s for transaction management and 2-phase commit protocol API will be explained and live examples with source code will be presented. Some specific issues with different databases will also be discussed.

About the Speakers

Svetlin Nakov is software engineer with more than 10 years of experience in the development of Java, .NET, Web and Win32 applications, software engineering consultant and trainer, author of 4 books and above 30 technical articles and presentations. He is one of the founders and currently chairman of the Bulgarian Association of Software Developers (BASD), director training and consulting activities in the National Academy for Software Development (NASD) and one of the founders of the Bulgarian Java User Group, author of open source projects and blogger.

Rossen Zhivkov is an independent freelance consultant and Microsoft Certified Trainer, expert in SharePoint Server 2007, .NET Framework and SQL Server 2005. He has been a leading consultant in implementation of solutions based on the SharePoint 2007 platform, as well as .NET architect in development of Web & Windows applications. Rossen has delivered development and administration courses for Microsoft technologies for corporate clients in Bulgaria and Europe. Rossen is a MCT, MCSD.NET, MCPD, MCTS: SharePoint Server 2007 & MCTS: SQL Server 2005.