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

Last updated