CN108595465A - Data processing method and device - Google Patents

Data processing method and device Download PDF

Info

Publication number
CN108595465A
CN108595465A CN201810096829.4A CN201810096829A CN108595465A CN 108595465 A CN108595465 A CN 108595465A CN 201810096829 A CN201810096829 A CN 201810096829A CN 108595465 A CN108595465 A CN 108595465A
Authority
CN
China
Prior art keywords
product
industrial part
encoded
tuple
standard
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201810096829.4A
Other languages
Chinese (zh)
Inventor
林振峰
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Hangzhou Excellent Technology Co Ltd
Original Assignee
Hangzhou Excellent Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Hangzhou Excellent Technology Co Ltd filed Critical Hangzhou Excellent Technology Co Ltd
Priority to CN201810096829.4A priority Critical patent/CN108595465A/en
Publication of CN108595465A publication Critical patent/CN108595465A/en
Priority to PCT/CN2019/073729 priority patent/WO2019149193A1/en
Pending legal-status Critical Current

Links

Classifications

    • 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
    • G06Q10/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • 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

Landscapes

  • Business, Economics & Management (AREA)
  • Engineering & Computer Science (AREA)
  • Economics (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Human Resources & Organizations (AREA)
  • Marketing (AREA)
  • General Business, Economics & Management (AREA)
  • Strategic Management (AREA)
  • Tourism & Hospitality (AREA)
  • General Health & Medical Sciences (AREA)
  • Primary Health Care (AREA)
  • Health & Medical Sciences (AREA)
  • Manufacturing & Machinery (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Development Economics (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • General Factory Administration (AREA)

Abstract

This application discloses a kind of data processing method and devices.This method includes:Determine industrial part to be encoded;The industrial part is encoded according to preset rules and database is written;Increase preset association relationship when being encoded to the industrial part.Present application addresses the low technical problems of the data-handling efficiency for industrial part.The application has achieved the purpose that industrial part encodes, to realize the technique effect to the product Unified coding of industrial part.It is that industrial part distributes a unique product identification card number by basic data, really realizes product attribute data uniformity and uniqueness, standardization, the standardization of industry is substantially improved, data basis is provided for industrial sector optimization and upgrading.In addition, industrial part can be encoded and be stored by the data processing method in the application, the industrial part basic database of 10,000,000,000 ranks is formed.

Description

Data processing method and device
Technical field
This application involves data processing fields, in particular to a kind of data processing method and device.
Background technology
Industrial part belongs to manufacturing base, according to difficulty of processing, is divided into raw material, industry from low to high Parts, assembling/assembly, core module layer, the system integration.Currently, industrial part market scale is more than 14,000,000,000,000, automobile, Numerous industries such as aerospace, the consumer goods, machinery, engineering, semiconductor have demand to industrial part.
Inventor has found, lacks unified Base data platform support and uniqueness coding staff for industrial part at present Formula, to cause from the low problem of the communication efficiency of production, circulation, trade to the entire industrial chain link of using terminal.This Outside, the problem of Unified coding is also easy to cause error probability height, an object multi-code, and object etc. can not correspond more than one yard.And then nothing Method realizes industrial part product attribute data uniformity, uniqueness.
For the low problem of the data-handling efficiency for being directed to industrial part in the related technology, not yet propose at present effective Solution.
Invention content
The main purpose of the application is to provide a kind of data processing method, to solve at the data for industrial part The problem of managing inefficiency.
To achieve the goals above, according to the one side of the application, a kind of data processing method is provided, for work The product coding of industry parts.
Include according to the data processing method of the application:Determine industrial part to be encoded;According to preset rules to institute Industrial part is stated to encode and database is written;And increase preset association relationship when being encoded to the industrial part.
Further, the industrial part is encoded according to preset rules and database is written and include:According to standard class Rule does not encode the industrial part;The first tuple { standard category } is obtained after being encoded to the industrial part;According to First tuple encodes the industrial part by product category rule;The is obtained after being encoded to the industrial part Two tuples { standard category, product category };Database is written according to the second tuple coding result.
Further, the industrial part is encoded according to preset rules and database is written and include:According to standard class Rule does not encode the industrial part;The second tuple { standard category, the first production are obtained after being encoded to the industrial part Category is other };The industrial part is encoded by product category rule according to second tuple;To the industrial part Third tuple { standard category, the first product category, the second product category } is obtained after coding;It is encoded and is tied according to the third tuple Database is written in fruit.
Further, the industrial part is encoded according to preset rules and database is written and include:According to product mark Quasi-regular encodes the industrial part;Four-tuple { product standard } is obtained after being encoded to the industrial part;According to The four-tuple encodes the industrial part by product attribute rule;The is obtained after being encoded to the industrial part Five-tuple { product standard, product attribute };The industrial part is compiled by product specification rule according to the five-tuple Code;It is obtained the hexa-atomic group { product standard, product attribute, product specification } after being encoded to the industrial part;According to described Database is written in hexa-atomic group of coding result.
Further, the industrial part is encoded according to preset rules and database is written and include:According to product generation The industrial part is encoded with rule and database is written;Increase preset association relationship when being encoded to the industrial part Including:Increase product alternative incidence relation when being encoded to the industrial part;Wherein, the alternative incidence relation of the product is: The alternative relationship of product specification grade.
Further, it is determined that industrial part to be encoded includes following one or more:Fastener, hand-held tool, Handware, bearing, spring, measuring and cutting tool, transmission parts, vapour rub accessory, low-voltage electrical apparatus.
To achieve the goals above, according to the another aspect of the application, a kind of data processing equipment is provided.
Include according to the data processing equipment of the application:Determination unit, for determining industrial part to be encoded;Coding Unit, for being encoded to the industrial part according to preset rules and database being written;And associative cell, for described Industrial part increases preset association relationship when encoding.
Further, the coding unit includes:Standard category rules unit, the first tuple coding unit, classification rule Unit, the second tuple coding unit, the standard category rules unit are used for according to standard category rule to described industrial zero Part encodes;The first tuple coding unit, for obtaining the first tuple { standard category } after being encoded to the industrial part; The classification rules unit, for being encoded to the industrial part by product category rule according to first tuple;Institute The second tuple coding unit is stated, for obtaining the second tuple { standard category, product category } after being encoded to the industrial part; First writing unit, for database to be written according to the second tuple coding result.
Further, the coding unit includes:Product standard rules unit, four-tuple coding unit, product attribute Rules unit, five-tuple coding unit, product specification rule rules unit, the hexa-atomic group of coding unit, the second writing unit, institute Product standard rules unit is stated, for being encoded to the industrial part according to product standard rule;The four-tuple coding Unit, for obtaining four-tuple { product standard } after being encoded to the industrial part;The product attribute rules unit is used In being encoded to the industrial part by product attribute rule according to the four-tuple;The five-tuple coding unit, For obtaining five-tuple { product standard, product attribute } after being encoded to the industrial part;The product specification rule rule Unit, for being encoded to the industrial part by product specification rule according to the five-tuple;The hexa-atomic group of volume Code unit, for being obtained the hexa-atomic group { product standard, product attribute, product specification } after being encoded to the industrial part;The Two writing units, for database to be written according to the hexa-atomic group of coding result.
Further, the coding unit includes:The alternative rules unit of product, the associative cell include:The product Alternative rules unit, for being encoded to the industrial part according to the alternative rule of product and database being written;Alternative association is closed Be unit, for it is described the industrial part encode when increase the alternative incidence relation of product;Wherein, the alternative pass of the product Connection relationship is:The alternative relationship of product specification grade
In the embodiment of the present application, by the way of determination industrial part to be encoded, by according to preset rules pair The industrial part encodes and is written database, increases preset association relationship when being encoded to the industrial part, reaches The purpose of industrial part coding to realize the technique effect to the product Unified coding of industrial part, and then solves For the low technical problem of the data-handling efficiency of industrial part.Due in the prior art, lacking unified basis Data platform supports and uniqueness coding mode, so causing from production, circulation, trade to the entire industry chain link of using terminal The communication efficiency of section is low, and error probability is high, one object multi-code of generally existing, object more than one yard, and there are many applications for the same product not Name and call respectively say that each is difficult to link up to understand similar to the local dialect, can be by work by the data processing method in the application Industry parts are encoded and are stored, and the industrial part basic database of 10,000,000,000 ranks is formed.
Description of the drawings
The attached drawing constituted part of this application is used for providing further understanding of the present application so that the application's is other Feature, objects and advantages become more apparent upon.The illustrative examples attached drawing and its explanation of the application is for explaining the application, not Constitute the improper restriction to the application.In the accompanying drawings:
Fig. 1 is the data processing method schematic diagram according to the application first embodiment;
Fig. 2 is the data processing method schematic diagram according to the application second embodiment;
Fig. 3 is the data processing method schematic diagram according to the application 3rd embodiment;
Fig. 4 is the data processing method schematic diagram according to the application fourth embodiment;
Fig. 5 is the data processing method schematic diagram according to the 5th embodiment of the application;
Fig. 6 is the data processing equipment schematic diagram according to the application first embodiment;
Fig. 7 is the data processing equipment schematic diagram according to the application second embodiment;
Fig. 8 is the data processing equipment schematic diagram according to the application 3rd embodiment;And
Fig. 9 is the data processing equipment schematic diagram according to the application fourth embodiment.
Specific implementation mode
In order to make those skilled in the art more fully understand application scheme, below in conjunction in the embodiment of the present application Attached drawing, technical solutions in the embodiments of the present application are clearly and completely described, it is clear that described embodiment is only The embodiment of the application part, instead of all the embodiments.Based on the embodiment in the application, ordinary skill people The every other embodiment that member is obtained without making creative work should all belong to the model of the application protection It encloses.
It should be noted that term " first " in the description and claims of this application and above-mentioned attached drawing, " Two " etc. be for distinguishing similar object, without being used to describe specific sequence or precedence.It should be appreciated that using in this way Data can be interchanged in the appropriate case, so as to embodiments herein described herein.In addition, term " comprising " and " tool Have " and their any deformation, it is intended that cover it is non-exclusive include, for example, containing series of steps or unit Process, method, system, product or equipment those of are not necessarily limited to clearly to list step or unit, but may include without clear It is listing to Chu or for these processes, method, product or equipment intrinsic other steps or unit.
In this application, term "upper", "lower", "left", "right", "front", "rear", "top", "bottom", "inner", "outside", " in ", "vertical", "horizontal", " transverse direction ", the orientation or positional relationship of the instructions such as " longitudinal direction " be orientation based on ... shown in the drawings or Position relationship.These terms are not intended to limit indicated dress primarily to preferably describe the application and embodiment It sets, element or component must have particular orientation, or be constructed and operated with particular orientation.
Also, above-mentioned part term is other than it can be used to indicate that orientation or positional relationship, it is also possible to for indicating it His meaning, such as term "upper" also are likely used for indicating certain relations of dependence or connection relation in some cases.For ability For the those of ordinary skill of domain, the concrete meaning of these terms in this application can be understood as the case may be.
In addition, term " installation ", " setting ", " being equipped with ", " connection ", " connected ", " socket " shall be understood in a broad sense.For example, It may be a fixed connection, be detachably connected or monolithic construction;Can be mechanical connection, or electrical connection;It can be direct phase Even, or indirectly connected through an intermediary, or it is two connections internal between device, element or component. For those of ordinary skills, the concrete meaning of above-mentioned term in this application can be understood as the case may be.
Being applied again with fastener products in industrial part and it is related to industry and the smallest arrives aircraft greatly all to mobile phone It is the mating industry of industrial foundation to need fastener to be attached.Fastener products every country, area and industry have oneself Standard information such as (standard content include) technology, performance, application, drawings, global fastener standard commonly uses up to more than 8000 kinds Product standard and type is also above ten million.The industrial part that 1,000,000,000 ranks how are had reached to database rank stores, and is The application mainly solves the problems, such as.Mainly with fastener, preferably embodiment is used for work to the application in the following embodiments The data storage method of industry parts is described in detail and describes.Due in the prior art, lacking unified basic number According to platform and uniqueness coding mode, so causing from production, circulation, trade to the entire industrial chain link of using terminal Communication efficiency it is low, error probability is high, one object multi-code of generally existing, object more than one yard, and there are many apply alias for the same product And call, respectively say that each is difficult to link up to understand similar to the local dialect, it can be by 10,000,000,000 ranks by data processing in the application Coding and storage.
It should be noted that in the absence of conflict, the features in the embodiments and the embodiments of the present application can phase Mutually combination.The application is described in detail below with reference to the accompanying drawings and in conjunction with the embodiments.
As shown in Figure 1, this method includes following step S102 to step S106:
Step S102 determines industrial part to be encoded;
Determine that industrial part to be encoded can be hand-held tool, handware, bearing, spring, measuring and cutting tool, driving section Part, vapour rub the industrial part of the industrial parts industry such as accessory, low-voltage electrical apparatus.
Determine that industrial part to be encoded can be that industrial large database concept has integrated global fastener class product standard number According to covering countries and regions, 13 categorys of employment, 15 product lines, nearly 1,000,000,000 product specification data, nearly 2,000,000,000 drawing number According to.
Determine that industrial part to be encoded can be the industrial part stored by table.
Determine that industrial part to be encoded can be the industrial part read and write according to library.
Step S104 encodes the industrial part according to preset rules and database is written;
Preset rules include but not limited to, national standard GB, moral mark DIN, world ISO, day mark JIS, American Standard ASME, American Standard IFI, English mark BS, Europe superscript EN, Italy UNI, method mark NF, mark AS difficult to understand, Korea Spro mark the standard categories such as KS, Russia mark GOST, station symbol CNS, nonstandard W Rule.
Preset rules include but not limited to automobile QC, machinery JB, chemical industry HG, petrochemical industry SH, standard PEM, electric power DL, electronics The standard categories rules such as SJ, building JG, railway TB, aviation HB, space flight QJ, army mark GJB.
Preset rules include but not limited to bolt, stud, screw, nut, washer, baffle ring, self threading pin, wood screw, combination Part, key, pin, rivet welding class, expansion piece, rigging, other etc. product categories rule.
Preset rules include but not limited to product standard rule.For example, the product standard of GB+ serial numbers.
Preset rules include but not limited to product attribute rule.For example, diameter, material, intensity, material, surface treatment
Preset rules include but not limited to product specification rule.For example, M10x100, M10x60, M10x45.
Preset rules include but not limited to substitute standard rule.Exchange between different size, length is alternative.
In some embodiments, when being encoded to the industrial part according to preset rules and database is written, in data Accumulation layer is carried out data persistence using MySql, and is detached using data base read-write, and property when multi-user access can be improved Energy.
In some embodiments, when being encoded to the industrial part according to preset rules and database is written, in data Access layer:ADO.NET EF or SqlClient two ways can be selected to carry out data access, meet logarithm under different scenes According to the requirement of access.
In some embodiments, when being encoded to the industrial part according to preset rules and database is written, in business Service layer:All service logics are all encapsulated in application service layer, and business is externally provided in such a way that Windows communicates development platform Service, has the characteristics that high cohesion, lower coupling.
In some embodiments, when being encoded to the industrial part according to preset rules and database is written, showing Layer:The front ends such as HTML5, JQuery, CSS3, Bootstrap display technique, response type layout, compatible a variety of browsings can be selected Device.
In some embodiments, when being encoded to the industrial part according to preset rules and database is written, in client End:It supports a variety of major browsers, IE, Google, red fox browser, the equipment such as tablet, smart mobile phone can be selected to adapt to movement Change office demand.
Step S106 increases preset association relationship when being encoded to the industrial part.
It can be standard category to increase preset association relationship when being encoded to the industrial part:National standard GB, moral mark DIN, International ISO, day mark JIS, American Standard ASME, American Standard IFI, English mark BS, Europe superscript EN, Italy UNI, method mark NF, mark AS, Han Biao difficult to understand KS, Russia mark GOST, station symbol CNS, nonstandard W, automobile QC, machinery JB, chemical industry HG, petrochemical industry SH, standard PEM, electric power DL, electronics SJ, Build JG, railway TB, aviation HB, space flight QJ, army mark GJB etc. and product category:Bolt, stud, screw, nut, washer, gear The preset association relationship of circle, self threading pin, wood screw, sub-assembly, key, pin, rivet welding class, expansion piece, rigging etc..
For example, standard category:National standard GB/ product categories:Bolt.
It can be product category, product standard to increase preset association relationship when being encoded to the industrial part:Product category The incidence relation of property and product specification.
For example, product category:Bolt, nut/product standard:GB5782/ product attributes:Intensity, diameter, length/product Specification:M10x100.
It can be alternative incidence relation to increase preset association relationship when being encoded to the industrial part.
For example, half tooth hex bolts partial threads of GB5782-2000, by diameter, tooth away from, material, intensity, material, surface Processing etc. attributes all be unfolded, the association based on backstage, orderly combination displaying, user only need click can fast filtering cut It changes.Such as it selects:Diameter:M8, length:50,80,100, material:Carbon steel, steel alloy, intensity:8.8, material:35, at surface Reason:Black (quenching);By thousand weight of product, product drawing, alternative interchange standard and data correlation.
It can be seen from the above description that the present invention realizes following technique effect:
In the embodiment of the present application, by the way of determination industrial part to be encoded, by according to preset rules pair The industrial part encodes and is written database, increases preset association relationship when being encoded to the industrial part, reaches The purpose of industrial part coding to realize the technique effect to the product Unified coding of industrial part, and then solves For the low technical problem of the data-handling efficiency of industrial part.
According to embodiments of the present invention, as preferred in the present embodiment, as shown in Fig. 2, according to preset rules to the work Industry coding of parts and components is simultaneously written database and includes:
Step S202 encodes the industrial part according to standard category rule;
According to standard category rule national standard GB, moral mark DIN, world ISO, day mark JIS, American Standard ASME, American Standard IFI, Ying Biao BS, Europe superscript EN, Italy UNI, method mark NF, mark AS difficult to understand, Korea Spro mark KS, Russia mark GOST, station symbol CNS, nonstandard W, automobile QC, machinery JB, chemical industry HG, petrochemical industry SH, standard PEM, electric power DL, electronics SJ, building JG, railway TB, aviation HB, space flight QJ, army mark GJB pairs The industrial part coding.
Step S204 obtains the first tuple { standard category } after being encoded to the industrial part;
The first tuple { national standard GB ... } is obtained after coding;
Step S206 encodes the industrial part by product category rule according to first tuple;
The coding of the industrial part is carried out by product category rule based on standard category rule.Bolt, stud, spiral shell Nail, nut, washer, baffle ring, self threading pin, wood screw, sub-assembly, key, pin, rivet welding class, expansion piece, rigging etc..
Step S208 obtains the second tuple { standard category, product category } after being encoded to the industrial part;
For example, obtaining the second tuple { national standard GB+ bolts } after coding;
Database is written according to the second tuple coding result in step S210.
By the way that second tuple { national standard GB+ bolts } to be written in database, can obtain, standard category and product class Not Wei tuple two-dimensional array.
For example, { national standard GB, bolt };{ international ISO, nut }.
According to embodiments of the present invention, as preferred in the present embodiment, as shown in figure 3, according to preset rules to the work Industry coding of parts and components is simultaneously written database and includes:
Step S302 encodes the industrial part according to standard category rule;
According to standard category rule national standard GB, moral mark DIN, world ISO, day mark JIS, American Standard ASME, American Standard IFI, Ying Biao BS, Europe superscript EN, Italy UNI, method mark NF, mark AS difficult to understand, Korea Spro mark KS, Russia mark GOST, station symbol CNS, nonstandard W, automobile QC, machinery JB, chemical industry HG, petrochemical industry SH, standard PEM, electric power DL, electronics SJ, building JG, railway TB, aviation HB, space flight QJ, army mark GJB pairs The industrial part coding.
Step S304 obtains the second tuple { standard category, the first product category } after being encoded to the industrial part;
First product category can be the major class of product category.
The second tuple { national standard GB+ bolts } is obtained after coding;
Step S306 encodes the industrial part by product category rule according to second tuple;
The coding of the industrial part is carried out by product category rule based on standard category rule.Bolt, stud, spiral shell Nail, nut, washer, baffle ring, self threading pin, wood screw, sub-assembly, key, pin, rivet welding class, expansion piece, rigging etc..
Step S308, obtained after being encoded to the industrial part third tuple standard category, the first product category, the Two product categories };
Third tuple { national standard GB+ bolts+hex bolts } is obtained after coding;
Database is written according to the third tuple coding result in step S310.
It is written in database, can be obtained by the way that third tuple { national standard GB+ bolts+hex bolts } will be obtained after the coding It arrives, standard category and the two-dimensional array that product category is tuple.
In some embodiments, can also be passed through to industry by SVM polar plots including pattern shape, the pattern shape Parts modeling obtains after rendering.
For example, can also include the pattern shapes such as head dummy, rod-shaped, screw thread in pattern shape.
According to embodiments of the present invention, as preferred in the present embodiment, as shown in figure 4, according to preset rules to the work Industry coding of parts and components is simultaneously written database and includes:
Step S402 encodes the industrial part according to product standard rule;
According to the criteria for classification under all standard category rules, division obtains fastener products standard rule.Pass through product Standard rule encodes industrial part to be encoded.It uses so that industrial part has unique mark.
Step S404 obtains four-tuple { product standard } after being encoded to the industrial part;
For example, obtaining four-tuple { GB5-1976 ... GB22-1976 } after being encoded to the industrial part.
Step S406 encodes the industrial part by product attribute rule according to the four-tuple;
Increase product attribute rule on the basis of four-tuple { GB5-1976 ... GB22-1976 }.
Product attribute can be product diameter, product length, product material, product strength, product material, product surface Processing.
For example, diameter:M8, length:50,80,100, material:Carbon steel, steel alloy, intensity:8.8, material:35, at surface Reason:Black.
Step S408 obtains five-tuple { product standard, product attribute } after being encoded to the industrial part;
For example, obtaining five-tuple { GB5-1976 ... GB22-1976, diameter after being encoded to the industrial part:M8, Length:50,80,100, material:Carbon steel, steel alloy, intensity:8.8, material:35, it is surface-treated:Black }.
Step S410 encodes the industrial part by product specification rule according to the five-tuple;
The industrial part is encoded based on five-tuple { product standard, product attribute }.
Step S412 obtains the hexa-atomic group { product standard, product attribute, product rule after being encoded to the industrial part Lattice };
For example, obtaining the hexa-atomic group { GB5-1976 ... GB22-1976, diameter after being encoded to the industrial part:M8, Length:50,80,100, material:Carbon steel, steel alloy, intensity:8.8, material:35, it is surface-treated:Black, specification:M10x100}.
Database is written according to the hexa-atomic group of coding result in step S414.
According to embodiments of the present invention, as preferred in the present embodiment, as shown in figure 5, according to preset rules to the work Industry coding of parts and components is simultaneously written database and includes:
Step S502 encodes the industrial part according to the alternative rule of product and database is written;
After being encoded to the industrial part for the alternative rule of product in write-in database.It is matched from industrial big data To correspondence can general exchange substitute standard.
Increasing preset association relationship when being encoded to the industrial part includes:
Step S504 increases product alternative incidence relation when being encoded to the industrial part;
The alternative incidence relation of product is:The alternative relationship of product specification grade.
By all combing the incidence relation between each element in the database, user's selection filter condition is Product standard can be quickly found out.
Such as:Standard selects " national standard GB ", major class selection " bolt ", and system Automatic-expanding is associated " group ", group It selects " hex bolts ", is unfolded " pattern shape ", Automatic-expanding is corresponding in the critical shapes such as expansion " head dummy, rod-shaped, screw thread " Figure is clicked and may filter that corresponding product standard.
As preferred in the present embodiment, the one or more that industrial part to be encoded includes following are determined:Tightly Firmware, hand-held tool, handware, bearing, spring, measuring and cutting tool, transmission parts, vapour rub accessory, low-voltage electrical apparatus.
It should be noted that step shown in the flowchart of the accompanying drawings can be in such as a group of computer-executable instructions It is executed in computer system, although also, logical order is shown in flow charts, and it in some cases, can be with not The sequence being same as herein executes shown or described step.
According to embodiments of the present invention, a kind of device for implementing above-mentioned data processing is additionally provided, as shown in fig. 6, should Device includes:Determination unit 10, for determining industrial part to be encoded;Coding unit 20, for according to preset rules pair The industrial part encodes and database is written;And associative cell 30, increase when for being encoded to the industrial part Preset association relationship.
Determine that industrial part to be encoded can be hand-held tool, hardware in the determination unit 10 of the embodiment of the present application Part, bearing, spring, measuring and cutting tool, transmission parts, vapour rub the industrial part of the industrial parts industry such as accessory, low-voltage electrical apparatus.
Determine that industrial part to be encoded can be that industrial large database concept has integrated global fastener class product standard number According to covering countries and regions, 13 categorys of employment, 15 product lines, nearly 1,000,000,000 product specification data, nearly 2,000,000,000 drawing number According to.
Determine that industrial part to be encoded can be the industrial part stored by table.
Determine that industrial part to be encoded can be the industrial part read and write according to library.
Preset rules include but not limited in the coding unit 20 of the embodiment of the present application, national standard GB, moral mark DIN, the world ISO, day mark JIS, American Standard ASME, American Standard IFI, English mark BS, Europe superscript EN, Italy UNI, method mark NF, mark AS difficult to understand, Korea Spro mark KS, Russia Mark the standard categories such as GOST, station symbol CNS, nonstandard W rule.
Preset rules include but not limited to automobile QC, machinery JB, chemical industry HG, petrochemical industry SH, standard PEM, electric power DL, electronics The standard categories rules such as SJ, building JG, railway TB, aviation HB, space flight QJ, army mark GJB.
Preset rules include but not limited to bolt, stud, screw, nut, washer, baffle ring, self threading pin, wood screw, combination Part, key, pin, rivet welding class, expansion piece, rigging, other etc. product categories rule.
Preset rules include but not limited to product standard rule.For example, the product standard of GB+ serial numbers.
Preset rules include but not limited to product attribute rule.For example, diameter, material, intensity, material, surface treatment
Preset rules include but not limited to product specification rule.For example, M10x100, M10x60, M10x45.
Preset rules include but not limited to substitute standard rule.Exchange between different size, length is alternative.
In some embodiments, when being encoded to the industrial part according to preset rules and database is written, in data Accumulation layer is carried out data persistence using MySql, and is detached using data base read-write, and property when multi-user access can be improved Energy.
In some embodiments, when being encoded to the industrial part according to preset rules and database is written, in data Access layer:ADO.NET EF and SqlClient two ways can be selected to carry out data access, met under different scenes to data The requirement of access.
In some embodiments, when being encoded to the industrial part according to preset rules and database is written, in business Service layer:All service logics are all encapsulated in application service layer, and business is externally provided in such a way that Windows communicates development platform Service, has the characteristics that high cohesion, lower coupling.
In some embodiments, when being encoded to the industrial part according to preset rules and database is written, showing Layer:The front ends such as HTML5, JQuery, CSS3, Bootstrap display technique, response type layout, compatible a variety of browsings can be selected Device.
In some embodiments, when being encoded to the industrial part according to preset rules and database is written, in client End:It supports a variety of major browsers, IE, Google, red fox browser, the equipment such as tablet, smart mobile phone can be selected to adapt to movement Change office demand.
Increasing preset association relationship when being encoded to the industrial part in the associative cell 30 of the embodiment of the present application can To be, standard category:National standard GB, moral mark DIN, world ISO, day mark JIS, American Standard ASME, American Standard IFI, English mark BS, Europe superscript EN, Italian UNI, method mark NF, mark AS difficult to understand, Korea Spro mark KS, Russia mark GOST, station symbol CNS, nonstandard W, automobile QC, machinery JB, chemical industry HG, stone Change SH, standard PEM, electric power DL, electronics SJ, building JG, railway TB, aviation HB, space flight QJ, army mark GJB etc. and product category:Spiral shell Bolt, stud, screw, nut, washer, baffle ring, self threading pin, wood screw, sub-assembly, key, pin, rivet welding class, expansion piece, rigging Deng preset association relationship.
For example, standard category:National standard GB/ product categories:Bolt.
It can be product category, product standard to increase preset association relationship when being encoded to the industrial part:Product category The incidence relation of property and product specification.
For example, product category:Bolt, nut/product standard:GB5782/ product attributes:Intensity, diameter, length/product Specification:M10x100.
It can be alternative incidence relation to increase preset association relationship when being encoded to the industrial part.
For example, half tooth hex bolts partial threads of GB5782-2000, by diameter, tooth away from, material, intensity, material, surface Processing etc. attributes all be unfolded, the association based on backstage, orderly combination displaying, user only need click can fast filtering cut It changes.Such as it selects:Diameter:M8, length:50,80,100, material:Carbon steel, steel alloy, intensity:8.8, material:35, at surface Reason:Black (quenching);By thousand weight of product, product drawing, alternative interchange standard and data correlation.
According to embodiments of the present invention, as preferred in the present embodiment, as shown in fig. 7, the coding unit 20 includes:Mark Quasi- classification rules unit 201, the first tuple coding unit 202, classification rules unit 203, the second tuple coding unit 204, institute Standard category rules unit 201 is stated, for being encoded to the industrial part according to standard category rule;First tuple is compiled Code unit 202, for obtaining the first tuple { standard category } after being encoded to the industrial part;The classification rules unit 203, for being encoded to the industrial part by product category rule according to first tuple;The second tuple coding Unit 204, for obtaining the second tuple { standard category, product category } after being encoded to the industrial part;First write-in is single Member 212, for database to be written according to the second tuple coding result.
According to standard category rule national standard GB, moral mark DIN, state in the standard category rules unit 201 of the embodiment of the present application Border ISO, day mark JIS, American Standard ASME, American Standard IFI, English mark BS, Europe superscript EN, Italy UNI, method mark NF, mark AS difficult to understand, Korea Spro's mark KS, GOST, station symbol CNS, nonstandard W, automobile QC, machinery JB, chemical industry HG, petrochemical industry SH, standard PEM, electric power DL, electronics SJ, building are marked by Russia JG, railway TB, aviation HB, space flight QJ, army mark GJB encode the industrial part.
The first tuple { national standard GB ... } is obtained after being encoded in the first tuple coding unit 202 of the embodiment of the present application.
Institute is carried out by product category rule based on standard category rule in the classification rules unit 203 of the embodiment of the present application State the coding of industrial part.Bolt, stud, screw, nut, washer, baffle ring, self threading pin, wood screw, sub-assembly, key, pin, Rivet welds class, expansion piece, rigging etc..
The second tuple { national standard GB+ bolts } is obtained after being encoded in the second tuple coding unit 204 of the embodiment of the present application.
By the way that number is written in second tuple { national standard GB+ bolts } in first writing unit 212 of the embodiment of the present application It according in library, can obtain, standard category and the two-dimensional array that product category is tuple.
For example, { national standard GB, bolt };{ international ISO, nut }.
According to embodiments of the present invention, as preferred in the present embodiment, as shown in figure 8, the coding unit 20 includes:Production Product standard rule unit 205, four-tuple coding unit 206, product attribute rules unit 207, five-tuple coding unit 208, product specification rule rules unit 209, the hexa-atomic group of coding unit 210, the second writing unit 211, the product standard rule Then unit 205, for being encoded to the industrial part according to product standard rule;The four-tuple coding unit 206 is used Four-tuple { product standard } is obtained after being encoded to the industrial part;The product attribute rules unit 207 is used for root The industrial part is encoded by product attribute rule according to the four-tuple;The five-tuple coding unit 208 is used Five-tuple { product standard, product attribute } is obtained after being encoded to the industrial part;The product specification rule rule is single Member 209, for being encoded to the industrial part by product specification rule according to the five-tuple;The hexa-atomic group of volume Code unit 210, for being obtained the hexa-atomic group { product standard, product attribute, product specification } after being encoded to the industrial part; Second writing unit 211, for database to be written according to the hexa-atomic group of coding result.
The embodiment of the present application product standard rules unit 205 according to the criteria for classification under all standard category rules, Division obtains fastener products standard rule.Industrial part to be encoded is encoded by product standard rule.It uses So that industrial part has unique mark.
Four-tuple is obtained after the four-tuple coding unit 206 of the embodiment of the present application encodes the industrial part {GB5-1976…GB22-1976}。
Increase product attribute rule on the basis of four-tuple { GB5-1976 ... GB22-1976 }.
Can be product diameter in 207 product attribute of product attribute rules unit of the embodiment of the present application, product length, Product material, product strength, product material, product surface processing.
For example, diameter:M8, length:50,80,100, material:Carbon steel, steel alloy, intensity:8.8, material:35, at surface Reason:Black.
The industrial part is encoded based on five-tuple { product standard, product attribute }.
Five-tuple is obtained after the hexa-atomic group of coding unit 210 of the embodiment of the present application encodes the industrial part { GB5-1976 ... GB22-1976, diameter:M8, length:50,80,100, material:Carbon steel, steel alloy, intensity:8.8, material: 35, it is surface-treated:Black }.
Five-tuple coding unit 208 is based on five-tuple { product standard, product attribute } and is compiled to the industrial part Code.
Product specification advises rules unit 209 and is based on five-tuple { product standard, product attribute } to the industrial part Coding.
The hexa-atomic group of coding unit 210 obtains the hexa-atomic group { GB5-1976 ... GB22- after being encoded to the industrial part 1976, diameter:M8, length:50,80,100, material:Carbon steel, steel alloy, intensity:8.8, material:35, it is surface-treated:Black, Specification:M10x100}.
According to embodiments of the present invention, as preferred in the present embodiment, as shown in figure 9, the coding unit 20 includes:Production The alternative rules unit 212 of product, the associative cell 30 include:Alternative incidence relation unit 301, the alternative rules unit of product 212, for being encoded to the industrial part according to the alternative rule of product and database being written;The alternative incidence relation unit 301, for it is described the industrial part encode when increase the alternative incidence relation of product;Wherein, the alternative association of the product Relationship is:The alternative relationship of product specification grade.
It is alternative regular to industrial part volume for product in the alternative rules unit 212 of product of the embodiment of the present application After code in write-in database.Be matched to from industrial big data correspondence can general exchange substitute standard.
The alternative incidence relation of product is described in the alternative incidence relation unit 301 of the embodiment of the present application:Product is advised The alternative relationship of lattice grade.
By all combing the incidence relation between each element in the database, user's selection filter condition is Product standard can be quickly found out.
Such as:Standard selects " national standard GB ", major class selection " bolt ", and system Automatic-expanding is associated " group ", group It selects " hex bolts ", is unfolded " pattern shape ", Automatic-expanding is corresponding in the critical shapes such as expansion " head dummy, rod-shaped, screw thread " Figure is clicked and may filter that corresponding product standard.
As preferred in the present embodiment, the one or more that industrial part to be encoded includes following are determined:Tightly Firmware, hand-held tool, handware, bearing, spring, measuring and cutting tool, transmission parts, vapour rub accessory, low-voltage electrical apparatus.
Obviously, those skilled in the art should be understood that each module of the above invention or each step can be with general Computing device realize that they can be concentrated on a single computing device, or be distributed in multiple computing devices and formed Network on, optionally, they can be realized with the program code that computing device can perform, it is thus possible to which they are stored Be performed by computing device in the storage device, either they are fabricated to each integrated circuit modules or by they In multiple modules or step be fabricated to single integrated circuit module to realize.In this way, the present invention is not limited to any specific Hardware and software combines.
The foregoing is merely the preferred embodiments of the application, are not intended to limit this application, for the skill of this field For art personnel, the application can have various modifications and variations.Within the spirit and principles of this application, any made by repair Change, equivalent replacement, improvement etc., should be included within the protection domain of the application.

Claims (10)

1. a kind of data processing method, which is characterized in that it is used for the product coding to industrial part, the method includes:
Determine industrial part to be encoded;
The industrial part is encoded according to preset rules and database is written;And
Increase preset association relationship when being encoded to the industrial part.
2. data processing method according to claim 1, which is characterized in that according to preset rules to the industrial part It encodes and database is written and include:
The industrial part is encoded according to standard category rule;
The first tuple { standard category } is obtained after being encoded to the industrial part;
The industrial part is encoded by product category rule according to first tuple;
The second tuple { standard category, product category } is obtained after being encoded to the industrial part;
Database is written according to the second tuple coding result.
3. data processing method according to claim 1, which is characterized in that according to preset rules to the industrial part It encodes and database is written and include:
The industrial part is encoded according to standard category rule;
The second tuple { standard category, the first product category } is obtained after being encoded to the industrial part;
The industrial part is encoded by product category rule according to second tuple;
Third tuple { standard category, the first product category, the second product category } is obtained after being encoded to the industrial part;
Database is written according to the third tuple coding result.
4. data processing method according to claim 1, which is characterized in that according to preset rules to the industrial part It encodes and database is written and include:
The industrial part is encoded according to product standard rule;
Four-tuple { product standard } is obtained after being encoded to the industrial part;
The industrial part is encoded by product attribute rule according to the four-tuple;
Five-tuple { product standard, product attribute } is obtained after being encoded to the industrial part;
The industrial part is encoded by product specification rule according to the five-tuple;
It is obtained the hexa-atomic group { product standard, product attribute, product specification } after being encoded to the industrial part;
Database is written according to the hexa-atomic group of coding result.
5. data processing method according to claim 1, which is characterized in that
The industrial part is encoded according to preset rules and database is written and includes:
The industrial part is encoded according to product alternative rule and database is written;
Increasing preset association relationship when being encoded to the industrial part includes:
Increase product alternative incidence relation when being encoded to the industrial part;
Wherein, the alternative incidence relation of the product is:The alternative relationship of product specification grade.
6. data processing method according to claim 1, which is characterized in that determine that industrial part to be encoded includes such as Under one or more:
Fastener, hand-held tool, handware, bearing, spring, measuring and cutting tool, transmission parts, vapour rub accessory, low-voltage electrical apparatus.
7. a kind of data processing equipment, which is characterized in that including:
Determination unit, for determining industrial part to be encoded;
Coding unit, for being encoded to the industrial part according to preset rules and database being written;And
Associative cell increases preset association relationship when for being encoded to the industrial part.
8. data processing equipment according to claim 1, which is characterized in that the coding unit includes:Standard category is advised Then unit, the first tuple coding unit, classification rules unit, the second tuple coding unit,
The standard category rules unit, for being encoded to the industrial part according to standard category rule;
The first tuple coding unit, for obtaining the first tuple { standard category } after being encoded to the industrial part;
The classification rules unit, for being compiled to the industrial part by product category rule according to first tuple Code;
The second tuple coding unit, for obtaining the second tuple { standard category, product after being encoded to the industrial part Classification };
First writing unit, for database to be written according to the second tuple coding result.
9. data processing equipment according to claim 1, which is characterized in that the coding unit includes:Product standard is advised Then unit, four-tuple coding unit, product attribute rules unit, five-tuple coding unit, product specification rule rules unit, The hexa-atomic group of coding unit, the second writing unit,
The product standard rules unit, for being encoded to the industrial part according to product standard rule;
The four-tuple coding unit, for obtaining four-tuple { product standard } after being encoded to the industrial part;
The product attribute rules unit is used for according to the four-tuple through product attribute rule to the industrial part Coding;
The five-tuple coding unit, for obtaining five-tuple { product standard, product after being encoded to the industrial part Attribute };
The product specification advises rules unit, is used for according to the five-tuple through product specification rule to described industrial zero Part encodes;
The hexa-atomic group of coding unit, for obtaining the hexa-atomic group { product standard, product after being encoded to the industrial part Attribute, product specification };
Second writing unit, for database to be written according to the hexa-atomic group of coding result.
10. data processing equipment according to claim 1, which is characterized in that the coding unit includes:The alternative rule of product Then unit, the associative cell include:Alternative incidence relation unit,
The alternative rules unit of product, for being encoded to the industrial part according to the alternative rule of product and data being written Library;
The alternative incidence relation unit, for it is described the industrial part encode when increase the alternative incidence relation of product; Wherein, the alternative incidence relation of the product is:The alternative relationship of product specification grade.
CN201810096829.4A 2018-01-31 2018-01-31 Data processing method and device Pending CN108595465A (en)

Priority Applications (2)

Application Number Priority Date Filing Date Title
CN201810096829.4A CN108595465A (en) 2018-01-31 2018-01-31 Data processing method and device
PCT/CN2019/073729 WO2019149193A1 (en) 2018-01-31 2019-01-29 Data processing method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810096829.4A CN108595465A (en) 2018-01-31 2018-01-31 Data processing method and device

Publications (1)

Publication Number Publication Date
CN108595465A true CN108595465A (en) 2018-09-28

Family

ID=63608510

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810096829.4A Pending CN108595465A (en) 2018-01-31 2018-01-31 Data processing method and device

Country Status (2)

Country Link
CN (1) CN108595465A (en)
WO (1) WO2019149193A1 (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2019149193A1 (en) * 2018-01-31 2019-08-08 杭州优工品科技有限公司 Data processing method and device

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103390223A (en) * 2013-07-31 2013-11-13 西安互易计算机科技有限公司 Purchase-sell-stock enterprise management system based on standard component industrial encoding
CN106056276A (en) * 2016-05-23 2016-10-26 国家电网公司 Material information management method and application platform
WO2017097377A1 (en) * 2015-12-11 2017-06-15 Abb Schweiz Ag An industrial robot and a method for controlling the robot to automatically select which program code to be executed next
CN107122484A (en) * 2017-05-08 2017-09-01 明觉科技(北京)有限公司 Parts information querying method and system

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20130031011A1 (en) * 2010-09-20 2013-01-31 Kps,Llc Building Rating System
US20140297649A1 (en) * 2011-11-02 2014-10-02 Rahinah Ibrahim Method and System for Providing and Managing Information of Prefabricated Construction Components between Manufacturers and Architects
CN105678610A (en) * 2016-03-01 2016-06-15 成都市泰象网络科技有限公司 Management system and method for automobile spare part electronic merchant transaction
CN107491609A (en) * 2017-08-22 2017-12-19 云南电网有限责任公司普洱供电局 A kind of substation equipment visualizes real-time dynamic folding display methods
CN108595465A (en) * 2018-01-31 2018-09-28 杭州优工品科技有限公司 Data processing method and device

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103390223A (en) * 2013-07-31 2013-11-13 西安互易计算机科技有限公司 Purchase-sell-stock enterprise management system based on standard component industrial encoding
WO2017097377A1 (en) * 2015-12-11 2017-06-15 Abb Schweiz Ag An industrial robot and a method for controlling the robot to automatically select which program code to be executed next
CN106056276A (en) * 2016-05-23 2016-10-26 国家电网公司 Material information management method and application platform
CN107122484A (en) * 2017-05-08 2017-09-01 明觉科技(北京)有限公司 Parts information querying method and system

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2019149193A1 (en) * 2018-01-31 2019-08-08 杭州优工品科技有限公司 Data processing method and device

Also Published As

Publication number Publication date
WO2019149193A1 (en) 2019-08-08

Similar Documents

Publication Publication Date Title
Hanson The rise of middle kingdoms: Emerging economies in global trade
Fujimoto Architecture-based comparative advantage in Japan and Asia
CN106789898B (en) Remote data transmission terminal, system and coding and decoding method thereof
CN104751342B (en) It is a kind of for tracing the merchandise news decoding method of commodity
CN107833117A (en) A kind of Bayes's personalized ordering for considering label information recommends method
US9442949B2 (en) System and method for compressing data in a database
CN108596291A (en) Label data generation method and device
CN104008485A (en) Intelligent order generation device and method
CN108595465A (en) Data processing method and device
CN104408189A (en) Keyword ranking display method and device
Rostamzadeh et al. Identification of Factors Affecting on Credit Risk in the Iran Banking Industry of Iran Using Stress Test
Wang et al. Low-carbon development via greening global value chains: a case study of Belarus
Argus et al. Data quality as an antecedent for commercial viability of circular economy business models: a case study
CN106991580A (en) Pricing method of the asymmetric manufacturer with combined recovery business under monopolization take-back model
CN108334600A (en) Data storage method and device for industrial part
Kovalov et al. Methods of evaluating digitization and digital transformation of business and economy: the experience of OECD and EU countries
CN106997490A (en) Asymmetric manufacturer reclaims pricing method of the business under competition take-back model with competition
Fukao et al. Why has the border effect in the Japanese market declined? The role of business networks in East Asia
CN105117385A (en) Method and system for extracting public opinion information based on matrix calculation
CN104766217A (en) Commodity information coding method and commodity information decoding method used in interference process
CN107808328A (en) A kind of digital product markets service system based on internet
CN108228890A (en) The data processing method and device graphically retrieved
Zhao et al. China's World
Williams Textile Mills of South West England
Wu et al. The electricity sector leads energy market integration in East Asia: Introduction

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20180928