Utility Company Power Outage Management System Computer Science Essay

Published:

This essay has been submitted by a student. This is not an example of the work written by our professional essay writers.

Energy Power Company will provide constant, reliable service to all customers whether residential, commercial or industrial.  We will provide up to date information to our customers regarding their outage which will include timely information on restoration efforts and cause of outage.  Our customer base will be over 95% satisfied with our restoration efforts.  In addition to our reactive response time, we will work to become a member of the community in which our customers reside.  This will include community outreach and education.

Requirements phase was done by all 3 members of the team by dividing up tasks, then working with each other to finalize the requirements. Final project work was divided up by having the database created and populated by Birendra, procedures and functions developed by Mark and the project documentation and presentation done by Philip with each team member working to finalize all facets of the project.

Energy Power Company provides electricity and natural gas service to customers across the state. Customers can utilize either electrical service, gas service, or both services from Energy Power Company. Energy Power has regional location throughout the state, which contain call centers to track customer outages. Each regional location consists of one to many service centers that are used to dispatch crews to analyze and repair outages or escalate repairs to advanced crews based on complexity, hazards, or surrounding concerns.

Rapid growth in residential homes and commercial office spaces coupled with enhanced reporting requirements for government agencies are proving Energy Power Company's current file based outage system needs to be replaced.

Mission Statement

The purpose of Outage Management System (OMS) is to maintain the data related to customers power outages, outage frequency and resolutions.

Mission Objectives

Insert, update and delete data on outages

Insert, update and delete data on employees

Insert, update and delete data on outage crews

Insert, update and delete data on customers

Insert, update and delete data on service centers

Perform searches and report on outages

Perform searches and report on employees

Perform searches and report on outage crews

Perform searches and report on customers

Perform searches and report on service centers

Track status on outages

Track location on outage crews

Track outages by customers

Track size of service centers

Track outage recovery times by crews

Application Background

The database system being created is to support an application for power outage management. OMS is responsible for tracking the occurrences and repairs of power outages. Anyone can call in to report an outage. The outage is tracked one time, however all calls to report an outage must be recorded. While recording the outage, the user will gather information to aid the utility company in resolving the outage such as the specific outage location, down lines, fires, fallen trees, and neighbors building observations. This information is used to create dispatch records for field crews that they receive on remote laptops within their vehicles.

Select users for the OMS system utilize specially designed views of the data to determine the order in which crews are dispatched to outages as well as which type of crew is dispatched to each outage. Fires, fallen trees and down lines all must be categorized as hazards to allow for specialized crews to be contacted and dispatched. Most outages require a troubleshooter to do the initial analysis. The troubleshooter can either fix the outage or create an order for another crew if the outage is beyond their ability to repair.

OMS needs to track all customers and their addresses. Each customer address is associated with a service center. Crews are dispatched from each service center and several service centers are contained in a region.

After the outage has been restored, the crew updates the record on their laptop. Another set of employees will then verify the information entered by the crew and provide additional details based upon their knowledge of the electrical grid and various other details. This information is used later to generate reports.

Data Definitions

Region

A defined area of the state that represents a large service area

Service center

A defined area of a region that is serviced by a specific collection of crews

Outage Call Center

Department within the organization that answers outage calls and opens initial outage detail

Outage

Any event that obstruct power line to the customer.

Employee

A person employed in the OMS company in various roles

Dispatch record aka Outage Assignment

A record is created for any outage that was reported which is given to field crew for repair purpose.

Troubleshooter

An employee who performs initial analysis of an outage. The troubleshooter can either fix the outage or create an order for another crew if the outage is beyond their ability to repair.

Field crew

An employee who performs the repair of an outage that could not be performed by a troubleshooter.

Customer

A person that has an account with the power company but may also be classified as a non-customer

Calls

A call received by a customer that has been made to report an outage or hazardous condition

Outage Crew aka Crew

A specialized employee that has been trained to restore power to customers and address the various problems that may exist

Troubleshoot Crew

Typically initial crew sent to determine the reason for the outage and able to repair select outage types.

Line Crew

Specific crew used to address downed lines

Forestry Crew

Specific crew used to address downed trees

