CN115114300A - Map database-based airworthiness regulation structured processing method - Google Patents

Map database-based airworthiness regulation structured processing method Download PDF

Info

Publication number
CN115114300A
CN115114300A CN202211044031.8A CN202211044031A CN115114300A CN 115114300 A CN115114300 A CN 115114300A CN 202211044031 A CN202211044031 A CN 202211044031A CN 115114300 A CN115114300 A CN 115114300A
Authority
CN
China
Prior art keywords
regulation
graph database
structured
data
airworthiness
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
Application number
CN202211044031.8A
Other languages
Chinese (zh)
Inventor
闫和松
叶夏竹
王兆星
王健
刘晓疆
陈晓
刘青
战嘉馨
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Qingdao Civil Aviation Cares Co ltd
Original Assignee
Qingdao Civil Aviation Cares Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Qingdao Civil Aviation Cares Co ltd filed Critical Qingdao Civil Aviation Cares Co ltd
Priority to CN202211044031.8A priority Critical patent/CN115114300A/en
Publication of CN115114300A publication Critical patent/CN115114300A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2228Indexing structures
    • G06F16/2272Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/242Query formulation
    • G06F16/2433Query languages
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/90Details of database functions independent of the retrieved data types
    • G06F16/901Indexing; Data structures therefor; Storage structures
    • G06F16/9024Graphs; Linked lists

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention relates to a graph database-based seaworthiness regulation structured processing method, which comprises the following steps of: (1) processing the structured data model of the airworthiness regulation based on the graph database; (2) storing the airworthiness regulation information as nodes, storing the relationship among the airworthiness regulation clauses as a relationship, and inquiring the data through a Cypher declarative inquiry language applied to a graph database to realize the storage and the inquiry of the data. The invention has the advantages that: the core function of the map database-based airworthiness regulation structured processing is to uniformly arrange the regulation clauses through analysis, analyze the existing rules, analyze the incidence relation among the clauses, finally provide the classification result for the user, and facilitate information collection and arrangement.

Description

