Good: 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 ... (this pertains Cluster, RDBMS, Parallel, Distributed, Relation, Database, Transaction, ACID, embedded, t sql, ...)
ScimoreDB Distributed 4.0
[Home] - by: Scimore UAB - Download
Click to enlarge
Some words about ScimoreDB Distributed:
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:
* Elastic: add/remove nodes while cluster continues to run.
* Fault tolerance: faulty nodes automatic failover.
* 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
News, new features for this New Release:
User's remarks, reviews, comments (Add your comment / review)
Download size: 4944 Kb
Install/Uninstall: Install and Uninstall
OS: WinNT 4.x, WinXP, Windows2000, Windows2003, Windows Vista Home Basic, Windows Vista Home Premium, Windows Vista Business, Windows Vista Enterprise, Windows Vista Ultimate
Sys requirements: 64 Mb RAM, 128 Mb Disk
See also in Business and Finance: Database and Analytics