Data migration method and server

Data migration method and server

The invention provides a data migration method and a server, which can be applied to the technical field of databases, and the method comprises the following steps: reading a CDC log in a current database; the CDC log is used for recording data change information in a database; generating a first SQ...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
1. Verfasser: LIN JIANHAI
Format: Patent
Sprache:chi ; eng
Schlagworte:
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
container_end_page
container_issue
container_start_page
container_title
container_volume
creator LIN JIANHAI
description The invention provides a data migration method and a server, which can be applied to the technical field of databases, and the method comprises the following steps: reading a CDC log in a current database; the CDC log is used for recording data change information in a database; generating a first SQL (Structured Query Language) statement corresponding to the CDC log in the current database; under the condition that the first SQL statement is not executed in a target database, first data migration operation is executed, and the first data migration operation is that the first SQL statement is sent to the target database, so that the target database executes the first SQL statement. Thus, whether the first SQL statement is executed in the target database or not is determined before data migration, then the first SQL statement is executed in the target database which does not execute the first SQL statement, and the problem of repeated migration is avoided. 本申请提供了一种数据迁移方法及服务器，可应用于数据库技术领域，该方法包括：读取当前数据库中的CDC日志；所述C
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_CN118606292A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>CN118606292A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_CN118606292A3</originalsourceid><addsrcrecordid>eNrjZFBwSSxJVMjNTC9KLMnMz1PITS3JyE9RSMxLUShOLSpLLeJhYE1LzClO5YXS3AyKbq4hzh66qQX58anFBYnJqXmpJfHOfoaGFmYGZkaWRo7GxKgBAEEcJRw</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Data migration method and server</title><source>esp@cenet</source><creator>LIN JIANHAI</creator><creatorcontrib>LIN JIANHAI</creatorcontrib><description>The invention provides a data migration method and a server, which can be applied to the technical field of databases, and the method comprises the following steps: reading a CDC log in a current database; the CDC log is used for recording data change information in a database; generating a first SQL (Structured Query Language) statement corresponding to the CDC log in the current database; under the condition that the first SQL statement is not executed in a target database, first data migration operation is executed, and the first data migration operation is that the first SQL statement is sent to the target database, so that the target database executes the first SQL statement. Thus, whether the first SQL statement is executed in the target database or not is determined before data migration, then the first SQL statement is executed in the target database which does not execute the first SQL statement, and the problem of repeated migration is avoided. 本申请提供了一种数据迁移方法及服务器，可应用于数据库技术领域，该方法包括：读取当前数据库中的CDC日志；所述C</description><language>chi ; eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2024</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20240906&amp;DB=EPODOC&amp;CC=CN&amp;NR=118606292A$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,309,782,887,25571,76555</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20240906&amp;DB=EPODOC&amp;CC=CN&amp;NR=118606292A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>LIN JIANHAI</creatorcontrib><title>Data migration method and server</title><description>The invention provides a data migration method and a server, which can be applied to the technical field of databases, and the method comprises the following steps: reading a CDC log in a current database; the CDC log is used for recording data change information in a database; generating a first SQL (Structured Query Language) statement corresponding to the CDC log in the current database; under the condition that the first SQL statement is not executed in a target database, first data migration operation is executed, and the first data migration operation is that the first SQL statement is sent to the target database, so that the target database executes the first SQL statement. Thus, whether the first SQL statement is executed in the target database or not is determined before data migration, then the first SQL statement is executed in the target database which does not execute the first SQL statement, and the problem of repeated migration is avoided. 本申请提供了一种数据迁移方法及服务器，可应用于数据库技术领域，该方法包括：读取当前数据库中的CDC日志；所述C</description><subject>CALCULATING</subject><subject>COMPUTING</subject><subject>COUNTING</subject><subject>ELECTRIC DIGITAL DATA PROCESSING</subject><subject>PHYSICS</subject><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2024</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZFBwSSxJVMjNTC9KLMnMz1PITS3JyE9RSMxLUShOLSpLLeJhYE1LzClO5YXS3AyKbq4hzh66qQX58anFBYnJqXmpJfHOfoaGFmYGZkaWRo7GxKgBAEEcJRw</recordid><startdate>20240906</startdate><enddate>20240906</enddate><creator>LIN JIANHAI</creator><scope>EVB</scope></search><sort><creationdate>20240906</creationdate><title>Data migration method and server</title><author>LIN JIANHAI</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_CN118606292A3</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>chi ; eng</language><creationdate>2024</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>LIN JIANHAI</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>LIN JIANHAI</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Data migration method and server</title><date>2024-09-06</date><risdate>2024</risdate><abstract>The invention provides a data migration method and a server, which can be applied to the technical field of databases, and the method comprises the following steps: reading a CDC log in a current database; the CDC log is used for recording data change information in a database; generating a first SQL (Structured Query Language) statement corresponding to the CDC log in the current database; under the condition that the first SQL statement is not executed in a target database, first data migration operation is executed, and the first data migration operation is that the first SQL statement is sent to the target database, so that the target database executes the first SQL statement. Thus, whether the first SQL statement is executed in the target database or not is determined before data migration, then the first SQL statement is executed in the target database which does not execute the first SQL statement, and the problem of repeated migration is avoided. 本申请提供了一种数据迁移方法及服务器，可应用于数据库技术领域，该方法包括：读取当前数据库中的CDC日志；所述C</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language chi ; eng
recordid cdi_epo_espacenet_CN118606292A
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title Data migration method and server
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2024-12-07T03%3A00%3A41IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-epo_EVB&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=LIN%20JIANHAI&rft.date=2024-09-06&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3ECN118606292A%3C/epo_EVB%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true