124 Hits in 5.0 sec

Automatically generating OLAP schmata from conceptual graphical models

Karl Hahn, Carsten Sapia, Markus Blaschka
2000 Proceedings of the 3rd ACM international workshop on Data warehousing and OLAP - DOLAP '00  
Generating tool specific schemata and configuration information for OLAP database tools from conceptual graphical models is an important prerequisite for a comprehensive tool support for computer aided  ...  The paper lists typical mismatches between the data model of commercial OLAP tools and conceptual graphical modeling notations, and proposes methods to overcome these expressive differences during the  ...  One of the immediate consequences of this set of objectives is that the implementation of the data warehouse must be automatically generated from the graphical conceptual models.  ... 
doi:10.1145/355068.355310 dblp:conf/dolap/HahnSB00 fatcat:w2gy7esdgrguve3umrk72gm6sa


Sandro Bimonte, Elodie Edoh-alove, Hassan Nazih, Myoung-Ah Kang, Stefano Rizzi
2013 Proceedings of the sixteenth international workshop on Data warehousing and OLAP - DOLAP '13  
To solve this deadlock we propose ProtOLAP, a toolassisted fast prototyping methodology that enables quick and reliable test and validation of data warehouse schemata in situations where data supply is  ...  Here, a logical (relational) schema and the related metadata are automatically generated and deployed starting from the conceptual schema.  ...  In automatic mode, hierarchical relations are automatically generated.  ... 
doi:10.1145/2513190.2513199 dblp:conf/dolap/BimonteENKR13 fatcat:jldrrpeldzhn7kv53wqxbzltja

QBX: A CASE Tool for Data Mart Design [chapter]

Antonino Battaglia, Matteo Golfarelli, Stefano Rizzi
2011 Lecture Notes in Computer Science  
It supports designers during conceptual design, logical design, and deployment of ROLAP data marts in the form of star/snowflake schemata, and it can also be used by business users to interactively explore  ...  QBX is a CASE tool for data mart design resulting from a close collaboration between academy and industry.  ...  Then, we will let QB-Xpose generate alternative logical schemata using different design preferences, and critically compare the results ( Figure 5 ).  ... 
doi:10.1007/978-3-642-24574-9_51 fatcat:epw2dstsxbhublegy2fcwkpxf4

Bridging the semantic gap in OLAP models

Jesús Pardillo, Jose-Norberto Mazón, Juan Trujillo
2008 Proceeding of the ACM 11th international workshop on Data warehousing and OLAP - DOLAP '08  
, semantically rich abstraction, namely the conceptual model.  ...  In order to bridge this gap, we propose the use of conceptual OLAP queries, i.e., platformindependent, that can be automatically traced to their logical implementation in a coherent and integrated way.  ...  Instead of providing OLAP metadata for a specific platform, we derive the required logical schemata and queries from the conceptual model, thus bridging the conceptual-logical semantic gap for the selected  ... 
doi:10.1145/1458432.1458448 dblp:conf/dolap/PardilloMT08 fatcat:6ky7fflxl5b6bfbt7qpm7rhlae

A UML Profile for Variety Awareness in Multidimensional Design

Sandro Bimonte, Houssam Bazza, Jean Laneurit, Stefano Rizzi, Hassan Badir
2022 International Workshop on Data Warehousing and OLAP  
Variety and variability are an inherent source of information wealth in schemaless sources, and executing OLAP sessions on multidimensional data in their presence has recently become an object of research  ...  We also provide a validation of our UML profile by ranking it against other meta-models based on a set of quality metrics.  ...  OLAP querying requires a multidimensional view of data, so even in this case conceptual modeling is mandatory. • Multi-model data warehouses.  ... 
dblp:conf/dolap/BimonteBLRB22 fatcat:tucoimbmtbd4haf2euzuiwz2r4

Mapping conceptual to logical models for ETL processes

Alkis Simitsis
2005 Proceedings of the 8th ACM international workshop on Data warehousing and OLAP - DOLAP  
Finally, we provide a methodology for the transition from the conceptual to the logical model.  ...  First, we identify how a conceptual entity is mapped to a logical entity. Next, we determine the execution order in the logical workflow using information adapted from the conceptual model.  ...  [4] presents a modelling framework BabelFish concerning the automatic generation of OLAP schemata from conceptual graphical models and discusses the issues of this automatic generation process for both  ... 
doi:10.1145/1097002.1097014 dblp:conf/dolap/Simitsis05 fatcat:flnhnpcsy5c6njjxwho6xodcxm

Towards Semantic Geo/BI: A Novel Approach for Semantically Enriching Geo/BI Data with OWL Ontological Layers (OOLAP and ODW) to Enable Semantic Exploration, Analysis and Discovery of Geospatial Business Intelligence Knowledge

Belko Abdoul Aziz Diallo, West African Science Service Centre on Climate Change and Adapted Land Use (WASCAL), Competence Centre, Ouagadougou, Burkina Faso, Aziz Diallo, Frédéric Hubert, Sylvie Daniel
2018 International Journal of Information Engineering and Electronic Business  
model and the data warehouse model.  ...  meta-model which defines details regarding enterprise goals (e.g.  ...  from a generic model.  ... 
doi:10.5815/ijieeb.2018.06.01 fatcat:p6qs6aqddrbxnpgqf6oktzo4zm

Using Perspective Schemata To Model The Etl Process

Valeria M. Pequeno, Joao Carlos G. M. Pires
2009 Zenodo  
This paper presents the overview of the proposed framework to model the ETL process, which is based on the use of a reference model and perspective schemata.  ...  Under a conceptual viewpoint, the authors want to innovate the ETL process in two ways: 1) to make clear compatibility between models in a declarative fashion, using correspondence assertions and 2) to  ...  generate a new perspective schema from the source schemata to the data warehouse one.  ... 
doi:10.5281/zenodo.1071869 fatcat:eqcre6zho5g4vg2azk3smqrzte

