Let’s quickly take a look at the strengths and weakness of current SQL and NoSQL databases with an eye towards where they are today! Its clear there is tremendous investment and development extending both SQL an NoSQL solutions (often to provide functions inherent in the other!) and over time innovation will close these gaps. Exactly when and how will evolve over the coming years, but we feel TODAY any serious data strategy must embrace BOTH storage paradigms.
- Mature technology
- Tremendous support options
- Decades of applications developed (both open and closed source)
- Low Latency transactions (OLTP)
- Robust transaction support (ACID)
- High concurrency
- Full ANSI compliant SQL
- Robust security
- Massive datastore capacity
- Massive parallel query
- Commodity hardware
- Horizontal scalability
- Ultra fast bulk data loads
- Unstructured data support
Its interesting to note that many of the strengths of NoSQL specifically arose from innovations driven to get past current SQL scaling limitations. In doing so, a entire new paradigm has been created and is being embraced not just by high flying high tech companies but now across industry domains. Data that was ignored by necessity is now being harvested to drive additional business insights. The key word here is additional. To fully gain the potential afforded by BigData computing, its critical to integrate within your existing data environments. Successful organizations are investing with an eye towards extending value and not looking to “replace” but augment current data infrastructure investments.
we are focused on integrating existing SQL infrastructure WITH NoSQL extensions to ensure our clients get the most out of their investment dollars. To support this with our PostgreSQL clients we have created BigSQL ( www.bigsql.org
). This open source distribution includes both SQL (PostgreSQL) and NoSQL (Hadoop) and extensions to smooth data integration across both stacks.