CN111143480A - Method for conveniently dividing and tracking simplified expression standard part in aircraft manufacturing - Google Patents

Method for conveniently dividing and tracking simplified expression standard part in aircraft manufacturing Download PDF

Info

Publication number
CN111143480A
CN111143480A CN201911300754.8A CN201911300754A CN111143480A CN 111143480 A CN111143480 A CN 111143480A CN 201911300754 A CN201911300754 A CN 201911300754A CN 111143480 A CN111143480 A CN 111143480A
Authority
CN
China
Prior art keywords
standard component
standard
name
installation position
specific installation
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201911300754.8A
Other languages
Chinese (zh)
Other versions
CN111143480B (en
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.)
Individual
Original Assignee
Individual
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 Individual filed Critical Individual
Priority to CN201911300754.8A priority Critical patent/CN111143480B/en
Publication of CN111143480A publication Critical patent/CN111143480A/en
Application granted granted Critical
Publication of CN111143480B publication Critical patent/CN111143480B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

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/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/284Relational databases
    • G06F16/288Entity relationship models
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION 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/00Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/04Manufacturing
    • YGENERAL 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
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02PCLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
    • Y02P90/00Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
    • Y02P90/30Computing systems specially adapted for manufacturing

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Primary Health Care (AREA)
  • Marketing (AREA)
  • Human Resources & Organizations (AREA)
  • Strategic Management (AREA)
  • Tourism & Hospitality (AREA)
  • General Health & Medical Sciences (AREA)
  • General Business, Economics & Management (AREA)
  • Economics (AREA)
  • Health & Medical Sciences (AREA)
  • Manufacturing & Machinery (AREA)
  • Data Mining & Analysis (AREA)
  • General Engineering & Computer Science (AREA)
  • General Factory Administration (AREA)

Abstract

The invention relates to a method for conveniently simplifying and expressing standard component division and tracking in aircraft manufacturing, and aims to solve the problems that the conventional standard component division mode has various data contents and is difficult to manage. The method for conveniently and simply expressing standard part division and tracking in the aircraft manufacturing comprises the following steps; establishing a corresponding storage code C according to the name M of the standard component, and generating a standard component code number coding set by the standard component name and the standard component figure number; establishing a mapping relation between the storage code set C and the standard component code set D, and generating one standard component attribute code set by the number of the standard components, the name of the specific installation position and the picture number of the specific installation position; and establishing a mapping relation between the storage code set C and the standard component attribute coding set Xj, and storing the storage code set C, the standard component code set D, the standard component attribute coding matrix set Xj and the mapping relation thereof in a database.

Description

