25 Hits in 5.8 sec

Applying QVT in Order to Implement Secure Data Warehouses in SQL Server Analysis Services

Carlos Blanco, Ignacio García Rodríguez de Guzmán, David G. Rosado, Eduardo Fernández-Medina, Juan Trujillo
2009 Journal of research and practice in information technology  
in SQL Server Analysis Services from our secure multidimensional conceptual model (SECDW) by using QVT transformations.  ...  By following the MDA approach we have created an architecture with which to develop secure Data Warehouses, and in this paper we complete this architecture, thus obtaining secure multidimensional code  ...  They then went on to implement this in SQL Server Analysis Services 2000 by using Multidimensional Expressions (MDX).  ... 
dblp:journals/acj/BlancoGRFT09 fatcat:mhiul5zqa5hqlcsplhpvkvp5xe

Automatic Generation of Secure Multidimensional Code for Data Warehouses: An MDA Approach [chapter]

Carlos Blanco, Ignacio García-Rodríguez de Guzmán, Eduardo Fernández-Medina, Juan Trujillo, Mario Piattini
2008 Lecture Notes in Computer Science  
We have proposed an MDA architecture to develop secure Data Warehouses which allows them to be modeled at different abstraction levels (business, conceptual, logical and code level).  ...  Data Warehouses manage vital information for the decision making process, which may be discovered by unauthorized users if we do not establish security measures in all the stages of the development process  ...  Server Analysis Services (SSAS) platform.  ... 
doi:10.1007/978-3-540-88873-4_9 fatcat:nh2u2f7rqvdoji5ao6tt7bqiom

Towards a Modernization Process for Secure Data Warehouses [chapter]

Carlos Blanco, Ricardo Pérez-Castillo, Arnulfo Hernández, Eduardo Fernández-Medina, Juan Trujillo
2009 Lecture Notes in Computer Science  
Data Warehouses (DW) manage crucial enterprise information used for the decision making process which has to be protected from unauthorized accesses.  ...  Furthermore, legacy systems need a reverse engineering process in order to accomplish re-documentation for detecting new security requirements as well as system's design recovery to enable migration and  ...  specific OLAP platform, SQL Server Analysis Services (SSAS), by using a set of Model-to-Text (M2T) rules.  ... 
doi:10.1007/978-3-642-03730-6_3 fatcat:kcy7klzdyzg7xbcc4envkfwnz4

Transforming Conceptual Model into Logical Model for Temporal Data Warehouse Security: A Case Study

Marwa S, Mohamed E., Laila M., Yehia K.
2012 International Journal of Advanced Computer Science and Applications  
This paper proposes a set of rules to transform PIM model for secure temporal data warehouse (TDW) to PSM model, we apply the QVT language to the development of a secure data warehouse by means of a case  ...  In this paper, we are using the Model Driven Architecture (MDA) approach to represent logical model requirements for secure Temporal Data Warehouses (TDW).  ...  commercial tools as SQL Server Analysis Services to complete our MDA framework.  ... 
doi:10.14569/ijacsa.2012.030320 fatcat:o3gamnxhwvhzblbc5bonmws7ci

A Model Driven Architecture Approach to Generate Multidimensional Schemas of Data Warehouses

Amine Azzaoui, Ouzayr Rabhi, Ayyoub Mani
2019 International Journal of Online and Biomedical Engineering (iJOE)  
The main reason for building data warehouses is to improve the quality of information in order to achieve specific business objectives such as competitive advantage or improved decision-making.  ...  To apply the MDA approach to the Data warehouse construction process, we describe a multidimensional meta-model and specify a set of transformations from a UML meta-model which is mapped to a multidimensional  ...  In [1] , the authors are interested in secure XML data warehouses.  ... 
doi:10.3991/ijoe.v15i12.10720 fatcat:svczcspeonaltj2syfg5dxdbwu

An MDA approach for developing secure OLAP applications: Metamodels and transformations

Carlos Blanco, Guzmán de, Eduardo Fernández-Medina, Juan Trujillo
2015 Computer Science and Information Systems  
; and it defines and implements transformations from conceptual to logical models, as well as from logical models to secure implementation in a specific OLAP tool (SQL Server Analysis Services).  ...  Since the information managed is critical, security constraints have to be correctly established in order to avoid unauthorized access.  ...  SECMDDW (Secure Multidimensional Data Warehouse) and the final implementation in an OLAP tool (SSAS).  ... 
doi:10.2298/csis140617007b fatcat:wz4qavnt2jdz7djcye3e3j3p6e

An architecture for automatically developing secure OLAP applications from models

Carlos Blanco, Ignacio García-Rodríguez de Guzmán, Eduardo Fernández-Medina, Juan Trujillo
2015 Information and Software Technology  
to logical models, and from logical models to the secure implementation into a specific OLAP tool (SQL Server Analysis Services).  ...  Trujillo, An architecture for automatically developing Secure OLAP applications from models, Information and Software Technology (2014), doi: http://dx.defines and implements transformations from conceptual  ...  It runs the transformations developed in this paper to generate the implementation for a certain OLAP tool. In this paper we obtain the implementation for SQL Server Analysis Services.  ... 
doi:10.1016/j.infsof.2014.10.008 fatcat:e755rjwhwfcjljf3z3pkvkankq

A UML profile for multidimensional modeling in data warehouses

