Enea Adds Fine-Grain Locking and Cascaded Deletes to the World’s Best Relational In-Memory Database Server
STOCKHOLM, Sweden, April 9, 2013 – Enea® (NASDAQ OMX Nordic:ENEA), a world leading operating system solution vendor for 3G and 4G infrastructure equipment, is today announcing version 8.7 of the In-Memory Database Management System Polyhedra®, adding locking and cascaded deletes to the Polyhedra family, while still securing the best practices in real-time applications.
Database locking allows an application to claim part of the database, so that others cannot make changes while the client with the lock is deciding on the changes it wants to make. In comparison with locking on database, table, or row, Polyhedra even makes it possible to lock individual fields of a record, which is critical for real-time systems. This allows, for example, one client to lock configuration fields for a record without stopping other applications updating the value field as new readings come in. Polyhedra also allows locks to be specified as pessimistic or optimistic and can automatically convert pessimistic locks to optimistic locks after a short period. The new locking mechanism is integrated into Polyhedra’s user-based security system, so the database administrator can control which tables, and which attributes of a table, someone can lock.
Polyhedra allows the database administrator to define cross-references between tables, by saying that a field is a ‘foreign key’ to another table in the database. It also enforces referential integrity – which means that if the value in a record for a foreign key attribute is non-null, then the record pointed at must exist. The person creating the tables containing the foreign keys can say what should happen when the referenced record is deleted: instead of the default behavior of failing the transaction to maintain integrity, the reference can be set to null, or the record containing the reference can be deleted – a ‘cascaded delete’.
For more information, please visit https://www.enea.com/polyhedra / or contact: