Targeting the Best of Both Worlds with Next-generation SQL Databases

Conventional relational databases and recently-developed NoSQL databases have led some enterprises to an impasse. They want to scale the systems that are handling their data. However, an RDBMS used to guarantee transaction integrity is difficult to expand. NoSQL systems, although scalable, typically do not offer full transaction integrity via the ACID properties discussed in earlier posts. The latest solution in the SQL/NoSQL saga—next-generation SQL databases—may have the answer.

Topics: Big Data Data Management database rdbms NoSQL SQL ESG Lab

NoSQL - The Great Escape from SQL and Normalization

For the last decade or so, data and data structures have been moving at the speed of the web. They change rapidly to keep pace with end-users and markets that are in constant flux. The data model is volatile and will continue to be as more and more unstructured data (images, videos, social media content, online purchase histories, and more) is generated. The solution of the pre-Internet era, meaning the RDBMS, can’t keep up. Enter the NoSQL database—a solution for handling data with highly variable formats in massive quantities at lightning speeds.

Topics: Big Data Data Management database rdbms NoSQL SQL ESG Lab

Why Won’t the RDBMS Go Away?

The relational database management system was a breakthrough when it first appeared about 40 years ago. A relational database puts power into a user’s hands. Few assumptions are needed about how data is related or how it is to be extracted. Data can then be viewed in a variety of ways, each one illustrating different connections or correlations. This power, history, and a little user inertia have led to the RDBMS being implanted and used in practically every sector of business today. Well-known RDBMS product examples are IBM DB2, Microsoft SQL Server, and Oracle databases.

Topics: Big Data Data Management database rdbms NoSQL SQL ESG Lab

Today’s Database Landscape at a 50,000 Foot Level

We all know the drill—data is exploding in size, but it’s not just the volume of data that is wreaking havoc on organizations. It’s how quickly it’s growing, how many different forms it can take, and how it’s constantly changing. And that’s just scratching the surface. How can the potential of data truly be harnessed? The database technologies for organizing the data that we generate and manipulate continue to morph and multiply. The hugely successful relational database management systems (RDBMSs) continue to soldier on using principles now over 40 years old, while newer database technologies have come along and been widely adopted to address specific needs in the data storage, management, and analytics space. Over the next few weeks, I’ll be going through the evolution of database technology at a 50,000 foot level to highlight the old and the new, how they’re used today, and what vendors to keep an eye on.

Topics: Big Data Data Management database rdbms NoSQL SQL ESG Lab

Oracle Strikes Back

IT is a global game of king of the mountain. The view is lovely from the top, but everyone else is looking to pull you down with new innovations in products, better services, and disruptive go-to-market strategies. Oracle has long held the crown for databases and a number of related business applications, yet is surely feeling some pressure from the ravenous hordes below. Two popular angles of attack have been in-memory and/or NoSQL databases. The goal of players such as Amazon (with DynamoDB), Apache Cassandra, MemSQL, MarkLogic, MongoDB, NuoDB, and many others has been to differentiate on the capabilities of their newer platforms to hopefully displace, or more likely find a niche alongside, the popular Oracle database. Even other industry titans like IBM (with DB2 BLU Acceleration) and Microsoft (with SQL Server 2014) have brought in-memory options to market with great fanfare.

Topics: IBM Microsoft Big Data Hadoop Enterprise Software Data Management Oracle Amazon NoSQL Cloudera Apache MemSQL MongoDB

Actian Means Big Data Action, Must Pursue Big Data Execution

Actian Corporation ("Actian"), with backing from Garnett & Helfrich Capital, stands alone as the big data vendor with the bravado to charge down the acquisition path towards big data critical mass. Between start-up business intelligence ("BI")/analytics vendors, and Not Only SQL ("NoSQL") database vendors, other venture capital firms have invested roughly $1.5 billion in early stage big data related vendors. While large, established vendors playing in big data have made major acquisitions and investments down through the years, such as Microsoft, IBM, Oracle, SAP, SAS, and Teradata, not even these major players have placed, proportionally speaking, such a big bet on big data as Actian.

The capstone to Actian's big data buying blitz happened last week with the announcement of the immediate acquisition of ParAccel, a leading MPP NoSQL database/advanced analytics solution. A mere month ago in a report I authored on the BI/analytics platforms, I wrote the following excerpt regarding ParAccel:

Topics: Big Data Enterprise Software Data Management NoSQL

Defining Big Data Security Analytics

At the end of 2012, ESG conducted a research project looking at big data security analytics from the demand-side. It turns out that market demand is already apparent -- 44% of enterprise organizations consider their security analytics “big data” today, while another 44% believe that their security analytics requirements will be regarded as “big data” within the next two years.

Okay, enterprise organizations need big data security analytics solutions today; but just what is a “big data security analytics” solution anyway? ESG just published a market landscape report to answer this very question by looking at the supply side to gauge existing solutions and future directions for big data security analytics.

Topics: IBM Big Data Hadoop Information and Risk Management Security and Privacy Security NoSQL big data security analytics SIEM Narus LogRhythm RSA Security Solera Networks Cassandra Lancope click security Splunk Packetloop RedLambda

At Least a Billion Good Reasons to Pay Attention to Not Only SQL Databases

We just published an in-depth market landscape report called Beyond RDBMS: Not Only SQL Challenges the Status Quo. While the full report is only available to private customers, here is an infographic that highlights some of the key findings about the nature of the Not Only SQL database market.

Topics: IBM Microsoft EMC Enterprise Software Data Management database Oracle google NoSQL Teradata sap MongoDB aster Amazon Web Services 10gen Greenplum

Giving Thanks for Versant and Actian

Giving Thanks for Versant and Actian

Topics: IBM Big Data Enterprise Software Data Management database NoSQL unicom

Oracle Changes the Changing Database Game

I am preparing a market landscape report about the many, comfortably over 20, not-only-SQL commercial database options available in the market. By not-only-SQL I mean databases that do not fit neatly into the classic RDBMS category; classic RDBMS includes product lines such as Oracle Database (11g and predecessors), IBM DB2, Microsoft SQL Server, Sybase SQL Server (SAP), mySQL (Oracle), etc.

Topics: Cloud Computing cloud Private Cloud Infrastructure Enterprise Software Data Management database Oracle NoSQL appliance