Data source library table information detection method, device, server and medium

A detection method and database technology, applied in the database field, can solve problems such as complex operation and poor applicability

Inactive Publication Date: 2019-10-25
北京启迪区块链科技发展有限公司
View PDF4 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Existing change data capture is usually realized by the data source table structure detection tool, but the current data source table structure detection tool has a certain intrusiveness to the source database, and part of the configuration of the source database needs to be changed when performing data table structure detection. Complicated and less applicable

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
  • Data source library table information detection method, device, server and medium
  • Data source library table information detection method, device, server and medium
  • Data source library table information detection method, device, server and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0027] figure 1 It is a flow chart of a method for detecting data source database table information provided by Embodiment 1 of the present invention. This embodiment is applicable to the situation of detecting changed data source database table information. The method can be executed by the data source database table information detection device provided by the embodiment of the present invention, the device can be implemented in the form of hardware and / or software, and the device can be integrated in the server. see figure 1 , the method may specifically include:

[0028] S110. Acquire and store database table information of the target database to be detected from the target data source according to the connection information of the target data source.

[0029] Wherein, the data source refers to a database or a database server used by a database application program, and is used to provide a device or an original medium for some required data. The database is an electroni...

Embodiment 2

[0048] Figure 4 It is a flow chart of a data source library table information detection method provided by Embodiment 2 of the present invention. This embodiment is based on the above embodiments, and further obtains and stores the connection information from the target data source based on the target data source connection information. To explain the library table information of the target database to be detected, see figure 2 , the method may specifically include:

[0049] S210. Determine the target database to be detected according to the connection information of the target data source.

[0050] S220. Connect to the target database through the public access interface, acquire and store the library table information of the target database to be detected from the target data source.

[0051] Among them, the public access interface can provide a unified access interface for various databases, and can access different types of databases at the same time, which solves the p...

Embodiment 3

[0057] Figure 5 It is a schematic structural diagram of a data source database table information detection device provided in Embodiment 3 of the present invention, which can execute the data source database table information detection method provided in any embodiment of the present invention.

[0058] see Figure 5 , the device for detecting database table information of a data source in this embodiment includes: a database table information acquisition module 310 and a database table change information determination module 320 .

[0059] Wherein, the library table information acquiring module 310 is configured to acquire and store the library table information of the target database to be detected from the target data source according to the connection information of the target data source.

[0060] The database table change information determination module 320 is configured to acquire the database table information of the target database according to a preset period, and...

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 embodiment of the invention discloses a data source library table information detection method, a data source library table information detection device, a server and a medium. The method comprises the steps of obtaining and storing library table information of a target database needing to be detected from a target data source according to target data source connection information; and obtaining library table information of the target database according to a preset period, and comparing the library table information with stored library table information to determine library table change information. According to the technical method provided by the embodiment of the invention, the change information of the target database is detected only through the target data source connection information. A non-invasive data source library table information detection method is provided, and the detection steps are simplified.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of databases, and in particular, to a method, device, server and medium for detecting information of a database table of a data source. Background technique [0002] The database is the place where electronic files are stored. Users can add, intercept, update, and delete data in the files. Change data capture can record the relevant change information of the database, and provide convenience for users to access the changed database. [0003] Existing change data capture is usually realized by the data source table structure detection tool, but the current data source table structure detection tool has a certain intrusiveness to the source database, and part of the configuration of the source database needs to be changed when performing data table structure detection. Complicated and poor in applicability. Contents of the invention [0004] In view of this, the present invention p...

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): G06F16/21
CPCG06F16/217
Inventor 宁晨光周雷皓段炜
Owner 北京启迪区块链科技发展有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap