Digital Energy  Utility Operations Systems  Energy Management System  Database Editor - Part I
Database Editor - Part I

Digital Energy Energy Management Systems
Purchase this course on our online store.
Visit Store


Description

This course is an introduction to the organization of the relational database for the PowerOn Reliance system. The concept of a relational database view is presented to provide the information required to populate the SCADA portions of the database. These tables include point tables (status, analog, accumulator, etc.), as well as the supporting tables required to incorporate customer requirements. The data is presented from the focal point of the database views as designed for the PowerOn Reliance system. This course trains the user on database editing operations using the PowerOn Reliance Database Editor, which provides a simplified, user-oriented picture of the underlying database. The class also covers bulk data loads into the database. Students use standard database batch files as examples on how to construct their own batch files. The presentation also encompasses utility support programs related to database maintenance and file integrity. Various database views are examined to identify the structure of the editing system and its related functional interfaces.

Duration

2 Days

Prerequisites

Software Architecture for PowerOn Reliance
Unix Fundamentals
SQL Basics

Objectives

Upon completion of the course, the participant will be able to:

Demonstrate familiarity with PowerOn Reliance database terminology

Identify and describe standard database views

Initialize and use a database editor session to enter new data into the database

Efficiently use both interactive and batch editing processes

Demonstrate the use of database editor search techniques