290 likes | 300 Views
Graphical Data Engineering. Network Manager. Graphical Data Engineering - GDE. Configuration tool for the Network Manager system Flexible and versatile Easy to learn and use Maintains data in the runtime database Total a s well as incremental population
E N D
Graphical Data Engineering Network Manager
Graphical Data Engineering - GDE • Configuration tool for the Network Manager system • Flexible and versatile • Easy to learn and use • Maintains data in the runtime database • Total as well as incremental population • Offline data entry and data preparation, supported by • Interactive tools; Graphical Editor and Forms Interface • Using powerful ORACLE tools • Extensive defaulting and Lookup of proposed or optional values • On-line Help • Extensive model validation and consistency checking • At data entry and at import • By the database • At manual request • Safe and easy to use data processing • The Maintenance Manager tool aids the user • Designed for data import and data reuse
Data Entry A- Sta dt B- Do rf C- Haus en Data Engineering Working Environment Maintenance Environment Run-time Environment Graphical Editor Forms Data Import Run-time PDB Presentation Oracle MDB Customer's Data Source Data Loading Picture Generator Picture files
Data Maintenance tools • Preparation of data for target runtime system(s) Forms Graphical Editor
GDE features – Graphical Editor (1/2) • Easy-to-use graphical user interface gives short training time • Intelligent graphics (symbols know their meaning) for extensive validation • Context sensitive menus give correct hierarchies and object relationships
GDE features – Graphical Editor (2/2) • Network topology derived from graphics ensures correct topology • Object relationships derived from graphics ensures correct and consistent data • Deep copy and paste makes reuse of work possible • Template library gives organized working methods • To Do list makes sure data is plausible before loading
GDE features - Multi record form • Benefits: • General changes are easily done • Reduces engineering costs • Visual inspection of changes • Increases the data quality
Substation Subnet Subnet Bay 1 Bay 4 Transmission line T2Wsystem Bay 5 bus segment ~ Generator bus segment bus segment Transmission line Definition Hierarchy
Data definition and connections STA SUN BUS STA2 CB1 CB2 Station connector (Side B) Internal connection IS1 Routing point STA132STA2 Station connector (Side A)
GDE - Deep copy Copy • Copy the structure of • Station • Subnet • Bay • Individual objects or arbitrary selection of objects • Benefits • Reuse of work • Powerful when copying similar objects Paste ~
GDE - Template Library • Benefits: • Automated work • Easy to use - graphical navigator • Reduced engineering costs
GDE - Data Consistency support features • Graphical Editor • To-do list • Visual topology definition • Database • Constraints • Derived data by triggers • Plausibility check • e.g. HW assignment Bild? T.ex. to-do list
GDE - Simplicity 1:1 DE MDB PDB = • Automated auditing • Automated data processing • Automated offset file generation • Simple and correct maintenance • Full trace-ability Safe and easy to use data processing
GIS Data Import – Customer Situation • Huge initial data transfer • Frequent updates of small data volumes • Several times each day • Both model data and picture data • Not all data can be found in the GIS system • It must be possible to add data in GDE • New objects, e.g. RTU • Extra parameters; e.g reference to Indication
Which Data Can GDE Import? • GDE can import data models that equal Network Manager data model • Mapping can be done outside the import tool • Import media is CSV files (Comma Separated Values) • Flexible specification in user friendly forms of • Scope of data to import • Order between data fields • Data transformation functions
Data Dictionary of GDE Import Tool • Parameters • Tables • Columns • Event Log
Import Data Flow GIS PED500 GIS GDE Run-time Database PictureData • GDE can import totally or incrementally ModelData
GDE Forms are utilized for adding data GDE Maintenance Database + • Data in columns entered by GDE Forms will sustain after re-import
GDE Graphical Editor used for EMS GDE Maintenance Database + • Support for several data sources • Only the tool that created the record can delete the record –Data Consistency Preserved
Data Loading Runtime Database Loading Maintenance Environment Run-time Environment Data Entry Graphical Editor Forms Data Import Run-time PDB Presentation Oracle MDB Customer's Data Source Picture Generator Picture files • Selectively • Totally or Incrementally
On- line Back- up Database Population in on-line environment • Network Manager supports introducing changes directly in the on-line server • does not require any switchover! • Affected objects are automatically taken out-of-service during update • The new database with modified objects can be tested in true real-time environment. • If the test is accepted the engineering change can be approved. • In case of a negative test result, the engineering change may be rejected. GDE - DE400
Maintenance Manager • Each maintenance task managed from one place • Database population • Selectively, only the wanted/changed scope of data • Total or incremental – incremental on record level for fast processing • Data Import
GDE - Configurations • GDE Server • Oracle application server in Tru64 or Windows 2000 Server • GDE Clients • Windows 2000 or Windows XP PCs
GDE - Multi-user support • Parallel working permitted • Data consistency preserved
GDE - Shared Multi Site Maintenance Environment Run-time Environments Offset files GDE tool System 1 (MCC) PDB Offset files System 2 (CC2) PDB Offset files System n (CCn) PDB • An unlimited number of runtime systems may • be defined and loaded with: • common data • shared (overlapping) data • individual data • Resolution is station level
DE tool 1 DE tool n GDE - Distributed Multi Site Maintenance Environments Runtime Environment Offset files System 1 Local changes PDB Subscription Offset files System n PDB Local changes • DE data may be subscribed to and locally modified in different DE tools • The DE tools may reside in the same DE database or in different workstations
GDE - Documentation • Graphical Editor On-line Help • Forms On-line Help • Step by stepUser’s Guide • Data Definition Guides • Installation Guide • Maintainers Guide
Features Graphical data entry and data navigation Flexible scope of data Tables Columns Data and Picture Model Total and Incremental import Several import sources Total and Incremental loading Data Quality focus Extensive defaulting Lookup of proposed or optional values Extensive data model validation Data and consistency checking of entered data Safe and easy to use data processing Graphical Data Engineering