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.

Dimensional Fact Model Extension via Predicate Calculus

DI TRIA, FRANCESCO;LEFONS, Ezio;TANGORRA, Filippo
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.
978-1-4244-5023-7
File in questo prodotto:
Non ci sono file associati a questo prodotto.

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: http://hdl.handle.net/11586/137211
 Attenzione

Attenzione! I dati visualizzati non sono stati sottoposti a validazione da parte dell'ateneo

Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 12
  • ???jsp.display-item.citation.isi??? 9
social impact