Method for conveniently dividing and tracking simplified expression standard part in aircraft manufacturing
Technical Field
The invention belongs to the field of airplane manufacturing part management, and particularly relates to a method for dividing and tracking simplified expression standard parts in airplane manufacturing.
Background
The standard parts refer to common parts such as screw parts, keys, pins, rolling bearings, etc. which are completely standardized in various aspects of structure, size, marks, etc. and are produced by professional factories. The number of standard parts needed to be used by the airplane in the manufacturing process is very large, the types of the standard parts are also various, therefore, a database needs to be established when the data of the standard parts are stored, the name, the drawing number, the number and the installation position of the standard parts are stored one by the database, the database stores the name, the drawing number, the installation position and the number of the standard parts in a packaging manner according to a conventional single information storage manner (the name, the drawing number, the installation position and the number of the standard parts are stored in a packaging manner), the database has very large contents, not only occupies more resources, but also is not easy to be uniformly managed, and once the data of the standard parts in the using process is changed, the standard parts with the same name and the drawing number are easy to be disordered, the filing of the standard parts is influenced, more human resources are needed to be spent when the disordered.
Disclosure of Invention
The invention aims to provide a method for conveniently and simply expressing standard component division and tracking in aircraft manufacturing, and solves the problems that the conventional standard component division mode has various data contents and is not easy to manage.
In order to achieve the purpose, the technical scheme of the invention is as follows:
a method for conveniently dividing and tracking simplified expression standard components in aircraft manufacturing comprises the following steps;
s1, establishing a corresponding storage code C according to the name M of the standard component, wherein the storage code set C { C1, C2, C3, … …, cn } of the standard component, the set M { M1, M2, M3, … …, mn } of the standard component, the set T { T1, T2, T3, … …, tn } of the standard component picture number, and generating a standard component code set D { D1, D2, D3, … …, dn } by the standard component name plus the standard component picture number;
s2, establishing a mapping relation between the storage code set C and the standard component code set D, and inquiring the picture number or name of the corresponding standard component through the storage code;
s3, wherein a standard component number set S1 { S1, S2, S3, … …, st }, a specific installation position name set N1 { N1, N2, N3, … …, nt }, a specific installation position picture number set H1 { H1, H2, H3, … …, ht }, and a standard component number + specific installation position name + specific installation position picture number are used for generating a standard component attribute coding set X1 { X1, X2, X3, … …, xt };
s4, obtaining all standard component attribute coding matrix sets Xj { X1, X2, X3, … …, Xn } according to one standard component attribute coding set X1, establishing a mapping relation between a storage code set C and the standard component attribute coding set Xj, and inquiring the number of corresponding standard components, the names of specific installation positions and the picture numbers through storage codes;
s5, storing the storage code set C, the standard part code set D, the standard part attribute coding matrix set Xj and the mapping relation thereof into a database;
s6, inputting the picture number of the standard component or the name of the specific installation position or the picture number of the specific installation position, and inquiring the picture number of the standard component, the name of the specific installation position, the picture number of the specific installation position and the number of the standard component through the corresponding storage code;
and S7, when the data is modified, directly reading the data in the set and modifying the data, wherein the modified data can be directly related to the original data according to the set mapping relation.
Preferably, the specific installation position name N1 { N1, N2, N3, … …, nt } of one standard component is used for establishing a corresponding storage code set W1 { W1, W2, W3, … …, wt }; generating a standard part position code set Z1 { Z1, Z2, Z3, … …, zt } by the specific installation position name of the standard part and the specific installation position picture number of the standard part;
making a standard component position matrix set Uj { U1, U2, U3 and … … Ut } by using a standard component position code set Z1 and an upper installation position code thereof, wherein U1 is { Z1, U1, U2, U3, … … and ua }, U2 is { Z2, U1, U2, U3, … … and ub }, U3 is { Z3, U1, U2, U3, … … and uc }, and Un is { zn, U1, U2, U3, … … and ux }; u1, u2, u3, … … and ua are the figure number and the name of the upper mounting position of z 1; u1, u2, u3, … … and ub are the drawing number and name of the upper mounting position of z 2; u1, u2, u3, … … and uc are the drawing number and name of the upper mounting position of z 3; u1, u2, u3 and … …, and ux is the figure number and name of the upper mounting position of zn;
establishing a mapping relation between a standard component position matrix set Uj and a storage code set W1, and inquiring names or figure numbers of specific installation positions and upper installation positions of corresponding standard components through a storage code W1;
establishing all standard component storage code matrix sets Wj { W1, W2, W3, … … and Wn } according to one standard component storage code set W1, establishing a mapping relation between the standard component storage code matrix set Wj and a standard component storage code set C, and inquiring the name or the figure number of the specific installation position and the upper installation position of the standard component through the standard component storage code C.
The invention has the beneficial effects that:
the method for conveniently simplifying the division and tracking of the expression standard component in the aircraft manufacturing, provided by the invention, has the advantages that the division method is clear and simple, the data storage capacity can be reduced, and fewer resources are occupied; the management of workers can be facilitated through the mapping relation; the associated data information can be quickly found through the mapping relation when the data is read daily, and the original data structure cannot be changed when the data is modified, so that the efficiency of workers can be improved when the data is maintained or tracked in the later period.
Drawings
FIG. 1 is a flow chart of a method for facilitating simplified presentation of standard part partitioning and tracking in aircraft manufacturing according to the present invention.
Detailed Description
The invention is described in further detail below with reference to the following figures and specific examples:
a method for facilitating simplified presentation of standard part partitioning and tracking in aircraft manufacturing, as shown in fig. 1, comprising the steps of:
s1, establishing a corresponding storage code C according to the name M of the standard component, wherein the storage code set C { C1, C2, C3, … …, cn } of the standard component, the set M { M1, M2, M3, … …, mn } of the standard component, the set T { T1, T2, T3, … …, tn } of the standard component picture number, and generating a standard component code set D { D1, D2, D3, … …, dn } by the standard component name plus the standard component picture number; the generation of the standard part code set D can reduce the storage content, and meanwhile, the problem that the names and the picture numbers of the standard parts are disordered is solved.
S2, establishing a mapping relation between the storage code set C and the standard component code set D, and inquiring the picture number or name of the corresponding standard component through the storage code; the corresponding name or figure number is inquired through the figure number or name of the standard component;
s3, wherein a standard component number set S1 { S1, S2, S3, … …, st }, a specific installation position name set N1 { N1, N2, N3, … …, nt }, a specific installation position picture number set H1 { H1, H2, H3, … …, ht }, and a standard component number + specific installation position name + specific installation position picture number are used for generating a standard component attribute coding set X1 { X1, X2, X3, … …, xt }; the number, the name and the figure number of the standard components at the same position are divided into one type for storage, so that the management operations such as modification, inquiry, tracking and the like at the later stage can be facilitated.
S4, obtaining all standard component attribute coding matrix sets Xj { X1, X2, X3, … …, Xn } according to one standard component attribute coding set X1, establishing a mapping relation between a storage code set C and the standard component attribute coding set Xj, and inquiring the number of corresponding standard components, the names of specific installation positions and the picture numbers through storage codes;
s5, storing the storage code set C, the standard part code set D, the standard part attribute coding matrix set Xj and the mapping relation thereof into a database;
s6, inquiring the picture number of the standard component, the name of the specific installation position and the number information of the standard component according to the corresponding storage code through a keyword in the picture number of the standard component, the name of the specific installation position, the picture number of the specific installation position and the number information of the standard component;
and S7, when the drawing number of the standard component, the name of the specific installation position, the drawing number of the specific installation position and the quantity information data of the standard component are modified, the data in the set can be directly read and the corresponding data can be modified, and the modified data can be directly associated to the original data according to the set mapping relation.
S8, the upper position relation of the standard component can be divided, such as the bolts on the corner pieces, according to the drawing numbers and names of the corner pieces, or the drawing numbers and names of the section bars containing the corner pieces, the drawing numbers and names of the cabin doors containing the section bars and the drawing numbers and names of the cabin doors located in the fuselage sections, and by dividing the upper position, the installation positions of the standard component can be conveniently and quickly found by workers, so that the installation area of the standard component can be quickly confirmed, and the construction management is facilitated.
Establishing a corresponding storage code set W1 { W1, W2, W3, … …, wt } by using the specific installation position name N1 { N1, N2, N3, … …, nt } of one standard component; generating a standard part position coding set Z1 { Z1, Z2, Z3, … … and zt } by combining the specific installation position name of the standard part and the specific installation position map number set H1 { H1, H2, H3, … … and ht } of the standard part;
an upper mounting position code set U0 { U1, U2, U3, … … and ua } of one standard component is obtained, and an upper mounting position code matrix set Uj0 { U01, U02, U03, … … and U0t } of all standard components is obtained according to the upper mounting position code set U0 of one standard component;
and (3) making the standard component position code set Z1 and the upper installation position code matrix set Uj0 thereof into a standard component position matrix set Uj { U1, U2, U3, … … Ut }.
U1 is { z1, U1, U2, U3, … …, ua }, U1, U2, U3, … …, ua is the figure number and name of the upper mounting position of z 1;
u2 is { z2, U1, U2, U3, … …, ub }, U1, U2, U3, … …, ub is the drawing number and name of the upper mounting position of z 2;
u3 is { z3, U1, U2, U3, … …, uc }, U1, U2, U3, … …, uc is the drawing number and name of the upper mounting position of z 3;
un is { zn, u1, u2, u3, … …, ux }; u1, u2, u3 and … …, and ux is the figure number and name of the upper mounting position of zn;
establishing a mapping relation between a standard component position matrix set Uj and a storage code set W1, and inquiring names or figure numbers of specific installation positions and upper installation positions of corresponding standard components through a storage code W1;
establishing all standard component storage code matrix sets Wj { W1, W2, W3, … … and Wn } according to one standard component storage code set W1, establishing a mapping relation between the standard component storage code matrix set Wj and a standard component storage code set C, and inquiring the name or the figure number of the specific installation position and the upper installation position of the standard component through the standard component storage code C.
Therefore, the drawing number, the name of the standard component, the name or the number of the specific installation position, and the name or the number of the upper installation position of the standard component can be inquired according to the drawing number, the name or the number of the standard component, and the name or the number of the upper installation position of the standard component corresponding to the drawing number, the name or the number of the standard component, and the name or the number of the upper installation position. The dividing method is clear and simple, can reduce the data storage capacity, occupies less resources, and can facilitate the management of workers through the mapping relation; the associated data information can be quickly found through the mapping relation when the data is read daily, and the original data structure cannot be changed when the data is modified, so that the efficiency of workers can be improved when the data is maintained or tracked in the later period.
The above description is only an embodiment of the present invention, and is not intended to limit the scope of the present invention, and all equivalent structural changes made by using the contents of the present specification and the drawings, or applied directly or indirectly to other related technical fields, are included in the scope of the present invention.

