Transaction identifier locking with data row locks
A computing device is provided, including non-volatile memory storing a database including a table having a plurality of rows. The computing device may further include a processor configured to receive a request to perform a first transaction on a row. The processor may assign a first transaction id...
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 | Chen, Wei Mittur Venkataramanappa, Girish Ravella, Chaitanya Sreenivas Purnananda, Prashanth Byrne, Peter Radu, Adrian-Leonard Freedman, Craig Steven Antonopoulos, Panagiotis Thallam Kodandaramaih, Raghavendra Kodavalla, Hanumantha Rao |
| description | A computing device is provided, including non-volatile memory storing a database including a table having a plurality of rows. The computing device may further include a processor configured to receive a request to perform a first transaction on a row. The processor may assign a first transaction identifier (TID) of the first transaction to the row. The processor may impose a first exclusive TID lock on the first TID of the row and may impose a first exclusive data lock associated with the first transaction on the row. The processor may perform the first transaction on the row. Performing the first transaction may include modifying the table as stored in the memory. In response to completing the first transaction, the processor may release the first exclusive data lock on the row and release the first exclusive TID lock on the first TID of the row. |
| format | Patent |
| fullrecord | <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US11755558B2</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US11755558B2</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US11755558B23</originalsourceid><addsrcrecordid>eNrjZDAKKUrMK05MLsnMz1PITEnNK8lMy0wtUsjJT87OzEtXKM8syVBISSxJVCjKLweLFvMwsKYl5hSn8kJpbgZFN9cQZw_d1IL8-NTigsTk1LzUkvjQYENDc1MgsHAyMiZGDQDpnSxx</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Transaction identifier locking with data row locks</title><source>esp@cenet</source><creator>Chen, Wei ; Mittur Venkataramanappa, Girish ; Ravella, Chaitanya Sreenivas ; Purnananda, Prashanth ; Byrne, Peter ; Radu, Adrian-Leonard ; Freedman, Craig Steven ; Antonopoulos, Panagiotis ; Thallam Kodandaramaih, Raghavendra ; Kodavalla, Hanumantha Rao</creator><creatorcontrib>Chen, Wei ; Mittur Venkataramanappa, Girish ; Ravella, Chaitanya Sreenivas ; Purnananda, Prashanth ; Byrne, Peter ; Radu, Adrian-Leonard ; Freedman, Craig Steven ; Antonopoulos, Panagiotis ; Thallam Kodandaramaih, Raghavendra ; Kodavalla, Hanumantha Rao</creatorcontrib><description>A computing device is provided, including non-volatile memory storing a database including a table having a plurality of rows. The computing device may further include a processor configured to receive a request to perform a first transaction on a row. The processor may assign a first transaction identifier (TID) of the first transaction to the row. The processor may impose a first exclusive TID lock on the first TID of the row and may impose a first exclusive data lock associated with the first transaction on the row. The processor may perform the first transaction on the row. Performing the first transaction may include modifying the table as stored in the memory. In response to completing the first transaction, the processor may release the first exclusive data lock on the row and release the first exclusive TID lock on the first TID of the row.</description><language>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&date=20230912&DB=EPODOC&CC=US&NR=11755558B2$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,776,881,25542,76289</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20230912&DB=EPODOC&CC=US&NR=11755558B2$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>Chen, Wei</creatorcontrib><creatorcontrib>Mittur Venkataramanappa, Girish</creatorcontrib><creatorcontrib>Ravella, Chaitanya Sreenivas</creatorcontrib><creatorcontrib>Purnananda, Prashanth</creatorcontrib><creatorcontrib>Byrne, Peter</creatorcontrib><creatorcontrib>Radu, Adrian-Leonard</creatorcontrib><creatorcontrib>Freedman, Craig Steven</creatorcontrib><creatorcontrib>Antonopoulos, Panagiotis</creatorcontrib><creatorcontrib>Thallam Kodandaramaih, Raghavendra</creatorcontrib><creatorcontrib>Kodavalla, Hanumantha Rao</creatorcontrib><title>Transaction identifier locking with data row locks</title><description>A computing device is provided, including non-volatile memory storing a database including a table having a plurality of rows. The computing device may further include a processor configured to receive a request to perform a first transaction on a row. The processor may assign a first transaction identifier (TID) of the first transaction to the row. The processor may impose a first exclusive TID lock on the first TID of the row and may impose a first exclusive data lock associated with the first transaction on the row. The processor may perform the first transaction on the row. Performing the first transaction may include modifying the table as stored in the memory. In response to completing the first transaction, the processor may release the first exclusive data lock on the row and release the first exclusive TID lock on the first TID of the row.</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>eNrjZDAKKUrMK05MLsnMz1PITEnNK8lMy0wtUsjJT87OzEtXKM8syVBISSxJVCjKLweLFvMwsKYl5hSn8kJpbgZFN9cQZw_d1IL8-NTigsTk1LzUkvjQYENDc1MgsHAyMiZGDQDpnSxx</recordid><startdate>20230912</startdate><enddate>20230912</enddate><creator>Chen, Wei</creator><creator>Mittur Venkataramanappa, Girish</creator><creator>Ravella, Chaitanya Sreenivas</creator><creator>Purnananda, Prashanth</creator><creator>Byrne, Peter</creator><creator>Radu, Adrian-Leonard</creator><creator>Freedman, Craig Steven</creator><creator>Antonopoulos, Panagiotis</creator><creator>Thallam Kodandaramaih, Raghavendra</creator><creator>Kodavalla, Hanumantha Rao</creator><scope>EVB</scope></search><sort><creationdate>20230912</creationdate><title>Transaction identifier locking with data row locks</title><author>Chen, Wei ; Mittur Venkataramanappa, Girish ; Ravella, Chaitanya Sreenivas ; Purnananda, Prashanth ; Byrne, Peter ; Radu, Adrian-Leonard ; Freedman, Craig Steven ; Antonopoulos, Panagiotis ; Thallam Kodandaramaih, Raghavendra ; Kodavalla, Hanumantha Rao</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US11755558B23</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>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>Chen, Wei</creatorcontrib><creatorcontrib>Mittur Venkataramanappa, Girish</creatorcontrib><creatorcontrib>Ravella, Chaitanya Sreenivas</creatorcontrib><creatorcontrib>Purnananda, Prashanth</creatorcontrib><creatorcontrib>Byrne, Peter</creatorcontrib><creatorcontrib>Radu, Adrian-Leonard</creatorcontrib><creatorcontrib>Freedman, Craig Steven</creatorcontrib><creatorcontrib>Antonopoulos, Panagiotis</creatorcontrib><creatorcontrib>Thallam Kodandaramaih, Raghavendra</creatorcontrib><creatorcontrib>Kodavalla, Hanumantha Rao</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Chen, Wei</au><au>Mittur Venkataramanappa, Girish</au><au>Ravella, Chaitanya Sreenivas</au><au>Purnananda, Prashanth</au><au>Byrne, Peter</au><au>Radu, Adrian-Leonard</au><au>Freedman, Craig Steven</au><au>Antonopoulos, Panagiotis</au><au>Thallam Kodandaramaih, Raghavendra</au><au>Kodavalla, Hanumantha Rao</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Transaction identifier locking with data row locks</title><date>2023-09-12</date><risdate>2023</risdate><abstract>A computing device is provided, including non-volatile memory storing a database including a table having a plurality of rows. The computing device may further include a processor configured to receive a request to perform a first transaction on a row. The processor may assign a first transaction identifier (TID) of the first transaction to the row. The processor may impose a first exclusive TID lock on the first TID of the row and may impose a first exclusive data lock associated with the first transaction on the row. The processor may perform the first transaction on the row. Performing the first transaction may include modifying the table as stored in the memory. In response to completing the first transaction, the processor may release the first exclusive data lock on the row and release the first exclusive TID lock on the first TID of the row.</abstract><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | |
| ispartof | |
| issn | |
| language | eng |
| recordid | cdi_epo_espacenet_US11755558B2 |
| source | esp@cenet |
| subjects | CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS |
| title | Transaction identifier locking with data row locks |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-06T20%3A24%3A12IST&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=Chen,%20Wei&rft.date=2023-09-12&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS11755558B2%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 |