CN111782736B - Data classification management method and system - Google Patents

Abstract

The invention relates to the field of data management, and particularly provides a method and a system for data classification management.A user carries out label marking on an unlabelled table, checks whether the unlabelled table exists, if so, checks whether a predefined label is tried, if so, carries out automatic marking, and if not, carries out manual marking; if not, the label or the label classification is required to be perfected, and the table is displayed. Compared with the prior art, the invention can effectively reduce the manpower input in the data management through a certain degree of automatic marking function, is convenient for a user to carry out multi-dimensional classification checking on the existing data through a form of table-label classification three-level, and continuously improves the existing data management through a warning-feedback mode.

Description

Data classification management method and system

Technical Field

The invention relates to the field of data management, and particularly provides a method and a system for data classification management.

Background

With the development of computer science and information science, each enterprise unit increasingly pays more attention to the construction of an information system, various information systems are gradually perfected, and massive data are generated in daily operation.

The data generated by a plurality of different information systems may differ in organization and structure, even to generate tables with ambiguous or temporary tables. In enterprise data management, due to the lack of corresponding management means, enterprises often have difficulty in realizing effective utilization of data, or some data which are actually discarded but occupy system resources for a long time due to unmarked data exist.

Disclosure of Invention

Aiming at the defects of the prior art, the invention provides a data classification management method with strong practicability.

The invention further aims to provide a system for data classification management, which is reasonable in design, safe and applicable.

The technical scheme adopted by the invention for solving the technical problem is as follows:

a method for data classification management includes that a user labels an unlabelled table, checks whether the unlabelled table exists, if yes, checks whether a predefined label is tried, if yes, carries out automatic labeling, and if not, carries out manual labeling;

if not, the label or the label classification needs to be perfected, and the table is displayed.

Further, before the user labels the untagged table, firstly, a label correspondence table is created in the database to store the correspondence between the data table and the label, a predefined label table is created, and the correspondence between the prefix and the label is initialized and marked according to specific business rules.

Preferably, the field NAMEs included in the tag correspondence TABLE are TABLE _ NAME, LABEL _ TYPE, and PREFIX _ CHECK;

the field NAMEs included in the predefined tag TABLE are TABLE _ PREFIX, LABEL _ NAME, and LABEL _ TYPE.

Further, checking whether an unmarked table exists, performing inspection operation on the table of the database to be managed according to a period defined by a user, and checking whether an unmarked table exists according to a comparison system table list and a label corresponding table;

if the non-tagged table exists, checking whether a PREFIX _ CHECK field exists and whether the PREFIX _ CHECK field is empty, namely, the pre-tagged flow is not passed through;

if the situation is met, performing labeling operation on the watch by combining a predefined label table;

if the PREFIX _ CHECK field is not empty, namely the predefined labeling process is performed, the user is informed to perform custom labeling on the tables which are not labeled, and the corresponding relation between all the predefined or custom tables and the labels is recorded in the label corresponding table.

Further, after the initial labeling is finished, the user completes and classifies the existing labels, combines and unifies the labels through the standardization of the labels, and updates the label name fields in the label correspondence table.

A data classification management system comprises an inspection module, a marking module, a warning module and a table display module, wherein the inspection module is used for performing inspection operation on a table in a database to be managed according to a period defined by a user;

the marking module is used for performing labeling operation on the watch; the warning module is used for informing a user to carry out custom labeling processing on the untagged table; and the table display module is used for checking the labeled table according to the label.

Furthermore, a tag correspondence table is created in the database for subsequently storing the data table and the tag correspondence, a predefined tag table is created in the database, and the correspondence between the table name prefix and the tag is initialized according to specific business rules.

Preferably, the field NAMEs included in the tag correspondence TABLE are TABLE _ NAME, LABEL _ TYPE, and PREFIX _ CHECK;

the field NAMEs included in the predefined tag TABLE are TABLE _ PREFIX, LABEL _ NAME, and LABEL _ TYPE.

Further, the inspection module is used for performing inspection operation on the table in the database to be managed according to a period defined by a user, and checking whether an untagged table exists according to the comparison system table list and the tag corresponding table;

if the non-tagged table exists, checking whether a PREFIX _ CHECK field exists and whether the PREFIX _ CHECK field is empty, namely, the pre-tagged flow is not passed through;

if the situation is met, performing labeling operation on the table through a marking module by combining a predefined label table;

if the PREFIX _ CHECK field is not null, namely the labeling process is predefined, the warning module is used for informing a user to perform custom labeling processing on the non-labeled table;

and recording the corresponding relation between all the predefined or customized tables and the labels to the label corresponding table through the marking module.

Further, after the initial labeling is completed, the user completes and classifies the existing labels, combines and unifies the labels through the standardization of the labels, and updates the label name fields in the label correspondence table.

