online multi data ware house

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)