WO2019149193A1 - 数据处理方法及装置 - Google Patents

数据处理方法及装置 Download PDF

Info

Publication number
WO2019149193A1
WO2019149193A1 PCT/CN2019/073729 CN2019073729W WO2019149193A1 WO 2019149193 A1 WO2019149193 A1 WO 2019149193A1 CN 2019073729 W CN2019073729 W CN 2019073729W WO 2019149193 A1 WO2019149193 A1 WO 2019149193A1
Authority
WO
WIPO (PCT)
Prior art keywords
product
tuple
encoding
industrial
standard
Prior art date
Application number
PCT/CN2019/073729
Other languages
English (en)
French (fr)
Inventor
林振峰
Original Assignee
杭州优工品科技有限公司
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 杭州优工品科技有限公司 filed Critical 杭州优工品科技有限公司
Publication of WO2019149193A1 publication Critical patent/WO2019149193A1/zh

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00—Administration; Management
    • G06Q10/08—Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087—Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
    • G06Q50/04—Manufacturing

Definitions

  • the present application relates to the field of data processing, and in particular to a data processing method and apparatus.
  • Industrial parts belong to the grassroots of the manufacturing industry. According to the difficulty of processing, they are divided into raw materials, industrial parts, assembly/assembly, core module layer and system integration from low to high. At present, the industrial parts market has a scale of more than 14 trillion yuan, and many industries such as automobiles, aerospace, consumer goods, machinery, engineering, and semiconductors have demand for industrial parts.
  • the lack of unified coding is also likely to cause a high probability of error, a multi-code, a multi-object, and so on.
  • the uniformity and uniqueness of the attribute data of industrial parts and components cannot be realized.
  • the main object of the present application is to provide a data processing method to solve the problem of inefficient data processing for industrial components.
  • the data processing method includes: determining an industrial component to be encoded; encoding and writing the industrial component according to a preset rule; and adding a preset association relationship when encoding the industrial component.
  • encoding and writing the industrial component according to a preset rule includes: encoding the industrial component according to a standard category rule; and encoding the industrial component to obtain a first tuple ⁇ standard category ⁇ ; Encoding the industrial component according to the first tuple by a product category rule; encoding the industrial component to obtain a second tuple ⁇ standard category, product category ⁇ ; writing according to the second tuple encoding result Into the database.
  • encoding and writing the industrial component according to a preset rule includes: encoding the industrial component according to a standard category rule; and encoding the industrial component to obtain a second tuple ⁇ standard category, a product category ⁇ ; encoding the industrial component according to the second tuple by a product category rule; encoding the industrial component to obtain a third tuple ⁇ standard category, first product category, second product category ⁇ ; written to the database according to the third tuple encoding result.
  • encoding and writing the industrial component according to a preset rule includes: encoding the industrial component according to a product standard rule; and encoding the industrial component to obtain a fourth component ⁇ product standard ⁇ ; Encoding the industrial component according to the fourth tuple by a product attribute rule; encoding the industrial component to obtain a fifth tuple ⁇ product standard, product attribute ⁇ ; passing the product specification according to the fifth tuple
  • the code encodes the industrial component; after encoding the industrial component, a sixth tuple ⁇ product standard, product attribute, product specification ⁇ is obtained; and the sixth tuple encoding result is written into the database.
  • encoding and writing the industrial component according to a preset rule includes: encoding and writing the industrial component according to a product substitution rule; and adding a preset association relationship when encoding the industrial component includes : adding a product substitution relationship when coding the industrial component; wherein the product substitution relationship is: a product specification level substitution relationship.
  • the industrial components to be encoded include one or more of the following: fasteners, hand tools, hardware, bearings, springs, gauge cutting tools, transmission components, automobile and motorcycle accessories, low-voltage electrical appliances.
  • a data processing apparatus is provided.
  • the data processing apparatus includes: a determining unit for determining an industrial component to be encoded; a coding unit for encoding and writing the industrial component according to a preset rule; and an associating unit for The preset relationship is added when the industrial component is coded.
  • the coding unit includes: a standard class rule unit, a first tuple coding unit, a class rule unit, and a second tuple coding unit, where the standard class rule unit is configured to perform the industrial zero according to a standard class rule.
  • a first tuple encoding unit configured to encode the industrial component to obtain a first tuple ⁇ standard category ⁇
  • the category rule unit configured to pass the product category according to the first tuple a rule encoding the industrial component
  • the second tuple encoding unit configured to encode the industrial component to obtain a second tuple ⁇ standard category, product category ⁇
  • a first writing unit configured to The second tuple encoded result is written to the database.
  • the coding unit includes: a product standard rule unit, a fourth tuple coding unit, a product attribute rule unit, a fifth tuple coding unit, a product specification rule unit, a sixth tuple coding unit, and a second write a unit, the product standard rule unit, for encoding the industrial component according to a product standard rule;
  • the fourth tuple coding unit configured to encode the industrial component to obtain a fourth tuple ⁇ product standard a product attribute rule unit, configured to encode the industrial component according to the fourth tuple by a product attribute rule;
  • the fifth tuple coding unit is configured to obtain the industrial component after encoding a fifth tuple ⁇ product standard, product attribute ⁇ ;
  • the product specification rule unit for encoding the industrial component according to the fifth tuple by a product specification rule;
  • the sixth tuple coding unit For encoding the industrial component to obtain a sixth tuple ⁇ product standard, product attribute, product specification ⁇ ;
  • the coding unit includes: a product substitution rule unit
  • the association unit includes: the product substitution rule unit, configured to encode and write the industrial component according to a product substitution rule; and substitute a relationship unit, And the product substitution relationship is added when the coding of the industrial component is used; wherein the product substitution relationship is: a product specification level substitution relationship.
  • the method for determining the industrial component to be encoded is adopted, and the industrial component is coded and written into the database according to a preset rule, and the preset association relationship is added when the industrial component is coded.
  • the purpose of coding industrial parts has achieved the technical effect of unified coding of industrial parts, and solved the technical problem of inefficient data processing for industrial parts.
  • the lack of a unified basic data platform support and unique coding method has resulted in low communication efficiency from the production, circulation, trade to the use of the entire industrial chain, and the probability of error is high, and there is a common problem.
  • FIG. 1 is a schematic diagram of a data processing method according to a first embodiment of the present application.
  • FIG. 2 is a schematic diagram of a data processing method according to a second embodiment of the present application.
  • FIG. 3 is a schematic diagram of a data processing method according to a third embodiment of the present application.
  • FIG. 4 is a schematic diagram of a data processing method according to a fourth embodiment of the present application.
  • FIG. 5 is a schematic diagram of a data processing method according to a fifth embodiment of the present application.
  • FIG. 6 is a schematic diagram of a data processing apparatus according to a first embodiment of the present application.
  • FIG. 7 is a schematic diagram of a data processing apparatus according to a second embodiment of the present application.
  • FIG. 8 is a schematic diagram of a data processing apparatus according to a third embodiment of the present application.
  • FIG. 9 is a schematic diagram of a data processing apparatus according to a fourth embodiment of the present application.
  • the above partial terms may be used to indicate other meanings in addition to the orientation or positional relationship, for example, the term “upper” may also be used to indicate a certain dependency or connection relationship in some cases.
  • the specific meaning of these terms in this application can be understood on a case-by-case basis.
  • installation In addition, the terms “installation,” “set,” “set,” “connected,” “connected,” and “socketed” are to be interpreted broadly. For example, it may be a fixed connection, a detachable connection, or a one-piece construction; it may be a mechanical connection, or an electrical connection; it may be directly connected, or indirectly connected through an intermediate medium, or it may be two devices, components or components. Internal communication.
  • installation For those of ordinary skill in the art, the specific meanings of the above terms in the present application can be understood on a case-by-case basis.
  • fastener products have their own standards in various countries, regions and industries (standard content includes technology, performance, applications, drawings and other information), the global fastener standards of more than 8,000, commonly used product specifications and models are also more than 10 million. How to store industrial components with a database level of 1 billion is the main problem to be solved in this application.
  • the method includes the following steps S102 to S106:
  • Step S102 determining an industrial component to be encoded
  • the industrial parts to be coded can be industrial parts such as hand tools, hardware, bearings, springs, measuring tools, transmission parts, automobile and motorcycle parts, low-voltage electrical appliances and other industrial parts industries.
  • the industrial parts to be coded can be the industrial large database integrated global fastener products standard data, covering countries and regions, 13 industry categories, 15 product series, nearly 1 billion product specification data, nearly 2 billion drawings and data .
  • the industrial parts to be coded may be industrial parts stored through a watch.
  • the industrial parts to be coded can be industrial parts of the database.
  • Step S104 encoding the industrial component according to a preset rule and writing the database
  • Presupposition rules include, but are not limited to, national standard GB, German standard DIN, international ISO, Japanese standard JIS, American standard ASME, American standard IFI, British standard BS, European standard EN, Italian UNI, French standard NF, Austrian standard AS, Korean Standard category rules such as KS, Russian standard GOST, Taiwan standard CNS, non-standard W.
  • Predetermined rules include, but are not limited to, automotive QC, mechanical JB, chemical HG, petrochemical SH, standard PEM, electric DL, electronic SJ, building JG, railway TB, aviation HB, aerospace QJ, military standard GJB and other standard category rules.
  • Preset rules include, but are not limited to, bolts, studs, screws, nuts, washers, retaining rings, self-tapping screws, wood screws, assemblies, keys, pins, rivet welds, expansions, rigging, and other product categories. rule.
  • Preset rules include, but are not limited to, product standard rules.
  • product standard rules For example, the product standard of GB+ serial number.
  • Preset rules include, but are not limited to, product attribute rules. For example, diameter, material, strength, material, surface treatment.
  • Preset rules include, but are not limited to, product specification rules. For example, M10x100, M10x60, M10x45.
  • Preset rules include, but are not limited to, alternative standard rules. Interchange substitution between different sizes and lengths.
  • the data storage layer uses MySql for data persistence and uses database read-write separation to improve performance when accessing multiple users.
  • the industrial component when the industrial component is encoded and written into the database according to a preset rule, in the data access layer: ADO.NET EF or SqlClient can be used for data access to meet data access in different scenarios. Requirements.
  • the business service layer when the industrial component is encoded and written into a database according to a preset rule, at the business service layer: all business logic is encapsulated in the business service layer, and the business service is provided in the form of a Windows communication development platform. It has the characteristics of high cohesion and low coupling.
  • the presentation layer front end display technology such as HTML5, JQuery, CSS3, Bootstrap, etc., responsive layout, compatible with various browsers .
  • the client when the industrial component is encoded and written into the database according to a preset rule, the client: supports a variety of mainstream browsers, and can select IE, Google, Firefox, tablet, smart phone, etc. Adapt to the needs of mobile office.
  • Step S106 adding a preset association relationship when encoding the industrial component.
  • Standard categories GB GB, German standard DIN, International ISO, Japanese standard JIS, American standard ASME, American standard IFI, British standard BS, European standard EN, Italy UNI, French Standard NF, Austrian Standard AS, Korean Standard KS, Russian Standard GOST, Taiwan Standard CNS, Non-standard W, Automobile QC, Machinery JB, Chemical HG, Petrochemical SH, Standard PEM, Power DL, Electronic SJ, Building JG, Railway TB, Aviation HB, Aerospace QJ, Military Standard GJB, etc. and product categories: bolts, studs, screws, nuts, washers, retaining rings, self-tapping screws, wood screws, assemblies, keys, pins, rivets, welding, expansion Preset association of pieces, rigging, etc.
  • the standard category GB GB / product category: bolts.
  • Adding a preset association relationship when encoding the industrial component may be a product category, a product standard: a product attribute, and an association relationship of product specifications.
  • product category Bolt, Nut / Product Standard: GB5782 / Product Attributes: Strength, Diameter, Length / Product Specifications: M10x100.
  • Adding a preset association relationship when encoding the industrial component may be a substitute association relationship.
  • the GB5782-2000 half-tooth hex bolt part of the thread, the diameter, tooth distance, material, strength, material, surface treatment and other attributes are all expanded, based on the background of the association, an orderly combination display, users only need to click to quickly filter Switch.
  • the method for determining the industrial component to be encoded is adopted, and the industrial component is coded and written into the database according to a preset rule, and the preset association relationship is added when the industrial component is coded.
  • the purpose of coding industrial parts has achieved the technical effect of unified coding of industrial parts, and solved the technical problem of inefficient data processing for industrial parts.
  • encoding and writing the industrial component according to a preset rule includes:
  • Step S202 encoding the industrial component according to a standard category rule
  • German standard DIN international ISO
  • Japanese standard JIS American standard ASME
  • American standard IFI British standard BS
  • European standard EN Italian UNI
  • French standard NF Austrian standard AS
  • Korean standard KS Korean standard KS
  • Russia Standard GOST Taiwan Standard CNS
  • Non-standard W Automotive QC
  • Machinery JB Chemical HG
  • Petrochemical SH Standard PEM
  • Power DL Electronic SJ
  • Building JG Railway TB
  • Aviation HB Aerospace QJ
  • Military Standard GJB Industrial parts coding United States Standard SJB
  • Step S204 encoding the industrial component to obtain a first tuple ⁇ standard category ⁇ ;
  • Step S206 encoding the industrial component according to the first tuple by a product category rule
  • the coding of the industrial parts is carried out by product category rules based on standard category rules. Bolts, studs, screws, nuts, washers, retaining rings, self-tapping screws, wood screws, assemblies, keys, pins, rivet welding, expansion parts, rigging, etc.
  • Step S208 encoding the industrial component to obtain a second tuple ⁇ standard category, product category ⁇ ;
  • Step S210 Write the database according to the second tuple encoding result.
  • the standard category and the product category are two-dimensional arrays of tuples.
  • encoding and writing the industrial component according to a preset rule includes:
  • Step S302 encoding the industrial component according to a standard category rule
  • German standard DIN international ISO
  • Japanese standard JIS American standard ASME
  • American standard IFI British standard BS
  • European standard EN Italian UNI
  • French standard NF Austrian standard AS
  • Korean standard KS Korean standard KS
  • Russia Standard GOST Taiwan Standard CNS
  • Non-standard W Automotive QC
  • Machinery JB Chemical HG
  • Petrochemical SH Standard PEM
  • Power DL Electronic SJ
  • Building JG Railway TB
  • Aviation HB Aerospace QJ
  • Military Standard GJB Industrial parts coding United States Standard SJB
  • Step S304 encoding the industrial component to obtain a second tuple ⁇ standard category, first product category ⁇ ;
  • the first product category can be a broad category of product categories.
  • Step S306 encoding the industrial component according to the second tuple by a product category rule
  • the coding of the industrial parts is carried out by product category rules based on standard category rules. Bolts, studs, screws, nuts, washers, retaining rings, self-tapping screws, wood screws, assemblies, keys, pins, rivet welding, expansion parts, rigging, etc.
  • Step S308 encoding the industrial component to obtain a third tuple ⁇ standard category, first product category, second product category ⁇ ;
  • Step S310 writing the database according to the third tuple encoding result.
  • the standard category and the product category are two-dimensional arrays of tuples.
  • a pattern shape may also be included, which is obtained by modeling an industrial component by SVM vector graphics.
  • the shape of the pattern may also include a shape of a head, a rod, a thread, and the like.
  • encoding and writing the industrial component according to a preset rule includes:
  • Step S402 encoding the industrial component according to a product standard rule
  • the standard rules for fastener products are obtained.
  • the industrial parts to be coded are coded by the product standard rules. Use makes industrial parts uniquely labeled.
  • Step S404 encoding the industrial component to obtain a fourth tuple ⁇ product standard ⁇ ;
  • the industrial component is encoded to obtain a fourth tuple ⁇ GB5-1976...GB22-1976 ⁇ .
  • Step S406 encoding the industrial component according to the fourth tuple by a product attribute rule
  • Product attributes can be, product diameter, product length, product material, product strength, product materials, product surface treatment.
  • diameter M8, length: 50, 80, 100, material: carbon steel, alloy steel, strength: 8.8, material: 35, surface treatment: black.
  • Step S408 encoding the industrial component to obtain a fifth tuple ⁇ product standard, product attribute ⁇ ;
  • the fifth component is obtained after encoding the industrial parts ⁇ GB5-1976...GB22-1976, diameter: M8, length: 50, 80, 100, material: carbon steel, alloy steel, strength: 8.8, material: 35, surface treatment: black ⁇ .
  • Step S410 encoding the industrial component according to the fifth tuple by a product specification rule
  • the industrial parts are coded based on a fifth tuple ⁇ product standard, product attribute ⁇ .
  • Step S412 encoding the industrial component to obtain a sixth tuple ⁇ product standard, product attribute, product specification ⁇ ;
  • the sixth element is obtained ⁇ GB5-1976...GB22-1976, diameter: M8, length: 50, 80, 100, material: carbon steel, alloy steel, strength: 8.8, material: 35, surface treatment: black, specifications: M10x100 ⁇ .
  • Step S414 writing the database according to the sixth tuple encoding result.
  • encoding and writing the industrial component according to a preset rule includes:
  • Step S502 encoding and writing the industrial component according to a product substitution rule into a database
  • the industrial parts are coded and written into the database for product substitution rules. Matching from industrial big data to surrogate standards that can be universally interchanged.
  • Adding a preset association relationship when encoding the industrial component includes:
  • Step S504 adding a product substitution relationship when encoding the industrial component
  • the product substitution relationship is: product specification level substitution relationship.
  • the user can quickly find the product standard by selecting the filter criteria.
  • the standard selects “national standard GB”, the large category selects “bolt”, the system automatically expands the associated “small class”, the small class selects “hexagon bolt”, expands “pattern shape”, expands “head shape, rod shape, thread "Automatically expand the corresponding graphics on the key shapes, click to filter the corresponding product standards.
  • the industrial component to be encoded is determined to include one or more of the following: fasteners, hand tools, hardware, bearings, springs, measuring tools, transmission components, automobile and motorcycle accessories, low-voltage electrical appliances. .
  • the apparatus includes: a determining unit 10 for determining an industrial component to be encoded; and an encoding unit 20 for The industrial component is encoded and written into the database according to a preset rule; and the associating unit 30 is configured to add a preset association relationship when encoding the industrial component.
  • the industrial parts to be encoded may be industrial parts of industrial parts industries such as hand tools, hardware, bearings, springs, measuring tools, transmission parts, automobile and motorcycle parts, low-voltage electrical appliances, and the like. .
  • the industrial parts to be coded can be the industrial large database integrated global fastener products standard data, covering countries and regions, 13 industry categories, 15 product series, nearly 1 billion product specification data, nearly 2 billion drawings and data .
  • the industrial parts to be coded may be industrial parts stored through a watch.
  • the industrial parts to be coded can be industrial parts of the database.
  • the preset rules in the coding unit 20 of the embodiment of the present application include, but are not limited to, the national standard GB, the German standard DIN, the international ISO, the Japanese standard JIS, the American standard ASME, the American standard IFI, the British standard BS, the European standard EN, the Italian UNI Standard classification rules such as the standard NF, the Austrian standard AS, the Korean standard KS, the Russian standard GOST, the Taiwan standard CNS, and the non-standard W.
  • Predetermined rules include, but are not limited to, automotive QC, mechanical JB, chemical HG, petrochemical SH, standard PEM, electric DL, electronic SJ, building JG, railway TB, aviation HB, aerospace QJ, military standard GJB and other standard category rules.
  • Preset rules include, but are not limited to, bolts, studs, screws, nuts, washers, retaining rings, self-tapping screws, wood screws, assemblies, keys, pins, rivet welds, expansions, rigging, and other product categories. rule.
  • Preset rules include, but are not limited to, product standard rules.
  • product standard rules For example, the product standard of GB+ serial number.
  • Preset rules include, but are not limited to, product attribute rules. For example, diameter, material, strength, material, surface treatment
  • Preset rules include, but are not limited to, product specification rules. For example, M10x100, M10x60, M10x45.
  • Preset rules include, but are not limited to, alternative standard rules. Interchange substitution between different sizes and lengths.
  • the industrial component when the industrial component is encoded and written into a database according to a preset rule, data is used in the data storage layer, and data is persisted using MySql, and the database is read and written separated, thereby improving performance when accessing multiple users. .
  • the industrial component when the industrial component is encoded and written into the database according to a preset rule, in the data access layer: ADO.NET EF and SqlClient can be used for data access to meet data access in different scenarios. Requirements.
  • the business service layer when the industrial component is encoded and written into a database according to a preset rule, at the business service layer: all business logic is encapsulated in the business service layer, and the business service is provided in the form of a Windows communication development platform. It has the characteristics of high cohesion and low coupling.
  • the presentation layer front end display technology such as HTML5, JQuery, CSS3, Bootstrap, etc., responsive layout, compatible with various browsers .
  • the client when the industrial component is encoded and written into the database according to a preset rule, the client: supports a variety of mainstream browsers, and can select IE, Google, Firefox, tablet, smart phone, etc. Adapt to the needs of mobile office.
  • the preset association relationship may be added when encoding the industrial component.
  • the standard category GB GB, German standard DIN, international ISO, Japanese standard JIS, American standard ASME, American standard IFI , British Standard BS, European Standard EN, Italian UNI, French Standard NF, Austrian Standard AS, Korean Standard KS, Russian Standard GOST, Taiwan Standard CNS, Non-standard W, Automobile QC, Machinery JB, Chemical HG, Petrochemical SH, Standard PEM , Power DL, Electronic SJ, Building JG, railway TB, Aviation HB, Aerospace QJ, Military Standard GJB, etc. and product categories: bolts, studs, screws, nuts, washers, retaining rings, self-tapping screws, wood screws, assemblies Preset association of keys, pins, rivet welds, expansion joints, rigging, etc.
  • the standard category GB GB / product category: bolts.
  • Adding a preset association relationship when encoding the industrial component may be a product category, a product standard: a product attribute, and an association relationship of product specifications.
  • product category Bolt, Nut / Product Standard: GB5782 / Product Attributes: Strength, Diameter, Length / Product Specifications: M10x100.
  • Adding a preset association relationship when encoding the industrial component may be a substitute association relationship.
  • the GB5782-2000 half-tooth hex bolt part of the thread, the diameter, tooth distance, material, strength, material, surface treatment and other attributes are all expanded, based on the background of the association, an orderly combination display, users only need to click to quickly filter Switch.
  • the coding unit 20 includes: a standard class rule unit 201, a first tuple coding unit 202, a class rule unit 203, and a second tuple.
  • a coding unit 204 the standard category rule unit 201, configured to encode the industrial component according to a standard category rule; the first tuple encoding unit 202, configured to encode the industrial component to obtain a first element a group ⁇ standard category ⁇ ; the category rule unit 203, configured to encode the industrial component by a product category rule according to the first tuple; the second tuple encoding unit 204, for the industry After the component is encoded, a second tuple ⁇ standard category, product category ⁇ is obtained; a first writing unit 212 is configured to write the database according to the second tuple encoding result.
  • Standard category rule unit 201 of the embodiment of the present application according to the standard category rules GB, German standard DIN, international ISO, Japanese standard JIS, American standard ASME, American standard IFI, British standard BS, European standard EN, Italian UNI, French standard NF, Austrian Standard AS, Korean Standard KS, Russian Standard GOST, Taiwan Standard CNS, Non-standard W, Automobile QC, Machinery JB, Chemical HG, Petrochemical SH, Standard PEM, Power DL, Electronic SJ, Building JG, railway TB, Aviation HB, Aerospace QJ, and military standard GJB code the industrial parts.
  • the standard category rules GB German standard DIN, international ISO, Japanese standard JIS, American standard ASME, American standard IFI, British standard BS, European standard EN, Italian UNI, French standard NF, Austrian Standard AS, Korean Standard KS, Russian Standard GOST, Taiwan Standard CNS, Non-standard W, Automobile QC, Machinery JB, Chemical HG, Petrochemical SH, Standard PEM, Power DL, Electronic SJ, Building JG, Railway TB,
  • the first tuple ⁇ national standard GB... ⁇ is obtained.
  • the category rule unit 203 of the embodiment of the present application performs encoding of the industrial component by a product category rule based on a standard category rule.
  • the second tuple ⁇ national standard GB+bolt ⁇ is obtained.
  • the first writing unit 212 of the embodiment of the present application by writing the second tuple ⁇ national standard GB+bolt ⁇ into the database, it is possible to obtain a two-dimensional array in which the standard category and the product category are tuples.
  • the coding unit 20 includes: a product standard rule unit 205, a fourth tuple coding unit 206, a product attribute rule unit 207, and a fifth element. a group coding unit 208, a product specification rule unit 209, a sixth tuple coding unit 210, and a second writing unit 211, wherein the product standard rule unit 205 is configured to encode the industrial component according to a product standard rule;
  • the fourth tuple encoding unit 206 is configured to encode the industrial component to obtain a fourth tuple ⁇ product standard ⁇ ;
  • the product attribute rule unit 207 is configured to pass the product attribute rule according to the fourth tuple Encoding the industrial component;
  • the fifth tuple encoding unit 208 is configured to encode the industrial component to obtain a fifth tuple ⁇ product standard, product attribute ⁇ ;
  • the product specification rule unit 209 For encoding the industrial component according to the fifth tuple by a product specification rule; the sixth
  • the product standard rule unit 205 in the embodiment of the present application divides the standard rule of the fastener product according to the classification standard under all the standard category rules.
  • the industrial parts to be coded are coded by the product standard rules. Use makes industrial parts uniquely labeled.
  • the fourth tuple encoding unit 206 in the embodiment of the present application encodes the industrial component to obtain a fourth tuple ⁇ GB5-1976...GB22-1976 ⁇ .
  • the product attribute rule unit 207 in the embodiment of the present application may be a product diameter, a product length, a product material, a product strength, a product material, and a product surface treatment.
  • diameter M8, length: 50, 80, 100, material: carbon steel, alloy steel, strength: 8.8, material: 35, surface treatment: black.
  • the industrial parts are coded based on a fifth tuple ⁇ product standard, product attribute ⁇ .
  • the sixth tuple encoding unit 210 in the embodiment of the present application encodes the industrial component to obtain a fifth tuple ⁇ GB5-1976...GB22-1976, diameter: M8, length: 50, 80, 100, material: carbon Steel, alloy steel, strength: 8.8, material: 35, surface treatment: black ⁇ .
  • the fifth tuple encoding unit 208 encodes the industrial component based on the fifth tuple ⁇ product standard, product attribute ⁇ .
  • the product specification rule unit 209 encodes the industrial parts based on the fifth tuple ⁇ product standard, product attribute ⁇ .
  • the sixth tuple encoding unit 210 encodes the industrial component to obtain a sixth tuple ⁇ GB5-1976...GB22-1976, diameter: M8, length: 50, 80, 100, material: carbon steel, alloy steel, strength : 8.8, material: 35, surface treatment: black, specification: M10x100 ⁇ .
  • the coding unit 20 includes: a product substitution rule unit 212
  • the association unit 30 includes: a proxy association unit 301, and the product substitute a rule unit 212, configured to encode and write the industrial component according to a product substitution rule
  • the proxy association unit 301 is configured to increase a product substitution relationship when encoding the industrial component
  • the product substitution relationship is: product specification level substitution relationship.
  • the product substitution rule unit 212 of the embodiment of the present application encodes the industrial component for the product substitution rule and writes it into the database. Matching from industrial big data to surrogate standards that can be universally interchanged.
  • the product substitution relationship in the substitute association unit 301 of the embodiment of the present application is: a product specification level substitute relationship.
  • the standard selects “national standard GB”, the large category selects “bolt”, the system automatically expands the associated “small class”, the small class selects “hexagon bolt”, expands “pattern shape”, expands “head shape, rod shape, thread "Automatically expand the corresponding graphics on the key shapes, click to filter the corresponding product standards.
  • the industrial component to be encoded is determined to include one or more of the following: fasteners, hand tools, hardware, bearings, springs, measuring tools, transmission components, automobile and motorcycle accessories, low-voltage electrical appliances. .
  • modules or steps of the present invention described above can be implemented by a general-purpose computing device that can be centralized on a single computing device or distributed across a network of multiple computing devices. Alternatively, they may be implemented by program code executable by the computing device, such that they may be stored in a storage device by a computing device, or they may be fabricated into individual integrated circuit modules, or Multiple modules or steps are made into a single integrated circuit module. Thus, the invention is not limited to any specific combination of hardware and software.

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

