CN107977409A - A kind of code conversion method of space flight goods and materials data - Google Patents
A kind of code conversion method of space flight goods and materials data Download PDFInfo
- Publication number
- CN107977409A CN107977409A CN201711162703.4A CN201711162703A CN107977409A CN 107977409 A CN107977409 A CN 107977409A CN 201711162703 A CN201711162703 A CN 201711162703A CN 107977409 A CN107977409 A CN 107977409A
- Authority
- CN
- China
- Prior art keywords
- code
- goods
- nato
- database
- coding
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
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/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
- G06F16/24534—Query rewriting; Transformation
- G06F16/24537—Query rewriting; Transformation of operators
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A kind of code conversion method of space flight goods and materials data, the step of including one using computer system storage items data, computer system includes database and input unit, input unit includes keyboard, wherein, the approval items name code being stored with database in goods and materials data and NATO coding, the class indication code in goods and materials data is read using computer, then retrieved to obtain the approval items name code in corresponding NATO coding in the database according to class indication code, then the class indication code for needing to be changed is chosen, the corresponding goods attribute of class indication code is inserted in the approval items name code attribute in NATO coding using computer, finally, according to the specification conditions of article, normal conditions used by article, auth type and reference number evidence are filled up in database.The present invention will can meet《China Aerospace Science and Industry Corporation's article code specification》Group's goods and materials data conversion into class NATO fgs encoder data, improve transfer efficiency.
Description
Technical field:
The present invention relates to the storing technology of transport field, more particularly to goods and materials, particularly a kind of volume of space flight goods and materials data
Code converting method.
Background technology:
In space flight industry, item code structure is made of class indication code and signature identification code:
×××××××× ××××××
Wherein, preceding 8 bit digital is class indication code, is marked with reference to China national GB/T 7635.1-2002 and GJB 5426
Standard, determines taxonomy of goods situation.6 bit digitals are characterized identification code afterwards, by issue sequencing generation.
With reference to the classification of GB/T 7635.1-2002 and GJB 5426, cluster coding is by group's ordinary articles by management requirement
Be divided into electronic component, nonmetallic materials, metal material, electronic product, product classification, taxonomy of goods level be divided into major class, in
Four layers of class, group and subclass, sorting code number derive from GB/T 7635.1-2002 and GJB 5426.
When production items completion items verification process, after obtaining MSN codings, production items have been transformed into.MSN coding by
13 character compositions.4 are to divide items class numbering (first 2 are group or major class, and latter two are class or group), mesh before MSN codings
Before have a major class more than 80, more than 600 a groups, cover all trades and professions, in addition to weaponry, also comprising other industry content, such as agriculture
Forestry, furniture, office appliance etc..
The principle of classification of major class group is performed according to GJB 7000.2 are national code among MSN codings, are ensured in platform
Distribute unitedly as 86, latter 7 are serial number, no concrete meaning, according to supply items authentication sequence layout successively.
In the prior art, when researching and developing the article of space flight industry, it is often necessary to colleague of the retrieval with reference to NATO group
Industry article.Since NATO uses different code systems to article, artificial contrast's inquiry is extremely inconvenient.
The content of the invention:
The object of the present invention is to provide a kind of code conversion method of space flight goods and materials data, this space flight goods and materials number
According to code conversion method to solve the item code of space flight industry and the less efficient skill of NATO code conversion in the prior art
Art problem.
The code conversion method of this space flight goods and materials data of the present invention, including a utilization computer system storage items
The step of data, the computer system include database and input unit, and the input unit includes keyboard, wherein,
The approval items name code being stored with the database in goods and materials data and NATO coding, read using computer described in
Goods and materials data in class indication code, then retrieve to obtain corresponding NATO in the database according to the class indication code
Approval items name code in coding, then choosing needs the class indication code changed, using computer by the contingency table
Know the corresponding goods attribute of code to insert in the approval items name code attribute in NATO coding, finally, according to the specification feelings of article
Normal conditions used by condition, article, auth type and reference number evidence are filled up in database.
Further, items name code is ratified in corresponding NATO coding is retrieved in the database according to class indication code
In step, selected using the mode of Keywords matching in NATO coding and ratify items name code.
Compared with prior art, its effect is positive and obvious to the present invention.The present invention is realized using computer system
The conversion of goods and materials data and NATO coded data, will can meet《China Aerospace Science and Industry Corporation's article code specification》Group
Goods and materials data conversion completes extraction, the conversion of attribute data, completes the automatic of authentication data and fill out into class NATO fgs encoder data
Enter, improve transfer efficiency.
Embodiment:
Embodiment 1
The code conversion method of the space flight goods and materials data of the present invention, including a utilization computer system storage items data
The step of, the computer system includes database and input unit, and the input unit includes keyboard, wherein, it is described
Database in be stored with approval items name code in goods and materials data and NATO coding, utilize computer to read the thing
The class indication code in data is provided, is then retrieved to obtain corresponding NATO coding in the database according to the class indication code
In approval items name code, then choosing needs the class indication code changed, using computer by the class indication code
Corresponding goods attribute is inserted in the approval items name code attribute in NATO coding, finally, according to the specification conditions of article, thing
Normal conditions used by product, auth type and reference number evidence are filled up in database.
Further, items name code is ratified in corresponding NATO coding is retrieved in the database according to class indication code
In step, selected using the mode of Keywords matching in NATO coding and ratify items name code.
Specifically, by taking a content is the items of capacitor as an example, the transcoding procedure carried out according to the present invention is such as
Under:
Exist first《China Aerospace Science and Industry Corporation's article code specification》In to check in the capacitor properties as shown in the table:
A, according to title and classification, corresponding INC=05667 is determined;
B, the attribute that INC=05667 is inquired about in NATO system coding is as shown in the table;
Then, the correspondence such as following table between both of which attribute is established:
Attribute is as shown in the table after the data conversion class NATO coded data of the capacitor:
Data are as follows after being converted with coded representation:
NAMED05667#ZZZTJYNPC#ZZZTJTYCBB222C#BHYFJBV1000#AFZHB47000#ZZZTJGRK#
ZZZTJRTB1#ZZZTJRTJ#ZZZKJNZZR-Q/RQ23045-2004##
Finally determine identification types.
In the present embodiment, INC=05667 has AARA, AFZH, BHYF, BHYG tetra- to fill out variable, herein only AFZH and
BHYF has value, must fill out value and not exclusively be not belonging to the identification of 1 type, belong to the identification of 4 types, its standard No. ZZR-Q/RQ23045-2004 can be bright
The items are really represented, so belonging to 4A type identification types.
Claims (2)
1. a kind of code conversion method of space flight goods and materials data, including a step that items data are stored using computer system
Suddenly, the computer system includes database and input unit, and the input unit includes keyboard, it is characterised in that:Institute
The approval items name code being stored with the database stated in goods and materials data and NATO coding, described using computer reading
Class indication code in goods and materials data, then retrieves to obtain corresponding NATO volume in the database according to the class indication code
Approval items name code in code, then choosing needs the class indication code changed, using computer by the class indication
The corresponding goods attribute of code is inserted in the approval items name code attribute in NATO coding, finally, according to the specification conditions of article,
Normal conditions used by article, auth type and reference number evidence are filled up in database.
2. the code conversion method of space flight goods and materials data according to claim 1, it is characterised in that:According to class indication
Code is retrieved in the step of ratifying items name code in corresponding NATO coding in the database, is selected using the mode of Keywords matching
Ratify items name code in NATO coding.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201711162703.4A CN107977409A (en) | 2017-11-21 | 2017-11-21 | A kind of code conversion method of space flight goods and materials data |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201711162703.4A CN107977409A (en) | 2017-11-21 | 2017-11-21 | A kind of code conversion method of space flight goods and materials data |
Publications (1)
Publication Number | Publication Date |
---|---|
CN107977409A true CN107977409A (en) | 2018-05-01 |
Family
ID=62010569
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201711162703.4A Pending CN107977409A (en) | 2017-11-21 | 2017-11-21 | A kind of code conversion method of space flight goods and materials data |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107977409A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108919695A (en) * | 2018-05-28 | 2018-11-30 | 深圳创维-Rgb电子有限公司 | A kind of coding method, device, equipment and the storage medium of electrical equipment module |
-
2017
- 2017-11-21 CN CN201711162703.4A patent/CN107977409A/en active Pending
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN108919695A (en) * | 2018-05-28 | 2018-11-30 | 深圳创维-Rgb电子有限公司 | A kind of coding method, device, equipment and the storage medium of electrical equipment module |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN102473185B (en) | Information search system, information management device, information search method, information management method, and recording medium | |
CN101673307B (en) | Space data index method and system | |
CN101404032A (en) | Video retrieval method and system based on contents | |
US10095769B2 (en) | System and method for dynamically clustering data items | |
CN103678648B (en) | A kind of BOM table sort aggregation system and method thereof | |
CA2477126A1 (en) | Support for multiple content-management data models | |
CN103970842A (en) | Water conservancy big data access system and method for field of flood control and disaster reduction | |
CN103902701A (en) | Data storage system and data storage method | |
CN105574648A (en) | Encoding method and system oriented to large ship whole lifecycle management | |
CN109284420A (en) | Electronic component substitutes selection system and substitution selection method | |
CN105117442A (en) | Probability based big data query method | |
CN103870557A (en) | Database-based electronic file storage system | |
CN107977409A (en) | A kind of code conversion method of space flight goods and materials data | |
Kaligis et al. | Analisa Perbandingan Algoritma K-Means, K-Medoids, Dan X-Means Untuk Pengelompokkan Kinerja Pegawai | |
CN105868357B (en) | File managing and control system and method | |
CN107273529A (en) | Efficient level index construct and search method based on hash function | |
CN1425159A (en) | ID symbol unique to structural formula of compound | |
CN105701256A (en) | Communication point table file comparison method | |
CN104598520A (en) | Commodity information processing method and device | |
CN107193906A (en) | The generation method and device of process pipe meter diagram BOM | |
US8805820B1 (en) | Systems and methods for facilitating searches involving multiple indexes | |
CN105302833A (en) | Content based video retrieval mathematic model establishment method | |
CN107239454A (en) | Search method and system based on text database | |
CN104809143B (en) | Method and apparatus for form data to be implanted into information bank | |
CN103544317B (en) | The treating method and apparatus of dimension table data |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
WD01 | Invention patent application deemed withdrawn after publication | ||
WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20180501 |