Polyhedra History

Company History

Polyhedra development was started in 1991 by Perihelion Technology Ltd, a subsidiary of Perihelion Software Ltd (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, and has been renamed to Enea Polyhedra Ltd. The company's office is still located in the English town of Shepton Mallet, where PSL was based, and the company still handles all development and support for the Polyhedra family of products.

Product History

1991 Development started of Polyhedra32 IMDB (as it is now called).
1993 Polyhedra 1.0: first commercial release of an in-memory Relational DBMS (RDBMS).
1995 Ported to Windows and Linux.
1996 Polyhedra 2.0: added hot standby configurations for use in applications needing high availability. First port to an RTOS (pSOS)
1997 Polyhedra 3.0: new in-memory data storage engine, for improved space and time efficiency.
1999 Polyhedra 3.1: adds new data types, ODBC API. OSE port.
2001 Polyhedra 4.0: JDBC support, additional index type, read-only replicas, multi-threading.
2002 Polyhedra 4.1: client–server comms overhauled for substantial performance improvements, especially for client apps using the ODBC API (now deemed the native API for all platforms).
2003 Polyhedra 5.0: UNICODE, schema migration (SQL ALTER TABLE).
2004 Polyhedra 6.0: Polyhedra64 IMDB introduced, for Linux and Solaris. Polyhedra64 IMDB has subsequently been ported to Windows x64.
2006 Polyhedra Flash DBMS introduced, based on a fork of the Polyhedra IMDB code base. (Originally called Polyhedra FlashLite, but renamed Polyhedra Flash DBMS in 2012 to avoid confusion with Polyhedra Lite, see below.)
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.
2008 Polyhedra 8.0: Polyhedra Flash DBMS now supports hot standby configurations for use in applications needing high availability, 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.
2009 Polyhedra 8.2: Linux ODBC drivers and IPv6
2010 Polyhedra 8.3: Some SQL enhancements and streaming output from historian.
Polyhedra 8.4: performance enhancements
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.
2012 Polyhedra 8.6: Signed 64-bit integers now supported, on all platforms. The protocol for master-standby communication has been revised, so that the start-up time for a standby when using the historian has been improved, particularly when operating over a network with high latency.
Polyhedra Lite introduced: a reduced-functionality version of Polyhedra32 IMDB, released under a free license on Windows and selected Linux platforms - including the Raspberry pi, a cheap ($35) single-board computer produced by an educational charity based in Cambridge, UK.
2013 Polyhedra 8.7: locking and cascades deletes. ODBC driver for use on the Raspberry Pi.
Polyhedra 8.8: new product, the Polyhedra SSL Module, allowing client-server and server-server communications to be encrypted.
2014 Polyhedra 8.9: SQL enhancements including DISTINCT, outer joins, GROUP BY, HAVING. Security enhancements including a challenge-response protocol for authentication. Improved performance of schema interrogation functions. Online backup of files used for time-series data.
2015 Polyhedra 9.0: Substantial performance improvements, when client applications using the callback API take advantage of 'prepared SQL'. New ADO.NET Data Provider, allowing .NET applications to take advantage of active queries. New subscription mechanism allowing a database to have a live cache of data retrieved form other Polyhedra database(s).
2016 Polyhedra 9.1: Significant enhancements to the data subscription feature introduced in Polyhedra 9.0 with the addition of bi-directional subscription and partial table replication. Introduces a way to monitor the internal resources used by a running RTRDB, such as memory, threads and client connections. Adds a new standard Python DB-API client interface with extensions for Polyhedra-specific features such as active queries.