Supercharge Your Innovation With Domain-Expert AI Agents!

Conflict-free method for reliable download of remote data base and use of local database

A data download and database technology, applied in special data processing applications, electrical digital data processing, program control devices, etc., can solve problems such as long download times, failures, conflicts, etc., and achieve the effect of preventing accidental loss and avoiding conflicts.

Inactive Publication Date: 2006-09-06
XIAN UNIV OF TECH
View PDF0 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] 1. It takes a long time to download large-capacity remote data to the local area. At the same time, due to the instability of the communication link, the technical failure of the remote database server, and the overload of the database server, the remote data download efficiency is low or fails.
[0005] 2. The download task of remote data will occupy a large resource of the local database server, so it will conflict with the use of the local database by the local application

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
  • Conflict-free method for reliable download of remote data base and use of local database
  • Conflict-free method for reliable download of remote data base and use of local database
  • Conflict-free method for reliable download of remote data base and use of local database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0020] The local database is created and managed by MS SQL Server 2000, and the application program is developed using Powerbuilder 9.0.

[0021] The database structure is as figure 1 As shown, the remote database is the download source of local data, and its table structure is known and fixed. Use MS SQL Server 2000 database management system to create a download database and an application database on two local servers (download server and application server), and establish local copy table 1, local copy table 2,... , replicate table n locally. In addition, a task record table is established in the download database, and the fields of the task record table include download date, download success flag, download subtask completion flag, task download times, and data copy success flag. The basic process of data downloading is: take a single database table (remote table 1, remote table 2, ..., remote table n) as a sub-task of the download task, use the data pipeline function p...

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

Wherein, with the remote database as the download source for local data, building a download database to download and store data from remote database and an application database to update the database periodically locally with MS SQL Server, Oracle or Sybase. This invention avoids conflict, simplifies operation, and can prevent the accidental missing of database.

Description

technical field [0001] The invention belongs to the fields of database application and computer software development, and relates to a method for reliably downloading a remote database and using a local database without conflict. Background technique [0002] At present, database technology has become an indispensable technology for data management in various industries and enterprises. For many large group companies with a wide range of businesses and branches all over the country or even in many regions of the world, how to use the network to efficiently transmit data and use remote data is a thorny issue. The branches of a large group usually carry out business in various places, and the business data that needs to be used mostly consists of local data and remote data. The local data is stored by the local database established by the branch, while the remote data is managed by a centralized remote database established by the head office. Generall...

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): G06F17/30G06F9/44
Inventor 王林张国宁
Owner XIAN UNIV OF 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