Catalyst

by Zoho
×
Cancel

ACCESS THIS PAGE
  • Tutorials
  • FAQ
  • Developer Tools
    CLI
    SDK
    Java Node.js Python Web Android iOS Flutter
    REST API
    Utilities
    Extensions Tools Integrations
    • Go to console

    OLAP Database

    Introduction

    Catalyst comes with a built-in proprietary OLAP (Online Analytical Processing) database feature, exclusively built to handle analytical queries that you run on the Data Store. You can execute advanced analytical queries on the OLAP database directly, instead of the Data Store’s primary relational database for instantaneous results on datasets of any scale. With its speed and efficiency, the OLAP database enables you to perform intricate analysis on multidimensional data and is designed for advanced business intelligence.

    Catalyst ZCQL supports querying the Data Store to execute the typical CRUD operations, and even include clauses and statements in them. In addition to this, ZCQL also supports built-in functions that help you perform quick arithmetic and analytical operations on the data in read queries, and manipulate the results to meet your requirements. As these involve advanced calculations, Catalyst provides you with a state-of-the-art OLAP system to handle these queries exclusively. With a single one-time action, you can enable automated synchronization of the data from the primary Data Store’s database to the OLAP database, and then execute data retrieval queries on it directly through our platform SDKs and APIs.

    Note: The OLAP database is a secondary database to the primary Data Store's database, optimized for analytical processing in data retrieval. Direct write operations to the OLAP database are not allowed. You will not be able to perform Create, Update, and Delete operations on OLAP, only Read operations.

    The OLAP system is designed to make complex data analysis easy for business users and decision makers. Some common applications where advanced data analysis and business intelligence can be integral include aggregated report generation, real-time dashboards and analytics, financial analysis that includes budgeting and forecasting, sales and marketing performance analysis, inventory and logistics management, data mining and trend analysis. If your application involves any of these aspects, you can query on the OLAP database and utilize its features to the fullest.


    Differences between the Primary Data Store and the OLAP Database

    Consider the factors listed below to determine when you would need to enable the OLAP database and query it, instead of querying the primary Data Store.

    Primary Data Store OLAP Database
    The primary Data Store implements OLTP (Online Transaction Processing) that is suited to handle queries to process transactions, rather than for the purpose of business intelligence. The OLAP system is built for a multidimensional data model, that allows for complex analytical and ad hoc query executions with a quick execution time, more suited for advanced data analysis.
    The primary Data Store can process all CRUD operations in an equally optimized manner, as it is fundamentally transaction-oriented. The OLAP database is highly read-optimized, as it is designed to handle analytical queries, which are typically executed in read operations.
    You can perform all CRUD operations on the primary Data Store. You will not be able to execute direct write operations on the OLAP database.
    Use this to execute transactional SELECT, INSERT, UPDATE and DELETE operations. Use this to execute analytical SELECT operations that include built-in ZCQL functions..

    Last Updated 2026-02-16 20:32:46 +0530 IST

    PREVIOUS

    NEXT