The Dimensional Fact Model is a conceptual model that allows to design the multidimensional schema of a data warehouse. Its methodology is based on the (re)modelling of the schema of a relational database; such a schema is represented by a tree, and the (re)modelling consists of the traditional operations on graphs (as prune, graft, adding child, change parent,⋯). The tree is generated automatically by an algorithm, starting from the logical schema of a relational database. Nowadays, this algorithm is not able to manage many-to-many relationships, and then, it stops the tree creation when it meets this kind of relationships. In this work, we propose a novel methodology, able to overcome this algorithmic limit, via the declarative approach of the logical programming.
Scheda prodotto non validato
Attenzione! I dati visualizzati non sono stati sottoposti a validazione da parte dell'ateneo
Titolo: | Dimensional Fact Model Extension via Predicate Calculus |
Autori: | |
Data di pubblicazione: | 2009 |
Abstract: | The Dimensional Fact Model is a conceptual model that allows to design the multidimensional schema of a data warehouse. Its methodology is based on the (re)modelling of the schema of a relational database; such a schema is represented by a tree, and the (re)modelling consists of the traditional operations on graphs (as prune, graft, adding child, change parent,⋯). The tree is generated automatically by an algorithm, starting from the logical schema of a relational database. Nowadays, this algorithm is not able to manage many-to-many relationships, and then, it stops the tree creation when it meets this kind of relationships. In this work, we propose a novel methodology, able to overcome this algorithmic limit, via the declarative approach of the logical programming. |
Handle: | http://hdl.handle.net/11586/137211 |
ISBN: | 978-1-4244-5023-7 |
Appare nelle tipologie: | 4.1 Contributo in Atti di convegno |