Approving updates in collaborative databases

Khaleel Mershad, Qutaibah M. Malluhi, Mourad Ouzzani, Mingjie Tang, Walid G. Aref

Research output: Chapter in Book/Report/Conference proceedingConference contribution

1 Citation (Scopus)

Abstract

Data curation activities in collaborative databases mandate that collaborators interact until they converge and agree on the content of their data. Typically, updates by a member of the collaboration are made visible to all collaborators for comments but at the same time are pending the approval or rejection of the data custodian, e.g., the principal scientist or investigator (PI). In current database technologies, approval and authorization of updates is based solely on the identity of the user, e.g., via the SQL GRANT and REVOKE commands. However, in collaborative enviroments, the updated data is open for collaborators for discussion and further editing and is finally approved or rejected by the PI based on the content of the data and not on the identity of the updater. In this paper, we introduce a cloud-based collaborative database system that promotes and enables collaboration and data curation scenarios. We realize content-based update approval and history tracking of updates inside HBase, a distributed and scalable open-source cluster-based database. The design and implementation as well as a detailed performance study of several approaches for update approval are presented and contrasted in the paper.

Original languageEnglish
Title of host publicationProceedings - 2015 IEEE International Conference on Cloud Engineering, IC2E 2015
PublisherInstitute of Electrical and Electronics Engineers Inc.
Pages42-47
Number of pages6
ISBN (Print)9781479982189
DOIs
Publication statusPublished - 2015
Event2015 IEEE International Conference on Cloud Engineering, IC2E 2015 - Tempe, United States
Duration: 9 Mar 201512 Mar 2015

Other

Other2015 IEEE International Conference on Cloud Engineering, IC2E 2015
CountryUnited States
CityTempe
Period9/3/1512/3/15

ASJC Scopus subject areas

  • Software
  • Control and Systems Engineering
  • Computer Networks and Communications
  • Hardware and Architecture

Cite this

Mershad, K., Malluhi, Q. M., Ouzzani, M., Tang, M., & Aref, W. G. (2015). Approving updates in collaborative databases. In Proceedings - 2015 IEEE International Conference on Cloud Engineering, IC2E 2015 (pp. 42-47). [7092897] Institute of Electrical and Electronics Engineers Inc.. https://doi.org/10.1109/IC2E.2015.31

Approving updates in collaborative databases. / Mershad, Khaleel; Malluhi, Qutaibah M.; Ouzzani, Mourad; Tang, Mingjie; Aref, Walid G.

Proceedings - 2015 IEEE International Conference on Cloud Engineering, IC2E 2015. Institute of Electrical and Electronics Engineers Inc., 2015. p. 42-47 7092897.

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Mershad, K, Malluhi, QM, Ouzzani, M, Tang, M & Aref, WG 2015, Approving updates in collaborative databases. in Proceedings - 2015 IEEE International Conference on Cloud Engineering, IC2E 2015., 7092897, Institute of Electrical and Electronics Engineers Inc., pp. 42-47, 2015 IEEE International Conference on Cloud Engineering, IC2E 2015, Tempe, United States, 9/3/15. https://doi.org/10.1109/IC2E.2015.31
Mershad K, Malluhi QM, Ouzzani M, Tang M, Aref WG. Approving updates in collaborative databases. In Proceedings - 2015 IEEE International Conference on Cloud Engineering, IC2E 2015. Institute of Electrical and Electronics Engineers Inc. 2015. p. 42-47. 7092897 https://doi.org/10.1109/IC2E.2015.31
Mershad, Khaleel ; Malluhi, Qutaibah M. ; Ouzzani, Mourad ; Tang, Mingjie ; Aref, Walid G. / Approving updates in collaborative databases. Proceedings - 2015 IEEE International Conference on Cloud Engineering, IC2E 2015. Institute of Electrical and Electronics Engineers Inc., 2015. pp. 42-47
@inproceedings{8631bd62700c43c5bc8861abad9cd1ae,
title = "Approving updates in collaborative databases",
abstract = "Data curation activities in collaborative databases mandate that collaborators interact until they converge and agree on the content of their data. Typically, updates by a member of the collaboration are made visible to all collaborators for comments but at the same time are pending the approval or rejection of the data custodian, e.g., the principal scientist or investigator (PI). In current database technologies, approval and authorization of updates is based solely on the identity of the user, e.g., via the SQL GRANT and REVOKE commands. However, in collaborative enviroments, the updated data is open for collaborators for discussion and further editing and is finally approved or rejected by the PI based on the content of the data and not on the identity of the updater. In this paper, we introduce a cloud-based collaborative database system that promotes and enables collaboration and data curation scenarios. We realize content-based update approval and history tracking of updates inside HBase, a distributed and scalable open-source cluster-based database. The design and implementation as well as a detailed performance study of several approaches for update approval are presented and contrasted in the paper.",
author = "Khaleel Mershad and Malluhi, {Qutaibah M.} and Mourad Ouzzani and Mingjie Tang and Aref, {Walid G.}",
year = "2015",
doi = "10.1109/IC2E.2015.31",
language = "English",
isbn = "9781479982189",
pages = "42--47",
booktitle = "Proceedings - 2015 IEEE International Conference on Cloud Engineering, IC2E 2015",
publisher = "Institute of Electrical and Electronics Engineers Inc.",

}

