Check patentability & draft patents in minutes with Patsnap Eureka AI!

Dblink monitoring method and system

A monitoring system and monitoring module technology, applied in the database field, can solve the problems of heavy workload, cumbersome operation, inability to understand the use and security of Dblink, etc., to reduce losses, ensure data security, and reduce professional ability requirements.

Inactive Publication Date: 2018-03-23
JIANGSU FRONTIER ELECTRIC TECH +2
View PDF5 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] The power system usually includes multiple business application systems. In order to save data, each business application system usually has a corresponding database. Due to the complex intersection between power services, databases need to frequently check data, while consulting other databases The data needs to use Dblink, but the existing technology cannot understand the usage and security of Dblink, the operation is very cumbersome and the workload is heavy

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
  • Dblink monitoring method and system
  • Dblink monitoring method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0041] In S1, JDBC drivers include: JDBC-ODBC bridge driver, JDBC-local driver, JDBC network driver and native protocol pure JDBC driver. Different JDBC drivers can be used to access different databases, and the specific access method can adopt existing technologies.

[0042] The Dblink obtained in S2 of the present invention is a Dblink whitelist corresponding to the target database to be queried, and its content can be set by the operation and maintenance personnel of the corresponding database.

[0043] In S3, by calling the Statement() interface of JDBC, the database to be queried is instantiated, and the executeQuery() method is executed to obtain the return value of sql on Dblink, which is the Dblink information. The Statement interface is used to send simple SQL statements without parameters to the database based on the established database connection. executeQuery is one of the methods for executing SQL statements provided by the Statement interface, which is used to gener...

Embodiment 2

[0047] In the Dblink monitoring method of this embodiment, S3 further includes: setting a Dblink blacklist corresponding to different databases to be accessed, judging whether the suspected illegal Dblink is included in the Dblink blacklist, if it is, the monitoring is ended, and the alarm information is output; Step S4;

[0048] In S4, for Dblink that is still not allowed to access the database to be queried in consideration of actual application needs, the corresponding Dblink is added to the blacklist. For some illegal Dblink, the blacklist simplifies the identification and judgment process, which can reduce the data redundancy during Dblink monitoring and alarm processing.

Embodiment 3

[0050] A Dblink monitoring system includes:

[0051] The database connection establishment module establishes a connection with the database to be queried through the JDBC driver to obtain Dblink information;

[0052] Database connection whitelist obtaining module, to obtain the Dblink whitelist of the database to be queried;

[0053] The Dblink monitoring module determines whether the currently obtained Dblink is included in the Dblink whitelist, if it is, the monitoring is ended, if otherwise, the current Dblink is set as a suspected illegal Dblink, the access permission of the Dblink is closed, and an alarm message is generated;

[0054] The alarm processing module, for the Dblink corresponding to the alarm information, determines whether it is allowed to access the database to be queried due to actual application needs. If it is not allowed, the corresponding Dblink is defined as an illegal access link, the alarm information is output, and the monitoring ends. The corresponding Db...

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 invention discloses a Dblink-based monitoring method and system. The monitoring method comprises the following steps of: establishing connection with a to-be-queried database through JDBC driving;calling a corresponding JDBC interface to obtain Dblink information; monitoring Dblinks of the to-be-queried database on the basis of a Dblink whitelist of the to-be-queried database; judging whetherthe current Dblink is in a whitelist of a target database or not; and for the Dblinks not in the whitelist, carrying out operations such as alarm and Dblink link disconnection. According to the method and system, the safety of the target database is ensured, and the workers can conveniently monitor each piece of data in power systems so as to ensure the data safety of the databases.

Description

Technical field [0001] The invention relates to the field of database technology, in particular to a Dblink monitoring method and monitoring system. Background technique [0002] Electric power systems usually include multiple business application systems. In order to store data in each business application system, there is usually a corresponding database. Due to the complex intersection between power services, databases need to frequently consult data and consult other databases The data needs to use Dblink, but the existing technology cannot understand the usage and safety of Dblink, and the operation is very cumbersome and the workload is heavy. [0003] Glossary [0004] Dblink (Database Link), the link to the database. [0005] JDBC (Java DataBase Connectivity), java database connection, is a Java API used to execute SQL statements and can provide unified access to a variety of relational databases. It consists of a set of classes and interfaces written in Java language. JDBC ...

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): G06F21/62G06F17/30
CPCG06F21/6227G06F2221/2141G06F16/2471
Inventor 潘雨晴任禹丞李叶飞葛崇慧张欣
Owner JIANGSU FRONTIER ELECTRIC TECH
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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