Seminar Database Transactions – Vitosha – 19 January 2008

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

1500-1540

Introduction to Database Transaction Management

Speaker: Svetlin Nakov

[Download the presentation]

[Watch the lecture video]

1550-1630

Case Study: Managing Transactions in a Supermarket Pay-desk

Speaker: Svetlin Nakov

[Download the presentation]

1640-1800

Distributed Transactions and Long Running Transactions

Speakers: Rossen Zhivkov, Krasimir Parushev

[Download the presentation]

1810-1900

Distributed transactions in Java EE

Speaker: Nikolai Tankov

[Download the presentation]

[Download the demos]

1900-0800

Free Discussion and Party Time

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.

Krasimir Parushev is a technical trainer and consultant in solutions development in ITCE. He has been solution architect and senior developer in .NET projects for development of Web and Windows applications using SQL Server. Krasimir is also an expert in the following fields: SQL Server development, .NET development, BI solutions, BMC Remedy integration. Krasimir is a MCT, MCAD, MCPD, MCTS: SQL Server 2005, MCITP: SQL Server Business Intelligence, and BMC Remedy Approved Consultant.

Nikolai Tankov is senior software engineer in SAP Labs Bulgaria with more than 7 years of experience in the development of Java, Java EE technologies and transaction management. He is a member of Java Connector 1.5 and 1.6 expert groups (JSR 112 & 322). He is responsible for transaction management in SAP NetWeaver and participated into development of several Java EE specifications. Nikolai holds Sun’s SCJP certificate.

Photos

See the seminar photos here.