Sample data extraction method and device, equipment and medium

A sample and data technology, applied in the field of equipment and media, sample data extraction method, and device field, can solve the problems of high plug-in environment requirements, cumbersome process, and inability to guarantee full access to business databases, and achieves improved comprehensive access, Simplify access and achieve the effect of fast access

Pending Publication Date: 2021-12-03
RUN TECH CO LTD BEIJING
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] When using the existing technology to access and query various business databases, the requirements for the plug-in environment are relatively high. Different plug-in environments need to be installed for different types of business databases. The process is cumbersome and cannot guarantee full access to business databases.

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
  • Sample data extraction method and device, equipment and medium
  • Sample data extraction method and device, equipment and medium
  • Sample data extraction method and device, equipment and medium

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0021] figure 1 A schematic flowchart of a method for extracting sample data provided by an embodiment of the present invention, the method can be executed by a device for extracting sample data, wherein the device can be implemented by software and / or hardware, and generally can be integrated in computer equipment such as servers middle. Such as figure 1 As shown, the method includes:

[0022] S110. Test the connectivity of the database to be extracted according to the connected connection information of the database to be extracted.

[0023] The database to be extracted can be understood as a business database that needs to be accessed. Wherein, the type of the business database may be: a relational database (MYSQL), an Oracle database (Oracle Database), or a Greenplum database, etc., and there is no limitation here, and generally the specific database type of the enterprise shall prevail.

[0024] Generally speaking, according to different needs, enterprises may need to...

Embodiment 2

[0042] The embodiment of the present invention is further optimized on the basis of the above-mentioned embodiments, optimizing the step of testing the connectivity of the database to be extracted according to the connection information of the database to be extracted, including: according to the database to be extracted The accessed network address information and account information access the database to be extracted; if the access is successful, it is determined that the database to be extracted is connected; if the access fails, it is determined that the database to be extracted is not connected. The advantage of this setting is that the connectivity of the database to be extracted is tested through the network address information and account information, and the operation is simple.

[0043] The step of extracting corresponding sample data from the database to be extracted according to the preset extraction conditions is also optimized, including: determining the target s...

Embodiment 3

[0080] image 3 Provide a structural block diagram of a device for extracting sample data for the embodiment of the present invention. The device can be implemented by software and / or hardware, and generally can be integrated in computer equipment such as servers. The database is accessed to realize the extraction operation of sample data. Such as image 3 As shown, the device includes: a connectivity test module 31 and a sample data extraction module 32, wherein:

[0081] A connectivity testing module 31, configured to test the connectivity of the database to be extracted according to the connected connection information of the database to be extracted;

[0082] The sample data extraction module 32 is configured to extract corresponding sample data from the database to be extracted according to preset extraction conditions if the database to be extracted is connected.

[0083] The sample data extraction device provided in the embodiment of the present invention tests the c...

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 sample data extraction method and device, equipment and a medium. The method comprises the steps of testing connectivity of a to-be-extracted database according to accessed connection information of the to-be-extracted database; and if the to-be-extracted database is connected, extracting corresponding sample data from the to-be-extracted database according to a preset extraction condition. The corresponding connection information is accessed to each database in advance, so that the to-be-extracted database is communicated through the connection information, and corresponding access operation is further performed on the to-be-extracted database after the to-be-extracted database is communicated. By adopting the technical scheme, the purpose of simplifying access to the to-be-extracted database can be achieved, so that successful extraction of the sample data in the to-be-extracted database is achieved, the problem that when different types of to-be-extracted databases are accessed, plug-in environments consistent with the to-be-extracted databases need to be downloaded is solved, rapid access to the to-be-extracted databases is achieved, and comprehensive access of the business database is improved.

Description

technical field [0001] The embodiments of the present invention relate to the technical field of database access, and in particular to a sample data extraction method, device, equipment and medium. Background technique [0002] In practical applications, it is necessary to access different business databases to extract sample data from corresponding data in different business databases, and then display the extracted sample data on the visual interface in the form of data reports, so that enterprises The extracted sample data is targeted for analysis. [0003] In the prior art, when accessing and querying different business databases, corresponding plug-in environments need to be installed for accessing different business databases. Only when the usage environment is consistent can one or several same-type The corresponding access query operation of the business database. [0004] When using the existing technology to access and query various business databases, the requir...

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
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/25G06F21/62G06F21/31
CPCG06F16/254G06F21/6227G06F21/31G06F2221/2137
Inventor 刘冬谢永恒程强
Owner RUN TECH CO LTD BEIJING
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