Method for synchronously migrating data in heterogeneous database

Method for synchronously migrating data in heterogeneous database

The invention provides a method for synchronously migrating data in heterogeneous databases. The method comprises the following steps: S1, connecting a source end database and a target database by using a driving program; s2, SQL query parameters are input into the drive program, then required data...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: ZOU CHANGGEN, TU CHAONAN, DING YING, GAO XING
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 ZOU CHANGGEN
TU CHAONAN
DING YING
GAO XING
description The invention provides a method for synchronously migrating data in heterogeneous databases. The method comprises the following steps: S1, connecting a source end database and a target database by using a driving program; s2, SQL query parameters are input into the drive program, then required data are queried in the source end database, and the required data are stored in a target table in the drive program; and S3, writing the data in the target table into the target database to realize data synchronous migration. According to the heterogeneous database data synchronous migration method, two-way transmission between the source end database and the target database is supported, the range of data migration synchronization can be controlled through the SQL statement, full-amount synchronization of all fields, synchronization according to fields, synchronization according to conditions and increment synchronization are supported, and the mode is simple and easy to operate. 本发明提供了一种异构数据库数据同步迁移的方法，所述方法包括：S1、使用驱动程
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_CN116303355A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>CN116303355A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_CN116303355A3</originalsourceid><addsrcrecordid>eNrjZHD0TS3JyE9RSMsvUiiuzEvOKMrPyy8tzqlUyM1ML0osycxLV0hJLElUyMxTyEgtSS3KT0_NSwWqAIsmJRan8jCwpiXmFKfyQmluBkU31xBnD93Ugvz41OKCxGSghpJ4Zz9DQzNjA2NjU1NHY2LUAABNnDI7</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Method for synchronously migrating data in heterogeneous database</title><source>esp@cenet</source><creator>ZOU CHANGGEN ; TU CHAONAN ; DING YING ; GAO XING</creator><creatorcontrib>ZOU CHANGGEN ; TU CHAONAN ; DING YING ; GAO XING</creatorcontrib><description>The invention provides a method for synchronously migrating data in heterogeneous databases. The method comprises the following steps: S1, connecting a source end database and a target database by using a driving program; s2, SQL query parameters are input into the drive program, then required data are queried in the source end database, and the required data are stored in a target table in the drive program; and S3, writing the data in the target table into the target database to realize data synchronous migration. According to the heterogeneous database data synchronous migration method, two-way transmission between the source end database and the target database is supported, the range of data migration synchronization can be controlled through the SQL statement, full-amount synchronization of all fields, synchronization according to fields, synchronization according to conditions and increment synchronization are supported, and the mode is simple and easy to operate. 本发明提供了一种异构数据库数据同步迁移的方法，所述方法包括：S1、使用驱动程</description><language>chi ; eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2023</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=20230623&amp;DB=EPODOC&amp;CC=CN&amp;NR=116303355A$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,780,885,25564,76547</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20230623&amp;DB=EPODOC&amp;CC=CN&amp;NR=116303355A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>ZOU CHANGGEN</creatorcontrib><creatorcontrib>TU CHAONAN</creatorcontrib><creatorcontrib>DING YING</creatorcontrib><creatorcontrib>GAO XING</creatorcontrib><title>Method for synchronously migrating data in heterogeneous database</title><description>The invention provides a method for synchronously migrating data in heterogeneous databases. The method comprises the following steps: S1, connecting a source end database and a target database by using a driving program; s2, SQL query parameters are input into the drive program, then required data are queried in the source end database, and the required data are stored in a target table in the drive program; and S3, writing the data in the target table into the target database to realize data synchronous migration. According to the heterogeneous database data synchronous migration method, two-way transmission between the source end database and the target database is supported, the range of data migration synchronization can be controlled through the SQL statement, full-amount synchronization of all fields, synchronization according to fields, synchronization according to conditions and increment synchronization are supported, and the mode is simple and easy to operate. 本发明提供了一种异构数据库数据同步迁移的方法，所述方法包括：S1、使用驱动程</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>2023</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZHD0TS3JyE9RSMsvUiiuzEvOKMrPyy8tzqlUyM1ML0osycxLV0hJLElUyMxTyEgtSS3KT0_NSwWqAIsmJRan8jCwpiXmFKfyQmluBkU31xBnD93Ugvz41OKCxGSghpJ4Zz9DQzNjA2NjU1NHY2LUAABNnDI7</recordid><startdate>20230623</startdate><enddate>20230623</enddate><creator>ZOU CHANGGEN</creator><creator>TU CHAONAN</creator><creator>DING YING</creator><creator>GAO XING</creator><scope>EVB</scope></search><sort><creationdate>20230623</creationdate><title>Method for synchronously migrating data in heterogeneous database</title><author>ZOU CHANGGEN ; TU CHAONAN ; DING YING ; GAO XING</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_CN116303355A3</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>chi ; eng</language><creationdate>2023</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>ZOU CHANGGEN</creatorcontrib><creatorcontrib>TU CHAONAN</creatorcontrib><creatorcontrib>DING YING</creatorcontrib><creatorcontrib>GAO XING</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>ZOU CHANGGEN</au><au>TU CHAONAN</au><au>DING YING</au><au>GAO XING</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Method for synchronously migrating data in heterogeneous database</title><date>2023-06-23</date><risdate>2023</risdate><abstract>The invention provides a method for synchronously migrating data in heterogeneous databases. The method comprises the following steps: S1, connecting a source end database and a target database by using a driving program; s2, SQL query parameters are input into the drive program, then required data are queried in the source end database, and the required data are stored in a target table in the drive program; and S3, writing the data in the target table into the target database to realize data synchronous migration. According to the heterogeneous database data synchronous migration method, two-way transmission between the source end database and the target database is supported, the range of data migration synchronization can be controlled through the SQL statement, full-amount synchronization of all fields, synchronization according to fields, synchronization according to conditions and increment synchronization are supported, and the mode is simple and easy to operate. 本发明提供了一种异构数据库数据同步迁移的方法，所述方法包括：S1、使用驱动程</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language chi ; eng
recordid cdi_epo_espacenet_CN116303355A
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title Method for synchronously migrating data in heterogeneous database
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-04T04%3A58%3A22IST&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=ZOU%20CHANGGEN&rft.date=2023-06-23&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3ECN116303355A%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