| by Scimore UAB |
| Free SQL database used as an embedded, client/server or distributed database |
|
|
|
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 |
|
|
|
|
»
t-sql, embedded, SQL, ACID, Transaction, Database, Relation, Distributed, Parallel, RDBMS, Cluster, Stability, Performance, Reliability, Cost |
|
|
| Released: |
10-3-2008 |
| Language: |
English |
| Platform: |
WinNT 4.x,WinXP,Windows2000,Windows2003,Windows Vista Home Basic,Windows Vista Home Premium,Windows Vista Business,Windows Vista Enterprise,Windows Vista Ultimate |
| Install: |
Install and Uninstall |
| Requirements: |
64 Mb RAM, 128 Mb Disk |
|
|
