DQL -Distributed Query Language

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. 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).