Show simple item record

AuthorMershad K.
AuthorMalluhi Q.M.
AuthorOuzzani M.
AuthorTang M.
AuthorGribskov M.
AuthorAref W.G.
AuthorPrakash D.
Available date2020-01-01T10:25:03Z
Publication Date2018
Publication NameDistributed and Parallel Databases
ResourceScopus
ISSN9268782
URIhttp://dx.doi.org/10.1007/s10619-017-7213-1
URIhttp://hdl.handle.net/10576/12463
AbstractData curation activities in collaborative databases mandate that collaborators interact until they converge and agree on the content of their data. In a previous work, we presented a cloud-based collaborative database system that promotes and enables collaboration and data curation scenarios. Our system classifies different versions of a data item to either pending, approved, or rejected. The approval or rejection of a certain version is done by the database Principle Investigators (or PIs) based on its value. Our system also allows collaborators to view the status of each version and help PIs take decisions by providing feedback based on their experiments and/or opinions. Most importantly, our system provided mechanisms for history tracking of different versions to trace the modifications and approval/rejection done by both collaborators and PIs on different versions of a data item. We labeled our system as Update-Pending-Approval model (or UPA). In this paper, we describe a high level SQL query interface language for PIs and collaborators to interact with the UPA framework. We define a set of UPA keywords that are used as a part of the history tracking mechanism to select specific versions of a data item, and a set of UPA options that select specific versions based on possible future decisions of PIs. We implemented our query interface mechanism on top of Apache Phoenix, taking into consideration that the UPA system was implemented on top of Apache HBase. We test the performance of the UPA query language by executing several queries that contain different complexity levels and discuss their results. - 2017, Springer Science+Business Media, LLC.
SponsorThis publication was made possible by the support of an NPRP Grant 4-1534-1-247 from the the Qatar National Research Fund (a member of Qatar Foundation) and the National Science Foundation under Grants IIS-1117766 and IIS-0964639. The statements made herein are solely the responsibility of the authors.
Languageen
PublisherSpringer New York LLC
SubjectCollaborative databases
False positives and negatives
Query options
SQL
True values
Update authorization
TitleCOACT: a query interface language for collaborative databases
TypeArticle
Pagination121-151
Issue Number1
Volume Number36
dc.accessType Abstract Only


Files in this item

FilesSizeFormatView

There are no files associated with this item.

This item appears in the following Collection(s)

Show simple item record