COACT: a query interface language for collaborative databases
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 sy...
محفوظ في:
| المؤلف الرئيسي: | |
|---|---|
| مؤلفون آخرون: | , , , , , |
| التنسيق: | article |
| منشور في: |
2017
|
| الوصول للمادة أونلاين: | http://hdl.handle.net/10725/15346 https://doi.org/10.1007/s10619-017-7213-1 http://libraries.lau.edu.lb/research/laur/terms-of-use/articles.php https://link.springer.com/article/10.1007/s10619-017-7213-1 |
| الوسوم: |
إضافة وسم
لا توجد وسوم, كن أول من يضع وسما على هذه التسجيلة!
|
| _version_ | 1864513470476582912 |
|---|---|
| author | Mershad, Khaleel |
| author2 | Malluhi, Qutaibah M. Ouzzani, Mourad Tang, Mingjie Gribskov, Michael Aref, Walid G. Prakash, Deo |
| author2_role | author author author author author author |
| author_facet | Mershad, Khaleel Malluhi, Qutaibah M. Ouzzani, Mourad Tang, Mingjie Gribskov, Michael Aref, Walid G. Prakash, Deo |
| author_role | author |
| dc.creator.none.fl_str_mv | Mershad, Khaleel Malluhi, Qutaibah M. Ouzzani, Mourad Tang, Mingjie Gribskov, Michael Aref, Walid G. Prakash, Deo |
| dc.date.none.fl_str_mv | 2017 2017-11-13 2024-02-27T14:14:28Z 2024-02-27T14:14:28Z |
| dc.identifier.none.fl_str_mv | 0926-8782 http://hdl.handle.net/10725/15346 https://doi.org/10.1007/s10619-017-7213-1 Mershad, K., Malluhi, Q. M., Ouzzani, M., Tang, M., Gribskov, M., Aref, W. G., & Prakash, D. (2018). COACT: a query interface language for collaborative databases. Distributed and Parallel Databases, 36, 121-151. http://libraries.lau.edu.lb/research/laur/terms-of-use/articles.php https://link.springer.com/article/10.1007/s10619-017-7213-1 |
| dc.language.none.fl_str_mv | en |
| dc.relation.none.fl_str_mv | Distributed and Parallel Databases |
| dc.rights.*.fl_str_mv | info:eu-repo/semantics/openAccess |
| dc.title.none.fl_str_mv | COACT: a query interface language for collaborative databases |
| dc.type.none.fl_str_mv | Article info:eu-repo/semantics/publishedVersion info:eu-repo/semantics/article |
| description | 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. |
| eu_rights_str_mv | openAccess |
| format | article |
| id | LAURepo_653aefb8ddc38868ccbaa0ba8bad839f |
| identifier_str_mv | 0926-8782 Mershad, K., Malluhi, Q. M., Ouzzani, M., Tang, M., Gribskov, M., Aref, W. G., & Prakash, D. (2018). COACT: a query interface language for collaborative databases. Distributed and Parallel Databases, 36, 121-151. |
| language_invalid_str_mv | en |
| network_acronym_str | LAURepo |
| network_name_str | Lebanese American University repository |
| oai_identifier_str | oai:laur.lau.edu.lb:10725/15346 |
| publishDate | 2017 |
| repository.mail.fl_str_mv | |
| repository.name.fl_str_mv | |
| repository_id_str | |
| spelling | COACT: a query interface language for collaborative databasesMershad, KhaleelMalluhi, Qutaibah M.Ouzzani, MouradTang, MingjieGribskov, MichaelAref, Walid G.Prakash, DeoData 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.Published2024-02-27T14:14:28Z2024-02-27T14:14:28Z20172017-11-13Articleinfo:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/article0926-8782http://hdl.handle.net/10725/15346https://doi.org/10.1007/s10619-017-7213-1Mershad, K., Malluhi, Q. M., Ouzzani, M., Tang, M., Gribskov, M., Aref, W. G., & Prakash, D. (2018). COACT: a query interface language for collaborative databases. Distributed and Parallel Databases, 36, 121-151.http://libraries.lau.edu.lb/research/laur/terms-of-use/articles.phphttps://link.springer.com/article/10.1007/s10619-017-7213-1enDistributed and Parallel Databasesinfo:eu-repo/semantics/openAccessoai:laur.lau.edu.lb:10725/153462024-07-03T09:22:33Z |
| spellingShingle | COACT: a query interface language for collaborative databases Mershad, Khaleel |
| status_str | publishedVersion |
| title | COACT: a query interface language for collaborative databases |
| title_full | COACT: a query interface language for collaborative databases |
| title_fullStr | COACT: a query interface language for collaborative databases |
| title_full_unstemmed | COACT: a query interface language for collaborative databases |
| title_short | COACT: a query interface language for collaborative databases |
| title_sort | COACT: a query interface language for collaborative databases |
| url | http://hdl.handle.net/10725/15346 https://doi.org/10.1007/s10619-017-7213-1 http://libraries.lau.edu.lb/research/laur/terms-of-use/articles.php https://link.springer.com/article/10.1007/s10619-017-7213-1 |