CN112487012B - Component parameter obtaining method and device based on data screening - Google Patents
Component parameter obtaining method and device based on data screening Download PDFInfo
- Publication number
- CN112487012B CN112487012B CN202011259462.7A CN202011259462A CN112487012B CN 112487012 B CN112487012 B CN 112487012B CN 202011259462 A CN202011259462 A CN 202011259462A CN 112487012 B CN112487012 B CN 112487012B
- Authority
- CN
- China
- Prior art keywords
- data
- component
- database
- parameter
- category
- 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
- 238000000034 method Methods 0.000 title claims abstract description 24
- 238000012216 screening Methods 0.000 title claims abstract description 23
- 230000015654 memory Effects 0.000 claims description 5
- 238000010586 diagram Methods 0.000 description 5
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
Images
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
-
- 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
-
- 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/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a component parameter acquisition method and device based on data screening, which are used for classifying and pre-storing data in a data resource pool according to component categories and storing the data in a first database; the data of each component category comprises information data of all components of the component category, and the information data of each component comprises characteristic data and a plurality of parameter data; when receiving a component type input by a client terminal, calling out all information data corresponding to the component type from a first database and storing the information data in a second database according to the input component type; splitting parameter data in a second database according to prestored parameter splitting rules of corresponding component categories; and displaying the processed information data in the second database. The invention realizes the batch acquisition of parameter information of the same component type, and effectively solves the problems of low efficiency and high error rate of artificial analysis and judgment.
Description
Technical Field
The invention relates to the field of acquisition of component parameters, in particular to a component parameter acquisition method and device based on data screening.
Background
With the development of the server industry and the progress of informatization, the types and specifications of components are more and more complex, and the requirement of customers on the parameter information of product components is more detailed. The current database is respectively stored in different data tables according to the types of the components. A plurality of component parameters of the same type of components are stored in each data table, and the quantity value of the same type of components is larger. In the data display mode of the current system, only the parameters of one component can be inquired at one time. Such as hard disk and memory, different component types, different component parameters. The data tables stored in the hard disk and the memory are inconsistent. Under the hard disk and memory types, there are N pieces of data. When in query, the detailed search is generally carried out according to the unique identification of the component, namely the code material code. The query mode cannot meet the informatization requirement of rapid development, and in addition, the parameters of general components can be judged by manually analyzing the material description of the components, but the efficiency is low and the error rate is high.
Disclosure of Invention
In order to solve the above problems, the present invention provides a component parameter obtaining method and apparatus based on data screening.
The technical scheme of the invention is as follows: a component parameter acquisition method based on data screening comprises the following steps:
classifying and pre-storing data in the data resource pool according to component categories, and storing the data in a first database; the data of each component category comprises information data of all components of the component category, and the information data of each component comprises characteristic data and a plurality of parameter data;
when receiving a component category input by a client terminal, calling out all information data corresponding to the component category from a first database and storing the information data in a second database according to the input component category;
splitting parameter data in a second database according to prestored parameter splitting rules of corresponding component categories;
and displaying the processed information data in the second database.
Further, the method comprises the following steps:
when receiving a component category and a query parameter input by a client terminal, calling out all data of the corresponding component category from a first database and storing the data into a second database according to the input component category;
splitting parameter data in a second database according to prestored parameter splitting rules of corresponding component categories;
and calling all information data corresponding to the query parameters from the second database for display according to the query parameters.
Further, the characteristic data comprises material codes;
the method further comprises the following steps:
when a material code input by a client terminal is received, analyzing the component type according to the material code;
calling out all data of the corresponding component types from the first database and storing the data into the second database according to the component types;
according to the material codes, corresponding information data are taken out from the second database and stored in a third database;
splitting parameter data in a third database according to a prestored parameter splitting rule of a corresponding component category;
and displaying the processed information data in the third database.
Further, the method comprises the following steps:
when an order number input by a client terminal is received, analyzing all material codes according to the order number;
and (4) coding each material, and calling and displaying corresponding data according to the method in the previous step.
Further, the characteristic data also comprises material category and material description.
The technical scheme of the invention also comprises a component parameter acquisition device based on data screening, which comprises,
a data pre-storage module: classifying and pre-storing data in the data resource pool according to component categories, and storing the data in a first database; the data of each component category comprises information data of all components of the component category, and the information data of each component comprises characteristic data and a plurality of parameter data;
the query condition receiving module: receiving a query condition input by a client terminal;
a data acquisition module: calling relevant data from a first database according to a query condition input by a client terminal;
a parameter disassembling module: splitting the acquired parameter data according to a prestored parameter splitting rule of the corresponding component category;
the data display module: and displaying the acquired and split related data.
Further, the data obtaining module retrieves relevant data from the first database according to the query condition input by the client terminal, and specifically includes:
when receiving the input component type of the client terminal, or the component type and the query parameter, calling out all information data of the corresponding component type from the first database and storing the information data in the second database according to the input component type.
Further, the characteristic data comprises material codes;
the data acquisition module is used for calling related data from the first database according to the query condition input by the client terminal, and the data acquisition module further comprises:
when a material code input by a client terminal is received, analyzing the component type according to the material code; and calling out all data of the corresponding component category from the first database and storing the data into the second database according to the component category.
Further, the data obtaining module retrieves the relevant data from the first database according to the query condition input by the client terminal, and further includes:
when an order number input by a client terminal is received, analyzing all material codes according to the order number; coding each material, and analyzing the component type according to the material codes; and calling out all data of the corresponding component category from the first database and storing the data into the second database according to the component category.
Further, the characteristic data also comprises material category and material description.
According to the component parameter obtaining method and device based on data screening, data in a data resource pool are classified and prestored according to component types, the data are called according to query conditions such as the component types and the like input by a client terminal, parameter information of the same component types is obtained in batches, the data are screened according to the parameter types, and parameter information of a single component is accurately obtained according to material codes. And the parameter information of the order configuration component can be acquired by one key in association with the production order. The problems of low efficiency and high error rate of artificial analysis and judgment are effectively solved.
Drawings
FIG. 1 is a diagram of a query presentation interface with query conditions as component parameters according to an embodiment of the present invention;
FIG. 2 is a diagram of a query presentation interface with a query condition of an order number according to an embodiment of the present invention;
FIG. 3 is a schematic flow chart of a method according to an embodiment of the present invention;
FIG. 4 is a schematic flow chart of a second method of an embodiment of the present invention;
FIG. 5 is a schematic flow chart of a three-way process according to an embodiment of the present invention;
fig. 6 is a schematic block diagram of a fifth configuration according to an embodiment of the present invention.
Detailed Description
The present invention will be described in detail below with reference to the accompanying drawings by way of specific examples, which are illustrative of the present invention and are not limited to the following embodiments.
The invention provides a component parameter acquisition method based on data screening, which is characterized in that data in a data resource pool is classified and prestored according to component types (such as hard disks, memories) and the like, the data of each component type comprises information data of all components of the component type (namely n groups of data are included, n is the number of the components, and the information data of each component is a group), and the information data of each component comprises characteristic data and a plurality of parameter data. Specifically, the characteristic data includes material codes, material categories, and material descriptions.
When a client needs to call the relevant parameters, the client inputs the query conditions, and the background calls the data from the database according to the query conditions and displays the data. Fig. 1 is a schematic diagram of a query presentation interface with query conditions as component parameters (including component category, material code, and query parameters), and fig. 2 is a schematic diagram of a query presentation interface with query conditions as order numbers. The data shown is shown as tabular data.
Example one
As shown in fig. 3, the method for acquiring component parameters based on data screening provided in this embodiment uses a component category as a query condition, and specifically includes the following steps:
s101, classifying and pre-storing data in a data resource pool according to component categories, and storing the data in a first database; the data of each component category comprises information data of all components of the component category, and the information data of each component comprises characteristic data and a plurality of parameter data;
s102, when receiving the input component type of the client terminal, calling out all information data of the corresponding component type from the first database and storing the information data into the second database according to the input component type;
s103, splitting parameter data in a second database according to prestored parameter splitting rules of corresponding component categories;
s104, displaying the processed information data in the second database; the processed information data refers to information data obtained by splitting the parameter data.
It should be noted that, in the parameter data in the data resource pool, there are cases where a plurality of parameters are combined into one parameter, there are cases where a character is designated, and there are cases where a unit is default, so that a component parsing module is required to perform parsing operation on the parameter data.
Hard disk parameters such as material coding: capacity interface type D. Three pieces of parameter information which are convenient to identify and have the capacity of 1.8TB, the interface type of SAS and the non-SSD hard disk need to be analyzed. Rotation speed/Flash chip type size: the analysis was performed at a rotation speed of 10K and a size of 2.5 inches.
Example two
As shown in fig. 4, the method for acquiring component parameters based on data screening provided in this embodiment uses a component category and a query parameter as a query condition, and specifically includes the following steps:
s201, classifying and pre-storing data in a data resource pool according to component categories, and storing the data in a first database; the data of each component category comprises information data of all components of the component category, and the information data of each component comprises characteristic data and a plurality of parameter data;
s202, when receiving the input component type and the query parameter of the client terminal, calling out all data of the corresponding component type from the first database and storing the data into the second database according to the input component type;
s203, splitting the parameter data in the second database according to the prestored parameter splitting rule of the corresponding component category;
s204, calling all information data corresponding to the query parameters from the second database for display according to the query parameters; it should be noted that the displayed parameter data is split parameter data.
EXAMPLE III
As shown in fig. 5, the method for obtaining component parameters based on data screening provided in this embodiment uses material codes as query conditions, and specifically includes the following steps:
s301, classifying and pre-storing the data in the data resource pool according to the component types, and storing the data in a first database; the data of each component category comprises information data of all components of the component category, and the information data of each component comprises characteristic data and a plurality of parameter data;
s302, when a material code input by a client terminal is received, analyzing the component type according to the material code;
s303, calling out all data of the corresponding component types from the first database and storing the data into the second database according to the component types;
s304, calling corresponding information data from the second database according to the material codes and storing the corresponding information data in a third database;
s305, splitting parameter data in a third database according to pre-stored parameter splitting rules of corresponding component categories;
and S306, displaying the processed information data in the third database.
Example four
The method for acquiring component parameters based on data screening provided by the embodiment takes an order number as a query condition, and specifically comprises the following steps:
s401, when an order number input by a client terminal is received, analyzing all material codes according to the order number;
s402, coding each material, and calling and displaying corresponding data according to the method of the third embodiment.
EXAMPLE five
As shown in fig. 6, the present embodiment provides a component parameter obtaining apparatus based on data screening, which includes the following functional modules.
Data pre-storage module 1: classifying and pre-storing data in the data resource pool according to component categories, and storing the data in a first database; the data of each component category comprises information data of all components of the component category, and the information data of each component comprises characteristic data and a plurality of parameter data; the characteristic data comprises material codes, material types and material descriptions;
the query condition receiving module 2: receiving a query condition input by a client terminal;
the data acquisition module 3: calling relevant data from a first database according to a query condition input by a client terminal;
the parameter disassembling module 4: splitting the acquired parameter data according to a prestored parameter splitting rule of the corresponding component category;
the data display module 5: and displaying the acquired and split related data.
The data acquisition module calls related data from the first database according to the query condition input by the client terminal, and specifically comprises:
when receiving a component type input by a client terminal, or the component type and a query parameter, calling out all information data of the corresponding component type from a first database and storing the information data in a second database according to the input component type;
when a material code input by a client terminal is received, analyzing the component type according to the material code; calling out all data of the corresponding component types from the first database and storing the data into the second database according to the component types;
when an order number input by a client terminal is received, analyzing all material codes according to the order number; analyzing the component type according to the material codes for each material code; and calling out all data of the corresponding component category from the first database and storing the data into the second database according to the component category.
The above disclosure is only for the preferred embodiments of the present invention, but the present invention is not limited thereto, and any non-inventive changes that can be made by those skilled in the art and several modifications and amendments made without departing from the principle of the present invention shall fall within the protection scope of the present invention.
Claims (9)
1. A component parameter acquisition method based on data screening is characterized by comprising the following steps:
classifying and pre-storing data in the data resource pool according to component categories, and storing the data in a first database; the data of each component category comprises information data of all components of the component category, and the information data of each component comprises characteristic data and a plurality of parameter data; the component category comprises a hard disk and a memory, and the characteristic data comprises material codes;
when receiving a component type input by a client terminal, calling out all information data corresponding to the component type from a first database and storing the information data in a second database according to the input component type;
splitting parameter data in a second database according to prestored parameter splitting rules of corresponding component categories;
displaying the processed information data in the second database;
when a material code input by a client terminal is received, analyzing the component type according to the material code;
calling out all data of the corresponding component types from the first database and storing the data into the second database according to the component types;
according to the material codes, corresponding information data are taken out from the second database and stored in a third database;
splitting parameter data in a third database according to prestored parameter splitting rules of corresponding component categories;
and displaying the processed information data in the third database.
2. The data screening-based component parameter acquisition method of claim 1, further comprising the steps of:
when receiving a component category and a query parameter input by a client terminal, calling out all data of the corresponding component category from a first database and storing the data into a second database according to the input component category;
splitting parameter data in a second database according to prestored parameter splitting rules of corresponding component categories;
and calling all information data corresponding to the query parameters from the second database for display according to the query parameters.
3. The data screening-based component parameter acquisition method of claim 1, further comprising the steps of:
when an order number input by a client terminal is received, analyzing all material codes according to the order number;
and (4) coding each material, calling corresponding data and displaying.
4. The method for acquiring component parameters based on data screening according to claim 1 or 3, wherein the characteristic data further comprises a material category and a material description.
5. A component parameter acquisition device based on data screening is characterized by comprising,
a data pre-storage module: classifying and pre-storing data in the data resource pool according to component categories, and storing the data in a first database; the data of each component category comprises information data of all components of the component category, and the information data of each component comprises characteristic data and a plurality of parameter data;
the query condition receiving module: receiving a query condition input by a client terminal;
a data acquisition module: calling relevant data from a first database according to a query condition input by a client terminal;
a parameter disassembling module: splitting the acquired parameter data according to a prestored parameter splitting rule of the corresponding component category;
a data display module: and displaying the acquired and split related data.
6. The device for acquiring component parameters based on data screening according to claim 5, wherein the data acquiring module retrieves the relevant data from the first database according to the query condition input by the client terminal, and specifically comprises:
when receiving the input component type of the client terminal, or the component type and the query parameter, calling out all information data of the corresponding component type from the first database and storing the information data in the second database according to the input component type.
7. The data screening-based component parameter acquisition device of claim 6, wherein the characteristic data comprises a material code;
the data acquisition module retrieves relevant data from the first database according to the query condition input by the client terminal, and further comprises:
when a material code input by a client terminal is received, analyzing the component type according to the material code; and calling out all data of the corresponding component category from the first database and storing the data into the second database according to the component category.
8. The data-screening-based component parameter obtaining apparatus of claim 7, wherein the data obtaining module retrieves the relevant data from the first database according to the query condition input by the client terminal, further comprising:
when an order number input by a client terminal is received, analyzing all material codes according to the order number; analyzing the component type according to the material codes for each material code; and calling out all data of the corresponding component category from the first database and storing the data into the second database according to the component category.
9. The data-screening-based component parameter acquisition apparatus according to claim 7 or 8, wherein the characteristic data further includes a material category and a material description.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011259462.7A CN112487012B (en) | 2020-11-12 | 2020-11-12 | Component parameter obtaining method and device based on data screening |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011259462.7A CN112487012B (en) | 2020-11-12 | 2020-11-12 | Component parameter obtaining method and device based on data screening |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112487012A CN112487012A (en) | 2021-03-12 |
| CN112487012B true CN112487012B (en) | 2022-05-27 |
Family
ID=74929896
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011259462.7A Active CN112487012B (en) | 2020-11-12 | 2020-11-12 | Component parameter obtaining method and device based on data screening |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112487012B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113701819A (en) * | 2021-08-31 | 2021-11-26 | 四川省建筑科学研究院有限公司 | Building structure monitoring method, monitoring device, monitoring system and storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107562821A (en) * | 2017-08-17 | 2018-01-09 | 平安科技（深圳）有限公司 | Pivot method, apparatus and computer-readable storage medium based on database |
| KR20190058141A (en) * | 2017-11-21 | 2019-05-29 | 주식회사 루테스 | Method for generating data extracted from document and apparatus thereof |
| CN110875092A (en) * | 2018-08-31 | 2020-03-10 | 福州依影健康科技有限公司 | Health big data service method and system based on remote fundus screening |
| CN111786849A (en) * | 2020-06-28 | 2020-10-16 | 京东数字科技控股有限公司 | Monitoring method, device and system of domain name server and computer equipment |
-
2020
- 2020-11-12 CN CN202011259462.7A patent/CN112487012B/en active Active
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107562821A (en) * | 2017-08-17 | 2018-01-09 | 平安科技（深圳）有限公司 | Pivot method, apparatus and computer-readable storage medium based on database |
| KR20190058141A (en) * | 2017-11-21 | 2019-05-29 | 주식회사 루테스 | Method for generating data extracted from document and apparatus thereof |
| CN110875092A (en) * | 2018-08-31 | 2020-03-10 | 福州依影健康科技有限公司 | Health big data service method and system based on remote fundus screening |
| CN111786849A (en) * | 2020-06-28 | 2020-10-16 | 京东数字科技控股有限公司 | Monitoring method, device and system of domain name server and computer equipment |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112487012A (en) | 2021-03-12 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106919635B (en) | Group chat record query method and device and electronic equipment | |
| US10839504B2 (en) | User interface for managing defects | |
| CN110987493A (en) | Equipment abnormality detection method and device, storage medium and electronic equipment | |
| CN112052138A (en) | Service data quality detection method and device, computer equipment and storage medium | |
| CN113139078B (en) | Control chart generation method and electronic equipment | |
| EP2341426A1 (en) | Operation monitoring apparatus | |
| CN115236260A (en) | Chromatographic data storage method and device, electronic equipment and storage medium | |
| CN112487012B (en) | Component parameter obtaining method and device based on data screening | |
| EP3388909A1 (en) | Display method, display program, and display control device | |
| WO1990007163A1 (en) | Attribute inductive data analysis | |
| CN112364014A (en) | Data query method, device, server and storage medium | |
| CN108062401B (en) | Application recommendation method and device and storage medium | |
| CN110457219B (en) | Method and device for selecting time when test script is recorded | |
| CN111353558A (en) | Error detection method and device for identification code and terminal | |
| CN110633418A (en) | Commodity recommendation method and device | |
| JP2007323546A (en) | Retrieval processing method and device | |
| CN113807410B (en) | Image recognition method and device and electronic equipment | |
| CN111124841B (en) | Alarm method and device for abnormal page and computer system | |
| CN116931768A (en) | Method and device for bill of materials change management and storage medium | |
| US8224838B2 (en) | Database search method, program, and apparatus | |
| CN112698883A (en) | Configuration data processing method, device, terminal and storage medium | |
| CN112583660A (en) | Main domain and standby domain test comparison method, device and system of recommendation platform | |
| CN111080150A (en) | Production data analysis method, apparatus, device and medium | |
| CN107911423B (en) | Information pushing method and device, server and readable storage medium | |
| CN110765119A (en) | Client trend change presentation method and device and computer readable storage medium |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |