It's all In the Memory: New Battleground for BI and Analytics
By Mark Dexter
28th September 2011

While the development of large-memory computing is not really new, it took a while for the software industry to adapt to 64-bit hardware processing and operating system platforms. Throw in the difficult learning curve for creating software to work with parallel processing, and it’s easy to see why the move from older systems has taken time. When large memory and parallel processing platforms were exotic, the slow pace of adaptation might have been acceptable. Now, with mainstream systems offering up to a terabyte of addressable memory, organizations can’t wait to try them out for BI and analytics.

Traditionally, designers of these systems have had to adjust to the limits of the I/O bottleneck. The preprocessing and design work for indexing and aggregating data has been necessary because of the performance constraints involved in getting data from disk through the I/O bottleneck. If large memory systems can ease or eliminate that constraint for the majority of users’ analysis needs, then the boundaries for analytics applications can be pushed out.

Users can perform “data discovery,” asking questions that lead to more questions, without as much concern for what this iterative, ad hoc style of investigation might mean to overall performance. Unlike with BI reports that simply update standard views of data, users can engage in exploratory data inquiries without knowing exactly where they will end up. Large-memory systems can offer volumes of detailed data on systems deployed closer to users. With the right tools, line-of-business (LOB) decision makers can dive into the data to test predictive models and perform fine-grained analysis on their own rather than wait for IT’s specialized business analysts and statisticians to do it for them.

Data discovery vendors such as QlikTech, Tableau, and TIBCO Spotfire have prospered by jumping first to seize market opportunities. However, the biggest coming battle may be between SAP and Oracle. Earlier this year, SAP introduced HANA, which competes with Oracle’s Exadata by offering in-memory analytics along with traditional disk-based storage in an appliance. Oracle has been readying a response, which will most likely come at Oracle Open World in early October and be aimed at taking in-memory capabilities for BI and analytics further. In the coming year, Oracle and SAP will battle to show which vendor is better at using analytics to increase the business value of ERP investments. In-memory capabilities will make it easier for these and other vendors to deploy rich analytics for ERP that are tailored to vertical industry and LOB requirements.

Large memory is not the whole story when it comes to the future of BI and analytics. However, it is a technology trend that users will notice firsthand through deeper, more visual, and more timely data analysis.

Read at source: TDWI

Comments

Currently there are no comments. Be the first to post one!

Post Comment

*
*
*

How far does data and analytics go and what can it do for you or your business?

Having worked in recruitment for a number of years I have recently joined KDR Recruitment focusing within the Data Analytics sector. I have always been a fan of analysing the finer details to my work but what I have learned... Read More

Is technology impacting the way we apply for jobs?

Technology is having an impact on every aspect of our lives, and no less in our job search. Tech is not just changing the way I, as a recruiter, find the best candidates for a role but also how the... Read More

Is SSRS dying?

Experience with the Microsoft BI full stack (SSIS, SSAS, SSRS) is in incredibly high demand with many organisations working with a heavy Microsoft tech stack, however nothing causes more controversy than one particular service in that stack; questioning the future... Read More

Data and Formula E

Upon a brief search of the web, you will find tons and tons of blogs relating to how data is used in Formula 1 , but what about its younger brother, Formula E? I was genuinely surprised at the lack of... Read More

Where should we send our newsletter?

Close