Polyhedra (software)

<h2 id="company">Company</h2>
Polyhedra development was started in 1991 by Perihelion Technology Ltd, a subsidiary of <a href="/facts/Perihelion_Software/wpUpqBGb"> Perihelion Software Ltd</a> (PSL); initially, the project had a working title the "Perihelion Application Toolkit", but was soon renamed Polyhedra (using a left-over trademark from another PSL project). There was a management buyout of PTL in 1994, and the company name changed to Polyhedra plc to match the name of the product. Polyhedra plc was in turn acquired by Enea AB in 2001.<a class="footnote-ref" id="fnref:2" href="#fn:2">2</a><a class="footnote-ref" id="fnref:3" href="#fn:3">3</a> All development and support is still done in the <a href="/facts/England/U9mE5bGL">English</a> town of <a href="/facts/Shepton_Mallet/4VP7lGxz">Shepton Mallet</a>, where PSL was based.

<h2 id="features">Features</h2>
Tim King, the founder of <a href="/facts/Perihelion_Software/wpUpqBGb"> Perihelion Software Ltd</a>, developed a relational DBMS for historical data as part of his PhD work;<a class="footnote-ref" id="fnref:4" href="#fn:4">4</a> Dave Stoneham, who set up PTL, had previously developed a <a href="/facts/SCADA/nKL6Mfd1">SCADA</a> system. Building on these experiences, Polyhedra was originally developed "to bring the benefits of relational technology to the embedded market". To this end, it had to be small footprint, very fast... and it had to avoid the need for <a href="/facts/Polling_(computer_science)/WVa88JIg">polling</a>, which is a performance killer. Consequently, it was designed from the start to:

<ul><li>keep the working copy of the data in-memory (though there is now a variant that keeps the data in a <a href="/facts/Flash_memory/Cn8JsStx">flash</a>-based file);</li>
<li>use a client–server architecture to protect the data from corruption by rogue application code;</li>
<li>have an 'active query' mechanism to update client applications when relevant database changes occur;</li>
<li>have a very simple processing model where a <a href="/facts/Database_transaction/q1Etrsl8">transaction</a> is either a schema change, a query, or a request for a set of inserts, updates and/or deletes - such alterations can either be expressed via SQL statements or by updating through the active queries with (in conjunction with active queries) an <a href="/facts/Optimistic_concurrency_control/d0quWfY2">optimistic concurrency mechanism</a> to handle clashing updates;</li>
<li>have a table <a href="/facts/Inheritance_(object-oriented_programming)/a7R1xv8n">inheritance</a> mechanism which, when combined with <a href="/facts/Database_trigger/yhI7KW6H">Database triggers</a> (via the CL language, see below), allows the database designer to program the database in an object-oriented fashion. Table inheritance also avoids or reduces the need for supplementary tables whose primary key is a foreign key to another table, and thus can simplify many queries and updates.</li>
<li>have a <a href="/facts/Operational_historian/FzvfkRFa">Historian</a><a class="footnote-ref" id="fnref:5" href="#fn:5">5</a> module to allow large volumes of times-series data to be captured, stored, archived and queried in an efficient fashion.</li></ul>
Polyhedra IMDB achieves data persistence through the use of <a href="/facts/Snapshot_(computer_storage)/LKm3NX2A">snapshots</a> and <a href="/facts/Transaction_log/R7fDybpe">journal logging</a>; Polyhedra Flash DBMS uses <a href="/facts/Shadow_paging/SChW4g3x">shadow paging</a>, with 2 levels of recursion. In addition, Polyhedra can be used in <a href="/facts/Hot_spare/0fjq424d">hot-standby</a> configurations for improved <a href="/facts/Availability/l8SGSyyf">availability</a>. The transactional model used by all Polyhedra products ensures atomicity, consistency and isolation (as defined by the <a href="/facts/ACID/FySU18n1">ACID</a> properties); durability is enforced in Polyhedra Flash DBMS, while in Polyhedra IMDB clients can choose the durability model when they issue their transactions.
"The Polyhedra DBMS system is fundamentally different compared to other relational systems, because of its active behaviour. This is achieved through two mechanisms, active queries and by the control language (CL). An active query looks quite like a normal query where some data is retrieved and/or written, but instead the query stays in the database until explicitly aborted. When a change in the data occurs that would alter the result of the query, the application is notified. The CL, which is a fully object-oriented script language that supports encapsulation, information hiding and inheritance, can determine the behaviour of data in the database. This means that methods, private or public, can be associated with data performing operations on them without involving the application."<a class="footnote-ref" id="fnref:6" href="#fn:6">6</a>
Polyhedra is not a general-purpose DBMS, as the restricted transactional model does not meet all needs, and its fault-tolerance model is based on the hot-standby approach (to minimise hardware costs) rather than <a href="/facts/Computer_cluster/mT7S1BcX">clustering</a> (which is better for load-sharing). However, its limitations are benefits in embedded use, where the emphasis in a deployed application is on performance and cost rather than handling continually varying usage patterns.
Most of the Polyhedra products are made available for purchase under a <a href="/facts/Proprietary_software/9zcskxYL">proprietary</a> license, but in 2012 Enea released Polyhedra Lite under a freeware license.<a class="footnote-ref" id="fnref:7" href="#fn:7">7</a>

