CN102799965B - A kind of method that in handling of goods and materials, material characteristics describes and stores - Google Patents
A kind of method that in handling of goods and materials, material characteristics describes and stores Download PDFInfo
- Publication number
- CN102799965B CN102799965B CN201210219307.1A CN201210219307A CN102799965B CN 102799965 B CN102799965 B CN 102799965B CN 201210219307 A CN201210219307 A CN 201210219307A CN 102799965 B CN102799965 B CN 102799965B
- Authority
- CN
- China
- Prior art keywords
- address pointer
- hand axis
- material characteristics
- corresponding group
- points
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Abstract
The present invention relates to field of material management, particularly relate to a kind of method that in handling of goods and materials, material characteristics describes and stores, it comprises the following steps, and the material principal character that user is concerned about is described and divides into groups by (1); (2) flat address pointer is set up; (3) by material principal character and address pointer combinations of pairs one by one, Description standard is set up; (4) Description standard set up according to step (3) is described each newly-increased material data and namely carries out Feature Combination; (5) data after describing according to step (4) are stored in database; (6) according to the method for address pointer isolation, feature decomposition is carried out and generated query table to the data in step (5) database; (7) combination of multiple features search operaqtion is carried out to the question blank that step (6) generates, required material can be retrieved fast by said method.
Description
Technical field
The present invention relates to field of material management, particularly relate to a kind of method that in handling of goods and materials, material characteristics describes and stores.
Background technology
A ripe enterprise product material has thousands of kind at least, some materials have design drawing, have plenty of and there is no design drawing, the material will finding out needs in so many materials is fast very difficult, the way of usual enterprise sets up material library, will be described them in advance the retrieval of these materials, and at present the character description method of PDM on the market or ERP software is all by keyword match mode, because material code and feature interpretation thereof store in a database with the form of master data sheet, master data sheet is data source table, feature interpretation is in master data sheet, it only occupies a cell in a database, because if feature interpretation occupies comparatively multi-cell in database, then just need slowly during the data of other relation tables and these feature interpretation of query calls in database, call efficiency very low, so the retrieval of multiple features coupling mostly can not be realized, single characteristic matching can only be carried out, the material be so only retrieved by keyword match (i.e. single characteristic key) just has a variety of, then also need constantly to carry out keyword match retrieval, until retrieve required material, so very inconvenient and retrieval rate is slow, and sometimes may have omission, cause not finding required material, material is not found just to be equivalent to not find drawing, then slip-stick artist needs to repaint, add the workload of slip-stick artist, even delay production, although what also have can carry out the retrieval of multiple features coupling, but the feature interpretation carrying described material is above equivalent to just occupy a cell, so total amount of capacity (i.e. byte number) that this cell comprises is fixing, so total capacity can be divided into multiple part to give multiple different feature, the amount of capacity that each like this feature is assigned to is fixing, when the feature of the material needed does not reach this amount of capacity, then need to supply this capacity by mending 0, namely such as, the axial length that I needs the material retrieved is 51 millimeters, and I is allocated to this feature of axial length 4 bytes when starting to distribute, input 0051 is needed when then we retrieve, and when the feature of the material needed has exceeded this amount of capacity, then we just can not retrieve this feature, such retrieval is got up neither be very convenient.
Summary of the invention
Technical matters to be solved by this invention is: provide a kind of can material characteristics describes and stores in the handling of goods and materials of convenient and swift retrieval material method.
The technical solution adopted in the present invention is: a kind of method that 1, in handling of goods and materials, material characteristics describes and stores, and it comprises the following steps,
(1) the material principal character that user is concerned about is described and divides into groups;
(2) flat address pointer is set up;
(3) by material principal character and address pointer combinations of pairs one by one, Description standard is set up;
(4) Description standard set up according to step (3) is described each newly-increased material data and namely carries out Feature Combination;
(5) data after describing according to step (4) are stored in database;
(6) according to the method for address pointer isolation, feature decomposition is carried out and generated query table to the data in step (5) database;
(7) combination of multiple features search operaqtion is carried out to the question blank that step (6) generates.
Adopt above method compared with prior art, the present invention has the following advantages: by material characteristics and flat address pointer being matched, and forms Description standard, can the decomposition of realization character information and recombinant easily, retrieve convenient and swift, and implementation algorithm is simple, not easily makes mistakes; For single characteristic attribute, describe and do not limit by byte, without the need to complicated algorithm check byte position; Isolate the feature of each user care in feature interpretation with the form of visicode pointer, be convenient to very much the identification of feature, when needs investigation specific characteristic, user just only can investigate the data of corresponding symbolic pointer position correspondence, and investigation scope reduces greatly.
Accompanying drawing explanation
Fig. 1 is step block diagram of the present invention.
Embodiment
Below in conjunction with accompanying drawing and embodiment, the present invention is described further, but the present invention is not limited only to following embodiment.
As shown in the figure: a kind of method that 1, in handling of goods and materials, material characteristics describes and stores, it comprises the following steps,
(1) the material principal character that user is concerned about is described and divides into groups;
(2) flat address pointer is set up;
(3) by material principal character and address pointer combinations of pairs one by one, Description standard is set up;
(4) Description standard set up according to step (3) is described each newly-increased material data and namely carries out Feature Combination;
(5) data after describing according to step (4) are stored in database;
(6) according to the method for address pointer isolation, feature decomposition is carried out and generated query table to the data in step (5) database;
(7) combination of multiple features search operaqtion is carried out to the question blank that step (6) generates.
Specific embodiment one: the feature interpretation of machine shaft and storage:
(1) the material principal character that user is concerned about be described and divide into groups, being divided into 9 groups as table 1:
| Material characteristics | Material is distinguished | Surface treatment | Axle overall length | Axle external diameter | Axial trough spacing | Right-hand axis screw thread | Left-hand axis screw thread | The flat position of right-hand axis | The flat position of left-hand axis |
| Group | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
Table 1
(2) flat address pointer is set up; As table 2:
| Address pointer | ! | # | $ | % | ^ | & | ※ | § | |
| Position | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
Table 2
(3) by material principal character and address pointer combinations of pairs one by one, Description standard is set up; Pairing is as table 3 one by one:
| Material characteristics | Material is distinguished | Surface treatment | Axle overall length | Axle external diameter | Axial trough spacing | Right-hand axis screw thread | Left-hand axis screw thread | The flat position of right-hand axis | The flat position of left-hand axis |
| Address pointer | ! | # | $ | % | ^ | & | ※ | § |
Table 3
Set up Description standard as:! The flat position of § left-hand axis, surface treatment # axle overall length $ axle outside journal axle % separation ^ right-hand axis screw thread & left-hand axis screw thread ※ right-hand axis flat position distinguished by material.
(4) Description standard set up according to step (3) is described each newly-increased material data, namely carries out Feature Combination;
All Feature Combinations are a data block by this step, such as:! Rotating shaft GZ#144 $ 8%33.5^12M6 & 12M6Z ※ 50B6 § 50B6, the principal character that each rotating shaft user is concerned about like this has been combined, and is namely equivalent to coding.
(5) data after describing according to step (4) are stored in database;
This step is deposited into database by step (4) by the data (feature interpretation of each rotating shaft occupies the position of a cell) after description, forms the data aggregation that each rotating shaft feature interpretation record all only accounts for a cell.
(6) according to the method for address pointer isolation, feature decomposition is carried out and generated query table to the data in step (5) database;
Specific feature is pointed to by address pointer, the database that step (5) is formed is carried out feature decomposition, namely decoding is equivalent to, so address pointer is its buffer action, each feature of such decomposition rotating shaft feature interpretation data out occupies a cell, form the question blank that can be carried out multiple features retrieval, as table 4:
| Material code | Material is distinguished | Surface treatment | Axle overall length | Axle external diameter | Axial trough spacing | Right-hand axis screw thread | Left-hand axis screw thread | The flat position of right-hand axis | The flat position of left-hand axis |
| 1001 | Rotating shaft | GZ | 144 | 8 | 33.5 | 12M6 | 12M6Z | 50B6 | 50B6 |
| 1002 | Rotating shaft | GZ | 144 | 10 | 53.5 | 0 | 12M6 | 15B6 | 50B6 |
| …… | …… | …… | …… | …… | …… | …… | …… | …… | …… |
Table 4
(7) operations such as combination of multiple features retrieval are carried out to the question blank that step (6) generates.
Finally combination of multiple features retrieval is carried out to the question blank generated, so just can retrieve the material required for us.
Sum up namely we only need just can material required for combination in any retrieval according to feature name in question blank, as retrieved surface treatment GZ and axial trough spacing 53.5 just can retrieve the material that material code is No. 1002.
Claims (1)
1. the method that in handling of goods and materials, material characteristics describes and stores, is characterized in that: it comprises the following steps,
(1) the material principal character that user is concerned about is described and divides into groups; Corresponding group 1 distinguished by material, the corresponding group 2 of surface treatment, the corresponding group 3 of axle overall length, the corresponding group 4 of axle external diameter, the corresponding group 5 of axial trough spacing, the corresponding group 6 of right-hand axis screw thread, the corresponding group 7 of left-hand axis screw thread, the corresponding group 8 in the flat position of right-hand axis, the corresponding group 9 in the flat position of left-hand axis;
(2) flat address pointer is set up; Address pointer "! " correspondence position 1; address pointer " " correspondence position 2; address pointer " # " correspondence position 3; address pointer " $ " correspondence position 4; address pointer " % " correspondence position 5, address pointer " ^ " correspondence position 6, address pointer " & " correspondence position 7; address pointer " ※ " correspondence position 8, address pointer " § " correspondence position 9;
(3) by material principal character and address pointer combinations of pairs one by one, Description standard is set up, address pointer "! " material characteristics that points to is " material differentiation ", the material characteristics that address pointer " " points to is " surface treatment ", the material characteristics that address pointer " # " is pointed to is " axle overall length ", the material characteristics that address pointer " $ " points to is " axle external diameter ", the material characteristics that address pointer " % " points to is " axial trough spacing ", the material characteristics that address pointer " ^ " points to is " right-hand axis screw thread ", the material characteristics that address pointer " & " points to is " left-hand axis screw thread ", the material characteristics that address pointer " ※ " points to is " the flat position of right-hand axis ", the material characteristics that address pointer " § " points to is " the flat position of left-hand axis ", the Description standard set up is! the flat position of § left-hand axis, surface treatment # axle overall length $ axle external diameter % axial trough spacing ^ right-hand axis screw thread & left-hand axis screw thread ※ right-hand axis flat position distinguished by material,
(4) Description standard set up according to step (3) is described each newly-increased material data and namely carries out Feature Combination;
(5) data after describing according to step (4) are stored in database;
(6) according to the method for address pointer isolation, feature decomposition is carried out and generated query table to the data in step (5) database;
(7) combination of multiple features search operaqtion is carried out to the question blank that step (6) generates.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210219307.1A CN102799965B (en) | 2012-06-29 | 2012-06-29 | A kind of method that in handling of goods and materials, material characteristics describes and stores |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210219307.1A CN102799965B (en) | 2012-06-29 | 2012-06-29 | A kind of method that in handling of goods and materials, material characteristics describes and stores |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102799965A CN102799965A (en) | 2012-11-28 |
| CN102799965B true CN102799965B (en) | 2016-03-02 |
Family
ID=47199064
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210219307.1A Active CN102799965B (en) | 2012-06-29 | 2012-06-29 | A kind of method that in handling of goods and materials, material characteristics describes and stores |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102799965B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105069054A (en) * | 2015-07-23 | 2015-11-18 | 孔凡勇 | Material information query method and apparatus |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102201089A (en) * | 2011-06-10 | 2011-09-28 | 张宪 | Method for encoding and managing materials |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US8645233B2 (en) * | 2009-11-09 | 2014-02-04 | GM Global Technology Operations LLC | Software interface management systems and methods |
-
2012
- 2012-06-29 CN CN201210219307.1A patent/CN102799965B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102201089A (en) * | 2011-06-10 | 2011-09-28 | 张宪 | Method for encoding and managing materials |
Non-Patent Citations (1)
| Title |
|---|
| 企业编码主数据模型研究;黄云华等;《制造技术与机床》;20070331(第3期);第113-116页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102799965A (en) | 2012-11-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10558495B2 (en) | Variable sized database dictionary block encoding | |
| CN104685498B (en) | The hardware implementation mode of polymerization/division operation：Hash table method | |
| AU2009246432B2 (en) | Managing storage of individually accessible data units | |
| CN103729392B (en) | Enquiring and optimizing method and query compiler device | |
| US11573941B2 (en) | Systems, methods, and data structures for high-speed searching or filtering of large datasets | |
| KR101137147B1 (en) | Query forced indexing | |
| WO2015017361A1 (en) | Generating a multi-column index for relational databases by interleaving data bits for selectivity | |
| CN100530187C (en) | Method for converting search inquiry into inquiry statement | |
| US20120131022A1 (en) | Methods and systems for merging data sets | |
| CN106528641B (en) | Data storage method and device and communication gateway machine | |
| CN104252536A (en) | Hbase-based internet log data inquiring method and device | |
| US20140280279A1 (en) | Minimizing result set size when converting from asymmetric to symmetric requests | |
| CN104573022A (en) | Data query method and device for HBase | |
| CN102855277A (en) | Data center system and data processing method | |
| CN103064991A (en) | Mass data clustering method | |
| CN102799965B (en) | A kind of method that in handling of goods and materials, material characteristics describes and stores | |
| CN104462080A (en) | Index structure creating method and system with group statistics for search results | |
| CN102508839B (en) | Data processing device and data processing method | |
| US10013442B2 (en) | Database value identifier hash map | |
| CN110019306B (en) | SQL statement searching method and system based on XML format file | |
| Haque et al. | Distributed RDF triple store using hbase and hive | |
| CN108108392B (en) | Commodity data management method, commodity data management device, computer equipment and storage medium | |
| CN104714983B (en) | The generation method and device of distributed index | |
| CN104598520A (en) | Commodity information processing method and device | |
| CN110597851B (en) | Big data based data processing and report display method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20180126 Address after: 315191 Yinzhou District Province, Ningbo City, Jiang Shan town on the village of summer ho Patentee after: AUX air conditioning Limited by Share Ltd Address before: 315191 Mingguang North Road No. 1166 (AUX International Industrial Park), Yinzhou District Yinzhou Industrial Park, Ningbo, Zhejiang Patentee before: Ningbo Haicheng Electric al Appliances Co., Ltd. |
|
| TR01 | Transfer of patent right |