Snapshot-based data tracing method and system

The invention discloses a snapshot-based data tracing method and system. The method comprises the steps of modifying a capture table and a task, obtaining an output target table of a to-be-updated task script, obtaining a dependent upstream table of the output target table, obtaining field data cons...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: ZHANG JIE, LIN XIAOJUN, HUANG CHUANGGUANG
Format: Patent
Sprache:chi ; eng
Schlagworte:
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 ZHANG JIE
LIN XIAOJUN
HUANG CHUANGGUANG
description The invention discloses a snapshot-based data tracing method and system. The method comprises the steps of modifying a capture table and a task, obtaining an output target table of a to-be-updated task script, obtaining a dependent upstream table of the output target table, obtaining field data consanguinity from a task snapshot script, and collecting table updates from the latest capture table modification; updating the data consanguinity, obtaining the latest historical snapshot of the to-be-updated task, refreshing the corresponding relationship between the output target table and the task snapshot, refreshing the corresponding relationship between the task snapshot and the input source end table, and refreshing the table change record; and obtaining a data source, a data destination and a data processing process by updating the data consanguinity. The method has the multi-table, multi-field and multi-version traceability, traces the generation process of data based on the table snapshots and the task snap
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_CN117743298A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>CN117743298A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_CN117743298A3</originalsourceid><addsrcrecordid>eNrjZNANzkssKM7IL9FNSixOTVFISSxJVCgpSkzOzEtXyE0tychPUUjMS1EoriwuSc3lYWBNS8wpTuWF0twMim6uIc4euqkF-fGpxQWJyal5qSXxzn6GhubmJsZGlhaOxsSoAQC8Pyof</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Snapshot-based data tracing method and system</title><source>esp@cenet</source><creator>ZHANG JIE ; LIN XIAOJUN ; HUANG CHUANGGUANG</creator><creatorcontrib>ZHANG JIE ; LIN XIAOJUN ; HUANG CHUANGGUANG</creatorcontrib><description>The invention discloses a snapshot-based data tracing method and system. The method comprises the steps of modifying a capture table and a task, obtaining an output target table of a to-be-updated task script, obtaining a dependent upstream table of the output target table, obtaining field data consanguinity from a task snapshot script, and collecting table updates from the latest capture table modification; updating the data consanguinity, obtaining the latest historical snapshot of the to-be-updated task, refreshing the corresponding relationship between the output target table and the task snapshot, refreshing the corresponding relationship between the task snapshot and the input source end table, and refreshing the table change record; and obtaining a data source, a data destination and a data processing process by updating the data consanguinity. The method has the multi-table, multi-field and multi-version traceability, traces the generation process of data based on the table snapshots and the task snap</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=20240322&amp;DB=EPODOC&amp;CC=CN&amp;NR=117743298A$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,780,885,25562,76317</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20240322&amp;DB=EPODOC&amp;CC=CN&amp;NR=117743298A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>ZHANG JIE</creatorcontrib><creatorcontrib>LIN XIAOJUN</creatorcontrib><creatorcontrib>HUANG CHUANGGUANG</creatorcontrib><title>Snapshot-based data tracing method and system</title><description>The invention discloses a snapshot-based data tracing method and system. The method comprises the steps of modifying a capture table and a task, obtaining an output target table of a to-be-updated task script, obtaining a dependent upstream table of the output target table, obtaining field data consanguinity from a task snapshot script, and collecting table updates from the latest capture table modification; updating the data consanguinity, obtaining the latest historical snapshot of the to-be-updated task, refreshing the corresponding relationship between the output target table and the task snapshot, refreshing the corresponding relationship between the task snapshot and the input source end table, and refreshing the table change record; and obtaining a data source, a data destination and a data processing process by updating the data consanguinity. The method has the multi-table, multi-field and multi-version traceability, traces the generation process of data based on the table snapshots and the task snap</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>eNrjZNANzkssKM7IL9FNSixOTVFISSxJVCgpSkzOzEtXyE0tychPUUjMS1EoriwuSc3lYWBNS8wpTuWF0twMim6uIc4euqkF-fGpxQWJyal5qSXxzn6GhubmJsZGlhaOxsSoAQC8Pyof</recordid><startdate>20240322</startdate><enddate>20240322</enddate><creator>ZHANG JIE</creator><creator>LIN XIAOJUN</creator><creator>HUANG CHUANGGUANG</creator><scope>EVB</scope></search><sort><creationdate>20240322</creationdate><title>Snapshot-based data tracing method and system</title><author>ZHANG JIE ; LIN XIAOJUN ; HUANG CHUANGGUANG</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_CN117743298A3</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>ZHANG JIE</creatorcontrib><creatorcontrib>LIN XIAOJUN</creatorcontrib><creatorcontrib>HUANG CHUANGGUANG</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>ZHANG JIE</au><au>LIN XIAOJUN</au><au>HUANG CHUANGGUANG</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Snapshot-based data tracing method and system</title><date>2024-03-22</date><risdate>2024</risdate><abstract>The invention discloses a snapshot-based data tracing method and system. The method comprises the steps of modifying a capture table and a task, obtaining an output target table of a to-be-updated task script, obtaining a dependent upstream table of the output target table, obtaining field data consanguinity from a task snapshot script, and collecting table updates from the latest capture table modification; updating the data consanguinity, obtaining the latest historical snapshot of the to-be-updated task, refreshing the corresponding relationship between the output target table and the task snapshot, refreshing the corresponding relationship between the task snapshot and the input source end table, and refreshing the table change record; and obtaining a data source, a data destination and a data processing process by updating the data consanguinity. The method has the multi-table, multi-field and multi-version traceability, traces the generation process of data based on the table snapshots and the task snap</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language chi ; eng
recordid cdi_epo_espacenet_CN117743298A
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title Snapshot-based data tracing method and system
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-14T10%3A40%3A50IST&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=ZHANG%20JIE&rft.date=2024-03-22&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3ECN117743298A%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