ScimoreDB Embedded, Server and Distri... Download

ScimoreDB Embedded, Server and Distributed

ScimoreDB Embedded, Server and Distributed Description

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: * 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

ScimoreDB Embedded, Server and Distributed Screenshot

View Larger

ScimoreDB Embedded, Server and Distributed System Requirements

64 Mb RAM, 128 Mb Disk

ScimoreDB Embedded, Server and Distributed Keywords

Rating