A database information push method, intelligent terminal and storage medium

Abstract

The present invention discloses a method for pushing database information, an intelligent terminal and a storage medium, the method comprising: obtaining a database log corresponding to a database, parsing database change information from the database log; querying a pre-established database authority control table according to the database change information, and determining the authority user group and authority user corresponding to the database change information; wherein the database includes several database tables, and the database authority control table stores authority user groups and authority users corresponding to the several database tables; and pushing the database change information to the authority user group and authority user. The present invention pushes the database change information to the corresponding authority user group and authority user, realizes unified control of database changes, prevents the database from being tampered with at will and unknown, improves the development efficiency, stability and security of the database, and saves the time cost and manpower cost of database development.

Description

Technical Field

[0001] The present invention relates to the field of database technology, and in particular to a database information push method, an intelligent terminal and a storage medium. Background Art

[0002] A database is a collection of data organized according to a preset data model and stored in a memory. This data collection serves multiple applications of a specific organization and is independent of the applications that use it. The addition, deletion, modification, and query of data are managed and controlled by unified software.

[0003] During the development and application of existing databases, it is inevitable to make changes to the database, such as data modification, table creation and modification, etc. However, since the database change information of the existing database cannot be intelligently displayed and give developers effective prompts, database development is restricted, database security cannot be guaranteed, and it is not easy to maintain later.

[0004] Therefore, the existing technology still needs to be improved and developed. Summary of the invention

[0005] The technical problem to be solved by the present invention is that, in view of the above-mentioned defects of the prior art, a database information push method, an intelligent terminal and a storage medium are provided, aiming to solve the problem that the existing database change information cannot be intelligently displayed and give effective prompts to developers, resulting in limited database development, database security cannot be guaranteed, and it is not easy to maintain in the future.

[0006] The technical solution adopted by the present invention to solve the problem is as follows:

[0007] In a first aspect, an embodiment of the present invention provides a method for pushing database information, wherein the method comprises:

[0008] Obtaining a database log corresponding to the database, and parsing database change information from the database log;

[0009] According to the database change information, a pre-established database authority control table is queried to determine the authority user group and authority user corresponding to the database change information; wherein the database includes several database tables, and the database authority control table stores the authority user groups and authority users corresponding to the several database tables;

[0010] The database change information is pushed to the authorized user group and the authorized user.

[0011] The method for pushing database information, wherein the step of querying a pre-established database authority control table according to the database change information to determine the authority user group and authority user corresponding to the database change information comprises:

[0012] Permissions are allocated to the plurality of database tables, the plurality of database tables are allocated to preset permission user groups and permission users, and a database permission control table is established based on the plurality of database tables and the permission user groups and permission users corresponding to the plurality of database tables.

[0013] In the database information push method, the database includes a database master database and a database slave database, and the step of obtaining a database log corresponding to the database includes:

[0014] The interactive protocol of the database slave is simulated by the canal component, a dump protocol is sent to the database master, and the database log corresponding to the database is obtained from the database master.

[0015] The method for pushing database information, wherein the step of parsing the database change information from the database log comprises:

[0016] The canal component is used to parse the database log, and database change information is parsed from the database log.

[0017] The method for pushing database information, wherein the step of querying a pre-established database authority control table according to the database change information to determine the authority user group and authority user corresponding to the database change information comprises:

[0018] Compare the database change information with the plurality of database tables, and determine a target database table corresponding to the database change information from the plurality of database tables;

[0019] The pre-constructed database authority control table is queried according to the target database table to obtain the authority user group and authority user corresponding to the target database table, and the authority user group and authority user corresponding to the target database table are used as the authority user group and authority user corresponding to the change information.

[0020] The method for pushing database information, wherein the step of pushing the database change information to the authorized user group and the authorized user comprises:

[0021] The database change information is pushed to the authorized user group and the authorized user by means of email or text message.

[0022] The database information pushing method, wherein the database information pushing method further comprises:

[0023] Obtaining in real time the user's change instructions for the database tables;

[0024] The database tables are changed according to the change instruction, and the database log is updated based on the changes of the database tables.

