Powerful Databases Change BI's Footprint - InformationWeek
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
How Enterprises Are Attacking the IT Security Enterprise
How Enterprises Are Attacking the IT Security Enterprise
To learn more about what organizations are doing to tackle attacks and threats we surveyed a group of 300 IT and infosec professionals to find out what their biggest IT security challenges are and what they're doing to defend against today's threats. Download the report to see what they're saying.
Register for InformationWeek Newsletters
White Papers
Current Issue
IT Success = Storage & Data Center Performance
Balancing legacy infrastructure with emerging technologies requires laying a solid foundation that delivers flexibility, scalability, and efficiency. Learn what the most pressing issues are, how to incorporate advances like software-defined storage, and strategies for streamlining the data center.
Twitter Feed
InformationWeek Radio
Archived InformationWeek Radio
Join us for a roundup of the top stories on InformationWeek.com for the week of November 6, 2016. We'll be talking with the InformationWeek.com 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.
Flash Poll