Changing table records in a database management system

Changing table records in a database management system

1. Technical Field A method and system for updating and deleting records in a tableset T of a family having M tables (M 1). A set S of N source files (N 1) are embodied in fileset Sat time tand in fileset Sat time t. S is logically associated with T. The family has a common family key Kacross the M...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Broden, Theresa W, Guse, Robert W, Parmeter, Debra A, Willets, Jeffrey G
Format: Patent
Sprache:eng
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 Broden, Theresa W
Guse, Robert W
Parmeter, Debra A
Willets, Jeffrey G
description 1. Technical Field A method and system for updating and deleting records in a tableset T of a family having M tables (M 1). A set S of N source files (N 1) are embodied in fileset Sat time tand in fileset Sat time t. S is logically associated with T. The family has a common family key Kacross the M tables and across the N source files. A Delta program generates a dataset D having non-redundant family keyvalues embodying K. Each non-redundant family keyvalue is drawn from selected Update or Delete records of Srelative to S. For Updates, a Trigger program generates fileset S from records of Shaving a family key in D, and a Bridge program generates fileset T that includes S data in a form compatible with T. A Load program updates and deletes records in T based on the non-redundant family keyvalues.
format Patent
fullrecord <record><control><sourceid>uspatents_EFH</sourceid><recordid>TN_cdi_uspatents_grants_06665654</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>06665654</sourcerecordid><originalsourceid>FETCH-uspatents_grants_066656543</originalsourceid><addsrcrecordid>eNrjZDBzzkjMS8_MS1coSUzKSVUoSk3OL0opVsjMU0hUSEkECiYWpyrkJuYlpqfmpuaVKBRXFpek5vIwsKYl5hSn8kJpbgYFN9cQZw_d0uKCxBKguuL49KJEEGVgZmZmamZqYkyEEgBKKy4_</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Changing table records in a database management system</title><source>USPTO Issued Patents</source><creator>Broden, Theresa W ; Guse, Robert W ; Parmeter, Debra A ; Willets, Jeffrey G</creator><creatorcontrib>Broden, Theresa W ; Guse, Robert W ; Parmeter, Debra A ; Willets, Jeffrey G ; International Business Machines Corporation</creatorcontrib><description>1. Technical Field A method and system for updating and deleting records in a tableset T of a family having M tables (M 1). A set S of N source files (N 1) are embodied in fileset Sat time tand in fileset Sat time t. S is logically associated with T. The family has a common family key Kacross the M tables and across the N source files. A Delta program generates a dataset D having non-redundant family keyvalues embodying K. Each non-redundant family keyvalue is drawn from selected Update or Delete records of Srelative to S. For Updates, a Trigger program generates fileset S from records of Shaving a family key in D, and a Bridge program generates fileset T that includes S data in a form compatible with T. A Load program updates and deletes records in T based on the non-redundant family keyvalues.</description><language>eng</language><creationdate>2003</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktopdf>$$Uhttps://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/6665654$$EPDF$$P50$$Guspatents$$Hfree_for_read</linktopdf><link.rule.ids>230,308,776,798,881,64015</link.rule.ids><linktorsrc>$$Uhttps://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/6665654$$EView_record_in_USPTO$$FView_record_in_$$GUSPTO$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>Broden, Theresa W</creatorcontrib><creatorcontrib>Guse, Robert W</creatorcontrib><creatorcontrib>Parmeter, Debra A</creatorcontrib><creatorcontrib>Willets, Jeffrey G</creatorcontrib><creatorcontrib>International Business Machines Corporation</creatorcontrib><title>Changing table records in a database management system</title><description>1. Technical Field A method and system for updating and deleting records in a tableset T of a family having M tables (M 1). A set S of N source files (N 1) are embodied in fileset Sat time tand in fileset Sat time t. S is logically associated with T. The family has a common family key Kacross the M tables and across the N source files. A Delta program generates a dataset D having non-redundant family keyvalues embodying K. Each non-redundant family keyvalue is drawn from selected Update or Delete records of Srelative to S. For Updates, a Trigger program generates fileset S from records of Shaving a family key in D, and a Bridge program generates fileset T that includes S data in a form compatible with T. A Load program updates and deletes records in T based on the non-redundant family keyvalues.</description><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2003</creationdate><recordtype>patent</recordtype><sourceid>EFH</sourceid><recordid>eNrjZDBzzkjMS8_MS1coSUzKSVUoSk3OL0opVsjMU0hUSEkECiYWpyrkJuYlpqfmpuaVKBRXFpek5vIwsKYl5hSn8kJpbgYFN9cQZw_d0uKCxBKguuL49KJEEGVgZmZmamZqYkyEEgBKKy4_</recordid><startdate>20031216</startdate><enddate>20031216</enddate><creator>Broden, Theresa W</creator><creator>Guse, Robert W</creator><creator>Parmeter, Debra A</creator><creator>Willets, Jeffrey G</creator><scope>EFH</scope></search><sort><creationdate>20031216</creationdate><title>Changing table records in a database management system</title><author>Broden, Theresa W ; Guse, Robert W ; Parmeter, Debra A ; Willets, Jeffrey G</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-uspatents_grants_066656543</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2003</creationdate><toplevel>online_resources</toplevel><creatorcontrib>Broden, Theresa W</creatorcontrib><creatorcontrib>Guse, Robert W</creatorcontrib><creatorcontrib>Parmeter, Debra A</creatorcontrib><creatorcontrib>Willets, Jeffrey G</creatorcontrib><creatorcontrib>International Business Machines Corporation</creatorcontrib><collection>USPTO Issued Patents</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Broden, Theresa W</au><au>Guse, Robert W</au><au>Parmeter, Debra A</au><au>Willets, Jeffrey G</au><aucorp>International Business Machines Corporation</aucorp><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Changing table records in a database management system</title><date>2003-12-16</date><risdate>2003</risdate><abstract>1. Technical Field A method and system for updating and deleting records in a tableset T of a family having M tables (M 1). A set S of N source files (N 1) are embodied in fileset Sat time tand in fileset Sat time t. S is logically associated with T. The family has a common family key Kacross the M tables and across the N source files. A Delta program generates a dataset D having non-redundant family keyvalues embodying K. Each non-redundant family keyvalue is drawn from selected Update or Delete records of Srelative to S. For Updates, a Trigger program generates fileset S from records of Shaving a family key in D, and a Bridge program generates fileset T that includes S data in a form compatible with T. A Load program updates and deletes records in T based on the non-redundant family keyvalues.</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language eng
recordid cdi_uspatents_grants_06665654
source USPTO Issued Patents
title Changing table records in a database management 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-27T14%3A15%3A54IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-uspatents_EFH&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=Broden,%20Theresa%20W&rft.aucorp=International%20Business%20Machines%20Corporation&rft.date=2003-12-16&rft_id=info:doi/&rft_dat=%3Cuspatents_EFH%3E06665654%3C/uspatents_EFH%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