Home > Data management / BI News > Gartner ranks data warehouse software, DBMS market leaders
Data management / BI News:
EMAIL THIS

Gartner ranks data warehouse software, DBMS market leaders

By Hannah Smalltree, News Writer
25 Sep 2006 | SearchDataManagement.com

News on data management trends and technology
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google

Things have changed since Gartner last published its Magic Quadrant for data warehouse and database management systems (DBMS) two years ago, an eternity in technology terms.

The 2006 version, released this month, reveals some telling trends, according to study author Mark Beyer, research director with the Stamford, Conn.-based analyst firm. Thanks to drivers like regulatory compliance and increased tactical use of business intelligence, data warehouses and DBMS systems must accommodate mixed workloads of analytic, operational and transactional functions. "Appliances," or bundled hardware and software configurations designed for specific data analysis tasks, were just emerging two years ago. Now, appliances, which tend to be faster to implement and cost less, are changing the market and putting new pressures on established leaders. And leaders have updated their pricing strategies, Beyer said, creating a better buying environment for customers.

Using Gartner's Magic Quadrant methodology, Beyer examined a host of vendors, arranging them into four categories: leaders, challengers, visionaries and niche players. Vendors are evaluated based on a combination of technical vision and ability to execute at customer sites.

For more on data warehousing and database management systems
Learn why a TDWI speaker said expensive data warehouses aren't always necessary for business intelligence

Get expert advice in this tip about building, or just renovating, a data warehouse
Leaders excel in both vision and execution. This year's leaders' quadrant includes NCR Teradata, IBM and Oracle in the top three spots. It's a slight change in order from 2004, when Oracle's unique willingness to publish its price list had helped place it on top, Beyer noted. Now, all leaders are responding to market pricing pressures by publishing price lists and offering more discounts, rather than just giving customized deal quotes as they had in the past.

This year's challengers, which get high marks for execution but lack vision, were Sybase and Microsoft. The software giant straddled the leadership line, Beyer said, and it may emerge as a leader, pending more data about SQL Server 2005.

"SQL Server 2005 is a good challenging product. Microsoft, of course, can execute, but now we need to wait and see if it lives up to its vision," Beyer said.

The quadrant's visionaries have notable technology but less proof of execution, while niche players are worthy of note but need improvement in both areas. The niche quadrant included U.K-based Kognitio Ltd.; Swedish MySQL AB; and Westmount, Quebec-based Sand Technology Inc., none of which appeared in the study two years ago. The sole niche player two years ago, Framingham, Mass.-based Netezza Corp., has made it to the visionaries quadrant, along with Aliso Viejo, Calif.-based Datallegro Inc.

The visionaries have notably increased pressures on the leaders with their lower-priced appliances, Beyer said. But it's not that they have overwhelming market share, he explained. Rather, the smaller vendors proved that there's a market for preconfigured systems built with commodity-class hardware and open source databases. This has not gone unnoticed.

"Physics" helps appliance market heat up

IBM has built its own appliance. Oracle has joined with hardware partners to create "approved configurations," which similarly lower implementation costs, Beyer said. Teradata has always had an appliance-style, preconfigured system, albeit at the higher end of the cost scale. Whether appliances will rule the market remains to be seen, he said, but they've brought attention to the important issue of the "physics" of data warehouse and DBMS systems.

"The mixed workload of data warehouses means it's critical now to balance the physics of simply moving data through an electronic and digital environment, along with having a good design for your database," Beyer said.

The study identified different kinds of workloads or functions that a system may address, such as enterprise reporting, strategic data mining, tactical business intelligence, continuous data loading, batch loading and ad hoc queries. Enterprises usually require systems that can handle mixed workloads or different combinations of these functions, Beyer explained. This means that companies must choose hardware and software combinations that are appropriately configured and balanced for the required tasks. Whether they choose an appliance or full-blown system depends on their requirements.

Buying advice and other considerations

Traditional data warehouse and DBMS systems are highly configurable, so organizations can tune them for their unique needs. Appliances are generally purpose-built to address specific kinds of workloads, Beyer said. For example, an appliance for strategic analytics or data mining is configured differently than an appliance designed for operational, tactical business intelligence. Try to stretch the use of an appliance, and it probably won't perform as well.

"If you buy an appliance, use it for what it's intended," Beyer advised. "Don't use a blender to try and bake a cake."

Those purchasing a DBMS should understand that they're only buying software, and there are important physics and hardware issues to deal with as well, he said.

Tags: Data warehouse softwareDatabase management systems (DBMS) architecture and designVIEW ALL TAGS

Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Data warehouse software
Netezza looks to transform from 'a one-product company'
Microsoft details self-service business intelligence, data warehouse releases
Why pay for a data warehouse appliance when you can get one free?
In-database analytics pulls together SAS, data warehouse vendors
Teradata takes a logical approach to data warehousing appliances
BT taps open source BI software, homegrown DW to unlock customer data
Bill pushes for data warehouse, XBRL to track TARP funds
Teradata VP talks data warehouse appliances, reveals cloud and SSD plans
Data Warehouse Platforms Product Directory
Commodity hardware aiding data warehouse appliance performance, costs

Database management systems (DBMS) architecture and design
Definition of primary, super, foreign and candidate key in the DBMS
What is the difference between a logical and physical warehouse design?
What are some emerging data warehouse and DBMS trends?
Data Warehouse Platforms Product Directory
Designing for performance: Strategic database application deployments
An introduction to database transaction management
Database access security: network authentication or data encryption?
Executing SQL statements using prepared statements and statement pooling
Static SQL vs. dynamic SQL for database application performance
How to get data/database independence with a three-tier architecture

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
data modeling  (SearchDataManagement.com)
extract, transform, load  (SearchDataManagement.com)
OLAP  (SearchDataManagement.com)
tree structure  (SearchDataManagement.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Data Management: Business Intelligence, Data Integration, Data Compliance
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2005 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts