SCIMOREDB EMBEDDED, SERVER AND DISTRIBUTED 2.5.0.1053

Royalty free fully featured SQL database engine with nearly 1 million installations worldwide. Use as embedded, like MS access, or as large clustered, like Oracle / DB2, distributed database.

Royalty free fully featured SQL database engine with nearly 1 million installations worldwide. Use as embedded, like MS access, or as large clustered, like Oracle / DB2, distributed database. ScimoreDB embedded, server or distributed databases has been optimized for MS Windows and .NET to deliver optimal database performance.Database top features: *GUI for database administration and querying. *Client interfaces: .NET data provider, C++ libraries, COM object. *SQL language *SQL procedures with T-SQL syntax *Optimized for SMP *Asynchronious IO for disk and network *Internal scheduler with priority queues - optimizing control of query execution *Multiversion Concurrency Control - writers never block readers *Table level and row level locking *ACID Transactions *Group commit *Optional "In memory Transactions" *Transactional DDL. Create/alter/drop comands are transactional *Configurable maximum memory usage *Primary key/foreign key/referential integrity/cascade delete *Blob size limited to 16TB *Text blob compression *Real-time deadlock detection *Nested sub-queries *Communicate with database using either shared memory, named pipes, and TCP/IP *Up to 65.000 concurrent connections *Side-by-side installations. Many installations of engine on same machine *Maximum database size 2^64 bytes = 16.777.216 Terabytes - imagine a backup/restore *Free text indexing and searching *Hot backup *Defragmentation/shrinking tables *Query optimizer using cost based strategy with heuristical hints *Distributed query optimizer *Flexible monitoring capabilities using SQL commands *Working with distributed, it like working with a single database instance