CN110515807B - Database table monitoring method, device, equipment and storage medium - Google Patents
Database table monitoring method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN110515807B CN110515807B CN201910824194.XA CN201910824194A CN110515807B CN 110515807 B CN110515807 B CN 110515807B CN 201910824194 A CN201910824194 A CN 201910824194A CN 110515807 B CN110515807 B CN 110515807B
- Authority
- CN
- China
- Prior art keywords
- database table
- monitoring
- rule
- configuration file
- monitored
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3003—Monitoring arrangements specially adapted to the computing system or computing system component being monitored
- G06F11/302—Monitoring arrangements specially adapted to the computing system or computing system component being monitored where the computing system component is a software system
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computing Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Mathematical Physics (AREA)
- Quality & Reliability (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention discloses a database table monitoring method, a device, equipment and a storage medium. The database table monitoring method comprises the following steps: acquiring a monitoring updating rule, wherein the monitoring updating rule is used for updating a current database table to be monitored; determining an updated target database table according to the monitoring updating rule; and monitoring the target database table. The embodiment of the invention determines the updated target database table to be monitored based on the monitoring updating rule, and monitors the updated target database table. The operation is realized in the monitoring operation process, namely the database table to be monitored can be dynamically changed in the monitoring process, and the updated database table is monitored after the change is finished, so that the dynamic monitoring of the database table is realized, and the monitoring efficiency is improved.
Description
Technical Field
The embodiment of the invention relates to the technical field of computers, in particular to a database table monitoring method, a database table monitoring device, database table monitoring equipment and a database table storage medium.
Background
The database table is a data set which is stored together in a certain mode, can be shared with a plurality of users, has the smallest redundancy and is independent of the application program, and the users can perform operations such as adding, inquiring, updating, deleting and the like on the data in the file. With the increase of data volume, database tables in the data source are also continuously increased and changed, so that users need to continuously update and inquire the monitored database tables so as to know the change content of the monitored database tables in time.
The existing method for acquiring the change data in the database table is to manually execute SQL sentences, realize the query of the target database table structure through the SQL sentences, and acquire the change data information through the query result.
However, the manual query method causes the problems of large manpower resource consumption and low query efficiency when a large number of database tables of different types need to be monitored; in the monitoring operation process, a large number of database tables of different types need to be checked one by one, and the database tables cannot be queried quickly, so that the discovery of changed data is not timely.
Disclosure of Invention
The embodiment of the invention provides a database table monitoring method, a device, equipment and a storage medium, which are used for improving the monitoring efficiency of a database table.
In a first aspect, an embodiment of the present invention provides a method for monitoring a database table, including:
acquiring a monitoring updating rule, wherein the monitoring updating rule is used for updating a current database table to be monitored;
determining an updated target database table according to the monitoring updating rule;
and monitoring the target database table.
Optionally, the monitoring update rule includes adding and/or deleting a database table name as a monitoring object and/or an updated database table filtering rule.
Optionally, the monitoring the target database table includes:
and monitoring the data information of the target database table at fixed time, and determining the update information of the target database table according to the comparison results of the data information at different moments.
Optionally, before the acquiring the monitoring update rule, the method further includes:
acquiring a configuration file of a database table to obtain initialization configuration information;
and obtaining the current database table to be monitored according to the initialization configuration information.
Optionally, the configuration file at least includes a filtering condition for the access data source, where the filtering condition for the access data source is used to obtain an initial monitoring database table.
In a second aspect, an embodiment of the present invention further provides a database table monitoring apparatus, including:
the monitoring updating rule acquisition module is used for acquiring a monitoring updating rule, wherein the monitoring updating rule is used for updating a current database table to be monitored;
the target database table determining module is used for determining an updated target database table according to the monitoring updating rule;
and the target database table monitoring module is used for monitoring the target database table.
Optionally, the monitoring update rule includes adding and/or deleting a database table name as a monitoring object and/or an updated database table filtering rule.
Optionally, the target database table monitoring module is specifically configured to:
and monitoring the data information of the target database table at fixed time, and determining the update information of the target database table according to the comparison results of the data information at different moments.
Optionally, before the monitoring update rule obtaining module, the apparatus further includes a configuration file obtaining module, specifically configured to:
acquiring a configuration file of a database table to obtain initialization configuration information;
and obtaining the current database table to be monitored according to the initialization configuration information.
Optionally, the configuration file at least includes a filtering condition for the access data source, where the filtering condition for the access data source is used to obtain an initial monitoring database table.
In a third aspect, an embodiment of the present invention further provides a computer apparatus, including:
one or more processors;
storage means for storing one or more programs,
the one or more programs, when executed by the one or more processors, cause the one or more processors to implement a database table monitoring method according to any of the embodiments of the present invention.
In a fourth aspect, embodiments of the present invention further provide a computer readable storage medium having stored thereon a computer program which, when executed by a processor, implements a database table monitoring method according to any of the embodiments of the present invention.
The embodiment of the invention determines the updated target database table to be monitored based on the monitoring updating rule, and monitors the updated target database table. The operation is realized in the monitoring operation process, namely the database table to be monitored can be dynamically changed in the monitoring process, and the updated database table is monitored after the change is finished, so that the dynamic monitoring of the database table is realized, and the monitoring efficiency is improved.
Drawings
FIG. 1 is a flowchart of a database table monitoring method in accordance with a first embodiment of the present invention;
FIG. 2 is a flowchart of a database table monitoring method in a second embodiment of the present invention;
FIG. 3 is a schematic diagram of a database table monitoring device according to a third embodiment of the present invention;
fig. 4 is a schematic structural diagram of a computer device in a fourth embodiment of the present invention.
Detailed Description
The invention is described in further detail below with reference to the drawings and examples. It is to be understood that the specific embodiments described herein are merely illustrative of the invention and are not limiting thereof. It should be further noted that, for convenience of description, only some, but not all of the structures related to the present invention are shown in the drawings.
Fig. 1 is a flowchart of a database table monitoring method according to a first embodiment of the present invention, where the present embodiment is applicable to a case of querying a changed database table when the database table is changed in a database table monitoring scenario. The method may be performed by a database table monitoring apparatus, which may be implemented in software and/or hardware, and may be configured in a computer device, such as a background server, for example, having communication and computing capabilities. As shown in fig. 1, the method specifically includes:
s101, acquiring a monitoring updating rule, wherein the monitoring updating rule is used for updating a current database table to be monitored.
The monitoring update rule refers to a request for modifying a database table as a monitoring object in the process of monitoring the database table. Optionally, the monitoring update rule includes adding and/or deleting a database table name as a monitoring object and/or an updated database table filtering rule. Specifically, during the monitoring operation of the database table, the monitored database table may be modified, including: and adding the names of the database tables to be monitored on the basis of the monitored current database table, and/or deleting part of the database tables in the current database table, and/or updating the filtering rules of the current database table, wherein the filtering rules refer to screening conditions of monitoring access data sources, and the database tables to be monitored are screened from the access data sources according to the monitoring requirements of users.
For example, in monitoring weather conditions, the data sources that can be accessed include a China weather data source, an American weather data source, etc., which includes weather database tables for each province. If the filtering rule of the current database table is a weather database table of a southern city in China, the monitoring updating rule can be to add a new weather database table of a city to be monitored on the basis of the current database table, or delete a database table of a designated city in the current database table, or modify the weather database table of the southern city in China monitored by the current filtering rule into a weather database table of a northern city in China monitored.
S102, determining an updated target database table according to the monitoring updating rule.
Wherein the updated target database table refers to a new database table to be monitored after the current database table is modified in response to the monitoring update rule. Optionally, in the case that the monitoring update rule includes adding and/or deleting a database table name as a monitoring object and/or an updated database table filtering rule, the updated target database table includes adding a target database table with a new database table name to be monitored, and/or deleting a target database table with a database table name not to be monitored, and/or obtaining a new target database table according to the new filtering rule.
For example, in the above example, the updated target database table refers to: 1) The monitoring updating rule is that when a new city weather database table to be monitored is added on the basis of the current database table, the updated target database table is the weather database of the southern city in China plus the weather database table of the newly added city; 2) The monitoring updating rule is that when deleting the database table of the appointed city in the current database table, the updated target database table is a meteorological database table of which the appointed city is deleted in the south China city; 3) The monitoring updating rule is that when the weather database table of the current filtering rule for monitoring the urban in the south of China is modified into the weather database table for monitoring the urban in the north of China, the updated target database table is the weather database table of the urban in the north of China.
S103, monitoring the target database table.
And monitoring the target database table when the updated target database table is determined. Monitoring refers to querying data in the target database table, and optionally, monitoring may include querying the target database table for the presence of changed data.
Optionally, the monitoring the target database table includes: and monitoring the data information of the target database table at fixed time, and determining the update information of the target database table according to the comparison results of the data information at different moments. Specifically, a time threshold is preset, for example, one minute, after the time threshold is reached, the target database table is continuously queried to obtain the data information of the target database table, the data information of different moments before and after the time threshold is compared, if the data information of the target database table is changed, a change notification is sent, and if the data information of the target database table is not changed, no information is sent, and monitoring and comparison are continued.
For example, when a database table name is newly added in the target database table, the data information obtained by the first query of the newly added database table is stored, the next time threshold is reached, the data information obtained by the second query is obtained, the second data information is compared with the first data information, and whether the update exists or not is checked. And for the newly added database table to be monitored, the change notification is not sent when the data information queried for the first time is received, but is compared with the data information queried for the second time, if the data information queried for the second time is changed, the change notification is sent, and if the data information queried for the second time is not changed, the monitoring is continued.
According to the embodiment of the invention, the monitored database table is updated in the monitoring operation process, and then the modified database table is continuously monitored, so that the monitoring requirement of a user, which is continuously changed in the monitoring process, can be met; in addition, the data information in the target database table can be monitored regularly, and when the information in the target database table is changed, a change notification is sent to inform a user, so that the user can find the database table with changed data information in time, the changed database table is reacted, and the query efficiency of the user is improved.
Example two
Fig. 2 is a flowchart of a database table monitoring method in a second embodiment of the present invention, which is further optimized based on the first embodiment. As shown in fig. 2, the method includes:
s201, acquiring a configuration file of a database table to obtain initialization configuration information.
The configuration file refers to an initial filtering rule for accessing the data source, and an initial database table to be monitored can be obtained according to the configuration file. Initializing configuration information refers to filtering rules for accessing a data source readable by a program after processing a configuration file. Illustratively, the configuration file includes the names of the filtering rules for accessing the data source or the database tables to be monitored, which are stored in text form, and the configuration information refers to converting the text format of the configuration file into a format recognizable by the program, for example, into an SQL language format.
Specifically, the configuration file is an initial setting of the access data source when the monitoring service is started, and the configuration file is still responded after the service is restarted; the configuration information is obtained according to the configuration file, and is stored in the memory, and the configuration information is modified when the monitoring rule is updated in the monitoring process, so that the configuration file is consistent. Because the requirements of the users for each monitoring are different, the initial configuration file is kept unchanged, so that the users can conveniently update the monitoring rules and monitor the initial monitoring database table, the new monitoring service is ensured not to be influenced by modification of the monitoring rules in the last monitoring service process, and the consistency of the initial monitoring conditions is ensured.
S202, obtaining an initial monitoring database table to be monitored according to the initialization configuration information.
The initial monitoring database table refers to an initial name of the database table which is obtained according to the initial configuration information and is required to be monitored after the monitoring service is started.
S203, acquiring a monitoring updating rule, wherein the monitoring updating rule is used for updating a current database table to be monitored.
S204, determining an updated target database table according to the monitoring updating rule.
S205, monitoring the target database table.
The monitoring means that the target database table is continuously inquired, and the types of the target database table are different, so that the corresponding inquiry sentences are different.
The embodiment of the invention introduces a schema crawler framework, and the framework can grab the corresponding database table according to the configuration information and provide corresponding query sentences to query the target database table.
The embodiment of the invention responds to the modification of the monitoring database table in the monitoring process on the basis of the initial configuration information, thereby realizing the dynamic change of the target database table to be monitored; in the monitoring service, after the monitoring service is restarted, the monitored information is still obtained from the configuration file, so that the independence of each monitoring service is ensured, and the modification efficiency of a user for different monitoring requirements is improved; in addition, the automatic query of different types of database tables is realized, and then the monitoring efficiency of the target database tables is improved.
Example III
Fig. 3 is a schematic structural diagram of a database table monitoring device in a third embodiment of the present invention, which is applicable to the dynamic monitoring of database tables. As shown in fig. 3, the apparatus includes:
a monitoring update rule obtaining module 310, configured to obtain a monitoring update rule, where the monitoring update rule is used to update a current database table to be monitored;
a target database table determining module 320, configured to determine an updated target database table according to the monitoring update rule;
and the target database table monitoring module 330 is configured to monitor the target database table.
The embodiment of the invention determines the updated target database table to be monitored based on the monitoring updating rule, and monitors the updated target database table. The operation is realized in the monitoring operation process, namely the database table to be monitored can be dynamically changed in the monitoring process, and the updated database table is monitored after the change is finished, so that the dynamic monitoring of the database table is realized, and the monitoring efficiency is improved.
Optionally, the monitoring update rule includes adding and/or deleting a database table name as a monitoring object and/or an updated database table filtering rule.
Optionally, the target database table monitoring module is specifically configured to:
and monitoring the data information of the target database table at fixed time, and determining the update information of the target database table according to the comparison results of the data information at different moments.
Optionally, before the monitoring update rule obtaining module, the apparatus further includes a configuration file obtaining module, specifically configured to:
acquiring a configuration file of a database table to obtain initialization configuration information;
and obtaining an initial monitoring database table to be monitored according to the initialization configuration information.
Optionally, the configuration file at least includes a filtering condition for the access data source, where the filtering condition for the access data source is used to obtain an initial monitoring database table.
The database table monitoring device provided by the embodiment of the invention can execute the database table monitoring method provided by any embodiment of the invention, and has the corresponding functional modules and beneficial effects of executing the database table monitoring method.
Example IV
Fig. 4 is a schematic structural diagram of a computer device according to a fourth embodiment of the present invention. Fig. 4 illustrates a block diagram of an exemplary computer device 12 suitable for use in implementing embodiments of the present invention. The computer device 12 shown in fig. 4 is merely an example and should not be construed as limiting the functionality and scope of use of embodiments of the present invention.
As shown in FIG. 4, the computer device 12 is in the form of a general purpose computing device. Components of computer device 12 may include, but are not limited to: one or more processors or processing units 16, a system memory 28, a bus 18 that connects the various system components, including the system memory 28 and the processing units 16.
The system memory 28 may include computer system readable media in the form of volatile memory, such as Random Access Memory (RAM) 30 and/or cache memory 32. The computer device 12 may further include other removable/non-removable, volatile/nonvolatile computer system storage media. By way of example only, storage system 34 may be used to read from or write to non-removable, nonvolatile magnetic media (not shown in FIG. 4, commonly referred to as a "hard disk drive"). Although not shown in fig. 4, a magnetic disk drive for reading from and writing to a removable non-volatile magnetic disk (e.g., a "floppy disk"), and an optical disk drive for reading from or writing to a removable non-volatile optical disk (e.g., a CD-ROM, DVD-ROM, or other optical media) may be provided. In such cases, each drive may be coupled to bus 18 through one or more data medium interfaces. Memory 28 may include at least one program product having a set (e.g., at least one) of program modules configured to carry out the functions of embodiments of the invention.
A program/utility 40 having a set (at least one) of program modules 42 may be stored in, for example, memory 28, such program modules 42 including, but not limited to, an operating system, one or more application programs, other program modules, and program data, each or some combination of which may include an implementation of a network environment. Program modules 42 generally perform the functions and/or methods of the embodiments described herein.
The computer device 12 may also communicate with one or more external devices 14 (e.g., keyboard, pointing device, display 24, etc.), one or more devices that enable a user to interact with the computer device 12, and/or any devices (e.g., network card, modem, etc.) that enable the computer device 12 to communicate with one or more other computing devices. Such communication may occur through an input/output (I/O) interface 22. Moreover, computer device 12 may also communicate with one or more networks such as a Local Area Network (LAN), a Wide Area Network (WAN) and/or a public network, such as the Internet, through network adapter 20. As shown, network adapter 20 communicates with other modules of computer device 12 via bus 18. It should be appreciated that although not shown, other hardware and/or software modules may be used in connection with computer device 12, including, but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, data backup storage systems, and the like.
The processing unit 16 executes various functional applications and data processing by running programs stored in the system memory 28, for example, implementing a database table monitoring method provided by an embodiment of the present invention, including:
acquiring a monitoring updating rule, wherein the monitoring updating rule is used for updating a current database table to be monitored;
determining an updated target database table according to the monitoring updating rule;
and monitoring the target database table.
Example five
The fifth embodiment of the present invention further provides a computer readable storage medium having a computer program stored thereon, the program when executed by a processor implementing a database table monitoring method as provided in the fifth embodiment of the present invention, including:
acquiring a monitoring updating rule, wherein the monitoring updating rule is used for updating a current database table to be monitored;
determining an updated target database table according to the monitoring updating rule;
and monitoring the target database table.
The computer storage media of embodiments of the invention may take the form of any combination of one or more computer-readable media. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples (a non-exhaustive list) of the computer-readable storage medium would include the following: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device.
The computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, either in baseband or as part of a carrier wave. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device.
Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
Computer program code for carrying out operations of the present invention may be written in any combination of one or more programming languages, including an object oriented programming language such as Java, smalltalk, C ++ and conventional procedural programming languages, such as the "C" programming language or similar programming languages. The program code may execute entirely on the user's computer, partly on the user's computer, as a stand-alone software package, partly on the user's computer and partly on a remote computer or entirely on the remote computer or server. In the case of a remote computer, the remote computer may be connected to the user's computer through any kind of network, including a Local Area Network (LAN) or a Wide Area Network (WAN), or may be connected to an external computer (for example, through the Internet using an Internet service provider).
Note that the above is only a preferred embodiment of the present invention and the technical principle applied. It will be understood by those skilled in the art that the present invention is not limited to the particular embodiments described herein, but is capable of various obvious changes, rearrangements and substitutions as will now become apparent to those skilled in the art without departing from the scope of the invention. Therefore, while the invention has been described in connection with the above embodiments, the invention is not limited to the embodiments, but may be embodied in many other equivalent forms without departing from the spirit or scope of the invention, which is set forth in the following claims.
Claims (8)
1. A method for monitoring a database table, comprising:
acquiring a monitoring updating rule, wherein the monitoring updating rule is used for updating a current database table to be monitored;
determining an updated target database table according to the monitoring updating rule;
monitoring the target database table;
before the acquiring the monitoring update rule, the method further comprises:
acquiring a configuration file of a database table to obtain initialization configuration information;
according to the initialization configuration information, an initial monitoring database table needing to be monitored is obtained;
the configuration file at least comprises filtering conditions for the access data sources, wherein the filtering conditions for the access data sources are used for acquiring an initial monitoring database table;
the configuration file refers to an initial filtering rule for accessing the data source, and an initial database table to be monitored is obtained according to the configuration file; initializing configuration information, namely processing a configuration file and then performing a program-readable filtering rule on an access data source; the configuration file comprises the names of filtering rules of access data sources or database tables to be monitored, which are stored in a text form, the configuration information is converted into SQL language format which can be identified by programs, the configuration information is obtained according to the configuration file, the configuration information is stored in a memory, the configuration information is modified when the monitoring rules are updated in the monitoring process, and the configuration file is kept consistent.
2. The method according to claim 1, wherein the monitoring update rule includes adding and/or deleting a database table name as a monitoring object and/or an updated database table filtering rule.
3. The method of claim 1, wherein the monitoring the target database table comprises:
and monitoring the data information of the target database table at fixed time, and determining the update information of the target database table according to the comparison results of the data information at different moments.
4. A database table monitoring apparatus, comprising:
the monitoring updating rule acquisition module is used for acquiring a monitoring updating rule, wherein the monitoring updating rule is used for updating a current database table to be monitored;
the target database table determining module is used for determining an updated target database table according to the monitoring updating rule;
the target database table monitoring module is used for monitoring the target database table;
before the monitoring update rule obtaining module, the device further includes a configuration file obtaining module, configured to:
acquiring a configuration file of a database table to obtain initialization configuration information; obtaining a current database table to be monitored according to the initialization configuration information; the configuration file at least comprises filtering conditions for the access data sources, wherein the filtering conditions for the access data sources are used for acquiring an initial monitoring database table; the configuration file refers to an initial filtering rule for accessing the data source, and an initial database table to be monitored is obtained according to the configuration file; initializing configuration information, namely processing a configuration file and then performing a program-readable filtering rule on an access data source; the configuration file comprises the names of filtering rules of access data sources or database tables to be monitored, which are stored in a text form, the configuration information is converted into SQL language format which can be identified by programs, the configuration information is obtained according to the configuration file, the configuration information is stored in a memory, the configuration information is modified when the monitoring rules are updated in the monitoring process, and the configuration file is kept consistent.
5. The apparatus according to claim 4, wherein the monitoring update rule includes a database table name and/or an updated database table filtering rule which are objects of monitoring.
6. The device according to claim 4, wherein the target database table monitoring module is specifically configured to:
and monitoring the data information of the target database table at fixed time, and determining the update information of the target database table according to the comparison results of the data information at different moments.
7. A computer device, the device comprising:
one or more processors;
storage means for storing one or more programs,
the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the database table monitoring method of any of claims 1-3.
8. A storage medium containing computer executable instructions which, when executed by a computer processor, are for performing the database table monitoring method of any of claims 1-3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910824194.XA CN110515807B (en) | 2019-09-02 | 2019-09-02 | Database table monitoring method, device, equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910824194.XA CN110515807B (en) | 2019-09-02 | 2019-09-02 | Database table monitoring method, device, equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110515807A CN110515807A (en) | 2019-11-29 |
| CN110515807B true CN110515807B (en) | 2023-07-14 |
Family
ID=68630495
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910824194.XA Active CN110515807B (en) | 2019-09-02 | 2019-09-02 | Database table monitoring method, device, equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110515807B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111162995A (en) * | 2019-12-26 | 2020-05-15 | 苏州浪潮智能科技有限公司 | Data change notification method, device, equipment and readable storage medium |
Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108874964A (en) * | 2018-06-07 | 2018-11-23 | 火烈鸟网络(广州)股份有限公司 | A kind of method and system in monitoring data library |
Family Cites Families (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6738757B1 (en) * | 1999-06-02 | 2004-05-18 | Workwise, Inc. | System for database monitoring and agent implementation |
| CN100359482C (en) * | 2004-08-04 | 2008-01-02 | 上海宝信软件股份有限公司 | Dynamic monitoring system and method for data base list update |
| US8818944B2 (en) * | 2011-06-30 | 2014-08-26 | Microsoft Corporation | Data change tracking and event notification |
| CN105335527A (en) * | 2015-12-04 | 2016-02-17 | 浪潮(北京)电子信息产业有限公司 | Method and system for monitoring database operation |
| CN109857720B (en) * | 2018-12-20 | 2024-02-02 | 中国平安人寿保险股份有限公司 | Database table monitoring method, device, computer device and readable storage medium |
| CN109933601A (en) * | 2019-01-24 | 2019-06-25 | 深圳壹账通智能科技有限公司 | Data base management method, system, computer installation and readable storage medium storing program for executing |
-
2019
- 2019-09-02 CN CN201910824194.XA patent/CN110515807B/en active Active
Patent Citations (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108874964A (en) * | 2018-06-07 | 2018-11-23 | 火烈鸟网络(广州)股份有限公司 | A kind of method and system in monitoring data library |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110515807A (en) | 2019-11-29 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9244999B2 (en) | Database query using a user-defined function | |
| WO2023109138A1 (en) | Method and apparatus for starting android application in linux system, and electronic device | |
| CN111949710B (en) | Data storage method, device, server and storage medium | |
| CN109194736B (en) | Message duplicate removal method and device, electronic equipment, medium and unmanned vehicle | |
| CN111198859B (en) | Data processing method, device, electronic equipment and computer readable storage medium | |
| US11256773B2 (en) | Document online preview method and device | |
| CN111709527A (en) | Operation and maintenance knowledge map library establishing method, device, equipment and storage medium | |
| CN110263277B (en) | Page data display method, page data updating device, page data equipment and storage medium | |
| US20080104080A1 (en) | Method and apparatus to access heterogeneous configuration management database repositories | |
| CN111432000A (en) | Control method, device, equipment and storage medium of Internet of things equipment | |
| CN109284108B (en) | Unmanned vehicle data storage method and device, electronic equipment and storage medium | |
| CN109857723B (en) | Dynamic data migration method based on expandable database cluster and related equipment | |
| CN111818145B (en) | File transmission method, device, system, equipment and storage medium | |
| CN110975293A (en) | Method, device, server and medium for establishing resource reference relation table | |
| CN109241100B (en) | Query method, device, equipment and storage medium | |
| CN111506603B (en) | Data processing method, device, equipment and storage medium | |
| CN110929128A (en) | Data crawling method, device, equipment and medium | |
| CN113468128A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN109033456B (en) | Condition query method and device, electronic equipment and storage medium | |
| CN109473178B (en) | Method, system, device and storage medium for medical data integration | |
| CN110515807B (en) | Database table monitoring method, device, equipment and storage medium | |
| CN114265966A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN110825802A (en) | Multi-type database data backup method, device, equipment and storage medium | |
| CN117609211A (en) | Data consistency comparison method, device, electronic equipment and storage medium | |
| CN112487025A (en) | Data query method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |