« WMINo Aloe Vera Here »

Open Source BI

05/12/05 | by Joseph A. di Paolantonio [mail] | Categories: Supporting IT, Open Source, Open Source, Open Source, Data Management, Business Intelligence

We [Clarise and I] met with Bernard Golden, The CEO of Navica, again. One of the topics of conversation brought together our work in Business Intelligence and Open Source. Bernard's background includes Informix and our's includes Oracle :) [No rivalry though] All three of us have worked on large system integration projects requiring strict data modeling and centered around the RDBMS, ETL, EAI, OLTP and OLAP tools selected to best meet the business needs. Clarise and I have worked with Jetstream [ETL & EAI], Mondrian with JPivot [OLAP].

One of the most important aspects of a BI project is the implementing the business process and best practices for the users. Determining what that really means is key to the success of such projects. Do the current business processes implement best practices for that industry, giving the organization a competitive edge, but needing better implementation from IT? Are the best practices implemented in a COTS BI suite better than the organization's current business processes? This is at the heart of most "build versus buy" decisions.

And this is one advantage that open source packages may have over buying a proprietary solution that implements the vendor's version of BI best practices for a given industry or vertical. Open Source can be more cost effectively customized to implement those processes and practices that your organization views as giving a competitive advantage.

By the way, Bernard gave us a copy of his book, Succeeding with Open SourceBook Cover Image for Succedding with Open Source.

Trackback address for this post

Trackback URL (right click and copy shortcut/link location)

4 comments

Comment from: Thomas [Visitor] · http://www.zetvisions.com
Did you already had a look at BIRT? (http://www.eclipse.org/birt/)
07/25/05 @ 06:42
Comment from: John [Visitor] · http://www.palo.net
Mondrian is a nice program with support for MDX and if run on a RDMS such as oracle which supports materialised view can really fly in speed terms.

I recommend you have a look at PALO (www.palo.net or www.opensourceolap.com)
an open source olap server.
Palo is RAM based (but obviously load data into memory at startup and writes data back to files for persistency) so performance is good. Palo should work on 64 bit windows and Linux machines (so large amounts of data can be held in memory).
A major advantage of PALO is that it can write values directly to memory, ideal for planning and "what if" alalysis and calculations are performed in real time. Real time OLAP systems tend to have smaller models (since every combination in the cube doesn't need to be calculated - therefore you tend not to have problems such as "database explosion")
I recommend any business intelligence practitioner or end user download it have a go.
10/28/05 @ 14:19
Comment from: Joseph A. di Paolantonio [Member] Email · http://press.teleinteractive.net
John,

thank you for stopping by. We have been investigating PALO, in relation to our new book project, Open Source Business Intelligence.

You can see the OSS linkblog for a list of the projects we've looked at so far.
10/29/05 @ 10:52
Comment from: lawuit [Visitor]
Wenfengli touted his BIRT a lot. Let's look at the background behind that...

Wenfeng li incured a huge lawsuit with his previous employer and brought a huge lose in lawsuit money to Actuate. Actuate has to layoff several times.

Then wenfeng li pushed to China. BIRT is his last desperate resort to build his force in Actuate. However, wenfeng li( PMC lead as he named himself )
doesn't really have much experience in Java technology.

Essentially Wenfeng li is wasting Actuate's money and resources to gain huge benefits for himself. At the same time to develop a very inferior product and call it a "massive success" and continue to add version number to that...
09/13/06 @ 13:42

Leave a comment


Your email address will not be revealed on this site.

Your URL will be displayed.
(Line breaks become <br />)
(Name, email & website)
(Allow users to contact you through a message form (your email will not be revealed.)
December 2008
Mon Tue Wed Thu Fri Sat Sun
 << <   > >>
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31        

This Web Log (Blog) is intended as a discussion of the business processes, life choices, management challenges, wireless networks, mobile devices, collaboration software, social networks and technical issues facing organizations and individuals: distributed workgroups, digital lifestyle aggregation, telecommuting, road warrior and all ways in which you can live the TeleInterActive Lifestyle™. It is a service of InterActive Systems & Consulting, Inc.

InterActive Systems & Consulting, Inc. (IASC) performs research in the areas of data analytics, collaboration and remote access.

InterASC Professional Services, a service mark of IASC, provides strategic consulting and project management for data warehousing, business intelligence and collaboration projects using proprietary and open source solutions. We formulate vendor-independent strategies and solutions for information management in an increasingly complex and distributed business environment, allowing secure data analysis and collaboration that provides enterprise information in the most valuable form to the right person, whenever and wherever needed.

TeleInterActive Networks, a service mark of IASC, hosts open source applications for small and medium enterprises including CMS, blogs, wikis, database applications, portals and mobile access. We provide the tools for SME to put their customer at the center of their business, and leverage information management in a way previously reserved for larger organizations.

37.540686772871 -122.516149406889

Search

Blogroll

  • TIA Life

XML Feeds

Powered by b2evolution