ScimoreDB Distributed

If you're in the market for a fully-featured and royalty-free SQL database engine, you'll want to check out ScimoreDB. With nearly one million installations worldwide, this engine has proven its worth to countless satisfied users. One of the standout features of the ScimoreDB engine is its flexibility; it can be used embedded (like MS Access) or for large clustered, distributed databases, much like Oracle or DB2.

Designed and optimized for use within the Windows and .NET environments, ScimoreDB delivers optimal database performance. Some key features of the engine include elastic scalability (you can add or remove nodes while the cluster is running), automatic failover for faulty nodes, and a GUI for easy database administration and querying. There are also a variety of client interfaces available, including .NET data providers, C++ libraries, and COM objects.

The ScimoreDB engine supports SQL language and T-SQL syntax, and is optimized for SMP. Asynchronous IO for disk and network, an internal scheduler with priority queues, and multiversion concurrency control all work together to ensure optimal performance. Writers never block readers, and the engine supports table level and row level locking, ACID transactions, and group commit. There is also an optional "In Memory Transactions" feature and transactional DDL.

Other key features of ScimoreDB include configurable maximum memory usage, primary key/foreign key/referential integrity/cascade delete, blob size limited to 16TB, text blob compression, and real-time deadlock detection. Nested sub-queries, with the ability to communicate with the database using either shared memory, named pipes, or TCP/IP, and support for up to 65,000 concurrent connections are also included. Additionally, the engine supports side-by-side installations and allows for the creation of databases up to 2^64 bytes (or 16.777.216 terabytes) in size.

ScimoreDB also offers free text indexing and searching, hot backup, defragmentation, and the ability to optimize queries using a cost-based strategy with heuristical hints. The distributed query optimizer and flexible monitoring capabilities using SQL commands make working with ScimoreDB simple and efficient, whether you're working with a single database instance or a distributed setup. All in all, ScimoreDB is a powerful, flexible, and reliable database engine that is definitely worth checking out.