arrow
返回

ER plus : A Conceptual Model for Distributed Multilayer Systems

delete2023-01-01
delete0
delete
OA
AI
G
Gonçalo Carvalho *
J
Jorge Bernardino
V
Vasco Pereira
B
Bruno Cabral
DOI:10.1109/ACCESS.2023.3287796delete
delete原文链接
delete原文求助
delete分享
delete收藏
摘要

摘要

En 中文
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.
Keyword:
Conceptual model
databases
distributed data storage
multilayer systems

期刊

IEEE Access 封面图
IEEE Access
IF:
3.6
论文数:
9.8W
被引数:
29.4W

机构

U
universidade de coimbra
学者数:
1.9W
论文数: 1.6W
被引数: 16
引用论文

引用论文

An automated entity-relationship clustering algorithm for conceptual database design
err2007-07-01
err4
PREAI
errTavana, Madjid; Joglekar, Prafulla; Redmond, Michael A.
err分享
err收藏
Modeling the complete chemokine–receptor interaction
err2019-01-01
err0
errOAAI
errMichael J. Wedemeyer; Benjamin K. Mueller; Brian J. Bender; Jens Meiler; Brian F. Volkman
err分享
err收藏
err分享
err收藏
Combining UML and ontology: An exploratory survey
err2020-02-01
err16
PREAI
errMkhinini, Meriem Mejhed; Labbani-Narsis, Ouassila; Nicolle, Christophe
err分享
err收藏
DiagnoSTic assays for heparin-induced thrombocytopenia
err2014-05-14
err0
errOAAI
errElizabeth E. Gardiner; Robert K. Andrews; Adam Cuker
err分享
err收藏
Salt stress response of wheat–barley addition lines carrying chromosomes from the winter barley “Manas”
err2014-09-04
err0
PREAI
errEva Darko; Tibor Janda; Imre Majláth; Dóra Szopkó; Sándor Dulai; István Molnár; Edina Türkösi; Márta Molnár-Láng
err分享
err收藏
err分享
err收藏
学者 查看更多内容