Map database-based airworthiness regulation structured processing method
Technical Field
The invention relates to a map database-based navigable regulation structured processing method, and belongs to the technical field of map databases.
Background
The China civil aviation administration officially approves the AMOS construction project establishment report. The AMOS system formally enters an online trial phase in 11 months in 2020. After the AMOS system is online, in the project inspection process, a plurality of structured rules and regulations are found, no correlation exists among the rules and regulations, the rules and regulations cannot be uniformly managed, and the certificate data based on certain rules and regulations cannot be subjected to statistical analysis. How to uniformly manage the structured data of the regulations is convenient for analyzing the incidence relation among the regulations and plays an important role in the analysis and statistics of the certificate.
1) CN202010235013.2 a method and system for regulatory management: the invention provides a method and a system for managing regulations and regulations, wherein the method comprises the following steps: receiving a regulation and regulation file sent by an OA information system and manually input, and storing the regulation and regulation file after structural analysis; based on the control instruction of the user, the analysis processing functions of classified registration, retrieval query, review revision, suggestion feedback and comprehensive management of the regulation are realized according to the stored regulation files; the invention can satisfy the electronic inquiry and study of the regulation and the regulation of the whole bank workers and provide the regulation and the regulation management tool for the whole bank.
The scheme is characterized in that a method and a system for managing the regulation and the regulation are provided, so that electronic inquiry and study of the regulation and the regulation by staff of a bank can be met, and a tool for managing the regulation and the regulation is provided for the whole bank. Our solution focuses on structuring the data in the regulatory domain to manage seaworthiness.
2) CN202011251442.5 structural semantic association method and system of airworthiness regulation:
the invention discloses a seaworthiness regulation structure semantic association method and system. The method comprises the following steps: format cleaning is carried out on airworthiness regulation texts; constructing a clause hierarchical feature rule template according to the hierarchical structure features of the airworthiness regulation text after format cleaning; identifying the level of the unit clauses of the current line according to a clause level feature rule template, extracting the content of the unit clauses of the basic clauses as nodes, and distributing corresponding attribute values for each unit of the basic clauses; the attribute value is a title level; judging whether semantic join relation exists between each node pair according to an edge structure judging mechanism; and performing structure conversion on the airworthiness regulation text according to the judgment result. The invention converts the special clause structure of the airworthiness regulation into a general type natural language structure with complete semantic information and syntax structure, eliminates the adverse effect of the special clause structure of the airworthiness regulation text on the related tasks of natural language processing, and is convenient for subsequent data intelligent and automatic analysis and processing. The key point of the scheme is to provide a seaworthy regulation structure semantic association method and system. Our solution focuses on the use of graph databases to process structured data for airworthiness regulations.
3) CN201910603096.3, graph database based storage method, apparatus and storage medium:
the invention discloses a storage method based on a graph database, which comprises the following steps: acquiring an example to be stored and a relation to be stored between the examples to be stored; establishing an instance node corresponding to the instance to be stored and a relation instance node corresponding to the relation to be stored; and respectively connecting the relationship instance node with the instance nodes corresponding to the instances forming the relationship to be stored through directed line segments. The invention also discloses a storage device and a storage medium based on the graph database. When the data is stored, the relationship is also stored as the node, and when the multi-element relationship exists among the instances, only one relationship instance node needs to be set, so that the multi-element relationship is favorably stored.
4) Search result overall analysis
Analysis from the search results of existing patents and other literature, graph databases have been used in numerous fields, but do not apply graph databases to structured data processing for airworthiness regulations.
Disclosure of Invention
In order to overcome the defects of the prior art, the invention provides a map database-based airworthiness regulation structured processing method, which adopts the technical scheme that:
a graph database based navigable regulation structured processing method, comprising the steps of:
(1) processing the structured airworthiness data model based on a graph database;
(2) storing the airworthiness regulation information as nodes, storing the relationship among the airworthiness regulation clauses as a relationship, and inquiring the data through a Cypher declarative inquiry language applied to a graph database to realize the storage and the inquiry of the data.
The step (1) is specifically as follows: the graph database processes the regulatory structured data in the relational database, maps the regulatory names in the regulatory structured relational database to Neo4j for appearance as relational names, and the terms under the regulations as attribute types of relations, representing the relationships between nodes.
The step (2) is specifically as follows: the Neo4j graph database stores data as nodes and relations, stores airworthiness regulation information as nodes, stores relations among airworthiness regulation clauses as relations, and manages the nodes and the relations through a localization graph database constructed from bottom to top by the Neo4 j; the Neo4j graph database pair nodes, relations, attributes and labels are respectively stored in different storage files; in Neo4j, the components of the nodes, relationships, attributes, and tags are all accessed based on numbers inside Neo4j and are fixed-length stores.
The Cypher declarative query language is a graph database query language adopted by Neo4j, and is used for querying information related to regulations and information related to the regulations.
And carrying out graph data visualization display on the structured result of the Cypher declarative query language query, the relationship among the airworthiness structured data and the relationship among the analyzed certificates.
The invention has the advantages that: the core function of the map database-based airworthiness regulation structured processing is to uniformly arrange the regulation clauses through analysis, analyze the existing rules, analyze the incidence relation among the clauses, finally provide the classification result for the user, and facilitate information collection and arrangement.
Based on the related concept of a graph database map, the structured data model of the airworthiness regulations is processed, the structured data model of the airworthiness regulations is stored as nodes and relations, the information of the airworthiness regulations is stored as nodes, the relations among the terms of the airworthiness regulations are stored as relations, and the data is efficiently inquired and processed through a Cypher declarative inquiry language applied to the graph database, so that the data is efficiently stored, inquired and displayed. The technical core of the proposal is that in the application of a graph database to airworthiness regulation related data, the structured data of the regulation is processed, the linkage between different regulation data is realized, and better data provision is made for the certificate statistical analysis.
Drawings
FIG. 1 is a schematic flow diagram of the present invention.
Detailed Description
The invention will be further described with reference to specific embodiments, and the advantages and features of the invention will become apparent as the description proceeds. These examples are illustrative only and do not limit the scope of the present invention in any way. It will be understood by those skilled in the art that various changes in form and details may be made therein without departing from the spirit and scope of the invention, and that such changes and modifications may be made without departing from the spirit and scope of the invention.
Referring to fig. 1, the present invention relates to a graph database-based navigable regulation structured processing method, comprising the steps of:
(1) processing the structured airworthiness data model based on a graph database;
(2) storing the airworthiness regulation information as nodes, storing the relationship among the airworthiness regulation clauses as a relationship, and inquiring the data through a Cypher declarative inquiry language applied to a graph database to realize the storage and the inquiry of the data.
The step (1) is specifically as follows: the graph database processes the regulatory structured data in the relational database, maps the regulatory names in the regulatory structured relational database to Neo4j for appearance as relational names, and the terms under the regulations as attribute types of relations, representing the relationships between nodes. Among them, Neo4j supports large data sets and can continuously expand its capacity, Neo4j is high performance; the expressive force of the declarative graph query language is rich, the query efficiency is high, colleagues have good expansibility, and a user can customize a query mode; neo4j provides true data security through ACID transactions, uses transactions to ensure that data is not lost in a hardware failure or system crash, etc.
The step (2) is specifically as follows: the Neo4j graph database stores data as nodes and relations, stores airworthiness regulation information as nodes, stores relations among airworthiness regulation clauses as relations, and manages the nodes and the relations through a localization graph database constructed from bottom to top by the Neo4 j; the Neo4j graph database pair nodes, relations, attributes and labels are respectively stored in different storage files; in Neo4j, the components of the nodes, relationships, attributes, and tags are all accessed based on numbers inside Neo4j and are fixed-length stores.
The Cypher declarative query language is a graph database query language adopted by Neo4j, and is used for querying information related to regulations and information related to the regulations.
And carrying out graph data visualization display on the structured result of the Cypher declarative query language query, the relationship among the airworthiness structured data and the relationship among the analyzed certificates. And the visualization of the graph data uses technologies such as SpringBoot, Vue and the like, and provides a set of simple, stable and efficient operation interface for a user through a load balancing and micro-service deployment mode. The user can clearly display the relationship between the structured result and the airworthiness structured data inquired by the Cypher declarative query language and the relationship between the analyzed certificates more conveniently, and subsequent analysis statistics is facilitated.
Among them, the Cypher declarative query language is a simple and expressive language that programmatically describes graph structures in an accurate manner. And performing addition, deletion, check and modification (CRUD) operation on the graphic data through Cypher.
Neo4j data modeling example:
the mode of graph database modeling is flexible, the model does not need further abstraction, and is more fit for real object relations, so that the method is more suitable for iterative and incremental development modes. New elements are added into the model to meet new requirements, and the addition of new objects and connection relations into the model does not affect the existing data model, model and constraint and has strong plasticity.
The data modeling of the graph database describes specific things and relations among the things, nodes in the graph database model correspond to specific things examples, and the labels are used for representing clustering and abstraction of the things examples and are selective and have high expandability and flexibility. Table 1 is a correspondence table of element names and modeling functions.
Figure DEST_PATH_IMAGE002
The Cypher query language is a graph database query language adopted by Neo4 j. Cypher is a compact and expressive language that programmatically describes graph structures in an accurate manner. Neo4j performs an add, delete, modify (CRUD) operation on the graphics data using Cypher. In the search function, Cypher language is composed of four parts of start, match, where and return:
and (3) start: one or more initial nodes are appointed in the graph and can be obtained through index searching or directly obtained through the serial numbers of the nodes;
match: the matching pattern of the graph is also a requirement part of instantiation;
where: providing a condition for filtering the pattern matching result;
return: to indicate which nodes, relationships and attributes are required to be returned to the client in the data that has matched the query.
For example, in Neo4j graph databases, the relationship between "flight" and "structure" can be directly obtained using query statements. The query sentence is: MATCH (a: { Name: "flight" }), (b: { Detail: "structure" }) return (a) - [ ] - > (b); all shortest paths can also be obtained directly using allshortestPaths, i.e. MATCH n = allshortestPaths ((a: { Name: "flight" }) - [ - (b: { Detail: "structure" })) return n, etc.
The structured data of the airworthiness regulations are uniformly managed on the basis of a graph database, the regulations and the clauses are stored as graph database nodes, the relation among the clauses is stored as a relation, the existing rules of the relation are analyzed, the incidence relation among the clauses is analyzed, the classification result is finally provided for a user, and the structured data of the airworthiness regulations play an important role in analysis and statistics of certificates; the Cypher declarative query language of the graph data is used for querying relevant information of the regulations and the mutual correlation information among the regulations, so that a foundation is laid for deep research of airworthiness regulations.
The above description is only for the preferred embodiment of the present invention, but the scope of the present invention is not limited thereto, and any person skilled in the art should be considered to be within the technical scope of the present invention, and the technical solutions and the inventive concepts thereof according to the present invention should be equivalent or changed within the scope of the present invention.

Claims (5)

1. A graph database-based navigable regulation structured processing method is characterized by comprising the following steps:
(1) processing the structured airworthiness data model based on a graph database;
(2) storing the airworthiness regulation information as nodes, storing the relationship among the airworthiness regulation clauses as a relationship, and inquiring the data through a Cypher declarative inquiry language applied to a graph database to realize the storage and the inquiry of the data.
2. The graph database-based navigable regulation structured processing method according to claim 1, wherein step (1) is embodied as: the graph database processes the regulatory structured data in the relational database, maps the regulatory names in the regulatory structured relational database to Neo4j for appearance as relational names, and the terms under the regulations as attribute types of relations, representing the relationships between nodes.
3. The graph database-based navigable regulation structured processing method according to claim 2, wherein step (2) is embodied as: the Neo4j graph database stores data as nodes and relations, stores airworthiness regulation information as nodes, stores relations among airworthiness regulation clauses as relations, and manages the nodes and the relations through a localization graph database constructed from bottom to top by the Neo4 j; the Neo4j graph database pair nodes, relations, attributes and labels are respectively stored in different storage files; in Neo4j, the components of the nodes, relationships, attributes, and tags are all accessed based on numbers inside Neo4j and are fixed-length stores.
4. The graph database-based navigable regulation structured processing method according to claim 2 or 3, wherein the Cypher declarative query language is a graph database query language adopted by Neo4j, and the Cypher declarative query language is used for querying regulation-related information and inter-regulation correlation information.
5. The method according to claim 2 or 3, wherein said Cypher declarative query language query is used to visually display the graph data of the structured result, the relationship between the navigable structured data and the relationship between the analyzed documents.
CN202211044031.8A 2022-08-30 2022-08-30 Map database-based airworthiness regulation structured processing method Pending CN115114300A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202211044031.8A CN115114300A (en) 2022-08-30 2022-08-30 Map database-based airworthiness regulation structured processing method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202211044031.8A CN115114300A (en) 2022-08-30 2022-08-30 Map database-based airworthiness regulation structured processing method

Publications (1)

Publication Number Publication Date
CN115114300A true CN115114300A (en) 2022-09-27

Family

ID=83336507

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202211044031.8A Pending CN115114300A (en) 2022-08-30 2022-08-30 Map database-based airworthiness regulation structured processing method

Country Status (1)

Country Link
CN (1) CN115114300A (en)

Citations (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20140278590A1 (en) * 2013-03-13 2014-09-18 Airline Tariff Publishing Company System, method and computer program product for providing a fare analytic engine
KR101525529B1 (en) * 2014-09-30 2015-06-05 주식회사 비트나인 data processing apparatus and data mapping method thereof
CN106528757A (en) * 2016-11-03 2017-03-22 北京中安智达科技有限公司 Big data-oriented relation analysis display method
CN107545019A (en) * 2017-03-02 2018-01-05 微云数聚(北京)科技有限公司 A kind of method for visualizing and system of chart database data-driven
CN109871415A (en) * 2019-01-21 2019-06-11 武汉光谷信息技术股份有限公司 A kind of user's portrait construction method, system and storage medium based on chart database
CN110209826A (en) * 2018-02-06 2019-09-06 武汉观图信息科技有限公司 A kind of financial map construction and analysis method towards bank risk control
CN111353762A (en) * 2020-03-30 2020-06-30 中国建设银行股份有限公司 Method and system for managing regulations and regulations
CN114020852A (en) * 2021-09-29 2022-02-08 苏州臻璇数据信息技术有限公司 Knowledge graph display method and device
US20220092116A1 (en) * 2020-09-23 2022-03-24 Citrix Systems, Inc. Automatic graph database query construction and execution
CN114819207A (en) * 2022-03-22 2022-07-29 中国民航科学技术研究院 Data evidence-based aircraft continuous airworthiness auxiliary management system and method

Patent Citations (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20140278590A1 (en) * 2013-03-13 2014-09-18 Airline Tariff Publishing Company System, method and computer program product for providing a fare analytic engine
KR101525529B1 (en) * 2014-09-30 2015-06-05 주식회사 비트나인 data processing apparatus and data mapping method thereof
CN106528757A (en) * 2016-11-03 2017-03-22 北京中安智达科技有限公司 Big data-oriented relation analysis display method
CN107545019A (en) * 2017-03-02 2018-01-05 微云数聚(北京)科技有限公司 A kind of method for visualizing and system of chart database data-driven
CN110209826A (en) * 2018-02-06 2019-09-06 武汉观图信息科技有限公司 A kind of financial map construction and analysis method towards bank risk control
CN109871415A (en) * 2019-01-21 2019-06-11 武汉光谷信息技术股份有限公司 A kind of user's portrait construction method, system and storage medium based on chart database
CN111353762A (en) * 2020-03-30 2020-06-30 中国建设银行股份有限公司 Method and system for managing regulations and regulations
US20220092116A1 (en) * 2020-09-23 2022-03-24 Citrix Systems, Inc. Automatic graph database query construction and execution
CN114020852A (en) * 2021-09-29 2022-02-08 苏州臻璇数据信息技术有限公司 Knowledge graph display method and device
CN114819207A (en) * 2022-03-22 2022-07-29 中国民航科学技术研究院 Data evidence-based aircraft continuous airworthiness auxiliary management system and method

Similar Documents

Publication Publication Date Title
CN103631882B (en) Semantization service generation system and method based on graph mining technique
CN108446368A (en) A kind of construction method and equipment of Packaging Industry big data knowledge mapping
CN110019555B (en) Relation data semantical modeling method
JP2002297602A (en) Method and device for structured document retrieval, structured document managing device, program, and recording medium
CN108664599A (en) Intelligent answer method, apparatus, intelligent answer server and storage medium
CN103425740A (en) IOT (Internet Of Things) faced material information retrieval method based on semantic clustering
CN115438199A (en) Knowledge platform system based on smart city scene data middling platform technology
Sheng et al. CEPV: A tree structure information extraction and visualization tool for big knowledge graph
CN116450908B (en) Self-service data analysis method and device based on data lake and electronic equipment
CN115934969A (en) Construction method of immovable cultural relic risk assessment knowledge graph
CN116467291A (en) Knowledge graph storage and search method and system
CN112668836B (en) Risk spectrum-oriented associated risk evidence efficient mining and monitoring method and apparatus
CN115114300A (en) Map database-based airworthiness regulation structured processing method
Bouhissi et al. Toward Data Integration in the Era of Big Data: Role of Ontologies
CN115827885A (en) Operation and maintenance knowledge graph construction method and device and electronic equipment
Elamin et al. Toward an Ontology Based Approach for Data Warehousing
CN112488642B (en) Cloud file management method based on structured labels and taking object as core
CN108595588A (en) A kind of science data storage correlating method
CN106649219A (en) Automatic generation method for communication satellite design documents
Gujral et al. Knowledge Graphs: Connecting Information over the Semantic Web
JP2002297601A (en) Method and device for structured document management, and program
Martinez-Cruz et al. An ontology to represent queries in fuzzy relational databases
JP3842574B2 (en) Information extraction method, structured document management apparatus and program
Leshcheva et al. Towards a method of ontology population from heterogeneous sources of structured data
Liu et al. Complex event processing for sequence data and domain knowledge

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
RJ01 Rejection of invention patent application after publication

Application publication date: 20220927

RJ01 Rejection of invention patent application after publication