[0025] The method for pushing database information, wherein after the step of pushing the database change information to the authorized user group and the authorized user, further comprises:

[0026] The location of the database change information in the database log is recorded.

[0027] In a second aspect, an embodiment of the present invention further provides a database information push device, wherein the device comprises:

[0028] An information acquisition unit, used to acquire a database log corresponding to the database, and parse the database change information from the database log;

[0029] A user matching unit is used to query a pre-established database authority control table according to the database change information to determine the authority user group and authority user corresponding to the database change information; wherein the database includes a plurality of database tables, and the database authority control table stores the authority user groups and authority users corresponding to the plurality of database tables;

[0030] The information push unit is used to push the database change information to the authorized user group and the authorized user.

[0031] In a third aspect, the present invention also provides an intelligent terminal comprising a memory and one or more programs, wherein the one or more programs are stored in the memory and are configured to be executed by one or more processors, and the one or more programs include a method for executing database information push as described in any one of the above items.

[0032] In a fourth aspect, an embodiment of the present invention further provides a non-temporary computer-readable storage medium, which, when instructions in the storage medium are executed by a processor of an electronic device, enables the electronic device to execute a database information push method as described in any one of the above.

[0033] Beneficial effects of the present invention: The embodiment of the present invention first obtains the database log corresponding to the database, parses the database change information from the database log, and then queries the pre-established database permission control table according to the database change information to determine the permission user group and permission user corresponding to the database change information. Finally, the database change information is pushed to the permission user group and the permission user. Therefore, the pre-established database permission control table is queried according to the database change information, and the database change information is pushed to the corresponding permission user group and permission user, thereby realizing unified control over database changes, preventing the database from being arbitrarily tampered with without knowing it, improving the development efficiency, stability and security of the database, and saving the time cost and manpower cost of database development. BRIEF DESCRIPTION OF THE DRAWINGS

[0034] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0035] Figure 1 It is a flowchart of a method for pushing database information provided by an embodiment of the present invention;

[0036] Figure 2 It is a schematic diagram of a process of obtaining a database log corresponding to a database in a database information push method provided in an embodiment of the present invention;

[0037] Figure 3 It is a principle block diagram of a database information push device provided by an embodiment of the present invention;

[0038] Figure 4 It is a block diagram of the internal structure principle of the intelligent terminal provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0039] In order to make the purpose, technical solution and advantages of the present invention clearer and more specific, the present invention is further described in detail below with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not used to limit the present invention.

[0040] It should be noted that if the embodiments of the present invention involve directional indications (such as up, down, left, right, front, back, etc.), the directional indications are only used to explain the relative position relationship, movement status, etc. between the components under a certain specific posture (as shown in the accompanying drawings). If the specific posture changes, the directional indication will also change accordingly.

[0041] In the prior art, due to the failure to reasonably plan and design the database in the early stage, and the uneven capabilities of the team developers, it is inevitable to change the database table structure and database table data in the later stage. However, since the database change information of the existing database cannot be intelligently displayed and effectively prompted to the developers (for example, if a database table structure changes, the development team and developers corresponding to the database table are unaware of the change due to the lack of corresponding prompts), database development is limited, database security cannot be guaranteed, and it is not easy to maintain in the later stage.

[0042] In order to solve the problems of the prior art, this embodiment provides a database information push method, through which the database change information can be pushed to the relevant permission user group and permission user in time when the database changes, so as to realize the unified control of the database change, prevent the database from being tampered with at will and unknown, improve the development efficiency, stability and security of the database, and save the time cost and manpower cost of database development. In the specific implementation, firstly obtain the database log corresponding to the database, parse the database change information from the database log, then query the pre-established database permission control table according to the database change information, determine the permission user group and permission user corresponding to the database change information, and finally, push the database change information to the permission user group and the permission user, therefore, query the pre-established database permission control table according to the database change information, push the database change information to the corresponding permission user group and permission user, realize the unified control of the database change, prevent the database from being tampered with at will and unknown, improve the development efficiency, stability and security of the database, and save the time cost and manpower cost of database development.

