See Also
You are here: Architecture > DQL - Distributed Query Language
ContentsIndexHome
PreviousUpNext
DQL - Distributed Query Language
Distributed Query Language

 

DQL is ScimoreDB's Distributed Query Language. It is a highly modular transactional grid framework on which we built a distributed SQL database. It is a simple language that is a closer representation to the way that the database will actually behave than SQL. All SQL queries have to be first translated DQL plans by the SQL optimizer to be executed. 

DQL plans how the query is executed on specific instances. DQL is a pipeline-based language. Using DQL, you can "open" tables for "project"ing, merging, Sorting and grouping perform very intelligently and efficiently in parallel using the binary tree structure. 

Most of the time, the automatic SQL optimizer will be sufficient. However, there may be a few special cases where it is more efficient to write pure DQL as opposed to SQL. It is possible to get DQL query plans for SQL batches in the database manager. These can be used to base hand-optimised DQL queries on. Seperate documentation for DQL is available (on special request). 

 

 

Related