ScimoreDB Engine Features

All Scimore products share the same database engine - the ScimoreDB Engine.

The key features of ScimoreDB Engine

• 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
• Functional shipment
• Flexible monitoring capabilities using SQL commands