[0043] For example, a database log corresponding to a database is obtained. The database is Alibaba Cloud's MySQL database. The database log is a binary log (binary log, Binlog). Then, the database change information is parsed from the database log. The database change information is a data addition operation on database table A. Then, the pre-established database permission control table is queried according to the database change information. For example, the pre-established database permission control table stores that the permission user group corresponding to database table A is user group A, and the permission users are a1, b1, c1, and d1. Then, it can be determined that the permission user group corresponding to the database change information is user group A, and the permission users are a1, b1, c1, and d1. Finally, the database change information is pushed to permission user group A and permission users a1, b1, c1, and d1. Since the pre-established database permission control table is queried according to the database change information, the database change information is pushed to the corresponding permission user group and permission user. Therefore, unified control of database changes can be achieved, and the database can be prevented from being tampered with at will without knowing it, thereby improving the development efficiency, stability, and security of the database, and saving the time and manpower costs of database development.

[0044] Exemplary Methods

[0045] This embodiment provides a method for pushing database information, which can be applied to smart terminals. Figure 1 As shown in , the method includes:

[0046] Step S100: Obtain a database log corresponding to the database, and parse the database change information from the database log.

[0047] Specifically, the database log is a database incremental log or binary log (binary log or Binlog log) corresponding to the database. Binlog log is a SQL statement that records database changes in binary form, which is used to record changes that occur in the database, such as data modification, table creation and modification. In this embodiment, the database log is monitored in real time. When the database log changes, the database log is obtained, and the database change information is parsed from the database log. The database change information includes changing the database table name, changing the database library name, change types such as data addition, deletion, modification, and database change time, so that the database change information can be pushed to the corresponding permission user group and permission user in the subsequent steps, and the database is uniformly managed and controlled by the permission user group and permission user to prevent the database from being tampered with without knowing it.

[0048] For example, taking Alibaba Cloud's MySQL database as an example, when R&D personnel A adds data to database table A at a certain moment, the database log will record the operation in the database log. By obtaining the database log and parsing the data change information from the database log, the database change information of the data addition operation performed by R&D personnel A on data table A at a certain moment can be obtained.

[0049] In a specific implementation, the step of obtaining the database log corresponding to the database in step S100 includes:

[0050] Step S110: simulate the interactive protocol of the database slave library through the canal component, send the dump protocol to the database master library, and obtain the database log corresponding to the database from the database master library.

[0051] Specifically, the canal component is an open source product of Alibaba, which provides incremental data subscription and consumption based on database incremental log analysis. In this embodiment, the canal component monitors the database and obtains the database log when the database log of the database is updated. The database includes a database master and a database slave. The database master is used to record database change information in the database log when the database changes. The Canal component is connected to the database master. Figure 2 As shown in the figure, when the Canal component obtains the database log, it simulates the interaction protocol of the database slave (sysqlslave), disguises itself as mysql skave, and sends the dump protocol to the database master (mysql master). After receiving the dump request, mysql master starts to push the database log to the slave (that is, the canal component).

[0052] In a specific implementation manner, the step of parsing the database change information from the database log in step S100 includes:

[0053] Step S120: using the canal component to parse the database log, and parse out database change information from the database log.

[0054] Specifically, the modes of the database log include Row mode, Statement mode and Mixed mode. Since the database log in Row mode does not need to record the context-related information of the executed SQL statement, it can clearly record the details of each row of data modification. The database log in this embodiment adopts Row mode. Considering that the database log is stored in binary format and cannot be directly opened for viewing, after obtaining the database log corresponding to the database through the canal component in this embodiment, the database change information is further parsed from the database log in Row mode through the canal component. The database change information includes the changed database table name, the changed database library name, the change type such as the addition, deletion, and modification of data, and the database change time.

[0055] Step S200: query a pre-established database authority control table according to the database change information to determine the authority user group and authority user corresponding to the database change information; wherein the database contains several database tables, and the database authority control table stores the authority user groups and authority users corresponding to the several database tables.

