67,742 Hits in 2.9 sec

Discovering functional dependencies for multidimensional design

Oscar Romero, Diego Calvanese, Alberto Abelló, Mariano Rodríguez-Muro
2009 Proceeding of the ACM twelfth international workshop on Data warehousing and OLAP - DOLAP '09  
of analysis is by discovering functional dependencies (as dimensions functionally depend of the fact) over the data sources.  ...  In our approach, we propose an algorithm to discover functional dependencies from the domain ontology that exploits the inference capabilities of DL-Lite, thus fully taking into account the semantics of  ...  Due to space limitations, we address the reader to [25] for a detailed discussion on how to use the functional dependencies for discovering every multidimensional concept.  ... 
doi:10.1145/1651291.1651293 dblp:conf/dolap/RomeroCAR09 fatcat:krfswm3arbhdpifnyzqqj4g4nq


George Tzenakis, Angelos Papatriantafyllou, John Kesapides, Polyvios Pratikakis, Hans Vandierendonck, Dimitrios S. Nikolopoulos
2012 Proceedings of the 17th ACM SIGPLAN symposium on Principles and Practice of Parallel Programming - PPoPP '12  
Dataflow Execution Engine Design BDDT uses a dataflow execution engine based on block-level dependence analysis for identifying parallel tasks.  ...  Every task element points to metadata elements for all task arguments, an atomic join counter that tracks unresolved dependencies, a function that is the task code, and the actual data, which can be strided  ... 
doi:10.1145/2145816.2145864 dblp:conf/ppopp/TzenakisPKPVN12 fatcat:fldzraoepre3vbgejysoiyjwl4

A Procedure of Conversion of Relational into Multidimensional Database Schema

Mladen Varga
2002 Journal of Computing and Information Technology  
It may be helpful to convert a relational database schema into a multidimensional database schema in order to discover dimensions that are hidden in a relational database.  ...  It is universally recognized that operational information systems lean on the relational model and data warehouses on the multidimensional model.  ...  Now the dimension tables are: Acknowledgement Many thanks to the anonymous referees for their helpful and insightful comments.  ... 
doi:10.2498/cit.2002.02.01 fatcat:6eroaj3m6nhj3pphhlqvrsr6vy

Automatic Integration Issues of Tabular Data for On-Line Analysis Processing [article]

Yuzhao Yang
2020 arXiv   pre-print
We provide a first automatic solution for the integration of such tabular data to allow On-Line Analysis Processing.  ...  To fulfil this task, features of tabular data should be analyzed and the challenge of automatic multidimensional schema generation should be addressed.  ...  Acknowledgements The research depicted in this paper is funded by the French National Research Agency (ANR), project ANR-19-CE23-0005 BI4people (Business Intelligence for the people).  ... 
arXiv:2008.11409v2 fatcat:bdrvsddgzrad7g6t3xinysvw7e

Automating multidimensional design from ontologies

Oscar Romero, Alberto Abelló
2007 Proceedings of the ACM tenth international workshop on Data warehousing and OLAP - DOLAP '07  
This paper presents a new approach to automate the multidimensional design of Data Warehouses.  ...  In short, our method identifies business multidimensional concepts from heterogeneous data sources having nothing in common but that they are all described by an ontology.  ...  That is, propagating the functional dependencies from the end of the functional paths to the beginning.  ... 
doi:10.1145/1317331.1317333 dblp:conf/dolap/RomeroA07 fatcat:bvyftguvjvfjdmqpdah7gc6uma

A business-oriented approach to data warehouse development

Ania Cravero Leal, Jose Norberto Mazón, Juan Trujillo
2013 Ingeniería e Investigación  
One reason for this is that requirement engineering is typically overlooked in real projects.  ...  requirements' modelling and how an underlying multidimensional data warehouse model may be derived.  ...  (2002) for conceptual DW design.  ... 
doaj:ddcf2666fa0543a98f9ac99e0f9658fb fatcat:fs6g2atwizfkvn427ksdhpxwkq

A Survey of Multidimensional Modeling Methodologies

Oscar Romero, Alberto Abelló
2009 International Journal of Data Warehousing and Mining  
150 words or less [Article copies are available for purchase from]  ...  They present data-mining techniques to be applied over the database instances to discover functional and inclusion dependencies and derive snowflake schemas.  ...  For instance, the authors suggest to look for business events for discovering adequate measures.  ... 
doi:10.4018/jdwm.2009040101 fatcat:7jspq7faebczppdxlou6t6n3x4

Creating a Collaborative Culture in a Multidimensional Organization

Joel Bigley
2018 International Journal of Economics and Management Sciences  
Automation and connectivity are enablers of a multidimensional design. A definition of a multidimensional organization is required for us to proceed.  ...  The matrix design should be thought of as a two-dimensional construct that typically is separated functionally and geographically, for the operation, and non-geographically, for support functions.  ... 
doi:10.4172/2162-6359.1000536 fatcat:qzhvgls5lffjlk2cmo247z33mq

