# cQube - Release V 2 **1.** **Objectives of the cQube release 2.0** The cQube release version 2.0 divides cQube into a base installation section and the cQube workflow. Installation is split into two sections, a base cQube installation which installs all the software components and the workflow installation configures the workflow, installs data processing components, SQL queries and the database components. **2.** **Scope** cQube product release features and issues are described in this version 2.0. and contains a description of the functionalities that have been developed/ upgraded in this version. **3.** **Summary of the Product Features** This document contains information on the following new features and enhancements to the existing features of the cQube product: ● cQube base & cQube workflow installation/upgradation separation - cQube Base Installation/upgradation ● cQube base & cQube workflow installation/upgradation separation - cQube Workflow Installation/upgradation ● Diksha summary rollup performance ● Data retention for transaction table based on the configured duration ● Performance benchmark ● Defect fixes - CRC nifi special character issue handling ● Defect fixes - composite report and diksha progress report **4.** **Description of the Product Features** 1\. cQube Base Installation/upgradation [CQB-1145](https://project-sunbird.atlassian.net/browse/CQB-1145) | Sl No. | Feature | Description | Roles Impacted | | ------ | ------------------------------------ | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------- | | 1 | cQube base Installation/ upgradation |

This feature includes the following -

- Installation of the cQube base data path

- Installation and configuration of all the software components required in the cQube product

Note: This installation does not include installation of any tables. None of the NIFI processes will be created

- Upgradation process is also part of the same base

| Admin, Report viewers | 2\. cQube Workflow Installation/upgradation [CQB-1146](https://project-sunbird.atlassian.net/browse/CQB-1146) | Sl No. | Feature | Description | Roles Impacted | | ------ | ---------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------- | | 1 | cQube workflow Installation/ Upgradation |

The base installation installs all the base software components and this installation takes place over the base installation

This installation configures the workflow, installs data processing components, SQL queries. This installation creates tables, creates functions, creates views and materialized views.

This installation also installs the NIFI processes, imports nifi templates, updates nifi parameters and initializes nifi controllers

There will ne workflow upgradation at all future releases

| Admin, Report viewers | 3\. Diksha summary rollup performance [CQB-1142](https://project-sunbird.atlassian.net/browse/CQB-1142) | Sl No. | Feature | Description | Roles Impacted | | ------ | -------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------- | | 1 | Diksha summary |

The diksha summary rollup nifi data flow has been optimized.

All files related to a request have been loaded into temp and a single workflow is initiated.

Month wise aggregation table is created to improve the query performance.

The overall query table is updated.

| Admin, Report viewers | 4\. Data retention for transaction table based on the configured duration [CQB-1143](https://project-sunbird.atlassian.net/browse/CQB-1143) | Sl No. | Feature | Description | Roles Impacted | | ------ | -------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------- | | 1 | Data retention |

Data retention has been set up for the following data sources.

- Periodic Assessment

- Semester Assessment

- CRC

- Diksha summary rollup

The default data retention time period for all the above tables is set to 90 days

The retention time period is configurable using the data replay/retention screen that has been provided in the admin console.

The data in the transaction tables will be deleted based on the retention time set.

| Admin, Report viewers | 5\. Security vulnerabilities fixes [CQB-1147](https://project-sunbird.atlassian.net/browse/CQB-1147) | Sl No. | Feature | Description | Roles Impacted | | ------ | -------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | --------------------- | | 1 | Security fixes |

The following defects have been fixed in this release:

- CRC nifi special character issue handling

- composite report and diksha progress report issues

| Admin, Report viewers | --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://cqube.sunbird.org/release-notes/cqube-release-v-2.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.