ElevateDB is an embedded SQL database engine that offers local single and multi-user access (file-sharing) and client-server access with the provided ElevateDB server. ElevateDB can switch between these modes of operation quickly, requiring just a few application changes. ElevateDB adheres to a subset of the SQL 2003 standard (ANSI/ISO 9075). Any deviations from the standard are detailed in the SQL reference material provided with the product. Some of the standard features in ElevateDB include: - Transparent local and client-server access - Local and client-server access is identical in operation, requiring only a few property modifications to switch between the two
- Small footprint - Both the ElevateDB .NET Data Provider and the ElevateDB Server is less than 2 Mb in size
- Multi-threaded - Both local and client-server sessions can be multi-threaded in an application
- Customization - File signatures, file names, file extensions, licensed session counts, and encryption passwords in ElevateDB can all be customized
- .NET Support - Works with the .NET Framework 2.0 and higher and the .NET Compact Framework 2.0 and higher
- 100% .NET managed code - ElevateDB does not use any direct pointer access or memory manipulation under .NET
- Visual Studio Integration - Design-time integration into the Visual Studio IDE, including the Server Explorer, Query Designer, and DataSet Designer
- Bi-Directional Cursors - Includes a bi-directional EDBDataCursor class with support for inserting, updating, deleting, searching, and filtering on tables or sensitive result sets
- Excellent performance - All SQL queries are optimized using available indexes and expression reduction, and query plans can be generated to show how a query will be executed
- Replication - Complete replication support is included, and replication can be set up in any configuration desired - uni-directional, bi-directional, push, pull, merge, and snapshot (using backup facilities).
- Collations - All standard Windows locales and collations supported on a per-column and per-indexed column basis, including options for case-insensitivity, accent-insensitivity, Kana-insensitivity, and width-insensitivity
- In-memory databases - Databases can be created entirely in-memory and can be accessed from multiple threads
- Security - User security is standard, but optional, and includes users, roles, and administrative access
- Online backup - Databases can be backed up while they are being used
- Serialized transactions - Transactions are always serialized and can be isolated to specific tables
- Row locking - Both pessimistic and optimistic row locking supported, with options for detecting row changes
- Constraints - Check, primary key, unique, and foreign key constraints
- Stored procedures and functions - Full SQL/PSM support for stored procedures and functions, including dynamic and DDL statements, structured exception handling, and rich cursor handling
- Triggers - Before and after insert, update, and delete triggers with full SQL/PSM support in trigger definitions and conditional execution
- Views - Updateable views and constrained views (WITH CHECK OPTION) supported
- Jobs - Jobs can be defined and scheduled to run on an ElevateDB server, and servers can be tasked to execute specific job categories
- Data types - All standard SQL data types are supported, including date/time intervals
- Full text indexing - Any CHAR, VARCHAR, or CLOB column can be indexed by word and searched using CONTAINS operator, and text to be indexed can be filtered according to another type column in the table
- NULL handling - Standard SQL NULL behaviors for all data types and operators
- Generated columns - Columns can be defined as expressions, and can be indexed and handled like any other column
- BLOB columns - Complete BLOB support with per-column compression and configurable block sizes per table
- Text import/export - Tables can be imported or exported from delimited text files with options for the formatting of dates, times, numerics, and boolean values as well as the delimiter
| |