<h2 id="release-history">Release history</h2>
<ul><li>1991 Development started.</li>
<li>1993 Polyhedra 1.0: first commercial release of an in-memory <a href="/facts/DBMS/VYcpkevb">Relational DBMS</a> (RDBMS).</li>
<li>1995 Ported to <a href="/facts/Microsoft_Windows/bwhAhuSL">Windows</a> and <a href="/facts/Linux/9FvCKSTq">Linux</a>.</li>
<li>1996 Polyhedra 2.0: added <a href="/facts/Hot_spare/0fjq424d">hot standby</a> configurations for use in applications needing <a href="/facts/High_availability/y3J8GnEo">high availability</a>. First port to an <a href="/facts/RTOS/IvUCFwCL">RTOS</a> (<a href="/facts/PSOS_(real-time_operating_system)/MCX2b8KC">pSOS</a>)</li>
<li>1997 Polyhedra 3.0: new in-memory data storage engine, for improved space and time efficiency.</li>
<li>1999 Polyhedra 3.1: adds new data types, <a href="/facts/ODBC/2dV2Fm5j">ODBC</a> <a href="/facts/API/GMlN4vUr">API</a>. <a href="/facts/Operating_System_Embedded/ND2jhhsU">OSE</a> port.</li>
<li>2001 Polyhedra 4.0: <a href="/facts/JDBC/uUVYg2sB">JDBC</a> support, additional index type, read-only replicas, multi-threading.</li>
<li>2002 Polyhedra 4.1: <a href="/facts/Client%25E2%2580%2593server/FSnf27C5">client–server</a> comms overhauled for substantial performance improvements, especially for client apps using the ODBC API (now deemed the 'native' <a href="/facts/API/GMlN4vUr">API</a> for all platforms).</li>
<li>2003 Polyhedra 5.0: <a href="/facts/UNICODE/DDu3MfPV">UNICODE</a>, schema migration (<a href="/facts/Alter_(SQL)/Hx7aNozV">SQL 'ALTER TABLE'</a>).</li>
<li>2004 Polyhedra 6.0: 64-bit support re-introduced, for <a href="/facts/Linux/9FvCKSTq">Linux</a> and <a href="/facts/Solaris_(operating_system)/KPfT98EJ">Solaris</a>. (It previously had been available on <a href="/facts/DEC_Alpha/4eN7LuXG">DEC Alpha</a> under <a href="/facts/Tru64_UNIX/J4tMy7uA">Digital UNIX</a> until usage of that platform generally died out.) Polyhedra64 has subsequently been ported to <a href="/facts/Microsoft_Windows/bwhAhuSL">Windows x64</a>.</li>
<li>2006 Polyhedra Flash DBMS introduced, based on a fork of the Polyhedra IMDB code base.</li>
<li>2007 Polyhedra 7.0: Polyhedra IMDB and Polyhedra Flash DBMS code bases unified, for ease of support and greater commonality of features. Also, enhanced resource management and multi-threading.</li>
<li>2008 Polyhedra 8.0: Polyhedra Flash DBMS now supports <a href="/facts/Hot_spare/0fjq424d">hot standby</a> configurations for use in applications needing <a href="/facts/High_availability/y3J8GnEo">high availability</a>, in a similar way to Polyhedra IMDB. Polyhedra 8.1 added Linux/MIPS support, the ability to monitor active queries, and enhancements to the historian.</li>
<li>2009 Polyhedra 8.2: Linux ODBC drivers and IPv6</li>
<li>2010</li></ul>
<ul><li>Polyhedra 8.3: Some SQL enhancements and streaming output from historian.</li>
<li>Polyhedra 8.4: performance enhancements</li></ul>
<ul><li>2011 Polyhedra 8.5: better integration with 3rd-party tools, and improved performance on Windows. Replica servers can be used in a fan-out configuration for better scaling.</li>
<li>2012 Polyhedra 8.6: 64-bit integer data type. Polyhedra Lite introduced:<a class="footnote-ref" id="fnref:8" href="#fn:8">8</a> a free-to-use, reduced-functionality version of Polyhedra32 IMDB, available for Windows, and for Linux on x86 and the <a href="/facts/Raspberry_Pi/Ie6Lx9n5">Raspberry Pi</a>.<a class="footnote-ref" id="fnref:9" href="#fn:9">9</a></li>
<li>2013</li></ul>
<ul><li>Polyhedra 8.7:<a class="footnote-ref" id="fnref:10" href="#fn:10">10</a> <a href="/facts/Locking_(computer_science)/e3a9gnJT">locking</a> and <a href="/facts/Propagation_constraint/SoC55rsc">cascaded deletes</a>.</li>
<li>Polyhedra 8.8:<a class="footnote-ref" id="fnref:11" href="#fn:11">11</a> <a href="/facts/Encryption/16q29Fdv">encrypted</a> communications</li></ul>
<ul><li>2014 Polyhedra 8.9: SQL enhancements (<a href="/facts/SQL/UjQLJcYm">GROUP BY and HAVING</a>, DISTINCT, <a href="/facts/Join_(SQL)/Cxl5lxcR">outer joins</a>), security enhancements, and online backups for time-series data.</li>
<li>2015 Polyhedra 9.0: read-only partial database replication via a subscription mechanism, an <a href="/facts/ADO.NET_data_provider/j8ynkv5q">ADO.NET data provider</a> for Polyhedra, and enhancements to the proprietary 'callback API' that can yield significant performance enhancements.</li>
<li>2016 Polyhedra 9.1: bi-directional subscription and partial table replication, internal resource monitoring, and a <a href="/facts/Python_(programming_language)/YbuGqofa">Python</a> DB-API module with extensions for Polyhedra-specific features such as active queries.</li>
<li>2017</li></ul>
<ul><li>Polyhedra 9.2: reduced memory usage, RDI (Remove Device Interface) API, <a href="/facts/OPC_Unified_Architecture/DX40Sh4D">OPC UA</a> RDI, and SQL EXPLAIN command.</li>
<li>Polyhedra 9.3: server initiated replication.</li></ul>
<ul><li>2018 Polyhedra 9.4: Embedded database API and limited SQL function-based indexes.</li>
<li>2019 Polyhedra 9.5: Backup standby, MQTT interface and Grafana interface.</li>
<li>2020 Polyhedra 9.6: REST API, WebSocket Server and IMDB API Enhancements.</li>
<li>2021 Polyhedra 9.7: IMDB API BLOB caching, multiple database support.</li>
<li>2022 Polyhedra 9.8: Maintenance release, updates for supported OS versions.</li>
<li>2023 Polyhedra 9.9: Maintenance release, updates for supported OS versions.</li>
<li>2024 Polyhedra 9.10: Maintenance release, updates for supported OS versions.</li></ul>

