ScimoreDB Embedded Database 2.0

ScimoreDB Embedded Database 2.0 is a component for a larger system which uses embedded database to keep the internal data or data of user without setting up a direct communication between the database and the user but with database as a part of program. ScimoreDB Embedded features all the technical advantages of a full database engine. It performs very fast and can easily handle millions of rows. This database provides full data reliability with zero chance of data corruption, manages heavy loads and includes all the standard features such as T-SQL, Free-text search and more.

ScimoreDB Embedded features a unique range of options. It can be loaded and hidden in your application, as well as it can run as an auto-start/stop database-process outside your application. This will increase reliability and allow sharing databases between multiple applications. This will allow developers with a broad range of new options such as direct access to the embedded database from database manager, while developing.

ScimoreDB Embedded is part of ScimoreDB engine development. The technology has been developed over a decade to optimize performance and remove any chance of data loss. There are constant updates to ScimoreDB Embedded project as the development never stops aiming to make the already fast solution even better. For the last three years, Scimore have developed three major releases of ScimoreDB. So far ScimoreDB Embedded has nearly 1 million installations worldwide. Multiple large companies have trusted ScimoreDB Embedded to be embedded into, and shipped with their solutions.

You can use ScimoreDB for free in any project in need of a fast, powerful and advanced embedded database. We offer our services assisting to integrate ScimoreDB Embedded into a project, training development teams and providing post production support and maintenance. When ScimoreDB Embedded is not enough, it can be upgrade to a full database server with an option to be scaled-out into a network of distributed databases to rise up to any data processing challenge you can come up with.

Top reasons to use ScimoreDB Embedded

• Installed on 1.200.000 machines worldwide
• Outstanding performance rate without cut backs on reliability
• Reduces time developing persistant data structures
• Handles large data sets
• Royalty free
• Easy maintenance
• Rapid and easy set up
• Includes free-text search
• Quick access to support, periodic update and new versions
• Multi process access to database
• Complete invisibility option
• Removes the requirements of a hosted database solution
• Large scale-out capability with ScimoreDB Distributed
  

Major Features:

1. Technical features of ScimoreDB Embedded
   • Easy deployment
   • Standard interfacing (c++, c#, vb)
   • Standard manager used to create/query/modify/administrate embedded database
   • Utilizing fibers, IO completion, non blocked sockets, async disc IO
   • SMP optimized memory access
   • Enterprise database engine
   • Hot backup
   • Scale-out from embedded to large distributed environment
   • Free text search support
   • In-process / out-of-process options
   • Asp.net enabled
   • Multiple processes access support
   • Only 3MB footprint
2. ScimoreDB Engine Features
   • 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 command

• XP / Vista / Windows Server 2000 / Windows Server 2003 / Windows Server 2008
• 10 Mb RAM
• 16 MB disk space