Speed, high availability and real-time decision making

A secure data repository for embedded systems, mobile devices and server-based applications demanding performance and reliability

Polyhedra

Polyhedra is a family of compact, lightweight, standards-based relational database management systems optimized for embedded systems and server-based applications demanding the utmost in performance and reliability. 

FLEXIBLE PRODUCT VERSIONS

Polyhedra IMDB (in-memory database system) manages a secure, fault-tolerant data repository for embedded systems, mobile devices and server-based applications that keeps the data in RAM for fast queries and updates – without the need of a hard drive.

Polyhedra Flash DBMS is a secure, fault-tolerant data repository targeted for smaller systems (such as set-top boxes, picocells and portable battery-powered devices) where minimizing code and RAM footprint is more important than ultimate system performance.

CLIENT-SERVER ARCHITECTURE

Built on an ironclad client-server architecture, Polyhedra is specifically designed for use in always-up, real-time applications in areas as diverse as data gathering, communication infrastructure, and industrial systems management.

 

Polyhedra Lite

Polyhedra Lite is a fast but flexible relational database system for personal use or for use in-house.

It is a freeware with reduced-functionality compared to the full 32-bit mode version of Polyhedra, and is available for Windows (on x86) and Linux (on x86 and the Raspberry Pi, plus selected Enea Linux platforms)

DOWNLOAD 

OPTIMIZED FOR EMBEDDED SYSTEMS APPLICATIONS

MEMORY RESIDENT

This provides performance that is significantly greater and more predictable than disk-based alternatives.

In-memory databases are faster than disk based systems, even where the disk based system is cached into RAM.

FAULT TOLERANT

Polyhedra can be configured so that servers run in a hot-standby arrangement, so that if the master database fails the standby can immediately take over in milliseconds or less.

ACTIVE QUERIES

Polyhedra incorporates a unique concept called active queries, which allow connected clients to monitor the database for changes to selected information, in a timely and scalable fashion. No polling needed!

POLYHEDRA PRODUCT FEATURES

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 JDBCclient 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

DATASHEET

Built on an ironclad clientserver architecture, Polyhedra provides a secure data repository for embedded systems demanding great performance and reliability.

Download PDF