Versions Compared

Old Version 8

changes.mady.by.user John Kostakos

Saved on

compared with

New Version 9

changes.mady.by.user Will Rensmith

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 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, doc gendocument generation, inspection plans 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 available for reporting data in the new version of nVISAGEthe data source for nVISAGE reports (with the exception of custom-written data sources)

Data Hub Reporting

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


Excerpt

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.
Info

The following data source types support real-time reporting:

  • FORM
  • PROGRAM
  • SECTION
  • REFERENCE
  • CUSTOM

The following data source types are refreshed on a nightly basis:

  • CORE



Data Hub Structure

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

On this page

Table of Contents


Sub-Topics

Page Tree
root@self


Related Content

nVIRO nVISAGE / Data Hub

nVISAGE Data Viewer