ScimoreDB Distributed Server 2.5.0.1053 details

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