CN112732709A - Data table management method, system, electronic device and storage medium - Google Patents
Data table management method, system, electronic device and storage mediumDownload PDFInfo
- Publication number
- CN112732709A CN112732709ACN202011567900.6ACN202011567900ACN112732709ACN 112732709 ACN112732709 ACN 112732709ACN 202011567900 ACN202011567900 ACN 202011567900ACN 112732709 ACN112732709 ACN 112732709A
- Authority
- CN
- China
- Prior art keywords
- product
- data table
- information
- checked
- data
- 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.)
- Granted
Links
Images
Classifications
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
Description
Technical Field
The present application relates to the field of information management technologies, and in particular, to a method, a system, an electronic device, and a storage medium for managing a data table.
Background
In the data management of an enterprise, product shelving information needs to be checked and related responsible management personnel needs to be informed to supplement the shelving information of product materials with incomplete shelving information. In the information management process of the products on shelves, the information on shelves of the products on shelves in each channel is checked manually at present, including but not limited to: and (4) preparation conditions of pictures, detail pages and video materials, and informing related responsible managers of specific inspection results to supplement the product materials with incomplete information on shelves.
The product shelving information checking mode has the defects that products of different brands can be found in the same brand, the products of different categories can be managed by different departments belonging to an enterprise, and the products of the same product can be shelved in different channels, so that the management of product shelving information can involve multiple aspects such as brands, categories, attribution departments, shelving channels and the like. Because the product information management measuring tool is large, the product subordinate department is not unique, and the product data management process is not clear, the product material with incomplete information of the product on the shelf can not be supplemented timely and effectively. The workload of manual inspection is large, the timeliness and accuracy of product shelving information collection cannot be guaranteed, the completeness of the shelving information of the product in each channel cannot be obtained through a specific product, and a product shelving information statistical table cannot be accurately, timely and efficiently provided according to requirements.
Disclosure of Invention
In view of the above, the present application is proposed to provide a data table management method, system, electronic device and storage medium that overcome or at least partially solve the above-mentioned problems.
According to an aspect of the present application, there is provided a data table management method, including:
acquiring product data table information, and screening out product information to be checked from the product data table information; acquiring information of an on-line and/or off-line channel product listing standard data table; wherein, product data table information and standard data table information of putting on shelf all include: the method comprises the following steps of (1) data table transverse header contents, fixed format requirements corresponding to the transverse header contents and data information in a data table;
generating a data table to be checked according to the correlation between the product information to be checked in the product data table and the information of the standard data table on which the product is put;
acquiring a data table to be checked, and determining the integrity of information on shelves of each product in the data table to be checked according to the data table to be checked and the data table to be checked;
and generating an un-ready product data table according to the shelf information integrity of each product, wherein the un-ready product data table comprises the data information of each product of which the shelf information integrity is less than a preset threshold value.
Optionally, in the above method, the acquiring information of the product data table includes:
acquiring data information of each product in the product data table, wherein the data information comprises: the data structure of the data, the storage address, a plurality of target fields in the data structure, the field identification of each target field and the field value.
Optionally, in the above method, the obtaining the product data table information, and screening the product information to be checked out includes:
screening the information of the products to be assessed from a product data table according to a first specified item, wherein the first specified item comprises: the product type, the product type code, the product brand code, the product producing area, the product specification parameter, the product name, the product unique code and the product sale channel;
the acquiring information of the on-line and/or off-line channel product listing standard data table comprises the following steps:
screening out the listing standard of each channel from the product listing standard data table according to a second specified item, wherein the second specified item comprises: product sale channel, product category, product picture attribute, product detail page attribute and product video attribute.
Optionally, in the above method, the generating a to-be-checked data table by associating the information of the to-be-checked product in the product data table with the information of the product listing standard data table includes:
associating the transverse header information in the product data sheet with the transverse header information of the product overhead standard data sheet to generate a transverse header of the data sheet to be checked; wherein, the horizontal header of the data table to be checked comprises: the method comprises the following steps of product unique coding, product category coding, product brand coding, product sale channel, product picture attribute, product detail page attribute and product video attribute;
and supplementing shelf loading information of each product in the data table to be checked into the corresponding cell of the data table to be checked according to the transverse header of the data table to be checked.
Optionally, in the above method, the acquiring a to-be-audited data table includes:
and acquiring the information of the products on the shelves in the online and/or offline channels according to the preset period, and updating the data sheet to be audited according to the preset period.
Optionally, in the method, the determining the integrity of the shelf information of each product in the data table to be checked according to the data table to be checked and the data table to be checked includes:
comparing the finished quantity of the information on shelves of each product in the data table to be checked with each evaluation standard of the information on shelves in the data table to be checked, determining the integrity of the information on shelves of each product, and updating the integrity of the information on shelves of each product to the data table to be checked.
Optionally, in the above method, the generating an unready product data table according to the completeness of the shelving information of each product includes:
setting products with at least one item of information integrity smaller than a preset threshold value in the information on shelves of the products in the data sheet to be audited as non-ready products, and storing the information of the non-ready products into a data sheet of the non-ready products; removing the product from the non-ready product data table if it is determined that the shelf information integrity of the product is supplemented to the shelf information is greater than or equal to a preset threshold.
In accordance with another aspect of the present application, there is provided a data table management system, including:
the acquisition unit is used for acquiring the product data table information and screening out the product information to be checked; the system is used for acquiring information of an on-line and/or off-line channel product listing standard data table; wherein, product data table information and standard data table information of putting on shelf all include: the method comprises the following steps of (1) data table transverse header contents, fixed format requirements corresponding to the transverse header contents and data information in a data table;
the acquisition unit is also used for generating a data table to be checked according to the correlation between the product information to be checked in the product data table and the information of the product listing standard data table;
the examination unit is used for acquiring a data table to be examined and determining the integrity of information on shelves of each product in the data table to be examined according to the data table to be examined and the data table to be examined;
and the generating unit is used for generating an un-ready product data table according to the shelf information integrity of each product, wherein the un-ready product data table comprises the data information of each product of which the shelf information integrity is less than a preset threshold value.
Optionally, in the system, the obtaining unit is configured to obtain data information of each product in the product data table, where the data information includes: the data structure of the data, the storage address, a plurality of target fields in the data structure, the field identification of each target field and the field value.
Optionally, in the system, the obtaining unit is configured to screen the information of the product to be assessed from a product data table according to a first specific item, where the first specific item includes: the product type, the product type code, the product brand code, the product producing area, the product specification parameter, the product name, the product unique code and the product sale channel;
the acquisition unit is further used for screening out the listing standard of each channel from the product listing standard data table according to a second specified item, wherein the second specified item comprises: product sale channel, product category, product picture attribute, product detail page attribute and product video attribute.
Optionally, in the system, the examination unit is configured to associate the transverse header information in the product data table with the transverse header information of the standard data table on the shelf of the product, and generate a transverse header of the data table to be examined; wherein, the horizontal header of the data table to be checked comprises: the method comprises the following steps of product unique coding, product category coding, product brand coding, product sale channel, product picture attribute, product detail page attribute and product video attribute;
and the examination unit is also used for supplementing the shelf information of each product in the data table to be examined into the corresponding cell of the data table to be examined according to the transverse header of the data table to be examined.
Optionally, in the system, the examination unit is configured to obtain information on the online and/or offline channels of each product category according to a preset period, and update the to-be-examined data table according to the preset period.
Optionally, in the system, the examination unit is configured to compare the information loading completion amount of each product in the data table to be examined with each information loading examination standard in the data table to be examined, determine the integrity of the information loading of each product, and update the integrity of the information loading of each product to the data table to be examined.
Optionally, in the system, the generating unit is configured to set, as an unready product, a product whose integrity of at least one item of information in the information on shelves of the product in the data table to be audited is smaller than a preset threshold, and store the information on the unready product into the data table of the unready product;
the generation unit is further used for removing the product from the non-ready product data table under the condition that the shelf information of the product is supplemented to the shelf information integrity degree which is greater than or equal to a preset threshold value.
In accordance with yet another aspect of the present application, there is provided an electronic device including: a processor; and a memory arranged to store computer executable instructions that, when executed, cause the processor to perform a method as any one of the above.
According to a further aspect of the application, there is provided a computer readable storage medium, wherein the computer readable storage medium stores one or more programs which, when executed by a processor, implement a method as in any above.
According to the technical scheme, the information of the product to be checked is screened out by acquiring the information of the product data table; acquiring information of an on-line and/or off-line channel product listing standard data table; wherein, product data table information and standard data table information of putting on shelf all include: the method comprises the following steps of (1) data table transverse header contents, fixed format requirements corresponding to the transverse header contents and data information in a data table; generating a data table to be checked according to the correlation between the product information to be checked in the product data table and the information of the standard data table on which the product is put; acquiring a data table to be checked, and determining the integrity of information on shelves of each product in the data table to be checked according to the data table to be checked and the data table to be checked; and generating an un-ready product data table according to the shelf information integrity of each product, wherein the un-ready product data table comprises the data information of each product of which the shelf information integrity is less than a preset threshold value. The beneficial effect of this application lies in: according to the method, the mass data tables are screened, associated, compared and stored, data classification management is effectively achieved, the association among data is greatly enhanced, the integrity of information of products on shelves in each channel is effectively counted, a large amount of manpower is saved, meanwhile, the accuracy of product on shelf information data counting is remarkably improved, and the operation efficiency of enterprises is effectively improved.
The foregoing description is only an overview of the technical solutions of the present application, and in order to make the technical means of the present application more clearly understood, the present application may be implemented in accordance with the content of the description, and in order to make the above and other objects, features, and advantages of the present application more clearly understood, the following detailed description will be made with reference to the accompanying drawings.
Drawings
Various other advantages and benefits will become apparent to those of ordinary skill in the art upon reading the following detailed description of the preferred embodiments. The drawings are only for purposes of illustrating the preferred embodiments and are not to be construed as limiting the application. Also, like reference numerals are used to refer to like parts throughout the drawings. In the drawings:
FIG. 1 shows a flow diagram of a data table management method according to an embodiment of the present application;
FIG. 2 shows a flow diagram of a data table management method according to another embodiment of the present application;
FIG. 3 illustrates a block diagram of a data table management system according to an embodiment of the present application;
FIG. 4 shows a schematic structural diagram of an electronic device according to an embodiment of the present application;
FIG. 5 shows a schematic structural diagram of a computer-readable storage medium according to an embodiment of the present application.
Detailed Description
Exemplary embodiments of the present application will be described in more detail below with reference to the accompanying drawings. While exemplary embodiments of the present application are shown in the drawings, it should be understood that the present application may be embodied in various forms and should not be limited to the embodiments set forth herein. Rather, these embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art.
The idea of the application is that: aiming at the inspection requirements of enterprises on the integrity of the information of the examination products on shelves in each channel, the products to be examined are associated with the information of the products to be examined in each channel to form a data table to be examined, a data table to be examined is formed according to the information uploaded on shelves in real time, the information of the products on shelves in the data table to be examined is compared with the information of the products on shelves in the data table to be examined, the products which do not reach the information of the products on shelves are stored to form a data table of products which are not ready, so that managers can inform relevant responsible departments of the perfection and supplement of materials at the first time after the managers inquire, and the efficiency of managing the information data of the products on shelves of the enterprises is improved.
Fig. 1 is a flowchart illustrating a data table management method according to an embodiment of the present application, where the method includes:
step S110, obtaining product data table information, and screening out product information to be checked from the product data table information; acquiring information of an on-line and/or off-line channel product listing standard data table; wherein, product data table information and standard data table information of putting on shelf all include: the data table comprises horizontal header contents, fixed format requirements corresponding to the horizontal header contents and data information in the data table.
The application aims to provide an efficient data table management method for enterprise management product shelf information data, and visual, effective and chain management of the data is achieved. The method and the device correlate the product information with the shelving information of each channel, realize whether the material of the product on the shelves of each channel is ready to be finished or not by extracting the unique code of the product, clarify the shelving integrity of the products on shelves in batches, clarify the product material which is not ready, save a large amount of manpower for enterprises, improve the effectiveness and reliability of product data management of the enterprises, greatly improve the management efficiency of the enterprises, provide powerful data support for the assessment of the enterprises, and provide decision reference for the development and planning of the enterprises.
The acquisition object of the product data sheet is a client for the overhead products in the enterprise, and the acquisition content comprises the acquisition of horizontal header content of the product data sheet, including but not limited to: the product type, the product type code, the product brand code, the product origin, the product specification, the product name, the product unique code and the product sale channel. The acquisition content also includes fixed format requirements for the horizontal header content, including but not limited to: the fixed format of the product category is letters, the fixed format of the product category code is numbers, the fixed format of the product name is characters, and the fixed format of the product unique code is numbers with fixed length. The acquiring the content further includes the following data information: and specific field values of the products under the requirement of the fixed format of the contents of the fields of the transverse header of the product data table. The data in the data table are all visual data, including but not limited to: numbers, text, pictures, graphics, links, videos, attachments.
The product to be examined is screened according to the examination requirements of customers and/or enterprises, wherein the product to be examined is a core product to be examined, and the core product to be examined is a product in a customer data table.
The acquisition time or period of the product data table may be preset in advance as required, and the application is not limited.
And step S120, generating a data table to be checked according to the correlation between the product information to be checked in the product data table and the information of the standard data table on which the product is put on shelf.
The high-performance data management system can realize the chain management of data information by storing the data tables into the database and associating the data in the data tables through the same fields among the data tables, and can realize the query of all information of the product in the database by querying the unique code of the product.
The acquisition object of the product loading standard data sheet is an online channel and/or an offline channel of a product to be loaded on a shelf and examined; obtaining content includes obtaining product listing standard data sheet horizontal header content, including but not limited to: a product sale channel, product types, product picture attributes, product detail page attributes and product video attributes; the acquisition content also includes fixed format requirements for the horizontal header content, including but not limited to: the product sale channel is online and/or offline, the fixed format of the product category is letters, the picture size and the picture format of the product, the detail page size and the detail page size of the product, and the video size of the product. The acquiring the content further includes the following data information: and specific field values of various products in the horizontal header under the requirement of the fixed format of the contents of various fields. The data in the data table are all visual data, including but not limited to: numbers, text, pictures, graphics, links, videos, attachments.
And associating the product to be checked with the listing standard of the product to be checked in the channel to be listed, and forming a data table containing the product information of the product to be checked and the listing standard of the channel to be listed as a data table to be checked. The horizontal header of the data table to be checked includes but is not limited to: the system comprises a unique product code, a product category code, a product brand code, a product origin, a product specification, a product sale channel, a product picture attribute, a product detail page attribute and a product video attribute.
The acquisition time or period of the standard data sheet for putting the product on shelf can be preset in advance as required, and the method is not limited in the application.
Step S130, acquiring a data table to be checked, and determining the integrity of the information on shelves of each product in the data table to be checked according to the data table to be checked and the data table to be checked.
The data sheet to be audited is obtained by recording and updating in real time according to the uploading completion condition of the material required by the product to be audited on the channel to be put on shelf.
The data table to be audited comprises: and acquiring the information of the products on the shelves in the online and/or offline channels according to the preset period, and updating the data sheet to be audited according to the preset period.
The information completion amount of the product on shelves is automatically counted according to the uploading amount of the material on shelves of the product, the automatic counting value is compared with the assessment standard amount of the information on shelves, the field of which the automatic counting value is smaller than the assessment standard amount is determined as the material on shelves of the product on the field is incomplete, and the field of the product is subjected to system labeling processing.
And after the shelf integrity of each product is updated to the data sheet to be checked, the data sheet to be checked contains product information, product shelf standard information and product shelf ready state, and can be used for exporting the requirements for data analysis, performance assessment and the like.
The acquisition time or period of the standard data sheet for putting the product on shelf can be preset in advance as required, and the method is not limited in the application.
Step S140, generating an un-ready product data table according to the integrity of the shelving information of each product, wherein the un-ready product data table comprises data information of each product of which the integrity of the shelving information is smaller than a preset threshold value.
The non-ready data table is a set of product information with at least one item of integrity smaller than a preset threshold in the product shelving information in the data table to be audited, and the data information of the non-ready products in a preset period is stored in the non-ready data table.
And removing the product from the non-ready product data table in the case that the completeness of the shelving information of the product is determined to be greater than or equal to a preset threshold value.
When the preset threshold is a value range, the setting in the value range is equal to the preset threshold, and the setting not in the value range is smaller than the preset threshold.
As can be seen from the method shown in fig. 1, the application has the following beneficial effects: by screening, associating, comparing and storing the mass data tables, the data classification management is effectively realized, the association between the data is greatly enhanced, the integrity of the information of products on shelves in each channel is effectively counted, a large amount of manpower is saved, meanwhile, the accuracy of the product information data counting on shelves is remarkably improved, and the enterprise operation efficiency is effectively improved.
In some embodiments of the present application, in the above method, obtaining the product data table information comprises: acquiring data information of each product in a product data table, wherein the data information comprises: the data structure of the data, the storage address, a plurality of target fields in the data structure, the field identification of each target field and the field value.
The data structure of the data includes but is not limited to arrays, stacks, queues, linked lists, hash tables, trees, heaps, graphs and the like, and the data structure can be customized by clients and enterprises according to requirements, and various data structures can be combined according to the frequency including but not limited to query data, the time of query waiting and the space occupied by the data.
The data is stored in a special database which is set for the information management of the products on shelves by enterprises, the data provided by customers is matched with the proper data structure type in the database according to the customer requirements, and the customer data is stored in a product data table bearing the customer data information under the data structure type.
The range of values for the plurality of target fields in the data structure includes, but is not limited to, the product data table and the horizontal header fields of the product listing standard data table.
When the data information provided by the customer is not matched with the data in the database, the data information of the customer needs to be subjected to data screening according to the field identification, and the screened data set forms a product data table.
In order to save the time of data screening, a data screening standard may be prepared in advance, which is not limited in the present application.
In some embodiments of the present application, in the above method, acquiring product data table information, and screening the product information to be checked out therefrom, includes: screening the information of the products to be assessed from a product data table according to a first specified item, wherein the first specified item comprises: the product type, the product type code, the product brand code, the product producing area, the product specification parameter, the product name, the product unique code and the product sale channel;
acquiring information of an on-line and/or off-line channel product listing standard data table, comprising: screening out the listing standard of each channel from the product listing standard data table according to a second specified item, wherein the second specified item comprises: product sale channel, product category, product picture attribute, product detail page attribute and product video attribute.
The product data table is a collection of product information and is a detailed record of the product information by the customer. The product categories can be differentiated in multiple dimensions according to different attributes of the product, including but not limited to delicacies, drinks, fresh foods, clothes, makeup, personal care, home textiles, digital products, household appliances and building materials, the product categories in each dimension can be differentiated into a plurality of secondary product categories, such as delicacies including but not limited to snacks, grain oil and milk drinks, fresh foods including but not limited to eggs, fresh milk, meat and seafood, and personal care including but not limited to wash care categories and paper categories.
The product listing standard data table is a set of product listing standards and is a detailed record of the product listing standards of each channel, such as picture attributes of products including but not limited to: picture size, picture format, detail page attributes of the product including, but not limited to, size, detail page size.
The product unique code of each product is the unique ID of the product, and the product can belong to a plurality of product categories and can be shelved in a plurality of channels. The data in the product information table and the product listing standard data table are visual data, including but not limited to: numbers, text, pictures, graphics, links, videos, attachments.
In some embodiments of the present application, in the above method, generating the to-be-checked data table by associating the information of the to-be-checked product in the product data table with the information of the product listing standard data table includes: associating the transverse header information in the product data sheet with the transverse header information of the standard data sheet on the shelf of the product to generate a transverse header of the data sheet to be checked; wherein, the horizontal table head of data table to be examined includes: the method comprises the following steps of product unique coding, product category coding, product brand coding, product sale channel, product picture attribute, product detail page attribute and product video attribute;
and supplementing shelf loading information of each product in the data table to be checked into the corresponding cell of the data table to be checked according to the transverse header of the data table to be checked.
The method comprises the steps of associating a product data sheet with a header of a product listing standard data sheet, wherein the formed data sheet to be checked is a set of product data and listing standard data of products in various channels, supplementing listing information in the data sheet to be checked into corresponding cells of the data sheet to be checked, and storing the data sheet to be checked into a database.
In some embodiments of the present application, in the method, acquiring a to-be-audited data table includes:
and acquiring the information of the products on the shelves in the online and/or offline channels according to the preset period, and updating the data sheet to be audited according to the preset period.
The method comprises the steps of obtaining the information of each product type on the online and/or offline channel according to a preset period, specifically, the time period can be a time period, and obtaining the information of each product type on the online and/or offline channel immediately after the time period is finished, wherein the preset time period can be specifically set according to the checking capability of an enterprise on the information of the online and/or offline channel and the assessment requirement of the enterprise on the information of the online and/or offline channel, such as but not limited to any value in the range of 5ms-24 h. Therefore, the acquisition method can obviously shorten the period of data acquisition and increase the density of data acquisition.
In some cases, the preset time period is not reached, but the information of the products on shelves in the online and/or offline channels needs to be acquired, and at this time, the information data of the products on shelves in the online and/or offline channels can be acquired in response to the data acquisition command sent by people.
Specifically, the period of other dimensions may also be obtained according to a preset period, including but not limited to: project cycle, category cycle.
Updating the data table to be audited comprises updating the integrity of the information on the shelves, and the completion amount of the information on the shelves is automatically counted according to the uploading amount of the materials on the shelves of the products.
In some embodiments of the present application, in the method, determining integrity of shelf information of each product in the to-be-checked data table according to the to-be-checked data table and the to-be-checked data table includes: and comparing the finished quantity of the information on shelves of each product in the data table to be checked with each item of information evaluation standard in the data table to be checked, determining the integrity of the information on shelves of each product, and updating the integrity of the information on shelves of each product to the data table to be checked.
The information completion amount of the product on shelves is automatically counted according to the uploading amount of the material on shelves of the product, the automatic counting value is compared with the assessment standard amount of the information on shelves, the field of which the automatic counting value is smaller than the assessment standard amount is determined as the material on shelves of the product on the field is incomplete, and the field of the product is subjected to system labeling processing.
And after the shelf integrity of each product is updated to the data sheet to be checked, the data sheet to be checked contains product information, product shelf standard information and product shelf ready state, and can be used for exporting the requirements for data analysis, performance assessment and the like.
The specific calculation process of the integrity of the information on the shelves is as follows, the requirement of the shelves on a platform on a line for one product in the data sheet to be checked is at least 5 head drawings, 1 detail page and 1 video, the material number counted by the data sheet to be checked is 4 head drawings, 1 detail page and 0 video, the completion of the projection of the product is 80%, the completion of the detail pages is 100%, and the completion of the video is 0%.
In some embodiments of the present application, in the above method, generating the not-ready product data table according to the shelf information integrity of each product includes: setting products with at least one item of information integrity smaller than a preset threshold value in the information on shelves of the products in the data sheet to be audited as non-ready products, and storing the information of the non-ready products into the data sheet of the non-ready products; and removing the product from the non-ready product data table under the condition that the completeness of the shelving information of the product is more than or equal to a preset threshold value when the shelving information is determined to be supplemented to the shelving information.
The non-ready data table is a set of at least one item of product information with the integrity smaller than a preset threshold in the product on-shelf information in the data table to be audited, the data table to be audited is inquired according to a preset period, and the data information of the non-ready products in the preset period is stored in the non-ready data table.
And removing the product from the non-ready product data table in the case that the completeness of the shelving information of the product is determined to be greater than or equal to a preset threshold value.
In some embodiments of the present application, the preset threshold may be a fixed value, or may also be a value range, and when the preset threshold is the value range, the setting in the value range is equal to the preset threshold, and the setting not in the value range is smaller than the preset threshold. As for the method, the shelving standard of one channel in the shelving standard data sheet is 5-10 pictures, when the number of uploaded pictures is within the range, the shelving information of the product is determined to be equal to the preset threshold, the completeness of the shelving information is 100%, when the number of uploaded pictures is outside the range, the shelving information of the product is determined to be smaller than the preset threshold, the completeness of the shelving information is calculated by the ratio of the number of uploaded pictures to the number of standard pictures, and the completeness of the shelving information is supplemented to the corresponding storage unit of the non-ready data sheet.
Fig. 2 is a flowchart illustrating a data table management method according to another embodiment of the present application.
And acquiring original data of the client according to preset time or period, screening products to be assessed, forming a client data table, and storing the client data table in an enterprise database.
And acquiring material requirements of products of different types on-line and/or off-line channel shelving according to preset time or period, forming a product shelving information table, and storing the product shelving information table in an enterprise database.
And associating the product to be checked by the customer with the standard requirement of the product category on an uploading channel to form a data table to be checked.
And checking whether the data table to be checked is finished, when the racking requirements of the product to be checked on each channel are not complete, continuing to associate the product to be checked with the racking requirements of each channel, and when the data table to be checked is complete, continuing to execute the next step.
And acquiring product shelving information according to preset time or period, and counting the product shelving information condition to a to-be-audited data table.
And checking whether the data table to be checked is consistent with the data table to be checked, and prompting that the preparation of the information on the product is finished when the data record in the data table to be checked is consistent with the data record in the data table to be checked. And when the data record in the data table to be checked is not consistent with the data record in the data table to be checked, marking the data record, and continuing to execute the next step.
And transferring all data records marked and processed by the system in the data table to be audited into the data table which is not ready, and forming a summary table of products which are not ready in the period.
And informing the material part of the product which is not ready in the non-ready data table to a relevant responsible department for supplementing.
And carrying out secondary inspection on the material which is not ready in the non-ready data table according to preset time or period, checking whether the material is completely supplemented or not, carrying out secondary notification on relevant responsible departments when the material is not completely supplemented, and continuously executing the next step when the material is completely supplemented.
And moving the complete data supplemented by the materials out of the non-ready data table, and simultaneously prompting that the information on the products is ready to be put on shelves.
FIG. 3 illustrates a block diagram of a data table management system according to an embodiment of the present application; the datasheet processing system 300 includes anacquisition unit 310, anevaluation unit 320, and ageneration unit 330.
The acquiringunit 310 is used for acquiring the product data table information and screening out the product information to be checked; the system is used for acquiring information of an on-line and/or off-line channel product listing standard data table; wherein, product data table information and product standard data table information of putting on shelf all include: the data table comprises horizontal header contents, fixed format requirements corresponding to the horizontal header contents and data information in the data table.
The obtainingunit 310 is further configured to generate a to-be-examined data table according to the to-be-examined product information in the product data table and the product listing standard data table information in an associated manner;
theexamination unit 320 is configured to obtain the data table to be examined, and determine the integrity of the information on shelves of each product in the data table to be examined according to the data table to be examined and the data table to be examined.
The generatingunit 330 is configured to generate an unready product data table according to the integrity of the shelving information of each product, where the unready product data table includes data information of each product whose integrity of the shelving information is smaller than a preset threshold.
In an embodiment of the present application, in the above system, the obtainingunit 310, configured to obtain the product data table information, includes: the method is used for acquiring data information of each product in a product data table, and the data information comprises: the data structure of the data, the storage address, a plurality of target fields in the data structure, the field identification of each target field and the field value.
In an embodiment of the present application, in the above system, the obtainingunit 310 is configured to screen out information of a product to be assessed from the product data table according to a first specified item, where the first specified item includes: the product type, the product type code, the product brand code, the product origin, the product specification parameter, the product name, the product unique code and the product sale channel.
The obtainingunit 310 is configured to screen the listing standard of each channel from the product listing standard data table according to a second specified item, where the second specified item includes: product sale channel, product category, product picture attribute, product detail page attribute and product video attribute.
In an embodiment of the present application, in the above system, the obtainingunit 310 is configured to associate the horizontal header information in the product data table with the horizontal header information in the standard data table on shelf of the product, and generate a horizontal header of the data table to be checked; wherein, the horizontal table head of data table to be examined includes: the method comprises the following steps of product unique coding, product category coding, product brand coding, product sale channel, product picture attribute, product detail page attribute and product video attribute;
the obtainingunit 310 is configured to supplement shelf information of each product in the data table to be checked into the corresponding cell of the data table to be checked according to the horizontal header of the data table to be checked.
In an embodiment of the present application, in the system, theexamination unit 320 is configured to obtain the information about the products on the shelves in the online and/or offline channels according to a preset period, and update the to-be-examined data table according to the preset period.
In an embodiment of the present application, in the above system, theexamination unit 320 is further configured to compare the completion amount of the shelving information of each product in the to-be-examined data table with each shelving information examination standard in the to-be-examined data table, determine the completeness of the shelving information of each product, and update the completeness of the shelving information of each product to the to-be-examined data table.
In an embodiment of the present application, in the above system, the generatingunit 330 is configured to, after determining that a product in the to-be-audited data table, in which at least one information integrity of the information on the shelves of the product is smaller than a preset threshold, set the product as an unready product, store the information on the unready product into the data table of the unready product; thegenerating unit 330 is further configured to remove the product from the not-ready product data table if it is determined that the shelf information of the product is supplemented to the shelf information integrity degree greater than or equal to a preset threshold.
It should be noted that the datatable processing system 300 can respectively implement the aforementioned methods one by one, and is not described again.
To sum up, the beneficial effect of this application lies in: by screening, associating, comparing and storing the mass data tables, the data classification management is effectively realized, the association between the data is greatly enhanced, the integrity of the information of products on shelves in each channel is effectively counted, a large amount of manpower is saved, meanwhile, the accuracy of the product information data counting on shelves is remarkably improved, and the enterprise operation efficiency is effectively improved.
Fig. 4 shows a schematic structural diagram of anelectronic device 400 according to an embodiment of the application, theelectronic device 400 comprising aprocessor 410 and amemory 420 arranged to store computer executable instructions (computer readable program code).
Thememory 420 may be an electronic memory such as a flash memory, an EEPROM (electrically erasable programmable read only memory), an EPROM, a hard disk, or a ROM, among others.Memory 420 has astorage space 430 that stores computerreadable program code 431. For example, thestorage space 430 for storing the computer readable program code may include respective computerreadable program codes 431 for respectively implementing various steps in the above method. The computerreadable program code 431 can be read from or written to one or more computer program products. These computer program products comprise a program code carrier such as a hard disk, a Compact Disc (CD), a memory card or a floppy disk. Such a computer program product is typically a computer readable storage medium such as described in fig. 5. FIG. 5 shows a schematic diagram of a computer-readable storage medium according to an embodiment of the present application. The computerreadable storage medium 500 stores computerreadable program code 431 for performing the steps of the method according to the present application, which is readable by theprocessor 410 of theelectronic device 400, which computerreadable program code 431, when executed by theelectronic device 400, causes theelectronic device 400 to perform the steps of the method described above, in particular the computerreadable program code 431 stored by the computer readable storage medium may perform the method shown in any of the embodiments described above. The computerreadable program code 431 may be compressed in a suitable form.
It should be noted that the above-mentioned embodiments illustrate rather than limit the application, and that those skilled in the art will be able to design alternative embodiments without departing from the scope of the appended claims. In the claims, any reference signs placed between parentheses shall not be construed as limiting the claim. The word "comprising" does not exclude the presence of elements or steps not listed in a claim. The word "a" or "an" preceding an element does not exclude the presence of a plurality of such elements. The application may be implemented by means of hardware comprising several distinct elements, and by means of a suitably programmed computer. In the unit claims enumerating several means, several of these means may be embodied by one and the same item of hardware. The usage of the words first, second and third, etcetera do not indicate any ordering. These words may be interpreted as names.
Claims (10)
1. A method for data table management, comprising:
acquiring product data table information, and screening out product information to be checked from the product data table information; acquiring information of an on-line and/or off-line channel product listing standard data table; wherein, the product data sheet information and the racking standard data sheet information both include: the method comprises the following steps of (1) data table transverse header contents, fixed format requirements corresponding to the transverse header contents and data information in a data table;
generating a data table to be checked according to the correlation between the product information to be checked in the product data table and the information of the standard data table on which the product is put;
acquiring a data table to be checked, and determining the integrity of information on shelves of each product in the data table to be checked according to the data table to be checked and the data table to be checked;
and generating an un-ready product data table according to the shelf information integrity of each product, wherein the un-ready product data table comprises the data information of each product of which the shelf information integrity is less than a preset threshold value.
2. The method of claim 1, wherein the obtaining product data table information comprises:
acquiring data information of each product in the product data table, wherein the data information comprises: the data structure of the data, the storage address, a plurality of target fields in the data structure, the field identification of each target field and the field value.
3. The method of claim 1, wherein the obtaining product data table information and screening the information of the product to be checked out comprises:
screening the information of the products to be assessed from a product data table according to a first specified item, wherein the first specified item comprises: the product type, the product type code, the product brand code, the product producing area, the product specification parameter, the product name, the product unique code and the product sale channel;
the acquiring information of the on-line and/or off-line channel product listing standard data table comprises the following steps:
screening out the listing standard of each channel from the product listing standard data table according to a second specified item, wherein the second specified item comprises: product sale channel, product category, product picture attribute, product detail page attribute and product video attribute.
4. The method of claim 1, wherein the generating the data table to be checked according to the association between the information of the product to be checked in the product data table and the information of the standard data table for product listing comprises:
associating the transverse header information in the product data sheet with the transverse header information of the product overhead standard data sheet to generate a transverse header of the data sheet to be checked; wherein, the horizontal header of the data table to be checked comprises: the method comprises the following steps of product unique coding, product category coding, product brand coding, product sale channel, product picture attribute, product detail page attribute and product video attribute;
and supplementing shelf loading information of each product in the data table to be checked into the corresponding cell of the data table to be checked according to the transverse header of the data table to be checked.
5. The method according to claim 1, wherein the obtaining the to-be-audited data table comprises:
and acquiring the information of the products on the shelves in the online and/or offline channels according to a preset period, and updating the data sheet to be audited according to the preset period.
6. The method according to claim 1, wherein the determining the integrity of the information on shelves of each product in the data table to be checked according to the data table to be checked and the data table to be checked comprises:
comparing the finished quantity of the information on shelves of each product in the data table to be checked with each evaluation standard of the information on shelves in the data table to be checked, determining the integrity of the information on shelves of each product, and updating the integrity of the information on shelves of each product to the data table to be checked.
7. The method of claim 6, wherein said generating a non-ready product data table based on said shelf information integrity of each product comprises:
setting products with at least one item of information integrity smaller than a preset threshold value in the information on shelves of the products in the data sheet to be audited as non-ready products, and storing the information of the non-ready products into a data sheet of the non-ready products;
removing the product from the non-ready product data table if it is determined that the shelf information integrity of the product is supplemented to the shelf information is greater than or equal to a preset threshold.
8. A data table management system, comprising:
the acquisition unit is used for acquiring the product data table information and screening out the product information to be checked; the system is used for acquiring information of an on-line and/or off-line channel product listing standard data table; wherein, product data table information and standard data table information of putting on shelf all include: the method comprises the following steps of (1) data table transverse header contents, fixed format requirements corresponding to the transverse header contents and data information in a data table;
the acquisition unit is also used for generating a data table to be checked according to the correlation between the product information to be checked in the product data table and the information of the product listing standard data table;
the examination unit is used for acquiring a data table to be examined and determining the integrity of information on shelves of each product in the data table to be examined according to the data table to be examined and the data table to be examined;
and the generating unit is used for generating an un-ready product data table according to the shelf information integrity of each product, wherein the un-ready product data table comprises the data information of each product of which the shelf information integrity is less than a preset threshold value.
9. An electronic device, wherein the electronic device comprises: a processor; and a memory arranged to store computer-executable instructions that, when executed, cause the processor to perform the method of any one of claims 1-7.
10. A computer readable storage medium, wherein the computer readable storage medium stores one or more programs which, when executed by a processor, implement the method of any of claims 1-7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011567900.6ACN112732709B (en) | 2020-12-25 | 2020-12-25 | Data table management method, system, electronic device and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011567900.6ACN112732709B (en) | 2020-12-25 | 2020-12-25 | Data table management method, system, electronic device and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112732709Atrue CN112732709A (en) | 2021-04-30 |
| CN112732709B CN112732709B (en) | 2024-01-26 |
Family
ID=75616670
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011567900.6AActiveCN112732709B (en) | 2020-12-25 | 2020-12-25 | Data table management method, system, electronic device and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112732709B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113487365A (en)* | 2021-07-28 | 2021-10-08 | 厦门海晟融创信息技术有限公司 | Smart tobacco marketing and processing with big data analysis and customer feedback |
| CN115841378A (en)* | 2022-11-03 | 2023-03-24 | 平安银行股份有限公司 | Downshift card issuing method and device and computer storage medium |
| CN116108497A (en)* | 2023-04-17 | 2023-05-12 | 武汉盛博汇信息技术有限公司 | Medical data lightweight cloud storage method and device based on identity anonymity |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140052825A1 (en)* | 2012-08-19 | 2014-02-20 | Box, Inc. | Enhancement of upload and/or download performance based on client and/or server feedback information |
| US9195361B1 (en)* | 2012-09-07 | 2015-11-24 | Google Inc. | Single progress indicator depicting multiple subprocesses of an upload of a content item |
| CN106325230A (en)* | 2015-07-03 | 2017-01-11 | 神讯电脑(昆山)有限公司 | Capacity monitoring system and method |
| CN106447156A (en)* | 2016-08-26 | 2017-02-22 | 隆鑫通用动力股份有限公司 | Attendance management method and system |
| CN106446298A (en)* | 2016-11-29 | 2017-02-22 | 盐城工学院 | Data management method and device based on PDM (Pulse Duration Modulation) |
| CN108182285A (en)* | 2018-01-29 | 2018-06-19 | 中国平安人寿保险股份有限公司 | Information processing method, terminal and computer readable storage medium |
| CN109978665A (en)* | 2019-03-28 | 2019-07-05 | 上海中通吉网络技术有限公司 | A kind of method, apparatus, terminal device and the storage medium of the undercarriage on commodity |
| CN110784524A (en)* | 2019-10-14 | 2020-02-11 | 广州微算互联信息技术有限公司 | Cloud mobile phone file uploading keep-alive method, device and system |
- 2020
- 2020-12-25CNCN202011567900.6Apatent/CN112732709B/enactiveActive
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140052825A1 (en)* | 2012-08-19 | 2014-02-20 | Box, Inc. | Enhancement of upload and/or download performance based on client and/or server feedback information |
| US9195361B1 (en)* | 2012-09-07 | 2015-11-24 | Google Inc. | Single progress indicator depicting multiple subprocesses of an upload of a content item |
| CN106325230A (en)* | 2015-07-03 | 2017-01-11 | 神讯电脑(昆山)有限公司 | Capacity monitoring system and method |
| CN106447156A (en)* | 2016-08-26 | 2017-02-22 | 隆鑫通用动力股份有限公司 | Attendance management method and system |
| CN106446298A (en)* | 2016-11-29 | 2017-02-22 | 盐城工学院 | Data management method and device based on PDM (Pulse Duration Modulation) |
| CN108182285A (en)* | 2018-01-29 | 2018-06-19 | 中国平安人寿保险股份有限公司 | Information processing method, terminal and computer readable storage medium |
| CN109978665A (en)* | 2019-03-28 | 2019-07-05 | 上海中通吉网络技术有限公司 | A kind of method, apparatus, terminal device and the storage medium of the undercarriage on commodity |
| CN110784524A (en)* | 2019-10-14 | 2020-02-11 | 广州微算互联信息技术有限公司 | Cloud mobile phone file uploading keep-alive method, device and system |
Non-Patent Citations (2)
| Title |
|---|
| I HABIBULLIN 等: "Complete list of Darboux integrable chains of the form", 《JOURNAL OF MATHEMATICAL PHYSICS》, pages 1 - 29* |
| 宋雪雁 等: "基于扎根理论的华为移动应用商店用户满意度影响因素研究", 《情报科学》, pages 74 - 81* |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113487365A (en)* | 2021-07-28 | 2021-10-08 | 厦门海晟融创信息技术有限公司 | Smart tobacco marketing and processing with big data analysis and customer feedback |
| CN115841378A (en)* | 2022-11-03 | 2023-03-24 | 平安银行股份有限公司 | Downshift card issuing method and device and computer storage medium |
| CN116108497A (en)* | 2023-04-17 | 2023-05-12 | 武汉盛博汇信息技术有限公司 | Medical data lightweight cloud storage method and device based on identity anonymity |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112732709B (en) | 2024-01-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112732709B (en) | Data table management method, system, electronic device and storage medium | |
| CN110245724B (en) | Food material updating method, device and storage equipment | |
| US8799193B2 (en) | Method for training and using a classification model with association rule models | |
| CN115063084A (en) | Method and system for inventory inventory of cigarette retailer | |
| CN110688381A (en) | Software product and software method for product process record tracing | |
| CN113663931A (en) | Article sorting method and device | |
| CN110297956A (en) | Generate method and system, the computer storage medium of product ID | |
| US12380715B2 (en) | Image data annotation and model training platform | |
| CN114898246A (en) | User classification method, system and device based on big data | |
| CN116109992A (en) | Goods shelf commodity identification method and system | |
| CN108154305A (en) | A kind of food safety detection information management platform and its implementation | |
| CN115496511A (en) | Raw material supply chain purchasing information auditing method and purchasing management platform | |
| CN115936590B (en) | Engineering file automated processing system | |
| US20100039509A1 (en) | System and Method for Determining the Kosher Status of Fish | |
| CN116911959A (en) | A data processing method for non-standard parts of building materials | |
| CN107104889B (en) | Draft mail synchronization method, draft mail synchronization device and draft mail synchronization terminal based on IMAP protocol | |
| CN111427936B (en) | Report generation method, device, computer equipment and storage medium | |
| CN110400108A (en) | A kind of logistics document intellectual analysis and automatic storage method based on image recognition | |
| CN113806621B (en) | Information recommendation method, device, computer equipment and storage medium | |
| CN109600428A (en) | A kind of automation uploads attachment and matches associated method and apparatus | |
| CN110944147B (en) | Resource bit monitoring system, method and device and electronic equipment | |
| CN110880088A (en) | Classification storage method, classification storage device, and computer-readable storage medium | |
| CN116562769B (en) | Cargo data analysis method and system based on cargo attribute classification | |
| CN116610681B (en) | Data processing method, device, equipment and computer program for multidimensional table | |
| CN114528452B (en) | Method and system for realizing data tag based on cigarette and wine sales |
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 |