Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Dynamic monitoring system and method for data base list update

A dynamic monitoring and database technology, applied in hardware monitoring, electrical digital data processing, special data processing applications, etc., can solve problems such as notification difficulties, and achieve the effect of simple and reliable real-time monitoring strategies

Active Publication Date: 2005-09-28
SHANGHAI BAOSIGHT SOFTWARE CO LTD
View PDF0 Cites 35 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, it is very difficult to realize real-time notification between the application system and the database system

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Dynamic monitoring system and method for data base list update

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0028] figure 1 It describes a complete class that can be encapsulated. The encapsulated class can work independently and provide real-time notifications of database table updates to the client system. Based on the subclass, a dynamic data application system can be built. In this system, the data of the database is real-time for customers.

[0029] Here, the database we use is MICROSOFT SQL SERVER 2000, and the development system uses MICROSOFT VISUAL BAISIC.NET.

[0030] Such as figure 1 The system shown includes:

[0031] Monitoring table 1, which stores the table names of all user tables and their life signs;

[0032] Monitoring trigger 2, which will intercept any update of the user table and maintain the table life identifier of the corresponding record in the monitoring table. This trigger corresponds to the user table one by one, and can intercept the insertion, update, and deletion of the corresponding user table operate;

[0033] Monitoring table backup 3, the sys...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The dynamic monitoring system for updated data base list includes monitoring list for storing the names and life signs of all the user lists; monitoring trigger corresponding to the user lists one by one for intercepting the insertion, updating and deletion operations of user lists; monitoring list backup in the application part of the system; monitoring module accessing the monitoring list via data base connector to obtain the life signs of the user lists and compare the obtained life signs with those in the backup for finding altering; and issuing interface to output real-time data base list updating information. The present invention solves the technological problem of providing dynamic monitoring system and method for updated data base list.

Description

technical field [0001] The invention relates to a dynamic monitoring system and method for updating database tables Background technique [0002] In a large-scale client-server application system, many clients and background services often work together to complete a set of related system tasks based on the same database. Due to the existence of multiple clients, any client may access and operate the same group of database resources, even if the group access permissions are set. However, due to the lack of a dynamic database update notification mechanism, it is impossible for a client to know whether the relevant database resources have been changed by other clients before performing its own operations, unless manual forced updates are performed in advance, so the operation transactions submitted Often ends in failure. [0003] A typical example is the book lending system of a large library. When we submit through the system and successfully get an inquiry list of unborro...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F11/30G06F17/30
Inventor 卫万勇
Owner SHANGHAI BAOSIGHT SOFTWARE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com