|Ravi Pandya software | nanotechnology | economics||
Thu 25 Oct 2007
The question raised by the Dynamo paper is answered here: Michael Stonebraker, Pat Helland, et al say it's the end of architectural era in databases, and it's time for a complete rewrite. In an earlier paper, Stonebraker said that special-purpose databases would be faster than general-purpose DBs for specialized tasks like stream queries. Now he's saying (and showing) that a general purpose database can be solidly trounced (82x perf on TPC benchmarks!) by a database optimized for current systems architectures. H-store has:
They work through a taxonomy of application schemas and map them to this model. Typical business apps follow a constrained tree schema (orders, order lines, etc.) which maps very well, and then there are soem interesting variations. H-store can precompile query/update plans, conflict analysis, etc. based on a static schema.
There are a number of interesting issues still to research - schema evolution, rebalancing, etc. But this is a very promising direction.
© 2002-2004 Ravi Pandya | All Rights Reserved