cQube - Release V 2

Release Version 2 - 11 June 2021

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

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

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

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

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

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