Live database schema tree change

Live database schema tree change

A method for live database schema tree change, comprising: (a) providing a computerized database comprising: a parent database table and a child database table having a column configured to reference the parent database table; and (b) while the computerized database is live, operating a database man...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Shmueli Yaniv, Keren-Haselkorn Sagi, Udassin Roy
Format: Patent
Sprache: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 Shmueli Yaniv
Keren-Haselkorn Sagi
Udassin Roy
description A method for live database schema tree change, comprising: (a) providing a computerized database comprising: a parent database table and a child database table having a column configured to reference the parent database table; and (b) while the computerized database is live, operating a database management system (DBMS) in control of the computerized database, to: create an intermediate database table having a column configured to reference the parent database table; in the child database table: create a column configured to reference the intermediate database table, insert an identifier of the intermediate database table into all fields of the column configured to reference the intermediate database table, and overwrite all fields of the column configured to reference the parent database table with data from the fields of the column configured to reference the intermediate database table.
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US9779118B2</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US9779118B2</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US9779118B23</originalsourceid><addsrcrecordid>eNrjZFDwySxLVUhJLElMSixOVShOzkjNTVQoKUpNVUjOSMxLT-VhYE1LzClO5YXS3AwKbq4hzh66qQX58anFBYnJqXmpJfGhwZbm5paGhhZORsZEKAEA6QckuQ</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Live database schema tree change</title><source>esp@cenet</source><creator>Shmueli Yaniv ; Keren-Haselkorn Sagi ; Udassin Roy</creator><creatorcontrib>Shmueli Yaniv ; Keren-Haselkorn Sagi ; Udassin Roy</creatorcontrib><description>A method for live database schema tree change, comprising: (a) providing a computerized database comprising: a parent database table and a child database table having a column configured to reference the parent database table; and (b) while the computerized database is live, operating a database management system (DBMS) in control of the computerized database, to: create an intermediate database table having a column configured to reference the parent database table; in the child database table: create a column configured to reference the intermediate database table, insert an identifier of the intermediate database table into all fields of the column configured to reference the intermediate database table, and overwrite all fields of the column configured to reference the parent database table with data from the fields of the column configured to reference the intermediate database table.</description><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2017</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=20171003&amp;DB=EPODOC&amp;CC=US&amp;NR=9779118B2$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,778,883,25547,76298</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20171003&amp;DB=EPODOC&amp;CC=US&amp;NR=9779118B2$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>Shmueli Yaniv</creatorcontrib><creatorcontrib>Keren-Haselkorn Sagi</creatorcontrib><creatorcontrib>Udassin Roy</creatorcontrib><title>Live database schema tree change</title><description>A method for live database schema tree change, comprising: (a) providing a computerized database comprising: a parent database table and a child database table having a column configured to reference the parent database table; and (b) while the computerized database is live, operating a database management system (DBMS) in control of the computerized database, to: create an intermediate database table having a column configured to reference the parent database table; in the child database table: create a column configured to reference the intermediate database table, insert an identifier of the intermediate database table into all fields of the column configured to reference the intermediate database table, and overwrite all fields of the column configured to reference the parent database table with data from the fields of the column configured to reference the intermediate database table.</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>2017</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZFDwySxLVUhJLElMSixOVShOzkjNTVQoKUpNVUjOSMxLT-VhYE1LzClO5YXS3AwKbq4hzh66qQX58anFBYnJqXmpJfGhwZbm5paGhhZORsZEKAEA6QckuQ</recordid><startdate>20171003</startdate><enddate>20171003</enddate><creator>Shmueli Yaniv</creator><creator>Keren-Haselkorn Sagi</creator><creator>Udassin Roy</creator><scope>EVB</scope></search><sort><creationdate>20171003</creationdate><title>Live database schema tree change</title><author>Shmueli Yaniv ; Keren-Haselkorn Sagi ; Udassin Roy</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US9779118B23</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2017</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>Shmueli Yaniv</creatorcontrib><creatorcontrib>Keren-Haselkorn Sagi</creatorcontrib><creatorcontrib>Udassin Roy</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Shmueli Yaniv</au><au>Keren-Haselkorn Sagi</au><au>Udassin Roy</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Live database schema tree change</title><date>2017-10-03</date><risdate>2017</risdate><abstract>A method for live database schema tree change, comprising: (a) providing a computerized database comprising: a parent database table and a child database table having a column configured to reference the parent database table; and (b) while the computerized database is live, operating a database management system (DBMS) in control of the computerized database, to: create an intermediate database table having a column configured to reference the parent database table; in the child database table: create a column configured to reference the intermediate database table, insert an identifier of the intermediate database table into all fields of the column configured to reference the intermediate database table, and overwrite all fields of the column configured to reference the parent database table with data from the fields of the column configured to reference the intermediate database table.</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language eng
recordid cdi_epo_espacenet_US9779118B2
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title Live database schema tree change
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-16T08%3A29%3A52IST&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=Shmueli%20Yaniv&rft.date=2017-10-03&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS9779118B2%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