Check patentability & draft patents in minutes with Patsnap Eureka AI!

Import/export method and device of database

A database and data import technology, applied in the database field, can solve problems such as low efficiency of database import operation

Active Publication Date: 2015-07-08
NEW FOUNDER HLDG DEV LLC +1
View PDF3 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] The present invention provides a database guide method and device to overcome the problem of low efficiency of guide database operation in the prior art

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
  • Import/export method and device of database
  • Import/export method and device of database
  • Import/export method and device of database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0025] figure 1 It is the flow process of the first embodiment of the library guide method of the database of the present invention Figure 1 , figure 2 It is a signaling flow chart of Embodiment 1 of the database guide method of the present invention. The method of this embodiment is used to import the data of the original system data table into the target system data table, such as figure 2 As shown, a logging table is also included to log the exported data. Such as figure 1 As shown, the method of this embodiment may include:

[0026] Step a, obtaining the reference serial number corresponding to the last record in the record table;

[0027] Step b. Determine whether there is a record to be exported in the original system data table, and the serial number corresponding to the record to be exported is greater than the reference serial number;

[0028] Step c. If it exists, obtain the data corresponding to the first record to be exported that is larger than the refere...

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 provides an import / export method and device of a database. The import / export method of the database is adopted to import data of an original system database to a target system database and further comprises a record sheet for recording exported data; the method comprises the steps: acquiring a reference serial-number of last record in the record sheet; judging whether a to-be-exported record exists in the original system database and a corresponding serial-number is greater than the reference serial-number; if so, acquiring data corresponding to a first to-be-exported record with the serial-number of greater than the reference serial number in the original system database, in which first main-key serial-numbers are ranked in an ascending order, and importing the data into the target system database; inserting one record in the record sheet and setting the corresponding reference serial-number to be the serial-number corresponding to the first to-be-exported record; repeating the above process till all data of the original system database is imported to the target system database. The import / export efficiency is improved and the data is prevented from being imported repeatedly after interruption.

Description

technical field [0001] The invention relates to database technology, in particular to a database guide method and device. Background technique [0002] During the use of enterprise information systems, with the continuous development of enterprise business and the continuous expansion of application fields, when a certain system cannot meet the needs of users, it will choose to use another more complete system. In order to continue to use the original system Important information, you need to import the data in the original system database to another target system database. [0003] There are two main methods for existing database guides: The first method is to export the data in the original system in a certain format, mostly as an XML file in a certain format, and then re-enter the database into the target database by parsing the exported XML file. system to go. The second method is to directly connect the data sources of the two databases, scan the table of the original...

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/30
Inventor 崔倩莹
Owner NEW FOUNDER HLDG DEV LLC
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