Transitioning between system sharing types in multi-tenancy database systems
The present disclosure teaches solutions for transitioning between database system sharing types. In one example, a tenant container includes a read-only table, a first writable table, and a mixed table for storing read-only and writable data. When transitioning to a sharing setup, a shared containe...
Gespeichert in:
| Hauptverfasser: | , , , , , , |
|---|---|
| Format: | Patent |
| Sprache: | 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 | Hoeft, Kerstin Neufeld, Andrea Stork, Christian Driesen, Volker Birn, Immo-Gert Walter, Welf Schlarb, Uwe |
| description | The present disclosure teaches solutions for transitioning between database system sharing types. In one example, a tenant container includes a read-only table, a first writable table, and a mixed table for storing read-only and writable data. When transitioning to a sharing setup, a shared container is created and a shared table is created in the shared container. Data is copied from the read-only table to the shared table and the read-only table is dropped. A read-only view is created in the tenant container and a second shared table is created in the shared container. Read-only mixed data is copied from the mixed table to the second shared table and deleted from the mixed table, and after the deletion, the mixed table is renamed as the second writable table. A union view is created that provides unified access to the second shared table and the second writable table. |
| format | Patent |
| fullrecord | <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US10740315B2</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US10740315B2</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US10740315B23</originalsourceid><addsrcrecordid>eNqNysEKglAQRuG7aRHVO0wPIGgW7YvERbtsLaP91gUdL85E3LePwAdodeDwLd21mljUmx_Fy5Ma2AcQ0qiGgfTF029bDFDyQsO7N58YhKWN9GDjhhUz17VbdNwrNnNXbltcqnOZIIw1NHALgdX3W5Ye92meHU67_B_zBRqXNtg</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Transitioning between system sharing types in multi-tenancy database systems</title><source>esp@cenet</source><creator>Hoeft, Kerstin ; Neufeld, Andrea ; Stork, Christian ; Driesen, Volker ; Birn, Immo-Gert ; Walter, Welf ; Schlarb, Uwe</creator><creatorcontrib>Hoeft, Kerstin ; Neufeld, Andrea ; Stork, Christian ; Driesen, Volker ; Birn, Immo-Gert ; Walter, Welf ; Schlarb, Uwe</creatorcontrib><description>The present disclosure teaches solutions for transitioning between database system sharing types. In one example, a tenant container includes a read-only table, a first writable table, and a mixed table for storing read-only and writable data. When transitioning to a sharing setup, a shared container is created and a shared table is created in the shared container. Data is copied from the read-only table to the shared table and the read-only table is dropped. A read-only view is created in the tenant container and a second shared table is created in the shared container. Read-only mixed data is copied from the mixed table to the second shared table and deleted from the mixed table, and after the deletion, the mixed table is renamed as the second writable table. A union view is created that provides unified access to the second shared table and the second writable table.</description><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC COMMUNICATION TECHNIQUE ; ELECTRIC DIGITAL DATA PROCESSING ; ELECTRICITY ; PHYSICS ; TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHICCOMMUNICATION</subject><creationdate>2020</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&date=20200811&DB=EPODOC&CC=US&NR=10740315B2$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,776,881,25544,76293</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20200811&DB=EPODOC&CC=US&NR=10740315B2$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>Hoeft, Kerstin</creatorcontrib><creatorcontrib>Neufeld, Andrea</creatorcontrib><creatorcontrib>Stork, Christian</creatorcontrib><creatorcontrib>Driesen, Volker</creatorcontrib><creatorcontrib>Birn, Immo-Gert</creatorcontrib><creatorcontrib>Walter, Welf</creatorcontrib><creatorcontrib>Schlarb, Uwe</creatorcontrib><title>Transitioning between system sharing types in multi-tenancy database systems</title><description>The present disclosure teaches solutions for transitioning between database system sharing types. In one example, a tenant container includes a read-only table, a first writable table, and a mixed table for storing read-only and writable data. When transitioning to a sharing setup, a shared container is created and a shared table is created in the shared container. Data is copied from the read-only table to the shared table and the read-only table is dropped. A read-only view is created in the tenant container and a second shared table is created in the shared container. Read-only mixed data is copied from the mixed table to the second shared table and deleted from the mixed table, and after the deletion, the mixed table is renamed as the second writable table. A union view is created that provides unified access to the second shared table and the second writable table.</description><subject>CALCULATING</subject><subject>COMPUTING</subject><subject>COUNTING</subject><subject>ELECTRIC COMMUNICATION TECHNIQUE</subject><subject>ELECTRIC DIGITAL DATA PROCESSING</subject><subject>ELECTRICITY</subject><subject>PHYSICS</subject><subject>TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHICCOMMUNICATION</subject><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2020</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNqNysEKglAQRuG7aRHVO0wPIGgW7YvERbtsLaP91gUdL85E3LePwAdodeDwLd21mljUmx_Fy5Ma2AcQ0qiGgfTF029bDFDyQsO7N58YhKWN9GDjhhUz17VbdNwrNnNXbltcqnOZIIw1NHALgdX3W5Ye92meHU67_B_zBRqXNtg</recordid><startdate>20200811</startdate><enddate>20200811</enddate><creator>Hoeft, Kerstin</creator><creator>Neufeld, Andrea</creator><creator>Stork, Christian</creator><creator>Driesen, Volker</creator><creator>Birn, Immo-Gert</creator><creator>Walter, Welf</creator><creator>Schlarb, Uwe</creator><scope>EVB</scope></search><sort><creationdate>20200811</creationdate><title>Transitioning between system sharing types in multi-tenancy database systems</title><author>Hoeft, Kerstin ; Neufeld, Andrea ; Stork, Christian ; Driesen, Volker ; Birn, Immo-Gert ; Walter, Welf ; Schlarb, Uwe</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US10740315B23</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2020</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC COMMUNICATION TECHNIQUE</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>ELECTRICITY</topic><topic>PHYSICS</topic><topic>TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHICCOMMUNICATION</topic><toplevel>online_resources</toplevel><creatorcontrib>Hoeft, Kerstin</creatorcontrib><creatorcontrib>Neufeld, Andrea</creatorcontrib><creatorcontrib>Stork, Christian</creatorcontrib><creatorcontrib>Driesen, Volker</creatorcontrib><creatorcontrib>Birn, Immo-Gert</creatorcontrib><creatorcontrib>Walter, Welf</creatorcontrib><creatorcontrib>Schlarb, Uwe</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Hoeft, Kerstin</au><au>Neufeld, Andrea</au><au>Stork, Christian</au><au>Driesen, Volker</au><au>Birn, Immo-Gert</au><au>Walter, Welf</au><au>Schlarb, Uwe</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Transitioning between system sharing types in multi-tenancy database systems</title><date>2020-08-11</date><risdate>2020</risdate><abstract>The present disclosure teaches solutions for transitioning between database system sharing types. In one example, a tenant container includes a read-only table, a first writable table, and a mixed table for storing read-only and writable data. When transitioning to a sharing setup, a shared container is created and a shared table is created in the shared container. Data is copied from the read-only table to the shared table and the read-only table is dropped. A read-only view is created in the tenant container and a second shared table is created in the shared container. Read-only mixed data is copied from the mixed table to the second shared table and deleted from the mixed table, and after the deletion, the mixed table is renamed as the second writable table. A union view is created that provides unified access to the second shared table and the second writable table.</abstract><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | |
| ispartof | |
| issn | |
| language | eng |
| recordid | cdi_epo_espacenet_US10740315B2 |
| source | esp@cenet |
| subjects | CALCULATING COMPUTING COUNTING ELECTRIC COMMUNICATION TECHNIQUE ELECTRIC DIGITAL DATA PROCESSING ELECTRICITY PHYSICS TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHICCOMMUNICATION |
| title | Transitioning between system sharing types in multi-tenancy database systems |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-27T16%3A01%3A11IST&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=Hoeft,%20Kerstin&rft.date=2020-08-11&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS10740315B2%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 |