Introduction
This is an online multi data ware house
project focuses on developing a web application that manipulates the data and
predict the future needs of electricity to meet the supply-chain management and
to introduce the new tariff rates/taxes per unit. Data is available for
analysis from different electricity distribution companies such as LESCO, FESCO
etc. it is a
Online Multi
Version Data Warehouse with an additional feature of versioning to manage the
change in DWH (Data Warehouse) as well as for better analysis.
1.2 Scope
We are going to develop an online system which helps companies in Distribution of Electricity in different areas. This is a web based system which can be accessed anywhere in country. This is an online multi version Data warehouse project which store record of supply and demand of Electricity on different times in different areas. Record of supply demand and tariff helps management to take profitable decisions.
Project objectives:
These are the main
objectives of this project
1. Monitoring the transmit ion distribution of
electricity in different areas.
2. Keep the record of Electricity Load, supply, Cost,
Tariff, revenue
3. To meet the supply and demand challenge online system
Predict (estimate) the feature needs of electricity in different areas of
country.
4. This system also helpful for management to calculate
tariff to get exceptional amount of revenue.
5. This data warehouse store data according to different regional electricity distribution companies such as
GEPCO, QESKO, KESCO
6. Online data warehouse System consist of additional
feature of versioning
1.3 definitions, acronyms and abbreviations
Definitions:
Data ware house:
A
complete repository of historical corporate data extracted from transaction
systems that is available for ad-hoc access by knowledge workers
Sequence Diagrams
A sequence
diagram is a kind of interaction diagram that shows how
processes operate with one another and in what order
Architecture Design
Diagram
An architectural
model is a rich and rigorous diagram which is created using
available standards. An architectural model is an expression of a viewpoint in
software architecture.
Class Diagram
A class diagram in
the Unified Modeling Language (UML) is a type of static structure
diagram that describes the structure of a system
Interface Design
Interface design deals
with the process of developing a method for two or more modules in a system to
connect and communicate.
Test Cases
A test case
is a set of conditions or variables under which a tester will determine whether
an application software system
Acronyms and Abbreviations:
Unified Modeling Language (UML)
Entity-relationship
(ER)
Data Warehouse (DWH)
Graphic user interface (GUIs)
Extraction, Transformation, and Loading (ETL)
