(Publisher of Peer Reviewed Open Access Journals)

International Journal of Advanced Computer Research (IJACR)

ISSN (Print):2249-7277    ISSN (Online):2277-7970
Volume-11 Issue-55 July-2021
Full-Text PDF
Paper Title : GU_DB : a database management system prototype for academia
Author Name : Bhumika Shah and Jyoti Pareek
Abstract :

There is hardly any open source database system having Academic or Research considerations. Moreover, the open-source databases do not provide developers, ease of implementing and testing their research work. We could not get full flexibility to analyze and implement our research proposal in any of the database system we approached. All the database systems approached, required the proposed work to be tested somewhere, before it could be implemented. This motivated us to develop our own Database management system that provides complete flexibility over the system, starting from the phase of the compilation till execution. GU_DB integrates our own Lexical and Syntax analysis engine which help in fetching the exact errors/messages for the query passed by the user. The ability of the database to plugin easily helps smooth connectivity with any front-end. The multi-threading nature of the database helps to seamlessly connect multiple web users. Our development has given wings to the new Database Management System Prototype named GU_DB, which is equipped with the basic features of a DBMS and has all academic and research considerations. The GU_DB is now built into a complete learning management system (LMS) in form of Virtual laboratory and is approved by Virtual Labs (a project under MHRD NMEICT) and the content is hosted at the Vlabs-Dev portal by IIT-Bombay. The Virtual laboratory hosted exist as a front-end and as a back-end of the same system, GU_DB exists in form of a database system.

Keywords : Database management system (DBMS), Open-source database systems, Learning management system (LMS), DBMS prototype, Academic DBMS, Custom DBMS development, Virtual laboratory.
Cite this article : Shah B, Pareek J. GU_DB : a database management system prototype for academia. International Journal of Advanced Computer Research. 2021; 11(55):67-82. DOI:10.19101/IJACR.2021.1152017.
References :
[1]Peters R, Sikorski R. Building your own: a physicians guide to creating a Web site. JAMA. 1998; 280(15):1365-6.
[Crossref] [Google Scholar]
[2]Venkatesh Emani K, Sudarshan S. Cobra: a framework for cost based rewriting of database applications. arXiv e-prints. 2018: arXiv-1801.
[Google Scholar]
[3]Khurana K, Haritsa JR. UNMASQUE: a hidden SQL query extractor. Proceedings of the VLDB Endowment. 2020; 13(12):2809-12.
[Crossref] [Google Scholar]
[4]https://www.cs.cmu.edu/~pavlo/blog/2017/03/building-a-new-database-management-system-in-academia.html. Accessed 20 March 2021.
[5]https://www.trustradius.com/open-source-database. Accessed 20 March 2021.
[6]Tan WC, Zhang M, Elmeleegy H, Srivastava D. REGAL+ reverse engineering SPJA queries. Proceedings of the VLDB Endowment. 2018; 11(12):1982-5.
[Google Scholar]
[7]Gribkoff E. Applications of deterministic finite automata. UC Davis. 2013:1-9.
[Google Scholar]
[8]Shah B, Pareek J, Patel S, Patel V. Database Virtual laboratory for guided learning.2019; 8(2):5418-25.
[Crossref] [Google Scholar]
[9]Shah B, Pareek J. Virtual Laboratories in STEM courses: a critical review. 2019; 14(2):118-29.
[Google Scholar]
[10]https://en.wikipedia.org/wiki/Hash_table. Accessed 20 March 2021.
[11]https://www.vlab.co.in/. Accessed 20 March 2021.
[12]Shah B, Pareek J. Query optimization for information retrieval in multilingual environment for e-governance resources. In international conference on ICT in business industry & government 2016 (pp. 1-4). IEEE.
[Crossref] [Google Scholar]
[13]Shah B, Pareek J, Kanziya D. A novel approach to optimize subqueries for open source databases. In smart trends in systems, security and sustainability 2018 (pp. 331-346). Springer, Singapore.
[Crossref] [Google Scholar]
[14]https://en.wikipedia.org/wiki/Learning_management_system. Accessed 20 March 2021.
[15]Vachharajani V, Pareek J. Framework to approximate label matching for automatic assessment of use-case diagram. International Journal of Distance Education Technologies. 2019; 17(3):75-95.
[Crossref] [Google Scholar]