COACT: a query interface language for collaborative databases
Author | Mershad K. |
Author | Malluhi Q.M. |
Author | Ouzzani M. |
Author | Tang M. |
Author | Gribskov M. |
Author | Aref W.G. |
Author | Prakash D. |
Available date | 2020-01-01T10:25:03Z |
Publication Date | 2018 |
Publication Name | Distributed and Parallel Databases |
Resource | Scopus |
ISSN | 9268782 |
Abstract | Data 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. |
Sponsor | This 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. |
Language | en |
Publisher | Springer New York LLC |
Subject | Collaborative databases False positives and negatives Query options SQL True values Update authorization |
Type | Article |
Pagination | 121-151 |
Issue Number | 1 |
Volume Number | 36 |
Files in this item
Files | Size | Format | View |
---|---|---|---|
There are no files associated with this item. |
This item appears in the following Collection(s)
-
Computer Science & Engineering [2281 items ]