Modeling and Design of Data Cube for Electricity Bill Deposit System

Abstract

Due to evolution of object-oriented technology, many of the software industries are converting old structured base database into the object oriented database. It is observed from the literature that limited research work is available for the object-oriented database and a well-known modeling language i.e. Unified Modeling Language is not much applied in the field of the object-oriented database, therefore, present work deals with the modeling of a database of a real case study of the electricity bill deposit system of electricity supply to the different houses of various localities of a city. As the size of database grows then it is very difficult to find the desired record from the database and also to keep the record for future use, therefore, a database cube designing technique is used for storing the three important fields of a database and one can get the desired information from the data cube. Sample queries are also performed for validating the designed UML class diagram for electricity billing system.