Palo (OLAP database)
From Wikipedia, the free encyclopedia
Palo is a memory resident multidimensional (OLAP or MOLAP) database server. This type of database is particularly suitable to handle complex data models for business management and statistics. Apart from multidimensional queries, data can also be written back and consolidated real-time. In order to give rapid access to all data, Palo stores them in the memory during run time. The server is Open Source and there is a free Add-In for Microsoft Excel. Palo can also be integrated into other systems via its Java, PHP, C and .NET interfaces.
Palo is typically used as a Business Intelligence tool for Controlling and Budgeting purposes with Microsoft Excel as a user interface. Beyond the multidimensional data concept, Palo enables multiple users to share one centralised data storage ("Single version of the truth").
Palo is being developed by Jedox, a company based in Freiburg (Germany).
[edit] References
- Bernd Held, Hartmut Erb: Advanced Controlling mit Excel. Unternehmenssteuerung mit OLAP und PALO, m. CD-ROM., Franzis, Poing 2006, ISBN 978-3-7723-7585-9 (in German)
- Evaluation Guide - Documentation to Palo (pdf) in the download section of the website
- Interview with Kristian Raue - CEO of Jedox about Palo
- Business Intelligence: One Version of the Truth ComputerWorld, Julia King, 2003-12-22
- Announcing Enterprise Excel Exceluser.com, Charley Kyd, Dec 2006
[edit] External links
- Palo - Open-Source MOLAP Server for Windows/Linux and Microsoft Excel interface, documentation, demos and forum
- JPalo - Java software for Palo
- Palo on sourceforge.net - Source Code of Palo