The ScimoreDB Parallel Server is a low cost shared-nothing clustered database system. The Database server have been designed to take advantage of parallelization over multiple servers, achieving a near linear scalability for OLTP applications. ScimoreDB supports up to 512 PC's in a single database cluster and offers value in terms of functionality, speed and cost.

Here are some key features of "ScimoreDB Distributed Server":

· 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


Requirements:

· 64 Mb RAM, 128 Mb Disk

What's New in This Release: [ read full changelog ]

· t-sql
· free-text search
· blob compression
· in-memory transactions,
· .net data provider supporting .net 2.0, 3.0, 3.5,
· single or shared access of embedded database