Doradus Query Language (OLAP)

[Table of Contents](https://github.com/dell-oss/Doradus/wiki/OLAP Databases: Table-of-Contents) | Previous | Next
Doradus OLAP Databases: Doradus Query Language

---

The Doradus query language (DQL) is used in object and aggregate queries. DQL is analogous to full text languages used by search engines such as Lucene and from which DQL borrows concepts such as _terms_, _phrases_, and _ranges_. To these, DQL adds _link paths_, _quantifiers_, and a _transitive_ function to support graph-based searches.

This section describes DQL, including extensions supported by Doradus OLAP.

• Query Perspective
• Clauses
• Clause Negation: NOT
• Clause Connectors: AND, OR, and Parentheses
• Literals
• Null Values
• IS NULL Clause
• Text Contains Clauses
• Range Clauses
• Equality Clauses
• IN Clause
• Timestamp Clauses
• Link Clauses
• Quantifier Functions
• Transitive Function
• Count (<link path>)