有什么开源工具和技术来构建完整的数据仓库平台? [英] What are the open source tools and techniques to build a complete data warehouse platform?
问题描述
我正在寻找可能是免费的或具有免费试用版的开放源代码工具，以建立完整的数据仓库堆栈.
I'm looking for these open source tools possibly free or with free trial version to set up complete data warehouse stack.
我知道一些像 Pentaho 这样的开源Mondrian服务器，但无法获取任何Google结果进行设置完整的平台.我不确定这些组件是否相互兼容?有人可以列出他们以及他们在链中的位置吗?
I know about few like Pentaho open source Mondrian server, but couldn't get any google result to setup complete platform. I'm not sure whether these components are compatible with each other? Could someone please list them along with their position in the chain?
推荐答案
The Open Source Data Warehousing does a great job at identifying OSS components that could be used to build a Data Warehouse stack: Infrastructure (servers, OS, databases), Integration Management (ETL, EAI, etc), Information Management (DW/Mart/ODS, OLap Servers, etc), Information Delivery (Portal, Dashboard, Analytics/OLAP Client, etc). Here is a summary:
开源BI/DW项目
BI和Analytics
- BEE- http://bee.insightstrategy.cz/en/index.html
- BIRT- http://www.eclipse.org/birt
- JasperSoft – http://www.jaspersoft.com
- MarvelIT- http://www.marvelit.com/dash.html
- OpenI – http://openi.sourceforge.net
- OpenReports – http://oreports.com
- 橙色- http://www.ailab.si/orange
- Palo – http://www.palo.net
- Pentaho- http://www.pentaho.com
- R- http://www.r-project.org
- SpagoBI – http://spagobi.eng.it
- Weka- http://www.cs.waikato.ac.nz /~ml/index.html
- VitalSigns- http://vitalsigns.sourceforge.net/
Open Source BI/DW Projects
BI and Analytics
- BEE - http://bee.insightstrategy.cz/en/index.html
- BIRT - http://www.eclipse.org/birt
- JasperSoft – http://www.jaspersoft.com
- MarvelIT - http://www.marvelit.com/dash.html
- OpenI – http://openi.sourceforge.net
- OpenReports – http://oreports.com
- Orange - http://www.ailab.si/orange
- Palo – http://www.palo.net
- Pentaho - http://www.pentaho.com
- R - http://www.r-project.org
- SpagoBI – http://spagobi.eng.it
- Weka - http://www.cs.waikato.ac.nz/~ml/index.html
- VitalSigns - http://vitalsigns.sourceforge.net/
- http://greenplum.org (bizgres)
- http://www.ingres.com
- http://www.mysql.com
- http://www.postgresql.org
- http://www.enterprisedb.com
- http://greenplum.org (bizgres)
- http://www.ingres.com
- http://www.mysql.com
- http://www.postgresql.org
- http://www.enterprisedb.com
- Apatar- http://www.apatar.com
- CloverETL- http://cloveretl.berlios.de/
- JitterBit- http://www.jitterbit.com/
- KETL- http://www.ketl.org
- 章鱼- http://www.enhydra.org/tech/octopus/index. html
- OSDQ- http://sourceforge.net/projects/dataquality
- Pentaho- http://www.pentaho.com
- Red Hat – http://www.redhat.com
- Saga.M31 Galaxy- http://galaxy.sagadc.com
- Talend- http://www.talend.com
- SnapLogic – http://www.snaplogic.com
- Apatar - http://www.apatar.com
- CloverETL - http://cloveretl.berlios.de/
- JitterBit - http://www.jitterbit.com/
- KETL - http://www.ketl.org
- Octopus - http://www.enhydra.org/tech/octopus/index.html
- OSDQ - http://sourceforge.net/projects/dataquality
- Pentaho - http://www.pentaho.com
- Red Hat – http://www.redhat.com
- Saga.M31 Galaxy - http://galaxy.sagadc.com
- Talend - http://www.talend.com
- SnapLogic – http://www.snaplogic.com
我建议浏览演示文稿.好东西.
I recommend browsing the presentation. Good stuff.
这篇关于有什么开源工具和技术来构建完整的数据仓库平台?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
