A system and method for instant customized labeling of business products

Abstract

The present invention relates to a system and method for instant custom labeling of business products. The system includes a data entry module and a data management module that are interconnected. The data management module is connected to a database, and a narrow label table for data supplementation is pre-created in the database. The data entry module is used to upload, download, or modify user-defined label files; the data management module is used to check for duplicates in the label files, store the label files that pass the check in the database, and extract corresponding labels from the database according to query requirements. Compared with the existing technology, the present invention can flexibly and instantly add custom labels to products without changing the table structure, improving response speed, and can use custom labels to perform corresponding screening queries, which is conducive to users conveniently and accurately understanding product performance from different dimensions.

Description

Technical Field

[0001] The present invention relates to the technical field of data labeling systems, and in particular to a system and method for instant customized labeling of business products. Background Art

[0002] In their actual work, product business personnel often need to use some label dimensions to understand the specific performance of the product. Most of these label dimensions are stored in the database from the front-end system. At the same time, there are also some temporarily used label dimensions that have not been maintained in the system and database. For the latter, if the traditional data entry process is adopted, it will take a long time and cannot meet the needs of immediate use. In addition, the existing technology reserves some fields on the product label dimension table to accept temporarily maintained labels. When the data is uploaded and supplemented, the use of custom labels can be realized. However, this method only supplements the label dimensions through reserved fields, and its flexibility and scalability are poor. Once the reserved fields are used up, the table structure must be readjusted to receive more custom labels. Adjusting the table structure requires going through the formal process again, which ultimately leads to slow response speed and difficulty in immediately adding custom labels to products, which is not conducive to users conveniently and accurately understanding product performance from different dimensions. Summary of the Invention

[0003] The purpose of the present invention is to overcome the defects of the above-mentioned prior art and provide a business product instant custom labeling system and method, which can flexibly and instantly add custom labels to products without changing the table structure, thereby improving the response speed.

[0004] The object of the present invention can be achieved by the following technical solutions: A system for instant customized labeling of business products, comprising a data entry module and a data management module connected to each other, the data management module being connected to a database, the data entry module being used to upload, download or modify user-defined label files;

[0005] The data management module is used to check the tag files for duplicates, store the tag files that pass the check in the database, and extract the corresponding tags from the database according to the query requirements;

[0006] A narrow label table for data supplementation is pre-created in the database.

[0007] Furthermore, the tag narrow table includes four columns, corresponding to the tag name, product code, tag value and usage permission respectively.

[0008] A method for instant custom labeling of business products includes the following steps:

[0009] S1. The user uploads the custom label file in the data entry module and transfers it to the data management module;

[0010] S2. The data management module checks the tag file for duplicates. If the duplicate check passes, step S3 is executed; otherwise, step S4 is executed.

[0011] S3. Store the label file in the database according to the set format. Then, based on the user's query requirements, the data management module extracts the corresponding label from the database;

[0012] S4. The data management module outputs a modification instruction to the data entry module, and waits for the user to re-upload the modified custom label file, and then returns to step S2.

[0013] Furthermore, the custom tag file adopts a wide table format.

[0014] Furthermore, the custom label file includes a product code and a corresponding label value.

[0015] Furthermore, in step S2, the data management module specifically checks the tag names for duplication.

[0016] Furthermore, the step S3 specifically automatically fills the data information in the custom tag file after the duplicate check is passed into the tag narrow table in the database.

[0017] Furthermore, the user query requirement in step S3 includes a tag name and corresponding permissions.

[0018] Furthermore, the specific process of the data management module extracting the corresponding tag from the database in step S3 is as follows:

[0019] S31. According to the tag name and corresponding authority provided by the user's query requirement, the row corresponding to the tag name is extracted from the current narrow table in the database, that is, multiple tags are obtained;

[0020] S32. Output the multiple tags together as a temporary table.

[0021] Furthermore, the temporary table in step S32 is specifically in the form of a wide table.

[0022] Compared with the prior art, the present invention has the following advantages:

[0023] First, the present invention provides interconnected data entry and data management modules, and connects the data management module to a database. This database contains a pre-created narrow table of labels for data entry. The data entry module is used to upload, download, or modify user-defined label files. The data management module also performs duplicate checking on label files, stores those that pass the check in the database, and extracts corresponding labels from the database based on query requirements. This allows user-defined labels to be stored in a separate narrow table, enabling rapid reception of an unlimited number of custom labels without requiring changes to the table structure. This provides the advantages of high flexibility and fast response times.

[0024] 2. The present invention is designed to perform duplicate checking on uploaded user-defined tag files, which can avoid duplication of tag names and ensure the accuracy and reliability of stored custom tags.

[0025] 3. The present invention extracts the rows corresponding to the tag names in the narrow table based on the tag names and corresponding permissions provided by the user's query requirements, that is, obtains a wide table output consisting of multiple tags, thereby associating the custom tag narrow table with the usual product tag dimension wide table to enable custom tags to participate in screening queries.

[0026] 4. The present invention is designed so that users can set permissions for uploaded tags, that is, users can independently set permissions for custom tag dimensions and choose to share them with other users, further improving the practicality of this solution. BRIEF DESCRIPTION OF THE DRAWINGS

[0027] Figure 1 Schematic diagram of the system structure of the present invention;

[0028] Figure 2 Schematic diagram of the method flow of the present invention;

[0029] Description of the marks in the figure: 1. Data entry module, 2. Data management module, 3. Database. DETAILED DESCRIPTION

[0030] The present invention will be described in detail below with reference to the accompanying drawings and specific embodiments.

[0031] Example

