CN114881566B - Installation process information data problem tracing method based on depth-first traversal strategy - Google Patents
Installation process information data problem tracing method based on depth-first traversal strategy Download PDFInfo
- Publication number
- CN114881566B CN114881566B CN202210547063.3A CN202210547063A CN114881566B CN 114881566 B CN114881566 B CN 114881566B CN 202210547063 A CN202210547063 A CN 202210547063A CN 114881566 B CN114881566 B CN 114881566B
- Authority
- CN
- China
- Prior art keywords
- data
- bill
- business
- fact
- dimension
- 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
- 238000000034 method Methods 0.000 title claims abstract description 55
- 238000011900 installation process Methods 0.000 title claims description 11
- 238000004519 manufacturing process Methods 0.000 claims abstract description 14
- 239000000463 material Substances 0.000 claims description 29
- 238000009434 installation Methods 0.000 claims description 13
- 230000000694 effects Effects 0.000 claims description 9
- 238000007726 management method Methods 0.000 claims description 4
- 238000004458 analytical method Methods 0.000 claims description 3
- 238000009826 distribution Methods 0.000 claims description 2
- 238000011144 upstream manufacturing Methods 0.000 abstract description 9
- 238000010276 construction Methods 0.000 abstract description 4
- 230000001737 promoting effect Effects 0.000 abstract description 3
- 238000013439 planning Methods 0.000 description 2
- 238000002360 preparation method Methods 0.000 description 2
- 230000033764 rhythmic process Effects 0.000 description 2
- 239000013589 supplement Substances 0.000 description 2
- 238000013473 artificial intelligence Methods 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000004806 packaging method and process Methods 0.000 description 1
- 239000000126 substance Substances 0.000 description 1
- 238000012384 transportation and delivery Methods 0.000 description 1
- 230000007306 turnover Effects 0.000 description 1
Classifications
-
- 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
- G06Q10/00—Administration; Management
- G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
- G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
-
- 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
- Business, Economics & Management (AREA)
- Engineering & Computer Science (AREA)
- Economics (AREA)
- General Physics & Mathematics (AREA)
- Tourism & Hospitality (AREA)
- Theoretical Computer Science (AREA)
- General Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Quality & Reliability (AREA)
- Development Economics (AREA)
- Operations Research (AREA)
- Entrepreneurship & Innovation (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Manufacturing & Machinery (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Primary Health Care (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The application relates to the technical field of big data and aviation manufacturing, and discloses a depth-first traversal strategy-based installed process information data problem tracing method, which is based on MBOM construction BBOM, then establishes association with a fact table of a data warehouse, opens data association of an upstream business process and a downstream business process according to a subdivision business domain of BBOM view, and finally judges a data breakpoint based on logic of a business. The application can help staff to find the service data problem on site in time, thereby improving the data quality, and finally promoting the high-efficiency performance of the aircraft production process and improving the productivity of the aircraft.
Description
Technical Field
The application relates to the technical field of big data and aviation manufacturing, in particular to an installation process information data problem tracing method based on a depth-first traversal strategy.
Background
Along with the continuous development of artificial intelligence and big data technology, the requirements of various large enterprises on data quality are higher and higher, the standard construction of an information system can be better promoted by improving the data quality, the business process turnover capacity is improved, and the capacity is finally promoted.
For aviation manufacturing industry, on-site business still has many manually executed processes, and has the problems of data input errors and the like, so that upstream and downstream data are inconsistent, and certain difficulties are brought to later retrospective work. Data information of an actual installation process is obtained in real time by constructing BBOM, and then the consistency of upstream and downstream data is detected based on the service field of BBOM, so that the problem of data quality is found, enterprises can be well helped to adjust service rhythm, coordinate material preparation and supplement data breakpoints, and production efficiency is improved. Therefore, how to automate the check of upstream and downstream data of BBOM business activities is critical to optimizing business processes.
Disclosure of Invention
In order to solve the problems and defects in the prior art, the application provides a method for tracing the information data problem of the installation process based on a depth-first traversal strategy, which is based on the MBOM construction BBOM, then establishes association with a fact table of a data warehouse, opens up the data association of an upstream business process and a downstream business process according to a subdivision business domain of BBOM view, finally judges a data breakpoint based on business logic, and can help workers to find the business data problem on site in time, thereby improving the data quality, and finally promoting the efficient performance of the aircraft production process and improving the productivity of the aircraft.
In order to achieve the above object, the present application has the following technical scheme:
The installed process information data problem tracing method based on the depth-first traversal strategy specifically comprises the following steps:
S1, constructing a theoretical installation bill of materials structure, and determining a unique identifier of an assembly outline;
S2, determining the service process dimension of an actual installed bill of materials;
S3, constructing a dimension table by taking an actual installed bill of materials business process needing to be counted as a fact process;
s4, constructing a fact table by taking a leaf node of a theoretical installation bill of materials structure as a minimum service unit of the fact table;
s5, hanging the constructed dimension table and the fact table under an assembly outline of a theoretical installation bill of materials structure;
S6, adopting a depth-first traversal strategy to preferentially theoretical install the whole machine node of the bill of materials structure, traversing the segment node and the station node in sequence, assembling a fact process of a outline and a fact table and a dimension table service process;
S7, judging the breakpoint of the data, so that the problem of information data of the installation process is found.
Further, in the step S2, the business process data warehouse model is constructed from several layers including production planning, purchasing, warehousing, distribution, ex-warehouse and borrowing by taking the number of ex-warehouse and in-warehouse in the logistics process as an analysis dimension.
Further, in the step S4, each row of data of the fact table is recorded as the AO number of each dimension table.
Further, in step S7, if the ID in the fact table is empty, it indicates that the business activity data is absent, and the activity is not executed; if the material quantity in the dimension table is inconsistent with the material quantity in the theoretical installation bill of materials structure, indicating that the data at the position has errors and needs to be treated; if the theoretical installation bill of materials structure has relevant nodes, but the fact table does not, the process service system is indicated to lack the service process data, and the management is needed.
The application has the beneficial effects that:
The application provides a depth-first traversal strategy-based installed process information data problem tracing method, which is based on MBOM construction BBOM, then establishes association with a fact table of a data warehouse, opens up data association of upstream and downstream business processes according to a BBOM view subdivision business domain, finally judges data breakpoints based on business logic, and can help workers to find on-site business data problems in time, thereby improving data quality, and finally promoting efficient performance of an aircraft production process and improving aircraft productivity.
Drawings
The foregoing and the following detailed description of the application will become more apparent when read in conjunction with the following drawings in which:
FIG. 1 is a flow chart of the method of the present application.
Detailed Description
In order for those skilled in the art to better understand the technical solution of the present application, the technical solution for achieving the object of the present application will be further described through several specific embodiments, and it should be noted that the technical solution claimed in the present application includes, but is not limited to, the following embodiments. All other embodiments, which can be made by a person skilled in the art without making any inventive effort, based on the embodiments of the present application shall fall within the scope of protection of the present application.
For aviation manufacturing industry, the current field business still has many manually executed processes, so that the problems of data input errors and the like exist, and the data on the upstream and the downstream are inconsistent, so that a certain difficulty is brought to the later traceability work. Data information of an actual installation process is obtained in real time by constructing BBOM, and then the consistency of upstream and downstream data is detected based on the service field of BBOM, so that the problem of data quality is found, enterprises can be well helped to adjust service rhythm, coordinate material preparation and supplement data breakpoints, and production efficiency is improved. Therefore, how to automate the check of upstream and downstream data of BBOM business activities is critical to optimizing business processes.
Based on the above, the embodiment provides a depth-first traversal strategy-based installation process information data problem tracing method, which can help workers to find service data problems on site in time, so that the data quality is improved, the efficient performance of the aircraft production process is finally promoted, and the productivity of the aircraft is improved.
In this embodiment, it should be noted that the MBOM refers to the bill of materials structure of the agency-based packaging machine.
In this embodiment, BBOM refers to the actual installed bill of materials.
In this embodiment, it should be noted that the leaf node is an assembly outline, which is also called an AO node.
Referring to fig. 1 of the specification, the method specifically comprises the following steps.
S1, constructing an MBOM structure, and finally determining the unique identification of the leaf node of the structure.
And S2, determining service process dimensions of BBOM views.
In the step, the business process data warehouse model is constructed by taking the number of the logistics process in-out and in-in as an analysis dimension and starting from the activities of all logistics processes such as production planning, purchasing and in-in, delivery, out-in and borrowing.
And S3, constructing a dimension table by taking BBOM business processes needing statistics as fact processes.
S4, constructing a fact table by taking the MBOM leaf node as a minimum service unit of the fact table, and recording data of each row of the fact table as the AO numbers of each dimension table.
S5, hanging the constructed dimension table and the fact table under an assembly outline of a theoretical installation bill of materials structure. The leaf nodes of the MBOM are AO numbers, and the AO numbers of the MBOM are associated with the AO numbers of the fact table.
And S6, adopting a depth-first traversal strategy, and preferentially traversing segment nodes, station nodes, a fact process of assembling outline and fact tables and a dimension table service process from the whole machine node of the installed bill structure in sequence. That is, the depth traversal process refers to going deep enough for each possible branch path to no longer go deep.
And S7, judging the breakpoint of the data, so that the problem of information data of the installation process is found.
Data breakpoint 1: if the ID in the fact table is empty, the fact table indicates that the business activity data is absent, and the activity is not executed.
Data breakpoint 2: if the material quantity in the dimension table is inconsistent with the material quantity in the theoretical installation bill of materials structure, the data at the position is wrong, and the management is needed.
Data breakpoint 3: if the theoretical installation bill of materials structure has relevant nodes, but the fact table does not, the process service system is indicated to lack the service process data, and the management is needed.
In this embodiment, it should be noted that there are other possible data breakpoint situations, which are not listed here, and the method may be used in other business fields of the production installation process.
In the description of the present application, it should also be noted that, unless explicitly specified and limited otherwise, the terms "disposed," "mounted," and "connected" are to be construed broadly, and may be, for example, fixedly connected, detachably connected, or integrally connected; can be mechanically or electrically connected; can be directly connected or indirectly connected through an intermediate medium, and can be communication between two elements. The specific meaning of the above terms in the present application will be understood in specific cases by those of ordinary skill in the art.
The foregoing description is only a preferred embodiment of the present application and is not intended to limit the application in any way, but any simple modification, equivalent variation, etc. of the above embodiment according to the technical substance of the present application falls within the scope of the present application.
Claims (1)
1. The installed process information data problem tracing method based on the depth-first traversal strategy is characterized by comprising the following steps of:
S1, constructing a theoretical installation bill of materials structure, and determining a unique identifier of an assembly outline;
S2, determining the service process dimension of an actual installed bill of materials;
S3, constructing a dimension table by taking an actual installed bill of materials business process needing to be counted as a fact process;
s4, constructing a fact table by taking an assembly outline of a theoretical installation bill of materials structure as a minimum service unit of the fact table;
s5, hanging the constructed dimension table and the fact table under an assembly outline of a theoretical installation bill of materials structure;
S6, adopting a depth-first traversal strategy to preferentially theoretical install the whole machine node of the bill of materials structure, traversing the segment node and the station node in sequence, assembling a fact process of a outline and a fact table and a dimension table service process;
S7, judging the breakpoint of the data, so as to find the problem of information data of the installation process;
In the step S2, the data warehouse model of the business process is constructed from the production plan, purchasing, warehousing, distribution, ex-warehouse and borrowing layers by taking the number of ex-warehouse and in-warehouse of the logistics process as analysis dimension;
In the step S4, each row of data of the fact table is recorded as an AO number of each dimension table, where the AO number represents an assembly outline;
in the step S7, if the ID in the fact table is empty, it is indicated that the business activity data is absent, and the activity is not executed; if the material quantity in the dimension table is inconsistent with the material quantity in the theoretical installation bill of materials structure, indicating that the data at the position has errors and needs to be treated; if the theoretical installation bill of materials structure has relevant nodes, but the fact table does not, the process service system is indicated to lack the service process data, and the management is needed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210547063.3A CN114881566B (en) | 2022-05-20 | 2022-05-20 | Installation process information data problem tracing method based on depth-first traversal strategy |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210547063.3A CN114881566B (en) | 2022-05-20 | 2022-05-20 | Installation process information data problem tracing method based on depth-first traversal strategy |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN114881566A CN114881566A (en) | 2022-08-09 |
| CN114881566B true CN114881566B (en) | 2024-06-04 |
Family
ID=82677827
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210547063.3A Active CN114881566B (en) | 2022-05-20 | 2022-05-20 | Installation process information data problem tracing method based on depth-first traversal strategy |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114881566B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN116739501A (en) * | 2023-05-12 | 2023-09-12 | 中航通飞华南飞机工业有限公司 | Rapid positioning method for differences between real object assembly configuration and design configuration of large aircraft |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2339063A1 (en) * | 2001-01-19 | 2002-07-19 | Cognos Incorporated | System and method for business performance management |
| CN1783129A (en) * | 2004-11-15 | 2006-06-07 | 国际商业机器公司 | Enterprise factory control method and system |
| US7472374B1 (en) * | 2003-06-09 | 2008-12-30 | Unisys Corporation | System and method for using blueprints to provide a traceable software solution for an enterprise |
| CN105279338A (en) * | 2015-11-09 | 2016-01-27 | 中国电子科技集团公司第三十八研究所 | Component processing-oriented process model construction method |
| CN108614891A (en) * | 2018-05-09 | 2018-10-02 | 上海航天精密机械研究所 | Space product data packet is built and consistency desired result method |
| CN111061747A (en) * | 2019-12-11 | 2020-04-24 | 金蝶软件（中国）有限公司 | Method for updating business document data and related equipment |
| CN112817725A (en) * | 2021-02-06 | 2021-05-18 | 成都飞机工业（集团）有限责任公司 | Microservice partitioning and optimizing method based on efficient global optimization algorithm |
Family Cites Families (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7487173B2 (en) * | 2003-05-22 | 2009-02-03 | International Business Machines Corporation | Self-generation of a data warehouse from an enterprise data model of an EAI/BPI infrastructure |
| US10909178B2 (en) * | 2015-03-05 | 2021-02-02 | Workday, Inc. | Methods and systems for multidimensional analysis of interconnected data sets stored in a graph database |
-
2022
- 2022-05-20 CN CN202210547063.3A patent/CN114881566B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CA2339063A1 (en) * | 2001-01-19 | 2002-07-19 | Cognos Incorporated | System and method for business performance management |
| US7472374B1 (en) * | 2003-06-09 | 2008-12-30 | Unisys Corporation | System and method for using blueprints to provide a traceable software solution for an enterprise |
| CN1783129A (en) * | 2004-11-15 | 2006-06-07 | 国际商业机器公司 | Enterprise factory control method and system |
| CN105279338A (en) * | 2015-11-09 | 2016-01-27 | 中国电子科技集团公司第三十八研究所 | Component processing-oriented process model construction method |
| CN108614891A (en) * | 2018-05-09 | 2018-10-02 | 上海航天精密机械研究所 | Space product data packet is built and consistency desired result method |
| CN111061747A (en) * | 2019-12-11 | 2020-04-24 | 金蝶软件（中国）有限公司 | Method for updating business document data and related equipment |
| CN112817725A (en) * | 2021-02-06 | 2021-05-18 | 成都飞机工业（集团）有限责任公司 | Microservice partitioning and optimizing method based on efficient global optimization algorithm |
Non-Patent Citations (2)
| Title |
|---|
| On Sequential-Pattern-Based Intelligent Compilation of Aircraft Assembly Process;Sen-Shan Ouyang;《2021 International Conference on Mechanical Engineering, Intelligent Manufacturing and Automation Technology》;20210117;第1820卷;1-7 * |
| 制造型企业信息化基础数据整理研究;赵长生;机械设计与制造工程;20130115;第42卷(第01期);44-48 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN114881566A (en) | 2022-08-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN114881566B (en) | Installation process information data problem tracing method based on depth-first traversal strategy | |
| Du et al. | RFID and multi-agent based architecture for information sharing in prefabricated component supply chain | |
| CN103514514A (en) | On-line monitoring method for electricity marketing business data | |
| CN108108917A (en) | Railway communication production scheduling command system | |
| CN106572186A (en) | Production supervision method and system | |
| CN108335027A (en) | A kind of wisdom interconnection manufacture execution managing and control system | |
| CN110322190A (en) | The method that steel industry intrabranch service order based on SAP automatically creates | |
| CN112163821A (en) | Cloud edge coordination system and method based on 5G industrial internet identification | |
| CN105373904A (en) | Application method of regulation data evaluating model in operation and maintenance of information system | |
| CN110110978A (en) | A kind of MES system for cabinet automatic assembly line | |
| CN114970954A (en) | Distribution network infrastructure data deepening application component engineering material prediction model system | |
| CN111915167A (en) | Intelligent manufacturing virtual shipyard information model construction method | |
| CN112541749A (en) | Construction progress management system based on BIM technology | |
| CN208506582U (en) | A kind of flexible production control system in dynamic regulation production path | |
| CN115016902B (en) | Industrial flow digital management system and method | |
| CN111815235A (en) | Engineering material management and control method and device based on BIM, storage medium and computer equipment | |
| CN107330608A (en) | A kind of production scheduling method based on Techniques of Neural Network | |
| CN110020820B (en) | Management and control method, electronic device, resource management system and device with storage function | |
| CN110826926A (en) | Intelligent manufacturing execution system for surface assembly production line | |
| CN107979174B (en) | Workflow operation method based on power grid operation management system | |
| CN205540238U (en) | Prevent slow -witted title material monitored control system | |
| CN212586936U (en) | Intelligent workshop system for mattress manufacturing | |
| CN201995020U (en) | Trusteeship call center system with performance calculating and managing functions | |
| CN112734226A (en) | Data asset management method for power customer service business | |
| CN106228312A (en) | A kind of mould management system |
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 |