Building a secure star schema in data warehouses by an extension of the relational package from CWM

Computer Standards and Interfaces

Volumn 30, Issue 6, 2008, Pages 341-350

  Soler, Emilio ^a   Trujillo, Juan ^b   Fernández Medina, Eduardo ^c   Piattini, Mario ^c  

^a UNIVERSITY OF MATANZAS   (Cuba)

^b UNIVERSITY OF ALICANTE   (Spain)

^c Alarcos Research Group   (Spain)

Author keywords

CWM; Data Warehouses; Security; Star scheme

Indexed keywords

ADMINISTRATIVE DATA PROCESSING; ARCHITECTURAL DESIGN; ARTIFICIAL INTELLIGENCE; COMPUTER NETWORKS; DATA WAREHOUSES; DATABASE SYSTEMS; DECISION MAKING; DECISION SUPPORT SYSTEMS; DECISION THEORY; DIFFRACTIVE OPTICAL ELEMENTS; HEALTH; MANAGEMENT INFORMATION SYSTEMS; METADATA; PACKAGING; PLANERS; STANDARDS; WAREHOUSES;

CASE STUDIES; COMMERCIAL SYSTEMS; CONCEPTUAL MODELLING; DECISION SUPPORTS; DESIGN PHASES; EARLY STAGES; ELSEVIER (CO); EXTENSION MECHANISMS; IN ORDER; META MODELLING; MULTIDIMENSIONAL (MD); RELATIONAL TABLES; SECURITY MEASURES; SECURITY REQUIREMENTS; STAR SCHEMA;

SECURITY OF DATA;

EID: 44949248387     PISSN: 09205489     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.csi.2008.03.002     Document Type: Article

References (37)