一种数据处理方法及装置。该方法包括：确定待编码的工业零部件(S102)；根据预设规则对所述工业零部件编码并写入数据库(S104)；对所述工业零部件编码时增加预设关联关系(S106)。解决了针对工业零部件的数据处理效率低下的技术问题。达到了工业零部件编码的目的，从而实现了对工业零部件的产品统一编码的技术效果。通过基础数据为工业零部件分配一个唯一的产品身份证号，真正实现产品属性数据统一性和唯一性，大幅提升行业的标准化、规范化，为工业产业优化升级提供数据基础。此外，通过该数据处理方法可将工业零部件进行编码以及存储，形成百亿级别的工业零部件基础数据库。

Description

数据处理方法及装置 技术领域
本申请涉及数据处理领域，具体而言，涉及一种数据处理方法及装置。
背景技术
工业零部件，属于制造业的基层，按照加工难度，从低到高依次分为原材料、工业零部件、组装/装配、核心模组层、系统集成。目前，工业零部件市场规模超过14万亿，汽车、航空航天、消费品、机械、工程、半导体等众多行业均对工业零部件有需求。
发明人发现，目前对于工业零部件缺乏统一的基础数据平台支撑和唯一性编码方式，从而造成了从生产、流通、贸易到使用终端整个产业链环节的沟通效率低下的问题。此外，缺乏统一编码还容易造成出错概率高、一物多码，一码多物等无法一一对应的问题。进而无法实现工业零部件产品属性数据统一性、唯一性。
针对相关技术中针对工业零部件的数据处理效率低下的问题，目前尚未提出有效的解决方案。
发明内容
本申请的主要目的在于提供一种数据处理方法，以解决针对工业零部件的数据处理效率低下的问题。
为了实现上述目的，根据本申请的一个方面，提供了一种数据处理方法，用于对工业零部件的产品编码。
根据本申请的数据处理方法包括：确定待编码的工业零部件；根据预设规则对所述工业零部件编码并写入数据库；以及对所述工业零部件编码时增加预设关联关系。
进一步地，根据预设规则对所述工业零部件编码并写入数据库包括：根据标准类别规则对所述工业零部件编码；对所述工业零部件编码后得到第一元组{标准类别}；根据所述第一元组通过产品类别规则对所述工业零部件编码；对所述工业零部件编码后得到第二元组{标准类别，产品类别}；根据所述第二元 组编码结果写入数据库。
进一步地，根据预设规则对所述工业零部件编码并写入数据库包括：根据标准类别规则对所述工业零部件编码；对所述工业零部件编码后得到第二元组{标准类别，第一产品类别}；根据所述第二元组通过产品类别规则对所述工业零部件编码；对所述工业零部件编码后得到第三元组{标准类别，第一产品类别，第二产品类别}；根据所述第三元组编码结果写入数据库。
进一步地，根据预设规则对所述工业零部件编码并写入数据库包括：根据产品标准规则对所述工业零部件编码；对所述工业零部件编码后得到第四元组{产品标准}；根据所述第四元组通过产品属性规则对所述工业零部件编码；对所述工业零部件编码后得到第五元组{产品标准，产品属性}；根据所述第五元组通过产品规格规则对所述工业零部件编码；对所述工业零部件编码后得到第六元组{产品标准，产品属性，产品规格}；根据所述第六元组编码结果写入数据库。
进一步地，根据预设规则对所述工业零部件编码并写入数据库包括：根据产品代用规则对所述工业零部件编码并写入数据库；对所述工业零部件编码时增加预设关联关系包括：对所述工业零部件编码时增加产品代用关联关系；其中，所述产品代用关联关系为：产品规格级代用关系。
进一步地，确定待编码的工业零部件包括如下的一种或者多种：紧固件、手工具、五金件、轴承、弹簧、量具刃具、传动部件、汽摩配件、低压电器。
为了实现上述目的，根据本申请的另一方面，提供了一种数据处理装置。
根据本申请的数据处理装置包括：确定单元，用于确定待编码的工业零部件；编码单元，用于根据预设规则对所述工业零部件编码并写入数据库；以及关联单元，用于对所述工业零部件编码时增加预设关联关系。
进一步地，所述编码单元包括：标准类别规则单元、第一元组编码单元、类别规则单元、第二元组编码单元，所述标准类别规则单元，用于根据标准类别规则对所述工业零部件编码；所述第一元组编码单元，用于对所述工业零部件编码后得到第一元组{标准类别}；所述类别规则单元，用于根据所述第一元组通过产品类别规则对所述工业零部件编码；所述第二元组编码单元，用于对所述工业零部件编码后得到第二元组{标准类别，产品类别}；第一写入单元，用于根据所述第二元组编码结果写入数据库。
进一步地，所述编码单元包括：产品标准规则单元、第四元组编码单元、产品属性规则单元、第五元组编码单元、产品规格规规则单元、第六元组编码单元、第二写入单元，所述产品标准规则单元，用于根据产品标准规则对所述工业零部件编码；所述第四元组编码单元，用于对所述工业零部件编码后得到第四元组{产品标准}；所述产品属性规则单元，用于根据所述第四元组通过产品属性规则对所述工业零部件编码；所述第五元组编码单元，用于对所述工业零部件编码后得到第五元组{产品标准，产品属性}；所述产品规格规规则单元，用于根据所述第五元组通过产品规格规则对所述工业零部件编码；所述第六元组编码单元，用于对所述工业零部件编码后得到第六元组{产品标准，产品属性，产品规格}；第二写入单元，用于根据所述第六元组编码结果写入数据库。
进一步地，所述编码单元包括：产品代用规则单元，所述关联单元包括：所述产品代用规则单元，用于根据产品代用规则对所述工业零部件编码并写入数据库；代用关联关系单元，用于所述对所述工业零部件编码时增加产品代用关联关系；其中，所述产品代用关联关系为：产品规格级代用关系。
在本申请实施例中，采用确定待编码的工业零部件的方式，通过根据预设规则对所述工业零部件编码并写入数据库，对所述工业零部件编码时增加预设关联关系，达到了工业零部件编码的目的，从而实现了对工业零部件的产品统一编码的技术效果，进而解决了针对工业零部件的数据处理效率低下的技术问题。由于在现有技术中，缺乏统一的基础数据平台支撑和唯一性编码方式，所以造成了从生产、流通、贸易到使用终端整个产业链环节的沟通效率低下，出错概率高，普遍存在一物多码，一码多物，同一个产品有多种应用别名和叫法，类似于地方方言各说各话很难沟通理解，通过本申请中的数据处理方法可将工业零部件进行编码以及存储，形成百亿级别的工业零部件基础数据库。
附图说明
此处所说明的附图用来提供对本公开的进一步理解，构成本申请的一部分，本公开的示意性实施例及其说明用于解释本公开，并不构成对本公开的不当限定。在附图中：
图1是根据本申请第一实施例的数据处理方法示意图；
图2是根据本申请第二实施例的数据处理方法示意图；
图3是根据本申请第三实施例的数据处理方法示意图；
图4是根据本申请第四实施例的数据处理方法示意图；
图5是根据本申请第五实施例的数据处理方法示意图；
图6是根据本申请第一实施例的数据处理装置示意图；
图7是根据本申请第二实施例的数据处理装置示意图；
图8是根据本申请第三实施例的数据处理装置示意图；以及
图9是根据本申请第四实施例的数据处理装置示意图。
具体实施方式
为了使本技术领域的人员更好地理解本申请方案，下面将结合本申请实施例中的附图，对本申请实施例中的技术方案进行清楚、完整地描述，显然，所描述的实施例仅仅是本申请一部分的实施例，而不是全部的实施例。基于本申请中的实施例，本领域普通技术人员在没有做出创造性劳动前提下所获得的所有其他实施例，都应当属于本申请保护的范围。
需要说明的是，本申请的说明书和权利要求书及上述附图中的术语“第一”、“第二”等是用于区别类似的对象，而不必用于描述特定的顺序或先后次序。应该理解这样使用的数据在适当情况下可以互换，以便这里描述的本申请的实施例。此外，术语“包括”和“具有”以及他们的任何变形，意图在于覆盖不排他的包含，例如，包含了一系列步骤或单元的过程、方法、系统、产品或设备不必限于清楚地列出的那些步骤或单元，而是可包括没有清楚地列出的或对于这些过程、方法、产品或设备固有的其它步骤或单元。
在本申请中，术语“上”、“下”、“左”、“右”、“前”、“后”、“顶”、“底”、“内”、“外”、“中”、“竖直”、“水平”、“横向”、“纵向”等指示的方位或位置关系为基于附图所示的方位或位置关系。这些术语主要是为了更好地描述本申请及其实施例，并非用于限定所指示的装置、元件或组成部分必须具有特定方位，或以特定方位进行构造和操作。
并且，上述部分术语除了可以用于表示方位或位置关系以外，还可能用于表示其他含义，例如术语“上”在某些情况下也可能用于表示某种依附关系或连接关系。对于本领域普通技术人员而言，可以根据具体情况理解这些术语在本申请中的具体含义。
此外，术语“安装”、“设置”、“设有”、“连接”、“相连”、“套 接”应做广义理解。例如，可以是固定连接，可拆卸连接，或整体式构造；可以是机械连接，或电连接；可以是直接相连，或者是通过中间媒介间接相连，又或者是两个装置、元件或组成部分之间内部的连通。对于本领域普通技术人员而言，可以根据具体情况理解上述术语在本申请中的具体含义。
工业零部件中的又以紧固件产品应用和涉及行业最为广泛小到手机大到飞机都需要紧固件进行连接是工业基础性配套产业。紧固件产品各个国家、地区和行业都有自己的标准(标准内容包含技术、性能、应用、图纸等信息)，全球的紧固件标准达8000多种，常用产品规格型号也超过千万。如何对数据库级别已达到10亿级别的工业零部件进行储存，是本申请主要解决的问题。
在下述实施例中主要以紧固件作为优选地实施例对本申请用于工业零部件的数据储存方法进行详细地说明和描述。由于在现有技术中，缺乏统一的基础数据平台支撑和唯一性编码方式，所以造成了从生产、流通、贸易到使用终端整个产业链环节的沟通效率低下，出错概率高，普遍存在一物多码，一码多物，同一个产品有多种应用别名和叫法，类似于地方方言各说各话很难沟通理解，通过本申请中数据处理可将百亿级别的编码以及存储。
需要说明的是，在不冲突的情况下，本申请中的实施例及实施例中的特征可以相互组合。下面将参考附图并结合实施例来详细说明本申请。
如图1所示，该方法包括如下的步骤S102至步骤S106：
步骤S102，确定待编码的工业零部件；
确定待编码的工业零部件可以是手工具、五金件、轴承、弹簧、量具刃具、传动部件、汽摩配件、低压电器等工业零部件行业的工业零部件。
确定待编码的工业零部件可以是工业大数据库已集成全球紧固件类产品标准数据，涵盖个国家地区、13个行业类别、15个产品系列，近10亿产品规格数据，近20亿图纸数据。
确定待编码的工业零部件可以是通过表储存的工业零部件。
确定待编码的工业零部件可以是读写据库的工业零部件。
步骤S104，根据预设规则对所述工业零部件编码并写入数据库；
预设规则包括但不限于，国标GB、德标DIN、国际ISO、日标JIS、美标ASME、美标IFI、英标BS、欧标EN、意大利UNI、法标NF、奥标AS、韩标KS、俄标GOST、台标CNS、非标W等标准类别规则。
预设规则包括但不限于，汽车QC、机械JB、化工HG、石化SH、标准PEM、电力DL、电子SJ、建筑JG、铁道TB、航空HB、航天QJ、军标GJB等标准类别规则。
预设规则包括但不限于，螺栓、螺柱、螺钉、螺母、垫圈、挡圈、自攻钉、木螺钉、组合件、键、销、铆钉焊接类、膨胀件、索具、其他等产品类别规则。
预设规则包括但不限于，产品标准规则。比如，GB+序号的产品标准。
预设规则包括但不限于，产品属性规则。比如，直径、材质、强度、材料、表面处理。
预设规则包括但不限于，产品规格规则。比如，M10x100、M10x60、M10x45。
预设规则包括但不限于，代用标准规则。不同的大小、长度之间的互换代用。
在一些实施例中，根据预设规则对所述工业零部件编码并写入数据库时，数据存储层，使用MySql进行数据持久化，并采用数据库读写分离，能够提高多用户访问时的性能。
在一些实施例中，根据预设规则对所述工业零部件编码并写入数据库时，在数据访问层：可以选用ADO.NET EF或者SqlClient两种方式进行数据访问，满足不同场景下对数据访问的要求。
在一些实施例中，根据预设规则对所述工业零部件编码并写入数据库时，在业务服务层：所有业务逻辑都封装在业务服务层，以Windows通讯开发平台的方式对外提供业务服务，具有高内聚、低耦合的特点。
在一些实施例中，根据预设规则对所述工业零部件编码并写入数据库时，在展现层：可以选用HTML5、JQuery、CSS3、Bootstrap等前端展示技术，响应式布局，兼容多种浏览器。
在一些实施例中，根据预设规则对所述工业零部件编码并写入数据库时，在客户端：支持多种主流浏览器，可以选用IE、谷歌、火狐浏览器，平板、智能手机等设备、适应移动化办公需求。
步骤S106，对所述工业零部件编码时增加预设关联关系。
对所述工业零部件编码时增加预设关联关系可以是，标准类别：国标GB、德标DIN、国际ISO、日标JIS、美标ASME、美标IFI、英标BS、欧标EN、 意大利UNI、法标NF、奥标AS、韩标KS、俄标GOST、台标CNS、非标W、汽车QC、机械JB、化工HG、石化SH、标准PEM、电力DL、电子SJ、建筑JG、铁道TB、航空HB、航天QJ、军标GJB等与产品类别：螺栓、螺柱、螺钉、螺母、垫圈、挡圈、自攻钉、木螺钉、组合件、键、销、铆钉焊接类、膨胀件、索具等的预设关联关系。
例如，标准类别：国标GB/产品类别：螺栓。
对所述工业零部件编码时增加预设关联关系可以是，产品类别、产品标准：产品属性以及产品规格的关联关系。
例如，产品类别：螺栓、螺母/产品标准：GB5782/产品属性：强度、直径、长度/产品规格：M10x100。
对所述工业零部件编码时增加预设关联关系可以是，代用关联关系。
例如，GB5782-2000半牙六角螺栓部分螺纹，将直径、牙距、材质、强度、材料、表面处理等属性全部展开，基于后台的关联，有序的组合展示，用户只需要点击即可快速过滤切换。例如选择：直径：M8，长度：50、80、100，材质：碳钢、合金钢，强度：8.8、材料：35、表面处理：发黑(淬火)；将产品千支重量、产品图纸、代用互换标准及数据关联。
从以上的描述中，可以看出，本发明实现了如下技术效果：
在本申请实施例中，采用确定待编码的工业零部件的方式，通过根据预设规则对所述工业零部件编码并写入数据库，对所述工业零部件编码时增加预设关联关系，达到了工业零部件编码的目的，从而实现了对工业零部件的产品统一编码的技术效果，进而解决了针对工业零部件的数据处理效率低下的技术问题。
根据本发明实施例，作为本实施例中的优选，如图2所示，根据预设规则对所述工业零部件编码并写入数据库包括：
步骤S202，根据标准类别规则对所述工业零部件编码；
根据标准类别规则国标GB、德标DIN、国际ISO、日标JIS、美标ASME、美标IFI、英标BS、欧标EN、意大利UNI、法标NF、奥标AS、韩标KS、俄标GOST、台标CNS、非标W、汽车QC、机械JB、化工HG、石化SH、标准PEM、电力DL、电子SJ、建筑JG、铁道TB、航空HB、航天QJ、军标GJB对所述工业零部件编码。
步骤S204，对所述工业零部件编码后得到第一元组{标准类别}；
编码后得到第一元组{国标GB…}；
步骤S206，根据所述第一元组通过产品类别规则对所述工业零部件编码；
基于标准类别规则通过产品类别规则进行所述工业零部件的编码。螺栓、螺柱、螺钉、螺母、垫圈、挡圈、自攻钉、木螺钉、组合件、键、销、铆钉焊接类、膨胀件、索具等。
步骤S208，对所述工业零部件编码后得到第二元组{标准类别，产品类别}；
例如，编码后得到第二元组{国标GB+螺栓}；
步骤S210，根据所述第二元组编码结果写入数据库。
通过将所述第二元组{国标GB+螺栓}写入数据库中，能够得到，标准类别和产品类别为元组的二维数组。
例如，{国标GB，螺栓}；{国际ISO，螺母}。
根据本发明实施例，作为本实施例中的优选，如图3所示，根据预设规则对所述工业零部件编码并写入数据库包括：
步骤S302，根据标准类别规则对所述工业零部件编码；
根据标准类别规则国标GB、德标DIN、国际ISO、日标JIS、美标ASME、美标IFI、英标BS、欧标EN、意大利UNI、法标NF、奥标AS、韩标KS、俄标GOST、台标CNS、非标W、汽车QC、机械JB、化工HG、石化SH、标准PEM、电力DL、电子SJ、建筑JG、铁道TB、航空HB、航天QJ、军标GJB对所述工业零部件编码。
步骤S304，对所述工业零部件编码后得到第二元组{标准类别，第一产品类别}；
第一产品类别可以是产品类别的大类。
编码后得到第二元组{国标GB+螺栓}；
步骤S306，根据所述第二元组通过产品类别规则对所述工业零部件编码；
基于标准类别规则通过产品类别规则进行所述工业零部件的编码。螺栓、螺柱、螺钉、螺母、垫圈、挡圈、自攻钉、木螺钉、组合件、键、销、铆钉焊接类、膨胀件、索具等。
步骤S308，对所述工业零部件编码后得到第三元组{标准类别，第一产品类别，第二产品类别}；
编码后得到第三元组{国标GB+螺栓+六角螺栓}；
步骤S310，根据所述第三元组编码结果写入数据库。
通过将所述编码后得到第三元组{国标GB+螺栓+六角螺栓}写入数据库中，能够得到，标准类别和产品类别为元组的二维数组。
在一些实施例中，还可以包括图样形状，所述图样形状通过SVM矢量图通过对工业零部件建模渲染后得到。
例如，图样形状中还可以包括头型、杆状、螺纹等图样形状。
根据本发明实施例，作为本实施例中的优选，如图4所示，根据预设规则对所述工业零部件编码并写入数据库包括：
步骤S402，根据产品标准规则对所述工业零部件编码；
根据所有标准类别规则下的分类标准，划分得到紧固件产品标准规则。通过产品标准规则对待编码的工业零部件进行编码。使用使得工业零部件具有唯一标识性。
步骤S404，对所述工业零部件编码后得到第四元组{产品标准}；
例如，对所述工业零部件编码后得到第四元组{GB5-1976…GB22-1976}。
步骤S406，根据所述第四元组通过产品属性规则对所述工业零部件编码；
在第四元组{GB5-1976…GB22-1976}的基础上增加产品属性规则。
产品属性可以是，产品直径，产品长度，产品材质，产品强度，产品材料，产品表面处理。
例如，直径：M8，长度：50、80、100，材质：碳钢、合金钢，强度：8.8、材料：35、表面处理：发黑。
步骤S408，对所述工业零部件编码后得到第五元组{产品标准，产品属性}；
例如，对所述工业零部件编码后得到第五元组{GB5-1976…GB22-1976，直径：M8，长度：50、80、100，材质：碳钢、合金钢，强度：8.8、材料：35、表面处理：发黑}。
步骤S410，根据所述第五元组通过产品规格规则对所述工业零部件编码；
基于第五元组{产品标准，产品属性}对所述工业零部件编码。
步骤S412，对所述工业零部件编码后得到第六元组{产品标准，产品属性，产品规格}；
例如，对所述工业零部件编码后得到第六元组{GB5-1976…GB22-1976，直径：M8，长度：50、80、100，材质：碳钢、合金钢，强度：8.8、材料：35、表面处理：发黑，规格：M10x100}。
步骤S414，根据所述第六元组编码结果写入数据库。
根据本发明实施例，作为本实施例中的优选，如图5所示，根据预设规则对所述工业零部件编码并写入数据库包括：
步骤S502，根据产品代用规则对所述工业零部件编码并写入数据库；
针对产品代用规则对所述工业零部件编码后写入数据库中。从工业大数据中匹配到对应可以通用互换的代用标准。
对所述工业零部件编码时增加预设关联关系包括：
步骤S504，对所述工业零部件编码时增加产品代用关联关系；
所述产品代用关联关系为：产品规格级代用关系。
通过将每个元素之间的关联关系在数据库中全部进行梳理，用户选择过滤条件即可快速找到产品标准。
例如：标准选择“国标GB”、大类选择“螺栓”，系统自动展开相关联的“小类”，小类选择“六角螺栓”，展开“图样形状”，展开“头型、杆状、螺纹”等关键形状上自动展开相应的图形，点击即可过滤相应的产品标准。
作为本实施例中的优选，确定待编码的工业零部件包括如下的一种或者多种：紧固件、手工具、五金件、轴承、弹簧、量具刃具、传动部件、汽摩配件、低压电器。
需要说明的是，在附图的流程图示出的步骤可以在诸如一组计算机可执行指令的计算机系统中执行，并且，虽然在流程图中示出了逻辑顺序，但是在某些情况下，可以以不同于此处的顺序执行所示出或描述的步骤。
根据本发明实施例，还提供了一种用于实施上述数据处理的装置，如图6所示，该装置包括：确定单元10，用于确定待编码的工业零部件；编码单元 20，用于根据预设规则对所述工业零部件编码并写入数据库；以及关联单元30，用于对所述工业零部件编码时增加预设关联关系。
在本申请实施例的确定单元10中确定待编码的工业零部件可以是手工具、五金件、轴承、弹簧、量具刃具、传动部件、汽摩配件、低压电器等工业零部件行业的工业零部件。
确定待编码的工业零部件可以是工业大数据库已集成全球紧固件类产品标准数据，涵盖个国家地区、13个行业类别、15个产品系列，近10亿产品规格数据，近20亿图纸数据。
确定待编码的工业零部件可以是通过表储存的工业零部件。
确定待编码的工业零部件可以是读写据库的工业零部件。
在本申请实施例的编码单元20中预设规则包括但不限于，国标GB、德标DIN、国际ISO、日标JIS、美标ASME、美标IFI、英标BS、欧标EN、意大利UNI、法标NF、奥标AS、韩标KS、俄标GOST、台标CNS、非标W等标准类别规则。
预设规则包括但不限于，汽车QC、机械JB、化工HG、石化SH、标准PEM、电力DL、电子SJ、建筑JG、铁道TB、航空HB、航天QJ、军标GJB等标准类别规则。
预设规则包括但不限于，螺栓、螺柱、螺钉、螺母、垫圈、挡圈、自攻钉、木螺钉、组合件、键、销、铆钉焊接类、膨胀件、索具、其他等产品类别规则。
预设规则包括但不限于，产品标准规则。比如，GB+序号的产品标准。
预设规则包括但不限于，产品属性规则。比如，直径、材质、强度、材料、表面处理
预设规则包括但不限于，产品规格规则。比如，M10x100、M10x60、M10x45。
预设规则包括但不限于，代用标准规则。不同的大小、长度之间的互换代用。
在一些实施例中，根据预设规则对所述工业零部件编码并写入数据库时，在数据存储层，使用MySql进行数据持久化，并采用数据库读写分离，能够提高多用户访问时的性能。
在一些实施例中，根据预设规则对所述工业零部件编码并写入数据库时， 在数据访问层：可以选用ADO.NET EF和SqlClient两种方式进行数据访问，满足不同场景下对数据访问的要求。
在一些实施例中，根据预设规则对所述工业零部件编码并写入数据库时，在业务服务层：所有业务逻辑都封装在业务服务层，以Windows通讯开发平台的方式对外提供业务服务，具有高内聚、低耦合的特点。
在一些实施例中，根据预设规则对所述工业零部件编码并写入数据库时，在展现层：可以选用HTML5、JQuery、CSS3、Bootstrap等前端展示技术，响应式布局，兼容多种浏览器。
在一些实施例中，根据预设规则对所述工业零部件编码并写入数据库时，在客户端：支持多种主流浏览器，可以选用IE、谷歌、火狐浏览器，平板、智能手机等设备、适应移动化办公需求。
在本申请实施例的关联单元30中对所述工业零部件编码时增加预设关联关系可以是，标准类别：国标GB、德标DIN、国际ISO、日标JIS、美标ASME、美标IFI、英标BS、欧标EN、意大利UNI、法标NF、奥标AS、韩标KS、俄标GOST、台标CNS、非标W、汽车QC、机械JB、化工HG、石化SH、标准PEM、电力DL、电子SJ、建筑JG、铁道TB、航空HB、航天QJ、军标GJB等与产品类别：螺栓、螺柱、螺钉、螺母、垫圈、挡圈、自攻钉、木螺钉、组合件、键、销、铆钉焊接类、膨胀件、索具等的预设关联关系。
例如，标准类别：国标GB/产品类别：螺栓。
对所述工业零部件编码时增加预设关联关系可以是，产品类别、产品标准：产品属性以及产品规格的关联关系。
例如，产品类别：螺栓、螺母/产品标准：GB5782/产品属性：强度、直径、长度/产品规格：M10x100。
对所述工业零部件编码时增加预设关联关系可以是，代用关联关系。
例如，GB5782-2000半牙六角螺栓部分螺纹，将直径、牙距、材质、强度、材料、表面处理等属性全部展开，基于后台的关联，有序的组合展示，用户只需要点击即可快速过滤切换。例如选择：直径：M8，长度：50、80、100，材质：碳钢、合金钢，强度：8.8、材料：35、表面处理：发黑(淬火)；将产品千支重量、产品图纸、代用互换标准及数据关联。
根据本发明实施例，作为本实施例中的优选，如图7所示，所述编码单元 20包括：标准类别规则单元201、第一元组编码单元202、类别规则单元203、第二元组编码单元204，所述标准类别规则单元201，用于根据标准类别规则对所述工业零部件编码；所述第一元组编码单元202，用于对所述工业零部件编码后得到第一元组{标准类别}；所述类别规则单元203，用于根据所述第一元组通过产品类别规则对所述工业零部件编码；所述第二元组编码单元204，用于对所述工业零部件编码后得到第二元组{标准类别，产品类别}；第一写入单元212，用于根据所述第二元组编码结果写入数据库。
本申请实施例的标准类别规则单元201中根据标准类别规则国标GB、德标DIN、国际ISO、日标JIS、美标ASME、美标IFI、英标BS、欧标EN、意大利UNI、法标NF、奥标AS、韩标KS、俄标GOST、台标CNS、非标W、汽车QC、机械JB、化工HG、石化SH、标准PEM、电力DL、电子SJ、建筑JG、铁道TB、航空HB、航天QJ、军标GJB对所述工业零部件编码。
本申请实施例的第一元组编码单元202中编码后得到第一元组{国标GB…}。
本申请实施例的类别规则单元203中基于标准类别规则通过产品类别规则进行所述工业零部件的编码。螺栓、螺柱、螺钉、螺母、垫圈、挡圈、自攻钉、木螺钉、组合件、键、销、铆钉焊接类、膨胀件、索具等。
本申请实施例的第二元组编码单元204中编码后得到第二元组{国标GB+螺栓}。
本申请实施例的第一写入单元212中通过将所述第二元组{国标GB+螺栓}写入数据库中，能够得到，标准类别和产品类别为元组的二维数组。
例如，{国标GB，螺栓}；{国际ISO，螺母}。
根据本发明实施例，作为本实施例中的优选，如图8所示，所述编码单元20包括：产品标准规则单元205、第四元组编码单元206、产品属性规则单元207、第五元组编码单元208、产品规格规规则单元209、第六元组编码单元210、第二写入单元211，所述产品标准规则单元205，用于根据产品标准规则对所述工业零部件编码；所述第四元组编码单元206，用于对所述工业零部件编码后得到第四元组{产品标准}；所述产品属性规则单元207，用于根据所述第四元组通过产品属性规则对所述工业零部件编码；所述第五元组编码单元208，用于对所述工业零部件编码后得到第五元组{产品标准，产品属性}；所述产品规格规规则单元209，用于根据所述第五元组通过产品规格规则对所述工 业零部件编码；所述第六元组编码单元210，用于对所述工业零部件编码后得到第六元组{产品标准，产品属性，产品规格}；第二写入单元211，用于根据所述第六元组编码结果写入数据库。
在本申请实施例的产品标准规则单元205根据所有标准类别规则下的分类标准，划分得到紧固件产品标准规则。通过产品标准规则对待编码的工业零部件进行编码。使用使得工业零部件具有唯一标识性。
在本申请实施例的第四元组编码单元206对所述工业零部件编码后得到第四元组{GB5-1976…GB22-1976}。
在第四元组{GB5-1976…GB22-1976}的基础上增加产品属性规则。
在本申请实施例的产品属性规则单元207产品属性可以是，产品直径，产品长度，产品材质，产品强度，产品材料，产品表面处理。
例如，直径：M8，长度：50、80、100，材质：碳钢、合金钢，强度：8.8、材料：35、表面处理：发黑。
基于第五元组{产品标准，产品属性}对所述工业零部件编码。
在本申请实施例的第六元组编码单元210对所述工业零部件编码后得到第五元组{GB5-1976…GB22-1976，直径：M8，长度：50、80、100，材质：碳钢、合金钢，强度：8.8、材料：35、表面处理：发黑}。
第五元组编码单元208基于第五元组{产品标准，产品属性}对所述工业零部件编码。
产品规格规规则单元209基于第五元组{产品标准，产品属性}对所述工业零部件编码。
第六元组编码单元210对所述工业零部件编码后得到第六元组{GB5-1976…GB22-1976，直径：M8，长度：50、80、100，材质：碳钢、合金钢，强度：8.8、材料：35、表面处理：发黑，规格：M10x100}。
根据本发明实施例，作为本实施例中的优选，如图9所示，所述编码单元20包括：产品代用规则单元212，所述关联单元30包括：代用关联关系单元301，所述产品代用规则单元212，用于根据产品代用规则对所述工业零部件编码并写入数据库；所述代用关联关系单元301，用于所述对所述工业零部件编码时增加产品代用关联关系；其中，所述产品代用关联关系为：产品规格级代用关系。
本申请实施例的产品代用规则单元212中针对产品代用规则对所述工业零部件编码后写入数据库中。从工业大数据中匹配到对应可以通用互换的代用标准。
本申请实施例的所述代用关联关系单元301中所述产品代用关联关系为：产品规格级代用关系。通过将每个元素之间的关联关系在数据库中全部进行梳理，用户选择过滤条件即可快速找到产品标准。
例如：标准选择“国标GB”、大类选择“螺栓”，系统自动展开相关联的“小类”，小类选择“六角螺栓”，展开“图样形状”，展开“头型、杆状、螺纹”等关键形状上自动展开相应的图形，点击即可过滤相应的产品标准。
作为本实施例中的优选，确定待编码的工业零部件包括如下的一种或者多种：紧固件、手工具、五金件、轴承、弹簧、量具刃具、传动部件、汽摩配件、低压电器。
显然，本领域的技术人员应该明白，上述的本发明的各模块或各步骤可以用通用的计算装置来实现，它们可以集中在单个的计算装置上，或者分布在多个计算装置所组成的网络上，可选地，它们可以用计算装置可执行的程序代码来实现，从而，可以将它们存储在存储装置中由计算装置来执行，或者将它们分别制作成各个集成电路模块，或者将它们中的多个模块或步骤制作成单个集成电路模块来实现。这样，本发明不限制于任何特定的硬件和软件结合。
以上所述仅为本申请的优选实施例而已，并不用于限制本申请，对于本领域的技术人员来说，本申请可以有各种更改和变化。凡在本申请的精神和原则之内，所作的任何修改、等同替换、改进等，均应包含在本申请的保护范围之内。

