CFP last date
20 December 2024
Reseach Article

Data Cube Representation for Vehicle Insurance Policy System

by Narander Kumar, Vishal Verma, Vipin Saxena
International Journal of Computer Applications
Foundation of Computer Science (FCS), NY, USA
Volume 58 - Number 1
Year of Publication: 2012
Authors: Narander Kumar, Vishal Verma, Vipin Saxena
10.5120/9243-3372

Narander Kumar, Vishal Verma, Vipin Saxena . Data Cube Representation for Vehicle Insurance Policy System. International Journal of Computer Applications. 58, 1 ( November 2012), 1-4. DOI=10.5120/9243-3372

@article{ 10.5120/9243-3372,
author = { Narander Kumar, Vishal Verma, Vipin Saxena },
title = { Data Cube Representation for Vehicle Insurance Policy System },
journal = { International Journal of Computer Applications },
issue_date = { November 2012 },
volume = { 58 },
number = { 1 },
month = { November },
year = { 2012 },
issn = { 0975-8887 },
pages = { 1-4 },
numpages = {9},
url = { https://ijcaonline.org/archives/volume58/number1/9243-3372/ },
doi = { 10.5120/9243-3372 },
publisher = {Foundation of Computer Science (FCS), NY, USA},
address = {New York, USA}
}
%0 Journal Article
%1 2024-02-06T21:01:22.843036+05:30
%A Narander Kumar
%A Vishal Verma
%A Vipin Saxena
%T Data Cube Representation for Vehicle Insurance Policy System
%J International Journal of Computer Applications
%@ 0975-8887
%V 58
%N 1
%P 1-4
%D 2012
%I Foundation of Computer Science (FCS), NY, USA
Abstract

On-Line Analytical Processing (OLAP) systems have a strong focus on the interactive analysis of data and typically provide extensive capabilities for visualizing the data and generating summary statistics. Most of the data sets can be represented as a table, where each row is an object and each column is an attribute. Data cube represents the multidimensional data with all possible aggregates. The three dimensional data cubes represent the different attributes entirely controlled with the help of objects. In general, a data cube is generalization of statistical terminology as a cross-tabulation. In the present work, authors have designed a framework of OLAP data cube to analyze the Vehicle Insurance Policy (VIP) system to identify the entity, which is highly preferred by the customer. The study describes a methodology with OLAP data cube and pivot table as well as a correlation technique which represents strong relationship among the data attributes. Tables and graphs are designed for the sample database of the Vehicle Insurance Policy System

References
  1. James Rumbaugh, ER Is UML, Journal of Information Systems Education, Vol. 17(1), 2006.
  2. Chaudhuri, S. and Dayal, U. , An Overview of Data Warehousing and OLAP Technology, SIGMOD Record Volume 26, Number 1, September 1997.
  3. Samtani, S. , Mohania, M. K. , Kumar, V. and Kambayashi, Y. , Recent Advances and Research Problems in Data Warehousing, ER Workshops 1998.
  4. Hurtado, C. , Mendelzon, A. and Vaisman, A. , Maintaining Data Cubes under Dimension Updates, Proc IEEE/ICDE' 99.
  5. Codd, E. F. , Codd, S. B. and Salley, C. T. , Providing OLAP (On-Line Analytical Processing) to User-Analysts: An IT Mandate, Technical report, 1993.
  6. Connolly, T. and Begg, C. , Database System: A Practical Approach to Design, Implementation, and Management, Addison-Wesley Longman, Inc. , 1999.
  7. Buzydlowski, J. W. , Song, II-Y. and Hassell, L. , A Framework for Object-Oriented On-Line Analytic Processing, DOLAP 1998.
  8. Cabibbo, L. and Torlone, R. , A Logical Approach to Multidimensional Databases, EDBT 1998.
  9. Kimball, R. , The Data Warehouse Lifecycle Toolkit, John Wiley & Sons, Inc. , 1998.
  10. Cabibbo, L. and Torlone, R. , A Logical Approach to Multidimensional Databases, Lecture Notes in Computer Science, number 1377 in proc. of the 6th Int. Conf. On Extending Database Technology, (EDBT'98), pages 183-197, Valencia, March, 1998.
  11. Nguyen. T. B. , Tjoa, A M. and Wagner, R. R. Conceptual Object Oriented Multidimensional Data Model for OLAP, Technical Report, IFS, Cited by 51, Vienna 1999.
  12. Trujillo J. and Palomar, M. , An Object Oriented Approach to Multidimensional Database, Conceptual Modeling (OOMD), DOLAP, 1998.
  13. Codd, E. F. , Codd, S. B. and Salley, C. T. , Providing OLAP to User-Aanalysts: An IT Mandate". Technical report, 1993.
  14. Kimball, R. , The Data Warehouse Lifecycle Toolkit, John Wiley & Sons, Inc. , 1998.
  15. Gyssens. M. and Lakshmanan. L. , A Foundation for Multi-Dimensional Databases, In the 33rd Intl. Conf. On Very Large Database Conference (VLDB'97), pp 106-115, 1997.
  16. Hurtado C. , Mendelzon A. and Vaisman A. , Maintaining Data Cubes under Dimension Updates, proceedings in the fifteenth international conference on Data Engineering, Washington DC (pp. 346-355).
  17. Vassiliadis, P. , Modeling Multidimensional Data Bases, Cubes and Operations, In proc. 10th Scientific and Statistical Database Management Conference (SSDBM '98), Capri, Italy, June 1998.
  18. Mangisengi O. , Tjoa A. M. and Wagner R. R. , Multidimensional Modeling Approaches for OLAP, Proceedings of the Ninth International Database Conference "Heterogeneous and Internet Databases", 1999, ISBN 962-937-046-8. Ed. J. Fong, Hong Kong, 1.
  19. Chaudhuri S and Dayal U. , "An Overview of Data Warehousing and OLAP technology", ACM Sigmod Record vol. 26 (1), March 1997.
Index Terms

Computer Science
Information Sciences

Keywords

OLAP OOMD Data Cube Pivot Table Correlation Coefficient