1. Amaral G.C.M., and Campos M.L.M. AQUAWARE: a data quality support environment for DataWarehousing. XIX Simpóosio Brasileiro de Banco de Dados (SBBD'04), Brasília, DF, Brasil (2004) 121-133
2. ANSI/SPARC Report. ACM SIGMOD Newsletter 7 2 (1975)
3. Devanbu P., and Stubblebine S. Software engineering for security: a roadmap. presented at The Future of Software Engineering, Limerick, Ireland (2000) 227-239
4. Dhillon G., and Backhouse J. Information systems security management in the new millenium. Communications of the ACM 43 7 (2000) 125-128
5. Essmayr W., Weippl E., Lichtenberger F., Winiwarter W., and Mangisengi O. An authorization model for data warehouses and OLAP. Workshop On Security In Distributed Data Warehousing, in conjunction with 20th IEEE Symposium on Reliable Distributed Systems (SRDS'2001), USA (2001) 9-13
6. Fernández-Medina E., Trujillo J., Villarroel R., and Piattini M. Access control and audit model for the multidimensional modeling of data warehouses. Decision Support Systems 42 3 (2006) 1270-1289
7. Fernández-Medina E., Trujillo J., Villarroel R., and Piattini M. Developing secure data warehouses with a UML extension. Information Systems 32 6 (2007) 826-856
8. Inmon W.H. Building the Data Warehouse. 3er Edition (2002), Wiley & Sons, New York
9. Katic N., Quirchmayr G., Schiefer J., Stolba M., and Tjoa A.M. A prototype model for data warehouse security based on metadata. Proceedings of the 9th International Workshop on Database and Expert Systems Applications (DEXA'98), Vienna, Austria (1998) 300-309
10. KirkgÄoze R., Katic N., Stolda M., and Tjoa A.M. A Security Concept for OLAP. 8th International Workshop on Database and Expert System Applications (DEXA'97), Toulouse, France (1997) 619-626
11. Luján-Mora S., Trujillo J., and Song I.Y. A UML profile for multidimensional modeling in data warehouses. Data & Knowledge Engineering (DKE) 59 3 (2006) 725-769
12. Liu Y., Sung S.Y., and Xiong H. A cubic-wise balance approach for privacy preservation in data cubes. Information Sciences 176 9 (2006) 1215-1240
13. Maier T. A formal model of the ETL process for OLAP-based web usage analysis. KDD Workshop on Web Mining and Web Usage Analysis (WebKDD'04), Seatle,Washington, USA (2004) 23-34
14. Mazón J.-N., Trujillo J., Serrano M., and Piattini M. A MDA approach for the development of data warehouses. Decision Support Systems 45 1 (2008) 41-58
15. Mazón J.N., Pardillo J., and Trujillo J. A Model-Driven Goal-Oriented Engineering Approach for Data Warehouses. Workshop on Requirements. Intentions and Goals in Conceptual Modeling (RIGiM) in conjunction with the Twenty-Sixth International Conference on Conceptual Modeling (ER'07), Auckland, New Zealand (2007) 255-264
16. McDermott J. Visual security protocol modeling. Proceedings of the 2005 workshop on New security paradigms NSPW'05, Lake Arrowhead, California, USA (2005) 97-109
17. Medina E., and Trujillo J. A standard for representing multidimensional properties: the CommonWarehouse Metamodel (CWM). presented at 6th East-European Conference on Advances in Databases and Information Systems (ADBIS02), Bratislava, Slovakia (2002)
18. Melchert F., Schwinn A., Herrmann C., and Winter R. Using reference models for data warehouse metadata management. 11th Americas Conference on Information Systems (AMCI'05), Omaha, NE, USA (2005) 1316-1326
19. OMG. Common Warehouse Metamodel Specification 1.1 (2003)
20. OMG. Common Warehouse Metamodel (CWM) Specification 1.1 vol. 2 (2002), Extensions
21. OMG. In: Mukerji J.M.a.J. (Ed). MDA Guide Version 1.0.1 (2003), OMG
22. OMG. MOF 2.0 QVT Final Adopted Specification (2005)
23. Poole J., Chang D., Tolbert D., and Mellor D. Common Warehouse Metamodel (2002), John Wiley & Sons, Inc., New York
24. Priebe T., and Pernul G. A pragmatic approach to conceptual modeling of OLAP security. 20th International Conference on Conceptual Modeling (ER'01), Yokohama, Japan (2001) 311-324
25. Priebe T., and Pernul G. Towards OLAP security design - survey and research issues. Proceedings of the 3rd ACM international workshop on Data Warehousing and OLAP (DOLAP'00), Virginia, USA (2000) 33-40
26. Poole J., Chang D., Tolbert D., and Mellor D. Common Warehouse Metamodel Developers Guide (2003), Wiley Publishing, Inc, Indianapolis, Indiana
27. Rosenthal A., and Sciore E. View security as the basic for data warehouse security. Workshop on Design and Management of Data Warehouse (DMDW'00), Sweden (2000)
28. Saltor F., Oliva M., Abelló A., and Samos J. Building secure DataWarehouse schemas from federated information systems. Heterogeneous Information Exchange and Organizational Hubs (2002) 123-134 KA
29. Santana A.S., and Moura A.M.d.C. Metadata to support transformations and data & metadata lineage in a warehousing environment. Data Warehousing and Knowledge Discovery (DAWAK'04), Zaragoza, Spain (2004) 249-258
30. Soler E., Trujillo J., Fernández-Medina E., and Piattini M. A set of QVT relations to transform PIM to PSM in the design of secure data warehouses. Second International Conference on Availability, Reliability and Security (ARES'07), Vienna, Austria (2007) 644-654
31. Soler E., Villarroel R., Trujillo J., Fernández-Medina E., and Piattini M. Representing security and audit rules for DW at the logical level by using the CWM. First International Conference on Availability, Reliability and Security (ARES'06), Vienna, Austria (2006) 914-921
32. Sung S.Y., Liu Y., Xiong H., and Ng P.A. Privacy preservation for data cubes. Knowledge and Information Systems 9 1 (2006) 38-61
33. Thess M., and Bolotnicov M. XELOPES Library Documentation Version 1.2.3, Prudsys AG (2004)
34. Villarroel R., Fernández-Medina E., Piattini M., and Trujillo J. A UML 2.0/OCL extension for designing secure DWs. Journal of Research and Practice in Information Technology 1 38 (2006) 31-43
35. Wang L., Sushil J., and Duminda W. Securing OLAP data cubes against privacy breaches. presented at IEEE Symposium on Security and Privacy, Berkeley, California, USA (2004)
36. E. Yu, Modelling Strategic Relationships for Process Reengineering. PhD thesis, University of Toronto, Canada (1995).
37. Zhao X., and Huang Z. A formal framework for reasoning on metadata based on CWM. 25th International Conference on Conceptual Modeling (ER'06), Tucson, AZ, USA (2006) 371-384