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
VERSION HISTORY
- Version 4.0 posted on 2011-06-01
elastic,fault tolernat,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 - Version 2.5.0.1053 posted on
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
Program Details
- Category: Business > Databases & Tools
- Publisher: Scimore UAB
- License: Free
- Price: N/A
- Version: 4.0
- Platform: windows
EULA
ScimoreDB is free. You are permitted to use Scimore products freely for both non-commercial and commercial products. You can royalty free distribute ScimoreDB with your software. You are not allowed to resell or modify Scimore software. To keep you informed, we do ask you to register during download. ScimoreDB Embedded, Server and Distributed are owned and produced by Scimore. No Liability for Damages. IN NO EVENT WILL SCIMORE BE LIABLE TO YOU FOR ANY DAMAGES WHATSOEVER, INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF BUSINESS PROFITS, BUSINESS INTERRUPTION, LOSS OF BUSINESS INFORMATION, LOST SAVINGS, PERSONAL INJURY, WRONGFUL DEATH, OR OTHER INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE SOFTWARE, EVEN IF SCIMORE HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES, OR FOR ANY CLAIM BY ANY OTHER PARTY.