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 | 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)
76
checked on Oct 9, 2024
Download(s)
57
checked on Oct 9, 2024
Google ScholarTM
Check
Altmetric
Altmetric
This item is licensed under a Creative Commons License