Publication
Extraction of fact tables from a relational database: an effort to establish rules in denormalization
| dc.contributor.author | Cavique, Luís | |
| dc.contributor.author | Cavique, Mariana | |
| dc.contributor.author | Gonçalves, António | |
| dc.date.accessioned | 2019-11-04T17:10:41Z | |
| dc.date.available | 2019-11-04T17:10:41Z | |
| dc.date.issued | 2019 | |
| dc.description.abstract | Relational databases are supported by very well established models. However, some neglected problems can occur with the join operator: semantic mistakes caused by the multiple access path problem and faults when connection traps arise. In this paper we intend to identify and overcome those problems and to establish rules for relational data denormalization. Two denormalization forms are proposed and a case study is presented. | pt_PT |
| dc.description.version | info:eu-repo/semantics/publishedVersion | pt_PT |
| dc.identifier.doi | 10.1007/978-3-030-16181-1_88 | |
| dc.identifier.uri | http://hdl.handle.net/10400.2/8704 | |
| dc.language.iso | eng | pt_PT |
| dc.peerreviewed | yes | pt_PT |
| dc.subject | Fact tables | pt_PT |
| dc.subject | Join operator | pt_PT |
| dc.subject | Multiple access path problem | pt_PT |
| dc.subject | Fan trap | pt_PT |
| dc.subject | Denormalization forms | pt_PT |
| dc.title | Extraction of fact tables from a relational database: an effort to establish rules in denormalization | pt_PT |
| dc.type | book part | |
| dspace.entity.type | Publication | |
| oaire.citation.endPage | 945 | pt_PT |
| oaire.citation.startPage | 936 | pt_PT |
| oaire.citation.title | New Knowledge in Information Systems and Technologies | pt_PT |
| oaire.citation.volume | 930 | pt_PT |
| person.familyName | Cavique | |
| person.familyName | Cavique | |
| person.givenName | Luís | |
| person.givenName | Mariana | |
| person.identifier.ciencia-id | 911E-84AC-3956 | |
| person.identifier.ciencia-id | 0718-5B04-F480 | |
| person.identifier.orcid | 0000-0002-5590-1493 | |
| person.identifier.orcid | 0000-0001-8489-8644 | |
| rcaap.rights | openAccess | pt_PT |
| rcaap.type | bookPart | pt_PT |
| relation.isAuthorOfPublication | 40906a16-46a2-42f1-b26d-7db7012294ee | |
| relation.isAuthorOfPublication | cf1e40b2-2061-4c86-833b-5e37a6529299 | |
| relation.isAuthorOfPublication.latestForDiscovery | 40906a16-46a2-42f1-b26d-7db7012294ee |