Plug-in implementation method for database data export tool

A technology of data export and implementation method, applied in database management system, structured data retrieval, electronic digital data processing and other directions, can solve the problem of unable to support different source databases at the same time, achieve the effect of low cost and avoid cumbersome steps

Active Publication Date: 2021-07-23
SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
View PDF13 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Most of these commonly used export tools are integrated in the management system of a certain database, and are customized for the export operation of a certain database, and cannot support different source databases at the same time.

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
  • Plug-in implementation method for database data export tool
  • Plug-in implementation method for database data export tool
  • Plug-in implementation method for database data export tool

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0045] A plug-in implementation method of a database data export tool, the specific steps of the method are as follows:

[0046] S1 uses the driver management system to maintain the driver plug-in of the database, and provides upload, update and download plug-in services;

[0047] S2 uses the template management system to maintain and export template plug-ins, and provides services for uploading, updating and downloading plug-ins;

[0048] S3 uses the terminal export tool to load the driver plug-in and template plug-in to export the data of the database;

[0049] The invention relates to a plug-in implementation method of a database data export tool, which includes three parts: a driver management system, a template management system and a terminal export tool, wherein the driver management system and the template management system are managed by the first inventor in a unified manner, independent As a terminal export tool, it mainly provides customized development of plug-in...

Embodiment 2

[0064] On the basis of Embodiment 1, the S2 uses the template management system to maintain the export template plug-ins developed for different platforms, and the specific steps of providing services for uploading, updating and downloading plug-ins are as follows:

[0065] S201 stores the template plug-in provided by the driver management system in a localized manner;

[0066] S202 connects the development template plug-in to the unified interface of the export template;

[0067] S203 obtains the storage address of the template according to the url_header, and downloads the template plug-in;

[0068] First, according to S201, the template plug-in provided by the driver management system is stored in a localized manner through the Mysql database, and then according to S202, the template plug-in provided by the template management system is developed by the developer to access the unified interface of the export tool template, and the driver plug-in is completed Development, f...

Embodiment 3

[0077] On the basis of embodiment one or two, described S3 utilizes terminal to export tool to load the corresponding drive plug-in of different database sources and template plug-in to export the data of this database, concrete steps are as follows:

[0078] S301 defines Driver, DriverFactory interface and Template, TemplateFactory interface;

[0079] S302 stores the driver plug-in in the driver directory, and stores the backup template plug-in in the template directory;

[0080] S303 exports command parameters, analyzes the input command, and the terminal export tool completes the loading of the corresponding database driver plug-in and template plug-in;

[0081] S304 The internal executor of the terminal export tool calls the Template instance to complete the export work according to the built-in execution process;

[0082] First, the terminal export tool defines the Driver and DriverFactory interfaces that need to be implemented by the driver plug-in and the Template 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 invention discloses a plug-in implementation method for a database data export tool, and belongs to the field of computer software databases. The method comprises the following specific steps: S1, maintaining a drive program plug-in of a database by utilizing a drive management system, and providing plug-in uploading, updating and downloading services; s2, using a template management system to maintain and export a template plug-in, and providing services of uploading, updating and downloading the plug-in; s3, loading the driving plug-in and the template plug-in by using a terminal export tool to export the data of the database; by applying the method, a database exporting tool with the characteristics of high efficiency, low cost and light weight can be realized. Meanwhile, the tool can meet the data exporting requirement of the multi-source database and has the characteristics of high compatibility and flexible configuration, and tedious steps during exporting operation of the multi-source database are avoided.

Description

technical field [0001] The invention discloses a plug-in realization method of a database data export tool, and relates to the technical field of computer software databases. Background technique [0002] In the field of database application development and daily operation and maintenance, data export is a problem that development and operation and maintenance personnel often face when performing data migration and data analysis. With the rise of big data technology, the amount of data in applications has increased tremendously, and how to effectively export data from different source databases has become an urgent problem in the database field. Existing export tools, such as Dumpling, which is optimized for some features of TiDB, currently support MySQL protocol databases, but do not support exporting multiple database sources; Mydumper is a multi-threaded backup and recovery tool for MySQL and Drizzle; the same type The export tool also includes pg_dump, which can extract...

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/25G06F9/445G06F8/30G06F8/65G06F8/70
CPCG06F16/252G06F9/44526G06F8/30G06F8/65G06F8/70
Inventor 杨臣高庆安江磊石梦飞徐扬鲍之骁刘文硕陈磊
Owner SHANDONG LANGCHAO YUNTOU INFORMATION TECH CO LTD
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