Skip to main content
Springer Nature Link
Log in

MySQL Collaboration by Approving and Tracking Updates with Dependencies: A Versioning Approach

  • Conference paper
  • First Online:
Computational Science and Its Applications – ICCSA 2022 Workshops (ICCSA 2022)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 13381))

Included in the following conference series:

  • 1259 Accesses

Abstract

In recent times, data science has seen a rapid increase in the need for individuals and teams to analyze and manipulate data at scale for various scientific and commercial purposes. Groups often collaboratively analyze datasets, thereby leading to a proliferation of dataset versions at each stage of iterative exploration and analysis. Thus, an efficient collaborative system compatible with handling various versions is needed rather than the current most often used ad-hoc versioning mechanism. In a collaborative database, all the collaborators working together on a project need to interact together to perform extensive curation activities. In a typical scenario, when an update is made by one of the collaborators, it should become visible to the whole team for possible comments and modifications, which in turn aid the data custodian in making a better decision. Relational databases provide efficient data management and querying. However, it lacks various features to support efficient collaboration. In these databases, the approval and authorization of updates are based completely on the identity of the user, e.g., via SQL GRANT and REVOKE commands. In this paper, we present a framework well suited for collaboration and implemented on top of relational databases that will enable the team to manage as well as query the dataset versions efficiently.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Log in via an institution

Subscribe and save

Springer+ Basic
$34.99 /Month
  • Get 10 units per month
  • Download Article/Chapter or eBook
  • 1 Unit = 1 Article or 1 Chapter
  • Cancel anytime
Subscribe now

Buy Now

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Similar content being viewed by others

References

  1. Mershad, K., Malluhi, Q.M., Ouzzani, M., Tang, M., Gribskov, M., Aref, W.G.: AUDIT: approving and tracking updates with dependencies in collaborative databases. Distrib. Parallel Databases 36(1), 81–119 (2017). https://doi.org/10.1007/s10619-017-7208-y

    Article  Google Scholar 

  2. Mershad, K., et al.: COACT: a query interface language for collaborative databases. Distrib. Parallel Databases 36(1), 121–151 (2017). https://doi.org/10.1007/s10619-017-7213-1

    Article  Google Scholar 

  3. Huang, S., Xu, L., Liu, J., Elmore, A.J., Parameswaran, A.: Orpheus DB: bolt-on versioning for relational databases. Proc. VLDB Endow. 10(10), 1130–1141 (2017)

    Article  Google Scholar 

  4. Xu, L., Huang, S., Hui, S., Elmore, A.J., Parameswaran, A.: ORPHEUSDB: a lightweight approach to relational dataset versioning. In: Proceedings of the 2017 ACM International Conference on Management of Data, pp. 1655–1658. ACM, May 2017

    Google Scholar 

  5. Navathe, S.B., Patil, U., Guan, W.: Genomic and proteomic databases: foundations, current status and future applications. J. Comput. Sci. Eng. 1(1), 1–30 (2007)

    Article  Google Scholar 

  6. Goldberg, D., Nichols, D., Oki, B.M., Terry, D.: Using collaborative filtering to weave an information tapestry. Commun. ACM 35(12), 61–70 (1992)

    Article  Google Scholar 

  7. Howe, B., Halperin, D., Ribalet, F., Chitnis, S., Armbrust, E.V.: Collaborative science workflows in SQL. Comput. Sci. Eng. 15(3), 22–31 (2013)

    Article  Google Scholar 

  8. Halperin, D., Ribalet, F., Weitz, K., Saito, M.A., Howe, B., Armbrust, E.: Real-time collaborative analysis with (almost) pure SQL: a case study in biogeochemical oceanography. In: Proceedings of the 25th International Conference on Scientific and Statistical Database Management, p. 28. ACM, July 2013

    Google Scholar 

  9. Eirinaki, M., Abraham, S., Polyzotis, N., Shaikh, N.: QueRIE: collaborative database exploration. IEEE Trans. Knowl. Data Eng. 26(7), 1778–1790 (2014)

    Article  Google Scholar 

  10. Harrington, J.L.: Relational Database Design and Implementation. Morgan Kaufmann (2016)

    Google Scholar 

  11. Coronel, C., Morris, S.: Database Systems: Design, Implementation, & Management. Cengage Learning (2016)

    Google Scholar 

  12. Nascimento, M.A., Sellis, T., Cheng, R.: Special issue on spatial and temporal database management. GeoInformatica 19(2), 297–298 (2015). https://doi.org/10.1007/s10707-015-0224-z

    Article  Google Scholar 

  13. Radhakrishna, V., Kumar, P.V., Janaki, V.: An efficient approach to find similar temporal association patterns performing only single database scan. Revista Tecnica De La Facultad De Ingenieria Universidad Del Zulia 39(1), 241–255 (2016)

    Google Scholar 

  14. Collaborate your way to better SQL queries and data visualizations: https://blog.modeanalytics.com/collaborate-your-way-to-better-sql-queries/

  15. SqlDBM’s Latest And Greatest: Team Project Collaboration: http://blog.sqldbm.com/team-collaboration/

  16. Painless Data Versioning for Collaborative Data Science: https://medium.com/data-people/painless-data-versioning-for-collaborative-data-science-90cf3a2e279d

  17. Bioinformatics Databases: https://www.ebi.ac.uk/training/online/course/bioinformatics-terrified-2018/what-bioinformatics

  18. MySQL Database - very good thesis: http://www.engpaper.com/mysql-database-very-good-thesis.html

  19. Relational Database Management System: https://searchdatamanagement.techtarget.com/definition/RDBMS-relational-database-management-system

  20. Nambiar, U.B., Deshpande, P.M., Halasipuram, R.S., Iyer, B.R.: U.S. Patent No. 9,262,491. U.S. Patent and Trademark Office, Washington, DC (2016)

    Google Scholar 

  21. Alromema, N.A., Rahim, M.S.M., Albidewi, I.: Temporal database models validation and verification using mapping methodology. VFAST Trans. Softw. Eng. 11(2), 15–26 (2016)

    Article  Google Scholar 

  22. Alromema, N., Rahim, M.S.M., Albidewi, I.: An Efficient approach for modeling temporal database with interval-based timestamping in conventional database management systems. J. Comput. Theor. Nanosci. 14(9), 4569–4575 (2017)

    Article  Google Scholar 

  23. Kalanat, N., Kangavari, M.R.: Data mining methods for rule designing and rule triggering in active database systems. Int. J. Datab. Theory Appl. 8(1), 39–44 (2015)

    Google Scholar 

  24. Berndtsson, M., Mellin, J.: Active database knowledge model. In: Liu, L., Özsu, M.T. (eds.) Encyclopedia of Database Systems. Springer, Boston (2009). https://doi.org/10.1007/978-0-387-39940-9_508

  25. Veldhuizen, T.L.: U.S. Patent No. 9,424,304. Patent and Trademark Office, Washington, DC (2016)

    Google Scholar 

  26. Meagher, M.: U.S. Patent No. 8,822,848. U.S. Patent and Trademark Office, Washington, DC (2014)

    Google Scholar 

  27. Vance, J. R., et al.: U.S. Patent No. 9,277,833. Patent and Trademark Office. Washington, DC (2016)

    Google Scholar 

  28. Collins Jr., D.A., Amada, J.: U.S. Patent No. 8,925,811. U.S. Patent and Trademark Office. Washington, DC (2015)

    Google Scholar 

  29. Active Databases: http://web.cs.ucla.edu/classes/winter04/cs240A/notes/node1.html

  30. Apache HBase Reference Guide: https://hbase.apache.org/book.html

  31. The Architecture of Apache HBase: https://intellipaat.com/blog/what-is-apache-hbase/

  32. Gómez, A., Benelallam, A., Tisi, M.: Decentralized model persistence for distributed computing. In: 3rd BigMDE Workshop, July 2015

    Google Scholar 

  33. Ramesh, D., Kumar, C.: An incremental protocol approach for secure collaboration between Byzantine processes in heterogeneous distributed processing systems. Glob. J. Technol. 3 (2013)

    Google Scholar 

  34. Ramesh, D., Khosla, E., Bhukya, S.N.: Inclusion of e-commerce workflow with NoSQL DBMS: MongoDB document store. In: 2016 IEEE International Conference on Computational Intelligence and Computing Research (ICCIC), pp. 1–5. IEEE, December 2016

    Google Scholar 

