Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Online database migration

A database, offline technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problem that the source server system and the target server system are not online.

Active Publication Date: 2016-02-24
ORACLE INT CORP
View PDF17 Cites 32 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, this migration results in both the source and target server systems being offline for a significant period of 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
  • Online database migration
  • Online database migration
  • Online database migration

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] Rather than taking the source server system offline while performing the migration, the source server system can remain online such that the source server system responds to database requests while the migration function is being performed. While online, the origin server system may receive and respond to read requests for records stored in one or more databases maintained by the origin server system. The origin server system may also receive and respond to modification requests for records stored in one or more databases maintained by the origin server system. In order for the origin server system to fulfill database requests in a timely manner, the number of migration scripts executed in parallel by the origin server system may be smaller than the number of migration scripts that would be executed in parallel if the origin server system were offline. As a result, migration-related scripts take significantly longer to execute while the source server system is online; h...

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

Various arrangements for performing an online migration between server systems is presented. A transfer, from a source server system to a target server system, of a database, may be initiated. During the transfer, the database of the source server system may remain online. A timing indication of when transfer of the database was initiated may be recorded. While transferring the database, modifications to the records of the database may be received. The plurality of modifications may be stored, and, for each modification of the plurality of modifications, a timing indication of when the modification was received may be stored. After completing the transfer of the database to the target server system, the plurality of modifications to the database stored by the target server system may be applied while the source server system is online.

Description

[0001] Cross References to Related Applications [0002] This application is related to the following co-pending and commonly assigned U.S. patent applications: [0003] U.S. Patent Application No. 13 / 937,977 (Attorney Docket No. 88325-860490(135800US)) by Higginson and entitled "METHODAND SYSTEM FOR REDUCING INSTABILITY WHEN UP GRADING SOFTWARE" filed concurrently herewith; [0004] U.S. Patent Application No. 13 / 938,061 (Attorney Docket No. 88325-870368(137700US)) written by Davis and entitled "CONSOLIDATION PLANNING SERVICES FOR SYSTEM SMIGRATION" filed concurrently herewith; [0005] U.S. Patent Application No. 13 / 938,066 (Attorney Docket No. 88325-870369(137800US)) written by Davis and entitled "MIGRATION SERVICESFORSYSTEMS," filed concurrently herewith; [0006] U.S. Patent Application No. 13 / 937,885 (Attorney Docket No. 88325-870374(137900US)) by Higginson, filed concurrently herewith, and entitled "DATABASE MODELINGAND ANALYSIS"; [0007] U.S. Patent Application No. 13...

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): G06F17/30
CPCG06F16/2379G06F16/119G06F16/214
Inventor S·比内E·施皮格尔贝尔格
Owner ORACLE INT CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com