The Polyhedra RDBMS Family

Polyhedra® is a family of compact, lightweight, SQL relational database management systems (RDBMS) optimized for embedded systems applications.

They are all standards-based and built on an ironclad client-server architecture, and the three main products are:

Polyhedra IMDB (in-memory database system) and Polyhedra Flash DBMS

These two database servers both provide a secure, fault-tolerant data repository for embedded systems, mobile devices and server-based applications, differing mainly by the underlying storage technology: as implied by the name, Polyhedra IMDB (in-memory database system) keeps the data in RAM for fast queries and updates, whereas Polyhedra Flash DBMS is targeted at smaller systems - such as set-top boxes, picocells and portable battery-powered devices - where minimising code and RAM footprint is more important than ultimate system performance.

Polyhedra Lite

This reduced-functionality version of Polyhedra IMDB is available as freeware for personal use or for use in-house.

What's the differences between the Polyhedra products?

The table below gives a brief summary of the main features of Polyhedra, with an indication of whether the feature is available in a particular member of the Polyhedra product family. (Note: in some cases support for a feature by a particular Polyhedra product is 'modular': it can be omitted from the executables if not used, to reduce the code footprint - or, for some products, it may be omitted from the supplied executables, and these would have to be relinked to enable the feature.)

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

Download software

Enea offers trial evaluations or freeware versions of a majority of our products. Check out the Download center.

White papers

Get your free technical white paper covering topics like multicore, realtime and embedded Linux, in Enea's White Paper Directory.

Downloads

Corporate Headquarters, Stockholm

P.O. Box 1033
Jan Stenbecks Torg 17
SE-164 26 Kista, Sweden
Phone: +46 8 507 140 00
Fax: +46 8 507 140 40
E-mail: info@enea.se

China

Shanghai Representative Office
Room 1203, Silver Tower
No.218 South XiZang Road
Shanghai 200021, China
Phone: +86 21 6334 3406

ENEA Software (Beijing) Co. Ltd.
RM1702, Block C, Reward Building,
No. 203, 2nd Section of WangJing LiZe ZhongYuan,
ChaoYang District, Beijing, 100102, China
Phone: +86 010-6439 8390, Fax: +86 10-64399850

France

Paris
Batiment Mac Kinley
1, avenue de l’Atlantique
F-91940 Les Ulis, France
Phone: +33 1 76 91 58 20

Germany

München
Schlosserstrasse 4
80336 München, Germany
Phone: +49 89 544 6760

Japan

Tokyo
1-4-2 Kanda Ogawa-machi
Chiyoda-ku
Tokyo 101-0052, Japan
Phone: +81 3 5207 6167

Romania

Bukarest
Splaiul Independentei 319 C,
Trust Center, 060044
Bucharest, Romania
Phone: +40 21 305 15 00
Fax +40 21 305 15 25

USA

Boston
Nashua Office Park
One Tara Blvd, Ste 404
Nashua, NH 03062, USA
Phone: +1 480 753 9200

Phoenix
1711 W. Greentree Drive
Suite 108
Tempe, AZ 85284, USA
Phone: +1 480 753 9200

Let ENEA get back to me

Please fill out the form with information about you. We will then get back to you as soon as possible.

Login

Please login by providing you information below.



New user