{"id":"https://openalex.org/W2924905558","doi":"https://doi.org/10.1007/978-3-030-16181-1_88","title":"Extraction of Fact Tables from a Relational Database: An Effort to Establish Rules in Denormalization","display_name":"Extraction of Fact Tables from a Relational Database: An Effort to Establish Rules in Denormalization","publication_year":2019,"publication_date":"2019-01-01","ids":{"openalex":"https://openalex.org/W2924905558","doi":"https://doi.org/10.1007/978-3-030-16181-1_88","mag":"2924905558"},"language":"en","primary_location":{"id":"doi:10.1007/978-3-030-16181-1_88","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-030-16181-1_88","pdf_url":null,"source":{"id":"https://openalex.org/S2764905038","display_name":"Advances in intelligent systems and computing","issn_l":"2194-5357","issn":["2194-5357","2194-5365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319965","host_organization_name":"Springer Nature","host_organization_lineage":["https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Advances in Intelligent Systems and Computing","raw_type":"book-chapter"},"type":"book-chapter","indexed_in":["crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://hdl.handle.net/10400.2/8704","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5031511260","display_name":"Lu\u00eds Cavique","orcid":"https://orcid.org/0000-0002-5590-1493"},"institutions":[{"id":"https://openalex.org/I201025148","display_name":"Universidade Aberta","ror":"https://ror.org/02rv3w387","country_code":"PT","type":"education","lineage":["https://openalex.org/I201025148"]}],"countries":["PT"],"is_corresponding":true,"raw_author_name":"Lu\u00eds Cavique","raw_affiliation_strings":["Universidade Aberta, MAS-BioISI, 1269-01, Lisbon, Portugal"],"affiliations":[{"raw_affiliation_string":"Universidade Aberta, MAS-BioISI, 1269-01, Lisbon, Portugal","institution_ids":["https://openalex.org/I201025148"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018475993","display_name":"Mariana Cavique","orcid":"https://orcid.org/0000-0001-8489-8644"},"institutions":[{"id":"https://openalex.org/I2800794739","display_name":"Universidade Europeia","ror":"https://ror.org/04bcdt432","country_code":"PT","type":"education","lineage":["https://openalex.org/I2800794739"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Mariana Cavique","raw_affiliation_strings":["Universidade Europeia, 1500-210, Lisbon, Portugal"],"affiliations":[{"raw_affiliation_string":"Universidade Europeia, 1500-210, Lisbon, Portugal","institution_ids":["https://openalex.org/I2800794739"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5086427702","display_name":"Ant\u00f3nio Gon\u00e7alves","orcid":"https://orcid.org/0000-0001-6091-2624"},"institutions":[{"id":"https://openalex.org/I4210102653","display_name":"Instituto Politecnico de Setubal","ror":"https://ror.org/01bvjz807","country_code":"PT","type":"education","lineage":["https://openalex.org/I4210102653"]}],"countries":["PT"],"is_corresponding":false,"raw_author_name":"Ant\u00f3nio Gon\u00e7alves","raw_affiliation_strings":["Escola Superior de Tecnologia de Set\u00fabal, Instituto Polit\u00e9cnico de Set\u00fabal, 2914-504, Set\u00fabal, Portugal"],"affiliations":[{"raw_affiliation_string":"Escola Superior de Tecnologia de Set\u00fabal, Instituto Polit\u00e9cnico de Set\u00fabal, 2914-504, Set\u00fabal, Portugal","institution_ids":["https://openalex.org/I4210102653"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5031511260"],"corresponding_institution_ids":["https://openalex.org/I201025148"],"apc_list":null,"apc_paid":null,"fwci":1.3757,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.78306265,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":95},"biblio":{"volume":null,"issue":null,"first_page":"936","last_page":"945"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9987000226974487,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9987000226974487,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9986000061035156,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.998199999332428,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.7544857859611511},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7241374254226685},{"id":"https://openalex.org/keywords/relational-model","display_name":"Relational model","score":0.5291239023208618},{"id":"https://openalex.org/keywords/path","display_name":"Path (computing)","score":0.49109983444213867},{"id":"https://openalex.org/keywords/conjunctive-query","display_name":"Conjunctive query","score":0.4459046423435211},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.4434683918952942},{"id":"https://openalex.org/keywords/operator","display_name":"Operator (biology)","score":0.4271719753742218},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.40472203493118286},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.35714855790138245},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.2166195809841156}],"concepts":[{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.7544857859611511},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7241374254226685},{"id":"https://openalex.org/C40207289","wikidata":"https://www.wikidata.org/wiki/Q755662","display_name":"Relational model","level":3,"score":0.5291239023208618},{"id":"https://openalex.org/C2777735758","wikidata":"https://www.wikidata.org/wiki/Q817765","display_name":"Path (computing)","level":2,"score":0.49109983444213867},{"id":"https://openalex.org/C65647387","wikidata":"https://www.wikidata.org/wiki/Q1781706","display_name":"Conjunctive query","level":3,"score":0.4459046423435211},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.4434683918952942},{"id":"https://openalex.org/C17020691","wikidata":"https://www.wikidata.org/wiki/Q139677","display_name":"Operator (biology)","level":5,"score":0.4271719753742218},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.40472203493118286},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.35714855790138245},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.2166195809841156},{"id":"https://openalex.org/C55493867","wikidata":"https://www.wikidata.org/wiki/Q7094","display_name":"Biochemistry","level":1,"score":0.0},{"id":"https://openalex.org/C86339819","wikidata":"https://www.wikidata.org/wiki/Q407384","display_name":"Transcription factor","level":3,"score":0.0},{"id":"https://openalex.org/C158448853","wikidata":"https://www.wikidata.org/wiki/Q425218","display_name":"Repressor","level":4,"score":0.0},{"id":"https://openalex.org/C185592680","wikidata":"https://www.wikidata.org/wiki/Q2329","display_name":"Chemistry","level":0,"score":0.0},{"id":"https://openalex.org/C104317684","wikidata":"https://www.wikidata.org/wiki/Q7187","display_name":"Gene","level":2,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1007/978-3-030-16181-1_88","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-030-16181-1_88","pdf_url":null,"source":{"id":"https://openalex.org/S2764905038","display_name":"Advances in intelligent systems and computing","issn_l":"2194-5357","issn":["2194-5357","2194-5365"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319965","host_organization_name":"Springer Nature","host_organization_lineage":["https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Advances in Intelligent Systems and Computing","raw_type":"book-chapter"},{"id":"pmh:oai:repositorioaberto.uab.pt:10400.2/8704","is_oa":true,"landing_page_url":"http://hdl.handle.net/10400.2/8704","pdf_url":null,"source":{"id":"https://openalex.org/S4306402256","display_name":"The Reposit\u00f3rio Aberto (Universidade Aberta)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I201025148","host_organization_name":"Universidade Aberta","host_organization_lineage":["https://openalex.org/I201025148"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"book part"}],"best_oa_location":{"id":"pmh:oai:repositorioaberto.uab.pt:10400.2/8704","is_oa":true,"landing_page_url":"http://hdl.handle.net/10400.2/8704","pdf_url":null,"source":{"id":"https://openalex.org/S4306402256","display_name":"The Reposit\u00f3rio Aberto (Universidade Aberta)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I201025148","host_organization_name":"Universidade Aberta","host_organization_lineage":["https://openalex.org/I201025148"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"book part"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":17,"referenced_works":["https://openalex.org/W1517033997","https://openalex.org/W1535430927","https://openalex.org/W1566432606","https://openalex.org/W1603422431","https://openalex.org/W1884542822","https://openalex.org/W1962922984","https://openalex.org/W2110954374","https://openalex.org/W2143075689","https://openalex.org/W2156094048","https://openalex.org/W2165467455","https://openalex.org/W2185907055","https://openalex.org/W2460071091","https://openalex.org/W2483136972","https://openalex.org/W2501451512","https://openalex.org/W2623293810","https://openalex.org/W4213366719","https://openalex.org/W4298168823"],"related_works":["https://openalex.org/W2267077731","https://openalex.org/W1510134535","https://openalex.org/W2386578196","https://openalex.org/W2483382562","https://openalex.org/W3091612633","https://openalex.org/W2085988990","https://openalex.org/W1528519853","https://openalex.org/W2376710457","https://openalex.org/W3174970460","https://openalex.org/W206482712"],"abstract_inverted_index":null,"counts_by_year":[{"year":2024,"cited_by_count":1},{"year":2023,"cited_by_count":1},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":1}],"updated_date":"2026-04-04T16:13:02.066488","created_date":"2025-10-10T00:00:00"}