Download pdf
The design of library database management system based on MySQL
- 1 University College London
* Author to whom correspondence should be addressed.
Abstract
Database-manage-system has become a modern management among different enterprises. The enterprise’s data need managed by a well-performed system. Also, the database is an essential need for a modern library. In this case, more and more people start using different way to build the system which is suitable for the enterprises. The library system has become a famous one which need a large database system to encounter the huge amount of data. In this article, it shows the usage of database-manage-system in a local library and how does the system work. Also, the introduction of the function of MySQL usage in this application. Finally, after the test of the data and running the programme in MySQL, the database-manage-system realize the function of list the book, check of availability, make reservations and store different users’ status. In this essay, through the test of data and the code, a database-manage-system is designed. This database-manage-system could complete basic function which contain check status, make appointments and locate books.
Keywords
database analysis, MySQL, database system, library
[1]. Jianghai Yang. Research and design of intelligent library management system based on big data. Library Hi Tech, 2018, 36. 3, 374-377.
[2]. Haiyan Su. Intelligent library construction in the era of big data. New Silk Road: late 2017, (14), 1.
[3]. Chen, R.H.. Status and Prospect of the Construction of Intelligent Libraries. Science and Technology Information 2018, 3(11).
[4]. Hu Yanling. Research on the Application of Artificial Intelligence in Library Work and Implications. Science and Technology Information, 2020, 18(30), 4.
[5]. Zhao, M.. Design and development of library management system. Science and Technology 2012 (29), 2.
[6]. Li Chunxia On the construction of characteristic databases in university libraries Technology Information 2008 (10), 1
[7]. Zhang Yu Research on the Construction and Utilization of Library Public Media Database in the Big Data Environment. Liaoning Normal University, 2014
[8]. Pan Yongsheng. The Development Direction of Traditional Libraries in the Era of All Media. News Research Guide, 2021,12 (09): 78-79
[9]. Liu Jingjia. On the Inheritance and Innovation of Digital Library Management over Traditional Library Management. Urban Construction Archives, 2020 (12): 123-124
[10]. Chapter 8 The Entity Relationship Data Model, Database Design – 2nd Edition (opentextbc.ca)
Cite this article
Wei,Z. (2024). The design of library database management system based on MySQL. Applied and Computational Engineering,38,41-50.
Data availability
The datasets used and/or analyzed during the current study will be available from the authors upon reasonable request.
Disclaimer/Publisher's Note
The statements, opinions and data contained in all publications are solely those of the individual author(s) and contributor(s) and not of EWA Publishing and/or the editor(s). EWA Publishing and/or the editor(s) disclaim responsibility for any injury to people or property resulting from any ideas, methods, instructions or products referred to in the content.
About volume
Volume title: Proceedings of the 2023 International Conference on Machine Learning and Automation
© 2024 by the author(s). Licensee EWA Publishing, Oxford, UK. This article is an open access article distributed under the terms and
conditions of the Creative Commons Attribution (CC BY) license. Authors who
publish this series agree to the following terms:
1. Authors retain copyright and grant the series right of first publication with the work simultaneously licensed under a Creative Commons
Attribution License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this
series.
2. Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the series's published
version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial
publication in this series.
3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and
during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See
Open access policy for details).