Please use this identifier to cite or link to this item:
https://hdl.handle.net/10316/114595
DC Field | Value | Language |
---|---|---|
dc.contributor.author | Carvalho, Gonçalo | - |
dc.contributor.author | Bernardino, Jorge | - |
dc.contributor.author | Pereira, Vasco | - |
dc.contributor.author | Cabral, Bruno | - |
dc.date.accessioned | 2024-04-02T09:29:15Z | - |
dc.date.available | 2024-04-02T09:29:15Z | - |
dc.date.issued | 2023 | - |
dc.identifier.issn | 2169-3536 | pt |
dc.identifier.uri | https://hdl.handle.net/10316/114595 | - |
dc.description.abstract | Distributed databases and data transformation mechanisms are highly relevant to Business Intelligence and Data Analytics. Most enterprise systems today have multiple and distributed databases, and the growing dissemination of Edge-Oriented architectures is driving this trend across many industries and business domains. The Entity-Relationship (ER) model is fundamental to modeling complex enterprise systems, but it has shortcomings. In particular, the ER model cannot represent data transport between different locations (or databases) of a system, nor can it conceptually express data transformation operations, such as aggregate and line functions, that are standard in data analytics. Therefore, we propose ER+, an extension of the ER model, where data distribution, data transport, data transformation, and information generation for distributed operational and analytical systems can be visually identified. The new ER+ representation has another important benefit, it provides the basis for transforming conceptual models into physical implementations of distributed data-oriented systems. This work introduces new concepts in ER modeling and illustrates their application. The practicality of the ER+ model is also demonstrated through the TPC-H benchmark. | pt |
dc.language.iso | eng | pt |
dc.relation | This work was partially supported by the Portuguese Foundation for Science and Technology (FCT) under PhD grant 2022.12090.BD, and within the scope of the project CISUC-UID/CEC/00326/2020 and by the European Social Fund, through the Regional Operational Program Centro 2020. Also by Project No. 7059 - Neuraspace - AI fights Space Debris, reference C644877546-00000020, supported by the RRP - Recovery and Resilience Plan and the European Next Generation EU Funds, following Notice No. 02/C05-i01/2022, Component 5 - Capitalization and Business Innovation - Mobilizing Agendas for Business Innovation. | pt |
dc.rights | openAccess | pt |
dc.rights.uri | http://creativecommons.org/licenses/by-nc-nd/4.0/ | pt |
dc.subject | Conceptual model | pt |
dc.subject | databases | pt |
dc.subject | distributed data storage | pt |
dc.subject | multilayer systems | pt |
dc.title | ER+: A Conceptual Model for Distributed Multilayer Systems | pt |
dc.type | article | - |
degois.publication.firstPage | 62744 | pt |
degois.publication.lastPage | 62757 | pt |
degois.publication.title | IEEE Access | pt |
dc.peerreviewed | yes | pt |
dc.identifier.doi | 10.1109/ACCESS.2023.3287796 | pt |
degois.publication.volume | 11 | pt |
dc.date.embargo | 2023-01-01 | * |
uc.date.periodoEmbargo | 0 | pt |
item.fulltext | Com Texto completo | - |
item.grantfulltext | open | - |
item.languageiso639-1 | en | - |
item.cerifentitytype | Publications | - |
item.openairetype | article | - |
item.openairecristype | http://purl.org/coar/resource_type/c_18cf | - |
crisitem.author.researchunit | CISUC - Centre for Informatics and Systems of the University of Coimbra | - |
crisitem.author.researchunit | CISUC - Centre for Informatics and Systems of the University of Coimbra | - |
crisitem.author.parentresearchunit | Faculty of Sciences and Technology | - |
crisitem.author.parentresearchunit | Faculty of Sciences and Technology | - |
crisitem.author.orcid | 0000-0001-7095-5003 | - |
crisitem.author.orcid | 0000-0001-9660-2011 | - |
crisitem.author.orcid | 0000-0002-4225-9075 | - |
crisitem.author.orcid | 0000-0001-9699-1133 | - |
Appears in Collections: | FCTUC Eng.Informática - Artigos em Revistas Internacionais I&D CISUC - Artigos em Revistas Internacionais |
Files in This Item:
File | Description | Size | Format | |
---|---|---|---|---|
ER_A_Conceptual_Model_for_Distributed_Multilayer_Systems.pdf | 2.28 MB | Adobe PDF | View/Open |
Page view(s)
69
checked on Sep 25, 2024
Download(s)
57
checked on Sep 25, 2024
Google ScholarTM
Check
Altmetric
Altmetric
This item is licensed under a Creative Commons License