Results 1 - 10
of
26
Data Mapping Diagrams for Data Warehouse Design with UML
- In Proc. 23rd International Conference on Conceptual Modeling (ER 2004
, 2004
"... In Data Warehouse (DW) scenarios, ETL (Extraction, Transformation, Loading) processes are responsible for the extraction of data from heterogeneous operational data sources, their transformation (conversion, cleaning, normalization, etc.) and their loading into the DW. In this paper, we present ..."
Abstract
-
Cited by 29 (4 self)
- Add to MetaCart
(Show Context)
In Data Warehouse (DW) scenarios, ETL (Extraction, Transformation, Loading) processes are responsible for the extraction of data from heterogeneous operational data sources, their transformation (conversion, cleaning, normalization, etc.) and their loading into the DW. In this paper, we present a framework for the design of the DW back-stage (and the respective ETL processes) based on the key observation that this task fundamentally involves dealing with the specificities of information at very low levels of granularity including transformation rules at the attribute level. Specifically, we present a disciplined framework for the modeling of the relationships between sources and targets in di#erent levels of granularity (including coarse mappings at the database and table levels to detailed inter-attribute mappings at the attribute level).
XML-OLAP: A Multidimensional Analysis Framework for XML Warehouses
- Proc. Sixth Int’l Conf. Data Warehousing and Knowledge Discovery (DaWaK ’05
, 2005
"... Abstract. Recently, a large number of XML documents are available on the Internet. This trend motivated many researchers to analyze them multi-dimensionally in the same way as relational data. In this paper, we propose a new framework for multidimensional analysis of XML docu-ments, which we call XM ..."
Abstract
-
Cited by 19 (1 self)
- Add to MetaCart
(Show Context)
Abstract. Recently, a large number of XML documents are available on the Internet. This trend motivated many researchers to analyze them multi-dimensionally in the same way as relational data. In this paper, we propose a new framework for multidimensional analysis of XML docu-ments, which we call XML-OLAP. We base XML-OLAP on XML ware-houses where every fact data as well as dimension data are stored as XML documents. We build XML cubes from XML warehouses. We propose a new multidimensional expression language for XML cubes, which we call XML-MDX. XML-MDX statements target XML cubes and use XQuery expressions to designate the measure data. They specify text mining op-erators for aggregating text constituting the measure data. We evaluate XML-OLAP by applying it to a U.S. patent XML warehouse. We use XML-MDX queries, which demonstrate that XML-OLAP is effective for multi-dimensionally analyzing the U.S. patents. 1
Developing secure data warehouses with a UML extension
- INFORMATION SYSTEMS
, 2006
"... ... as a very powerful mechanism for discovering crucial business information. Considering the extreme importance of the information managed by these kinds of applications, it is essential to specify security measures from the early stages of the DW design in the MD modeling process, and enforce the ..."
Abstract
-
Cited by 11 (4 self)
- Add to MetaCart
... as a very powerful mechanism for discovering crucial business information. Considering the extreme importance of the information managed by these kinds of applications, it is essential to specify security measures from the early stages of the DW design in the MD modeling process, and enforce them. In the past years, some proposals for representing main MD modeling properties at the conceptual level have been stated. Nevertheless, none of these proposals considers security issues as an important element in its model, so they do not allow us to specify confidentiality constraints to be enforced by the applications that will use these MD models. In this paper, we will discuss the specific confidentiality problems regarding DWs as well as present an extension of the Unified Modeling Language for specifying security constraints in the conceptual MD modeling, thereby allowing us to design secure DWs. One key advantage of our approach is that we accomplish the conceptual modeling of secure DWs independently of the target platform where the DW has to be implemented, allowing the implementation of the corresponding DWs on any secure commercial database management system. Finally, we will present a case study to show how a conceptual model designed with our approach can be directly implemented on top of Oracle 10g.
A Comprehensive Method for Data Warehouse Design
- In Proc. DMDW
, 2003
"... A data warehouse (DW) is a complex information system primarily used in the decision making process by means of On-Line Analytical Processing (OLAP) applications. Although various methods and approaches have been presented for designing dierent parts of DWs, such as the conceptual and logical sc ..."
Abstract
-
Cited by 9 (1 self)
- Add to MetaCart
A data warehouse (DW) is a complex information system primarily used in the decision making process by means of On-Line Analytical Processing (OLAP) applications. Although various methods and approaches have been presented for designing dierent parts of DWs, such as the conceptual and logical schemas or the Extraction-TransformationLoading (ETL) processes, no general and standard method exists to date for dealing with the whole design of a DW. In this paper, we ll this gap by presenting a method based on the Unied Modeling Language (UML) that allows the user to tackle all DW design phases and steps, from the operational data sources to the nal implementation and including the denition of the ETL processes. The main advantages of our proposal are: the use of a standard modeling notation (UML) in the models accomplished in the dierent design phases, the integration of dierent design phases in a single and coherent framework and the use of a grouping mechanism (UML packages) that allows the designer to layer the models according to dierent levels of detail. Finally, we also provide a set of steps that guide the DW design.
M.: Multidimensional Data Modeling for Business Process Analysis
- In: Proceedings of the ER 2007
, 2007
"... Abstract. The emerging area of business process intelligence attempts to enhance the analytical capabilities of business process management systems by employing data warehousing and mining technologies. This paper presents an approach to re-engineering the business process modeling in conformity wit ..."
Abstract
-
Cited by 8 (2 self)
- Add to MetaCart
(Show Context)
Abstract. The emerging area of business process intelligence attempts to enhance the analytical capabilities of business process management systems by employing data warehousing and mining technologies. This paper presents an approach to re-engineering the business process modeling in conformity with the multidimensional data model. Since the business process and the multidimensional model are driven by rather different objectives and assumptions, there is no straightforward solution to converging these models. Our case study is concerned with Surgical Process Modeling which is a new and promising subdomain of business process modeling. We formulate the requirements of an adequate multidimensional presentation of process data, introduce the necessary model extensions and propose the structure of the data cubes resulting from applying vertical decomposition into flow objects, such as events and activities, and from the dimensional decomposition according to the factual perspectives, such as function, organization, and operation. The feasibility of the presented approach is exemplified by demonstrating how the resulting multidimensional views of surgical workflows enable various perspectives on the data and build a basis for supporting a wide range of analytical queries of virtually arbitrary complexity. 1
A UML 2.0/OCL Extension for Designing Secure Data Warehouses
- Journal of Research and Practice in Information Technology
, 2006
"... At present, it is very difficult to develop a methodology that fulfills all criteria and comprises all security constraints in the successful design of data warehouses. If that methodology were developed, its complexity would hinder its success. The solution, therefore, would be an approach in which ..."
Abstract
-
Cited by 5 (1 self)
- Add to MetaCart
At present, it is very difficult to develop a methodology that fulfills all criteria and comprises all security constraints in the successful design of data warehouses. If that methodology were developed, its complexity would hinder its success. The solution, therefore, would be an approach in which techniques and models defined by the most accepted model standards were extended by integrating the necessary security aspects that at this moment in time are not covered by the existing methodologies. In this paper, we will focus on solving confidentiality problems in the conceptual modelling of data warehouses by defining a profile using the UML 2.0 extensibility mechanisms. In addition, we define an OCL extension that allows us to specify the security constraints of the elements in conceptual modelling of data warehouses and we apply this profile to an example.
The Advisability of using packages in data warehouse design
"... Abstract. Data warehouses are large data repositories integrating data from several sources that support decision making. Although, traditionally, data warehouses have been designed using the ‘well-known ’ star schema, some design methodologies have come into existence in recent times. These new met ..."
Abstract
-
Cited by 1 (0 self)
- Add to MetaCart
(Show Context)
Abstract. Data warehouses are large data repositories integrating data from several sources that support decision making. Although, traditionally, data warehouses have been designed using the ‘well-known ’ star schema, some design methodologies have come into existence in recent times. These new methodologies have not only focused on logical design: they also propose performing a conceptual modeling using UML. At present, it is widely accepted that modeling using packages simplifies the management and understanding of the designs.Until now, however, this statement has not been empirically proved in the data warehouse field. In this paper, we present an empirical study whose aim is to check whether using packages in designing data warehouses makes them more understandable. Keywords. Data Warehouse, Design, UML. 1.
Business Metadata for the Data Warehouse
- Extending UML 2 Activity Diagrams with Business Intelligence Objects, Proceedings DaWaK 2005, LNCS 3589
, 2006
"... Enterprise organizations use Data Warehouses (DWHs) to analyze their performance. Performance is judged regarding the achievement of goals. ..."
Abstract
-
Cited by 1 (0 self)
- Add to MetaCart
Enterprise organizations use Data Warehouses (DWHs) to analyze their performance. Performance is judged regarding the achievement of goals.
Multidimensional Data Modeling for Business Process Analysis
"... Abstract. The emerging area of business process intell igence attempts to enhance the analytical capabilities of business process management systems by employing data warehousing and mining technologies. This paper presents an approach to re-engineering the business process mod-eling in conformity w ..."
Abstract
- Add to MetaCart
Abstract. The emerging area of business process intell igence attempts to enhance the analytical capabilities of business process management systems by employing data warehousing and mining technologies. This paper presents an approach to re-engineering the business process mod-eling in conformity with the multidimensional data model. Since the business process and the multidimensional model are driven by rather different objectives and assumptions, there is no straightforward solution to converging these models. Our case study is concerned with Surgical Process Modeling which is a new and promising subdomain of business process modeling. We for-mulate the requ-irements of an adequate multidimensional presentation of process data, introduce the necessary model extensions and propose the structure of the data cubes resulting from applying vertical decom-position into flow objects, such as events and activities, and from the dimensional decomposition according to the factual perspectives, such as function, organization, and operation. The feasibility of the presented approach is exemplified by demonstrating how the resulting multidimen-sional views of surgical workflows enable various perspectives on the data and build a basis for supporting a wide range of analytical queries of vir-tually arbitrary complexity. 1