Claims (10)

  1. 一种数据处理方法，其特征在于，用于对工业零部件的产品编码，所述方法包括：
    确定待编码的工业零部件；
    根据预设规则对所述工业零部件编码并写入数据库；以及
    对所述工业零部件编码时增加预设关联关系。
  2. 根据权利要求1所述的数据处理方法，其特征在于，根据预设规则对所述工业零部件编码并写入数据库包括：
    根据标准类别规则对所述工业零部件编码；
    对所述工业零部件编码后得到第一元组{标准类别}；
    根据所述第一元组通过产品类别规则对所述工业零部件编码；
    对所述工业零部件编码后得到第二元组{标准类别，产品类别}；以及
    根据所述第二元组编码结果写入数据库。
  3. 根据权利要求1所述的数据处理方法，其特征在于，根据预设规则对所述工业零部件编码并写入数据库包括：
    根据标准类别规则对所述工业零部件编码；
    对所述工业零部件编码后得到第二元组{标准类别，第一产品类别}；
    根据所述第二元组通过产品类别规则对所述工业零部件编码；
    对所述工业零部件编码后得到第三元组{标准类别，第一产品类别，第二产品类别}；以及
    根据所述第三元组编码结果写入数据库。
  4. 根据权利要求1所述的数据处理方法，其特征在于，根据预设规则对所述工业零部件编码并写入数据库包括：
    根据产品标准规则对所述工业零部件编码；
    对所述工业零部件编码后得到第四元组{产品标准}；
    根据所述第四元组通过产品属性规则对所述工业零部件编码；
    对所述工业零部件编码后得到第五元组{产品标准，产品属性}；
    根据所述第五元组通过产品规格规则对所述工业零部件编码；
    对所述工业零部件编码后得到第六元组{产品标准，产品属性，产品规格}；以及
    根据所述第六元组编码结果写入数据库。
  5. 根据权利要求1所述的数据处理方法，其特征在于，根据预设规则对所述工业零部件编码并写入数据库包括：
    根据产品代用规则对所述工业零部件编码并写入数据库；
    对所述工业零部件编码时增加预设关联关系包括：
    对所述工业零部件编码时增加产品代用关联关系；
    其中，所述产品代用关联关系为：产品规格级代用关系。
  6. 根据权利要求1所述的数据处理方法，其特征在于，确定待编码的工业零部件包括如下的一种或者多种：
    紧固件、手工具、五金件、轴承、弹簧、量具刃具、传动部件、汽摩配件、低压电器。
  7. 一种数据处理装置，其特征在于，包括：
    确定单元，用于确定待编码的工业零部件；
    编码单元，用于根据预设规则对所述工业零部件编码并写入数据库；以及
    关联单元，用于对所述工业零部件编码时增加预设关联关系。
  8. 根据权利要求7所述的数据处理装置，其特征在于，所述编码单元包括：
    标准类别规则单元、第一元组编码单元、类别规则单元、第二元组编码单元，所述标准类别规则单元，用于根据标准类别规则对所述工业零部件编码；
    所述第一元组编码单元，用于对所述工业零部件编码后得到第一元组{标准 类别}；
    所述类别规则单元，用于根据所述第一元组通过产品类别规则对所述工业零部件编码；
    所述第二元组编码单元，用于对所述工业零部件编码后得到第二元组{标准类别，产品类别}；以及
    第一写入单元，用于根据所述第二元组编码结果写入数据库。
  9. 根据权利要求7所述的数据处理装置，其特征在于，所述编码单元包括：产品标准规则单元、第四元组编码单元、产品属性规则单元、第五元组编码单元、产品规格规规则单元、第六元组编码单元、第二写入单元，
    所述产品标准规则单元，用于根据产品标准规则对所述工业零部件编码；
    所述第四元组编码单元，用于对所述工业零部件编码后得到第四元组{产品标准}；
    所述产品属性规则单元，用于根据所述第四元组通过产品属性规则对所述工业零部件编码；
    所述第五元组编码单元，用于对所述工业零部件编码后得到第五元组{产品标准，产品属性}；
    所述产品规格规规则单元，用于根据所述第五元组通过产品规格规则对所述工业零部件编码；
    所述第六元组编码单元，用于对所述工业零部件编码后得到第六元组{产品标准，产品属性，产品规格}；以及
    第二写入单元，用于根据所述第六元组编码结果写入数据库。
  10. 根据权利要求7所述的数据处理装置，其特征在于，所述编码单元包括：
    产品代用规则单元，所述关联单元包括：代用关联关系单元，
    所述产品代用规则单元，用于根据产品代用规则对所述工业零部件编码并写入数据库；
    所述代用关联关系单元，用于所述对所述工业零部件编码时增加产品代用关联关系；其中，所述产品代用关联关系为：产品规格级代用关系。
