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.

Keyword

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

Refference

[1][1]Peters R, Sikorski R. Building your own: a physicians guide to creating a Web site. JAMA. 1998; 280(15):1365-6.

[2][2]Venkatesh Emani K, Sudarshan S. Cobra: a framework for cost based rewriting of database applications. arXiv e-prints. 2018: arXiv-1801.

[3][3]Khurana K, Haritsa JR. UNMASQUE: a hidden SQL query extractor. Proceedings of the VLDB Endowment. 2020; 13(12):2809-12.

[4][4]https://www.cs.cmu.edu/~pavlo/blog/2017/03/building-a-new-database-management-system-in-academia.html. Accessed 20 March 2021.

[5][5]https://www.trustradius.com/open-source-database. Accessed 20 March 2021.

[6][6]Tan WC, Zhang M, Elmeleegy H, Srivastava D. REGAL+ reverse engineering SPJA queries. Proceedings of the VLDB Endowment. 2018; 11(12):1982-5.

[7][7]Gribkoff E. Applications of deterministic finite automata. UC Davis. 2013:1-9.

[8][8]Shah B, Pareek J, Patel S, Patel V. Database Virtual laboratory for guided learning.2019; 8(2):5418-25.

[9][9]Shah B, Pareek J. Virtual Laboratories in STEM courses: a critical review. 2019; 14(2):118-29.

[10][10]https://en.wikipedia.org/wiki/Hash_table. Accessed 20 March 2021.

[11][11]https://www.vlab.co.in/. Accessed 20 March 2021.

[12][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.

[13][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.

[14][14]https://en.wikipedia.org/wiki/Learning_management_system. Accessed 20 March 2021.

[15][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.