Goal-oriented requirement analysis for data warehouse design

Paolo Giorgini, Stefano Rizzi, Maddalena Garzetti
2005 Proceedings of the 8th ACM international workshop on Data warehousing and OLAP - DOLAP  
Two different perspectives are integrated for requirement analysis: organizational modeling, centered on stakeholders, and decisional modeling, focused on decision makers.  ...  Fact schemata are automatically generated from the diagrams elaborated during decisional modeling. The analyst can refine such schemata to generate the final ones.  ...  Conversely, in WAND [10] the conceptual schema is semi-automatically derived from the operational schemata, thus implementing de facto a supply-driven approach.  ... 
doi:10.1145/1097002.1097011 dblp:conf/dolap/GiorginiRG05 fatcat:ofvmgb5tyramvej27imh7mo3wi

Integration of Data Mining and Data Warehousing: A Practical Methodology

Muhammad Usman, Russel Pears
2010 International Journal of Advancements in Computing Technology  
For the seamless integration, the mined data has to be modeled in form of a data warehouse schema. Schema generation process is complex manual task and requires domain and warehousing familiarity.  ...  warehouse schema generation and integration of data mining and warehousing.  ...  To achieve the goal of automation, [27] , proposed the generation of tool specific schemata for OLAP from conceptual graphical models.  ... 
doi:10.4156/ijact.vol2.issue3.4 fatcat:jsmrrhak3vhefl2psd6wewstta

An Architecture for Integrated Online Analytical Mining

Muhammad Usman, Sohail Asghar
2011 Journal of Emerging Technologies in Web Intelligence  
Furthermore, automatic OLAP schema generation has never been introduced as a component of OLAM architecture.  ...  A prototype of automatic schema generation has been developed and schema generation algorithms have been provided. In addition to this, we implemented and deployed the proposed architecture.  ...  [34] , proposed the generation of tool specific schemata for OLAP from conceptual graphical models.  ... 
doi:10.4304/jetwi.3.2.74-99 fatcat:ppkarvwrojho5ftwdwqqok2m6m

Towards a logical multidimensional model for spatial data warehousing and OLAP

Marcus Costa Sampaio, André Gomes de Sousa, Cláudio de Souza Baptista
2006 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP - DOLAP '06  
This paper proposes a novel logical multidimensional model suitable for SDW, which is implemented on the top of an object-relational database system with support for spatial data.  ...  Regardless the evident importance of using data warehousing and OLAP in DSS, the incorporation of spatial dimensions and measures enables to locate more efficiently tendencies in a given application domain  ...  DW/OLAP is responsible for symbolic data extraction from operational sources and its organization according to a multidimensional model.  ... 
doi:10.1145/1183512.1183528 dblp:conf/dolap/SampaioSB06 fatcat:idcob6wyljc2fjw7cr27fre6ii

Hydro-meteorological data analysis using OLAP techniques

Néstor Dario Duque-Méndez, Mauricio Orozco-Alzate, Jorge Julián Vélez
2014 Dyna  
From the designed data warehouse schema, the data warehouse exploits the data (in some cases extending back more than 50 years) in order to apply online analytical processing (OLAP) techniques and discovery  ...  The purpose of this work is to develop a conceptual model for a data warehouse in a star schema that allows the structured storage and multidimensional analysis of historical hydro-climatological data.  ...  Acknowledgments The authors would like to thank financial support from "Convocatoria Nacional de Investigación y de Creación Artística de la Universidad Nacional de Colombia 2010 -2012" to the "Programa  ... 
doi:10.15446/dyna.v81n185.37700 fatcat:5gc3nyky3fccpiwxaykv727n5a

Spatial Datawarehousing [chapter]

Alejandro A. Vaisman, Esteban Zimányi
2017 Encyclopedia of Database Systems  
Second, data warehousing applications require improved, standardized, and secure conceptual modeling techniques as well as novel approaches to dealing with data quality issues.  ...  However, much less is known about how to integrate the Web data represented by these models with more conventional corporate data to enable OLAP-style decision-support.  ...  Logical Modeling The overall task of logical modeling is the transformation of conceptual schemata into logical schemata that can be implemented on a chosen target system.  ... 
doi:10.1007/978-1-4899-7993-3_80810-1 fatcat:7yo63qvmhfadzn5vwn2x7bizku

Semantic Metadata for Supporting Exploratory OLAP [article]

Jovan Varga
2016 Ph.d.-serien for Det Teknisk-Naturvidenskabelige Fakultet, Aalborg Universitet  
All modules provide graphical interfaces. QB2OLAP automatically generates and triggers the necessary SPARQL queries and handles the result triples.  ...  Second, the conceptual abstraction level of OLAP operations in SM4MQ makes the model understandable by non-technical OLAP users.  ...  A key feature to promote the use of our proposal is to relieve OLAP users from the need of learning a new and complex language like SPARQL.  ... 
doi:10.5278/ fatcat:2jvgnvvmznh7dk7dap2aipiiii
« Previous Showing results 1 — 15 out of 124 results