Compared with the prior art, the data classification management method and the data classification management system have the following outstanding beneficial effects:

(1) the invention can effectively reduce the input of manpower in data management through a certain degree of automatic marking function.

(2) Through the form of table-label classification three levels, the user can conveniently conduct multi-dimensional classification checking on the existing data. Existing data management is continuously refined through an alert-feedback model.

Drawings

In order to more clearly illustrate the embodiments or technical solutions of the present invention, the drawings used in the embodiments or technical solutions in the prior art are briefly introduced below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained according to these drawings without creative efforts.

Fig. 1 is a schematic structural diagram of a data classification management system.

Detailed Description

The present invention will be described in further detail with reference to specific embodiments in order to better understand the technical solutions of the present invention. It should be apparent that the described embodiments are only some embodiments of the present invention, and not all embodiments. All other embodiments obtained by a person of ordinary skill in the art based on the embodiments of the present invention without making any creative effort belong to the protection scope of the present invention.

A preferred embodiment is given below:

as shown in fig. 1, a method for data classification management in this embodiment is: the user labels the untagged table, checks whether the untagged table exists, if so, checks whether the predefined label is tried, if so, automatically marks, and if not, manually marks. If not, the label or the label classification is required to be perfected, and the table is displayed.

The specific process is as follows:

before a user LABELs an untagged TABLE, firstly, a LABEL correspondence TABLE R _ TABLE _ LABEL is created in a database to store the correspondence between the data TABLE and the LABEL, a predefined LABEL TABLE R _ PREFIX _ LABEL is created, and the correspondence between the PREFIX and the LABEL is initialized and marked according to specific business rules.

The field NAMEs included in the tag correspondence TABLE R _ TABLE _ LABEL are TABLE _ NAME, LABEL _ TYPE, and PREFIX _ CHECK. The field NAMEs included in the predefined tag TABLE R _ PREFIX _ LABEL are TABLE _ PREFIX, LABEL _ NAME, and LABEL _ TYPE.

Checking whether an unmarked table exists, performing inspection operation on the table of the database to be managed according to a period defined by a user, and checking whether an unmarked table exists according to a comparison system table list and a label corresponding table.

If there is a non-tagged table, it is checked if there is a PREFIX _ CHECK field and if the PREFIX _ CHECK field is empty, i.e. not subjected to the predefined tagging flow.

If the situation is met, the table is labeled by combining the predefined LABEL table R _ PREFIX _ LABEL.

If the PREFIX _ CHECK field is not empty, namely the predefined labeling process is performed, the user is informed to perform custom labeling on the tables which are not labeled, and the corresponding relation between all the predefined or custom tables and the labels is recorded in the label corresponding table.

After the initial labeling is finished, the user completes and classifies the existing labels, combines and unifies the labels through the standardization of the labels, and updates the label name fields in the label corresponding table.

The system for realizing the method comprises the following steps:

a data classification management system comprises an inspection module, a marking module, a warning module and a table display module, wherein the inspection module is used for performing inspection operation on a table in a database to be managed according to a period defined by a user.

The marking module is used for performing labeling operation on the meter; the warning module is used for informing a user to carry out custom labeling processing on the untagged table; and the table display module is used for checking the labeled table according to the label.

The method comprises the following specific steps:

(1) and creating a LABEL corresponding TABLE R _ TABLE _ LABEL in the database for storing the corresponding relation between the data TABLE and the LABEL subsequently.

Name of field	Type of data	Note
			TABLE_NAME	Character type	Name of data table
LABEL_NAME	Character type	Label name
			LABEL_TYPE	Character type	Type of label
PREFIX_CHECK	Character type	Whether a predefined marking process has been performed

(2) A predefined LABEL table R _ PREFIX _ LABEL is established in a database, and the corresponding relation between the table name PREFIX and the LABEL is initialized according to specific business rules.

Name of field	Data type	Note
			TABLE_PREFIX	Character type	Table name prefix
LABEL_NAME	Character type	Label name
			LABEL_TYPE	Character type	Label type 5

(3) The patrol module is used for carrying out patrol operation on the TABLEs in the database to be managed according to the period defined by the user, and checking whether the untagged TABLEs exist according to the comparison system TABLE list and the LABEL corresponding TABLE R _ TABLE _ LABEL.

If there is an untagged table, it is checked if there is a PREFIX _ CHECK field that is empty, i.e. not subjected to a predefined tagging flow.

If such a situation is met, the table is tagged by the tagging module in conjunction with the predefined tag table R _ PREFIX _ LABEL. If the PREFIX _ CHECK field is not null, namely the predefined labeling process is already performed, the user is informed to perform custom labeling processing on the non-labeled table through an alarm module. And recording the corresponding relation between all predefined or customized TABLEs and the LABELs to a LABEL corresponding TABLE R _ TABLE _ LABEL through a marking module.