Hazard

A condition associated with an outage that requires specialized crews and/or equipment to repair.

Wire Hazard

Contains specific details about hazards as it relates to downed wires, etc

Transformer Hazard

Contains specific details about hazards as it relates to transformers affected or affecting hazards such as transformer information on a fire.

Pole Hazard

Contains specific details about hazards as it relates to poles. Pole information gathered will aid in determining crews to dispatch to repair downed/broken poles.

Customer Outages

Details that tracks the customers impacted by outages

Call Detail

Details about each call from various customers about outages.

Application Scope

This program will be a departmental application. This program excludes the enterprise related data and the application. This programs tracks all the calls related to the outages within the region as well as all related outage data. OMS will not track HR related functions, customer payments, nor regional company data.

Business Functions/Rules

OMS will track power outages.

Anyone can call in to report an outage.

An outage is tracked one time.

All calls to report an outage must be recorded.

Outage location, down lines, fires, fallen trees, and neighbors building observations are tracked.

Fires, fallen trees and down lines all must be categorized as hazards.

OMS needs to track all customers and their address.

Each customer address is associated with a service center.

Crews are dispatched from each service center and several service centers are contained in a region.

Outages cannot be closed when it has open hazards.

Enterprise Data Model Entities

Outages

Many customers may be impacted by one outage. A customer may have many outages. An outage may contain hazards.

Customer

Many customers may report one outage. Non-customers may report an outage. One customer may report one outage many times.

Service Centers

One Service Center contains many employees. Many Service Centers belong in a region.

 

Employee

One employee belongs to a service center. One employee may be a member of a crew. One employee may handle many outages.

Enterprise Data Model

Functional Decomposition

Business Function to data Entity Matrix

Data Entity Types

Business Functions

Calls

Hazards

Customer

Outages

Region

Service Center

Crews

Employee

Customer Calls

X

X

X

X

X

Enter Outage Data

X

X

X

X

X

Dispatch

X

X

X

X

X

X

Analyze Outage Cause

X

X

X

X

Repair Outage

X

X

X

X

Outage Verification

X

X

X

X

Outage Reporting

X

X

X

X

Outage Data Gathering

X

X

X

X

Data Maintenance

X

X

Manage Service Center

X

X

Logical Design:

Region

RegionID

RegionName

Address

ServiceCenter

ServiceCenterID

ServiceCenterName

Address

RegionID

Employee

EmployeeID

EmployeeName

Address

ServiceCenterID

crewleader

Customer

CustomerID

CustomerName

Address

ServiceCenterID

Phone

transforferID

Calls

CallID

CustomerID

CallerPhone

OutageID

ServiceCenterID

WorkDescription

EmployeeID

NotifiedDate

Crews

CrewID

EmployeeID

CrewType

Outages

OutageID

OutageLocation

RestorationDate

ServiceCenterID

OutageType

CustomerOutages

OutageID

CustomerID

NotifiedFixed

CrewAssignment

OutageID

CrewID

Active

MaterialsRequired

VehicleRequired

Hazards

HazardID

OutageID

HazardType

Arcing

Fire

Restoration

Date

NotifyPolice

NotifyFire

Rescue

Severity

Pole

HazardID

PoleID

PoleType

PoleCapacity

PoleTagNumber

PoleOwner

WildlifeProtection

Description

Wire

HazardID

WireID

WireDown

WireInsulation

Phase

Description

Transformer

HazardID

TransformerID

TransformerType

TransformerKVA

TransformerFeederLine

Description

Model Differences

Additional attributes

Service Center

Added RegionID column. Was in original 3NF, missed on diagram.

Customer

Service Center ID. Was in original 3NF, missed on diagram.

Transformer ID. Added to demonstrate a portion of complex data used to track customers on the utility grid.

Employee

Service Center ID. Was in original 3NF, missed on diagram.

Crew Leader. Added to allow for tracking crew leaders and allow for reporting.

Calls

Added Work Description and EmployeeID from Call Detail table.

Hazards - combined with Outage Hazard. Many to Many without linker due to limited use, higher join and faster performance as 1 table.

Added Restoration Date

