Label system based on relational database

Abstract

The invention discloses a label system based on a relational database, and relates to the technical field of database management. Comprising a data resource management module, a label rule management module, a crowd rule management module, a task scheduling module, a data authorization query module and a system security module. According to the method, information such as dispersed object data, management label rules and scheduling strategies can be integrated to realize labeling, classification and query analysis of the object data, corresponding user portraits and business object label systems are established, and by combining an actual government affair service scene, through analysis and association retrieval of user portrait data, the user portraits and business object labels can be obtained. And precise and personalized services are realized.

Description

Technical Field

[0001] The present invention discloses a tag system based on a relational database, which relates to the technical field of database management. Background Art

[0002] With the rapid development of the Internet, the service content and user data in the field of government services are becoming increasingly diverse. However, there is currently no tag system for relational databases in the field of government services that can quickly and accurately screen out the information and services required by users from a large amount of government service content and actively reach users. Summary of the Invention

[0003] In view of the problems of the prior art, the present invention provides a tag system based on a relational database, which can integrate scattered object data, manage information such as tag rules and scheduling strategies, so as to realize the annotation, classification and query analysis of object data, establish corresponding user portraits and business object tag systems, and combine the actual government service scenarios to achieve precise and personalized services through the analysis and associated retrieval of user portrait data.

[0004] The specific solution proposed by the present invention is as follows:

[0005] The present invention provides a method for implementing a tag system based on a relational database: create a tag system based on a relational database, and the tag system includes a data resource management module, a tag rule management module, a population rule management module, a task scheduling module, a data authorization query module and a system security module;

[0006] Configure the database connection information where the object model is located and the model information of the object through the data resource management module, establish data resources, and integrate user data and business data to facilitate tag annotation and data consumption;

[0007] Classify and manage tags and classification basic information through the tag rule management module. The tag types include static tags, rule tags, compliance tags, and attribute tags, and online configure tag screening conditions, manage tag combination condition rules and scheduling strategies, and automatically retrieve a list of objects that meet the tag screening conditions from the data resources and establish an association relationship with the tags;

[0008] Perform population management through the population rule management module based on the established object and tag data and using the management tag combination condition rules;

[0009] Establish unified task scheduling through the task scheduling module based on the distributed timed task xxl-job, and incorporate tag calculation, population calculation, data heterogeneity, and various asynchronous push tasks into the scheduling platform for unified management;

[0010] Authorize application management and data management through the data authorization query module: Manage business applications that need to consume user and label data, provide asymmetric keys to the calling party, and implement encryption processing during data interaction; authorize the scope of data resources that business applications can access, avoid the exposure of unnecessary data resource information, classify and manage data according to sensitivity levels, and improve data security;

[0011] Authenticate through the system security module to ensure the legitimacy of accessing the system, and provide two-way identity authentication with the business system of the data consumer. Use asymmetric encryption to handle data transmission between systems to ensure data security. For the display of sensitive data within the system, desensitization methods are adopted.

[0012] Furthermore, in the implementation method of a tag system based on a relational database, manage data sources through the data resource management module, manage the connection configurations of various relational database data sources storing user and business object data, and based on the configured data sources, maintain the table structure association relationships and field information related to the object model in the system to establish data resources.

[0013] Furthermore, in the implementation method of a tag system based on a relational database, for associated data, a search engine and a bitmap data structure are introduced in the tag rule management module. When the tag data changes, by listening to the change operations of the associated table, asynchronously synchronize the tag data to the search engine, maintain the bitmap structure of the tag data, and both query analysis are based on the search engine and bitmap to improve query performance and storage space utilization.

[0014] Furthermore, in the implementation method of a tag system based on a relational database, record all operation data of system users and API call data of associated business systems through the system security module, implement full-process traceability as logs, and provide permission control to authorize the management of corresponding data management and data query, so that the query and processing of important data are carried out within a reliable range.

[0015] The present invention also provides a tag system based on a relational database, and the tag system includes a data resource management module, a tag rule management module, a population rule management module, a task scheduling module, a data authorization query module, and a system security module;

[0016] The data resource management module configures the database connection information where the object model is located, as well as the model information of the object, establishes data resources, integrates user data and business data, and facilitates tag annotation and data consumption;

[0017] The label rule management module classifies and manages labels and classification basic information. The label types include static labels, rule labels, compliance labels, and attribute labels. It online configures label screening conditions, manages label combination condition rules and scheduling strategies, automatically retrieves a list of objects that meet the label screening conditions from the data resources, and establishes an association relationship with the labels;

[0018] Based on the established object and label data, the population rule management module uses the management label combination condition rules to manage the population;

[0019] Based on the distributed timed task xxl-job, the task scheduling module establishes a unified task scheduling, incorporating label calculation, population calculation, data heterogeneity, and various asynchronous push tasks into the scheduling platform for unified management;

[0020] The data authorization query module authorizes application management and data management: manages business applications that need to consume user and label data, provides an asymmetric key to the invoker to implement encryption processing during data interaction; authorizes the data resource scope that the business application can access, avoids the exposure of unnecessary data resource information, classifies and manages the data according to the sensitivity level, and improves data security;

[0021] The system security module conducts authentication to ensure the legality of accessing the system, and provides two-way identity authentication with the business system of the data consumer. It uses asymmetric encryption to handle data transmission between systems to ensure data security. For the display of sensitive data within the system, desensitization methods are adopted.

[0022] Furthermore, the data resource management module of the label system based on the relational database manages data sources, manages the connection configurations of various relational database data sources storing user and business object data, and based on the configured data sources, maintains the table structure association relationships and field information related to the object model in the system to establish a data resource.

[0023] Furthermore, for the associated data in the label system based on the relational database, a search engine and a bitmap data structure are introduced in the label rule management module. When the label data changes, by listening to the change operations of the associated table, the label data is asynchronously synchronized to the search engine, and the bitmap structure of the label data is maintained. Query analysis is implemented based on the search engine and bitmap, improving query performance and storage space utilization.

[0024] Furthermore, the system security module of the label system based on the relational database records all operation data of system users and API call data of the associated business system, and realizes full-process traceability as a log. It also provides permission control to authorize the management of corresponding data management and data query, enabling the query and processing of important data to be carried out within a reliable range.

[0025] The advantages of the present invention are as follows:

[0026] Centralized management of business data: By integrating various business data in the government service scenario through data resource management for unified management, problems such as scattered data, multi-source heterogeneity, etc. are solved.

[0027] Improving the accuracy and personalization of government services: Through capabilities such as tag rule management, task scheduling, and data open query, gradually improve the user portrait and business object classification annotation based on business data and behavior data, realize refined operation of government services, meet the needs of innovative application scenarios such as "enjoy without review", and greatly improve the accuracy and personalization of government services.

[0028] Security of data docking: The built-in security mechanism of the system deepens the security maintenance of data from aspects such as authentication, authorization, encryption, and audit logs, making all aspects such as data integration, management, and consumption more secure. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] Figure 1 It is a front-end schematic diagram of the data resource module of the present invention.

[0030] Figure 2 It is a front-end schematic diagram of the tag rule management module.

[0031] Figure 3 It is a front-end schematic diagram of the population rule management module.

[0032] Figure 4 It is a schematic diagram of the method flow of the present invention. DETAILED DESCRIPTION OF THE EMBODIMENTS

[0033] The present invention will be further described below in conjunction with the accompanying drawings and specific embodiments, so that those skilled in the art can better understand the present invention and be able to implement it, but the embodiments cited do not limit the present invention.

[0034] Embodiment 1

[0035] The present invention provides a method for implementing a tag system based on a relational database: Create a tag system based on a relational database, and the tag system includes a data resource management module, a tag rule management module, a population rule management module, a task scheduling module, a data authorization query module, and a system security module. Among them, data source management can be carried out through the data resource management module, manage the connection configuration of various relational database data sources storing user and business object data, and based on the configured data sources, maintain the table structure association relationship and field information related to the object model in the system to establish data resources.

[0036] Configure the database connection information where the object model is located and the model information of the object through the data resource management module, establish a data resource, and integrate user data and business data to facilitate label annotation and data consumption.

[0037] Classify and manage labels and classification basic information through the label rule management module. The label types include static labels, rule labels, compliance labels, and attribute labels. Online configure label screening conditions, manage label combination condition rules, and scheduling strategies, and automatically retrieve a list of objects that meet the label screening conditions from the data resource and establish an association relationship with the labels. For associated data, a search engine and a bitmap data structure are introduced in the label rule management module. When the label data changes, by listening to the change operations of the associated table, the label data is asynchronously synchronized to the search engine, and the bitmap structure of the label data is maintained. Query analysis is implemented based on the search engine and the bitmap, improving query performance and storage space utilization.

[0038] Based on the established object and label data, use the management label combination condition rules to manage the population through the population rule management module;

