DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Refcards Trend Reports Events Over 2 million developers have joined DZone. Join Today! Thanks for visiting DZone today,
Edit Profile Manage Email Subscriptions Moderation Admin Console How to Post to DZone Article Submission Guidelines
View Profile
Sign Out
Refcards
Trend Reports
Events
Zones
Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
  1. DZone
  2. Data Engineering
  3. Databases
  4. VoltDB's End of Summer Engineering Update

VoltDB's End of Summer Engineering Update

Mike  Stonebraker user avatar by
Mike Stonebraker
·
Sep. 07, 12 · Interview
Like (0)
Save
Tweet
Share
6.97K Views

Join the DZone community and get the full member experience.

Join For Free

It's been a busy summer here at VoltDB! Since spring the VoltDB Engineering team has released VoltDB four times (we're operating on 3 week sprints) and delivered numerous product and performance enhancements.

Some of the major features we've recently released include:

  • Pause-less rejoin of failed nodes. Failed nodes can now be rejoined to the k-safe cluster without significant impact to the operational throughput of the cluster. This feature is available in the Enterprise edition of VoltDB.
  • Significant performance improvements around ad hoc SQL, which is SQL executed outside of stored procedures, via the @AdHoc system procedure invocation or through JDBC.   Some of our internal workloads saw three orders of magnitude improvement in ad hoc throughput.
  • SQL LIKE support.  Provides the ability to search for a specified pattern in a column.
  • CSV Loader.   The ability to load data into VoltDB from a text file containing comma-separated tabular values.
  • New PHP Client. A new lightweight C-extension-based PHP client with a streamlined interface.

We've also introduced numerous other features including:

  • Column Functions: Date Extract functions, String functions, with more to come!
  • Counting/Rank index performance improvements upwards of 1000%.  Helpful for leaderboard and ranking-type queries.
  • New "explain” query plan system stored procedure.
  • Java Date and Timestamp are now valid parameter types for VoltDB stored procedures.
  • VoltDB allows broader use of strings as arguments. It is now possible to pass numeric values, such as integers and floating point values, to stored procedures as the string representations of those values.
  • Ability to Batch Multiple Ad Hoc SQL statements as one transactional request.
  • Large Catalog Updates
  • Java Client Support for arrays of VARBINARY (arrays of arrays of bytes)
  • Ability to partition tables on VARBINARY columns
  • Integration of Partitioning with the Schema DDL
  • New Debian Installation Package

Be sure to download the latest kit containing these enhancements as well as many others, here: http://voltdb.com/products-services/downloads

For a full description of these new features, please see the VoltDB documentation and associated kit release notes
VoltDB Engineering

Published at DZone with permission of Mike Stonebraker, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

Popular on DZone

  • Using JSON Web Encryption (JWE)
  • Type Variance in Java and Kotlin
  • Unlocking the Power of Polymorphism in JavaScript: A Deep Dive
  • Upgrade Guide To Spring Data Elasticsearch 5.0

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 600 Park Offices Drive
  • Suite 300
  • Durham, NC 27709
  • support@dzone.com
  • +1 (919) 678-0300

Let's be friends: