|
|
|
|
|
|
|
SQL92 compliant distributed database
|
ScimoreDB Embedded, Server and Distributed 2.5.0.1053
Author:
Supported languages: English
Supported OS: WinNT 4.x / WinXP / Windows2000 / Windows2003 / Windows Vista Home Basic / Windows Vista Home Premium / Windows
Price: Free
|
|
|
|
|
|
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
|
Free ScimoreDB Embedded, Server and Distributed download - 4.83 Mbscimoredb.2.5.0.928.msi
|
| Keywords:
t-sql, embedded, SQL, ACID, Transaction, Database, Relation, Distributed, Parallel, RDBMS, Cluster, Stability, Performance, Reliability, Cost |
|
|
|
|
|
