CN117435624A - Method for extracting selected material specific attribute from material management system in batches - Google Patents
Method for extracting selected material specific attribute from material management system in batches Download PDFInfo
- Publication number
- CN117435624A CN117435624A CN202311050143.9A CN202311050143A CN117435624A CN 117435624 A CN117435624 A CN 117435624A CN 202311050143 A CN202311050143 A CN 202311050143A CN 117435624 A CN117435624 A CN 117435624A
- Authority
- CN
- China
- Prior art keywords
- attribute
- data
- specific
- head
- column
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 24
- 238000000605 extraction Methods 0.000 claims description 6
- 230000008569 process Effects 0.000 claims description 5
- 230000014509 gene expression Effects 0.000 claims description 4
- 238000005457 optimization Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 230000008859 change Effects 0.000 description 2
- 238000006243 chemical reaction Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 238000011835 investigation Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
- G06F16/24553—Query execution of query operations
- G06F16/24554—Unary operations; Data partitioning operations
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- 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
- G06Q10/0875—Itemisation or classification of parts, supplies or services, e.g. bill of materials
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Engineering & Computer Science (AREA)
- Accounting & Taxation (AREA)
- Marketing (AREA)
- Finance (AREA)
- Development Economics (AREA)
- Computational Linguistics (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Software Systems (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- General Factory Administration (AREA)
Abstract
The invention belongs to the technical field of data processing, and provides a method for extracting specific properties of selected materials from a material management system in batches, which comprises the following steps: selecting a certain column of head-up corresponding data from a material source list to be queried as a mark attribute; searching for a mark attribute in the head-up data of the corresponding column of the system data statistics table, judging that the mark attribute is matched with the head-up data of the corresponding column of the system data statistics table when the mark attribute is equal to the head-up data of the corresponding column of the system data statistics table, and confirming the ordinate of the required specific attribute in the material source list; then, the corresponding zone bits of all the column attributes are read, when the zone bit is 1, the abscissa of the attribute is determined to be the required specific attribute, and the intersection point of the abscissa and the ordinate is the required data; placing the mark attribute under the head-up corresponding to the specific data statistics table, and placing the required data corresponding to the mark attribute according to the head-up corresponding sequence of the specific data statistics table; until all the search objects in the material source list to be queried are traversed, and a final required data table is obtained.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a method for extracting specific properties of selected materials from a material management system in batches.
Background
The product is formed by combining various materials, and the types and specifications of the materials are often complicated and various. Huge amounts of material information are typically digitally managed by IT material management systems or databases, each piece of material information containing detailed, comprehensive material attributes, forming a system list containing a large amount of data.
In the actual use process, for example, when a product configuration selection tool is manufactured, the model, the code, the description and the like of the materials related to the product are acquired. It is necessary to extract specific attributes for these materials from the data statistics of the materials management system.
When more materials need to be queried, and the needed specific attribute information is also separated from a system data statistical table containing massive information. If the device is manually searched, the device is low in efficiency, time-consuming and labor-consuming, and is extremely prone to error and omission.
Disclosure of Invention
The invention aims to provide a method for extracting selected material specific attributes from a material management system in batches, which can automatically derive a required specific material attribute list from a system material data statistics table in batches according to the mark attribute, flexibly change a material source needing to extract the attribute by adjusting the mark attribute, flexibly change the content of the specific attribute needing to be extracted, and also can be compatible with statistics table templates with different column sequences and different attribute names, and output data files with specific formats according to the requirement.
The invention solves the technical problems and adopts the following technical scheme:
a method of batch extracting selected material specific properties from a material management system, comprising the steps of:
preparing a system data statistical table, a material source list to be inquired and a specific data statistical table;
selecting a certain column of head-up corresponding data from a material source list to be queried as a mark attribute;
searching a mark attribute in the head-up data of the corresponding column of the system data statistics table, judging that the mark attribute is matched when the mark attribute is equal to the head-up data of the corresponding column of the system data statistics table, and confirming that the required specific attribute is on the ordinate of the material source list;
reading the corresponding zone bits of all the column attributes, and determining that the attribute is the abscissa of the specific attribute of the selected material when the zone bit is 1, wherein the intersection point of the abscissa and the ordinate is the required attribute data; extracting all the characteristic attributes to be extracted in sequence;
placing the mark attribute under the head-up corresponding to the specific data statistics table, and placing the required attribute data corresponding to the mark attribute in the head-up corresponding order of the specific data statistics table;
and repeating the process until all the search objects in the material source list to be queried are traversed, and obtaining a final required data table.
As further optimization, the attribute of the mark is adjustable, is a certain complete attribute and is used for one-to-one matching; or part of keywords or regular expressions in the attributes, which are used for searching the mark attributes meeting the requirements.
As further optimization, when the flag bit corresponding to all the column attributes is read, when the flag bit is 0, the attribute is not selected and does not need to be extracted, and when the flag bit is 1, the attribute is selected and needs to be extracted.
As further optimization, the specific content to be extracted can be selected by adjusting the zone bit of the material attribute of the system data statistics table; by changing the column order of a particular data statistics table, statistics tables of corresponding formats may be output.
As a further optimization, if the selected material is not in the system data statistics table, a 'not queried' is displayed at a corresponding position of the specific data statistics table to prompt that the material cannot be found.
As a further optimization, to avoid that null values displayed as null in material information in a specific data statistics table are converted into true null values by software, the actual character string "null" is not displayed, so that the conversion function is automatically turned off when the data are picked up, and the character string "null" is directly displayed.
The beneficial effects of the invention are as follows: according to the method for extracting the specific attributes of the selected materials from the material management system in batches, the other required attributes of the materials can be automatically extracted from the statistical table in batches according to one attribute keyword in the material list, and corresponding data files are generated, so that direct reference is facilitated. The extracted data can be comprehensive and complete, materials with the same attribute keywords can be extracted completely, the corresponding data is not omitted, and a data manager can evaluate the data state and the accuracy of the whole current system conveniently. The statistics table templates with different column sequences and different attribute names can be compatible, and data files with different formats can be output according to requirements.
Drawings
FIG. 1 is a flow chart of a method for batch extracting selected material specific properties from a material handling system according to embodiment 1 of the present invention;
FIG. 2 is a diagram of a system data statistics table A according to embodiment 2 of the present invention;
FIG. 3 is a schematic diagram of a list B of material sources to be queried in embodiment 2 of the present invention;
FIG. 4 is a diagram of a specific data statistics table C in embodiment 2 of the present invention;
FIG. 5 is a diagram showing the final desired data obtained in example 2 of the present invention;
FIG. 6 is a flow chart of a method for batch extracting specific properties of a selected material from a material handling system according to embodiment 2 of the present invention.
Detailed Description
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is apparent that the described embodiments are some embodiments of the present invention, but not all embodiments of the present invention. The components of the embodiments of the present invention generally described and illustrated in the figures herein may be arranged and designed in a wide variety of different configurations.
Example 1
The embodiment provides a method for extracting specific properties of selected materials from a physical management system in batches, a flow chart of which is shown in fig. 1, wherein the method comprises the following steps:
s1, preparing a system data statistics table, a material source list to be inquired and a specific data statistics table;
s2, selecting a certain column of head-up corresponding data from a material source list to be queried as a mark attribute;
s3, searching for a mark attribute in the head-up data of the corresponding column of the system data statistics table, and judging that the mark attribute is matched with the head-up data of the corresponding column of the system data statistics table when the mark attribute is equal to the head-up data of the corresponding column of the system data statistics table, and confirming that the required specific attribute is on the ordinate of the material source list;
s4, reading the corresponding zone bits of all column attributes, and when the zone bit is 1, determining that the attribute is the abscissa of the specific attribute of the selected material, wherein the intersection point of the abscissa and the ordinate is the required attribute data, and sequentially extracting all the characteristic attributes to be extracted;
s5, placing the mark attribute under the head-up corresponding to the specific data statistics table, and placing the required attribute data corresponding to the mark attribute in the order corresponding to the head-up corresponding to the specific data statistics table
S6, repeating the process until all the search objects in the material source list to be queried are traversed, and obtaining a final required data table.
In this embodiment, the flag attribute may be adjustable, and may be a certain complete attribute, which is used for one-to-one matching; or part of keywords or regular expressions in the attributes, which are used for searching the mark attributes meeting the requirements.
It should be noted that, when the flag bit corresponding to all column attributes is read, when the flag bit is 0, it indicates that the attribute is not selected, and extraction is not required, and when the flag bit is 1, it indicates that the attribute is selected, and extraction is required.
In this embodiment, the flag bit of the material attribute of the system data statistics table can be prepared through adjusting the table, the specific content to be extracted is selected, and the statistics table with the corresponding format is output through changing the column sequence of the specific data statistics table; if the selected material is not in the system data statistics table, the 'not queried' is displayed at the corresponding position of the specific data statistics table to prompt that the material is not found.
In addition, the information in the material information in the specific data statistics table is displayed as null value of null, so that the information is prevented from being converted into real null value, and the actual character string 'null' is not displayed, so that the conversion function is automatically closed when the data are picked up, and the character string 'null' is directly displayed.
Example 2
Referring to table a in fig. 2, table B in fig. 3, and table C in fig. 4, assuming that specific properties of a selected material need to be obtained from a system data statistics table, three tables are first prepared—table a: system data statistics, table B: list of sources to be queried, table C: a particular data statistics table.
Firstly, a certain column of head-up corresponding data is selected from the table B to be used as a mark attribute for searching, and the mark attribute is adjustable by taking sales codes as an example of the mark attribute, and can be a certain complete attribute for one-to-one matching. Or may be part of a key word or regular expression in the attribute to find a satisfactory flag attribute. Meanwhile, confirming the data attribute to be extracted, firstly listing all column attributes in a table A, and setting a corresponding zone bit for each attribute to determine whether the attribute needs to be extracted or not, for example, when the zone bit is 0, the attribute is not selected and does not need to be extracted; when the flag bit is 1, it indicates that the attribute is selected and needs to be extracted. Here, the attribute of the corresponding column in the table C is selected as an example, and the data sequence corresponding to the table C can be flexibly adjusted.
In practical application, referring to fig. 6, the method for extracting the specific properties of the selected materials from the material management system in batches according to the embodiment may be implemented according to the following steps:
a. confirm the required data ordinate (representing the position of the row): the sales code is used as a circulation variable, the circulation variable is searched in the corresponding column head-up in the table A, and if the two values are equal, the matching is judged, and the ordinate is determined.
b. Confirm the required data abscissa (representing column position): after confirming the ordinate, the flag bit corresponding to the column attribute is read, when the flag bit is 1, the attribute is the required abscissa, the abscissas and the ordinates intersect to acquire the required specific data, the cycle is sequentially carried out, and all the required data are extracted.
c. And (3) deriving the extracted data: and (3) putting the mark attribute sales coding data into the corresponding head-up of the table C according to the circulation order. And putting the specific data corresponding to the mark attribute into the table according to the sequence corresponding to the head-up of the table C. This process is repeated until all the lookup objects in table B have been traversed, resulting in the final desired data table, as shown in fig. 5.
The above method of the present embodiment further has the following features in terms of extracting data: for one code multiple, all repetition codes can be listed for analysis and judgment by a data manager. And under the condition of one code with multiple objects, only partial materials are led out, so that hidden danger is generated. If the selected material is not in the system data statistics table, the 'not queried' is displayed at the corresponding position of the table C to prompt that the material is not found, so as to be analyzed and judged by a data manager. The material which is not inquired is prevented from being skipped, and the investigation is inconvenient. The information in the material information is displayed as null value of null, and part of the tool is converted into true null value instead of displaying the character string of null. When the data are picked up, the automatic turn-off escape function directly displays null, and the inconsistency of the extracted data and the system data is prevented.
The above is only a preferred embodiment of the present invention, and is not intended to limit the present invention, but various modifications and variations can be made to the present invention by those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (6)
1. A method for batch extraction of selected material specific properties from a material management system, comprising the steps of:
preparing a system data statistical table, a material source list to be inquired and a specific data statistical table;
selecting a certain column of head-up corresponding data from a material source list to be queried as a mark attribute;
searching a mark attribute in the head-up data of the corresponding column of the system data statistics table, judging that the mark attribute is matched when the mark attribute is equal to the head-up data of the corresponding column of the system data statistics table, and confirming that the required specific attribute is on the ordinate of the material source list;
reading the corresponding zone bits of all the column attributes, and determining that the attribute is the abscissa of the specific attribute of the selected material when the zone bit is 1, wherein the intersection point of the abscissa and the ordinate is the required attribute data; extracting all the characteristic attributes to be extracted in sequence;
placing the mark attribute under the head-up corresponding to the specific data statistics table, and placing the required attribute data corresponding to the mark attribute in the head-up corresponding order of the specific data statistics table;
and repeating the process until all the search objects in the material source list to be queried are traversed, and obtaining a final required data table.
2. The method for batch extraction of selected material specific properties from a material management system according to claim 1, wherein said flag property is adjustable to a certain complete property for one-to-one matching; or part of keywords or regular expressions in the attributes, which are used for searching the mark attributes meeting the requirements.
3. The method for batch extraction of selected material specific attributes from a material management system according to claim 1, wherein when the flag bits corresponding to all column attributes are read, the flag bits are 0, which indicates that the attribute is not selected and does not need to be extracted, and when the flag bits are 1, which indicates that the attribute is selected and does need to be extracted.
4. The method for batch extraction of selected material specific properties from a material management system according to claim 1, wherein the specific content to be extracted can be selected by adjusting the flag bit of the material properties of the system data statistics table; by changing the column order of a particular data statistics table, statistics tables of corresponding formats may be output.
5. The method of claim 1, wherein if the selected material is not in the system data statistics, displaying "not queried" in a location corresponding to the particular data statistics to indicate that the material is not found.
6. A method of mass extracting selected material specific properties from a physical management system according to any of claims 1-5, wherein to avoid that null values displayed as null in material information in a specific data statistics table are overridden by software to true null values without displaying the actual string "null", the override function is automatically turned off when picking up the data, and the string "null" is displayed directly.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202311050143.9A CN117435624A (en) | 2023-08-18 | 2023-08-18 | Method for extracting selected material specific attribute from material management system in batches |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN202311050143.9A CN117435624A (en) | 2023-08-18 | 2023-08-18 | Method for extracting selected material specific attribute from material management system in batches |
Publications (1)
Publication Number | Publication Date |
---|---|
CN117435624A true CN117435624A (en) | 2024-01-23 |
Family
ID=89552309
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN202311050143.9A Pending CN117435624A (en) | 2023-08-18 | 2023-08-18 | Method for extracting selected material specific attribute from material management system in batches |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN117435624A (en) |
-
2023
- 2023-08-18 CN CN202311050143.9A patent/CN117435624A/en active Pending
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US8799772B2 (en) | System and method for gathering, indexing, and supplying publicly available data charts | |
CN106528684B (en) | Method and system for establishing engineering material database | |
CN107004141A (en) | To the efficient mark of large sample group | |
CN104573022A (en) | Data query method and device for HBase | |
CN111143478A (en) | Two-three-dimensional file association method based on lightweight model and engineering object bit number | |
CN104346331A (en) | Retrieval method and system for XML database | |
CN112036118B (en) | Configurable data report dynamic display method and system | |
CN111858728A (en) | Data extraction method, device and equipment for different data sources and storage medium | |
CN110826299A (en) | General template log analysis method based on classification | |
CN105677723A (en) | Method for establishing and searching data labels for industrial signal source | |
CN117435624A (en) | Method for extracting selected material specific attribute from material management system in batches | |
CN104636471A (en) | Procedure code finding method and device | |
CN115510289B (en) | Data cube configuration method and device, electronic equipment and storage medium | |
CN116842076A (en) | Data analysis method, device, analysis equipment and readable storage medium | |
CN111143356B (en) | Report retrieval method and device | |
CN114511027B (en) | Method for extracting English remote data through big data network | |
CN112967759B (en) | DNA material evidence identification STR typing comparison method based on memory stack technology | |
JP2001014333A (en) | Image retrieval system and image database management device | |
CN109783455B (en) | Large-scale data-based management method, system and storage device | |
CN112612893A (en) | Electronic file case generation system | |
US7873659B2 (en) | Database management system, database management method and database management program | |
CN115630154B (en) | Big data environment-oriented dynamic abstract information construction method and system | |
CN110781245A (en) | Method for constructing national culture knowledge data warehouse | |
CN113139106B (en) | Event auditing method and device for security check | |
CN113760913B (en) | Elasticity-extensible equipment cost acquisition method |
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 |