ADMIN PANEL FOR HETEROGENEOUS DATABASES

Information systems are integral parts of an organization that plays a vital role in the management of its activities. They help the organization to meet its goals and objectives by delivering output efficiently. Raw material information is collected in a database to be used for processing and storage. The Database Management system is software designed to manage the data effectively and efficiently. End-users can use a DBMS to create, protect, read, update, and delete data in a database. It provides a centralized view of data that can be accessed in a controlled manner by multiple users from multiple locations. We present a new and simple method for integrating different databases on browser-based support that is easier to manage. The proposed Database Management System (DBMS) will also include backup capabilities to help in database recovery in the event of a failure.

Content

Author and article information

Journal

Title: ScienceOpen Preprints

Publisher: ScienceOpen

Publication date (Electronic preprint): 23 April 2022

Affiliations

[1 ] Information Technology Department, SIES Graduate School of Technology

Author notes

[* ]Email: mithilpit118@ 123456gst.sies.edu.in .

Author information

Mithil Poojary https://orcid.org/0000-0001-5298-2665

Article

DOI: 10.14293/S2199-1006.1.SOR-.PPY8A7L.v1

SO-VID: 4cfd9467-e9f9-4dea-a20c-9bb68f1fce1f

License:

This work has been published open access under Creative Commons Attribution License CC BY 4.0 , which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited. Conditions, terms of use and publishing policy can be found at www.scienceopen.com .

History

Date received : 23 April 2022

Data availability: Data sharing not applicable to this article as no datasets were generated or analysed during the current study.

ScienceOpen disciplines: Software engineering,Databases

Keywords: Database management system,Database,SQL,Python,Flask,API,Web application,Query,Postman,Entity relationship diagram

References

Badia Antonio. Entity-Relationship modeling revisited. ACM SIGMOD Record. Vol. 33(1):77–82. 2004. Association for Computing Machinery (ACM). [Cross Ref]
Fagin Ronald, Kimelfeld Benny, Li Yunyao, Raghavan Sriram, Vaithyanathan Shivakumar. Understanding queries in a search database system. Proceedings of the twenty-ninth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems of data - PODS '10. 2010. ACM Press. [Cross Ref]
Győrödi Cornelia A., Dumşe-Burescu Diana V., Győrödi Robert Ş., Zmaranda Doina R., Bandici Livia, Popescu Daniela E.. Performance Impact of Optimization Methods on MySQL Document-Based and Relational Databases. Applied Sciences. Vol. 11(15)2021. MDPI AG. [Cross Ref]

Comments

Comment on this article

[1] Badia Antonio. Entity-Relationship modeling revisited. ACM SIGMOD Record. Vol. 33(1):77–82. 2004. Association for Computing Machinery (ACM). [Cross Ref]

[2] Fagin Ronald, Kimelfeld Benny, Li Yunyao, Raghavan Sriram, Vaithyanathan Shivakumar. Understanding queries in a search database system. Proceedings of the twenty-ninth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems of data - PODS '10. 2010. ACM Press. [Cross Ref]

[3] Győrödi Cornelia A., Dumşe-Burescu Diana V., Győrödi Robert Ş., Zmaranda Doina R., Bandici Livia, Popescu Daniela E.. Performance Impact of Optimization Methods on MySQL Document-Based and Relational Databases. Applied Sciences. Vol. 11(15)2021. MDPI AG. [Cross Ref]