Open And Shut - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

Software // Information Management
07:51 PM
Connect Directly

Open And Shut

Analytics: The next stop for open source?

The value and utilization of open-source software have grown immensely in recent years, but in the booming analytics market, open source is strangely not keeping pace. A variety of projects are out there—search open-source nexus for "OLAP" or "reporting," and you'll find dozens. Unfortunately, many of these attempts seem amateurish, more intentions than anything approaching commercial-grade products. The projects that do appear worth a trial run boast only niche rather than broad-market appeal. Nonetheless, they do suggest far greater future adoption of open source for decision systems.

Where's the Linux OLAP?

First and foremost is Mondrian, an open-source OLAP server that accesses relational databases and supports Microsoft's Multidimensional Expressions (MDX) language, as well as the Java OLAP (JOLAP) and XML for Analysis application programming interfaces (APIs). A companion project, JPivot, provides a Java Server Page (JSP) tag library for tables and charts and acts as a Mondrian client. "The feedback I get from users is that they love how simple JPivot is to configure—just write a simple XML file or use the Eclipse plug-in," says lead developer Julian Hyde. "They love the JPivot user interface, and they find it fits seamlessly into their Web applications."

Nigel Pendse, lead author of the "OLAP Report," has found that despite OLAP-vendor Linux support dating back several years, only 2 to 3 percent of the overall OLAP market runs OLAP on Linux.

But let's shift focus to analytics' high-performance computing (HPC) cutting edge, where open source dominates and users program their own analytics rather than looking to buy off the shelf. For those users, performance, reliability and scalability count far more than commercial branding. To succeed, open-source business analytics applications must appeal to that same class of exacting user by providing a similar platform for serious innovation.

A Product and a Process

The JPivot plug-in for Eclipse—an open tool-integration platform—that Mondrian developer Hyde mentioned is the tip of the iceberg. Companies including IBM, Ilog, Oracle and SAS have joined the Eclipse Consortium, and reporting vendor Actuate will steward the new Eclipse Business Intelligence and Reporting Tools (BIRT) Project ( But with far less visibility and little press coverage, the R computing system ( and a number of related open-source data mining efforts are already winning users over.

R is an open-source implementation of the S statistical programming language. It provides an excellent environment for exploratory data analysis and visualization. Health-care consultant Marc Schwartz says that R has advanced "under the leadership of some of the best minds in the business." A biotechnology research statistician told me that R and its associated contributed packages "simply can't be beat in terms of data analytic and static data visualization capabilities." Others have told me how easy it is to build Windows and Web interfaces for R and also to integrate R and software developed with other languages and environments.

The folks behind the free Open Office productivity application suite say that via open source, they offer "not only a product, but a process." Their mission is to create an office suite that will run on all major platforms and provide access to all functionality and data through open-component-based APIs and an XML-based file format. (Open Office is a worthy product, too, one I use myself except when third-party spreadsheet functions I need are exclusive to Microsoft Excel.) Australian research psychologist and R user Jim Lemon is on board; he likes the idea of a "cooperative effort to produce a stats-oriented programming language."

I see the open-source process changing the way we perform decision support by providing a platform that encourages end-user participation and supports collaborative innovation. Mainstream analytics will evolve slowly and perhaps incompletely toward this model. Open-source platform tools, HPC, R and similar successes will show the way.

SETH GRIMES is a principal of Alta Plana Corp., a Washington, D.C.-based consultancy specializing in large-scale analytic computing systems.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
InformationWeek Is Getting an Upgrade!

Find out more about our plans to improve the look, functionality, and performance of the InformationWeek site in the coming months.

10 Things Your Artificial Intelligence Initiative Needs to Succeed
Lisa Morgan, Freelance Writer,  4/20/2021
Tech Spending Climbs as Digital Business Initiatives Grow
Jessica Davis, Senior Editor, Enterprise Apps,  4/22/2021
Optimizing the CIO and CFO Relationship
Mary E. Shacklett, Technology commentator and President of Transworld Data,  4/13/2021
White Papers
Register for InformationWeek Newsletters
Current Issue
Planning Your Digital Transformation Roadmap
Download this report to learn about the latest technologies and best practices or ensuring a successful transition from outdated business transformation tactics.
Flash Poll