Automated Data Versioning with a Storage Engine Middleware

Peter Volk (DDEngine)
Average rating: ****.
(4.00, 3 ratings)

While MySQL offers a wide variety of extensions on user level, the storage engine extends the ABI at the lowest database level. Traditional engines, such as MyISAM, InnoDB, PBXT, deliver a data store for MySQL with different transaction isolation methods and performance. With the appropriate methods, the Revision Engine ABI can add very low level functionality to MySQL in a pluggable way.

With these methods the engine can extend the basic data store paradigm to a data versioning store. The versioning store does not claim to be a new persistent storage engine but is more of a middleware between the MySQL core and existing persistent storage engines. Hence only minimal code is used to implement a most reliable (in terms of bugs in the code) software stack. Moreover the revision paradigm can compete with existing techniques (such as triggers on tables or revision logic within the client application). Compared to the traditional versioning techniques, the revision engine uses low level MySQL interfaces. In this manner it is able to perform more efficiently on DML statements than if the versioning is performed in the client software or with triggers.

In this presentation we will show the benefits of extending MySQL on a storage engine level in terms of data security and DML performance. Furthermore we will illustrate common relational based data versioning and how they can be implemented.

Photo of Peter Volk

Peter Volk

DDEngine

Peter Benjamin Volk received his Diploma in computer science from the Technische Universit├Ąt Dresden in 2007. He majored in Database technology (including Data Mining) and System Architecture with a specialization in microkernel operating systems and database management system design.

Currently he is research assistant at the chair for database system at the Technische Universit├Ąt Dresden performing original research in the field of data mining for semiconductor manufacturing and experimental database management system design. He is also cofounder and head of the DDEngine.org project.

Comments on this page are now closed.

Comments

04/26/2009 3:40pm PDT

Very interesting!

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com

Download the MySQL Sponsor/Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.