CFP last date
20 June 2024
Call for Paper
July Edition
IJCA solicits high quality original research papers for the upcoming July edition of the journal. The last date of research paper submission is 20 June 2024

Submit your paper
Know more
Reseach Article

Modeling and Design of Data Cube for Electricity Bill Deposit System

by Vipin Saxena, Sudhir Kumar Singh
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 80 - Number 11
Year of Publication: 2013
Authors: Vipin Saxena, Sudhir Kumar Singh

Vipin Saxena, Sudhir Kumar Singh . Modeling and Design of Data Cube for Electricity Bill Deposit System. International Journal of Computer Applications. 80, 11 ( October 2013), 11-14. DOI=10.5120/13904-1736

@article{ 10.5120/13904-1736,
author = { Vipin Saxena, Sudhir Kumar Singh },
title = { Modeling and Design of Data Cube for Electricity Bill Deposit System },
journal = { International Journal of Computer Applications },
issue_date = { October 2013 },
volume = { 80 },
number = { 11 },
month = { October },
year = { 2013 },
issn = { 0975-8887 },
pages = { 11-14 },
numpages = {9},
url = { },
doi = { 10.5120/13904-1736 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
%0 Journal Article
%1 2024-02-06T21:54:16.279115+05:30
%A Vipin Saxena
%A Sudhir Kumar Singh
%T Modeling and Design of Data Cube for Electricity Bill Deposit System
%J International Journal of Computer Applications
%@ 0975-8887
%V 80
%N 11
%P 11-14
%D 2013
%I Foundation of Computer Science (FCS), NY, USA

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.

  1. Booch, G. , "Object Oriented Analysis and Design with Application", 2nd Edition, Addison Wesley 1994.
  2. Rambaugh, J. , Jacobson, I and Booch, G. , "The Unified Modeling Language User Guide", Addison Wesley, 1999.
  3. Martin, F. , "UML Distilled: A Brief Guide to the Standard Object Modeling Language", 3rd Edition, Addison-Wesley, Boston, 2000.
  4. Li, M. , "Approach to Formalizing UML Sequence Diagrams", Presented IEEE, Page 1-4, 28 to 29 May, 2011.
  5. Samuel, P. , "Test Sequence Generation from UML Sequence Diagrams", presented IEEE, Page 879-887, 6 Aug. 2008.
  6. Nakamura, Sakamoto, Y. , Inoue, K. , Washizaki, H. and Fukazawa, Y. , "Evaluation of Understandability of UML Class Diagrams by Using Word Similarity", Presented in IEEE, Page 178-187, 20 Dec 2011.
  7. Ali, N. , "A Design of an Assessment System for UML Class Diagram", This Paper appears in Computational Science and its Applications, 2007 ICCSA 2007. International Conference on IEEE Page 539, Aug. 2007.
  8. Chaurasia and Saxena, V. , "Mobile Based Electricity Bill Deposit System Through UML, " Journal of Software Engineering and Applications, Vol. 4(3), 187-190, 2011.
  9. Harinarayan, V. , Rajaraman, A. , and Ulman, J. , "Efficient Implementation of Data Cube via Materialized Views", In Proceedings of ACM SIGMOD Conference Vol. (25), Page No 205-216, Montreal, Canada 1996.
  10. Cabibbo, L. , and Torlone, R. , "A Logical Approach to Multidimensional Database", 6th International Conference on Extending Database technology (EDBT, 98, Valencia, Spain), G. Alonso (eds. ), Lncs, Vol. 1377, Springer, 1998.
  11. Lehner, W. , Albrecht, J. , and Wedekinds, H. , " Normal Forms for Multidimensional Database", In Proceedings of the 10th International Conference on Scientific and Statistical Data Management (SSDBM'98),Italy,1998.
  12. Vanea, A. , and Potolea, R. , "A Method for Dynamically Creating Data Cube Structure", IEEE International Conference Appeared Intelligent Computer Communication and Processing (ICCP), Date 25-27 Aug 2011.
  13. Xie, Z. , and Guang, J. , " The Algorithm of reducing Data Cube Rapidly", Published in: Management and Service Science, 2009. MASS '09. International Conference, Date 20-22 Sept 2009.
  14. Han, J. , and Kamber, M. , "Data Mining: Concepts and Technique", 2nd Edition, Morgan Kaufmann Publishers, March 2006.
  15. Chen, M. , "Multimedia Database Retrieval Based on Data Cube", Proceedings of the IEEE, Page 1265-1269, 2008.
Index Terms

Computer Science
Information Sciences


Object-Oriented Database UML Class Diagram Sequence Diagram Data Cube Queries