Database Design on Mechanical Equipment Operation Management System
- DOI
- 10.2991/ameii-16.2016.258How to use a DOI?
- Keywords
- mechanical equipment, operation management, database design, conceptual design, logical design, physical design
- Abstract
Carrying out mechanical equipment operation management can improve the economic efficiency for enterprises, prevent accidents, ensure production safety, and promote the reform of machinery and equipment maintenance system. Using computer system to manage is the necessary requirements for the information age. For the difficulties of system development, this paper conducted the database design. Following the database design process conducted the conceptual design, logical design and physical design. Conceptual design using the E-R diagram approach, suggested a link between entities and entity; logic design is based on SQL Server, designed the logical structure for all the tables; physical design about storage structures and access methods, including the disk hardware selection, data place on the disk, use the index to improve system performance, configuration parameters and other aspects design.
- Copyright
- © 2016, the Authors. Published by Atlantis Press.
- Open Access
- This is an open access article distributed under the CC BY-NC license (http://creativecommons.org/licenses/by-nc/4.0/).
Cite this article
TY - CONF AU - Qiu Zheng AU - Kaiyuan Wu AU - Chengyan Wu AU - Lei Liu PY - 2016/04 DA - 2016/04 TI - Database Design on Mechanical Equipment Operation Management System BT - Proceedings of the 2nd International Conference on Advances in Mechanical Engineering and Industrial Informatics (AMEII 2016) PB - Atlantis Press SN - 2352-5401 UR - https://doi.org/10.2991/ameii-16.2016.258 DO - 10.2991/ameii-16.2016.258 ID - Zheng2016/04 ER -