[0039] Based on the distributed timed task xxl-job, establish a unified task scheduling through the task scheduling module, and incorporate label calculation, population calculation, data heterogeneity, and various asynchronous push tasks into the scheduling platform for unified management;

[0040] Authorize application management and data management through the data authorization query module: Manage business applications that need to consume user and label data, provide an asymmetric key to the caller, and implement encryption processing during data interaction; Authorize the range of data resources that business applications can access, avoid the exposure of unnecessary data resource information, classify and manage data according to sensitivity levels, and improve data security;

[0041] Authenticate through the system security module to ensure the legitimacy of accessing the system, and provide two-way identity authentication with the business system of the data consumer. Use asymmetric encryption to handle data transmission between systems to ensure data security. For the display of sensitive data within the system, desensitization methods are adopted.

[0042] The system security module can further record all operation data of system users and API call data of associated business systems, implement full-process traceability as logs, and provide permission control to authorize the management of corresponding data management and data query, so that the query and processing of important data are carried out within a reliable range.

[0043] Embodiment 2

[0044] The present invention also provides a tag system based on a relational database. The tag system includes a data resource management module, a tag rule management module, a population rule management module, a task scheduling module, a data authorization and query module, and a system security module;

[0045] The data resource management module configures the database connection information where the object model is located, as well as the model information of the object, establishes data resources, and integrates user data and business data to facilitate tag annotation and data consumption;

[0046] The tag rule management module classifies and manages tags and classification basic information. The tag types include static tags, rule tags, compliance tags, and attribute tags, and online configures tag screening conditions, manages tag combination condition rules and scheduling strategies, automatically retrieves a list of objects that meet the tag screening conditions from the data resources, and establishes an association relationship with the tags;

[0047] The population rule management module performs population management based on the established object and tag data, using the management tag combination condition rules;

[0048] The task scheduling module establishes unified task scheduling based on the distributed timed task xxl-job, and incorporates tag calculation, population calculation, data heterogeneity, and various asynchronous push tasks into the scheduling platform for unified management;

[0049] The data authorization and query module authorizes application management and data management: manages business applications that need to consume user and tag data, provides an asymmetric key to the caller to implement encryption processing during data interaction; authorizes the range of data resources that business applications can access, avoids the exposure of unnecessary data resource information, classifies and manages data according to sensitivity levels, and improves data security;

[0050] The system security module performs authentication to ensure the legitimacy of accessing the system, and provides two-way identity authentication with the business system of the data consumer. It uses asymmetric encryption to handle data transmission between systems to ensure data security, and sensitive data within the system is displayed in a desensitized manner.

[0051] Regarding the information interaction and execution process among the above-mentioned modules in the system, since they are based on the same concept as the method embodiment of the present invention, the specific content can be referred to the description in the method embodiment of the present invention, and will not be elaborated here.

[0052] Similarly, the advantages of the system of the present invention are:

[0053] Centralized management of business data: Integrate various business data in the government service scenario through data resource management for unified management, and solve problems such as scattered data, multi-source heterogeneity, etc.

[0054] Improve the precision and personalization of government services: Through capabilities such as label rule management, task scheduling, and data open query, gradually improve user portraits and business object classification annotations based on business data and behavioral data, achieve refined operation of government services, meet the needs of innovative application scenarios such as "enjoy without review", and greatly improve the precision and personalization of government services.

[0055] Security of data docking: The built-in security mechanism of the system deepens the security maintenance of data from aspects such as authentication, authorization, encryption, and audit logs, making all aspects of data integration, management, and consumption more secure.

[0056] It should be noted that not all steps and modules in the above-mentioned processes and system structures are necessary, and some steps or modules can be ignored according to actual needs. The execution order of each step is not fixed and can be adjusted according to needs. The system structures described in the above-mentioned embodiments can be physical structures or logical structures, that is, some modules may be implemented by the same physical entity, or some modules may be implemented by multiple physical entities separately, or some components in multiple independent devices may be jointly implemented.

[0057] The above-described embodiments are only preferred embodiments given to fully illustrate the present invention, and the protection scope of the present invention is not limited thereto. Equivalent substitutions or transformations made by those skilled in the art on the basis of the present invention are within the protection scope of the present invention. The protection scope of the present invention shall be subject to the claims.

Claims

1. A method for implementing a tag system based on a relational database, characterized in that Create a tag system based on a relational database. The tag system includes a data resource management module, a tag rule management module, a population rule management module, a task scheduling module, a data authorization query module, and a system security module; Configure the database connection information where the object model is located and the model information of the object through the data resource management module, establish data resources, and integrate user data and business data to facilitate tag annotation and data consumption; Classify and manage tags and classification basic information through the tag rule management module. The tag types include static tags, rule tags, compliance tags, and attribute tags. Online configure tag screening conditions, manage tag combination condition rules, and scheduling strategies, and automatically retrieve a list of objects that meet the tag screening conditions from the data resources and establish an association relationship with the tags; Based on the established object and tag data, use the management tag combination condition rules to conduct population management through the population rule management module; Based on the distributed timed task xxl-job, establish unified task scheduling through the task scheduling module, and incorporate tag calculation, population calculation, data heterogeneity, and various asynchronous push tasks into the scheduling platform for unified management; Authorize application management and data management through the data authorization query module: Manage business applications that need to consume user and tag data, provide an asymmetric key to the caller, and implement encryption processing during data interaction; Authorize the range of data resources that business applications can access, avoid the exposure of unnecessary data resource information, classify and manage data according to sensitivity levels, and improve data security; Authenticate through the system security module to ensure the legitimacy of accessing the system, and provide two-way identity authentication with the business system of the data consumer. Use asymmetric encryption to handle data transmission between systems to ensure data security. Sensitive data within the system is displayed in a desensitized manner.

2. The implementation method of a tag system based on a relational database according to claim 1, characterized in that Conduct data source management through the data resource management module, manage the connection configurations of various relational database data sources storing user and business object data, and based on the configured data sources, maintain the association relationships and field information of the table structures related to the object model in the system to establish data resources.

3. The implementation method of a tag system based on a relational database according to claim 1, characterized in that For associated data, a search engine and a bitmap data structure are introduced in the tag rule management module. When the tag data changes, by listening to the change operations of the associated table, the tag data is asynchronously synchronized to the search engine, and the bitmap structure of the tag data is maintained. Query analysis is implemented based on the search engine and the bitmap to improve query performance and storage space utilization.

4. The implementation method of a tag system based on a relational database according to claim 1, characterized in that Record all operation data of system users and API call data of associated business systems through the system security module, implement full-process traceability as logs, and provide permission control to authorize the management of corresponding data management and data query, so that the query and processing of important data are carried out within a reliable range.

5. A tag system based on a relational database, characterized in that The tag system includes a data resource management module, a tag rule management module, a population rule management module, a task scheduling module, a data authorization query module, and a system security module; The data resource management module configures the database connection information where the object model of the data resource is located, as well as the model information of the object, establishes the data resource, and integrates user data and business data to facilitate label annotation and data consumption; The label rule management module classifies and manages the basic information of labels and classifications. The label types include static labels, rule labels, compliance labels, and attribute labels. It also configures label screening conditions online, manages label combination condition rules and scheduling strategies, and automatically retrieves a list of objects that meet the label screening conditions from the data resource and establishes an association relationship with the labels; The population rule management module conducts population management based on the established object and label data and by using the management label combination condition rules; Based on the distributed timed task xxl-job, the task scheduling module establishes unified task scheduling, and incorporates label calculation, population calculation, data heterogeneity, and various asynchronous push tasks into the scheduling platform for unified management; The data authorization query module authorizes application management and data management: manages business applications that need to consume user and label data, provides an asymmetric key to the calling party to implement encryption processing during data interaction; authorizes the scope of data resources that business applications can access, avoids the exposure of unnecessary data resource information, classifies and manages data according to sensitivity levels, and improves data security; The system security module conducts authentication to ensure the legitimacy of accessing the system, and provides two-way identity authentication with the business system of the data consumer. It uses asymmetric encryption to handle data transmission between systems to ensure data security. For the display of sensitive data within the system, desensitization is adopted.

6. The tag system based on a relational database according to claim 5, wherein the data The resource management module conducts data source management, manages the connection configurations of various relational database data sources storing user and business object data, and based on the configured data sources, maintains the association relationships of table structures and field information related to the object model in the system to establish the data resource.

7. The tag system based on a relational database according to claim 5, characterized in that For associated data, a search engine and a bitmap data structure are introduced in the label rule management module. When the label data changes, by listening to the change operations of the associated table, the label data is asynchronously synchronized to the search engine, and the bitmap structure of the label data is maintained. Query analysis is implemented based on the search engine and bitmap to improve query performance and storage space utilization.

8. A tag system based on a relational database according to claim 5, characterized in that The system security module records all operation data of system users and API call data of associated business systems as logs to achieve full-process traceability, and provides permission control to authorize the management of corresponding data and data queries, enabling the query and processing of important data to be carried out within a reliable range.

Images