Software // Information Management
10:00 AM
Doug Henschen
Doug Henschen
Connect Directly

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.

2 of 2
Comment  | 
Print  | 
More Insights
Newest First  |  Oldest First  |  Threaded View
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
Top IT Trends to Watch in Financial Services
IT pros at banks, investment houses, insurance companies, and other financial services organizations are focused on a range of issues, from peer-to-peer lending to cybersecurity to performance, agility, and compliance. It all matters.
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on for the week of August 21, 2016. We'll be talking with the editors and correspondents who brought you the top stories of the week to get the "story behind the story."
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.