<h2 id="external-links">External links</h2>
<ul><li><a href="http://enea.com/polyhedra">Official website</a></li></ul>

<h2 id="references">References</h2>

<ol>
<li id="fn:1">Enea Announces Flash-Based Relational Database Management System Archived 17 May 2008 at the Wayback Machine <a href="http://www.enea.com/templates/Extension____8923.aspx" target="_blank">http://www.enea.com/templates/Extension____8923.aspx</a> <a href="#fnref:1" class="footnote-back-ref">↩</a></li>
<li id="fn:2">Business Wire: Enea Acquires Polyhedra <a href="http://www.allbusiness.com/technology/software-services-applications/6050443-1.html" target="_blank">http://www.allbusiness.com/technology/software-services-applications/6050443-1.html</a> <a href="#fnref:2" class="footnote-back-ref">↩</a></li>
<li id="fn:3">thefreelibrary.com: Enea Acquires UK Company Polyhedra - Strengthens OSE With Database Technology <a href="http://www.thefreelibrary.com/Enea+Acquires+UK+Company+Polyhedra+-+Strengthens+OSE+With+Database...-a072311343" target="_blank">http://www.thefreelibrary.com/Enea+Acquires+UK+Company+Polyhedra+-+Strengthens+OSE+With+Database...-a072311343</a> <a href="#fnref:3" class="footnote-back-ref">↩</a></li>
<li id="fn:4">Tim King – Home Page <a href="http://www.tim-king.com/" target="_blank">http://www.tim-king.com/</a> <a href="#fnref:4" class="footnote-back-ref">↩</a></li>
<li id="fn:5">Handling time-series data in Polyhedra IMDB, White Paper, Enea. <a href="http://developer.polyhedra.com/polyhedra-features/historian" target="_blank">http://developer.polyhedra.com/polyhedra-features/historian</a> <a href="#fnref:5" class="footnote-back-ref">↩</a></li>
<li id="fn:6">Aleksandra Tešanović, Dag Nyström, Jörgen Hansson, Christer Norström: Embedded databases for embedded real-time systems: a component-based approach (2002) <a href="http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.23.6688" target="_blank">http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.23.6688</a> <a href="#fnref:6" class="footnote-back-ref">↩</a></li>
<li id="fn:7">Polyhedra® Lite In-Memory Relational Database System Freeware Available Now from Enea, Press Release, EECatalog. <a href="http://eecatalog.com/embeddedlinux/2012/10/11/polyhedra-lite-in-memory-relational-database-system-freeware-available-now-from-enea/" target="_blank">http://eecatalog.com/embeddedlinux/2012/10/11/polyhedra-lite-in-memory-relational-database-system-freeware-available-now-from-enea/</a> <a href="#fnref:7" class="footnote-back-ref">↩</a></li>
<li id="fn:8">Polyhedra® Lite In-Memory Relational Database System Freeware Available Now from Enea, Press Release, EECatalog. <a href="http://eecatalog.com/embeddedlinux/2012/10/11/polyhedra-lite-in-memory-relational-database-system-freeware-available-now-from-enea/" target="_blank">http://eecatalog.com/embeddedlinux/2012/10/11/polyhedra-lite-in-memory-relational-database-system-freeware-available-now-from-enea/</a> <a href="#fnref:8" class="footnote-back-ref">↩</a></li>
<li id="fn:9">Free real-time relational database for the Raspi, Raspberry Pi forum. <a href="http://www.raspberrypi.org/phpBB3/viewtopic.php?t=20065&p=330703" target="_blank">http://www.raspberrypi.org/phpBB3/viewtopic.php?t=20065&p=330703</a> <a href="#fnref:9" class="footnote-back-ref">↩</a></li>
<li id="fn:10">Embedded DBMS gains locking and cascaded deletes, LinuxGizmos.com. <a href="http://linuxgizmos.com/embedded-dbms-gains-locking-and-cascaded-deletes/" target="_blank">http://linuxgizmos.com/embedded-dbms-gains-locking-and-cascaded-deletes/</a> <a href="#fnref:10" class="footnote-back-ref">↩</a></li>
<li id="fn:11">Enea AB: Enea Protects the Communication between Database Server and Client Applications, Regulatory news, SPi World news. <a href="http://www.sectorpublishingintelligence.co.uk/news/843220/enea+ab+enea+protects+the+communication+between+database+server+and+client+applications" target="_blank">http://www.sectorpublishingintelligence.co.uk/news/843220/enea+ab+enea+protects+the+communication+between+database+server+and+client+applications</a> <a href="#fnref:11" class="footnote-back-ref">↩</a></li>
</ol>

Polyhedra (software) open-in-new

Polyhedra (software)