Sergio Luján-Mora, Juan Trujillo, Il-Yeol Song
2006 Data & Knowledge Engineering  
Moreover, our proposal is Model Driven Architecture (MDA) compliant and we use the Query View Transformation (QVT) approach for an automatic generation of the implementation in a target platform.  ...  ) UML can be easily extended so that it can be tailored for a specific domain with concrete peculiarities such as the multidimensional modeling for data warehouses.  ...  the conceptual modeling of secure data warehouses.  ... 
doi:10.1016/j.datak.2005.11.004 fatcat:sgx6vozwbjehjfwyhyia4nxtnq

"A veritable bucket of facts" origins of the data base management system

Thomas Haigh
2006 SIGMOD record  
This work has been partially supported by the European Commission under the contract IST-FP6-004559 (project SODIUM: Service Oriented Development in a Unified fraMework).  ...  Acknowledgements The author would like to thank Jef Wijsen and Alain Pirotte for their insightful comments that allowed to improve the quality of the paper. Acknowledgement.  ...  Performance may be significantly improved by using procedural SQL (e.g., T-SQL for SQL Server) with cursors in some steps.  ... 
doi:10.1145/1147376.1147382 fatcat:pk5odqlhqnctdepmcrfsriputi

Handling behavioral semantics in persistent meta-modeling systems

Youness Bazhar
2012 2012 Sixth International Conference on Research Challenges in Information Science (RCIS)  
Moreover, DBMSs offer mechanisms for ensuring all security properties in order to avoid potential conflicts of data modification.  ...  Flexibility of implementation In order to satisfy requirement 5, an operation shall be implemented by a program internal to the database system (e.g., a PL/SQL stored procedure) or external to the PMMS  ...  To show that our approach can be used in a wide range of contexts, we propose in this chapter a case study concerning a model transformation and model analysis applied to real-time model analysis.  ... 
doi:10.1109/rcis.2012.6240459 dblp:conf/rcis/Bazhar12 fatcat:pr6uewtluraajn2fzs3higda2i

Analysis of Compositional Conflicts in Component-Based Systems [chapter]

Andreas Leicher, Susanne Busse, Jörn Guy Süß
2005 Lecture Notes in Computer Science  
Component Based Software Engineering is an emerging discipline that aims at improving software development by means of artifact reuse within a systematically applied construction process.  ...  Acknowledgments First of all, I'd like to thank my family. Without their support and especially without the help of Silke I hadn't been able to finish this work.  ...  Services are applied on these models in a sequential order. The results can either be displayed or handed back to the modeling tool environment.  ... 
doi:10.1007/11550679_6 fatcat:nur2mc3a3jb77gcnk55bxipfby

Industry 4.0 and the New Simulation Modelling Paradigm

Blaž Rodič
2017 Organizacija  
with industry partners and diversification of knowledge of researchers in order to build integrated, multi-level models of cyber-physical systems.  ...  , and the methodologies and technologies they use to overcome the issues.  ...  MS SQL server database describing technical procedures and client's orders.  ... 
doi:10.1515/orga-2017-0017 fatcat:2ywvpkpg5nbohj4i36c4iqva4y

Modeling and Multiple Perceptions [chapter]

Christine Parent, Stefano Spaccapietra, Esteban Zimányi
2017 Encyclopedia of GIS  
Modeling with Pictogrammic Languages OGC's Open Standards for Geospatial Interoperability Vector Data Cross-References Indexing, Query and Velocity-Constrained Privacy Threats in Location-Based Services  ...  Cross-References Computer Environments for GIS and CAD Movement Patterns in Spatio-Temporal Data Cross-References Geospatial Semantic Web, Interoperability Metadata and Interoperability, Geospatial  ...  SQL Transformations In order to achieve a Full MDA process, SQL Transformations have conceived and implemented. They are applied on the SQL Implementation model.  ... 
doi:10.1007/978-3-319-17885-1_805 fatcat:d4t4ossygvcutpfabqn6f3hjcm

A process model template for the support of IT-based logistics planning in the context of Chinese ports

Zhan Chen
2012 unpublished
But in the aspect of design, development and implementation, China is still in its infancy compared with other industrialized countries.  ...  The "design process model" is not only envisaged to serve as a standard process model to design the IT system in the enterprise, but also a collection of some methods, patterns and rules to help designers  ...  For an easier understanding, in this example implementation methods which have been already in Repository are applied.  ... 
doi:10.25365/thesis.23619 fatcat:zqwsepezvbbhtcqwq5njlngaxa

MOPAS 2011 Foreword MOPAS 2011 Committee MOPAS Chairs MOPAS 2011 Technical Program Committee

Michel Diaz, France Exposito, France Laas, Michel Diaz, France Exposito, France Jain, Michel Diaz, France Exposito, France Jain, Mourad Alia, Olivier Curé, Université Paris-Est (+4 others)
Architectures and Services   unpublished
for presenting achievements, surveys and perspectives in the areas of design, architecture and implementation based on ontologies and related models.  ...  The Second International Conference on Models and Ontology-based Design of Protocols, Architectures and Services [MOPAS 2011], held between April 17 and 22 in Budapest, Hungary, proposed a new context  ...  This data can be structured (e.g., DBs) or non-structured (e.g., technical documentation). The most often met solution is relational DBs (e.g., SQL Server, Oracle DB).  ... 
« Previous Showing results 1 — 15 out of 25 results