starER: a conceptual model for data warehouse design
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Designing data marts for data warehouses
ACM Transactions on Software Engineering and Methodology (TOSEM)
A Logical Approach to Multidimensional Databases
EDBT '98 Proceedings of the 6th International Conference on Extending Database Technology: Advances in Database Technology
An Object Oriented Multidimensional Data Model for OLAP
WAIM '00 Proceedings of the First International Conference on Web-Age Information Management
SecureUML: A UML-Based Modeling Language for Model-Driven Security
UML '02 Proceedings of the 5th International Conference on The Unified Modeling Language
Extending the E/R Model for the Multidimensional Paradigm
ER '98 Proceedings of the Workshops on Data Warehousing and Data Mining: Advances in Database Technologies
A Pragmatic Approach to Conceptual Modeling of OLAP Security
ER '01 Proceedings of the 20th International Conference on Conceptual Modeling: Conceptual Modeling
A Framework for the Classification and Description of Multidimensional Data Models
DEXA '01 Proceedings of the 12th International Conference on Database and Expert Systems Applications
DEXA '97 Proceedings of the 8th International Workshop on Database and Expert Systems Applications
A Prototype Model for Data Warehouse Security Based on Metadata
DEXA '98 Proceedings of the 9th International Workshop on Database and Expert Systems Applications
MDA Explained: The Model Driven Architecture: Practice and Promise
MDA Explained: The Model Driven Architecture: Practice and Promise
The Pragmatics of Model-Driven Development
IEEE Software
DWARF: AN Approach for Requirements Definition and Management of Data Warehouse Systems
RE '03 Proceedings of the 11th IEEE International Conference on Requirements Engineering
Tropos: An Agent-Oriented Software Development Methodology
Autonomous Agents and Multi-Agent Systems
Integrating XML Data in the TARGITOLAP System
ICDE '04 Proceedings of the 20th International Conference on Data Engineering
MDA Distilled
Evaluating XML-extended OLAP queries based on a physical algebra
Proceedings of the 7th ACM international workshop on Data warehousing and OLAP
Extending XQuery for analytics
Proceedings of the 2005 ACM SIGMOD international conference on Management of data
Analytical processing of XML documents: opportunities and challenges
ACM SIGMOD Record
Representing UML Snowflake Diagram from Integrating XML Data Using XML Schema
DEEC '05 Proceedings of the International Workshop on Data Engineering Issues in E-Commerce
A relevance-extended multi-dimensional model for a data warehouse contextualized with documents
Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
CIT '05 Proceedings of the The Fifth International Conference on Computer and Information Technology
Model driven security: From UML models to access control infrastructures
ACM Transactions on Software Engineering and Methodology (TOSEM)
YAM2: a multidimensional conceptual model extending UML
Information Systems
Model driven development of secure XML databases
ACM SIGMOD Record
Research in data warehouse modeling and design: dead or alive?
DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
Model-Driven Software Development: Technology, Engineering, Management
Model-Driven Software Development: Technology, Engineering, Management
A UML profile for multidimensional modeling in data warehouses
Data & Knowledge Engineering - Special issue: ER 2003
Access control and audit model for the multidimensional modeling of data warehouses
Decision Support Systems
A UML-based data warehouse design method
Decision Support Systems
Developing secure data warehouses with a UML extension
Information Systems
Model-Based Security Engineering of Distributed Information Systems Using UMLsec
ICSE '07 Proceedings of the 29th international conference on Software Engineering
Evaluation of MDA/PSM database model quality in the context of selected non-functional requirements
DEPCOS-RELCOMEX '07 Proceedings of the 2nd International Conference on Dependability of Computer Systems
Tools for secure systems development with UML
International Journal on Software Tools for Technology Transfer (STTT)
Extended RBAC-based design and implementation for a secure data warehouse
International Journal of Business Intelligence and Data Mining
GRAnD: A goal-oriented approach to requirement analysis in data warehouses
Decision Support Systems
An MDA approach for the development of data warehouses
Decision Support Systems
Building a secure star schema in data warehouses by an extension of the relational package from CWM
Computer Standards & Interfaces
Integrating Data Warehouses with Web Data: A Survey
IEEE Transactions on Knowledge and Data Engineering
XML security - A comparative literature review
Journal of Systems and Software
Expressing OLAP operators with the TAX XML algebra
DataX '08 Proceedings of the 2008 EDBT workshop on Database technologies for handling XML information on the web
UML-Based Modeling for What-If Analysis
DaWaK '08 Proceedings of the 10th international conference on Data Warehousing and Knowledge Discovery
DW 2.0: The Architecture for the Next Generation of Data Warehousing
DW 2.0: The Architecture for the Next Generation of Data Warehousing
An engineering process for developing Secure Data Warehouses
Information and Software Technology
A UML 2.0 profile to define security requirements for Data Warehouses
Computer Standards & Interfaces
Towards a Modernization Process for Secure Data Warehouses
DaWaK '09 Proceedings of the 11th International Conference on Data Warehousing and Knowledge Discovery
A Taxonomy of Model Transformation
Electronic Notes in Theoretical Computer Science (ENTCS)
Finding an application-appropriate model for XML data warehouses
Information Systems
Secure Systems Development with UML
Secure Systems Development with UML
An XML document warehouse model
DASFAA'06 Proceedings of the 11th international conference on Database Systems for Advanced Applications
XML-OLAP: a multidimensional analysis framework for XML warehouses
DaWaK'05 Proceedings of the 7th international conference on Data Warehousing and Knowledge Discovery
X-warehousing: an XML-based approach for warehousing complex data
ADBIS'06 Proceedings of the 10th East European conference on Advances in Databases and Information Systems
Hi-index | 0.00 |
Data warehouses are systems that provide useful information to support the decision making process, thus improving organizations' business processes. These systems integrate heterogeneous sources which are not only limited to their internal business data but also include data from the Web, the latter of which have become increasingly more important in the decision making process in recent years. This has motivated the extensive use of XML in the implementation of data warehouses, in a manner which facilitates data and metadata interchange among the heterogeneous data sources from the Web and the data warehouse. However, the business information that data warehouses manage is crucial and highly sensitive, and must be carefully protected. Security is thus a key issue in the design of data warehouses, regardless of the implementation technology used. It is important to note that the data available on the Web requires particular security considerations which have been specifically tailored to these systems in order to permit their particularities to be captured correctly. Unfortunately, although security issues have been considered in the development of traditional data warehouses, current research lacks approaches with which to consider security when the target platform is based on XML technology. In order to deal with this situation, in this paper we propose a methodological approach for the model driven development of secure XML data warehouses. We also specify a set of transformation rules that are able to automatically generate not only the corresponding XML structure of the data warehouse from secure conceptual data warehouse models, but also the security rules specified within the data warehouse XML structure, thus allowing both aspects to be implemented simultaneously. We additionally introduce our secure XML DW development approach, in which the secure conceptual DW data model, the PIM, is transformed into a secure XML DW, as a PSM, by applying a set of transformation rules. Our proposal is validated through the practical application of our model driven development approach for Modeling Secure XML Data Warehouses to a case study, which is based on a central Airport DW. We first describe the transformation rules defined, then use a step by step illustration to show how they will be applied to the secure conceptual model of the case study to obtain the Secure XML Data Warehouse, thus demonstrating the benefits of our proposal, and finally we analyze how to achieve the secure implementation into commercial database management systems, providing details of the secure implementation in Oracle XML DB 11g.