Custom field duplication avoidance system and method in enterprise IT system
By splitting custom field names and descriptions by word or word, querying and highlighting duplicates in real-time, it solves the duplication problem in field management in enterprise IT systems, and improves the accuracy and consistency of field management.
Patent Information
- Application Number
- CN202310758899.2
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2023-06-26
- Publication Date
- 2025-07-29
AI Technical Summary
In enterprise IT systems, multiple administrators may add custom fields or field values with duplicate meanings, resulting in confusion in field management.
By splitting custom field names and descriptions by word or word, query the existing fields in real time for duplicates, and highlight potential duplicates on the interface to avoid duplication of field names and descriptions.
It effectively avoids duplication in field names and descriptions, improves the accuracy and consistency of field management, and facilitates administrators to confirm whether there are duplications in new content.
Smart Images
Figure CN120386781A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of database management, and particularly to a method for creating a database of a small and medium-sized enterprise IT management system. Background Art
[0002] In order to provide the flexibility of the IT system, many IT systems support users to set fields and field values by themselves, that is, users can add new fields and specify value ranges for the fields. For example, an administrator of an IT system can add a field named "position" and specify the value range of this field as "clerk, cashier, welder, operator, salesperson". When adding a new field, it is necessary to provide the name and description of the field to facilitate subsequent maintenance of the field list; when specifying the value range of the field, it is also necessary to provide the value and the description of the value for each value to facilitate subsequent maintenance of the value list.
[0003] In most cases, there are multiple administrators for an IT system of a company; when maintaining fields, multiple administrators may separately add fields or field values with duplicate meanings. For example, when adding a field for position management, different administrators may separately add different fields. The field name added by Administrator A is "position", and the field name added by Administrator B is "position name"; when maintaining the value range of the position field, different administrators may have different appellations for the same position. For example, for a welder, Administrator A names it "welder" when maintaining position information, Administrator B names it "electric welder" when maintaining position information, and Administrator C names it "welder master" when maintaining position information, resulting in chaos in position management. Summary of the Invention
[0004] In view of the deficiencies involved in the background art, the present invention provides a method for avoiding duplication of custom field content in an enterprise IT system, which avoids fields or words that are not literally repeated but have duplicate actual meanings when adding field names or descriptions in the IT system.
[0005] The present invention provides a method for avoiding duplication of custom fields in an enterprise IT system, display a page for creating custom fields; receive the name of the custom field, split the field name by characters, and query in real time for existing fields with duplicate characters by character, and display the field names with duplicate characters; Alternatively, receive the description of the custom field, split the field description by words, and query in real time for existing field descriptions with duplicates by word, and display the field descriptions with duplicate words.
[0006] Further, perform duplicate checking on the received name of the custom field by character. If the name of an existing custom field contains the characters of the name of the newly added custom field, then this character is used as a potential duplicate item; When performing duplicate checking, single characters in the names of custom fields are used with "or" as the logical combination for duplicate checking in the field management database; when a field name with duplicate single characters is found, the field management database feeds back the field name to the page.
[0007] Furthermore, the page displays the field names with duplicate single characters, and highlights the characters with potential duplicate items in color.
[0008] Furthermore, semantic duplicate checking is performed on the descriptions of received custom fields. First, the text is segmented, and then duplicate checking is performed on the words. If the description of an existing field contains the words in the description of the newly added custom field, the field description is regarded as a potential duplicate item; When performing duplicate checking, words in the descriptions of custom fields are used with "or" as the logical combination for duplicate checking in the field management database; when a field description with duplicate words is found, the field management database feeds back the field description to the page.
[0009] Furthermore, the page displays the field descriptions with duplicate words, and highlights the words with potential duplicate items in color.
[0010] As a preferred implementation of this application, some set common characters are not regarded as duplicate-avoiding characters. When specifying the position name, "worker" and "employee" are not regarded as duplicate-avoiding characters, so as to avoid too many query results.
[0011] Even further, if the potential duplicate items of the name of a custom field and the potential duplicate items of the description of the field or custom field belong to the same existing field, they are highlighted in the same color.
[0012] This application also provides a duplicate-avoiding system for custom fields in an enterprise IT system, which is characterized in that the system includes: An interaction module, which is used to receive the name and description of a custom field input by the user, pass the name of the custom field to the character splitting module, pass the description of the custom field to the word segmentation module, and display the query results returned by the character splitting module and the word segmentation module; A character splitting module and a word segmentation module. The character splitting module and the word segmentation module split the name of the custom field into single characters according to the user's input, divide the description of the custom field into words, and pass the split content to the real-time query module in real time, receive the query results returned by the real-time query module, and feed back the query results to the interaction module; A real-time query module, which receives the splitting results of the character splitting module or the word segmentation module, combines the single characters or words with "or" as the logical combination, and then queries for duplicate field names or field descriptions in the field management database in real time, and returns the query results to the character splitting module or the word segmentation module; A field management database, which is used to store field-related information, including field names and field description information, process query requests submitted by a real-time query module, and return query results Further, the interaction module is also used to display field names with single-character repetitions and highlight the characters with potential duplicates in color As a preferred implementation of this application, the interaction module is also used to display field descriptions with word repetitions and highlight the words with potential duplicates in color
[0013] Furthermore, if the potential duplicates of the name of a custom field and the potential duplicates of the description of the field or custom field belong to the same existing field, they are highlighted in the same color
[0014] Compared with the prior art, the solution for avoiding duplication of custom field content in the enterprise IT system proposed by the present invention has the following effects 1. Check the content of the newly added field through the name of the field and the description of the field 2. When checking the duplication of field names, check by character; when checking the duplication of field descriptions, check by word 3. Display the duplication check results of the field name and field description on the interface, and highlight the field name and field description belonging to the same field, which is convenient for the administrator to confirm whether there are duplications in the newly added content 4. The characters in the name of the field or field value that are the same as those in the potential duplicates are displayed in the same color; if there are multiple duplicates, they are distinguished by different colors; the words in the description of the field or field value that are the same as those in the potential duplicates are displayed in the same color; if there are multiple duplicates, they are distinguished by different colors, which is convenient for users to judge the duplication situation BRIEF DESCRIPTION OF THE DRAWINGS
[0015] Figure 1 It is a schematic diagram of the basic solution in the prior art Figure 2 It is a diagram showing the effect of the method for avoiding duplication of custom fields in the enterprise IT system of this application Figure 3 It is a block diagram of the system for avoiding duplication of custom fields in the enterprise IT system of this application Figure 4 It is a data interaction timing diagram of the method for avoiding duplication of custom fields in the enterprise IT system of this application EMBODIMENTS
[0016] The technical solution of the present invention will be further described in detail below with reference to the drawings EXAMPLE
[0017] The present invention provides a method for avoiding duplicate custom fields in an enterprise IT system, which sets custom fields and performs addition or deletion operations on the custom fields; when adding a custom field, it checks for duplicate field names and / or descriptions to avoid adding duplicate fields; displays the duplicate check results, and highlights the words with potential duplicates in color.
[0018] As Figure 4 shown, it is the interaction sequence diagram of the solution of this application, which shows the page for creating custom fields; First, receive the name of the custom field, split the field name by characters, and query the existing fields with duplicate characters in real time by character, and display the field names with duplicate characters; Alternatively, receive the description of the custom field, split the description of the field by words, and query the existing field descriptions with duplicates in real time by word, and display the field descriptions with duplicate words.
[0019] When a user adds a custom field, the following content needs to be provided: • The name of the custom field • The description of the custom field.
[0020] It should be noted that the description of the custom field is not a necessary content. When the name of the custom field is a professional name, the description of the custom field can be added to explain the name in detail for other readers to understand. Or, when the name of the custom field is relatively rare and not often used, in order to avoid forgetting what the name refers to when seeing it later, the description of the custom field can also be added to explain it.
[0021] When filling in the field name, the duplicate check results are synchronously displayed on the interface, that is, potential duplicates are queried and displayed in real time as the user enters. The name of the received custom field is checked for duplicates by character. If the name of an existing custom field contains the character of the name of the newly added custom field, then this character is used as a potential duplicate; When performing duplicate checks, the single characters in the name of the custom field are used as logical combinations with "or" to perform duplicate checks in the field management database; when a field name with a single character duplicate is queried, the field management database feeds back the field name to the page.
[0022] • Some common characters are not used as duplicate avoidance characters. For example, when specifying a job title, characters such as "worker" and "employee" that often appear in job titles are not used as duplicate avoidance query characters, so as to avoid too many query results. The display results are as Figure 2 shown; Furthermore, the page displays the field names with single character duplicates, and highlights the words with potential duplicates in color.
[0023] When filling in the field description, the interface simultaneously displays the duplicate check results, that is, it instantaneously queries and displays potential duplicates as the user enters the information. For the description of the received custom fields, semantic duplicate checking is performed. First, the text is segmented into words, and then word-by-word duplicate checking is carried out. If the description of an existing field contains a word in the description of the newly added custom field, then the description of this field is regarded as a potential duplicate item; During duplicate checking, for the words in the description of the custom field, OR is used as the logical combination for duplicate checking in the field management database; when a field description with duplicate words is queried, the field management database feeds back the field description to the page.
[0024] Furthermore, the page displays the field descriptions with duplicate words and highlights the words with potential duplicate items in color.
[0025] If the potential duplicate item of the custom field name and the potential duplicate item of the field or custom field description belong to the same existing field, they are highlighted in the same color. Embodiment
[0026] This embodiment is a duplicate avoidance system for custom fields in an enterprise IT system. As Figure 3 shown, this system includes the following functional modules: Interaction module: (1) Receive user input. If the user fills in a field name, the field name is transmitted to the word splitting module in real time; if the user fills in a field description, the field description is transmitted to the word segmentation module in real time; (2) According to the user's selection, read the field information from the field management database, including the field name, field description, etc.; (3) According to the user's operation, save the field name and / or field description filled in or modified by the user to the field management database; Word splitting module: Split the field name into single characters. For example, "welder" is split into three single characters: "weld", "join", and "worker"; Word segmentation module: Split the field description into words. For example, "subordinate to Production Department 1, responsible for shelf welding" is split into words such as "subordinate", "production", "one", "department", "responsible", "shelf", and "welding"; Real-time query module: Receive the splitting results from the word splitting module or the word segmentation module, combine the single characters or words according to the OR logic, and query for duplicate field names or field descriptions in the field management database in real time, and return the query results to the word splitting module or the word segmentation module; Field management database: Store information related to fields, including information such as field names and field descriptions; process the query requests submitted by the real-time query module and return the query results.
[0027] Those skilled in the art can understand that, unless otherwise defined, all terms used herein (including technical and scientific terms) have the same meaning as the general understanding of those of ordinary skill in the art to which this invention pertains. It should also be understood that terms such as those defined in a general dictionary should be understood to have a meaning consistent with their meaning in the context of the prior art, and will not be interpreted in an idealized or overly formal sense unless defined as such here.
[0028] The specific embodiments described above further elaborate on the purpose, technical solutions, and beneficial effects of the present invention. It should be understood that the above description is only for the specific embodiments of the present invention and is not intended to limit the present invention. Any modifications, equivalent replacements, improvements, etc. made within the spirit and principles of the present invention shall be included within the protection scope of the present invention.
Claims
1. A method for avoiding duplicate custom fields in an enterprise IT system, characterized in that display a page for creating custom fields; receive the name of the custom field, split the field name by characters, and query in real time for existing fields with duplicate characters, and display the field names with duplicate characters; alternatively, receive the description of the custom field, split the field description by words, and query in real time for existing field descriptions with duplicates, and display the field descriptions with duplicate words.
2. The method for avoiding duplicate custom fields in an enterprise IT system according to claim 1, characterized in that perform duplicate checking on the received name of the custom field by characters. If the name of an existing custom field contains the characters of the name of the newly added custom field, then the character is used as a potential duplicate item; when performing duplicate checking, perform duplicate checking on the single characters in the name of the custom field in the field management database with "or" as the logical combination; when a field name with a duplicate single character is queried, the field management database feeds back the field name to the page.
3. The method for avoiding duplicate custom fields in an enterprise IT system according to claim 2, characterized in that, The page displays the field names with duplicate single characters, and highlights the characters with potential duplicate items in color.
4. The method for avoiding duplicate custom fields in an enterprise IT system according to claim 1, wherein, perform semantic duplicate checking on the received description of the custom field. First, perform word segmentation, and then perform duplicate checking by words. If the description of an existing field contains the words in the description of the newly added custom field, then the field description is used as a potential duplicate item; when performing duplicate checking, perform duplicate checking on the words in the description of the custom field in the field management database with "or" as the logical combination; when a field description with a duplicate word is queried, the field management database feeds back the field description to the page.
5. The method for avoiding duplicate custom fields in an enterprise IT system according to claim 4, characterized in that The page displays the field descriptions with duplicate words, and highlights the words with potential duplicate items in color.
6. The method for avoiding duplicate custom fields in an enterprise IT system according to claim 2 or 4, characterized in that, Do not use some set common characters as duplicate-avoiding characters. When specifying a job title, do not use "worker" and "employee" as duplicate-avoiding characters to avoid too many query results.
7. The method for avoiding duplicate custom fields in an enterprise IT system according to any one of claims 1 to 5, characterized in that, If the potential duplicate items of the name of the custom field and the potential duplicate items of the description of the custom field belong to the same existing field, highlight them in the same color.
8. A system for avoiding duplicate custom fields in an enterprise IT system, characterized in that The system includes: an interaction module, which is used to receive the name of the custom field and the description of the custom field input by the user, pass the name of the custom field to the character-splitting module, pass the description of the custom field to the word-segmenting module, and display the query results returned by the character-splitting module and the word-segmenting module; a character-splitting module and a word-segmenting module. The character-splitting module and the word-segmenting module split the name of the custom field into single characters according to the user's input, divide the description of the custom field into words, and pass the split content to the real-time query module in real time, receive the query results returned by the real-time query module, and feed back the query results to the interaction module; a real-time query module, which receives the split results of the character-splitting module or the word-segmenting module, combines the single characters or words with "or" as the logical combination, and queries for duplicate field names or field descriptions in the field management database in real time, and returns the query results to the character-splitting module or the word-segmenting module; A field management database, which is used to store field-related information, including field names and field description information, processes query requests submitted by a real-time query module and returns query results.
9. The custom field duplication avoidance system in the enterprise IT system according to claim 8, characterized in that, The interaction module is also used to display field names with single-character repetitions and highlight the characters with potential duplicates in color. The interaction module is also used to display field descriptions with word repetitions and highlight the words with potential duplicates in color.
10. The custom field duplicate avoidance system in the enterprise IT system according to claim 9, wherein If the potential duplicates of the name of a custom field and the potential duplicates of the description of the field or custom field belong to the same existing field, they are highlighted in the same color.