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/).

Download article (PDF)

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  -