DEPENDENCY LOCKING
Techniques are described for performing dependency locking to enable parallel execution of database server processes modifying the same object. In an embodiment, a DBMS receives a request to execute an operation on its managed database. The request may include an object identifier and a version iden...
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 | WANG, CHIH-PING HOANG, CHI KIM BANDI, NAGENDER MILLER, JOHN |
| description | Techniques are described for performing dependency locking to enable parallel execution of database server processes modifying the same object. In an embodiment, a DBMS receives a request to execute an operation on its managed database. The request may include an object identifier and a version identifier for a version of a database object, which is required for the successful execution of the operation on the database. The required version of the database object may not exist and may be generated only after the execution of another, second, operation on the database. The first database server process initiates execution of the earlier received operation on the database. The first database server process queries the first database for the version of the particular database object and determines that the version of the database object does not exist yet, in one embodiment. Based on such a determination, a dependency lock is generated for the version of the object, and the first database server process is suspended, preventing the completion of execution of the earlier received operation on the database. Another, second database server process executes another operation on the database and causes the generation of the version of the object on the database. The dependency lock is thereby released for the version of the object, and the first database server process completes the execution of the first operation on the first database. |
| format | Patent |
| fullrecord | <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US2020125549A1</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US2020125549A1</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US2020125549A13</originalsourceid><addsrcrecordid>eNrjZBBycQ1w9XNx9XOOVPDxd_b29HPnYWBNS8wpTuWF0twMym6uIc4euqkF-fGpxQWJyal5qSXxocFGBkYGhkampiaWjobGxKkCALFeHu8</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>DEPENDENCY LOCKING</title><source>esp@cenet</source><creator>WANG, CHIH-PING ; HOANG, CHI KIM ; BANDI, NAGENDER ; MILLER, JOHN</creator><creatorcontrib>WANG, CHIH-PING ; HOANG, CHI KIM ; BANDI, NAGENDER ; MILLER, JOHN</creatorcontrib><description>Techniques are described for performing dependency locking to enable parallel execution of database server processes modifying the same object. In an embodiment, a DBMS receives a request to execute an operation on its managed database. The request may include an object identifier and a version identifier for a version of a database object, which is required for the successful execution of the operation on the database. The required version of the database object may not exist and may be generated only after the execution of another, second, operation on the database. The first database server process initiates execution of the earlier received operation on the database. The first database server process queries the first database for the version of the particular database object and determines that the version of the database object does not exist yet, in one embodiment. Based on such a determination, a dependency lock is generated for the version of the object, and the first database server process is suspended, preventing the completion of execution of the earlier received operation on the database. Another, second database server process executes another operation on the database and causes the generation of the version of the object on the database. The dependency lock is thereby released for the version of the object, and the first database server process completes the execution of the first operation on the first database.</description><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</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=20200423&DB=EPODOC&CC=US&NR=2020125549A1$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,776,881,25542,76516</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20200423&DB=EPODOC&CC=US&NR=2020125549A1$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>WANG, CHIH-PING</creatorcontrib><creatorcontrib>HOANG, CHI KIM</creatorcontrib><creatorcontrib>BANDI, NAGENDER</creatorcontrib><creatorcontrib>MILLER, JOHN</creatorcontrib><title>DEPENDENCY LOCKING</title><description>Techniques are described for performing dependency locking to enable parallel execution of database server processes modifying the same object. In an embodiment, a DBMS receives a request to execute an operation on its managed database. The request may include an object identifier and a version identifier for a version of a database object, which is required for the successful execution of the operation on the database. The required version of the database object may not exist and may be generated only after the execution of another, second, operation on the database. The first database server process initiates execution of the earlier received operation on the database. The first database server process queries the first database for the version of the particular database object and determines that the version of the database object does not exist yet, in one embodiment. Based on such a determination, a dependency lock is generated for the version of the object, and the first database server process is suspended, preventing the completion of execution of the earlier received operation on the database. Another, second database server process executes another operation on the database and causes the generation of the version of the object on the database. The dependency lock is thereby released for the version of the object, and the first database server process completes the execution of the first operation on the first database.</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>2020</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZBBycQ1w9XNx9XOOVPDxd_b29HPnYWBNS8wpTuWF0twMym6uIc4euqkF-fGpxQWJyal5qSXxocFGBkYGhkampiaWjobGxKkCALFeHu8</recordid><startdate>20200423</startdate><enddate>20200423</enddate><creator>WANG, CHIH-PING</creator><creator>HOANG, CHI KIM</creator><creator>BANDI, NAGENDER</creator><creator>MILLER, JOHN</creator><scope>EVB</scope></search><sort><creationdate>20200423</creationdate><title>DEPENDENCY LOCKING</title><author>WANG, CHIH-PING ; HOANG, CHI KIM ; BANDI, NAGENDER ; MILLER, JOHN</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US2020125549A13</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2020</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>WANG, CHIH-PING</creatorcontrib><creatorcontrib>HOANG, CHI KIM</creatorcontrib><creatorcontrib>BANDI, NAGENDER</creatorcontrib><creatorcontrib>MILLER, JOHN</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>WANG, CHIH-PING</au><au>HOANG, CHI KIM</au><au>BANDI, NAGENDER</au><au>MILLER, JOHN</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>DEPENDENCY LOCKING</title><date>2020-04-23</date><risdate>2020</risdate><abstract>Techniques are described for performing dependency locking to enable parallel execution of database server processes modifying the same object. In an embodiment, a DBMS receives a request to execute an operation on its managed database. The request may include an object identifier and a version identifier for a version of a database object, which is required for the successful execution of the operation on the database. The required version of the database object may not exist and may be generated only after the execution of another, second, operation on the database. The first database server process initiates execution of the earlier received operation on the database. The first database server process queries the first database for the version of the particular database object and determines that the version of the database object does not exist yet, in one embodiment. Based on such a determination, a dependency lock is generated for the version of the object, and the first database server process is suspended, preventing the completion of execution of the earlier received operation on the database. Another, second database server process executes another operation on the database and causes the generation of the version of the object on the database. The dependency lock is thereby released for the version of the object, and the first database server process completes the execution of the first operation on the first database.</abstract><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | |
| ispartof | |
| issn | |
| language | eng |
| recordid | cdi_epo_espacenet_US2020125549A1 |
| source | esp@cenet |
| subjects | CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS |
| title | DEPENDENCY LOCKING |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-20T08%3A37%3A07IST&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=WANG,%20CHIH-PING&rft.date=2020-04-23&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS2020125549A1%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 |