Skip directly to content

NoSQL

Key Value Benchmark FAQ

Tuesday, June 1, 2010 - 8:00pm

written by John Hugg on June 1, 2010

This is a follow up to a previous post on Benchmarking VoltDB against Cassandra on Key-Value-like workloads.

 

What’s the point of this benchmark?

 

Point 1: Demonstrate SQL can be fast. Say what you want about our numbers and benchmark, but the language used to manipulate data was SQL and it clearly wasn’t bottlenecking VoltDB performance. We wanted to show the assumption that dropping SQL is a precondition for performance and scalability is false.

Point 2: VoltDB competes well on simple workloads like the key-value puts and gets, as well as complex

MySQL to VoltDB: Experiences from the field

Tuesday, September 4, 2012 - 12:00am

written by Andrew Wilson on September 4, 2012

Francis Pelland is the Technical Lead for Social Game Universe developing the next generation of The Lightning Platform. The Lightning Platform lets developers build high performance, scalable data platform and provides the management, analytics and the tools to promote and grow social games. He wrote a short guide to help his team get through the transition for PHP developers moving from MySQL to VoltDB.   Here’s an excerpt:

Is there PhpMyAdmin or similar?

Yes there is!  This tool is called Web Studio.

Thoughts on NoSQL Now! 2012

Tuesday, August 28, 2012 - 12:00am

written by Ryan Betts on August 28, 2012

One of the best parts about working for a growing start-up is the chance to leave keyboard and office behind and escape to meet users. I spent last week in San Jose at NoSQLNow – a conference designed to bring together users and vendors of “Not Only SQL” products.

VoltDB is, quite proudly, a SQL system and some passers-by raise an eyebrow as we explain this. But our modern OLTP database shares some of the
same design vocabulary as many NoSQL systems: we shard data; we run on commodity and cloud hardware; we scale horizontally; we design for update and

VoltDB Explain Plan Command and Planner Testing Tool

Wednesday, September 12, 2012 - 12:00am

written by Douglas Patten on September 12, 2012

My name is Zheng Li, a UMass Lowell graduate student. I spent the summer as an internship at VoltDB. Over the summer, I primarily worked on two VoltDB features, both related to query plans. The features are:

  1. Explain plan command
  2. Planner testing tool

query plan is an ordered set of steps used to access or modify information in a SQL relational database management system (see http://en.wikipedia.org/wiki/Query_plan).  Understanding query plans is important because the first plan chosen to execute will directly affect the query execution