American Journal of Computer Science and Technology

Submit a Manuscript

Publishing with us to make your research visible to the widest possible audience.

Propose a Special Issue

Building a community of authors and readers to discuss the latest research and develop new ideas.

Research on Principles and Problems of Computer Software Database Design

Database design is an unforgettable part of this evolution, it is the core of systems and is the foundation for creating a safe and reliable program. The design quality is directly correlated to the user’s experience with the system. It has a huge effect on the smoothness, stability, and security of the system’s operation. Problems also arise when the database is neglected. If the design lacks quality due to the developer’s disregard for following design principles these problems arise, thus developers need to comprehensively analyze, test, and summarize their design. This paper aims at software design concepts and their importance from a researcher’s point of view. We will discuss how someone could improve the transmission efficiency of data resources and the importance of updating the software database. Our study shows there is a difference between databases of different applications. For instance, the database of a supermarket chain must be fundamentally different from that of an information technology company. An insurance industry database is definitely different from a manufacturing enterprise database. From the micro perspective, although the same industry database is being used, there are differentiated designs and services. For example, a supermarket chain, international chain, and domestic supermarket chain databases are completely different. Another thing we want to highlight is about the caution that is advised in any industry, the systems design and development industry has to be extra careful. If a single aspect of a program database is organized wrong, the whole system could crash. It causes huge losses for the enterprises as the company is dependent on it. In addition, accuracy is crucial for maintaining the integrity of data. For example, if inaccurate data can lead to false conclusions and wasted time and resources, the users must enter data correctly and consistently to ensure accuracy. Data should also be verified regularly to identify any errors that may have been introduced. The study shows we lack vitality in the design phase of software systems. Regarding the literature, we evaluated that future work needed to be used as an architecture with improved hardware capability, and evaluate the architecture’s adaptability in more scenarios. The obtained results from our study encourage and show the potential for applying a software architecture for data-intensive real-time applications in the future. The paper concludes even though the usage of real-time based database technologies increased in recent years, there is a lack of standardization and modularized architectures.

Computer Software, Database Design, Principles of Design, Problems

APA Style

Zhang Daoping, Tuyatsetseg Badarch. (2023). Research on Principles and Problems of Computer Software Database Design. American Journal of Computer Science and Technology, 6(1), 20-24. https://doi.org/10.11648/j.ajcst.20230601.13

ACS Style

Zhang Daoping; Tuyatsetseg Badarch. Research on Principles and Problems of Computer Software Database Design. Am. J. Comput. Sci. Technol. 2023, 6(1), 20-24. doi: 10.11648/j.ajcst.20230601.13

AMA Style

Zhang Daoping, Tuyatsetseg Badarch. Research on Principles and Problems of Computer Software Database Design. Am J Comput Sci Technol. 2023;6(1):20-24. doi: 10.11648/j.ajcst.20230601.13

Copyright © 2023 Authors retain the copyright of this article.
This article is an open access article distributed under the Creative Commons Attribution License (http://creativecommons.org/licenses/by/4.0/) which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

1. Mingwu F, Analysis of database programming technology based on computer software engineering in the new era Hubei Agricultural Mechanization 21 157-8, 2019.
2. L. Almeida, F. Santos, Coordinating distributed autonomous agents with a real-time database: The cambada project. In Proceedings of the 19th International Symposium of Computer and Information Sciences, 2004.
3. Dan Jia, Research on Method of Database Platform Design and Machine Learning Performance Prediction of Lubricating Materials. General Institute of Mechanical Research, 2021.
4. Jing Ziqi, Zhaonian, Design and implementation of multi-version concurrency control on embedded database SQLite. Journal of Computer Applications, Journal of Plant Genetic Resources, 2022.
5. Ni Jiacai, Key Techniques of Multi-Tenant Database Design, Tsinghua University, 2015.
6. Warr WNick Laus C et al. Exploration of ultra large compound collections for drug discovery, Journal of Chemical Information and Modeling, 62, 9: 2021-2034, 2022.
7. PubChem project. PubChem compound. https://www.ncbi.nlm.nih.gov/pccompound accessed July 1, 2022.
8. Jain A, Hauter R, The materials project: A materials genome approach to accelerating materials innovation, APL Materials, 2013.
9. Wang Yu-fu, Chen Li, Function and Use of the World Major Grape Germplasm Resources Database [J]. 2022.
10. Energetic materials compendium (EMC) v5.0. https://www.msi-ac.nato.int/news/energetic-materials-compendium-emc-v50 accessed July 1, 2022.
11. Jingjing Chen. Research and Visualization of SQLite Database. Nanjing University of Posts and Telecommunications. 2020.
12. Zhiyi Wang. Design of Data Upload System Based on Database Cluster. China Electronics Technology Group Corporation Electronic Science Research Institute. 2021.
13. Bei Han. Research and Application of SQLite Database. Nanjing University of Posts and Telecommunications for the Degree of Master of Engineering. 2019.
14. ZHANG Hao, REN Jing. Design and research of smart tourism information service platform. journal of Computer Applications. 2021.
15. Ju ruli, Ying Chunma. Design of Information Management Database Based on Computer Technology. Information and computers. 2022.
16. Tao Qiu, Bin Wang, Shaowei Shu, Zhibo Zhao, Zi wen song, Yan hui zhong. Intelligent index tuning method for relational database. Journal of software. 2020.
17. Yanqing Yang, Xian Chongguo. Problems and design principles in computer database design. Wireless Internet Technology Phase II. 2021.
18. Jiyang HU. Research on Necessity and Design Method of Computer Software Database Development. Computer Knowledge and Technology, 2020 (29): 36-37.
19. Yangdong He. Design and Implementation of Embedded real-time Database for Intelligent Agricultural Machinery. Nanjing University. 2019.
20. Cadaviz, Miguel & Farias, Kleinner & Gonçales, Lucian & Bischoff, Vinicius. (2018). DORIC: An Architecture for Data-intensive Real-time Applications. 1-7. 10.1145/3229345.3229416.