Claims (2)

1. A method for facilitating division and tracking of simplified representation standard components in aircraft manufacturing is characterized in that: comprises the following steps;
s1, establishing a corresponding storage code C according to the name M of the standard component, wherein the storage code set C { C1, C2, C3, … …, cn } of the standard component, the set M { M1, M2, M3, … …, mn } of the standard component, the set T { T1, T2, T3, … …, tn } of the standard component picture number, and generating a standard component code set D { D1, D2, D3, … …, dn } by the standard component name plus the standard component picture number;
s2, establishing a mapping relation between the storage code set C and the standard component code set D, and inquiring the picture number or name of the corresponding standard component through the storage code;
s3, wherein a standard component number set S1 { S1, S2, S3, … …, st }, a specific installation position name set N1 { N1, N2, N3, … …, nt }, a specific installation position picture number set H1 { H1, H2, H3, … …, ht }, and a standard component number + specific installation position name + specific installation position picture number are used for generating a standard component attribute coding set X1 { X1, X2, X3, … …, xt };
s4, obtaining all standard component attribute coding matrix sets Xj { X1, X2, X3, … …, Xn } according to one standard component attribute coding set X1, establishing a mapping relation between a storage code set C and the standard component attribute coding set Xj, and inquiring the number of corresponding standard components, the names of specific installation positions and the picture numbers through storage codes;
s5, storing the storage code set C, the standard part code set D, the standard part attribute coding matrix set Xj and the mapping relation thereof into a database;
s6, inputting the picture number of the standard component or the name of the specific installation position or the picture number of the specific installation position, and inquiring the picture number of the standard component, the name of the specific installation position, the picture number of the specific installation position and the number of the standard component through the corresponding storage code;
and S7, when the data is modified, directly reading the data in the set and modifying the data, wherein the modified data can be directly related to the original data according to the set mapping relation.
2. A method for facilitating the simplified presentation of standard part partitioning and tracking in aircraft manufacturing according to claim 1, wherein: establishing a corresponding storage code set W1 { W1, W2, W3, … …, wt } by using the specific installation position name N1 { N1, N2, N3, … …, nt } of one standard component; generating a standard part position code set Z1 { Z1, Z2, Z3, … …, zt } by the specific installation position name of the standard part and the specific installation position picture number of the standard part;
making a standard component position matrix set Uj { U1, U2, U3 and … … Ut } by using a standard component position code set Z1 and an upper installation position code thereof, wherein U1 is { Z1, U1, U2, U3, … … and ua }, U2 is { Z2, U1, U2, U3, … … and ub }, U3 is { Z3, U1, U2, U3, … … and uc }, and Un is { zn, U1, U2, U3, … … and ux }; u1, u2, u3, … … and ua are the figure number and the name of the upper mounting position of z 1; u1, u2, u3, … … and ub are the drawing number and name of the upper mounting position of z 2; u1, u2, u3, … … and uc are the drawing number and name of the upper mounting position of z 3; u1, u2, u3 and … …, and ux is the figure number and name of the upper mounting position of zn;
establishing a mapping relation between a standard component position matrix set Uj and a storage code set W1, and inquiring names or figure numbers of specific installation positions and upper installation positions of corresponding standard components through a storage code W1;
establishing all standard component storage code matrix sets Wj { W1, W2, W3, … … and Wn } according to one standard component storage code set W1, establishing a mapping relation between the standard component storage code matrix set Wj and a standard component storage code set C, and inquiring the name or the figure number of the specific installation position and the upper installation position of the standard component through the standard component storage code C.
CN201911300754.8A 2019-12-17 2019-12-17 Method for conveniently dividing and tracking simplified expression standard part in aircraft manufacturing Active CN111143480B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911300754.8A CN111143480B (en) 2019-12-17 2019-12-17 Method for conveniently dividing and tracking simplified expression standard part in aircraft manufacturing

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911300754.8A CN111143480B (en) 2019-12-17 2019-12-17 Method for conveniently dividing and tracking simplified expression standard part in aircraft manufacturing