Added Notified Police

Added Notified Rescue

Added Hazard Type

Pole - Added detail to allow for complex joining to data grid (outside of scope) to automatically include customers in outages

Added Description

Added PoleID

Outages

Added ServiceCenterID column. Was in original 3NF, missed on diagram.

Added Restoration Date to allow for tracking outage time length.

Added Outage Type. Allows for non-customers calling in.

Transformer

Added Transformer ID to show complex grid computations that will automatically add customers to outages based on locations.

Tables removed

Call Detail

Combined with Calls. No reason to keep separate.

Work Log

Project Proposal

Mark McArthey

Contributor

Project Proposal

Biren Yonjon

Contributor

Project Proposal

Philip Hauser

Contributor

Requirement Specification - Application Scope

Philip Hauser

Author

Requirement Specification - Data Definitions

Biren Yonjon

Author

Requirement Specification - Detailed Requirements

Biren Yonjon

Author

Requirement Specification - Enterprise Data Model

Mark McArthey

Author

Requirement Specification - Function Matrix

Mark McArthey

Author

Requirement Specification - Functional Decomposition

Philip Hauser

Author

Requirement Specification - Application Scope

Biren Yonjon

Contributor

Requirement Specification - Enterprise Data Model

Biren Yonjon

Contributor

Requirement Specification - Function Matrix

Biren Yonjon

Contributor

Requirement Specification - Functional Decomposition

Biren Yonjon

Contributor

Requirement Specification - Application Scope

Mark McArthey

Contributor

Requirement Specification - Data Definitions

Mark McArthey

Contributor

Requirement Specification - Detailed Requirements

Mark McArthey

Contributor

Requirement Specification - Functional Decomposition

Mark McArthey

Contributor

Requirement Specification - Data Definitions

Philip Hauser

Contributor

Requirement Specification - Detailed Requirements

Philip Hauser

Contributor

Requirement Specification - Enterprise Data Model

Philip Hauser

Contributor

Requirement Specification - Function Matrix

Philip Hauser

Contributor

Database Design - EER

Mark McArthey

Author

Database Design - EER Attributes

Philip Hauser

Author

Database Design - Logical Model

Biren Yonjon

Author

Database Design - Map ER to relations

Biren Yonjon

Author

Database Design - EER Attributes

Mark McArthey

Contributor

Database Design - Logical Model

Mark McArthey

Contributor

Database Design - Map ER to relations

Mark McArthey

Contributor

Database Design - EER

Philip Hauser

Contributor

Database Design - Logical Model

Philip Hauser

Contributor

Database Design - Map ER to relations

Philip Hauser

Contributor

Database Design - EER

Biren Yonjon

Contributor

Database Design - EER Attributes

Biren Yonjon

Contributor

DML and DDL

Biren Yonjon

Author

DML and DDL

Mark McArthey

Author

DML and DDL

Philip Hauser

Author

Writing Services

Essay Writing
Service

Find out how the very best essay writing service can help you accomplish more and achieve higher marks today.

Assignment Writing Service

From complicated assignments to tricky tasks, our experts can tackle virtually any question thrown at them.

Dissertation Writing Service

A dissertation (also known as a thesis or research project) is probably the most important piece of work for any student! From full dissertations to individual chapters, we’re on hand to support you.

Coursework Writing Service

Our expert qualified writers can help you get your coursework right first time, every time.

Dissertation Proposal Service

The first step to completing a dissertation is to create a proposal that talks about what you wish to do. Our experts can design suitable methodologies - perfect to help you get started with a dissertation.

Report Writing
Service

Reports for any audience. Perfectly structured, professionally written, and tailored to suit your exact requirements.

Essay Skeleton Answer Service

If you’re just looking for some help to get started on an essay, our outline service provides you with a perfect essay plan.

Marking & Proofreading Service

Not sure if your work is hitting the mark? Struggling to get feedback from your lecturer? Our premium marking service was created just for you - get the feedback you deserve now.

Exam Revision
Service

Exams can be one of the most stressful experiences you’ll ever have! Revision is key, and we’re here to help. With custom created revision notes and exam answers, you’ll never feel underprepared again.