TY - GEN

T1 - Approving updates in collaborative databases

AU - Mershad, Khaleel

AU - Malluhi, Qutaibah M.

AU - Ouzzani, Mourad

AU - Tang, Mingjie

AU - Aref, Walid G.

PY - 2015

Y1 - 2015

N2 - Data curation activities in collaborative databases mandate that collaborators interact until they converge and agree on the content of their data. Typically, updates by a member of the collaboration are made visible to all collaborators for comments but at the same time are pending the approval or rejection of the data custodian, e.g., the principal scientist or investigator (PI). In current database technologies, approval and authorization of updates is based solely on the identity of the user, e.g., via the SQL GRANT and REVOKE commands. However, in collaborative enviroments, the updated data is open for collaborators for discussion and further editing and is finally approved or rejected by the PI based on the content of the data and not on the identity of the updater. In this paper, we introduce a cloud-based collaborative database system that promotes and enables collaboration and data curation scenarios. We realize content-based update approval and history tracking of updates inside HBase, a distributed and scalable open-source cluster-based database. The design and implementation as well as a detailed performance study of several approaches for update approval are presented and contrasted in the paper.

AB - Data curation activities in collaborative databases mandate that collaborators interact until they converge and agree on the content of their data. Typically, updates by a member of the collaboration are made visible to all collaborators for comments but at the same time are pending the approval or rejection of the data custodian, e.g., the principal scientist or investigator (PI). In current database technologies, approval and authorization of updates is based solely on the identity of the user, e.g., via the SQL GRANT and REVOKE commands. However, in collaborative enviroments, the updated data is open for collaborators for discussion and further editing and is finally approved or rejected by the PI based on the content of the data and not on the identity of the updater. In this paper, we introduce a cloud-based collaborative database system that promotes and enables collaboration and data curation scenarios. We realize content-based update approval and history tracking of updates inside HBase, a distributed and scalable open-source cluster-based database. The design and implementation as well as a detailed performance study of several approaches for update approval are presented and contrasted in the paper.

UR - http://www.scopus.com/inward/record.url?scp=84944325010&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84944325010&partnerID=8YFLogxK

U2 - 10.1109/IC2E.2015.31

DO - 10.1109/IC2E.2015.31

M3 - Conference contribution

AN - SCOPUS:84944325010

SN - 9781479982189

SP - 42

EP - 47

BT - Proceedings - 2015 IEEE International Conference on Cloud Engineering, IC2E 2015

PB - Institute of Electrical and Electronics Engineers Inc.

ER -