Publications (2)

Publication Number Publication Date
CN111143480A true CN111143480A (en) 2020-05-12
CN111143480B CN111143480B (en) 2023-03-21

Family

ID=70518613

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911300754.8A Active CN111143480B (en) 2019-12-17 2019-12-17 Method for conveniently dividing and tracking simplified expression standard part in aircraft manufacturing

Country Status (1)

Country Link
CN (1) CN111143480B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116193085A (en) * 2023-04-24 2023-05-30 中汽信息科技(天津)有限公司 Automobile tracking and positioning method and system based on edge computing technology

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20110296394A1 (en) * 2010-05-26 2011-12-01 Seth Kelby Vidal Systems and methods for generating cached representations of encoded package profile
WO2013143278A1 (en) * 2012-03-30 2013-10-03 华为技术有限公司 Method, device and system for querying data index
CN108416137A (en) * 2018-03-02 2018-08-17 沈阳飞机工业(集团)有限公司 It is divided and the method for tracking in a kind of aircraft manufacturing convenient for simplifying expression standard component

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20110296394A1 (en) * 2010-05-26 2011-12-01 Seth Kelby Vidal Systems and methods for generating cached representations of encoded package profile
WO2013143278A1 (en) * 2012-03-30 2013-10-03 华为技术有限公司 Method, device and system for querying data index
CN108416137A (en) * 2018-03-02 2018-08-17 沈阳飞机工业(集团)有限公司 It is divided and the method for tracking in a kind of aircraft manufacturing convenient for simplifying expression standard component

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
孙宜然等: "面向工装管理的工装图号编码方法的设计与实现", 《制造业自动化》 *
杜宝江等: "飞机标准件的自动筛选与匹配技术研究", 《现代制造工程》 *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN116193085A (en) * 2023-04-24 2023-05-30 中汽信息科技(天津)有限公司 Automobile tracking and positioning method and system based on edge computing technology

