|
ElevateDB V1.09
A Database Engine Tool for .Net, ActiveX, ASP.Net, C/C++, Delphi, Java
ElevateDB is an embedded SQL database engine that can be compiled directly into your application and 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.
For more information about this product please visit the
Features:
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
Client access code added to a compiled application is minimal, 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, and file extensions, licensed session counts, and encryption passwords in ElevateDB can all be customized
ANSI/Unicode
ElevateDB is available in ANSI (8-bit encoding using the Windows ANSI code pages) or Unicode (16-bit UTF-16 encoding) flavors under Windows
100% .NET managed code
ElevateDB does not use any direct pointer access or memory manipulation under .NET, making it 100% managed code
Source code
ElevateDB was written using Delphi's Object Pascal language, and the source code for ElevateDB is available for purchase as an extra charge
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
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
Licensing
Distribution of ElevateDB is royalty-free.
Technical Information
Programming Language - Generates code for or works with the follow languages...
|
Visual Basic
|
|
C#
|
|
Visual Basic.Net
|
|
C/C++
|
|
Java
|
|
Delphi
|
|
J#
|
|
VB Script
|
|
VBA
|
|
JavaScript
|
|
PHP
|
|
Development Environment - Is compatible with the following environments (IDE's)...
|
Visual Studio
|
|
Visual Studio.Net
|
|
Delphi
|
|
C++ Builder
|
|
Kylix
|
|
JBuilder
|
|
C# Builder
|
|
MS Access
|
|
MS Office
|
|
Component Type - Contains the following types of components...
|
.Net Class Library
|
|
Dynamic\Static Link Library
|
|
VCL
|
|
CLX
|
|
Operating System - Which operating systems does the product run on?
|
XP
|
|
2000
|
|
ME
|
|
98
|
|
NT4
|
|
|
|
|