Oterro 11 Features

General:

• Read/Write capable
• Automatic multi-user locking to provide the most liberal concurrent user access control - built into the engine
• Automatic write to disk verification
• Automatically maintains a duplicate copy of the database
• Engine level security via access rights
• Full referential integrity - constraints and custom business rules enforced at engine level
• Multi-thread compatible
• Supports stored procedures
• Supports triggers
• Data Access Objects (DAO) can be used with Oterro
• RemoteData controls can be used with Oterro
• Oterro automatically enters dates in both the 20th and 21st centuries.
• Supports full ODBC Level 2.x and partial support for Level 3.x
• Full engine level referential integrity
• Cost-based query optimizer built in the engine
• Full engine level multi-user optimistic locking

Supported Development Environments:

While not intended to be a complete list of development environments, the products listed below have been used by our clients with Oterro:

• ADO.NET
• Java
• Active Data Objects 2.x and Remote Data Objects
• Active Server Pages
• Cold Fusion
• Visual Basic
• Visual C++
• Borland C++ Builder
• Borland Delphi
• Other environments using the Borland Database Engine
• Microsoft Office (including Access, Excel and Word)
• R:BASE for Windows
• PHP
• Crystal Reports
• IBM WebSphere
• TeraScript
• UPS WorldShip

Transaction Processing:

• Read repeatability transaction processing
• Automatic database recovery

Application Development:

• File structure incorporates multimedia types -binary large objects
• Supports DLL access to the database
• Supports ODBC API for best performance

Data Integrity:

• Optimistic concurrency control
• Primary/foreign key constraints with cascading updates and deletes
• Rules
• Mirrored database
• Write check verify

Back