Overview

The nVIRO Data Hub provides a replicated read-only repository of data populated from nCORE, nFORM, and nSPECT.  The data is structured to store key nVIRO entities and relationships and to facilitate fast reporting.  A new database schema (DataHub) and several new database tables are added to support this capability. 

Long term direction for the Data Hub is to provide support for:

• Data reporting / analytics
  • Advanced data reporting (fast, powerful data access, for ad-hoc and standard reporting)
  • ‘Executive’ dashboards (future)
• Data re-use
  • Cross-pollinate data between nVIRO products
  • Support 3rd party integration
• Low Code
  • Enable easier user report and data source definition (less SQL)
  • Consolidated way to configure form prefill, reports, doc gen, inspection plans etc.

Data Hub Population

• Data Hub is populated in real-time from new nFORM submissions
• Data Hub is (currently) updated nightly from nCORE, nFORM, nSPECT
• Data Hub is available for reporting data in the new version of nVISAGE

Data Hub Reporting

The nVIRO nVISAGE / Data Hub Data Viewer is automatically configured to access data sources from the Data Hub. 

Data sources are classified as follows:

• • CORE – Core nVIRO entities.
  • IDENTIFIER - Provides related Identifiers / Alternate Names for Sites
  • FORM – Submitted forms. Typically FORM data sources would be reported in conjunction with a SECTION data source.
  • PROGRAM – Program component forms. Typically PROGRAM data sources would be reported in conjunction with a SECTION data source.
  • SECTION – FORM or PROGRAM form section data.  These are available after selecting a FORM or PROGRAM data source
  • CUSTOM – Custom (non-Data Hub) data sources.
  • REFERENCE – A list of the data sources.

Data Hub Structure

The following diagram provides an high level overview of the core data hub entities and relationships