Comparative Analysis of Data warehouse Design Approaches from Security Perspectives

International Journal of Computer Trends and Technology (IJCTT)          
© July to Aug Issue 2011 by IJCTT Journal
Volume-1 Issue-3                           
Year of Publication : 2011
Authors : Shashank Saroop, Manoj Kumar.


Shashank Saroop, Manoj Kumar. "Comparative Analysis of Data warehouse Design Approaches from Security Perspectives"International Journal of Computer Trends and Technology (IJCTT),V1(3):286-291 July to Aug Issue 2011 .ISSN Published by Seventh Sense Research Group.

Abstract: ——Data warehouse systems integrate data from heterogeneous sources and are used by decision makers to analyze the status and the development of an organization. Due to the sensitive data contain in the DW it is most important to specify a security, from early stages of DW design so that data must be secured. Traditionally, security was not considered as an important element in modeling of DW. Most of the author starts applying a security at conceptual level to implementation level, however they did not consider a “requirement level” which basically a main levels in DW design. In this paper we have surveyed the literature related to work done by various authors in last few years and Comparison of various approaches in data warehouse design from security perspective by using various parameters


[1] F. Saltor, M. Oliva, A. Abelló, J. Samos, Building secure data warehouse schemas from federated information systems, in: H. Bestougeff, J.E. Dubois, B. Thuraisingham (Eds.), Heterogeneous Information Exchange and Organizational Hubs, Kluwer Academic Publishers, Dordrecht, The Netherlands, 2002, pp. 123–134. ISBN: 1- 4020-0649–7
[2] P. Devanbu, S. Stubblebine, Software engineering for security: a roadmap, in: A. Finkelstein (Ed.), The Future of Software Engineering, ACM Press, New York, 2000, pp. 227–239.
[3] E. Ferrari, B. Thuraisingham, Secure database systems, in: M. Piattini, O. Di´az (Eds.), Advanced Databases: Technology Design, Artech House, 2000.
[4]. R. Kirkgöze, N. Katic, M. Stolda, and A. M. Tjoa, "A Security Concept for OLAP. (DEXA`97)," Toulouse, France
[5]. Rosenthal and E. Sciore, "View Security as the Basic for DW Security," (DMDW`00), Sweden, 2000
[6]. Emilio Soler, Juan Trujillo, Eduardo Fernandez-Medina and Mario Piattini, “A Framework for the Development of Secure Data Warehouses based on MDA and QVT” Second International conference on availability, reliability and security 2007.
[7]Diego Calvanese, Data Integration in Data Warehousing, International Journal of Cooperative Information Systems Vol. 10, No. 3 (2001) 237–271
[8] Golfarelli, M., Maio, D., and Rizzi, S., The Dimensional Fact Model: A Conceptual Model for Data Warehouses. Int. Journal of Cooperative Information Systems (IJCIS), (1998) (2-3): 215-247.
[9]. Sapia, C., Blaschka, M., Höfling, G., and Dinter, B.: Extending the E/R Model for the Multidimensional Paradigm. in 1st Int. Workshop on Data Warehouse and Data Mining.

Keywords-Data Warehouse, Security, Multidimensional modeling, UML extension, MDA, QVT, OLAP.