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