Today the notion of Open Source Business Intelligence conjures to mind open source report writers such as the commendable BIRT project. But today Business Intelligence encompasses more than just coming up with an open source competitor to Crystal Reports or SQL Server Reporting Services. A full stack BI has to consist of minimally:
- A content managment system
- Some kind of security scheme
- Relational reporting
- Query and Analysis
- Data Integration
- A Scheduling Framework
- A Distribution Framework
- A Presentation Layer
An Open Source BI project would be enormous, and I would imagine quite contentious. More promising perhaps would be an Open Source approach to Business Intelligence. A possible combination of technologies for providing a practice around an open stack might include:
- Apache Jackrabbit as the CMS
- Spring Framework and maybe Hibernate for Data Integration, Q&A and distribution
- MySQL for relational data and even analytical ROLAP
- Quartz for scheduling (again probably with spring)
- BIRT for relational reporting
- A whole mix of presentation techologies (Flex, SVG, XSLT, XHTML/CSS, HTML Canvas, Flash)
What else? I know my list above is pretty Java-heavy and there are obvious LAMP alternatives, Plone for the CMS, perhaps. What's missing from this list? Have I listed parts of the stack that you don't think are required? (I know I have some doubts about the absolute necessity of a CMS). Finally, who else is working on this?
__
No comments:
Post a Comment