Project operation and maintenance-oriented heterogeneous data security management and control method, system and equipment and medium
Patent Information
- Application Number
- CN202411140353.1
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-08-20
- Publication Date
- 2024-12-03
AI Technical Summary
Traditional data security solutions lack comprehensiveness and coordination, making it difficult to deal with complex and changeable data security threats. Especially in heterogeneous database environments, data security and consistency guarantees are more complex.
By sorting out the roles and responsibilities of the database security protection platform, building a heterogeneous database adaptation engine to achieve unified management; building a user system and a unified data access portal, refining data permission control, data operation warning strategy configuration, intermediary management and post-audit audit , form a comprehensive and coordinated data security protection system.
It realizes comprehensive, coordinated and efficient protection of heterogeneous data, improves the overall efficiency and efficiency of data security protection, reduces the risks of data leakage and misoperation, and ensures the security and business continuity of data during its life cycle.
Smart Images

Figure CN119066678A_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the field of data security technology, and specifically to a heterogeneous data security management and control method, system, device and medium for project operation and maintenance. Background Art
[0002] With the rapid development of information technology and the deepening of digital transformation, data has become the core resource of modern organizations. However, the explosive growth of data volume and the increase in complexity have brought unprecedented challenges to data security protection. Traditional data security solutions are often limited to single links such as data encryption and access control. They lack comprehensiveness and coordination and are difficult to cope with complex and changing data security threats. In addition, the heterogeneity between different database systems also increases the difficulty of data management, making data security and consistency assurance more complicated.
[0003] Therefore, how to achieve comprehensive, coordinated and efficient data security protection and improve the overall effectiveness and efficiency of data security protection is a technical problem that needs to be solved urgently. Summary of the invention
[0004] The technical task of the present invention is to provide a heterogeneous data security management method, system, equipment and medium for project operation and maintenance to solve the problem of how to achieve comprehensive, coordinated and efficient data security protection and improve the overall effectiveness and efficiency of data security protection.
[0005] The technical task of the present invention is achieved in the following way: a heterogeneous data security management and control method for project operation and maintenance, the method is as follows:
[0006] Sorting out and defining the roles and responsibilities of the database security protection platform: By sorting out the scenarios of daily data security operation and maintenance of the project, the roles, users and responsibilities of the database security protection platform are defined, laying the foundation for the division of rights and responsibilities of the database security protection platform;
[0007] Build a heterogeneous database adaptation engine to achieve comprehensive management of data;
[0008] Build a user system and a unified data access portal;
[0009] Refined data permission control;
[0010] Data operation warning strategy configuration;
[0011] Intervention management during data operation;
[0012] Post-audit of data operations.
[0013] As a preferred option, the roles defined by the database security protection platform include two categories: platform-level roles and tenant-level roles; platform-level roles include platform operation administrators and platform operation and maintenance administrators; tenant-level roles include operation administrators, security administrators, audit administrators, operation and maintenance administrators and ordinary users under the corresponding projects;
[0014] The users defined by the database security protection platform include the director of the information center, the platform builder, the data prevention and control platform operation and maintenance team, business department customers, project managers, platform operation and maintenance supervisors, implementers, testers and developers;
[0015] Among them, the director of the information center and the platform builder shall conduct authority level management, authorization management, authority approval and process design in advance, and conduct audit management and operation analysis during and after the event;
[0016] The data prevention and control platform operation and maintenance team performs system initialization, permission configuration, organizational maintenance, tenant-level project maintenance, tenant initial account maintenance, and process configuration in advance, and conducts audit management and platform operation and maintenance during and after the event;
[0017] Business department clients conduct project authority management and authority approval in advance, and conduct project-level audit management and operation analysis during and after the project;
[0018] The project manager under the security administrator shall perform project authority management and authority approval in advance;
[0019] The project manager under the audit administrator conducts project-level audit management (accident accountability) after the event;
[0020] The platform operation and maintenance supervisor under the audit administrator conducts project-level audit management during and after the event (behavior analysis, process optimization, risk avoidance, and auxiliary accident accountability);
[0021] The platform operation and maintenance supervisor shall perform project personnel initialization, authority configuration, database access, data protection policy configuration, task configuration (backup tasks, etc.), data management and configuration file management in advance, perform project data operation maintenance, performance monitoring, performance diagnosis and data operation approval (high-risk operations) during the project, and perform data recovery afterwards;
[0022] The implementation personnel shall carry out project deployment and data implementation (DDL and DML) in advance;
[0023] Testers conduct pre-launch verification and data query on the project;
[0024] Developers perform data operations (DDL and DML) and configuration file modifications in advance.
[0025] As a preferred method, before building a heterogeneous database adaptation engine, the target database is first investigated and analyzed to understand its data format, storage structure and access interface information, and then, based on the collected information, exclusive adapters (DataAdaptor) for different databases are designed and developed. Through the scheduling of different adapters by the heterogeneous data adaptation engine, connection and communication with various types of databases can be achieved; the heterogeneous data adaptation engine is used to realize the encapsulation and standardization of database drivers, so that the database security protection platform can manage and operate various databases in a unified manner, and flexibly expand different data types and database products; finally, the target database is included in the management scope of the database security protection platform through the heterogeneous data adaptation engine to realize unified management and control of data resources;
[0026] Constructing a heterogeneous database adaptation engine to complete comprehensive data management is as follows:
[0027] Script delivery mechanism:
[0028] (1) The heterogeneous data adaptation engine supports converting SQL scripts or other database operation scripts into a format that can be executed on the target database;
[0029] (2) Use database connection pool technology to manage and reuse database connections to improve script execution efficiency;
[0030] (3) Introduce a task scheduling framework, such as Quartz, to implement scheduled delivery of scripts;
[0031] Result query:
[0032] (1) Design a result storage mechanism: Use a database or cache system to store script execution results;
[0033] (2) Providing an API interface that allows users to query execution results based on script ID and execution time;
[0034] (3) For queries that exceed the set threshold number of data, consider using paging and indexing technology to optimize query performance;
[0035] Permission configuration is issued:
[0036] (1) Design a unified permission configuration model that is compatible with the permission systems of different databases;
[0037] (2) Implement the logic of issuing permission configuration and convert the configuration into permission setting statements that can be recognized by the corresponding database;
[0038] (3) Provide an API interface to allow administrators to batch issue permission configurations through the API interface;
[0039] User role permission data query:
[0040] (1) The heterogeneous data adaptation engine maintains a mapping table between user roles and permissions;
[0041] (2) Provide an API interface to allow users to query permission data based on username and role conditions;
[0042] (3) Consider using caching technology to reduce the number of database queries and improve query efficiency;
[0043] Monitoring information collection:
[0044] (1) Design monitoring indicators: number of database connections, execution efficiency and error rate;
[0045] (2) Implement monitoring data collection logic and collect relevant indicator data from the target database at regular intervals;
[0046] (3) Storing monitoring data in a database or time series database to facilitate subsequent analysis and alarm;
[0047] Database configuration is issued:
[0048] (1) Design a unified database configuration model that can cover the configuration items of different databases;
[0049] (2) Implement the configuration delivery logic and convert the configuration into the configuration setting statement of the corresponding database;
[0050] (3) Provide an API interface, allowing administrators to batch distribute and modify configurations through the API interface;
[0051] As a preferred option, a user system is built and the unified data access portal is as follows:
[0052] Reclaim redundant accounts and unify access portals: After accessing various databases, the database access accounts reclaimed by R&D and operation and maintenance personnel can access the database through the data security protection platform account with unified access portals;
[0053] Unified data access path: By configuring a whitelist, the access IP addresses of various application databases are limited, and only the business system host and the security protection platform host are authorized to access data, cutting off other database access paths and standardizing database access;
[0054] Forced interruption of abnormal access: Get all database connection pool information (dataSourceConnection) in real time, and forcefully close unauthorized access connections through configuration policies.
[0055] As a preferred option, the refined data permission control is as follows:
[0056] Hierarchical authorization mechanism: Establish a hierarchical authorization mechanism based on defined user roles and responsibilities; and assign one or more permission nodes under the database management operation, data object, and data access categories through a permission tree or permission matrix;
[0057] Fine-grained permission management: Fine-grained permission control is achieved through the configuration of data sets, sensitive data types, and security levels. For example, for some highly sensitive data sets, only specific roles or specially authorized users may have access. For other data sets, access control policies can be customized according to business needs.
[0058] The data operation warning strategy configuration is as follows:
[0059] Define a set of flexible and comprehensive security policies based on the actual project operation and maintenance management and data usage requirements. The security policies include access control, operation restrictions and sensitive instruction rules. Configure early warning, audit, control and backup mechanisms based on the security policies.
[0060] Sensitive instruction rules are the core of advance warning. By analyzing and identifying sensitive deletion and modification operations in SQL statements, high-risk operations can be perceived and warned. When unauthorized high-risk operations are detected, direct blocking is adopted to prevent data loss. For authorized high-risk operations, highlighted reminders are given and the operations are executed after manual confirmation by the user.
[0061] Pre-warning also provides online SQL editing function, supports advanced SQL editors across multiple data sources, and improves the efficiency and security of data operations;
[0062] Among them, when executing defined high-risk operations, the database security protection platform will pre-execute the user's script and feedback the user's confirmation. After confirmation, the data before modification will be stored in the OSS object storage for backup to prevent data backtracking after misoperation, and then the script will be executed and logs will be recorded.
[0063] Preferably, the data operation in-process intervention management is as follows:
[0064] Real-time monitoring of the operating status of the managed database, including performance indicators, connection status, and error logs;
[0065] By collecting and analyzing the operating status data of the database, abnormalities and potential risks are discovered in a timely manner, and administrators are notified through alarms for intervention; in addition, continuous performance monitoring and multi-dimensional performance optimization are also carried out;
[0066] Improve database performance and stability by adjusting database configuration parameters online, identifying slow SQL statements, recommending indexes, and optimizing SQL rewrites. At the same time, provide a visualized topology function to help operation and maintenance personnel quickly locate anomalies and associated potential impacts.
[0067] In terms of privacy data protection, by configuring desensitization rules, dynamic desensitization of data for users with different roles and permissions can be achieved to protect data privacy and security;
[0068] The details of post-audit of data operations are as follows:
[0069] Build heterogeneous data operation audit tools to record and store log information of all database operations. The log information of all database operations includes operation time, operation type, operation object and execution result.
[0070] The audit report function analyzes and summarizes the log information of all database operations to generate detailed operation and maintenance reports. The detailed operation and maintenance reports are used to help operation and maintenance personnel understand the distribution of database operations, user behavior patterns, and potential security risks.
[0071] Conduct independent audits from the perspective of database objects and users;
[0072] Comprehensively understand the usage and security status of the database by viewing the operation records and user permission information of the specified database objects, as well as the database operation records and access rights of the specified users;
[0073] The audit data visualization function displays multi-dimensional audit data in the form of charts, helping users quickly analyze audit data to discover anomalies or potential security risks.
[0074] A heterogeneous data security management and control system for project operation and maintenance, the system includes a heterogeneous database adaptation module, a data operation pre-warning module, a data operation in-process control module and a data operation post-audit module;
[0075] Among them, the heterogeneous database adaptation module is used to achieve connection and adaptation with different database systems to uniformly manage heterogeneous databases;
[0076] The data operation pre-warning module is used to conduct early warning analysis according to the preset security strategy before the data operation is executed to prevent potential security risks; the data operation pre-warning module also has a sensitive instruction recognition function to identify and warn potential high-risk operation instructions;
[0077] The data operation control module is used to monitor the operation status of the database in real time during the data operation process, and to optimize performance and handle exceptions. The data operation control module also has a dynamic desensitization function, which is used to realize dynamic encryption and desensitization of data during the data operation process.
[0078] The data operation post-audit module is used to record and analyze the log information of data operations to realize the audit and traceability of data operations.
[0079] As a preference, the system also has the following functions:
[0080] ① Supports customizing data sets, roles, sensitive data types, and security levels according to business conditions to configure access control policies; access control policies include allowing, denying, or alerting specific users to access specific data sets;
[0081] ② Provide visual topology function to display the connection status and performance indicators of the database;
[0082] ③ Provide online SQL editing function to support advanced SQL editor across multiple data sources.
[0083] An electronic device comprising: a memory and at least one processor;
[0084] Wherein, the memory stores a computer program;
[0085] The at least one processor executes the computer program stored in the memory, so that the at least one processor executes the heterogeneous data security management and control method for project operation and maintenance as described above.
[0086] A computer-readable storage medium stores a computer program, which can be executed by a processor to implement the heterogeneous data security management and control method for project operation and maintenance as described above.
[0087] The heterogeneous data security management and control method, system, device and medium for project operation and maintenance of the present invention have the following advantages:
[0088] (1) The present invention aims to achieve comprehensive, coordinated and efficient protection of data security by integrating multiple modules such as heterogeneous database adaptation, data operation pre-warning, in-process control and post-event audit;
[0089] (ii) The present invention also supports customizing data sets, roles, sensitive data types and security levels according to business conditions to configure access control policies, including allowing, denying or alerting specific users' access requests to specific data sets; the present invention also provides visual topology functions, online SQL editing functions, etc., to improve the efficiency and security of data operations;
[0090] (3) The present invention has the advantages of comprehensive coverage of the data life cycle, multi-dimensional collaborative protection, efficient and accurate operation, flexible configuration, and post-audit traceability, providing organizations with a more comprehensive, efficient and reliable data security protection solution;
[0091] (IV) The present invention not only integrates multiple key modules such as heterogeneous database adaptation, data operation pre-warning, in-process control and post-audit, but also provides organizations with comprehensive security protection from data access, operation execution to post-audit through advanced algorithms and mechanisms; specifically, the present invention involves multiple sub-fields such as database connection management, security policy configuration, real-time monitoring and performance optimization, data desensitization, audit log recording and visualization, etc., aiming to improve the overall effectiveness of data security protection through technological innovation, reduce the risk of data leakage and misoperation, and ensure the continuity of organizational business and data security;
[0092] (V) The present invention can fully integrate multiple data security protection functions and realize a technical platform for multi-dimensional collaborative protection, which has become an urgent need in the industry. By integrating multiple modules such as heterogeneous database adaptation, data operation pre-warning, in-process control, and post-audit, a comprehensive, collaborative, and efficient data security protection system is constructed, which is of great significance to improving the overall effectiveness and efficiency of data security protection;
[0093] (VI) The present invention realizes the construction of a heterogeneous data security protection platform. By integrating multiple modules such as heterogeneous database adaptation, data operation pre-warning, in-process control, and post-audit, it realizes comprehensive, coordinated, and efficient protection of data security. In practical applications, the present invention can improve the overall capability and efficiency of data security protection, reduce the risk of data leakage and misoperation, and ensure the continuity of organizational business and data security.
[0094] (VII) Comprehensive coverage of the data life cycle: The present invention covers multiple links such as data access, operation execution, and post-audit, achieving comprehensive protection of data security. This full-cycle protection ensures the security of data throughout its life cycle and reduces the risk of data leakage and illegal access;
[0095] (VIII) Multi-dimensional collaborative protection: By integrating multiple modules such as heterogeneous database adaptation, data operation pre-warning, in-process control, and post-audit, the present invention realizes multi-dimensional collaborative protection. This collaborative work can ensure information exchange and collaborative operations between different modules, thereby improving the overall effectiveness and efficiency of data security protection;
[0096] (IX) Improve operational efficiency and accuracy: Pre-warning and in-process control modules can detect potential security risks in a timely manner through intelligent analysis and real-time monitoring, and provide corresponding warning and control measures, which can reduce the workload of manual review and operation and improve the accuracy and efficiency of operations;
[0097] (10) Flexible and configurable: The present invention supports configuring access control policies based on customized data sets, roles, sensitive data types, and security levels according to business conditions. This flexibility enables organizations to customize security configurations according to their own needs to better meet the needs of business development;
[0098] (XI) Strengthen post-audit and tracing: The post-audit module can conduct a comprehensive audit and traceability of database operations by recording and storing operation logs, which helps to discover potential security incidents and illegal operations, and provides an important basis for subsequent security analysis and accident handling. BRIEF DESCRIPTION OF THE DRAWINGS
[0099] The present invention is further described below in conjunction with the accompanying drawings.
[0100] Attached Figure 1 This is a schematic diagram of a heterogeneous data security management and control method for project operation and maintenance;
[0101] Attached Figure 2 This is a schematic diagram of heterogeneous data management;
[0102] Attached Figure 3 This is a schematic diagram of the unified access entrance;
[0103] Attached Figure 4 This is a flow chart for high-risk operations. DETAILED DESCRIPTION
[0104] The heterogeneous data security management and control method, system, device and medium for project operation and maintenance of the present invention are described in detail below with reference to the drawings and specific embodiments of the specification.
[0105] Embodiment 1:
[0106] As attached Figure 1 As shown, this embodiment provides a heterogeneous data security management and control method for project operation and maintenance, and the method is specifically as follows:
[0107] S1. Define the roles and responsibilities of the database security protection platform: By sorting out the scenarios of daily data security operation and maintenance of the project, complete the definition of roles, users and responsibilities of the database security protection platform, and lay the foundation for the division of rights and responsibilities of the database security protection platform;
[0108] S2. Build a heterogeneous database adaptation engine to achieve comprehensive management of data;
[0109] S3. Build a user system and unify data access portals;
[0110] S4. Refined data permission control;
[0111] S5. Data operation warning strategy configuration;
[0112] S6. Intervention management during data operation;
[0113] S7. Post-audit of data operations.
[0114] The database security protection platform in step S1 of this embodiment defines two categories and seven roles, including platform-level operation and maintenance management and project operation and maintenance management-level roles (tenants). The actual users corresponding to each role and their responsibilities in daily project management, data operations, and security operation and maintenance management are shown in the following table:
[0115]
[0116]
[0117] As attached Figure 2 As shown, in step S2 of this embodiment, before building the heterogeneous database adaptation engine, the target database is first investigated and analyzed to understand its data format, storage structure and access interface information, and then, based on the collected information, exclusive adapters (DataAdaptor) for different databases are designed and developed, and the heterogeneous data adaptation engine schedules different adapters to achieve connection and communication with various types of databases; the heterogeneous data adaptation engine is used to implement the encapsulation and standardization of database drivers, so that the database security protection platform can manage and operate various databases in a unified manner, and flexibly expand different data types and database products; finally, the target database is included in the management scope of the database security protection platform through the heterogeneous data adaptation engine to achieve unified management and control of data resources.
[0118] The construction of a heterogeneous database adaptation engine in step S2 of this embodiment to complete the comprehensive management of data is as follows:
[0119] S201, Script distribution mechanism:
[0120] (1) The heterogeneous data adaptation engine supports converting SQL scripts or other database operation scripts into a format that can be executed on the target database;
[0121] (2) Use database connection pool technology to manage and reuse database connections to improve script execution efficiency;
[0122] (3) Introduce a task scheduling framework, such as Quartz, to implement scheduled script delivery;
[0123] S202, result query:
[0124] (1) Design a result storage mechanism: Use a database or cache system to store script execution results;
[0125] (2) Providing an API interface that allows users to query execution results based on script ID and execution time;
[0126] (3) For queries that exceed the set threshold number of data, consider using paging and indexing technology to optimize query performance;
[0127] S203, authority configuration is issued:
[0128] (1) Design a unified permission configuration model that is compatible with the permission systems of different databases;
[0129] (2) Implement the logic of issuing permission configuration and convert the configuration into permission setting statements that can be recognized by the corresponding database;
[0130] (3) Provide an API interface to allow administrators to batch issue permission configurations through the API interface;
[0131] S204. User role authority data query:
[0132] (1) The heterogeneous data adaptation engine maintains a mapping table between user roles and permissions;
[0133] (2) Provide an API interface to allow users to query permission data based on username and role conditions;
[0134] (3) Consider using caching technology to reduce the number of database queries and improve query efficiency;
[0135] S205, monitoring information collection:
[0136] (1) Design monitoring indicators: number of database connections, execution efficiency and error rate;
[0137] (2) Implement monitoring data collection logic and collect relevant indicator data from the target database at regular intervals;
[0138] (3) Storing monitoring data in a database or time series database to facilitate subsequent analysis and alarm;
[0139] S206. Database configuration is issued:
[0140] (1) Design a unified database configuration model that can cover the configuration items of different databases;
[0141] (2) Implement the configuration delivery logic and convert the configuration into the configuration setting statement of the corresponding database;
[0142] (3) Provide an API interface, allowing administrators to batch distribute and modify configurations through the API interface;
[0143] As attached Figure 3 As shown, the construction of the user system in step S3 of this embodiment and the unified data access entry are as follows:
[0144] S301. Reclaim redundant accounts and unify access portals: After accessing various databases, the database access accounts reclaimed by R&D and operation and maintenance personnel can access the database through the data security protection platform account with unified access portals;
[0145] S302, Unified data access path: By configuring a whitelist, limit the access IP addresses of various application databases, authorize only the business system host and the security protection platform host to access data, cut off other database access paths, and standardize database access;
[0146] S303, forced interruption of abnormal access: obtain all database connection pool information (dataSourceConnection) in real time, and forcibly close the connection with unauthorized access through the configuration policy.
[0147] The refined data authority control in step S4 of this embodiment is as follows:
[0148] S401, hierarchical authorization mechanism: establish a hierarchical authorization mechanism based on defined user roles and responsibilities; and allocate one or more permission nodes under the database management operation, data object, and data access categories through a permission tree or permission matrix;
[0149] S402, Fine-grained permission management: Implement fine-grained permission control through configuration of data sets, sensitive data types, and security levels; for example, for certain highly sensitive data sets, only specific roles or specially authorized users may have access; for other data sets, access control policies can be customized according to business needs.
[0150] The data operation warning strategy configuration in step S5 of this embodiment is specifically as follows:
[0151] S501. Define a set of flexible and comprehensive security policies based on the actual project operation and maintenance management and data usage requirements. The security policies include access control, operation restrictions and sensitive instruction rules; and configure early warning, review, control and backup mechanisms based on the security policies;
[0152] S502, sensitive instruction rules are the core of pre-warning. By analyzing and identifying sensitive operations such as deletion and modification in SQL statements, high-risk operations can be perceived and warned. When unauthorized high-risk operations are detected, direct blocking is adopted to prevent data loss. For authorized high-risk operations, highlighted reminders are given and the operations are executed after manual confirmation by the user.
[0153] S503, Pre-warning also provides online SQL editing function, supports advanced SQL editor across multiple data sources, and improves the efficiency and security of data operations;
[0154] When executing defined high-risk operations, the database security protection platform pre-executes the user's script and provides feedback to the user for confirmation. After confirmation, the data before modification is stored in the OSS object storage for backup to prevent data backtracking after misoperation. The script is then executed and the log is recorded, as shown in the attached file. Figure 4 shown.
[0155] The data operation in-process intervention management in step S6 of this embodiment is specifically as follows:
[0156] S601. Monitor the operating status of the managed database in real time. The operating status of the database includes performance indicators, connection status, and error logs.
[0157] S602. By collecting and analyzing the operation status data of the database, abnormalities and potential risks are discovered in a timely manner, and administrators are notified through alarms to intervene; in addition, continuous performance monitoring and multi-dimensional performance optimization are also carried out;
[0158] S603: Improve database performance and stability by adjusting database configuration parameters online, identifying slow SQL statements, recommending indexes, and optimizing SQL rewrites. At the same time, provide a visualized topology function to help operation and maintenance personnel quickly locate anomalies and associated potential impacts.
[0159] S604. At the privacy data protection level, by configuring desensitization rules, dynamic desensitization of data related to different roles and permission users is achieved to protect data privacy and security.
[0160] The post-audit of data operation in step S7 of this embodiment is as follows:
[0161] S701. Construct heterogeneous data operation audit tools to record and store log information of all database operations. The log information of all database operations includes operation time, operation type, operation object and execution result.
[0162] S702. Analyze and summarize the log information of all database operations through the audit report function to generate a detailed operation and maintenance report. The detailed operation and maintenance report is used to help operation and maintenance personnel understand the distribution of database operations, user behavior patterns, and potential security risks.
[0163] S703. Conduct independent audits from the perspective of database objects and users;
[0164] S704, comprehensively understand the usage and security status of the database by viewing the operation records and user authority information of the specified database object and the database operation records and access rights of the specified user;
[0165] S705. The audit data visualization function is used to display multi-dimensional audit data in the form of charts, helping users to quickly analyze audit data to discover anomalies or potential security risks.
[0166] Embodiment 2:
[0167] This embodiment provides a heterogeneous data security management and control system for project operation and maintenance, which includes a heterogeneous database adaptation module, a data operation pre-warning module, a data operation in-process control module, and a data operation post-audit module;
[0168] Among them, the heterogeneous database adaptation module is used to achieve connection and adaptation with different database systems to uniformly manage heterogeneous databases;
[0169] The data operation pre-warning module is used to conduct early warning analysis according to the preset security strategy before the data operation is executed to prevent potential security risks; the data operation pre-warning module also has a sensitive instruction recognition function to identify and warn potential high-risk operation instructions;
[0170] The data operation control module is used to monitor the operation status of the database in real time during the data operation process, and to optimize performance and handle exceptions. The data operation control module also has a dynamic desensitization function, which is used to realize dynamic encryption and desensitization of data during the data operation process.
[0171] The data operation post-audit module is used to record and analyze the log information of data operations to realize the audit and traceability of data operations.
[0172] The system also has the following functions:
[0173] ① Supports customizing data sets, roles, sensitive data types, and security levels according to business conditions to configure access control policies; access control policies include allowing, denying, or alerting specific users to access specific data sets;
[0174] ② Provide visual topology function to display the connection status and performance indicators of the database;
[0175] ③ Provide online SQL editing function to support advanced SQL editor across multiple data sources.
[0176] Embodiment 3:
[0177] This embodiment also provides an electronic device, including: a memory and a processor;
[0178] Wherein, the memory stores computer-executable instructions;
[0179] The processor executes the computer-executable instructions stored in the memory, so that the processor executes the heterogeneous data security management and control method for project operation and maintenance in any embodiment of the present invention.
[0180] The processor may be a central processing unit (CPU), or other general-purpose processors, digital signal processors (DSP), application-specific integrated circuits (ASIC), field-programmable gate arrays (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, etc. The processor may be a microprocessor or any conventional processor, etc.
[0181] The memory can be used to store computer programs and / or modules. The processor realizes various functions of the electronic device by running or executing the computer programs and / or modules stored in the memory, and calling the data stored in the memory. The memory can mainly include a program storage area and a data storage area, wherein the program storage area can store an operating system, at least one application required for a function, etc.; the data storage area can store data created according to the use of the terminal, etc. In addition, the memory can also include a high-speed random access memory, and can also include a non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a smart memory card (SMC), a secure digital (SD) card, a flash memory card, at least one disk storage period, a flash memory device, or other volatile solid-state storage devices.
[0182] Embodiment 4:
[0183] This embodiment also provides a computer-readable storage medium, in which a plurality of instructions are stored, and the instructions are loaded by a processor, so that the processor executes the heterogeneous data security management and control method for project operation and maintenance in any embodiment of the present invention. Specifically, a system or device equipped with a storage medium can be provided, on which a software program code that implements the functions of any of the above embodiments is stored, and a computer (or CPU or MPU) of the system or device reads and executes the program code stored in the storage medium.
[0184] In this case, the program code itself read from the storage medium can realize the function of any one of the above-mentioned embodiments, and thus the program code and the storage medium storing the program code constitute a part of the present invention.
[0185] The storage medium embodiments for providing the program code include a floppy disk, a hard disk, a magneto-optical disk, an optical disk (such as CD-ROM, CD-R, CD-RW, DVD-ROM, DVD-RYM, DVD-RW, DVD+RW), a magnetic tape, a non-volatile memory card, and a ROM. Alternatively, the program code can be downloaded from a server computer via a communication network.
[0186] In addition, it should be clear that the functions of any of the above embodiments can be implemented not only by executing the program code read by the computer, but also by enabling an operating system operating on the computer to complete part or all of the actual operations based on instructions from the program code.
[0187] In addition, it can be understood that the program code read from the storage medium is written to a memory provided in an expansion board inserted into the computer or written to a memory provided in an expansion unit connected to the computer, and then based on the instructions of the program code, a CPU installed on the expansion board or the expansion unit is enabled to perform part or all of the actual operations, thereby realizing the functions of any of the above-mentioned embodiments.
[0188] Finally, it should be noted that the above embodiments are only used to illustrate the technical solutions of the present invention, rather than to limit it. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that they can still modify the technical solutions described in the aforementioned embodiments, or replace some or all of the technical features therein with equivalents. However, these modifications or replacements do not cause the essence of the corresponding technical solutions to deviate from the scope of the technical solutions of the embodiments of the present invention.
Claims
1. A heterogeneous data security management and control method for project operation and maintenance. It is characterized in that The method is as follows: Sorting out and defining the roles and responsibilities of the database security protection platform: By sorting out the scenarios of daily data security operation and maintenance of the project, the roles, users and responsibilities of the database security protection platform are defined, laying the foundation for the division of rights and responsibilities of the database security protection platform; Build a heterogeneous database adaptation engine to achieve comprehensive management of data; Build a user system and a unified data access portal; Refined data permission control; Data operation warning strategy configuration; Intervention management during data operation; Post-audit of data operations.
2. According to the heterogeneous data security management and control method for project operation and maintenance according to claim 1, It is characterized in that The roles defined by the database security protection platform include two categories: platform-level roles and tenant-level roles. Platform-level roles include platform operation administrators and platform operation and maintenance administrators. Tenant-level roles include operation administrators, security administrators, audit administrators, operation and maintenance administrators, and ordinary users under the corresponding projects. The users defined by the database security protection platform include the director of the information center, the platform builder, the data prevention and control platform operation and maintenance team, business department customers, project managers, platform operation and maintenance supervisors, implementers, testers and developers; Among them, the director of the information center and the platform builder shall conduct authority level management, authorization management, authority approval and process design in advance, and conduct audit management and operation analysis during and after the event; The data prevention and control platform operation and maintenance team performs system initialization, permission configuration, organizational maintenance, tenant-level project maintenance, tenant initial account maintenance, and process configuration in advance, and conducts audit management and platform operation and maintenance during and after the event; Business department clients conduct project authority management and authority approval in advance, and conduct project-level audit management and operation analysis during and after the project; The project manager under the security administrator shall perform project authority management and authority approval in advance; The project manager under the audit administrator conducts project-level audit management after the fact; The platform operation and maintenance supervisor under the audit administrator conducts project-level audit management during and after the event; The platform operation and maintenance supervisor shall perform project personnel initialization, authority configuration, database access, data protection policy configuration, task configuration, data management and configuration file management in advance, perform project data operation maintenance, performance monitoring, performance diagnosis and data operation approval during the project, and perform data recovery afterwards; The implementation personnel will carry out project deployment and data implementation in advance; Testers conduct pre-launch verification and data query on the project; Developers perform data operations and configuration file modifications in advance.
3. According to the heterogeneous data security management and control method for project operation and maintenance according to claim 1, It is characterized in that Before building a heterogeneous database adaptation engine, first conduct research and analysis on the target database to understand its data format, storage structure, and access interface information. Then, based on the collected information, design and develop dedicated adapters for different databases. Through the scheduling of different adapters by the heterogeneous data adaptation engine, connection and communication with various types of databases can be achieved. The heterogeneous data adaptation engine is used to implement the encapsulation and standardization of database drivers, so that the database security protection platform can manage and operate various databases in a unified way, and flexibly expand different data types and database products. Finally, the target database is included in the management scope of the database security protection platform through the heterogeneous data adaptation engine to achieve unified management and control of data resources. Constructing a heterogeneous database adaptation engine to complete comprehensive data management is as follows: Script delivery mechanism: (1) The heterogeneous data adaptation engine supports converting SQL scripts or other database operation scripts into a format that can be executed on the target database; (2) Use database connection pool technology to manage and reuse database connections to improve script execution efficiency; (3) Introduce a task scheduling framework to implement scheduled delivery of scripts; Result query: (1) Design a result storage mechanism: Use a database or cache system to store script execution results; (2) Providing an API interface that allows users to query execution results based on script ID and execution time; (3) For queries that exceed the set threshold number of data, consider using paging and indexing technology to optimize query performance; Permission configuration is issued: (1) Design a unified permission configuration model that is compatible with the permission systems of different databases; (2) Implement the logic of issuing permission configuration and convert the configuration into permission setting statements that can be recognized by the corresponding database; (3) Provide an API interface to allow administrators to batch issue permission configurations through the API interface; User role permission data query: (1) The heterogeneous data adaptation engine maintains a mapping table between user roles and permissions; (2) Provide an API interface to allow users to query permission data based on username and role conditions; (3) Consider using caching technology to reduce the number of database queries and improve query efficiency; Monitoring information collection: (1) Design monitoring indicators: number of database connections, execution efficiency and error rate; (2) Implement monitoring data collection logic and collect relevant indicator data from the target database at regular intervals; (3) Storing monitoring data in a database or time series database to facilitate subsequent analysis and alarm; Database configuration is issued: (1) Design a unified database configuration model that can cover the configuration items of different databases; (2) Implement the configuration delivery logic and convert the configuration into the configuration setting statement of the corresponding database; (3) Provide an API interface, allowing administrators to batch distribute and modify configurations through the API interface.
4. According to the heterogeneous data security management and control method for project operation and maintenance according to claim 1, It is characterized in that Build a user system and unify the data access portal as follows: Reclaim redundant accounts and unify access portals: After accessing various databases, the database access accounts reclaimed by R&D and operation and maintenance personnel can access the database through the data security protection platform account with unified access portals; Unified data access path: By configuring a whitelist, the access IP addresses of various application databases are limited, and only the business system host and the security protection platform host are authorized to access data, cutting off other database access paths and standardizing database access; Forced interruption of abnormal access: Get all database connection pool information (dataSourceConnection) in real time, and forcefully close unauthorized access connections through configuration policies.
5. According to the heterogeneous data security management and control method for project operation and maintenance according to claim 1, It is characterized in that The details of refined data permission control are as follows: Hierarchical authorization mechanism: Establish a hierarchical authorization mechanism based on defined user roles and responsibilities; and assign one or more permission nodes under the database management operation, data object, and data access categories through a permission tree or permission matrix; Fine-grained permission management: fine-grained permission control is achieved through configuration of data sets, sensitive data types, and security levels; The data operation warning strategy configuration is as follows: Define a set of flexible and comprehensive security policies based on the actual project operation and maintenance management and data usage requirements. The security policies include access control, operation restrictions and sensitive instruction rules. Configure early warning, audit, control and backup mechanisms based on the security policies. Sensitive instruction rules are the core of advance warning. By analyzing and identifying sensitive deletion and modification operations in SQL statements, high-risk operations can be perceived and warned. When unauthorized high-risk operations are detected, direct blocking is adopted to prevent data loss. For authorized high-risk operations, highlighted reminders are given and the operations are executed after manual confirmation by the user. Pre-warning also provides online SQL editing function, supports advanced SQL editors across multiple data sources, and improves the efficiency and security of data operations; Among them, when executing defined high-risk operations, the database security protection platform will pre-execute the user's script and feedback the user's confirmation. After confirmation, the data before modification will be stored in the OSS object storage for backup to prevent data backtracking after misoperation, and then the script will be executed and logs will be recorded.
6. A method for heterogeneous data security management and control for project operation and maintenance according to any one of claims 1 to 5, It is characterized in that The details of the intervention management during data operation are as follows: Real-time monitoring of the operating status of the managed database, including performance indicators, connection status, and error logs; By collecting and analyzing the operating status data of the database, abnormalities and potential risks are discovered in a timely manner, and administrators are notified through alarms for intervention; in addition, continuous performance monitoring and multi-dimensional performance optimization are also carried out; Improve database performance and stability by adjusting database configuration parameters online, identifying slow SQL statements, recommending indexes, and optimizing SQL rewrites. At the same time, provide a visualized topology function to help operation and maintenance personnel quickly locate anomalies and associated potential impacts. In terms of privacy data protection, by configuring desensitization rules, dynamic desensitization of data for users with different roles and permissions can be achieved to protect data privacy and security; The details of post-audit of data operations are as follows: Build heterogeneous data operation audit tools to record and store log information of all database operations. The log information of all database operations includes operation time, operation type, operation object and execution result. The audit report function analyzes and summarizes the log information of all database operations to generate detailed operation and maintenance reports. The detailed operation and maintenance reports are used to help operation and maintenance personnel understand the distribution of database operations, user behavior patterns, and potential security risks. Conduct independent audits from the perspective of database objects and users; Comprehensively understand the usage and security status of the database by viewing the operation records and user permission information of the specified database objects, as well as the database operation records and access rights of the specified users; The audit data visualization function displays multi-dimensional audit data in the form of charts, helping users quickly analyze audit data to discover anomalies or potential security risks.
7. A heterogeneous data security management and control system for project operation and maintenance. It is characterized in that The system includes a heterogeneous database adaptation module, a data operation pre-warning module, a data operation in-process control module and a data operation post-audit module; Among them, the heterogeneous database adaptation module is used to achieve connection and adaptation with different database systems to uniformly manage heterogeneous databases; The data operation pre-warning module is used to conduct early warning analysis according to the preset security strategy before the data operation is executed to prevent potential security risks; the data operation pre-warning module also has a sensitive instruction recognition function to identify and warn potential high-risk operation instructions; The data operation control module is used to monitor the operation status of the database in real time during the data operation process, and to optimize performance and handle exceptions. The data operation control module also has a dynamic desensitization function, which is used to realize dynamic encryption and desensitization of data during the data operation process. The data operation post-audit module is used to record and analyze the log information of data operations to realize the audit and traceability of data operations.
8. According to the heterogeneous data security management and control system for project operation and maintenance according to claim 7, It is characterized in that The system also has the following functions: ① Supports customizing data sets, roles, sensitive data types, and security levels according to business conditions to configure access control policies; access control policies include allowing, denying, or alerting specific users to access specific data sets; ② Provide visual topology function to display the connection status and performance indicators of the database; ③ Provide online SQL editing function to support advanced SQL editor across multiple data sources.
9. An electronic device, It is characterized in that include: memory and at least one processor; Wherein, the memory stores a computer program; The at least one processor executes the computer program stored in the memory, so that the at least one processor executes the heterogeneous data security management and control method for project operation and maintenance as described in any one of claims 1 to 6.
10. A computer-readable storage medium, It is characterized in that The computer-readable storage medium stores a computer program, which can be executed by a processor to implement the heterogeneous data security management and control method for project operation and maintenance as described in any one of claims 1 to 6.
Citation Information
Cited By
User permission configuration method and device, electronic equipment and storage medium
CN120277723A
