Royalty free fully featured SQL database with nearly 1 million installations worldwide. Fast performance. Scales from small embedded to clustered ScimoreDB database for high load applications. Supports free-text indexing, acid transactions, T-SQL.
Pros: This database could be used in several usage scenarios. As embedded like an Access database, a large clustered database like Oracle or the DB2 or as distributed database are just some of the scenarios. This database systems optimized for Windows & dotNet environment. Publishers claim a million installed base for the package.
ScimoreDB Distributed is capable of scaling up as the load on the system grows. Installing more servers and joining them in a cluster lets the system automatically distribute the data and SQL queries over all the machines in the cluster and take care of the performance issues. No need to rewrite even a line of code. TPC-C benchmark ratings of 160,000 transactions per second has been achieved by the database. The system supports all the key technologies including transactions, SQL, OLAP/OLTP queries, and data replication providing the database support needed for a business. Distributed query optimizer helps optimize execution of SQL queries over the distributed database, network load balancing is built in. All I/O to storage is designed to be asynchronous to optimize performance of the processor. Data replication is used effectively to replicate data over multiple servers in the cluster adding redundancy features. ScimoreDB is a cluster aware application and using third-party software can provide no single point of failure. There are different schemes on how to achieve high availability, such as active-passive, active-active, active-active-active-passive. Each schema has different pro`s and con`s.
Cons: It does have an impressive user base. It is the feedback from this user base that will be useful for determining effectiveness. Apparently it does look and impressive package.