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 to fix a broken leg

You break your leg, what do you do? You go to the hospital. Right? You get it X-rayed, plastered up and wait for it to heal. When it twinges and you say “ohh my leg ain’t half hurtin’ today” (in... Read More

Are tech tests useful or just lazy?

For many businesses that are hiring software and tech specialists they can see a mass influx of candidates. Tech tests or exercises can be a great way to cut down the noise and find the person with the right skills.... Read More

How NOT to answer interview questions

Interviews are the most important part of the job searching process; it is what stands between you and your dream role. If you have a bad interview or answers a question badly you might be putting your next role at... Read More

How AI is personalising marketing

There is no question that artificial intelligence, machine learning and automation is changing the marketing function in many businesses. For many consumer brands these technologies are now they most effective way of communication with a customer.  As AI continues to... Read More

Where should we send our newsletter?

Close