CN114218196A - Interface database design method for flight training safety - Google Patents
Interface database design method for flight training safety Download PDFInfo
- Publication number
- CN114218196A CN114218196A CN202111549036.1A CN202111549036A CN114218196A CN 114218196 A CN114218196 A CN 114218196A CN 202111549036 A CN202111549036 A CN 202111549036A CN 114218196 A CN114218196 A CN 114218196A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- design
- interface database
- flight training
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
A design method of an interface database facing flight training safety comprises the steps of firstly collecting data required by the flight training safety, analyzing and determining the required data to form an integration requirement, abstracting the integration requirement into an information structure to form a conceptual model independent of a concrete DBMS, and obtaining an E-R diagram; then converting the E-R diagram into a logical structure which is consistent with a data model supported by a database management system, and determining parameters of physical structure design; after the physical design of the interface database is completed, the interface database is established, the interface database system adopts an open source database MySQL, the structures of the database logic and the physical design are established in the database, the interface database is generated through debugging, all business data are organized to be put into a warehouse, and finally, the interface database is continuously evaluated, adjusted and modified according to the actual situation. The method and the system uniformly summarize flight training safety data, eliminate data islands and provide guarantee for correlation analysis of subsequently integrated multi-class flight data.
Description
Technical Field
The invention relates to the technical field of database design, in particular to an interface database design method for flight training safety.
Background
With the improvement of the informatization degree of the airplane, a large amount of standardized flight data can be recorded in a computer and a data recorder which are installed on the airplane, the carried information is more accurate and objective, the prior documents disclose a method for analyzing the flight data recorded during the flying period of the airplane and an interaction, transmission and receiving method of the flight data, but most of the documents aim at unmanned aerial vehicle data, the data source is single, and the unmanned aerial vehicle data and the manned flight data have obvious differences in the aspects of data dimension, data composition and the like.
The flight safety is always a focus of concern in the field of domestic and foreign aviation, at the present stage, the overall situation of the flight safety is still severe, if the potential safety problem in the flight process cannot be found in time and effective measures are taken for control, the flight safety can be endangered, and further safety accidents are caused.
Actually, current flight safety relates to data of multiple systems, such as airborne data, maintenance data and the like, each application system is established according to business requirements during construction, database tables and field formats are not uniform, and effective integration and comprehensive analysis cannot be performed. In view of this, it is urgently needed to design and establish a set of interface database facing flight training safety, store a large amount of generated service data, realize the integration and fusion of data, and facilitate the discovery of potential safety hazards in flight through a data analysis and mining means in the following.
Disclosure of Invention
The technical problem to be solved by the present invention is to provide a design method of interface database for flight training security, so as to solve the problems in the background art.
The technical problem solved by the invention is realized by adopting the following technical scheme:
a design method of an interface database for flight training safety comprises the following specific steps:
(1) demand collection and analysis
Reflecting the actual requirements for constructing an interface database facing flight training safety, and integrating the existing data and the requirements to form integrated requirements: 1) fully knowing the data condition of an original service system, researching data objects to be processed, determining the function of an interface database, and fully considering the expanded and changed multi-service system data in the future; 2) the data type is complex, the interface database facing the flight training safety comprises data with various structures, the data content is changeable, and the formats are various; 3) the data volume is large, and with the increase of flight number, the data stored in the interface database facing flight training safety is accumulated day by day, and the data volume is huge; 4) the data quality is different, and because the embodiment needs to integrate multiple types of flight safety data and maintenance guarantee data, the data quality is different, the scale is different, and the relationship between the data is complex, so that the logic for designing the database is complex;
(2) concept structure design
Abstracting an integrated demand obtained by demand analysis into an information structure to form a conceptual model independent of a concrete DBMS, wherein the adopted strategy is a bottom-up method, namely, the demand analysis is performed from top to bottom, then, a conceptual structure is designed from bottom to top, the design of an interface database concept facing flight training safety is performed in two steps, the step 1 is to abstract data and design a local view, and the step 2 is to integrate the local view to obtain a global E-R diagram;
(3) logical structure design
The task of logic design is to convert the global E-R diagram designed in the concept design stage into a logic structure conforming to a data model supported by a database management system, and the logic structure design is carried out in three steps: 1) converting a global E-R diagram obtained by the conceptual structure into a relational model; 2) converting the relation model obtained by conversion to a data model supported by a database management system; 3) optimizing the data model, and converting the global E-R model into a relational model through surface contact so as to determine the logical structure of the interface database facing flight training safety;
(4) physical structure design
Designing according to a concept design, a logic structure design and a computer system, determining parameters of a physical structure design, such as a data structure, an access path, a storage space, a recording format and the like, wherein the physical structure design of a database is a process of selecting a most suitable physical structure for a logic data model;
(5) database enforcement
And after the physical design of the interface database is finished, the interface database is established, the interface database system adopts an open source database MySQL, the structures of the logical design and the physical design of the database are established in the database according to the design content, the interface database is generated through debugging, and then all the service data are organized and stored in the database.
(6) Database operation and maintenance
The database system must be evaluated, adjusted and modified continuously according to the actual situation in the operation process.
Has the advantages that: according to the invention, based on the existing flight training safety data, a database table relation is designed, and a database table and fields are constructed, so that the flight training safety data can be uniformly stored and managed, the standardization of the data is facilitated, and the integrity and consistency of the data are ensured; meanwhile, through the established interface database, flight training safety data are collected in a unified mode, data islands are eliminated, correlation analysis is conducted on the subsequent comprehensive multi-class flight data, fault reasons are found, potential flight safety problems are found, the safety prediction capability of flight is improved, and a design thought is provided.
Drawings
FIG. 1 is a schematic design flow diagram of a preferred embodiment of the present invention.
FIG. 2 is a diagram illustrating the conceptual steps of interface database design in accordance with a preferred embodiment of the present invention.
FIG. 3 is an exemplary diagram of a preferred embodiment of the present invention.
Detailed Description
In order to make the technical means, the creation characteristics, the achievement purposes and the effects of the invention easy to understand, the invention is further explained below by combining the specific drawings.
Referring to fig. 1, a method for designing an interface database for flight training security includes the following steps:
(1) demand collection and analysis
Reflecting the actual requirements for constructing an interface database facing flight training safety, and integrating the existing data and the requirements to form integrated requirements: 1) fully knowing the data condition of an original service system, researching data objects to be processed, determining the function of an interface database, and fully considering the expanded and changed multi-service system data in the future; 2) the data type is complex, the interface database facing the flight training safety comprises data with various structures, the data content is changeable, and the formats are various; 3) the data volume is large, and with the increase of flight number, the data stored in the interface database facing flight training safety is accumulated day by day, and the data volume is huge; 4) the data quality is different, and because the embodiment needs to integrate multiple types of flight safety data and maintenance guarantee data, the data quality is different, the scale is different, and the relationship between the data is complex, so that the logic for designing the database is complex;
therefore, the embodiment is based on integration and fusion of data, the data after flight mainly comes from various flight data recording devices, maintenance records and the like, as shown in table 1, the data recording process has the characteristics of high sampling rate and multi-parameter parallel access, and the data from a sensor to a storage medium is the process of one-way communication of an airborne data bus, so that the data obtained by decoding the ground system after flight has the characteristics of completeness and reliability, the sample data volume is abundant, the data is static, an interface database is designed according to the existing data condition, and a basis is provided for realizing the effective fusion of various flight safety data;
TABLE 1 flight training safety data categories
(2) Concept structure design
Abstracting an integrated demand obtained by demand analysis into an information structure to form a conceptual model independent of a concrete DBMS, wherein the concept design of the embodiment adopts a bottom-up method as a strategy, namely, performing demand analysis from top to bottom, then designing a concept structure from bottom to top, and performing design and scoring of an interface database concept facing flight training safety in two steps, wherein the step 1 is to abstract data and design a local view, and the step 2 is to integrate the local view to obtain a global E-R diagram, as shown in FIG. 2; the conceptual structural design of the embodiment is described by an E-R diagram;
(3) logical structure design
The task of logic design is to convert the global E-R diagram designed in the concept design stage into a logic structure corresponding to a data model supported by a database management system, and the logic structure design of the embodiment is carried out in three steps: 1) converting a global E-R diagram obtained by the conceptual structure into a relational model; 2) converting the relation model obtained by conversion to a data model supported by a database management system; 3) optimizing the data model, and converting the global E-R model into a relational model through surface connection, thereby determining the logical structure of the interface database facing flight training safety, and the structure of part interface table, as shown in Table 2:
TABLE 2 flight training safety section interface Table Structure example
(4) Physical structure design
Designing according to a concept design, a logic structure design and a computer system, determining parameters of a physical structure design, such as a data structure, an access path, a storage space, a recording format and the like, wherein the physical structure design of a database is a process of selecting a most suitable physical structure for a logic data model;
(5) database enforcement
After the physical design of the interface database is completed, the interface database is established, as shown in fig. 3, the interface database system of this embodiment adopts an open source database MySQL, establishes a structure of a database logic and a physical design in the database according to design contents, generates the interface database through debugging, and then organizes all business data to be put into storage.
(6) Database operation and maintenance
The database system must be evaluated, adjusted and modified continuously according to the actual situation in the operation process.
The interface database oriented to flight training safety in the embodiment is used for storing flight safety data extracted from a business system, and the data is basically consistent with the business system in various aspects such as data structure, logic relationship among data, data granularity, organization mode and the like, but is different from the business database, and the detail data at the moment is not 'current and constantly changing' data, but 'historical and unchanging' data. Because the interface database stores historical, stable and integrated data, the data is integrated with the historical data in the past, the data is kept for a long time (5-10 years are different) and needs to meet the query requirement, therefore, the capacity estimation of the interface database is also anticipated in advance, the storage life of important data is firstly determined, the average field length value of a relevant table is the annual record number predicted per year, then 20% redundancy and 20% redundancy reserved by a disk are added, and all levels of modes of the database are formed at different stages of the database design, so that the data integration and fusion can be realized, and the subsequent mining is supported.
Claims (7)
1. A design method of an interface database for flight training safety is characterized by comprising the following specific steps:
(1) demand collection and analysis
Collecting data required by flight training safety, and analyzing and determining the required data to form an integration requirement;
(2) concept structure design
Abstracting the integration requirement obtained by requirement analysis into an information structure to form a conceptual model independent of a concrete DBMS to obtain a global E-R diagram;
(3) logical structure design
Converting the global E-R diagram designed in the concept design stage into a logic structure which is consistent with a data model supported by a database management system;
(4) physical structure design
Designing according to the concept design, the logic structure design and the computer system, and determining the parameters of the physical structure design;
(5) database enforcement
After the physical design of the interface database is completed, the interface database is established, an open source database MySQL is adopted by an interface database system, the structures of the logical design and the physical design of the database are established in the database according to the design content, the interface database is generated through debugging, and then all service data are organized to be stored in a warehouse;
(6) database operation and maintenance
And continuously evaluating, adjusting and modifying the database system according to the actual situation in the operation process of the database system.
2. The method for designing an interface database for flight training safety according to claim 1, wherein in the step (1), the data required for flight training safety is mainly the post-flight data.
3. The design method of an interface database for flight training safety as claimed in claim 2, wherein the data is derived from various flight data recording devices and maintenance records.
4. The design method of interface database facing flight training safety as claimed in claim 1, wherein in step (2), the strategy adopted by concept design is a bottom-up method, i.e. performing demand analysis from top to bottom, and then designing concept structure from bottom to top.
5. The method for designing the interface database for flight training safety as claimed in claim 1, wherein in the step (2), concept design is performed in two steps, wherein the step 1 is to abstract data and design a local view, and the step 2 is to integrate the local view to obtain a global E-R diagram.
6. The method for designing an interface database for flight training safety according to claim 1, wherein in the step (3), the logic structure design is performed in three steps: 1) converting an E-R diagram obtained by the concept structure into a relation model; 2) converting the relation model obtained by conversion to a data model supported by a database management system; 3) and optimizing the data model, and converting the global E-R model into a relational model through surface contact so as to determine the logical structure of the interface database facing the flight training safety.
7. The method for designing an interface database for flight training safety according to claim 1, wherein in the step (4), the parameters include data structure, access path, storage space and record format.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111549036.1A CN114218196A (en) | 2021-12-17 | 2021-12-17 | Interface database design method for flight training safety |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111549036.1A CN114218196A (en) | 2021-12-17 | 2021-12-17 | Interface database design method for flight training safety |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114218196A true CN114218196A (en) | 2022-03-22 |
Family
ID=80703409
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111549036.1A Pending CN114218196A (en) | 2021-12-17 | 2021-12-17 | Interface database design method for flight training safety |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114218196A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115129942A (en) * | 2022-05-24 | 2022-09-30 | 湖北省计量测试技术研究院 | Method for storing metering detection data by using graph data structure |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7958165B1 (en) * | 2003-11-18 | 2011-06-07 | Unisys Corporation | Converting logical aspects of common warehouse model to design elements for relational database |
| US20140229491A1 (en) * | 2013-02-08 | 2014-08-14 | Arindam Bhattacharjee | Converting data models into in-database analysis models |
| CN106383823A (en) * | 2015-07-26 | 2017-02-08 | 威海创林信息科技有限公司 | Instructional management system database designing method |
| CN111240350A (en) * | 2020-02-13 | 2020-06-05 | 西安爱生无人机技术有限公司 | Unmanned aerial vehicle pilot dynamic behavior evaluation system |
| CN111651537A (en) * | 2020-04-29 | 2020-09-11 | 民航数据通信有限责任公司 | Method and device for making flight procedure standard diagram by data driving |
| CN112527771A (en) * | 2020-12-12 | 2021-03-19 | 江西洪都航空工业集团有限责任公司 | City management-oriented database design method |
| CN113282567A (en) * | 2021-04-02 | 2021-08-20 | 重庆交通大学 | Method, system, medium and application for analyzing unsafe behavior database of operating personnel |
-
2021
- 2021-12-17 CN CN202111549036.1A patent/CN114218196A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7958165B1 (en) * | 2003-11-18 | 2011-06-07 | Unisys Corporation | Converting logical aspects of common warehouse model to design elements for relational database |
| US20140229491A1 (en) * | 2013-02-08 | 2014-08-14 | Arindam Bhattacharjee | Converting data models into in-database analysis models |
| CN106383823A (en) * | 2015-07-26 | 2017-02-08 | 威海创林信息科技有限公司 | Instructional management system database designing method |
| CN111240350A (en) * | 2020-02-13 | 2020-06-05 | 西安爱生无人机技术有限公司 | Unmanned aerial vehicle pilot dynamic behavior evaluation system |
| CN111651537A (en) * | 2020-04-29 | 2020-09-11 | 民航数据通信有限责任公司 | Method and device for making flight procedure standard diagram by data driving |
| CN112527771A (en) * | 2020-12-12 | 2021-03-19 | 江西洪都航空工业集团有限责任公司 | City management-oriented database design method |
| CN113282567A (en) * | 2021-04-02 | 2021-08-20 | 重庆交通大学 | Method, system, medium and application for analyzing unsafe behavior database of operating personnel |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115129942A (en) * | 2022-05-24 | 2022-09-30 | 湖北省计量测试技术研究院 | Method for storing metering detection data by using graph data structure |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103023970B (en) | Method and system for storing mass data of Internet of Things (IoT) | |
| CN110990585B (en) | Multi-source data and time sequence processing method and device for building industry knowledge graph | |
| CN103136249A (en) | System and method of multiplex mode isomerous data integration | |
| CN104216989A (en) | Method for storing transmission line integrated data based on HBase | |
| CN111552813A (en) | Power knowledge graph construction method based on power grid full-service data | |
| CN104536904A (en) | Data management method, equipment and system | |
| CN113179173B (en) | Operation and maintenance monitoring system for expressway system | |
| CN108009290B (en) | Data modeling and storage method for large data of rail transit command center line network | |
| CN109391629A (en) | Track traffic synthetic monitoring system data processing method | |
| CN111858713A (en) | Object-based government information asset management method and system | |
| CN114218196A (en) | Interface database design method for flight training safety | |
| CN107193994A (en) | Business decision point method for digging and its system based on mass data | |
| CN105930381A (en) | Global Argo data storage and update method based on mixed database architecture | |
| CN105205185A (en) | Data interaction and data modeling method between monitoring system and management information system | |
| CN116450620B (en) | Database design method and system for multi-source multi-domain space-time reference data | |
| CN104539895A (en) | Video layering storage system and processing method | |
| CN106056515A (en) | Community grid event cluster feature extraction method | |
| CN106202340B (en) | Database double-core storage system based on CD and the method using the system | |
| CN116089448A (en) | Real-time population management system for establishing population portraits based on multidimensional perception | |
| CN109508335B (en) | Mass ground clutter data classification storage method | |
| CN115130994A (en) | Digital city management system | |
| CN113971213A (en) | Smart city management public information sharing system | |
| CN102543108A (en) | Video redundancy strategy optimization method based on distributed storage | |
| CN112784129A (en) | Pump station equipment operation and maintenance data supervision platform | |
| CN113115069A (en) | Video storage method and system of automobile data recorder |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |