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.

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
  • Facilitate data sharig 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, document generation, inspection plan search tools, 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 the data source for nVISAGE reports (with the exception of custom-written data sources)

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