Software // Information Management
Commentary
12/6/2010
10:00 AM
Doug Henschen
Doug Henschen
Commentary
Connect Directly
LinkedIn
Twitter
Google+
RSS
E-Mail
50%
50%

Powerful Databases Change BI's Footprint

In-database analytics and in-memory computing should slim down business intelligence suites.

Even without the in-database analytics and in-memory computing trends, there are those who believe BI should be a thin skin for analysis and visualization, and not a big, weighty suite that introduces redundant information management.

(Practitioner Peter Green of Pfizer asked important questions about where to handle data management before developing the "thin BI" application discussed in this story.)

If you can get your processing power from the database, the crux of the question for BI system buyers is, why would you buy yet more expensive, high-powered servers to run a BI platform? And why would you and take the time and effort to move data into yet another environment?

An Aster Data-Tableau partnership announced last week provides an example of such a combination. Aster Data is an MPP database with a strong-and-growing in-database-analytics story. Tableau provides a popular data visualization environment that is both fast and intuitive for business users. When you put the two together, Aster handles the analytics and querying inside the database while Tableau does the slicing, dicing, data visualization and reporting.

Interestingly, Tableau's recent 6.0 release gives you the option of using a built-in, in-memory database, but Tableau has wisely maintained the flexibility to use its software as a lightweight front-end visualization tool. In this case, lightweight is a good thing, as in minimal processing power and infrastructure required.

With today's databases running on powerful appliances and hardware configurations, it only makes sense to move the processing-intensive query, scoring, and other analytic crunching steps into the database. That's why the likes of Aster Data, IBM Netezza, Teradata and others are moving into in-database analytics.

If we add in the in-memory computing trend -- something SAP, Kognitio, SAS, Microsoft and others are now pursuing -- then BI vendors (even those with their own in-memory products) could focus strictly on usability and let the database support querying and massive data exploration.

We're not quite there yet. But we're seeing the promise of a simplified environment with less redundancy, less cost, better performance and greater usability for all.

Previous
2 of 2
Next
Comment  | 
Print  | 
More Insights
The Agile Archive
The Agile Archive
When it comes to managing data, donít look at backup and archiving systems as burdens and cost centers. A well-designed archive can enhance data protection and restores, ease search and e-discovery efforts, and save money by intelligently moving data from expensive primary storage systems.
Register for InformationWeek Newsletters
White Papers
Current Issue
InformationWeek Tech Digest September 18, 2014
Enterprise social network success starts and ends with integration. Here's how to finally make collaboration click.
Flash Poll
Video
Slideshows
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
The weekly wrap-up of the top stories from InformationWeek.com this week.
Sponsored Live Streaming Video
Everything You've Been Told About Mobility Is Wrong
Attend this video symposium with Sean Wisdom, Global Director of Mobility Solutions, and learn about how you can harness powerful new products to mobilize your business potential.