Supercharge Your Innovation With Domain-Expert AI Agents!

Database guide method and device

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: 2017-11-14
NEW FOUNDER HLDG DEV LLC +1
View PDF3 Cites 0 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
  • Database guide method and device
  • Database guide method and device
  • Database guide method and device

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 a database guide method and device. The database guide method of the present invention is used to import the data of the original system data table into the target system data table, and also includes a record table for recording the exported data; including: obtaining the reference serial number of the last record in the record table; Determine whether there is a record to be exported in the original system data table, and the corresponding serial number is greater than the reference serial number; if it exists, obtain the first record in the original system data table that is greater than the reference serial number after sorting in ascending order of the first primary key serial number For the data corresponding to the record to be exported, import the data into the target system data table; and insert a record in the record table, and set the corresponding reference serial number to the serial number corresponding to the first record to be exported; repeat the above process, Until all the data in the original system data table are imported into the target system data table. The invention improves the efficiency of database guide and avoids importing repeated data 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
Patent Type & Authority Patents(China)
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