ScimoreDB
From Wikipedia, the free encyclopedia
 |
This article does not cite any references or sources. (January 2008) Please help improve this article by adding citations to reliable sources. Unverifiable material may be challenged and removed. |
 |
This article or section needs to be wikified to meet Wikipedia's quality standards. Please help improve this article with relevant internal links. (January 2008) |
| ScimoreDB | |
|---|---|
| Developed by | Scimore UAB |
| Latest release | 2.5.887 / March 3, 2008 |
| OS | Windows |
| Genre | RDBMS |
| Website | www.scimore.com |
ScimoreDB is a free relational database management system for Microsoft Windows, developed by Scimore UAB. It features advanced features: SQL, ACID transactions, Multiversion concurrency control, internal task scheduler, free text search, functional shipment in with grid streaming technology for distribution of data and queries. It works as embedded library, standalone server and distributed over many machines.
Contents |
[edit] DQL
DQL stands for Distributed Query Language. It’s the internal query language for ScimoreDB. DQL is a text based query language, which precisely describes how each query is executed in a large grid of computers. DQL describes where different functional nodes are instantiated, how they are connected, and how they communicate. The nodes are always connected in a tree like structure, where the root node returns the result of the DQL query.
[edit] History
It all started as an internal project for a European Portal. In the early days of the internet – there were no database servers, that were ready to fuel the low cost and high speed required by internet applications. It started as an “In memory database”, with simple COM interfaces. It was the core of many internet applications, and grew with requirements of the applications. Distribution was added to improve scalability, a query language DQL was added to improve speed of development, and transactions followed to ensure improve manageability. In 2005 Scimore was created, and the database was separated into a separate company. The major improvements in 2006 were the SQL to DQL translator and new distribution algorithms, allowing for linear scalability in distributed environment. The embedded version where launched. In 2007 based on requirements by the users, features where added – free text search, blob compression, database files movable, and embedded database allows for cross process interaction. A TPC benchmark resulted in updated communication protocols, improving the speed in large distributed database scenario.
[edit] Source code specifics
ScimoreDB is written in C++, utilizing many of the advanced features of Win32, Fibers, IO completions. An attempt is being made to porting ScimoreDB to Linux using the Wine project. There are currently clients for C++, Borland Delphi and .NET Framework.
