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 PDF

Info

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
Application number
CN202311050143.9A
Other languages
Chinese (zh)
Inventor
向哲爽
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Sichuan Huakun Zhenyu Intelligent Technology Co ltd
Original Assignee
Sichuan Huakun Zhenyu Intelligent Technology Co ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Sichuan Huakun Zhenyu Intelligent Technology Co ltd filed Critical Sichuan Huakun Zhenyu Intelligent Technology Co ltd
Priority to CN202311050143.9A priority Critical patent/CN117435624A/en
Publication of CN117435624A publication Critical patent/CN117435624A/en
Pending legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/245—Query processing
    • G06F16/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

Method for extracting selected material specific attribute from material management system in batches
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.
CN202311050143.9A 2023-08-18 2023-08-18 Method for extracting selected material specific attribute from material management system in batches Pending CN117435624A (en)

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)

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