Overview of Database Management Systems: Components, Abstraction, and Applications
Keywords:
Database management system (DBMS), components, operations, entities, redundancy, normalizationAbstract
Computer software called a database management system (DBMS) is made to manage databases effectively and conveniently. The primary goal of DBMSs is to efficiently and conveniently store and retrieve data. This paper provides an overview of the DBMS, including an explanation of its components and the data model that specifies how the data should be organized for a given use. Giving users an abstract view of the data is one of a database's main goals. The process of normalization plays a vital role in the development of a database. Developers can remove redundant data and create standards by which all data can be evaluated by employing DBMS. It makes it easy for businesses to create and utilize databases for a range of purposes through database administrators. DBMSs are currently unable to provide this kind of flexibility. The growing amount of data that needs to be indexed and retrieved, coupled with increasingly demanding workloads, has led to issues with scalability, reliability, distribution, and performance in modern search engines. This paper assesses the effectiveness of our system in comparison to existing implementations that rely on storing the complete text index directly within the file system. Additionally, it introduces a novel and uncomplicated integration approach.
References
Aparajitha RSV, Kavitha MK, Monisha TR, Pavithra TS, Raja VP. Database management systems. Int J Computer Appl. 2010; 1 (8): 66–69.
Wingerath W, Ritter N, Gessert F, Wingerath W, Ritter N, Gessert F. Database management. In: Real-Time & Stream Data Management: Push-Based Data in Research & Practice. New York, NY: Springer; 2019. pp. 9–19.
Rocha L, Vale F, Cirilo E, Barbosa D, Mourão F. A framework for migrating relational datasets to NoSQL. Procedia Computer Sci. 2015; 51: 2593–2602.
Lo E, Binnig C, Kossmann D, Tamer Özsu M, Hon WK. A framework for testing DBMS features. VLDB J. 2010; 19: 203–230.
Ordonez C. Can we analyze big data inside a DBMS? In: Proceedings of the Sixteenth International Workshop on Data Warehousing and OLAP, San Francisco, CA, USA, October 28, 2013. pp. 85–92.
Silberschatz A, Korth HF, Sudarshan S. Database System Concepts. 6th edition. New York, NY, USA: McGraw-Hill Education; 2010.
Pavlo A, Angulo G, Arulraj J, Lin H, Lin J, Ma L, Menon P, Mowry TC, Perron M, Quah I, Santurkar S. Self-driving database management systems. In: 8th Biennial Conference on Innovative Data Systems Researc (CIDR 2017), Chaminade, CA, USA, January 8–11, 2017. Volume 4, pp. 1–6.
Chen G, Vo HT, Wu S, Ooi BC, Özsu MT. A framework for supporting DBMS-like indexes in the cloud. Proc VLDB Endowment. 2011; 4 (11): 702–713.
Do J, Zhang D, Patel JM, DeWitt DJ, Naughton JF, Halverson A. Turbocharging DBMS buffer pool using SSDs. In: Proceedings of the 2011 ACM SIGMOD International Conference on Management of Data, Athens, Greece, June 12–16, 2011. pp. 1113–1124.
Manyam G, Payton MA, Roth JA, Abruzzo LV, Coombes KR. Relax with CouchDB—into the non-relational DBMS era of bioinformatics. Genomics. 2012; 100 (1): 1–7.
