Q

The basics of improving BI performance

Find some basic ways of improving BI performance at your company. Learn about in-memory analytics, columnar databases and how data aggregation affects BI performance.

What are some basic ways of improving BI performance?

If you mean the speed at which reports and other types of business intelligence data get to the users, there are several ways to improve that. 

The first option is to aggregate your data; that automatically produces better performance. In addition, you can scale back the amount of data you let users query and analyze. For example, even though you have 10 years of historical data in your data warehouse, only two years might be used for day-to-day analysis, with archived tables for the data from the other eight years. 

A popular approach these days is to use columnar databases vs. traditional databases with a row orientation.  Columnar software typically indexes and compresses data, which can significantly increase performance. 

In-memory analytics is another BI trend that leverages a system's memory cache to load, index and compress data, giving users access to high volumes of data with nearly instant response rates on queries. Those are some of the most common ways of improving BI performance.

This was first published in April 2011

Dig deeper on Business intelligence best practices

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchAWS

SearchContentManagement

SearchCRM

SearchOracle

SearchSAP

SearchSQLServer

Close