(4) After the initial labeling is completed, the user can perfect and classify the existing labels. The perfection of the LABEL mainly relates to the standardization work of the LABEL, because data can be generated by a plurality of information systems, users in different service fields have different appellations to the same entity or different appellations, in the process of customizing the LABEL by the user, the LABEL with different names but the same meaning appears, in this link, the part of LABELs are merged and unified through the standardization of the LABEL, and the LABEL name field in the LABEL corresponding TABLE R _ TABLE _ LABEL is updated. The classification of the labels mainly relates to the type division of the labels, and is used for reducing the screening range and improving the query efficiency in the actual use process.

(5) And checking the labeled table according to the label through the table display module.

The above embodiments are only specific examples, and the scope of the present invention includes but is not limited to the above embodiments, and any suitable changes or substitutions that may be made by one of ordinary skill in the art according to the method and system claims for data classification management of the present invention shall fall within the scope of the present invention.

Although embodiments of the present invention have been shown and described, it will be appreciated by those skilled in the art that various changes, modifications, substitutions and alterations can be made in these embodiments without departing from the principles and spirit of the invention, the scope of which is defined in the appended claims and their equivalents.

Claims (4)

1. A method for managing data classification is characterized in that a user labels an unlabelled table, checks whether the unlabelled table exists, if so, checks whether a predefined label is tried, if so, performs automatic labeling, and if not, performs manual labeling;

if the label does not exist, the label or the label classification needs to be perfected, and the table is displayed;

before a user labels an untagged table, firstly creating a label corresponding table in a database to store a corresponding relation between a data table and a label, creating a predefined label table, and initializing a corresponding relation between a marked prefix and the label according to a specific service rule;

the field NAMEs included in the tag correspondence TABLE are TABLE _ NAME, LABEL _ TYPE, and PREFIX _ CHECK;

the field NAMEs included in the predefined tag TABLE are TABLE _ PREFIX, LABEL _ NAME, and LABEL _ TYPE;

checking whether an unmarked table exists, performing inspection operation on the table of the database to be managed according to a period defined by a user, and checking whether an unmarked table exists according to a comparison system table list and a label corresponding table;

if the non-tagged table exists, checking whether a PREFIX _ CHECK field exists and whether the PREFIX _ CHECK field is empty, namely, the pre-tagged flow is not performed;

if the situation is met, performing labeling operation on the watch by combining a predefined label table;

if the PREFIX _ CHECK field is not empty, namely the predefined labeling process is performed, the user is informed to perform custom labeling on the tables which are not labeled, and the corresponding relation between all the predefined or custom tables and the labels is recorded in the label corresponding table.

2. The data classification management method as claimed in claim 1, characterized in that after the initial labeling is completed, the user completes and classifies the existing labels, merges and unifies the labels by standardizing the labels, and updates the label name field in the label correspondence table.

3. A data classification management system is characterized by comprising an inspection module, a marking module, a warning module and a table display module, wherein the inspection module is used for performing inspection operation on a table in a database to be managed according to a period defined by a user;

the marking module is used for performing labeling operation on the watch; the warning module is used for informing a user to carry out custom labeling processing on the non-labeled table; the table display module is used for checking the labeled table according to the label;

creating a label corresponding table in a database for storing the data table and the label corresponding relation subsequently, creating a predefined label table in the database, and initializing the corresponding relation between the table name prefix and the label according to specific business rules;

the field NAMEs included in the tag correspondence TABLE are TABLE _ NAME, LABEL _ TYPE, and PREFIX _ CHECK;

the field NAMEs included in the predefined tag TABLE are TABLE _ PREFIX, LABEL _ NAME, and LABEL _ TYPE;

the polling module is used for polling the tables in the database to be managed according to a period defined by a user and checking whether an untagged table exists or not according to a comparison system table list and a tag corresponding table;

if the non-tagged table exists, checking whether a PREFIX _ CHECK field exists and whether the PREFIX _ CHECK field is empty, namely, the pre-tagged flow is not performed;

if the situation is met, performing labeling operation on the table through a marking module by combining a predefined label table;

if the PREFIX _ CHECK field is not null, namely the predefined labeling process is performed, the warning module is used for informing a user of performing custom labeling on the non-labeled table;

and recording the corresponding relation between all the predefined or customized tables and the labels to the label corresponding table through the marking module.

4. The data classification management system according to claim 3, characterized in that after the initial labeling is completed, the user completes and classifies the existing labels, merges and unifies the labels by standardizing the labels, and updates the label name field in the label correspondence table.

Images