"Evaluating columnar databases" is now available at Fast Market Research

April 17, 2010 - PRLog -- 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.

For more information or to purchase this report, go to:
-  http://www.fastmr.com/prod/58176_evaluating_columnar_data...

Report Table of Contents:

SUMMARY
Impact
Ovum view
Key messages
THE ANALYTIC CASE FOR COLUMNAR DATABASES
Optimized for business questions
The business benefits
Faster performance
Storage efficiency
Lowered DBA costs
Increased analytic productivity
CHOOSING THE RIGHT COLUMNAR DATABASE
A once-sleepy market is getting noisy
A practical evaluation model
Analytic performance
Data and end-user scalability
Data load times
Range of analytic functions
Data schema flexibility
Data access techniques
Data type support
Database administration overhead
System availability
ALTERNATIVE VIEWS
The counter-argument
Other analytic options to consider
In-memory databases
Vector databases
Database appliances
OLAP accelerators
Database clustering
Data-matching systems
Adaptive indexing
Associative databases
Others
RECOMMENDATIONS
Recommendations for enterprises
Consider performance trade-offs between queries and data loads
Target query-intensive applications
Be realistic about size
Rows are here to stay
Make the columnar system a good BI citizen
Expect some resistance from IT
APPENDIX
Further reading
Methodology

List of Tables
Table 1:  Ovum taxonomy of columnar database providers
Table 2:  Benefits of columnar databases


List of Figures
Figure 1:  Structural differences between row- and column-based data

About Ovum

Ovum fully understands convergence across telecoms, IT services and software. They invest heavily in researching what is happening in a market that is dynamic and full of risk and reward, analysing the changes and identify the threats and opportunities ahead for their clients. Ovum's team has extensive experience in the sector and is dedicated to 'getting closer' - to the industries they advise on, to the people they work for, and ultimately to the real issues determining how ICT markets behave. Ovum maintains a fluid, highly collaborative structure that brings the right range of expertise to each situation.  View more research from Ovum at http://www.fastmr.com/catalog/publishers.aspx?pubid=1006

About Fast Market Research

Fast Market Research is an online aggregator and distributor of market research and business information. We represent the world's top research publishers and analysts and provide quick and easy access to the best competitive intelligence available.

For more information about these or related research reports, please visit our website at http://www.fastmr.com or call us at 1.800.844.8156.