Recap of VoltDB for SQL Devs Webinar
We had a great turnout for the VoltDB for SQL Developers webinar on July 19th. The audience was engaged and asked many good questions. We had attendees from all over the US, Canada and Germany. I’d like to thank all those who attended and asked questions, and those who have contacted us since then with additional questions and feedback.
There were several questions in particular about partitioning and working with stored procedures, which hit upon what I think are the two most important concepts.
Partitioning enables scalability and throughput, by distributing both data storage and transaction processing across the hardware resources in the database closer. This requires consideration of the workload, so that the best partitioning column is selected. At a minimum, a partitioning column should distribute the data and work relatively evenly, but it should also enable the most frequent operations to run in a single partition and minimize operations that need to access data from all of the partitions.
Writing stored procedures enables you to develop a layer of abstraction between your application and the database. Basic CRUD procedures are generated automatically, while others are either configured in XML or coded in Java. Stored procedures are known in advance, and can therefore be compiled and planned in advance, and the database can know how to route requests to the appropriate partition in the database to facilitate partitioning. For a SQL Developer, stored procedures may seem like additional work that used to be optional, but they also give developers more control over the database access operations of an application that may be written by others, and allow more complex operations to be performed within the database without multiple round-trips to the application.
The video of the webinar is now available VoltDB’s Resources page. For additional information on these concepts, download VoltDB’s Getting Started and Using VoltDB guides. You can also post questions to our Community Forums.