Web Search
Introduction
Recent Changes
OLAP Database Overview
What is OLAP?
When OLAP Works Best
The Email Sample Application
Starting an OLAP Database
Optimizing OLAP Applications
Schema Design
Updates
Queries
OLAP Data Model
Motivation
Identifiers
Application
Table
Objects
Object IDs
Fields
Scalar Fields
Link Fields
Group Fields
Aliases
OLAP Sharding Model
Cross-shard Relationships: Xlinks
Shard Aging
Doradus Query Language (DQL)
Query Perspective
Clauses
Clause Negation: NOT
Clause Connectors: AND, OR, and Parentheses
Literals
Booleans
Numbers
Timestamps
Terms
Strings
Null Values
IS NULL Clause
Text Contains Clauses
Term Clauses
Phrase Clauses
Range Clauses
Equality Clauses
IN Clause
Timestamp Clauses
Subfield Clauses
NOW Function
PERIOD Function
Link Clauses
Link Path Clauses
WHERE Filter
Outer WHERE Filter
Quantifier Functions
Overview: ANY, ALL, and NONE
Quantifiers on MV Scalar Fields
Quantifiers on SV Scalar Fields
Quantifiers on Link Fields
Quantifiers with IS NULL
Link Path Comparison Functions
Transitive Function
COUNT(<link path>)
OLAP Object Queries
Query Parameters Overview
Fields Parameter
Basic Formats
WHERE Filters
Link Field Size Limits
Link Field AS Aliases
Metric Parameter
Order Parameter
Query Results
Empty Results
SV Scalar Fields
MV Scalar Fields
Link Fields
Multi-shard and Uncommitted Data Queries
OLAP Aggregate Queries
Aggregate Parameters Overview
Metric Parameter
Metric Functions
Multiple Metric Functions
Metric Expressions
DATEDIFF Function
WHERE Filter
ROUNDUP Function
Grouping Parameter
Global Aggregates: No Grouping Parameter
Single-level Grouping
Grouping Field Aliases
Multi-level Grouping
Group by Timestamp Subfield
Special Grouping Functions
BATCH Function
INCLUDE and EXCLUDE Functions
TERMS Function
TOP and BOTTOM Functions
TRUNCATE Function
UPPER and LOWER Functions
WHERE Function
Outer WHERE Function
FIRST and LAST Functions
Flattened Multi-level Grouping
SETS Function
Multi-metric Aggregate Queries
Pair Parameter
Multi-shard and Uncommitted Data Queries
OLAP REST Commands
REST API Overview
Common REST Headers
Common REST URI Parameters
REST Commands in Multi-Tenant Mode
Common JSON Rules
Illegal Characters in XML Content
Common REST Responses
OLAP REST Command Summary
Application Management Commands
Create Application
Modify Application
List Application
Delete Application
Object Update Commands
Add Batch
Delete Batch
Shard Management Commands
List Shards
Get Shard Statistics
Merge Shard
Delete Shard
Verify Shard
Set Shard Properties
Object Query Commands
Object Query via URI
Object Query via Entity
Aggregate Query Commands
Aggregate Query via URI
Aggregate Query via Entity
Find Duplicates Command
Task Status Command
OLAP Browser Interface