The ACID paradigm guarantees the validity of the database state and 4D provides superlative support for it. Learn the skills of mastering 4D’s “4-Wheel Drive” mode and how to make it work for you.

Wikipedia defines an atomic transaction as “an indivisible and irreducible series of database operations such that either all occur, or nothing occurs” and is part of the ACID gold standard of database features. Strategically placed atomicity can serve as the pillars of a building that keep the roof from crashing down as our projects evolve.
In this presentation we go beyond START/VALIDATE TRANSACTION to examine some key techniques associated with stateless design including a pseudo “3-tier” logic model using brokering records, switching from pessimistic to optimistic concurrency management, decoupled table designs for minimum contention, error handling best practice and “canned” maintenance modes in the atomic tier.
Whether you’re an intermediate developer who would like to take a controlled leap into advanced concepts or an experienced one who just wants to compare notes, this presentation will provide a lively and engaging guide to extreme-reliability design using 4D.

Presented by: Peter Jakobsson • Netkelvin