Making the Data Available Network HD maintains raw data storage - - PowerPoint PPT Presentation

Making the Data Available

NVH Controllers convert NVH data to metrics and push them to a data entry client running on any networked server Network HD maintains raw data storage archive and NVH metric database

MajX NVH ShieldTM can monitor data semi-live, or recent results can be pulled from the circulating archives on the NVH controller, Historic data can also be pulled from the permanent NVH database

• n the server

Circulating archive holds recently acquired data files – no permanent file storage here though

3 Terabytes Annually

Database Scanner Query Engine Report Definition Batch Definition Processing Definition Job Scheduler Report Generation Job Job Alarming & Alerting Batch Process Runs Maintenance Actions Support Doc’s

MajX Data ManagerTM

Overview

• Automate mining, analysis and reporting of

data gathered from multiple sources

NVH Controllers

Maintenance Actions Support Doc’s Database Report Definition Job Scheduler Batch Definition Query Engine Processing Definition Report Generation Job Job Alarming & Alerting Batch Process Runs Scanner

MajX Data ManagerTM

The Scanner

• Scan data sources on a programmable

schedule

• Consolidate information and execute

database entry

• Maintain robust connection to each data

source with unsupervised shutdown and disconnect recovery

NVH Controllers

Database Report Definition Job Scheduler Batch Definition Processing Definition Report Generation Job Job Alarming & Alerting Batch Process Runs Scanner Maintenance Actions Support Doc’s Query Engine

MajX Data ManagerTM

Defining a Database Query

• Define database queries that can be

edited, stored and re-used

• Query results are the data source for

batch jobs and reports

• Rich set of query parameters
• Arbitrary number of queries can be

defined

NVH Controllers

Database Job Scheduler Batch Definition Processing Definition Report Generation Job Job Alarming & Alerting Batch Process Runs Scanner Query Engine Maintenance Actions Support Doc’s Report Definition

MajX Data ManagerTM

Defining a Report Definition

• Define reports which draw source data

from database queries and batch processing jobs

• Access predefined templates to create

automated multipage reports

• Arbitrary number of report definitions can

be created and stored for re-use.

Variety of table, SPC and other report types are available

NVH Controllers

Database Job Scheduler Processing Definition Report Generation Job Job Alarming & Alerting Batch Process Runs Scanner Query Engine Report Definition Maintenance Actions Support Doc’s Batch Definition

MajX Data ManagerTM

Batch Processing

• Batch processing sources a database

query that lists archived datafiles

• Analysis batch processing engine mates

a processing definition to data files and computes waveforms and metrics

• Investigate advanced analysis methods

and automate continuing analysis

NVH Controllers

Database Job Scheduler Report Generation Job Job Alarming & Alerting Batch Process Runs Scanner Query Engine Report Definition Batch Definition Maintenance Actions Support Doc’s Processing Definition

MajX Data ManagerTM

Batch Processing Definition

• MajX NVH Shield is a metric design tool to

define batch processing operations

• Or, user API documentation permits user

defined processing definitions

• An arbitrary number of batch processing

engines can be specified with the API

NVH Controllers

Database Report Generation Job Job Alarming & Alerting Batch Process Runs Scanner Query Engine Report Definition Batch Definition Processing Definition Maintenance Actions Support Doc’s Job Scheduler

MajX Data ManagerTM

Scheduling Jobs

• The job scheduler will automate

execution of batch jobs and reports

• A report first refreshes the source query,

and batch job if included, before generating a report updated with the latest results

• Reports can be alarmed with on-screen

notification, email and text messages

NVH Controllers

Database Scanner Query Engine Report Definition Batch Definition Processing Definition Job Scheduler Maintenance Actions Support Doc’s Report Generation Job Job Alarming & Alerting Batch Process Runs

MajX Data ManagerTM

Job Examples

• Alarmed reports can be refreshed often

and alert a user to review results only when an alarm state is encountered

• Scheduler will manage all activities

related to running any number of jobs

Define job frequency Processed job results are accessible in text files

NVH Controllers