Palo (OLAP database)

Palo (OLAP database)

Palo is a memory resident multidimensional (OLAP or MOLAP) database server. This type of database is 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. There is a free Add-In for Microsoft Excel, with an open source Add-In for OpenOffice.org: [http://sourceforge.net/projects/palooca/ PalOOCa OpenOffice - Extension for Palo] . 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 a Spreadsheet used 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).

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)
* [http://www.jedox.com/en/enterprise-spreadsheet-server/excel-olap-server/palo-server.html Evaluation Guide] - Documentation to Palo (pdf) in the download section of the website
* [http://www.vectorspace.com/2006/08/03/raue_interview Interview with Kristian Raue] - CEO of Jedox about Palo
* [http://www.computerworld.com/databasetopics/data/story/0,10801,88349,00.html Business Intelligence: One Version of the Truth] "ComputerWorld", Julia King, 2003-12-22
* [http://www.exceluser.com/enterprise/enterprisexl.htm Announcing Enterprise Excel] "Exceluser.com", Charley Kyd, Dec 2006
* [http://www.b-eye-network.co.uk/view-articles/6759 "b-eye network" article] - Open Source OLAP in the Retail Environment. John Hobson, Feb 2008

External links

* [http://www.palo.net Palo] - Open-Source MOLAP Server for Windows/Linux and Microsoft Excel interface, documentation, demos and forum
* [http://sourceforge.net/projects/palooca PalOOCa on sourceforge.net] - OpenOffice.org Calc version of Palo client
* [http://www.jpalo.net JPalo] - Java software for Palo
* [https://sourceforge.net/projects/palo Palo on sourceforge.net] - Source Code of Palo


Wikimedia Foundation. 2010.

Игры ⚽ Нужен реферат?

Look at other dictionaries:

  • Palo — may refer to:*Palo (religion), developed by slaves from Central Africa in Cuba * Palos , long drums used in the music of the Dominican Republic *Palo (flamenco), the name for a musical form in flamenco;Places *Palo, Leyte, a 3rd class… …   Wikipedia

  • OLAP — (англ. online analytical processing, аналитическая обработка в реальном времени)  технология обработки данных, заключающаяся в подготовке суммарной (агрегированной) информации на основе больших массивов данных, структурированных по… …   Википедия

  • Comparison of OLAP Servers — The following tables compare general and technical information for a number of Online analytical processing (OLAP) servers. Please see the individual products articles for further information. Contents 1 General information 2 Data storage modes 3 …   Wikipedia

  • Сравнение OLAP серверов — В приведенных таблицах сравниваются основные и технические характеристики основных OLAP серверов. Для более детальной информации см. индивидуальные статьи по каждому продукту. Содержание 1 Общая информация 2 Модель хранения данных …   Википедия

  • Сравнение OLAP-серверов — В приведенных таблицах сравниваются основные и технические характеристики основных OLAP серверов. Для более детальной информации см. индивидуальные статьи по каждому продукту. Содержание 1 Общая информация 2 Модель хранения данных …   Википедия

  • Open Source Business Intelligence — L OSBI, acronyme de Open Source Business Intelligence, regroupe l ensemble des solutions et techniques liées au décisionnel et dont le modèle s appuie sur l Open Source. Ce concept, malgré la ressemblance, n a aucun rapport avec l Open Source… …   Wikipédia en Français

  • Business intelligence tools — are a type of application software designed to report, analyze and present data. The tools generally read data that have been previously stored often, though, not necessarily, in a data warehouse or data mart. Types of business intelligence tools …   Wikipedia

  • MOLAP — stands for Multidimensional Online Analytical Processing.MOLAP is an alternative to the ROLAP (Relational OLAP) technology. While both ROLAP and MOLAP analytic tools are designed to allow analysis of data through the use of a multidimensional… …   Wikipedia

  • List of computing and IT abbreviations — This is a list of computing and IT acronyms and abbreviations. Contents: 0–9 A B C D E F G H I J K L M N O P Q R S T U V W X Y …   Wikipedia

  • Liste De Logiciels Libres — Les logiciels libres présents sur cette page le sont selon la définition de l article logiciel libre. La plupart des programmes cités ici sont disponibles sous licence GNU GPL ou BSD. Sommaire 1 Système d exploitation 1.1 Famille des GNU/Linux… …   Wikipédia en Français

Share the article and excerpts

Direct link
… Do a right-click on the link above
and select “Copy Link”