CN112214498A - Method for generating airborne maintenance configuration database - Google Patents
Method for generating airborne maintenance configuration database Download PDFInfo
- Publication number
- CN112214498A CN112214498A CN202011213016.2A CN202011213016A CN112214498A CN 112214498 A CN112214498 A CN 112214498A CN 202011213016 A CN202011213016 A CN 202011213016A CN 112214498 A CN112214498 A CN 112214498A
- Authority
- CN
- China
- Prior art keywords
- tree structure
- database
- data
- airborne
- data source
- 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.)
- Granted
Links
- 238000012423 maintenance Methods 0.000 title claims abstract description 47
- 238000000034 method Methods 0.000 title claims abstract description 26
- 238000013507 mapping Methods 0.000 claims abstract description 5
- 230000006870 function Effects 0.000 description 6
- 238000007726 management method Methods 0.000 description 4
- 238000004132 cross linking Methods 0.000 description 3
- 230000008676 import Effects 0.000 description 3
- 238000002955 isolation Methods 0.000 description 3
- 238000003745 diagnosis Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 238000007796 conventional method Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000005070 sampling Methods 0.000 description 1
- 238000013024 troubleshooting Methods 0.000 description 1
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/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
- G06F16/2246—Trees, e.g. B+trees
-
- 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
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/04—Manufacturing
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Manufacturing & Machinery (AREA)
- Software Systems (AREA)
- Economics (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Primary Health Care (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Debugging And Monitoring (AREA)
Abstract
The application provides a method for generating an onboard maintenance configuration database, which comprises the following steps: acquiring a data source file of an airplane airborne maintenance system; respectively writing the data source files into corresponding database tables according to data types to serve as initial values; according to the database table, a system tree structure, a variable tree structure and an equation tree structure are established according to the incidence relation of each data source file; acquiring parameter data in each data source file of a system tree structure, and mapping out corresponding variables of the parameter data in a variable tree structure according to the association relation; constructing a fault equation in an equation tree structure according to the corresponding variables in the variable tree structure and the logical relationship between the variables in the variable tree structure, wherein the fault equation is used for diagnosing system faults; and exporting the data information in the configured system tree structure, variable tree structure and equation tree structure to an airborne maintenance configuration database for use by each airborne function module of the airborne maintenance system.
Description
Technical Field
The invention belongs to the technical field of civil aircraft airborne maintenance systems, and particularly relates to a method for generating an airborne maintenance configuration database.
Background
The civil aircraft airborne maintenance system collects and monitors BIT data and state parameter data of aircraft systems, subsystems and member equipment by using a digital information means, maps the data into variables, constructs a fault equation through the variables and fault logic, performs fault location and fault diagnosis, implements fault isolation, and provides maintenance suggestions and reports. Because of the wide variety of airplane systems, subsystems and member devices, complex cross-linking relationship and various data types, the formed data source file has various formats (such as the formats of XML, BIN, XLS, DB, etc.).
Therefore, the conventional method for maintaining and configuring the database cannot realize the retrospective management of the data source and the parameter data; the burden of manpower is increased.
Disclosure of Invention
In order to solve the technical problem, the application provides a method for generating an airborne maintenance configuration database, which can facilitate the management of a data source; various cross-linking relationships between data sources are solved.
The application provides a method for generating an onboard maintenance configuration database, which comprises the following steps:
acquiring a data source file of an airplane airborne maintenance system, wherein the data source file comprises data source files in various formats;
respectively writing the data source files into corresponding database tables according to data types to serve as initial values;
according to the database table, a system tree structure, a variable tree structure and an equation tree structure are established according to the incidence relation of each data source file;
acquiring parameter data in each data source file of a system tree structure, and mapping out corresponding variables of the parameter data in a variable tree structure according to the association relation;
constructing a fault equation in an equation tree structure according to the corresponding variables in the variable tree structure and the logical relationship between the variables in the variable tree structure, wherein the fault equation is used for diagnosing system faults;
and exporting the data information in the configured system tree structure, variable tree structure and equation tree structure to an airborne maintenance configuration database for use by each airborne function module of the airborne maintenance system.
Preferably, after the data information is exported to the onboard maintenance configuration database, the method further comprises:
and each airborne functional module of the airborne maintenance system obtains the required data information by reading the airborne maintenance configuration database, so as to realize the function of each airborne functional module.
Preferably, the database table includes an SQL database table and an ACCESS database table.
Preferably, the onboard maintenance configuration database includes a SQLITE database and an ACCESS database.
Preferably, the database tables include an aircraft system information table, a subsystem information table, a linear replaceable unit information table, and a bus information table.
Preferably, the format of the data source file includes an XML format file, an XLS format file, a BIN format file, and an MDB format file.
Preferably, the logical relationship between the database tables is established by using the foreign key access technology in the database tables.
Preferably, the parameters on the system tree structure are compared with a preset threshold value to generate a boolean expression, and variables in the variable tree structure are formed.
In summary, the present application provides a method for generating an airborne maintenance configuration database, which supports complex data types and data structures; the data sources are uniformly managed through the tree structure of the special tool software, the specific sources and the hierarchical relation of the parameter data are determined, and the management of the data sources is facilitated; various cross-linking relations among data sources are solved; the retrospective management of data sources and parameter data is realized; the data import and data export functions of the special tool software replace a large amount of manual input operation, so that the labor burden is reduced, and the automatic labor of the machine is realized; and finally, generating an airborne maintenance configuration database for each airborne functional module of the airborne maintenance system.
Drawings
Fig. 1 is a schematic diagram of a method for generating an onboard maintenance configuration database according to the present invention.
Detailed Description
The application provides a flexible and controllable method for generating an airborne maintenance configuration database, which is used for solving the problems of importing, storing, configuring, associating, managing and exporting of a plurality of formats of data sources at the front end of civil aircraft airborne maintenance system software and finally generating an airborne configuration database file with a uniform data format. The use of the method requires specialized tool software. The user uses the data import function in the special tool software to write all the data into the SQL database table as an initial value, manages all the data sources in a layering way through the tree structure of the special tool software, and establishes the incidence relation among all the data sources. And acquiring parameter data in each data source by special tool software, mapping variables corresponding to the parameters, and constructing a fault equation according to the logic relationship among the variables. All information such as data sources, parameters, fault equations and the like is stored in the SQLITE configuration database through the export function of the tool software, each airborne functional module of the airborne maintenance system accesses a specific table in the SQLITE configuration database by using SQL language to acquire required information, the required information is used by an analysis program of the airborne functional module to carry out fault positioning and fault diagnosis, implement fault isolation and give maintenance suggestions and reports.
The invention establishes a set of flexible and controllable method for generating an airborne maintenance configuration database aiming at a civil aircraft airborne maintenance system, and a user completes configuration activities of data sources in various formats by means of special tool software and generates database files used by airborne functional software of the airborne maintenance system. As shown in fig. 1, the specific implementation of the present invention is as follows:
a. acquiring an external data source file required by an airborne maintenance system;
b. aiming at external data source files in various forms, different data import modes are selected from special tool software, different data configuration structures are established, the configuration structures comprise data sources and various parameter data (for example, the data come from a certain aircraft system, a subsystem, a linear replaceable unit, a bus, a Label and a Label domain, or come from a certain aircraft system, a subsystem, a linear replaceable unit, a message and a message domain), and the configuration data serve as important basis for use of airborne maintenance system software. Writing the configuration data into a SQLITE database;
c. setting specific attributes (including attributes belonging to a certain data source, parameter name, parameter description, parameter data type, parameter unit, parameter threshold, parameter maximum range, parameter minimum range, parameter sampling frequency, parameter use mode, trigger mode and the like) of each parameter by using special tool software, creating a tree structure of parameter membership, and solving the association relationship between parameter data;
d. mapping the parameter data into parameter variables complying with naming rules according to the parameter data types;
e. constructing a fault equation consisting of parameter variables according to the fault logic;
f. setting fault equation attributes (such as fault types, fault information, maintenance information, troubleshooting criteria, cockpit effects and the like);
g. writing the generated and configured data information into an SQLITE database which can be identified by onboard maintenance system software by utilizing a data export function of special tool software;
h. the method comprises the following steps that airborne maintenance system software accesses an SQLITE database in a specified uniform format, reads contents in the database table by using an SQL language, and applies read data information and parameter data to analysis programs of all functional modules of the airborne software;
i. according to the read fault equation and the relevant data information, a functional module in the airborne maintenance system software makes judgment, positions the fault, judges the fault and gives a fault isolation measure;
j. the onboard maintenance system software feeds the fault information back to the special tool software, and the special tool software generates fault maintenance reports in various formats.
In summary, in order to unify these various types of data information together and output the data information into a database file in the same data storage format, the invention provides a method for flexibly and controllably generating an airborne maintenance configuration database, and a configuration generation process is completed by adopting special tool software.
Claims (8)
1. A method of generating an on-board maintenance configuration database, the method comprising:
acquiring a data source file of an airplane airborne maintenance system, wherein the data source file comprises data source files in various formats;
respectively writing the data source files into corresponding database tables according to data types to serve as initial values;
according to the database table, a system tree structure, a variable tree structure and an equation tree structure are established according to the incidence relation of each data source file;
acquiring parameter data in each data source file of a system tree structure, and mapping out corresponding variables of the parameter data in a variable tree structure according to the association relation;
constructing a fault equation in an equation tree structure according to the corresponding variables in the variable tree structure and the logical relationship between the variables in the variable tree structure, wherein the fault equation is used for diagnosing system faults;
and exporting the data information in the configured system tree structure, variable tree structure and equation tree structure to an airborne maintenance configuration database for use by each airborne function module of the airborne maintenance system.
2. The method of claim 1, wherein after the data information is exported to an onboard maintenance configuration database, the method further comprises:
and each airborne functional module of the airborne maintenance system obtains the required data information by reading the airborne maintenance configuration database, so as to realize the function of each airborne functional module.
3. The method of claim 2, wherein the database table comprises a SQL database table, an ACCESS database table.
4. The method of claim 1, wherein the onboard maintenance configuration database comprises a SQLITE database and an ACCESS database.
5. The method of claim 1, wherein the database tables include an aircraft system information table, a subsystem information table, a linear replaceable unit information table, and a bus information table.
6. The method of claim 1, wherein the format of the data source file includes an XML format file, an XLS format file, a BIN format file, and an MDB format file.
7. The method of claim 1, wherein the logical relationship between database tables is established using a foreign key access technique in the database tables.
8. The method of claim 1, wherein the parameters on the system tree structure are compared to a preset threshold to generate a boolean expression to form the variables in the variable tree structure.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202011213016.2A CN112214498B (en) | 2020-11-03 | 2020-11-03 | Method for generating airborne maintenance configuration database |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202011213016.2A CN112214498B (en) | 2020-11-03 | 2020-11-03 | Method for generating airborne maintenance configuration database |
Publications (2)
Publication Number | Publication Date |
---|---|
CN112214498A true CN112214498A (en) | 2021-01-12 |
CN112214498B CN112214498B (en) | 2024-05-24 |
Family
ID=74058148
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202011213016.2A Active CN112214498B (en) | 2020-11-03 | 2020-11-03 | Method for generating airborne maintenance configuration database |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN112214498B (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112800283A (en) * | 2021-01-29 | 2021-05-14 | 重庆恒真维实医药科技有限公司 | Method for establishing medical database based on pharmacokinetics |
Citations (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH07114484A (en) * | 1993-10-19 | 1995-05-02 | Hitachi Ltd | Fault diagnosing method |
CN102646111A (en) * | 2012-02-16 | 2012-08-22 | 中国测绘科学研究院 | Knowledge base-based fast construction method of common correlation information query tree |
CN106294742A (en) * | 2016-08-10 | 2017-01-04 | 中国科学技术大学 | A kind of space launching site security reliability database construction method and analyzing and assessment system |
CN106516159A (en) * | 2016-12-09 | 2017-03-22 | 中电科航空电子有限公司 | Airborne Aircraft Communication Addressing and Reporting System (ACARS) and malfunction diagnosis and health management method thereof |
CN107301250A (en) * | 2017-07-27 | 2017-10-27 | 南京南瑞集团公司 | A kind of Various database cooperates with backup method |
CN107544462A (en) * | 2017-09-07 | 2018-01-05 | 新疆金风科技股份有限公司 | For the method and system for the failure for diagnosing wind power generating set |
CN109726244A (en) * | 2019-01-29 | 2019-05-07 | 北京中电普华信息技术有限公司 | Data lead-in method and device |
WO2019233047A1 (en) * | 2018-06-07 | 2019-12-12 | 国电南瑞科技股份有限公司 | Power grid dispatching-based operation and maintenance method |
US20200050586A1 (en) * | 2017-07-31 | 2020-02-13 | Splunk Inc. | Query execution at a remote heterogeneous data store of a data fabric service |
CN111782890A (en) * | 2020-07-07 | 2020-10-16 | 中国人民解放军陆军防化学院 | Equipment state analysis and management system |
-
2020
- 2020-11-03 CN CN202011213016.2A patent/CN112214498B/en active Active
Patent Citations (10)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH07114484A (en) * | 1993-10-19 | 1995-05-02 | Hitachi Ltd | Fault diagnosing method |
CN102646111A (en) * | 2012-02-16 | 2012-08-22 | 中国测绘科学研究院 | Knowledge base-based fast construction method of common correlation information query tree |
CN106294742A (en) * | 2016-08-10 | 2017-01-04 | 中国科学技术大学 | A kind of space launching site security reliability database construction method and analyzing and assessment system |
CN106516159A (en) * | 2016-12-09 | 2017-03-22 | 中电科航空电子有限公司 | Airborne Aircraft Communication Addressing and Reporting System (ACARS) and malfunction diagnosis and health management method thereof |
CN107301250A (en) * | 2017-07-27 | 2017-10-27 | 南京南瑞集团公司 | A kind of Various database cooperates with backup method |
US20200050586A1 (en) * | 2017-07-31 | 2020-02-13 | Splunk Inc. | Query execution at a remote heterogeneous data store of a data fabric service |
CN107544462A (en) * | 2017-09-07 | 2018-01-05 | 新疆金风科技股份有限公司 | For the method and system for the failure for diagnosing wind power generating set |
WO2019233047A1 (en) * | 2018-06-07 | 2019-12-12 | 国电南瑞科技股份有限公司 | Power grid dispatching-based operation and maintenance method |
CN109726244A (en) * | 2019-01-29 | 2019-05-07 | 北京中电普华信息技术有限公司 | Data lead-in method and device |
CN111782890A (en) * | 2020-07-07 | 2020-10-16 | 中国人民解放军陆军防化学院 | Equipment state analysis and management system |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN112800283A (en) * | 2021-01-29 | 2021-05-14 | 重庆恒真维实医药科技有限公司 | Method for establishing medical database based on pharmacokinetics |
CN112800283B (en) * | 2021-01-29 | 2023-03-14 | 重庆恒真维实医药科技有限公司 | Method for establishing medical database based on pharmacokinetics |
Also Published As
Publication number | Publication date |
---|---|
CN112214498B (en) | 2024-05-24 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107229584B (en) | I/O management system of avionic simulation test platform | |
Azeroual et al. | Data measurement in research information systems: metrics for the evaluation of data quality | |
CN109818763B (en) | Equipment fault analysis and statistics method and system and equipment real-time quality control method and system | |
CN104732311A (en) | Enterprise data management system based on unified data models | |
CN104992022A (en) | Aeronautics electronic system interface management method based on models | |
CN111078781B (en) | Multi-source flow type big data fusion convergence processing frame model implementation method | |
CN104951623A (en) | Avionics system interface management system based on models | |
CN109213132A (en) | A kind of method, device and equipment that UDS diagnostic interface software generates | |
CN108595604A (en) | A kind of data visualisation system and method for intelligent report forms | |
CN105335580A (en) | Total-system ICD collaborative design and configuration management method for airplane | |
CN114218218A (en) | Data processing method, device and equipment based on data warehouse and storage medium | |
CN112214498B (en) | Method for generating airborne maintenance configuration database | |
CN108694448A (en) | PHM platforms | |
CN113378011A (en) | Method and system for constructing complex product final assembly digital twin body | |
US9672228B2 (en) | Methods and systems for creating a complex user interface adapting a generic database software application to individually manage subset domains in complex database | |
CN106682250A (en) | Establishment method of lightweight civil aircraft model | |
CN115019595A (en) | Avionics simulation I/O management-based training simulator implementation method and system | |
CN112667606A (en) | Knowledge base system based on multi-source knowledge acquisition technology and construction method thereof | |
CN111860854B (en) | Model feature management system, model feature management method, and storage medium | |
CN112764396B (en) | Configuration method and device | |
CN112069779B (en) | Offline data acquisition and report method based on hierarchical control | |
KR20180090452A (en) | Strorage and analysis system of hla/rti interwotking data using data model conversion | |
CN117931776B (en) | Big data storage analysis system platform and method based on virtualization technology | |
CN115114268B (en) | Method, device and equipment for organizing future state twinning | |
Kiatphao et al. | Version Control on Database Schema and Test Cases from Functional Requirements’ Input Changes |
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 | ||
GR01 | Patent grant |