Advances in database technologies are moving the attention of data managers from well known structured relational databases (SQL-Like DBs) towards NoSQL approaches, especially to address big data issues. However, changing technologies in consolidated data management system is hard and requires great investments. Deploying hybrid SQL-NoSQL approaches could be a good solution to speed up the transition in many domains and information systems, but a formal data model to design hybrid databases is necessary. This paper presents a new data model aimed at solving this issue. Starting from the well known E-R model, we introduce some additional components to identify data and “big data” in the system, in order to drive the implementation of SQL-like solutions to manage data, and NoSQL solutions to manage big data. The paper also discusses a Hospital Information System use case, to clearly show how the proposed enriched E-R model can be successfully adopted.

Enriched E-R model to design hybrid database for big data solutions

VILLARI, Massimo;CELESTI, ANTONIO;GIACOBBE, MAURIZIO;FAZIO, MARIA
2016-01-01

Abstract

Advances in database technologies are moving the attention of data managers from well known structured relational databases (SQL-Like DBs) towards NoSQL approaches, especially to address big data issues. However, changing technologies in consolidated data management system is hard and requires great investments. Deploying hybrid SQL-NoSQL approaches could be a good solution to speed up the transition in many domains and information systems, but a formal data model to design hybrid databases is necessary. This paper presents a new data model aimed at solving this issue. Starting from the well known E-R model, we introduce some additional components to identify data and “big data” in the system, in order to drive the implementation of SQL-like solutions to manage data, and NoSQL solutions to manage big data. The paper also discusses a Hospital Information System use case, to clearly show how the proposed enriched E-R model can be successfully adopted.
2016
978-1-5090-0679-3
File in questo prodotto:
Non ci sono file associati a questo prodotto.
Pubblicazioni consigliate

I documenti in IRIS sono protetti da copyright e tutti i diritti sono riservati, salvo diversa indicazione.

Utilizza questo identificativo per citare o creare un link a questo documento: https://hdl.handle.net/11570/3089077
 Attenzione

Attenzione! I dati visualizzati non sono stati sottoposti a validazione da parte dell'ateneo

Citazioni
  • ???jsp.display-item.citation.pmc??? ND
  • Scopus 4
  • ???jsp.display-item.citation.isi??? 9
social impact