Please use this identifier to cite or link to this item:
https://hdl.handle.net/10316/114595
Title: | ER+: A Conceptual Model for Distributed Multilayer Systems | Authors: | Carvalho, Gonçalo Bernardino, Jorge Pereira, Vasco Cabral, Bruno |
Keywords: | Conceptual model; databases; distributed data storage; multilayer systems | Issue Date: | 2023 | Project: | 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. | Serial title, monograph or event: | IEEE Access | Volume: | 11 | 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. | URI: | https://hdl.handle.net/10316/114595 | ISSN: | 2169-3536 | DOI: | 10.1109/ACCESS.2023.3287796 | Rights: | openAccess |
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