Skip to content
This repository has been archived by the owner on Dec 20, 2024. It is now read-only.

Doradus OLAP Databases

JoeWinter edited this page Dec 15, 2014 · 21 revisions

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


This document describes the Doradus OLAP database, which is a Doradus server configured to use the OLAP storage service to manage data. A Doradus OLAP database offers unique performance and storage advantages that benefit specific types of applications. This document describes the unique features of Doradus OLAP, its data model, and its REST commands.

Doradus OLAP builds upon the Doradus core data model and query language (DQL). This document provides an overview of these topics and provides OLAP-specific examples. The following documents are also available:

  • Doradus Spider Database: Describes the features, data model extensions, and REST commands specific to the Doradus Spider Database.
  • Doradus Administration: Describes how to install and configure Doradus for various deployment scenarios, and it describes the JMX commands provided by the Doradus Server.

This document is organized into the following sections:

  • Architecture: An overview of the Doradus architecture. The Doradus OLAP and Doradus Spider databases are compared.
  • OLAP Database Overview: An overview of an OLAP database including its architecture, unique features, the types of applications it is best suited for, and an example application schema.
  • OLAP Data Model: Describes core Doradus data model concepts and extensions specific to Doradus OLAP such as xlinks.
  • Doradus Query Language (DQL): A detailed description of DQL: perspectives, clauses, link paths, etc.
  • OLAP Object Queries: Describes the Object Query type including parameters and output results in XML and JSON.
  • OLAP Aggregate Queries: Describes the Aggregate Query type including parameters and output results in XML and JSON.
  • OLAP REST Commands: Describes the REST commands supported by OLAP databases for schema definition, updates, queries, and shard management.

Recent Changes

The following changes were made to reflect new features for the v2.3 release:

  • In object queries, the order parameter (&o) now supports multiple sort fields. Example: &o=LastName,FirstName.
Clone this wiki locally