[0056] Continue to refer to Figure 2 As shown, in this embodiment, the database change information parsed by the canal component is obtained through the back-end (PHP) server, and the canal component communicates with the back-end (PHP) server through a socket. After the canal component parses the database change information, the back-end (PHP) server obtains the database change information and analyzes it. In order to uniformly control the authority of the database table, a database authority control table is pre-established in this embodiment, and the database authority table stores the authority user groups and authority users corresponding to several database tables in the database. For example, the authority user group corresponding to database table A is user group A, and the authority users are a1, b1, c1, and d1; the authority user group corresponding to database table B is user group B, and the authority users are a2, b2, c2, d2, and e2.

[0057] As mentioned in the above steps, the database change information includes the changed database table name, changed database library name, change type, and database change time. After the back-end (PHP) server obtains the database change information, it queries the database permission control table according to the database change information to determine the permission user group and permission user corresponding to the database change information. For example, if the database change information includes database table A, querying the database permission control table can determine that the permission user group corresponding to the database change information is user group A, and the permission users are a1, b1, c1, and d1.

[0058] In a specific implementation, before step S200, the following steps are included:

[0059] Step M100: assign permissions to the database tables, assign the database tables to preset permission user groups and permission users, and establish a database permission control table based on the database tables and the permission user groups and permission users corresponding to the database tables.

[0060] Considering the huge amount of database data, multiple teams and multiple R&D technicians are required to conduct R&D and maintenance. In this embodiment, according to the database R&D and maintenance requirements, the permissions of several database tables in the database are allocated, and several database tables are allocated to preset permission user groups and permission users, and a database permission control table is established based on the several database tables and the permission user groups and permission users corresponding to the several database tables. For example, database table A is maintained by user group A and users a1, b1, c1, and d1, then the permission user group corresponding to database table A in the database permission control table is user group A, and the permission users are users a1, b1, c1, and d1.

[0061] In a specific implementation, step S200 specifically includes:

[0062] Step S210: Compare the database change information with the plurality of database tables, and determine a target database table corresponding to the database change information from the plurality of database tables;

[0063] Step S220: query a pre-built database authority control table according to the target database table, obtain the authority user group and authority user corresponding to the target database table, and use the authority user group and authority user corresponding to the target database table as the authority user group and authority user corresponding to the change information.

[0064] Specifically, after the back-end (PHP) server obtains the database change information, it compares the database change information with the several database tables. Since the database change information includes the change data table information, such as the change data table name, the change data table ID, etc., the database change information is compared with the several databases, and the target database table corresponding to the database change information can be determined from the several database tables. For example, if the database change information includes database table A, the database change information is compared with the several database tables, and it can be determined that the target database table corresponding to the data change information is database table A.

[0065] Furthermore, after the back-end (PHP) server obtains the target database table corresponding to the database change information, it queries the database permission control table according to the target database table to obtain the permission user group and permission user corresponding to the target database table, and uses the permission user group and permission user corresponding to the target database table as the permission user group and permission user corresponding to the database change information. For example, by querying the database permission control table, it is obtained that the permission user group corresponding to the target database table A is user group A, and the permission users are a1, b1, c1, and d1, then the permission user group corresponding to the database change information is user group A, and the permission users are a1, b1, c1, and d1.

[0066] Step S300: Push the database change information to the authorized user group and the authorized user.

[0067] Specifically, after the back-end (PHP) server determines the permission user group and permission user corresponding to the database change information, it pushes the database change information to the corresponding permission user group and permission user via email or text message, so that the database table is accurately managed by the permission user group and each developer in the permission user group, realizing unified and standardized management of the database, improving the development efficiency, stability and security of the database, and saving time and labor costs in the database development process.

[0068] Of course, the backend (PHP) server is not only used to push database change information, but also to manage the database permission control table, cooperate with developers to allocate permissions to the database table, and update the database permission control table when the permissions of the database table change.

[0069] In a specific implementation, the database information push method further includes:

[0070] Step S410: obtaining in real time the user's change instructions for the database tables;

[0071] Step S420: modify the database tables based on the change instruction and update the database log corresponding to the changes of the database tables.

