Skip to main content
Erschienen in: Distributed and Parallel Databases 1/2018

13.11.2017

COACT: a query interface language for collaborative databases

verfasst von: Khaleel Mershad, Qutaibah M. Malluhi, Mourad Ouzzani, Mingjie Tang, Michael Gribskov, Walid G. Aref, Deo Prakash

Erschienen in: Distributed and Parallel Databases | Ausgabe 1/2018

Einloggen

Aktivieren Sie unsere intelligente Suche um passende Fachinhalte oder Patente zu finden.

search-config
loading …

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.

Sie haben noch keine Lizenz? Dann Informieren Sie sich jetzt über unsere Produkte:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Literatur
2.
Zurück zum Zitat Griffiths, P.P., Wade, B.W.: An authorization mechanism for a relational database system. ACM TODS 1(3), 242–255 (1976)CrossRef Griffiths, P.P., Wade, B.W.: An authorization mechanism for a relational database system. ACM TODS 1(3), 242–255 (1976)CrossRef
3.
Zurück zum Zitat Mershad, K., Malluhi, Q., Quzzani, M, Tang, M., Aref, A.: Approving updates in collaborative databases. In: Proceedings of the 3rd IEEE International Conference on Cloud Engineering. IC2E 15, March (2015) Mershad, K., Malluhi, Q., Quzzani, M, Tang, M., Aref, A.: Approving updates in collaborative databases. In: Proceedings of the 3rd IEEE International Conference on Cloud Engineering. IC2E 15, March (2015)
6.
Zurück zum Zitat Rose, E., Segev, A.: TooSQL-a temporal object-oriented query language. In: Entity-Relationship Approach ER’93, pp. 122–136. Springer, Berlin (1994) Rose, E., Segev, A.: TooSQL-a temporal object-oriented query language. In: Entity-Relationship Approach ER’93, pp. 122–136. Springer, Berlin (1994)
7.
Zurück zum Zitat Snodgrass, R.: An overview of the temporal query language TQuel. University of Arizona, Department of Computer Science (1992) Snodgrass, R.: An overview of the temporal query language TQuel. University of Arizona, Department of Computer Science (1992)
8.
Zurück zum Zitat Snodgrass, R.T.: The TSQL2 Temporal Query Language, vol. 330. Springer Science & Business Media, New York (2012)MATH Snodgrass, R.T.: The TSQL2 Temporal Query Language, vol. 330. Springer Science & Business Media, New York (2012)MATH
9.
Zurück zum Zitat Jensen, C.S., Lomet, D.B.: Transaction timestamping in (temporal) databases. In: VLDB, 2001, pp. 441–450 Jensen, C.S., Lomet, D.B.: Transaction timestamping in (temporal) databases. In: VLDB, 2001, pp. 441–450
10.
Zurück zum Zitat Lomet, D., Barga, R., Mokbel, M.F., Shegalov, G., Wang, R., Zhu, Y.: Immortal DB: transaction time support for SQL server. In: Proceedings of the 2005 ACM SIGMOD International Conference on Management of Data. ACM, 2005, pp. 939–941 (2005 ) Lomet, D., Barga, R., Mokbel, M.F., Shegalov, G., Wang, R., Zhu, Y.: Immortal DB: transaction time support for SQL server. In: Proceedings of the 2005 ACM SIGMOD International Conference on Management of Data. ACM, 2005, pp. 939–941 (2005 )
11.
Zurück zum Zitat Lomet, D., Hong, M., Nehme, R., Zhang, R.: Transaction time indexing with version compression. Proc. VLDB Endow. 1(1), 870–881 (2008)CrossRef Lomet, D., Hong, M., Nehme, R., Zhang, R.: Transaction time indexing with version compression. Proc. VLDB Endow. 1(1), 870–881 (2008)CrossRef
12.
Zurück zum Zitat Abdessalem, T., Jomier, G.: VQL: a query language for multiversion databases. In: Database Programming Languages. Springer, Berlin, pp. 160–179 (1998) Abdessalem, T., Jomier, G.: VQL: a query language for multiversion databases. In: Database Programming Languages. Springer, Berlin, pp. 160–179 (1998)
13.
Zurück zum Zitat Proll, S., Rauber, A.: Scalable data citation in dynamic, large databases: model and reference implementation. In: Big Data, 2013 IEEE International Conference on. IEEE, pp. 307–312 (2013) Proll, S., Rauber, A.: Scalable data citation in dynamic, large databases: model and reference implementation. In: Big Data, 2013 IEEE International Conference on. IEEE, pp. 307–312 (2013)
14.
Zurück zum Zitat Meimaris, M., Papastefanatos, G., Viglas, S., Stavrakas, Y., Pateritsas, C.: A query language for multi-version data web archives (2015). arXiv:1504.01891 Meimaris, M., Papastefanatos, G., Viglas, S., Stavrakas, Y., Pateritsas, C.: A query language for multi-version data web archives (2015). arXiv:​1504.​01891
17.
Zurück zum Zitat He, H., Singh, A.K.: Graphs-at-a-time: query language and access methods for graph databases. In: Management of data, 2008 ACM SIGMOD International Conference on. ACM, pp. 405–418 (2008) He, H., Singh, A.K.: Graphs-at-a-time: query language and access methods for graph databases. In: Management of data, 2008 ACM SIGMOD International Conference on. ACM, pp. 405–418 (2008)
18.
Zurück zum Zitat Hong, S., Chafi, H., Sedlar, E., Olukotun, K.: Green-Marl: a DSL for easy and efficient graph analysis. In: Proceedings of the 17\({{\rm th}}\) International Conference on Architectural Support for Programming Languages and Operating Systems. ACM, pp. 349–362 (2012) Hong, S., Chafi, H., Sedlar, E., Olukotun, K.: Green-Marl: a DSL for easy and efficient graph analysis. In: Proceedings of the 17\({{\rm th}}\) International Conference on Architectural Support for Programming Languages and Operating Systems. ACM, pp. 349–362 (2012)
19.
Zurück zum Zitat Jindal, A., Madden, S.: Graphiql: a graph intuitive query language for relational databases. In: Big Data, 2014 IEEE International Conference on IEEE, pp. 441–450 (2014) Jindal, A., Madden, S.: Graphiql: a graph intuitive query language for relational databases. In: Big Data, 2014 IEEE International Conference on IEEE, pp. 441–450 (2014)
Metadaten
Titel
COACT: a query interface language for collaborative databases
verfasst von
Khaleel Mershad
Qutaibah M. Malluhi
Mourad Ouzzani
Mingjie Tang
Michael Gribskov
Walid G. Aref
Deo Prakash
Publikationsdatum
13.11.2017
Verlag
Springer US
Erschienen in
Distributed and Parallel Databases / Ausgabe 1/2018
Print ISSN: 0926-8782
Elektronische ISSN: 1573-7578
DOI
https://doi.org/10.1007/s10619-017-7213-1

Weitere Artikel der Ausgabe 1/2018

Distributed and Parallel Databases 1/2018 Zur Ausgabe