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.
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.
For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at firstname.lastname@example.org
Download the MySQL Sponsor/Exhibitor Prospectus
For media-related inquiries, contact Maureen Jennings at email@example.com
To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.
View a complete list of MySQL contacts.