SQL Fire – SQL at Web Scale
Most of the options allowing you to take your application to Web Scale are moving away from SQL in some way or another. NoSQL is a major proponent.
SQL Fire is a product from VM Ware addressing the issue of SQL at Web Scale. SQL Fire gains web scale performance using
- Data is stored on multiple machines
- Data is primarily stored in memory
- The database scales horizontally across multiple machines
- Data may be replicated across locations
These kinds of features are unique in a product that follows a traditional SQL Syntax. JDBC and ODBC may be used to attach and query SQL Fire data storage.
So, the intention is for you to be able to replace your persistence machine with an SQL engine following the traditional SQL Syntax, requiring less impact on your code while providing scalability rivaling all traditional SQL Engines. VM Ware says SQL Fire can be up to 30 times faster than Oracle 11g.
What do you think? Is there a place for an engine such as SQL Fire? It seems like it would be easier to introduce in an architecture using something like hibernate or some other ORM mechanism that does not use proprietary stored procedures, etc.
Get into the conversation by sharing your thoughts below, or drop an email to btaylor@sswug.org.
Cheers,
Ben
$$SWYNK$$
Featured Article(s)
3 Things: Moving Some, All or None of Your Systems to the Cloud
There are fundamental differences between approaches offered by current online solutions. The choices are very important to understand. Here’s a look at 3 different points to consider.
Featured White Paper(s)
Encryption Key Management Simplified
Managing encryption keys is a fundamental step to securing encrypted data, meeting compliance requirements, and preventing da… (read more)