CN111046032A - Data accessory building method and device - Google Patents
Data accessory building method and device Download PDFInfo
- Publication number
- CN111046032A CN111046032A CN201911306849.0A CN201911306849A CN111046032A CN 111046032 A CN111046032 A CN 111046032A CN 201911306849 A CN201911306849 A CN 201911306849A CN 111046032 A CN111046032 A CN 111046032A
- Authority
- CN
- China
- Prior art keywords
- data
- accessory
- standard
- accessory data
- cleaned
- 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
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/21—Design, administration or maintenance of databases
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/285—Clustering or classification
-
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Business, Economics & Management (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Quality & Reliability (AREA)
- Data Mining & Analysis (AREA)
- Economics (AREA)
- Development Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Strategic Management (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a data accessory building method and a data accessory building device, wherein the method comprises the following steps: collecting accessory data; cleaning the accessory data to obtain cleaned accessory data; and classifying the cleaned accessory data. The method enables the provision of standard accessory data.
Description
Technical Field
The invention relates to the technical field of automobile accessories, in particular to a data accessory building method and device.
Background
At present, for automobile accessory data, accessory data in a service system are single in source, and terminal clients maintain the data more complexly. Moreover, the accessory data of the terminal client is not standard and the classification is not clear, so that the service personnel cannot clearly identify the correct accessory data. Moreover, the data of the service system processing accessories does not reach the professional level and cannot meet the market demand. Therefore, how to provide standard accessory data is a problem to be solved urgently.
Disclosure of Invention
The invention aims to provide a data accessory building method and device to provide standard accessory data.
In order to solve the technical problem, the invention provides a data accessory construction method, which comprises the following steps:
collecting accessory data;
cleaning the accessory data to obtain cleaned accessory data;
and classifying the cleaned accessory data.
Preferably, the collecting accessory data comprises:
receiving accessory data which is individually input by a user;
receiving accessory data uploaded by users in batches;
and establishing an accessory service interface, and acquiring accessory data in the ERP management system by using the accessory service interface.
Preferably, the cleaning of the accessory data includes:
accessory data is normalized and incomplete accessory data is filtered out.
Preferably, the classifying the cleaned accessory data includes:
the cleaned accessory data is divided into standard data, non-standard data and invalid data.
The invention also provides a data accessory building device, which is used for realizing the method and comprises the following steps:
a collection module for collecting accessory data;
the cleaning module is used for cleaning the accessory data to obtain the cleaned accessory data;
and the classification module is used for classifying the cleaned accessory data.
Preferably, the collection module includes:
the first receiving unit is used for receiving accessory data which are individually input by a user;
the second receiving unit is used for receiving accessory data uploaded by users in batches;
and the acquisition unit is used for establishing an accessory service interface and acquiring accessory data in the ERP management system by using the accessory service interface.
Preferably, the cleaning module is specifically configured to standardize the accessory data and filter out incomplete accessory data to obtain cleaned accessory data.
Preferably, the sorting module is specifically configured to sort the cleaned accessory data into standard data, non-standard data, and invalid data.
According to the data accessory building method and device provided by the invention, accessory data is collected; cleaning the accessory data to obtain cleaned accessory data; and classifying the cleaned accessory data. Therefore, after the accessory data are collected, the accessory data are cleaned, the cleaned accessory data conform to the standard data, the accessory data are classified after being cleaned, the standard accessory data are obtained, the standard accessory data are provided, and the standard, standard and high-availability accessory data are established.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only embodiments of the present invention, and for those skilled in the art, other drawings can be obtained according to the provided drawings without creative efforts.
FIG. 1 is a flow chart of a data fitting construction method provided by the invention;
FIG. 2 is a flow chart of accessory collection;
FIG. 3 is a flow chart of the accessory cleaning;
FIG. 4 is a flow chart of the accessory warehousing;
FIG. 5 is an accessory data processing flow diagram;
fig. 6 is a schematic structural diagram of a data accessory building device provided by the invention.
Detailed Description
The core of the invention is to provide a data accessory building method and a data accessory building device so as to provide standard accessory data.
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Referring to fig. 1, fig. 1 is a flowchart of a data accessory building method provided by the present invention, where the method includes the following steps:
s11: collecting accessory data;
s12: cleaning the accessory data to obtain cleaned accessory data;
s13: and classifying the cleaned accessory data.
Therefore, in the method, after the accessory data are collected, the accessory data are cleaned, the cleaned accessory data conform to the standard data, the accessory data are classified after being cleaned, the standard accessory data are obtained, the standard accessory data are provided, and the purpose that the standard, standard and high-availability accessory data are established is achieved.
In detail, accessory information is collected through various supply channels, original data are accumulated, the accumulated original data are cleaned and integrated through butting of various data companies, and the accumulated original data are applied to the industry to provide standard business data.
Based on the above method, further, step S11 includes the following steps:
s21: receiving accessory data which is individually input by a user;
s22: receiving accessory data uploaded by users in batches;
s23: and establishing an accessory service interface, and acquiring accessory data in the ERP management system by using the accessory service interface.
The execution main body of the method is a data accessory building device which is arranged on a business system. In the accessory collection, the service system provides accessory uploading service, when the data volume is large, accessories can be uploaded on a page in batch through excel, the excel specifies a template format through the service, a terminal client fills in accessory information according to the template, and the filled excel is uploaded to a platform. When the data volume is small, the terminal customer enters a single accessory on the page, the main field of the accessory is inquired in the accessory standard data of the service system, the inquired result is returned to the page, the terminal customer can enter the accessory quickly by slightly adjusting the accessory standard data, the result of the accessory entry can be quickly and conveniently obtained due to the fact that the page is provided with the quicker operation, and if the entry is mistaken, the adjustment can be carried out in time.
Additionally, ERP third-party system docking is employed to collect accessory data, including active docking and passive docking. The active docking is that a terminal client pushes a self sales accessory through a service interface of a service system accessory. The service system provides a uniform accessory service interface, the terminal client applies for an open platform account number, and accessories are actively pushed to the service system. The passive docking is that the ERP system of the terminal client provides an interface, and the business system actively acquires the sales accessories of the terminal client. The terminal client has an ERP system and a mature service interface, the service system develops the corresponding interface for butt joint, the terminal client configures accessory data to be sold in the service system in the ERP system, then the accessory data is actively acquired by the service system, and the accessory data is collected to the service system. Referring to fig. 2, fig. 2 is a flow chart of accessory collection, and during the process of storing accessories in a warehouse, the accessories are specifically recorded into different accessory libraries according to the cleaning rules.
The price inquiry sheet of the business system can be pushed to a plurality of local terminal clients for quotation, price inquiry sheet accessories are data sources of damage assessment accessories for claim settlement, and the business system regularly collects the quotation accessories of the terminal clients to obtain the latest accessory price information. Meanwhile, price inquiry orders initiated by repair shops, personal users and insurance company claim settlement systems are quoted through supplier terminal customers of the service system to form transaction data, and the service system collects the quoted part data of the supplier terminal customers regularly.
Further, in step S12, the process of cleaning the accessory data is as follows: accessory data is normalized and incomplete accessory data is filtered out.
Since the collected parts may be non-standard and non-standardized, a cleaning function is established in order to standardize and normalize the parts data. The cleaning process is to provide accessory data such as: the OE is provided for the data service provider, and the data service provider screens and matches out full data information consistent with conditions in a database of the data service provider, and the OE mainly comprises the following steps: the model brand, the price of a 4S store, the standard name of accessories and the standard adaptive model. OE is a uniform reference number for an accessory, generally designated by the manufacturer, and by which the specific accessory can be quickly located, and by which the automobile accessory wholesaler, agent, automobile repair plant, and accessory user. Referring to fig. 3, fig. 3 is a flow chart of accessory cleaning.
Through cleaning, the data of the accessories are standardized and normalized, and a uniform and standard accessory data standard is established. The data service provider selected in the cleaning process has to have certain requirements and can have comprehensive data standard information of the automobile parts, and then the information of the parts can be fully matched. If the service system has the automobile accessory database, the automobile accessory database can be used for replacing data of a data service provider, and the automobile accessory database and the data service provider can be used in combination, so that the higher the matching rate is, the better the matching rate is. The automobile accessory database refers to a standard accessory information database produced by an automobile production host factory.
Further, the process of step S13 is: the cleaned accessory data is divided into standard data, non-standard data and invalid data.
After the cleaning is finished, the accessories are divided into three types of commodity data according to the cleaning result: standard data, non-standard data, invalid data. The standard data indicates that the accessory data conforms to the standards of the host factory, the data vendor and the business system. The non-standard data indicates that the accessory data does not conform to the standard rule specified by the business system and can reach the standard through data correction. Invalid data indicates that the accessory data does not meet the necessary standards of the host factory, the data vendor and the business system. And finally, establishing a unified standard accessory product library and storing standard accessory data. According to standard accessory database data, a humanized and intelligent accessory service system is optimized, and integrated intelligent service is provided for various terminals. Referring to fig. 4, fig. 4 is a flow chart of accessory warehousing, during a cleaning process, data with an effective OE and an ineffective brand quality are classified into a non-standard library, data with an effective OE and an effective brand quality are classified into a standard library, data with an ineffective OE and brand quality are classified into an ineffective library, and if an accessory type is a maintenance wearing part, OE is not necessarily filled, accessory data are manually checked and an accessory warehousing type is allocated.
In the prior art, a standard accessory data system does not exist, the rapid expansion of the existing business cannot be met, and the data chains of the upstream and the downstream cannot be linked rapidly. The method solves the requirements of a service system and a user, and comprises the following steps:
(1) the problem that the upstream and downstream data are not matched is solved, and the transfer mining by the pin cannot be realized;
(2) standardized management of warehouse logistics, namely, paying a difference from the traditional offline to find manufacturer's required goods;
(3) the manufacturer is helped to accelerate the stock turnover through rapid ordering and rapid response.
The method realizes upward expansion of services, links such as whole supply chain transaction, warehouse allocation, settlement and the like are opened, the whole transaction is online and digitalized, and the information is more transparent. And moreover, scattered accessory data are integrated, a standard terminal customer accessory sales system is built, and the terminal customer accessory data are standardized, so that the accessory data can provide standard service to the outside, and the efficiency of accessory service is improved.
The method completes the integration of multiple accessory data sources, provides stable and high-quality data business services, and ensures the standardization, the safety and the high availability of the accessory sold by a terminal customer.
Based on the method, in detail, fig. 5 is an accessory data processing flow chart, and the accessory data processing flow is as follows:
1. uploading/adding new commodities;
collecting and summarizing accessories from each channel to form uniform original accessory data; the service system establishes an excel uploading batch accessory function, establishes a page entry single accessory function, establishes an ERP interface docking function and establishes a timed task collection quotation inquiry accessory function;
2. cleaning the data of the accessories;
the collected accessory data is standardized, incomplete data is filtered out, data meeting conditions are further improved, and data standards of a business system are met. Connecting high-quality and stable accessory data merchants and establishing high-efficiency cleaning capacity;
3. establishing a standard commodity library;
wherein, according to the result that the accessory is washd, the accessory can be divided into three main categories: standard data, non-standard data, invalid data. And establishing a graded and definite accessory commodity library to meet different business requirements.
4. And establishing a product library.
Wherein, standard accessory product data is summarized according to accessories in the standard commodity library.
Referring to fig. 6, fig. 6 is a schematic structural diagram of a data accessory constructing device provided by the present invention, for implementing the method, the device includes:
a collection module 101 for collecting accessory data;
the cleaning module 102 is configured to clean the accessory data to obtain cleaned accessory data;
and the classification module 103 is used for classifying the cleaned accessory data.
Therefore, after the device collects the accessory data, the accessory data are cleaned, the cleaned accessory data conform to the standard data, the accessory data are classified after cleaning, the standard accessory data are obtained, the standard accessory data are provided, and the purpose that the standard, standard and high-availability accessory data are established is achieved.
Based on the above device, further, the collection module includes:
the first receiving unit is used for receiving accessory data which are individually input by a user;
the second receiving unit is used for receiving accessory data uploaded by users in batches;
and the acquisition unit is used for establishing an accessory service interface and acquiring accessory data in the ERP management system by using the accessory service interface.
Furthermore, the cleaning module is specifically used for standardizing the accessory data and filtering out incomplete accessory data to obtain cleaned accessory data.
Further, the sorting module is specifically configured to sort the cleaned accessory data into standard data, non-standard data, and invalid data.
The embodiments are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same or similar parts among the embodiments are referred to each other. The device disclosed by the embodiment corresponds to the method disclosed by the embodiment, so that the description is simple, and the relevant points can be referred to the method part for description.
Those of skill would further appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both, and that the various illustrative components and steps have been described above generally in terms of their functionality in order to clearly illustrate this interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
The steps of a method or algorithm described in connection with the embodiments disclosed herein may be embodied directly in hardware, in a software module executed by a processor, or in a combination of the two. A software module may reside in Random Access Memory (RAM), memory, Read Only Memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.
The data accessory building method and device provided by the invention are described in detail above. The principles and embodiments of the present invention are explained herein using specific examples, which are presented only to assist in understanding the method and its core concepts. It should be noted that, for those skilled in the art, it is possible to make various improvements and modifications to the present invention without departing from the principle of the present invention, and those improvements and modifications also fall within the scope of the claims of the present invention.
Claims (8)
1. A data accessory construction method is characterized by comprising the following steps:
collecting accessory data;
cleaning the accessory data to obtain cleaned accessory data;
and classifying the cleaned accessory data.
2. The method of claim 1, wherein the collecting accessory data comprises:
receiving accessory data which is individually input by a user;
receiving accessory data uploaded by users in batches;
and establishing an accessory service interface, and acquiring accessory data in the ERP management system by using the accessory service interface.
3. The method of claim 1, wherein the cleaning the fitting data comprises:
accessory data is normalized and incomplete accessory data is filtered out.
4. The method of claim 1, wherein the sorting the cleaned part data comprises:
the cleaned accessory data is divided into standard data, non-standard data and invalid data.
5. A data accessory construction apparatus for carrying out the method of any one of claims 1 to 4, comprising:
a collection module for collecting accessory data;
the cleaning module is used for cleaning the accessory data to obtain the cleaned accessory data;
and the classification module is used for classifying the cleaned accessory data.
6. The apparatus of claim 5, wherein the collection module comprises:
the first receiving unit is used for receiving accessory data which are individually input by a user;
the second receiving unit is used for receiving accessory data uploaded by users in batches;
and the acquisition unit is used for establishing an accessory service interface and acquiring accessory data in the ERP management system by using the accessory service interface.
7. The apparatus of claim 5, wherein the cleaning module is specifically configured to normalize the accessory data and filter out incomplete accessory data to obtain cleaned accessory data.
8. The apparatus of claim 5, wherein the classification module is specifically configured to classify the cleaned part data into standard data, non-standard data, and invalid data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911306849.0A CN111046032A (en) | 2019-12-18 | 2019-12-18 | Data accessory building method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911306849.0A CN111046032A (en) | 2019-12-18 | 2019-12-18 | Data accessory building method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111046032A true CN111046032A (en) | 2020-04-21 |
Family
ID=70237312
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911306849.0A Pending CN111046032A (en) | 2019-12-18 | 2019-12-18 | Data accessory building method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111046032A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105740257A (en) * | 2014-12-09 | 2016-07-06 | 朗新科技股份有限公司 | Method and system for establishing standard geographic name address base |
| CN108897882A (en) * | 2018-07-05 | 2018-11-27 | 北京精友时代信息技术发展有限公司 | A kind of accessory basic data management system for serving vehicle insurance |
| CN109766336A (en) * | 2019-02-18 | 2019-05-17 | 安徽典典科技发展有限责任公司 | Data auto-cleaning method based on DataPurge component |
-
2019
- 2019-12-18 CN CN201911306849.0A patent/CN111046032A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105740257A (en) * | 2014-12-09 | 2016-07-06 | 朗新科技股份有限公司 | Method and system for establishing standard geographic name address base |
| CN108897882A (en) * | 2018-07-05 | 2018-11-27 | 北京精友时代信息技术发展有限公司 | A kind of accessory basic data management system for serving vehicle insurance |
| CN109766336A (en) * | 2019-02-18 | 2019-05-17 | 安徽典典科技发展有限责任公司 | Data auto-cleaning method based on DataPurge component |
Non-Patent Citations (1)
| Title |
|---|
| 杨添琴: ""基于汽车产业链协同平台的配件需求预测***研究与实现"", 《中国优秀博硕士学位论文全文数据库(硕士) 信息科技辑》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20190066196A1 (en) | Client Centric Viewer | |
| CN108090712B (en) | Method and device for analyzing business abnormity | |
| CN109685421A (en) | A kind of commodity inventory control method, apparatus, storage medium and terminal | |
| CN106408095B (en) | Ship equipment spare part management system and method | |
| US20220188756A1 (en) | Systems and methods for inventory control and optimization | |
| CN112511846A (en) | E-commerce live broadcast processing method based on big data and network security live broadcast platform | |
| CN114820140A (en) | Furniture full-link digital operation system based on big data analysis | |
| CN110634015A (en) | Consumption habit analysis system based on computer software | |
| CN112214508A (en) | Data processing method and device | |
| CN115423289A (en) | Intelligent plate processing workshop data processing method and terminal | |
| CN115759937A (en) | Non-standard product retail sales management system based on big data analysis | |
| CN115082153A (en) | Merchant quality evaluation method and device, electronic equipment and storage medium | |
| Anderson et al. | Firm heterogeneity and export pricing in india | |
| CN111311381A (en) | Commodity recommendation method and system | |
| CN112365321A (en) | Method for realizing effective supervision and identification of fresh electronic commerce platform multi-merchant commodities | |
| CN112258220A (en) | Information acquisition and analysis method, system, electronic device and computer readable medium | |
| CN110223104B (en) | Big data-based customer model construction system | |
| CN111046032A (en) | Data accessory building method and device | |
| CN114648389A (en) | Electronic commerce information processing system | |
| CN112270537B (en) | Multi-channel bill storage method, system and storage medium | |
| CN114971083A (en) | Method for purchasing, predicting and selling goods | |
| CN114663108A (en) | E-commerce product sales detection method and detection system based on big data technology | |
| CN111415207B (en) | Optimal ordering period prediction system and method for seasonal and periodic commodities | |
| CN111768139B (en) | Stock processing method, apparatus, device and storage medium | |
| CN113052381A (en) | E-commerce marketing and management system based on big data |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200421 |
|
| RJ01 | Rejection of invention patent application after publication |