Modeling and Design of Data Cube for Electricity Bill Deposit System

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.

[1]  Zarina Shukur,et al.  A Design of an Assessment System for UML Class Diagram , 2007, 2007 International Conference on Computational Science and its Applications (ICCSA 2007).

[2]  Luca Cabibbo,et al.  A Logical Approach to Multidimensional Databases , 1998, EDBT.

[3]  Kendall Scott,et al.  UML distilled - a brief guide to the Standard Object Modeling Language (2. ed.) , 2000, notThenot Addison-Wesley object technology series.

[4]  Philip Samuel,et al.  Test Sequence Generation from UML Sequence Diagrams , 2008, 2008 Ninth ACIS International Conference on Software Engineering, Artificial Intelligence, Networking, and Parallel/Distributed Computing.

[5]  Ming Li,et al.  Approach to Formalizing UML Sequence Diagrams , 2011, 2011 3rd International Workshop on Intelligent Systems and Applications.

[6]  Ivar Jacobson,et al.  The Unified Modeling Language User Guide , 1998, J. Database Manag..

[7]  Grady Booch,et al.  Object-Oriented Analysis and Design with Applications , 1990 .

[8]  Jeffrey D. Ullman.  Efficient Implementation of Data Cubes Via Materialized Views , 1996, KDD.

[9]  Jiawei Han,et al.  Data Mining: Concepts and Techniques , 2000 .

[10]  Rodica Potolea,et al.  A method for dinamically creating data cube structures , 2011, 2011 IEEE 7th International Conference on Intelligent Computer Communication and Processing.

[11]  Wolfgang Lehner,et al.  Normal forms for multidimensional databases , 1998, Proceedings. Tenth International Conference on Scientific and Statistical Database Management (Cat. No.98TB100243).

[12]  Hironori Washizaki,et al.  Evaluation of Understandability of UML Class Diagrams by Using Word Similarity , 2011, 2011 Joint Conference of the 21st International Workshop on Software Measurement and the 6th International Conference on Software Process and Product Measurement.

[13]  Pawan Kumar Chaurasia,et al.  Mobile Based Electricity Bill Deposit System through UML , 2011, J. Softw. Eng. Appl..

[14]  Yu Song,et al.  Multimedia database retrieval based on data cube , 2008, 2008 International Conference on Audio, Language and Image Processing.