Background database configuration based data downloading method and system

A data download and database technology, applied in the network field, can solve problems such as low efficiency and error-prone efficiency, and achieve the effects of simple development, good maintainability, and simple and flexible configuration process

Active Publication Date: 2016-10-12
北京思特奇信息技术股份有限公司
View PDF5 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The present invention provides a method and system for downloading data based on background database configuration, which solves the technical problems of error-prone and low efficiency in the prior art when the database is maintained manually

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
  • Background database configuration based data downloading method and system
  • Background database configuration based data downloading method and system
  • Background database configuration based data downloading method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0043] The principles and features of the present invention are described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.

[0044] Such as figure 1 As shown, it is a schematic flow diagram of a method for data download based on background database configuration of the present invention, including the following steps:

[0045] Step 1: Design a configuration table template according to business requirements, and the configuration table template includes an audit configuration table, a scheduling configuration table and / or a file attribute table.

[0046] Step 2, according to the data model of the background database, fill in the configuration table template to form a configuration table. Table 1 below is an audit configuration table of an embodiment, Table 2 is a file attribute table of an embodiment, and Table 3 is a scheduling configura...

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 relates to the technical field of networks, and particularly relates to a background database configuration based data downloading method and system. The method includes the following steps: designing a configuration table template according to a service demand; filling in the configuration table template according a data model of the background database, and forming a configuration table; configuring a preset downloading task parameter to the configuration table, and forming a corresponding executable task script; and extracting data from the database through the executable task script, and generating a downloading file. The method can generate task scripts such as an SQL, a storage process, and an SHELL, appoint the starting time and the starting frequency, can regularly execute the task scripts to generate target files or tables to be downloaded without configuring a timing task by means of a Crontab, can improve the maintenance efficiency, relieve workload of maintainers, lower risks, is simple and flexible in configuration process, can perform multi-type configuration for different services, and is good in maintainability.

Description

technical field [0001] The invention relates to the field of network technology, in particular to a method and system for data download based on background database configuration. Background technique [0002] In database maintenance, extracting data according to requirements and generating target files or tables are repeated tasks every day. Sometimes the same data needs to be extracted multiple times. The existing technology usually uses manual methods to extract item by item, which is not only error-prone , and inefficient, greatly increasing the workload of database administrators. Contents of the invention [0003] The invention provides a method and system for downloading data based on background database configuration, which solves the technical problem of error-prone and low efficiency in the prior art when the database is maintained manually. The technical solution of the present invention to solve the above-mentioned technical problems is as follows: a method fo...

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): G06F9/48G06F17/30
CPCG06F9/4843G06F16/254
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