[0072] Specifically, in this embodiment, the user's change instructions for several database tables in the database will be obtained in real time, and the change instructions may include data modification, table creation and modification, etc. After obtaining the user's change instructions, the several database tables will be changed according to the change instructions, and the database log will be updated based on the changes to the several database tables. For example, if the user's change instruction is to add data M to the fifth row of database table A, then according to the change instruction, data M will be added to the fifth row of database table A, and the database log will be updated based on the database change.

[0073] In a specific embodiment, after step S300, the method further includes:

[0074] Step S500: Record the location of the database change information in the database log.

[0075] Specifically, the database log contains multiple database change information. In order to facilitate the canal component to parse the database change information from the database log next time, in this embodiment, after the back-end (PHP) server receives the database change information and pushes it successfully, it sends a receipt to the canal component. At the same time, the canal component records the position of the database change information in the database log, so that the canal component can parse the database change information from the database log next time, and parse it from the position of the database change information to avoid repeated parsing and pushing of the database change information.

[0076] It can be seen that the embodiment of the present invention first obtains the database log corresponding to the database, parses the database change information from the database log, and then queries the pre-established database permission control table according to the database change information to determine the permission user group and permission user corresponding to the database change information. Finally, the database change information is pushed to the permission user group and the permission user. Therefore, the pre-established database permission control table is queried according to the database change information, and the database change information is pushed to the corresponding permission user group and permission user, thereby realizing unified control of database changes, preventing the database from being arbitrarily tampered with and unknown, improving the development efficiency, stability and security of the database, and saving the time cost and manpower cost of database development.

[0077] Exemplary Devices

[0078] like Figure 3 As shown in , an embodiment of the present invention provides a database information push device, which includes: an information acquisition unit 310, a user matching unit 320, and an information push unit 330. Specifically, the information acquisition unit 310 is used to obtain a database log corresponding to the database, and parse the database change information from the database log. The user matching unit 320 is used to query a pre-established database authority control table according to the database change information, and determine the authority user group and authority user corresponding to the database change information; wherein the database contains several database tables, and the database authority control table stores the authority user groups and authority users corresponding to the several database tables. The information push unit 330 is used to push the database change information to the authority user group and the authority user.

[0079] Based on the above embodiments, the present invention further provides an intelligent terminal, whose principle block diagram can be shown as follows: Figure 4 As shown. The intelligent terminal includes a processor, a memory, a network interface, a display screen, and a temperature sensor connected through a system bus. Among them, the processor of the intelligent terminal is used to provide computing and control capabilities. The memory of the intelligent terminal includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of the operating system and the computer program in the non-volatile storage medium. The network interface of the intelligent terminal is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a database information push method is implemented. The display screen of the intelligent terminal can be a liquid crystal display screen or an electronic ink display screen, and the temperature sensor of the intelligent terminal is pre-set inside the intelligent terminal to detect the operating temperature of the internal device.

[0080] Those skilled in the art will understand that Figure 4 The principle block diagram shown in the figure is only a block diagram of a partial structure related to the scheme of the present invention, and does not constitute a limitation on the smart terminal to which the scheme of the present invention is applied. The specific smart terminal may include more or fewer components than those shown in the figure, or combine certain components, or have a different arrangement of components.

[0081] In one embodiment, a smart terminal is provided, comprising a memory and one or more programs, wherein the one or more programs are stored in the memory and are configured to be executed by one or more processors, and the one or more programs include instructions for performing the following operations:

[0082] Obtaining a database log corresponding to the database, and parsing database change information from the database log;

[0083] According to the database change information, a pre-established database authority control table is queried to determine the authority user group and authority user corresponding to the database change information; wherein the database includes several database tables, and the database authority control table stores the authority user groups and authority users corresponding to the several database tables;

[0084] The database change information is pushed to the authorized user group and the authorized user.

[0085] Those skilled in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided by the present invention can include non-volatile and / or volatile memory. Non-volatile memory can include read-only memory (ROM), programmable ROM (PROM), electrically programmable ROM (EPROM), electrically erasable programmable ROM (EEPROM) or flash memory. Volatile memory can include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM is available in many forms, such as static RAM (SRAM), dynamic RAM (DRAM), synchronous DRAM (SDRAM), double data rate SDRAM (DDRSDRAM), enhanced SDRAM (ESDRAM), synchronous link (Synchlink) DRAM (SLDRAM), memory bus (Rambus) direct RAM (RDRAM), direct memory bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).

[0086] In summary, the present invention discloses a method for pushing database information, an intelligent terminal and a storage medium, the method comprising: obtaining a database log corresponding to a database, parsing database change information from the database log; querying a pre-established database authority control table according to the database change information, and determining the authority user group and authority user corresponding to the database change information; wherein the database contains several database tables, and the database authority control table stores authority user groups and authority users corresponding to the several database tables; and pushing the database change information to the authority user group and the authority user. The present invention queries a pre-established database authority control table according to the database change information, pushes the database change information to the corresponding authority user group and authority user, realizes unified control of database changes, prevents the database from being tampered with at will and unknown, improves the development efficiency, stability and security of the database, and saves the time cost and manpower cost of database development.

[0087] It should be understood that the application of the present invention is not limited to the above examples. For ordinary technicians in this field, improvements or changes can be made based on the above description. All these improvements and changes should fall within the scope of protection of the claims attached to the present invention.

Claims

1. A method for pushing database information, characterized in that: The method comprises: Obtain a database log corresponding to the database, and parse the database change information from the database log; the modes of the database log include Row mode, Statement mode and Mixed mode; According to the database change information, a pre-established database authority control table is queried to determine the authority user group and authority user corresponding to the database change information; wherein the database includes several database tables, and the database authority control table stores the authority user groups and authority users corresponding to the several database tables; Pushing the database change information to the authorized user group and the authorized user; Centralized management and control of the database through authorized user groups and authorized users; The database includes a database master database and a database slave database, and the step of obtaining a database log corresponding to the database includes: Simulate the interactive protocol of the database slave library through the canal component, send the dump protocol to the database master library, and obtain the database log corresponding to the database from the database master library; The step of parsing the database change information from the database log includes: The canal component is used to parse the database log, and the database change information is parsed from the database log, so as to avoid repeated parsing and pushing of the database change information.

2. The method for pushing database information according to claim 1, characterized in that: The step of querying a pre-established database authority control table according to the database change information to determine the authority user group and authority user corresponding to the database change information includes: Permissions are allocated to the plurality of database tables, the plurality of database tables are allocated to preset permission user groups and permission users, and a database permission control table is established based on the plurality of database tables and the permission user groups and permission users corresponding to the plurality of database tables.

3. The method for pushing database information according to claim 1, characterized in that: The step of querying a pre-established database authority control table according to the database change information to determine the authority user group and authority user corresponding to the database change information comprises: Compare the database change information with the plurality of database tables, and determine a target database table corresponding to the database change information from the plurality of database tables; The pre-constructed database authority control table is queried according to the target database table to obtain the authority user group and authority user corresponding to the target database table, and the authority user group and authority user corresponding to the target database table are used as the authority user group and authority user corresponding to the change information.

4. The method for pushing database information according to claim 1, characterized in that: The step of pushing the database change information to the authorized user group and the authorized user comprises: The database change information is pushed to the authorized user group and the authorized user by means of email or text message.

5. The method for pushing database information according to claim 1, characterized in that: The database information push method also includes: Obtaining in real time the user's change instructions for the database tables; The database tables are changed according to the change instruction, and the database log is updated based on the changes of the database tables.

6. The method for pushing database information according to claim 1, characterized in that: After the step of pushing the database change information to the authorized user group and the authorized user, the following step is further included: The location of the database change information in the database log is recorded.

7. An intelligent terminal, characterized in that: The device comprises a memory and one or more programs, wherein the one or more programs are stored in the memory and are configured to be executed by one or more processors, and the one or more programs include being used to execute the method according to any one of claims 1 to 6.

8. A non-transitory computer-readable storage medium, when instructions in the storage medium are executed by a processor of an electronic device, the electronic device is enabled to execute the method as claimed in any one of claims 1 to 6.

Images