|
Feature
|
Polyhedra 64 IMDB |
Polyhedra 32 IMDB |
Polyhedra Lite |
Polyhedra Flash DBMS |
| SQL relational database, supporting views; INSERT, UPDATE, DELETE; queries with joins; foreign keys |
yes |
yes |
yes |
yes |
| Dynamic table creation, alteration and deletion |
yes |
yes |
yes |
yes |
| Strict enforcement of entity (data types) and referential integrity |
yes |
yes |
yes |
yes |
● 64-bit, 32-bit, 16-bit and 8-bit signed integers
● 64-bit and 32-bit floating point values
● bounded and unbounded character strings (+ UNICODE option)
● unbounded binary objects
● datetime
● Booleans |
yes |
yes |
yes |
yes |
| Table inheritance; 'shared' and 'virtual' attributes |
yes |
yes |
yes |
yes |
| Ability to mark tables and columns as persistent or transient |
yes |
yes |
yes |
yes |
| Ordered and hash indexes |
yes |
yes |
yes |
yes |
| Client-server architecture, keeping data separate from the applications that use it (and thus safer) |
yes |
yes |
yes |
yes |
| Standards-conformant ODBC and JDBC client libraries |
yes |
yes |
yes |
yes |
| Cross platform support |
yes |
yes |
yes |
yes |
| interworking with older releases |
yes |
yes |
yes |
yes |
| interworking with other Polyhedra products |
yes |
yes |
no |
yes |
| Address mode (which affects the platforms supported, and the size of database supported by Polyhedra IMDB) |
64-bit |
32-bit |
32-bit |
32-bit |
| Maximum database size |
determined by the memory available to a single process |
2 GB |
| Platform-independent database files |
yes |
yes |
yes |
yes |
| Fully transactional, with ACID operation |
yes |
yes |
yes |
yes |
| Provision for snapshots, for offline storage and analysis |
yes |
yes |
yes |
yes |
| Mechanisms for data durability |
Snapshots plus journal logging |
Shadow paging |
| Support for High Availability configurations |
yes |
yes |
no |
yes |
| Support for read-only replica servers |
yes |
yes |
no |
no |
| Subscriptions: allow a database to have an active cache of data from another |
yes |
yes |
no |
no |
| Active queries, with clients automatically updated |
yes |
yes |
yes |
yes |
| Interface to PLCs, RTUs (‘the DVI module’) |
yes |
yes |
no |
no |
| Historian module, to store and retrieve time-series data |
yes |
yes |
no |
no |
| Where is the master copy of the data stored? |
RAM |
RAM |
RAM |
file |
| Configurable RAM cache |
n/a |
n/a |
n/a |
yes |
| Configurable limit on total file size |
n/a |
n/a |
n/a |
yes |
| Configurable limits on size of individual tables |
no |
no |
no |
yes |
| Configurable limits on total RAM usage |
yes |
yes |
yes |
yes |
| Configurable limit on space used on behalf of a client |
yes |
yes |
yes |
yes |
| Debugging module |
yes |
yes |
no |
yes |