Also Published As

Publication number Publication date
CN111143480B (en) 2023-03-21

Similar Documents

Publication Publication Date Title
CN105447122B (en) A kind of implementation method that archives economy can be independently created based on multilist association
Engles A tutorial on data base organization
CN105677323A (en) Method for automatically generating database operation layer codes
CN105718261A (en) Functional member and functional member tree based target product generation method and system
CN109408906B (en) BIM model-based engineering quantity expression and statistics method
CN108280159B (en) Method for converting graph database into relational database
CN105022615A (en) Interface generating method and system
CN109214068A (en) Bottom assembled architecture information extracting method based on BIM
CN107748803B (en) Method for designing spatial situation characteristic event database
CN101488086A (en) Software generation method and apparatus based on field model
US20060149770A1 (en) Integrated authoring system for electronic technical manual and paper technical manual using logistics support analysis data and authoring method therefor
CN109783886A (en) Emerging system and method for GIM model and IFC model
CN111143480B (en) Method for conveniently dividing and tracking simplified expression standard part in aircraft manufacturing
CN104573086A (en) Database access component and generating method thereof
CN103473444A (en) Electronic medical record system based on intelligent analyzing data structure and processing method of system
CN109344306B (en) Method and system for customized online transaction and service of field multi-standard metadata
CN104199882A (en) Method for obtaining structural knowledge and ontology of structural knowledge based on intelligent template customization
CN114895875B (en) Zero-code visual information system metadata production application method and system
CN111625596A (en) Multi-source data synchronous sharing method and system for real-time consumption scheduling of new energy
CN116301760A (en) Application design system for software development
CN104346334A (en) Remote visual interface database system
CN113918537A (en) XML-based power grid multidimensional data modeling method
CN101464873A (en) Material list establishing method and system
CN103958796A (en) A method and system for providing and managing information of prefabricated construction components between manufacturers and architects
Bounab et al. A federated approach to tool integration

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