PCT/CN2019/073729 2018-01-31 2019-01-29 数据处理方法及装置 WO2019149193A1 (zh)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201810096829.4A CN108595465A (zh) 2018-01-31 2018-01-31 数据处理方法及装置
CN201810096829.4 2018-01-31

Publications (1)

Publication Number Publication Date
WO2019149193A1 true WO2019149193A1 (zh) 2019-08-08

Family

ID=63608510

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2019/073729 WO2019149193A1 (zh) 2018-01-31 2019-01-29 数据处理方法及装置

Country Status (2)

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

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN108595465A (zh) * 2018-01-31 2018-09-28 杭州优工品科技有限公司 数据处理方法及装置

Citations (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
CN103958796A (zh) * 2011-11-02 2014-07-30 马来西亚普渡大学 在制造者和设计者之间提供和管理预制结构部件的信息的方法和系统
CN105678610A (zh) * 2016-03-01 2016-06-15 成都市泰象网络科技有限公司 一种汽车配件电商交易的管理系统及方法
CN107491609A (zh) * 2017-08-22 2017-12-19 云南电网有限责任公司普洱供电局 一种变电站设备可视化实时动态开合显示方法
CN108595465A (zh) * 2018-01-31 2018-09-28 杭州优工品科技有限公司 数据处理方法及装置

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103390223A (zh) * 2013-07-31 2013-11-13 西安互易计算机科技有限公司 一种基于标准件行业编码的进销存企业管理系统
US10518413B2 (en) * 2015-12-11 2019-12-31 Abb Schweiz Ag Industrial robot and method for controlling the robot to automatically select which program code to be executed next
CN106056276A (zh) * 2016-05-23 2016-10-26 国家电网公司 一种物料信息管理方法及应用平台
CN107122484A (zh) * 2017-05-08 2017-09-01 明觉科技（北京）有限公司 零件信息查询方法及系统

Patent Citations (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
CN103958796A (zh) * 2011-11-02 2014-07-30 马来西亚普渡大学 在制造者和设计者之间提供和管理预制结构部件的信息的方法和系统
CN105678610A (zh) * 2016-03-01 2016-06-15 成都市泰象网络科技有限公司 一种汽车配件电商交易的管理系统及方法
CN107491609A (zh) * 2017-08-22 2017-12-19 云南电网有限责任公司普洱供电局 一种变电站设备可视化实时动态开合显示方法
CN108595465A (zh) * 2018-01-31 2018-09-28 杭州优工品科技有限公司 数据处理方法及装置

Also Published As

Publication number Publication date
CN108595465A (zh) 2018-09-28

Similar Documents

Publication Publication Date Title
Shanahan et al. Large scale distributed data science using apache spark
US11036685B2 (en) System and method for compressing data in a database
US10083195B2 (en) System and method for composing a multidimensional index key in data blocks
Li et al. Sensitivity analysis of TOPSIS method in water quality assessment: I. Sensitivity to the parameter weights
CN107085570B (zh) 数据处理方法、应用服务器和路由器
Prell et al. Unequal carbon exchanges: The environmental and economic impacts of iconic US consumption items
CN103729453A (zh) 一种HBase表联合查询优化的方法
WO2019149193A1 (zh) 数据处理方法及装置
Megnigbeto Efficiency, unused capacity and transmission power as indicators of the Triple Helix of university–industry–government relationships
US20150120697A1 (en) System and method for analysis of a database proxy
WO2014176182A1 (en) Auto-completion of partial line pattern
CN113094387A (zh) 一种数据查询方法、装置、电子设备及机器可读存储介质
CN105912723A (zh) 一种自定义字段的存储方法
CA3203549A1 (en) Unified verification method, device, equipment and storage medium
CN110837499A (zh) 数据访问处理方法、装置、电子设备和存储介质
US20210141791A1 (en) Method and system for generating a hybrid data model
CN114138735A (zh) 一种Janusgraph数据快速批量装载的方法
CN113934729A (zh) 一种基于知识图谱的数据管理方法、相关设备及介质
CN106649836A (zh) 一种基于硬件查找表的模式字符的查找方法
CN107203635B (zh) 一种基于最小略图的流模式下有向标签图的略图构建方法
Fujimoto Architecture-based comparative advantage in Japan and Asia
Bildtgard et al. The transformation of late-life singlehood: Emergence of the society of divorcees
CN103714147A (zh) 视频资源数据源的处理方法及其系统
CN115221249B (zh) 跨库数据查询方法、装置、计算机设备和存储介质
CN115168409B (zh) 数据库分表的数据查询方法、装置和计算机设备

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 19748458

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 19748458

Country of ref document: EP

Kind code of ref document: A1

32PN Ep: public notification in the ep bulletin as address of the adressee cannot be established

Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 24/02/2021)

122 Ep: pct application non-entry in european phase

Ref document number: 19748458

Country of ref document: EP

Kind code of ref document: A1