|
|
 |
|
Viewing report
|
|
|
|
Evaluating Columnar Databases
Ovum, March 2010, Pages: 21
The market for columnar databases was once a narrow niche that played a distant second to traditional row-based relational databases, as espoused by Oracle, IBM, Sybase, Microsoft, and others. However, organizations seeking to speed up data query and access are now looking more closely at this technology to meet the increased pressures put on business analytics - namely, performance and speed to insight. The exponential growth of data warehouses - from gigabytes to terabytes and even petabytes - is starting to take its toll on query performance. That is hindering companies from deeper analysis of their business data for fear of “runaway queries from hell” that take all night to process. To address this problem, columnar databases optimized for data analytics are now in development, and organizations are starting to implement them as an alternative or adjunct to data warehouses traditionally built around relational data structure constraints.
This report aims to introduce the basic concepts and benefits of columnar databases in a straightforward manner. Its value proposition should be balanced against limitations of the technology, and organizations should guard against swallowing vendor rhetoric. Hence, this report also presents a multidimensional evaluation model that highlights the key functional considerations that organizations should look out for when choosing a columnar database for analytics. It is important to remember that while columnar databases are applicable to several data problems, there are situations to which they are not suited. The report ends by providing practical advice for both IT end-user organizations thinking of buying and implementing a columnar database, and IT vendors developing and selling these systems.
Customers who bought this item also bought
Business Intelligence IT Strategy Report
Enterprise Search Technology Evaluation Report
Getting more from your data with predictive analytics
The BI Market Guide (3rd Edition)
Vertica Systems - Rowing Against the Tide
Identity and Access Management 2011-12 (Technology Evaluation and Comparison Report)
Exploiting IT management-as-a-service
Fundamentals of Database Management Systems, 2nd Edition
Best practices for evaluating data quality tools
Data Warehousing Fundamentals for IT Professionals, 2nd Edition
|
|
|
|
