Gartner recently released their 2014 Magic Quadrant for Data Warehouse Database Management Systems, and perhaps not surprisingly, it describes both the rising influence of big data and cloud, as well as the investment by traditional vendors into their data warehouse offerings.
Let’s point out a few interesting points from that analysis
Delivery of stand-alone DBMS software continues to be challenged by cloud solutions, especially Amazon Web Services. According to Gartner’s research AWS gets the highest customer satisfaction scores, and it’s quick to deploy, while keeping costs low and the ability to scale easily. One nice thing to remember is,Amazon Redshift is based upon relational databases. From the Amazon website: “Redshift uses standard PostgreSQL JDBC and ODBC drivers, allowing you to use a wide range of familiar SQL clients.”
Tip: If you’re thinking about moving your data to the cloud, check out Wired's analysis.
The traditional vendors like IBM and Oracle remain close to each other in the leaders quadrant. However, instead of offering disruptive technologies, they’re re-investing in their current offerings to provide reliable products for the mainstream market. Among the leaders, Teradata remains ahead of the pack.
Here are the most interesting notes about each leading vendor:
“Customers report a low count of software issues, above-average customer experience and obvious interoperability with Excel (and Office).They also like the easy-to-understand licensing and pricing — adding to execution.”
“Oracle is consistently shortlisted in Gartner data warehouse competitive inquiries. In 2013, however, we saw an increase in the number of customers introducing competitors during scaling challenges (as the warehouse grows), but most decided to stay with Oracle.”
“Oracle continues to be the relational DBMS market share leader (Gartner estimates over 42% of the market in 2013), and good execution in the data warehouse market. Customers mention Oracle's strong overall viability.”
“IBM offers all five form factors for data warehouses: software only, managed services, appliances, cloud and reference architectures. IBM partnerships and channels are highly prolific in terms of ability to provide local support. IBM utilizes direct staff, distributors and partners.”
“Teradata continues to demonstrate its consistent ability to deliver on market trends, reliably meeting customer demand; for example, the Teradata Intelligent Memory option (Teradata's IMDBMS) was delivered in 2013.”
We believe that over the next few years, analysts, developers and managers within Business Intelligence will ask for more from their tools, and Gartner seems to agree with us:
“As we progress toward 2016, this new generation of analytics developers and their managers will realize their implementations need advanced tools for production management and maintenance.”
Our tool, SQLdep, is designed to solve one of the challenges associated with handling large data sets: missing data lineage and unclear impact analysis. We believe that SQL is the simplest way to query large data sets, and with a better understanding of your underlying database and data warehouse structures, you will be able to gain more from your data. SQLdep enables better metadata management & always up-to-date documentation, to speed up your bugfixing and bring clarity to your reporting.