A framework for multidimensional design of data warehouses from ontologies

Oscar Romero, Alberto Abelló
2010 Data & Knowledge Engineering  
In this paper, we introduce our approach for automatically deriving the multidimensional schema from a domain ontology.  ...  A logical schema is tied to the design decisions made when devising the system and these decisions either made to fulfill the system requirements (for instance, improve query answering, avoid insertion  ...  Depending on the aggregation function used, we can derived different aggregate measures.  ... 
doi:10.1016/j.datak.2010.07.007 fatcat:iv7z7xm3crculdhvnmkf5attru

Data-Driven Multidimensional Design for OLAP [chapter]

Oscar Romero, Alberto Abelló
2011 Lecture Notes in Computer Science  
Relevantly, different approaches to automatically identify facts are nowadays available, but all MD design methods rely on discovering functional dependencies (FDs) to identify dimensions.  ...  OLAP is a popular technology to query scientific and statistical databases, but their success heavily depends on a proper design of the underlying multidimensional (MD) databases (i.e., based on the fact  ...  The interesting Dimension Function: This function is called whenever a combination of attributes is likely to be an ID (see [1] ).  ... 
doi:10.1007/978-3-642-22351-8_51 fatcat:yanc3xopbngznoupn4u5uvw6ta

Identification of Multidimensional Relationship among Item Sets using Association Rules

Mamta Mamta, Shwetank Arya, R. P. Agarwal
2012 International Journal of Computer Applications  
General Terms Data mining task discovering multidimensional relationship among item sets. Keyword Multidimensional relationship, association rule, support, confidence.  ...  In recent days, there is more interest in discovering multi dimensional relationship among item sets rather than frequent pattern sets for applications in specific domains viz. identification of irregularities  ...  Mining for multidimensional patterns could be very useful in discovering inherent dependency of one factor on another factor.  ... 
doi:10.5120/7220-0040 fatcat:256a6zlslbcnxc4ldoxq62xnii

A Model-Driven Heuristic Approach for Detecting Multidimensional Facts in Relational Data Sources [chapter]

Andrea Carmè, Jose-Norberto Mazón, Stefano Rizzi
2010 Lecture Notes in Computer Science  
Facts are multidimensional concepts of primary interests for knowledge workers because they are related to events occurring dynamically in an organization.  ...  However, this task may require a high level of expertise in the application domain, and is often tedious and time-consuming for designers.  ...  We would like to express our gratitude to personnel at TAHE Fertilidad ( for their support during the development of this work.  ... 
doi:10.1007/978-3-642-15105-7_2 fatcat:ubpf5ce3gbbvbaxo4hzxmrfzqy

WorkflowMiner: a New Workflow Patterns and Performance Analysis tool

Karim Baïna, Walid Gaaloul, Reda El Khattabi, Abdellah Mouhou
2006 International Conference on Advanced Information Systems Engineering  
WorkflowMiner performance analyser is developed using Pentaho [6] for OLAP multidimensional storage and browsing, and JFreeChart [7] and Birt [8] for visual reporting.  ...  Sequential and concurrent properties inherit from causal dependency. These patterns rules specify an indicator function defining as a unique manner a pattern.  ... 
dblp:conf/caise/BainaGKM06 fatcat:j3qbtsyid5dadku76bduobjuku

Framework to elicit multidimensional requirements

Edgar Serna M., Alexei Serna A.
2018 Ingeniería y Universidad  
For this reason, and because its existence is accepted, it is necessary to unify criteria and propose frameworks to elicit multidimensional requirements.  ...  Objective: Propose a framework to elicit multidimensional requirements.  ...  software engineering; software requirements; multidimensionality. Resumen Objetivo: Proponer un marco para elicitar requisitos multidimensionales.  ... 
doi:10.11144/javeriana.iyu22-2.femr fatcat:a5f4qnkgvjectbzggskxkrjqxu

X-ETL: A Data-Driven Approach for Designing Star Schemas

Nawfal El Moukhi, Ikram El Azami, Abdelaaziz Mouloudi, Abdelali Elmounadi
2019 International Journal of Recent Contributions from Engineering, Science & IT  
This method aims to automating the data warehouse design by generating star models from relational data.  ...  primarily due to the proliferation of data source types and the lack of a standardized and well-structured method, hence the increasing interest from researchers who have tried to develop new methods for  ...  [10] : the authors proposed a method for designing a multidimensional schema from an XML schema.  ... 
doi:10.3991/ijes.v7i1.10009 fatcat:5zfflhld2jejbn4xi5nvexptqi
« Previous Showing results 1 — 15 out of 67,742 results