Download references

Acknowledgments

This research work is supported by the Indian Institute of Technology (Indian School of Mines), Dhanbad, Govt. of India. The authors wish to express their gratitude and heartiest thanks to the Department of Computer Science & Engineering, Indian Institute of Technology (ISM), Dhanbad, India, for their research support.

Author information

Authors and Affiliations

  1. Department of Computer Science and Engineering, Indian Institute of Technology (Indian School of Mines), Dhanbad, 826004, India

    Dharavath Ramesh

  2. National Institute of Technology, Agartala, Tripura, 799046, India

    Munesh Chandra Trivedi

Authors
  1. Dharavath Ramesh
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Munesh Chandra Trivedi
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Dharavath Ramesh .

Editor information

Editors and Affiliations

  1. University of Perugia, Perugia, Italy

    Osvaldo Gervasi

  2. University of Basilicata, Potenza, Potenza, Italy

    Beniamino Murgante

  3. Østfold University College, Halden, Norway

    Sanjay Misra

  4. University of Minho, Braga, Portugal

    Ana Maria A. C. Rocha

  5. University of Cagliari, Cagliari, Italy

    Chiara Garau

Rights and permissions

Reprints and permissions

Copyright information

© 2022 The Author(s), under exclusive license to Springer Nature Switzerland AG

About this paper

Check for updates. Verify currency and authenticity via CrossMark

Cite this paper

Ramesh, D., Trivedi, M.C. (2022). MySQL Collaboration by Approving and Tracking Updates with Dependencies: A Versioning Approach. In: Gervasi, O., Murgante, B., Misra, S., Rocha, A.M.A.C., Garau, C. (eds) Computational Science and Its Applications – ICCSA 2022 Workshops. ICCSA 2022. Lecture Notes in Computer Science, vol 13381. Springer, Cham. https://doi.org/10.1007/978-3-031-10548-7_28

Download citation

  • DOI: https://doi.org/10.1007/978-3-031-10548-7_28

  • Published:

  • Publisher Name: Springer, Cham

  • Print ISBN: 978-3-031-10547-0

  • Online ISBN: 978-3-031-10548-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics