CN115357671B - Method, device, equipment and medium for constructing aircraft assembly data - Google Patents
Method, device, equipment and medium for constructing aircraft assembly data Download PDFInfo
- Publication number
- CN115357671B CN115357671B CN202211279787.0A CN202211279787A CN115357671B CN 115357671 B CN115357671 B CN 115357671B CN 202211279787 A CN202211279787 A CN 202211279787A CN 115357671 B CN115357671 B CN 115357671B
- Authority
- CN
- China
- Prior art keywords
- data
- target
- layer
- node
- assembly
- 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.)
- Active
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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
-
- 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/26—Visual data mining; Browsing structured data
-
- 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
Abstract
The invention discloses a method, a device, equipment and a medium for constructing aircraft assembly data, which are used for a data center station, wherein the data center station is in communication connection with a production management system and a plurality of databases, the data center station comprises a materialized view, the materialized view comprises synchronous BOM structure data and assembly data, and the materialized view also comprises the corresponding relation between bottom-layer nodes and the assembly data in the BOM structure data; the method comprises the following steps: receiving target assembly information of an airplane to be assembled; determining a target top node in the materialized view according to the target assembly information; according to the tree structure in the BOM structure data and the target assembly information, taking the target top-level node as a starting point, and performing recursive query to obtain a target bottom-level node; and obtaining target assembly data according to the target bottom layer nodes and the corresponding relation. The method and the device can improve the construction speed of the aircraft assembly data and improve the production efficiency.
Description
Technical Field
The application relates to the field of airplane digital manufacturing, in particular to a method, a device, equipment and a medium for constructing airplane assembly data.
Background
In the aircraft manufacturing process, whether manufacturing meets design requirements is a very important technical state control process, and process design data, manufacturing plans and material data need to be called and combined into installed material data to carry out aircraft manufacturing. Generally, process design data is in a PDM system, and planning, material, inventory and other data related to a manufacturing process are respectively stored in different systems.
Disclosure of Invention
The application mainly aims to provide a method, a device, equipment and a medium for constructing aircraft assembly data, and aims to solve the technical problem that the existing aircraft assembly data construction method is low in generation efficiency.
In order to solve the technical problem, the application provides: an aircraft assembly data construction method is used for a data center station, the data center station is in communication connection with a production management system and a plurality of databases, BOM structure data are stored in the production management system, the BOM structure data comprise a plurality of top-level nodes, the top-level nodes are associated with bottom-level nodes, aircraft assembly information is stored in the top-level nodes, and assembly data required by aircraft assembly are stored in the databases respectively; the data middle stage comprises a materialized view, the materialized view comprises synchronous BOM structure data and assembly data, and the materialized view also comprises a corresponding relation between bottom-layer nodes and the assembly data in the BOM structure data; the method comprises the following steps:
receiving target assembly information of an airplane to be assembled;
determining a target top node in the materialized view according to the target assembly information;
and performing recursive query by taking the target top-level node as a starting point according to the tree structure and the target assembly information in the BOM structure data to obtain a target bottom-level node.
As some optional embodiments of the present application, the top level node is associated with a component layer, the component layer is associated with a level layer, the level layer is associated with a first configuration item layer, the first configuration item layer is associated with a second configuration item layer, the second configuration item layer includes a bottom level node, each layer associated with the top level node is stored in a different table, and a table corresponding to each layer also stores a parent-child relationship with a next layer.
As some optional embodiments of the present application, the target assembly information includes a node parameter, and the step of determining a target top-level node in the materialized view according to the target assembly information includes:
and determining a target top-level node in the materialized view according to the node parameter.
As some optional embodiments of the present application, the target assembly information further includes a rank parameter and a model parameter, and the step of performing recursive query with the target top-level node as a starting point according to the tree structure in the BOM structure data and the target assembly information to obtain the target bottom-level node includes:
performing recursive query by taking the target top-level node as a starting point according to the ranking parameter and the model parameter to obtain a bottom-level node of a target tree structure;
and acquiring target assembly data according to the incidence relation and the bottom node of the target tree structure.
As some optional embodiments of the present application, performing recursive query with the target top-level node as a starting point according to the ranking parameter and the model parameter to obtain a bottom-level node of a target tree structure includes:
merging tables corresponding to each layer associated with the target top-level node to obtain a temporary view;
and performing recursive query on the temporary view according to the model parameters, the frame parameters and the parent-child relationship to obtain a target tree structure.
As some optional embodiments of the present application, before the receiving target assembly information of the aircraft to be assembled, the method further comprises:
and refreshing the materialized view according to a preset time interval.
In order to solve the technical problem, the application further provides: an aircraft assembly data construction device is used for a data center station, the data center station is in communication connection with a production management system and a plurality of databases, BOM structure data is stored in the production management system, the BOM structure data comprises a plurality of top-level nodes, the top-level nodes are associated with bottom-level nodes, aircraft assembly information is stored in the top-level nodes, and assembly data required by aircraft assembly are stored in the plurality of databases respectively; the data middle stage comprises a materialized view, the materialized view comprises synchronous BOM structure data and assembly data, and the materialized view also comprises a corresponding relation between bottom-layer nodes and the assembly data in the BOM structure data; the device comprises:
the receiving module is used for receiving target assembly information of the airplane to be assembled;
the determining module is used for determining a target top node in the materialized view according to the target assembly information;
the query module performs recursive query by taking the target top-layer node as a starting point according to the tree structure and the target assembly information in the BOM structure data to obtain a target bottom-layer node;
and the acquisition module acquires target assembly data according to the target bottom layer node and the corresponding relation.
As some optional embodiments of the present application, the top level node is associated with a component layer, the component layer is associated with a level layer, the level layer is associated with a first configuration item layer, the first configuration item layer is associated with a second configuration item layer, the second configuration item layer includes a bottom level node, each layer associated with the top level node is stored in a different table, and a table corresponding to each layer also stores a parent-child relationship with a next layer.
In order to solve the technical problem, the application further provides: an electronic device, comprising: at least one processor, at least one memory, and computer program instructions stored in the memory which, when executed by the processor, implement the method as described above.
In order to solve the technical problem, the application further provides: a storage medium having stored thereon computer program instructions which, when executed by a processor, implement a method as described above.
In conclusion, the beneficial effects of the invention are as follows:
the application provides an aircraft assembly data construction method, which is used for a data center station, wherein the data center station is in communication connection with a production management system and a plurality of databases, BOM structure data are stored in the production management system, the BOM structure data comprise a plurality of top-level nodes, the top-level nodes are associated with bottom-level nodes, aircraft assembly information is stored in the top-level nodes, and assembly data required by aircraft assembly are respectively stored in the databases; the data middle stage comprises a materialized view, the materialized view comprises synchronous BOM structure data and assembly data, and the materialized view also comprises a corresponding relation between bottom-layer nodes and the assembly data in the BOM structure data; the method comprises the following steps: receiving target assembly information of an airplane to be assembled; determining a target top node in the materialized view according to the target assembly information, wherein the target top node can be accurately obtained through target matching information due to the fact that the BOM structural data comprises a plurality of top nodes; according to the tree structure and the target assembly information in the BOM structure data, taking the target top node as a starting point, performing recursive query to obtain a target bottom node, and performing recursive query on a data intermediate stage to traverse the tree structure in the BOM node and quickly obtain the target bottom node; and obtaining target assembly data according to the target bottom layer node and the corresponding relation. Therefore, on one hand, the data consistency of the data center and the data of each service system is ensured by arranging the localized materialized view in the data center, the data can be directly acquired from the materialized view during data construction, the phenomenon that the data is intensively inquired from each database during data construction to cause centralized occupation of network bandwidth is avoided, the acquisition efficiency of assembly data is improved, and the construction efficiency is further improved; on the other hand, recursive query is carried out based on the BOM structure and the corresponding relation established in advance in the construction process, the acquisition efficiency of the assembly data can be further improved, and the construction efficiency is further improved.
Drawings
FIG. 1 is a schematic flow chart diagram illustrating a method for constructing aircraft assembly data according to an embodiment of the present application;
FIG. 2 is a diagram illustrating a tree structure in BOM structure data according to an embodiment of the present disclosure;
FIG. 3 is a schematic structural diagram of an aircraft assembly data construction apparatus according to an embodiment of the present application;
FIG. 4 is a schematic diagram of an electronic device according to an embodiment of the present application;
the implementation, functional features and advantages of the objectives of the present application will be further explained with reference to the accompanying drawings.
Detailed Description
Features and exemplary embodiments of various aspects of the present invention will be described in detail below, and in order to make objects, technical solutions and advantages of the present invention more apparent, the present invention will be further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not to be construed as limiting the invention. It will be apparent to one skilled in the art that the present invention may be practiced without some of these specific details. The following description of the embodiments is merely intended to provide a better understanding of the present invention by illustrating examples of the present invention.
It is noted that, herein, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising … …" does not exclude the presence of another like element in a process, method, article, or apparatus that comprises the element.
In aircraft manufacturing, whether manufacturing meets design requirements is a very important state-of-the-art control process. Generally, process design data is in a PDM system, planning, material, inventory and other data related to a manufacturing process are stored in an enterprise ERP system and an MES system, and mutual isolation of databases causes low data query efficiency and low real-time performance, so that the latest installed data cannot be obtained when state cleaning is required, and the state cleaning result is influenced, thereby causing serious consequences.
In order to solve the above technical problem, as shown in fig. 1, the present application proposes: an aircraft assembly data construction method is used for a data center station, the data center station is in communication connection with a production management system and a plurality of databases, BOM structure data are stored in the production management system, the BOM structure data comprise a plurality of top-level nodes, the top-level nodes are associated with bottom-level nodes, aircraft assembly information is stored in the top-level nodes, and assembly data required by aircraft assembly are stored in the databases respectively; the data middle stage comprises a materialized view, the materialized view comprises synchronous BOM structure data and assembly data, and the materialized view also comprises a corresponding relation between bottom-layer nodes and the assembly data in the BOM structure data;
specifically, the data center platform is a data management system, which is constructed for data mining, the most important aim is to support all department business data and provide computing services, the essence of the data center platform is 'data warehouse + data service middleware', a plurality of systems can be connected together through the data center platform, and the data center platform comprises a materialized view, wherein the materialized view is a database object comprising a query result, which is a local copy of remote data or is used for generating a summary table based on summation of data tables. The materialized view stores data based on a remote table, which can also be called as a snapshot, through the materialized view, the data consistency of a data middle station and each business system data is ensured by setting a localized materialized view in the data middle station, the data can be directly obtained from the materialized view when the data is constructed, the network bandwidth spent by inquiring data in each database through a DBLink is avoided, the centralized occupation of the network bandwidth is caused, the obtaining efficiency of assembly data is improved, and the construction efficiency is further improved, the assembly data required by organic assembly is stored in the database, wherein the assembly data comprises but is not limited to production process plan data, stock data, material data, manufacturing execution data and the like; the BOM structure data, namely the bill of material structure data, is a product information management method based on a product decomposition structure, the method divides a product into objects of different levels according to an assembly process, a function or other business logics and assigns corresponding numbers, then organizes the numbered objects according to a tree structure so as to carry out management operations such as searching, updating, deleting and the like, the BOM structure data comprises a plurality of top-level nodes, the top-level nodes store aircraft assembly information, the materialized view also comprises a corresponding relation between bottom-level nodes and the assembly data in the BOM structure data, and the assembly data and the BOM structure data can be organized through the corresponding relation to obtain target assembly data, so that the acquisition efficiency of the assembly data is improved;
the method comprises the following steps:
s1, receiving target assembly information of an airplane to be assembled;
specifically, the assembly states of each aircraft to be assembled are different, so that the corresponding target assembly information is different, for example, if the aircraft parts required by the aircraft to be assembled include skins, wing main boxes, flaps and spoilers, and if the production process planning data, the stock data, the material data and the manufacturing execution data of different aircraft parts are different, the corresponding target assembly information needs to be acquired according to the aircraft parts required by the aircraft to be assembled, so as to facilitate acquisition of the subsequent aircraft assembly data.
S2, determining a target top node in the materialized view according to the target assembly information;
specifically, a target top node in the materialized view is determined according to the target assembly information, the materialized view comprises BOM structure data which comprises a plurality of top nodes by determining the target top node, and the subsequent downward recursive query according to the top nodes can be facilitated by determining the target top node;
as some optional embodiments of the present application, as shown in fig. 2, a BOM structure is an organization structure of materials and is a tree structure relationship, where the BOM structure data includes a plurality of top nodes, the top nodes are associated with component layers, the component layers are associated with segment layers, the segment layers are associated with first configuration item layers, the first configuration item layers are associated with second configuration item layers, the second configuration item layers include bottom nodes, each layer associated with the top nodes is stored in a different table, and the table corresponding to each layer further stores a parent-child relationship with the next layer, and as the table corresponding to each layer further stores a parent-child relationship with the next layer, through the parent-child relationship, when performing recursive query, the next layer of the current layer can be quickly determined according to the parent-child relationship, and the BOM structure data is queried from top to bottom, so as to generate a target tree structure, thereby enhancing acquisition efficiency of assembly data, and further enhancing construction efficiency;
in a specific embodiment, the bottom-layer node is an AO node, the AO is a manufacturing outline of the part, the manufacturing outline is a production basis of the part in each section, wherein parameters necessary for completing production of the part, such as a production section, a material grade, a process flow, production equipment and the like in a part manufacturing process, are specified, the assembly data comprises an AO number, an assembly material is matched according to the AO, and the BOM structure data can be associated with the assembly data through the AO node and the AO number.
As some optional embodiments of the present application, the target assembly information includes node parameters, and the step of determining a target top-level node in the materialized view according to the target assembly information includes:
and S21, determining a target top-level node in the materialized view according to the node parameter.
Specifically, in this embodiment, the target assembly information includes node parameters, the node parameters correspond to top nodes in the BOM structure data, and the top nodes can be quickly and accurately determined through the node parameters, so that the tree structure of the BOM structure data is recursively queried according to the top nodes in the following.
S3, performing recursive query by taking the target top-level node as a starting point according to the tree structure and the target assembly information in the BOM structure data to obtain a target bottom-level node;
specifically, according to the target assembly information, the target top-level node is taken as a starting point, recursive query is performed on the tree structure corresponding to the target top-level node from top to bottom until a bottom-level node of the corresponding tree structure is obtained, and due to the fact that the association relation between the bottom-level node and the assembly data is stored in the materialized view, the acquisition efficiency of the assembly data can be further improved by confirming the target bottom-level node and the corresponding relation established in advance in the construction process, and therefore the construction efficiency is further improved.
As some optional embodiments of the present application, the target assembly information further includes a rank parameter and a model parameter, and the step of performing recursive query with the target top-level node as a starting point according to the tree structure in the BOM structure data and the target assembly information to obtain the target bottom-level node includes:
s31, performing recursive query by taking the target top-level node as a starting point according to the ranking parameter and the model parameter to obtain a bottom-level node of a target tree structure;
specifically, the target assembly information further comprises rack-level information and model parameters, and because assembly data of the physical assembly machine needs to be organized according to the rack level, the model parameters and the rack-level parameters need to be received, so that the constructed assembly data correspond to the current airplane to be assembled, and the accuracy of the target assembly data is improved; the BOM node parameters are obtained for confirming the top-level node in the BOM structure data and improving the confirming efficiency of the top-level node, and the bottom-level node of the BOM data structure can be obtained according to downward recursive inquiry of the node, so that the obtaining efficiency of the assembly data is improved.
As some optional embodiments of the present application, performing recursive query with the target top-level node as a starting point according to the ranking parameter and the model parameter to obtain a bottom-level node of a target tree structure includes:
s311, combining the tables corresponding to each layer associated with the target top-level node to obtain a temporary view;
specifically, a plurality of layers are associated with the top node in the BOM structure data, each layer is stored in a different table, and the tables corresponding to each layer associated with the target top node are combined, so that resource waste caused by query from different tables is avoided, the efficiency of subsequent recursive query is improved, and the acquisition efficiency of target assembly data is improved.
In a specific embodiment, the table corresponding to each layer associated with the target top-level node is merged by UNION ALL, UNION ALL and UNION are different in that UNION does not remove duplicate records, only a plurality of results are merged and then returned, UNION filters duplicate records after table understanding, and sorts the records according to the sequence of fields, and each layer associated with the top-level node has different data and does not need to be filtered, deduplicated and sorted, so that the efficiency of recursive query can be improved by UNION, and the acquisition efficiency of assembly data is further improved.
S312, performing recursive query on the temporary view according to the model parameters, the frame parameters and the parent-child relationship to obtain a target tree structure.
Specifically, since the table records the parent-child relationship between the used hierarchy and the next hierarchy, the tree structure can be rapidly recursively queried through the parent-child relationship to obtain the target tree structure, in a specific embodiment, the recursive query is performed through a connect by prior in Oracle, a connect by statement is to integrate and display the data in the table in the form of a tree in a recursive manner, where a start with is used to designate a certain number of root nodes, if a start with a conditional hierarchy statement is not designated, each record is sequentially regarded as a root node to generate a corresponding tree for display, and the temporary view can be recursively queried through the connect by prior to obtain the target tree structure,
and S4, obtaining target assembly data according to the target bottom layer nodes and the corresponding relation.
Specifically, after the target tree structure is obtained, a bottom node of the target tree structure can be determined, a correlation relationship exists between the bottom node of the tree structure and the assembly data, and the target assembly data can be obtained through the correlation relationship.
As some optional embodiments of the present application, before the receiving target assembly information of the aircraft to be assembled, the method further comprises:
s01: and refreshing the materialized view according to a preset time interval.
Specifically, the materialized view is refreshed according to a preset time interval, consistency of data of the materialized view in the data center station and data in a database of each system can be guaranteed, and the situation that data errors occur due to untimely updating is avoided, wherein the preset time interval can be set according to user requirements and actual scenes, and is not limited specifically.
In summary, the present application provides an aircraft assembly data construction method, which is used for a data center station, where the data center station is communicatively connected with a production management system and a plurality of databases, the production management system stores BOM structure data, the BOM structure data includes a plurality of top-level nodes, the top-level nodes are associated with bottom-level nodes, the top-level nodes store aircraft assembly information, and the databases respectively store assembly data required for aircraft assembly; the data middle stage comprises a materialized view, the materialized view comprises synchronous BOM structure data and assembly data, and the materialized view also comprises a corresponding relation between bottom-layer nodes and the assembly data in the BOM structure data; the method comprises the following steps: receiving target assembly information of an airplane to be assembled; determining a target top node in the materialized view according to the target assembly information, wherein the target top node can be accurately obtained through target matching information due to the fact that the BOM structural data comprises a plurality of top nodes; performing recursive query by taking the target top-level node as a starting point according to the tree structure and the target assembly information in the BOM structure data to obtain a target bottom-level node, and traversing the tree structure in the BOM node by performing the recursive query in a data middle stage to quickly obtain the target bottom-level node; and obtaining target assembly data according to the target bottom layer node and the corresponding relation. Therefore, on one hand, the data consistency of the data center and the data of each service system is ensured by arranging the localized materialized view in the data center, the data can be directly acquired from the materialized view during data construction, the phenomenon that the data is intensively inquired from each database during data construction to cause centralized occupation of network bandwidth is avoided, the acquisition efficiency of assembly data is improved, and the construction efficiency is further improved; on the other hand, recursive query is carried out based on the BOM structure and the corresponding relation established in advance in the construction process, the acquisition efficiency of the assembly data can be further improved, and the construction efficiency is further improved.
In order to solve the above technical problem, as shown in fig. 3, the present application further proposes: an aircraft assembly data construction device is used for a data center station, wherein the data center station is in communication connection with a production management system and a plurality of databases, BOM structure data are stored in the production management system, the BOM structure data comprise a plurality of top-level nodes, the top-level nodes are associated with bottom-level nodes, aircraft assembly information is stored in the top-level nodes, and assembly data required by aircraft assembly are respectively stored in the plurality of databases; the data middle stage comprises a materialized view, the materialized view comprises synchronous BOM structure data and assembly data, and the materialized view also comprises a corresponding relation between bottom-layer nodes and the assembly data in the BOM structure data; the device comprises:
the receiving module is used for receiving target assembly information of the airplane to be assembled;
the determining module is used for determining a target top node in the materialized view according to the target assembly information;
the query module performs recursive query by taking the target top-layer node as a starting point according to the tree structure and the target assembly information in the BOM structure data to obtain a target bottom-layer node;
and the acquisition module acquires target assembly data according to the target bottom layer node and the corresponding relation.
As some optional embodiments of the present application, the top level node is associated with a component layer, the component layer is associated with a level layer, the level layer is associated with a first configuration item layer, the first configuration item layer is associated with a second configuration item layer, the second configuration item layer includes a bottom level node, each layer associated with the top level node is stored in a different table, and a table corresponding to each layer also stores a parent-child relationship with a next layer.
It should be noted that, each module in the aircraft assembly data construction apparatus in this embodiment corresponds to each step in the aircraft assembly data construction method in the foregoing embodiment one to one, and therefore, the specific implementation and the achieved technical effect of this embodiment may refer to the implementation of the foregoing compilation method, and are not described here again.
In addition, an aircraft assembly data construction method according to the embodiment of the invention described in conjunction with fig. 1 may be implemented by an electronic device. Fig. 4 shows a hardware structure diagram of an electronic device provided by an embodiment of the present invention.
The electronic device may comprise at least one processor 301, at least one memory 302, and computer program instructions stored in the memory 302 that, when executed by the processor 301, implement the methods of the above-described embodiments.
In particular, the processor 301 may include a Central Processing Unit (CPU), or an Application Specific Integrated Circuit (ASIC), or may be configured as one or more Integrated circuits implementing embodiments of the present invention.
The processor 301 reads and executes the computer program instructions stored in the memory 302 to implement any one of the aircraft assembly data construction methods in the above-described embodiments.
In one example, the electronic device may also include a communication interface and a bus. As shown in fig. 4, the processor 301, the memory 302, and the communication interface 303 are connected via a bus 310 to complete communication therebetween. The communication interface is mainly used for realizing communication among modules, devices, units and/or equipment in the embodiment of the invention.
A bus comprises hardware, software, or both that couple components of an electronic device to one another. By way of example, and not limitation, a bus may include an Accelerated Graphics Port (AGP) or other graphics bus, an Enhanced Industry Standard Architecture (EISA) bus, a Front Side Bus (FSB), a Hypertransport (HT) interconnect, an Industry Standard Architecture (ISA) bus, an infiniband interconnect, a Low Pin Count (LPC) bus, a memory bus, a Micro Channel Architecture (MCA) bus, a Peripheral Component Interconnect (PCI) bus, a PCI-Express (PCI-X) bus, a Serial Advanced Technology Attachment (SATA) bus, a video electronics standards association local (VLB) bus, or other suitable bus or a combination of two or more of these. A bus may include one or more buses, where appropriate. Although specific buses have been described and shown in the embodiments of the invention, any suitable buses or interconnects are contemplated by the invention.
In addition, in combination with the aircraft assembly data construction method in the above embodiment, the embodiment of the present invention may be implemented by providing a computer-readable storage medium. The computer readable storage medium having stored thereon computer program instructions; the computer program instructions, when executed by a processor, implement any of the aircraft assembly data construction methods of the embodiments described above.
It is to be understood that the invention is not limited to the specific arrangements and instrumentality described above and shown in the drawings. A detailed description of known methods is omitted herein for the sake of brevity. In the above embodiments, several specific steps are described and shown as examples. However, the method processes of the present invention are not limited to the specific steps described and illustrated, and those skilled in the art can make various changes, modifications and additions or change the order between the steps after comprehending the spirit of the present invention.
The functional blocks shown in the above-described structural block diagrams may be implemented as hardware, software, firmware, or a combination thereof. When implemented in hardware, it may be, for example, an electronic circuit, an Application Specific Integrated Circuit (ASIC), suitable firmware, plug-in, function card, or the like. When implemented in software, the elements of the invention are the programs or code segments used to perform the required tasks. The program or code segments may be stored in a machine-readable medium or transmitted by a data signal carried in a carrier wave over a transmission medium or a communication link. A "machine-readable medium" may include any medium that can store or transfer information. Examples of a machine-readable medium include an electronic circuit, a semiconductor memory device, a ROM, a flash memory, an Erasable ROM (EROM), a floppy disk, a CD-ROM, an optical disk, a hard disk, an optical fiber medium, a Radio Frequency (RF) link, and so forth. The code segments may be downloaded via computer networks such as the internet, intranet, etc.
It should also be noted that the exemplary embodiments mentioned in this patent describe some methods or systems based on a series of steps or devices. However, the present invention is not limited to the order of the above-described steps, that is, the steps may be performed in the order mentioned in the embodiments, may be performed in an order different from the order in the embodiments, or may be performed simultaneously.
As described above, only the specific embodiments of the present invention are provided, and it can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working processes of the system, the module and the unit described above may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again. It should be understood that the scope of the present invention is not limited thereto, and any person skilled in the art can easily conceive various equivalent modifications or substitutions within the technical scope of the present invention, and these modifications or substitutions should be covered within the scope of the present invention.
Claims (10)
1. The method is characterized in that the method is used for a data center station, the data center station is in communication connection with a production management system and a plurality of databases, BOM structure data are stored in the production management system, the BOM structure data comprise a plurality of top-level nodes, the top-level nodes are associated with bottom-level nodes, aircraft assembly information is stored in the top-level nodes, and assembly data required by aircraft assembly are stored in the databases respectively; the data middle stage comprises a materialized view, the materialized view comprises synchronous BOM structure data and assembly data, and the materialized view also comprises a corresponding relation between bottom-layer nodes and the assembly data in the BOM structure data; the method comprises the following steps:
receiving target assembly information of an airplane to be assembled;
determining a target top node in the materialized view according to the target assembly information;
performing recursive query by taking the target top-level node as a starting point according to the tree structure and the target assembly information in the BOM structure data to obtain a target bottom-level node;
and obtaining target assembly data according to the target bottom layer node and the corresponding relation.
2. The aircraft assembly data construction method according to claim 1, wherein the top level node is associated with a component layer, the component layer is associated with a level layer, the level layer is associated with a first configuration item layer, the first configuration item layer is associated with a second configuration item layer, the second configuration item layer comprises bottom level nodes, each layer associated with the top level node is stored in a different table, and the table corresponding to each layer also stores a parent-child relationship with the next layer.
3. The method for constructing aircraft assembly data according to claim 1, wherein the target assembly information includes node parameters, and the step of determining a target top-level node in the materialized view according to the target assembly information includes:
and determining a target top node in the materialized view according to the node parameters.
4. The method for constructing aircraft assembly data according to claim 2, wherein the target assembly information further includes a rack time parameter and a model parameter, and the step of performing recursive query to obtain a target bottom node by using the target top node as a starting point according to the tree structure and the target assembly information in the BOM structure data includes:
and performing recursive query by taking the target top-level node as a starting point according to the ranking parameter and the model parameter so as to obtain a bottom-level node of the target tree structure.
5. The method for constructing aircraft assembly data according to claim 4, wherein the performing recursive query to obtain a bottom node of a target tree structure by using the target top node as a starting point according to the rack-level parameter and the model parameter comprises:
merging the tables corresponding to each layer associated with the target top-level node to obtain a temporary view;
and performing recursive query on the temporary view according to the model parameters, the frame parameters and the parent-child relationship to obtain a target tree structure.
6. The aircraft assembly data construction method of claim 1, wherein prior to the receiving target assembly information for an aircraft to be assembled, the method further comprises:
and refreshing the materialized view according to a preset time interval.
7. An aircraft assembly data construction device is used for a data center station, wherein the data center station is in communication connection with a production management system and a plurality of databases, the production management system stores BOM structure data, the BOM structure data comprises a plurality of top-level nodes, the top-level nodes are associated with bottom-level nodes, aircraft assembly information is stored in the top-level nodes, and assembly data required by aircraft assembly are stored in the databases respectively; the data middle stage comprises a materialized view, the materialized view comprises synchronous BOM structure data and assembly data, and the materialized view also comprises a corresponding relation between bottom-layer nodes and the assembly data in the BOM structure data; the device comprises:
the receiving module is used for receiving target assembly information of the airplane to be assembled;
the determining module is used for determining a target top node in the materialized view according to the target assembly information;
the query module performs recursive query by taking the target top-layer node as a starting point according to the tree structure and the target assembly information in the BOM structure data to obtain a target bottom-layer node;
and the acquisition module acquires target assembly data according to the target bottom layer node and the corresponding relation.
8. The aircraft assembly data construction device according to claim 7, wherein the top level node is associated with a component layer, the component layer is associated with a level layer, the level layer is associated with a first configuration item layer, the first configuration item layer is associated with a second configuration item layer, the second configuration item layer comprises bottom level nodes, each layer associated with the top level node is stored in a different table, and the table corresponding to each layer also stores a parent-child relationship with the next layer.
9. An electronic device, comprising: at least one processor, at least one memory, and computer program instructions stored in the memory that, when executed by the processor, implement the method of any of claims 1-6.
10. A storage medium having computer program instructions stored thereon, which when executed by a processor implement the method of any one of claims 1-6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211279787.0A CN115357671B (en) | 2022-10-19 | 2022-10-19 | Method, device, equipment and medium for constructing aircraft assembly data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211279787.0A CN115357671B (en) | 2022-10-19 | 2022-10-19 | Method, device, equipment and medium for constructing aircraft assembly data |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115357671A CN115357671A (en) | 2022-11-18 |
| CN115357671B true CN115357671B (en) | 2023-01-10 |
Family
ID=84008475
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211279787.0A Active CN115357671B (en) | 2022-10-19 | 2022-10-19 | Method, device, equipment and medium for constructing aircraft assembly data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115357671B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115630117B (en) * | 2022-12-21 | 2023-04-07 | 网易（杭州）网络有限公司 | Data analysis method, materialized view generation method and related equipment |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109784818A (en) * | 2019-01-30 | 2019-05-21 | 美林数据技术股份有限公司 | Product data processing method, device, equipment and storage medium based on BOM |
| CN111881213A (en) * | 2020-07-28 | 2020-11-03 | 东航技术应用研发中心有限公司 | System for storing, processing and using flight big data |
| CN114254160A (en) * | 2021-11-24 | 2022-03-29 | 国网四川省电力公司信息通信公司 | Construction method of data navigation map for power grid company |
| CN115130794A (en) * | 2021-03-25 | 2022-09-30 | 腾讯科技（深圳）有限公司 | Data processing method, device, equipment and computer readable storage medium |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6850933B2 (en) * | 2001-11-15 | 2005-02-01 | Microsoft Corporation | System and method for optimizing queries using materialized views and fast view matching |
| US7543278B2 (en) * | 2004-10-15 | 2009-06-02 | Microsoft Corporation | System and method for making a user interface element visible |
| US11256666B2 (en) * | 2010-11-04 | 2022-02-22 | Speedment, Inc. | Method and apparatus for handling digital objects in a communication network |
| US10769836B2 (en) * | 2017-12-27 | 2020-09-08 | Industrial Technology Research Institute | Method and apparatus for establishing coordinate system and data structure product |
-
2022
- 2022-10-19 CN CN202211279787.0A patent/CN115357671B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109784818A (en) * | 2019-01-30 | 2019-05-21 | 美林数据技术股份有限公司 | Product data processing method, device, equipment and storage medium based on BOM |
| CN111881213A (en) * | 2020-07-28 | 2020-11-03 | 东航技术应用研发中心有限公司 | System for storing, processing and using flight big data |
| CN115130794A (en) * | 2021-03-25 | 2022-09-30 | 腾讯科技（深圳）有限公司 | Data processing method, device, equipment and computer readable storage medium |
| CN114254160A (en) * | 2021-11-24 | 2022-03-29 | 国网四川省电力公司信息通信公司 | Construction method of data navigation map for power grid company |
Non-Patent Citations (2)
| Title |
|---|
| Study on Endless Loop Node Checking Algorithm for BOM;Huang Xuewen;《2009 Second International Conference on Intelligent Computation Technology and Automation》;20091116;1-18页 * |
| 大数据多维建模分析平台的研究与实现;田川;《中国优秀硕士学位论文全文数据库 信息科技辑》;20220115;I138-845 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115357671A (en) | 2022-11-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108932313B (en) | Data processing method and device, electronic equipment and storage medium | |
| CN115357671B (en) | Method, device, equipment and medium for constructing aircraft assembly data | |
| CN114416703A (en) | Method, device, equipment and medium for automatically monitoring data integrity | |
| WO2016113648A1 (en) | Database statistical histogram forecasting | |
| CN111444188B (en) | Preparation method and device of stock test data, storage medium and electronic equipment | |
| CN105279089A (en) | Method and device for obtaining page element | |
| US11551169B2 (en) | Industrial device matching method and apparatus | |
| CN109741034B (en) | Grid tree organization management method and device | |
| CN113220907B (en) | Construction method and device of business knowledge graph, medium and electronic equipment | |
| CN114169860A (en) | Enterprise organizational structure synchronization method | |
| CN113721950A (en) | Resource loss prevention and control processing method and device | |
| CN112256555A (en) | Automatic test case management system and test case execution state conversion method | |
| CN115545577B (en) | Method and equipment for processing scheduling data | |
| CN115794067B (en) | Industrial software generation method and device, electronic equipment and storage medium | |
| CN111708761A (en) | Partitioned autonomous distributed heterogeneous database management system and method | |
| CN115660619A (en) | Production management system and server based on BIM information management | |
| CN114661736A (en) | Electronic map updating method and device, electronic equipment, storage medium and product | |
| CN114238359A (en) | Report data management method, device, equipment, medium and computer program product | |
| CN111753511B (en) | Method and system for fusing event information of different industrial assets | |
| CN114647496A (en) | Index checking method, device, equipment and computer readable storage medium | |
| CN114564501A (en) | Database data storage and query methods, devices, equipment and medium | |
| CN109426576A (en) | Fault-tolerance processing method and fault-tolerant component | |
| CN114416852A (en) | Data processing method, device, equipment and medium | |
| CN114385644A (en) | Dimension data processing method, device, equipment and storage medium | |
| US11551464B2 (en) | Line based matching of documents |
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 | ||
| GR01 | Patent grant |