An engineering database design method and its application based on logic level connection

1 Introduction

Engineering database system and traditional database system, including engineering database management system and engineering database design of two aspects. The main task of engineering database design is to design a reasonable structure, easy to use and, in accordance with the requirements of engineering database management system, for a class or a project. High efficiency Engineering database and its application system. The database design is good, can make the whole application system high efficiency, maintenance simple, easy to use. Even the best applications do not compensate for some of the pitfalls of database design. The research includes the design method of engineering database and the research and development of auxiliary design tools. This paper discusses some problems in engineering database design, expounds the basic concept and content of engineering database design, and some characteristics of database design in engineering application field, introduces a kind of analytic hierarchy process, based on connection relation, The method and application of engineering database design based on object-oriented technology.

2 Design characteristics of engineering database

The so-called engineering database design, it means to design a whole process of engineering database structure from the point of engineering application. A rough process of it is: first of all, we need to analyze the data in the field of engineering application, and sort out the concept of the processed object. This concept is independent of the engineering database management system, It has nothing to do with the specific Engineering database management system. After the conceptual design is completed, the concrete design of database is carried out according to the actual situation.

The design of engineering database system, which is the foundation of integrated CAD/CAM system, absorbs the conventional design thought, and also fully considers some characteristics related to engineering design environment, to meet the needs of Project data processing [1]

.2.1 Design objectives of engineering database

The basic goal of engineering database design is to effectively provide the required engineering data for the integrated application. And make these engineering data have high stability. Specifically, the goal of conceptual design is to describe and synthesize the information requirements of the application system, and to simulate the information structure of engineering application from the concept. Easy to understand. Logical design to produce a high data independence, low redundancy, data consistency and integrity of the characteristics of the logic of the structure, can meet and minimum coverage of the application of the data requirements; can be project number According to the library management system. Physical design should produce a physical structure of the database that can be effectively implemented, and design of implementation details related to system software, hardware and its distribution.

2.2 Focus on the practicality of the design method

In order to improve the utilization of the system resources, simplify the software design and data conversion, avoid the waste of human, material and financial resources in the system development, improve the productivity of the system, we must consider the practicability of the design system.

Generally, most of the theoretical research of Database design methodology focuses on the general the Engineering Database design practice is more focused on the practicality of the specific environment. Therefore, on the one hand, to meet user needs as the starting point and destination of design, the information needs through to the whole process of database design; On the other hand, in the degree of abstraction of data, Conceptual model levels, data pattern types, and design tools should be selected and determined according to the design environment and objectives, focusing on their actual effects.