[0032] like Figure 1 As shown, a system for instant custom labeling of business products includes a data entry module 1 and a data management module 2, which are connected to each other. The data management module 2 is connected to a database 3, which has a pre-created narrow label table for data supplementation. The narrow label table contains four columns, corresponding to the label name, product code, label value, and usage permission. The data entry module 1 is used to upload, download, or modify user-defined label files;

[0033] The data management module 2 is used to perform a duplicate check on the tag files, store the tag files that pass the duplicate check into the database 3, and extract the corresponding tags from the database 3 according to the query requirements.

[0034] Based on the above system, a method for instant customized labeling of business products is implemented, such as Figure 2 As shown, the following steps are included:

[0035] S1. The user uploads a custom label file in the data entry module and transfers it to the data management module. The custom label file uses a wide table format and contains the product code and the corresponding label value.

[0036] S2. The data management module checks the tag file for duplicates (specifically, checks the tag name for duplicates). If the check passes, step S3 is executed; otherwise, step S4 is executed.

[0037] S3. Store the tag file in the database according to the set format (that is, automatically fill the data information in the custom tag file into the tag narrow table in the database after the duplicate check is passed). Then, according to the user's query requirements, the data management module extracts the corresponding tags from the database;

[0038] The user query requirement includes a tag name and corresponding permissions. Based on the tag name and corresponding permissions provided by the user query requirement, the data management module extracts the row corresponding to the tag name from the current narrow table in the database, that is, obtains multiple tags, and then outputs the multiple tags together as a temporary table (specifically in the form of a wide table);

[0039] S4. The data management module outputs a modification instruction to the data entry module, and waits for the user to re-upload the modified custom label file, and then returns to step S2.

[0040] This solution takes into account that normally one label is one column, and many labels have many columns, thus forming a wide table. The problem with wide tables is that adding a new label requires adding a new column, which means that the table structure must be changed. User-defined labels are often unpredictable in advance, so the design adopts a narrow table approach, turning all column-by-column labels into narrow tables that use label names to find corresponding rows. Rows that match the label name constitute a label. This way, there is no need to change the table structure. No matter how many new labels are added, the structure of this narrow table remains unchanged, and user-defined labels can be added without modification.

[0041] This embodiment applies the above technical solution to design a data entry module for uploading, downloading and permission modification of custom tags; designs a data management module for managing custom tag data, including data entry, providing query interfaces, and data maintenance; in addition, a custom tag narrow table for data supplement is created in the database, which contains four columns: tag name, product code, tag value, and usage permissions. User-defined tags will be stored in this narrow table.

[0042] In specific applications, users upload custom label files through the data entry module. The files need to contain product codes and corresponding label values ​​(with label names as column names).

[0043] The data management module checks for duplicate tag names. If duplicate names are found, the user is prompted to modify the tag name.

[0044] After the tag name is checked for duplicates, the data is entered into the database according to the format;

[0045] Based on the tag name and corresponding permissions provided in the query requirements, the rows with the corresponding tag name are extracted from the narrow table and the results are returned. It should be noted that when querying, tags are extracted one by one from the narrow table. Each tag is extracted to form a temporary table. This temporary table has the same structure as the traditional dimensional wide table, and joint queries are implemented in sequence, that is, custom tags are used to participate in filtering queries.

[0046] In summary, this solution provides users with a flexible and instant way to tag products. Users can maintain their own tag dimensions at any time, even if they haven't already entered them into the system or data warehouse according to standard procedures. Users can also use these tags for queries immediately after uploading them. Furthermore, users can set permissions for custom tag dimensions and choose to share them with other users. This solution significantly facilitates users' reliable understanding of product performance across multiple dimensions.

Claims

1. A method for instant custom labeling of business products, applied to an instant custom labeling system for business products, characterized in that: The system comprises a data entry module (1) and a data management module (2) connected to each other, wherein the data management module (2) is connected to a database (3), and the data entry module (1) is used to upload, download or modify user-defined label files; The data management module (2) is used to perform a duplicate check on the tag files, store the tag files that pass the duplicate check in a database (3), and extract corresponding tags from the database (3) according to query requirements; A narrow tag table for data supplementation is pre-created in the database (3), and the narrow tag table contains four columns, corresponding to the tag name, product code, tag value and usage authority respectively; The method comprises the following steps: S1. The user uploads the custom label file in the data entry module and transfers it to the data management module; S2. The data management module checks the tag file for duplicates. If the duplicate check passes, step S3 is executed; otherwise, step S4 is executed. S3. Store the label file in the database according to the set format. Then, based on the user's query requirements, the data management module extracts the corresponding label from the database; S4. The data management module outputs a modification instruction to the data entry module. After the user re-uploads the modified custom label file, the module returns to step S2. Step S3 specifically involves automatically filling the data information in the custom tag file after the duplicate check is passed into the tag narrow table in the database. The specific process of the data management module extracting the corresponding tag from the database in step S3 is as follows: S31. According to the tag name and corresponding authority provided by the user's query requirement, extract the row corresponding to the tag name from the current narrow table in the database, that is, obtain multiple tags; S32. Output the multiple tags together as a temporary table, where the temporary table is specifically in a wide table format.

2. A method for instant customized labeling of business products according to claim 1, characterized in that: The custom tag file adopts a wide table format.

3. A method for instant customized labeling of business products according to claim 2, characterized in that: The custom label file contains the product code and the corresponding label value.

4. A method for instant customized labeling of business products according to claim 3, characterized in that: In step S2, the data management module specifically checks the tag names for duplication.

5. The instant customized labeling method for business products according to claim 3, characterized in that: The user query requirement in step S3 includes the tag name and the corresponding authority.

Images