Method for estimating a first access time of transactions accessing a database object
A method for estimating the first access time of a plurality of currently active transactions accessing at least one database object are disclosed. In one aspect, the method may include providing a storage area of a particular size to store data for a plurality of groups corresponding to the at leas...
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 | LYLE ROBERT W WINER MICHAEL J |
| description | A method for estimating the first access time of a plurality of currently active transactions accessing at least one database object are disclosed. In one aspect, the method may include providing a storage area of a particular size to store data for a plurality of groups corresponding to the at least one database object. Each of the plurality of groups corresponds to a particular time interval. The method includes placing each of the currently active transactions in a group of the plurality of groups based upon a time of a first access of the at least one database object by each of the currently active transactions and the particular time interval. The method also includes storing a group first access time for the group. The group first access time corresponds to the earliest first access time for any of the currently active transactions in the group. The method may also include defining the object's first, or earliest access time, to be the earliest group first access time for currently active groups. |
| format | Patent |
| fullrecord | <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US7647296B2</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US7647296B2</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US7647296B23</originalsourceid><addsrcrecordid>eNqNyjEKwkAQheFtLES9w1wgTZQEW0WxsdLUYTJ5a1bMbtiZ-2PAHMDqwf--tWvusCH15FMmqIWRLcQXMfmQ1YhFoEpzByVPljkqi4UUdfl-umfjjnVG3RtiW7fy_FHslt04ul6e51uBKbXQiQUR1jaPujrU5bE6lfs_yBdSijjS</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Method for estimating a first access time of transactions accessing a database object</title><source>esp@cenet</source><creator>LYLE ROBERT W ; WINER MICHAEL J</creator><creatorcontrib>LYLE ROBERT W ; WINER MICHAEL J</creatorcontrib><description>A method for estimating the first access time of a plurality of currently active transactions accessing at least one database object are disclosed. In one aspect, the method may include providing a storage area of a particular size to store data for a plurality of groups corresponding to the at least one database object. Each of the plurality of groups corresponds to a particular time interval. The method includes placing each of the currently active transactions in a group of the plurality of groups based upon a time of a first access of the at least one database object by each of the currently active transactions and the particular time interval. The method also includes storing a group first access time for the group. The group first access time corresponds to the earliest first access time for any of the currently active transactions in the group. The method may also include defining the object's first, or earliest access time, to be the earliest group first access time for currently active groups.</description><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2010</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=20100112&DB=EPODOC&CC=US&NR=7647296B2$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,777,882,25545,76296</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20100112&DB=EPODOC&CC=US&NR=7647296B2$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>LYLE ROBERT W</creatorcontrib><creatorcontrib>WINER MICHAEL J</creatorcontrib><title>Method for estimating a first access time of transactions accessing a database object</title><description>A method for estimating the first access time of a plurality of currently active transactions accessing at least one database object are disclosed. In one aspect, the method may include providing a storage area of a particular size to store data for a plurality of groups corresponding to the at least one database object. Each of the plurality of groups corresponds to a particular time interval. The method includes placing each of the currently active transactions in a group of the plurality of groups based upon a time of a first access of the at least one database object by each of the currently active transactions and the particular time interval. The method also includes storing a group first access time for the group. The group first access time corresponds to the earliest first access time for any of the currently active transactions in the group. The method may also include defining the object's first, or earliest access time, to be the earliest group first access time for currently active groups.</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>2010</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNqNyjEKwkAQheFtLES9w1wgTZQEW0WxsdLUYTJ5a1bMbtiZ-2PAHMDqwf--tWvusCH15FMmqIWRLcQXMfmQ1YhFoEpzByVPljkqi4UUdfl-umfjjnVG3RtiW7fy_FHslt04ul6e51uBKbXQiQUR1jaPujrU5bE6lfs_yBdSijjS</recordid><startdate>20100112</startdate><enddate>20100112</enddate><creator>LYLE ROBERT W</creator><creator>WINER MICHAEL J</creator><scope>EVB</scope></search><sort><creationdate>20100112</creationdate><title>Method for estimating a first access time of transactions accessing a database object</title><author>LYLE ROBERT W ; WINER MICHAEL J</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US7647296B23</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2010</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>LYLE ROBERT W</creatorcontrib><creatorcontrib>WINER MICHAEL J</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>LYLE ROBERT W</au><au>WINER MICHAEL J</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Method for estimating a first access time of transactions accessing a database object</title><date>2010-01-12</date><risdate>2010</risdate><abstract>A method for estimating the first access time of a plurality of currently active transactions accessing at least one database object are disclosed. In one aspect, the method may include providing a storage area of a particular size to store data for a plurality of groups corresponding to the at least one database object. Each of the plurality of groups corresponds to a particular time interval. The method includes placing each of the currently active transactions in a group of the plurality of groups based upon a time of a first access of the at least one database object by each of the currently active transactions and the particular time interval. The method also includes storing a group first access time for the group. The group first access time corresponds to the earliest first access time for any of the currently active transactions in the group. The method may also include defining the object's first, or earliest access time, to be the earliest group first access time for currently active groups.</abstract><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | |
| ispartof | |
| issn | |
| language | eng |
| recordid | cdi_epo_espacenet_US7647296B2 |
| source | esp@cenet |
| subjects | CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS |
| title | Method for estimating a first access time of transactions accessing a database object |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-17T14%3A23%3A50IST&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=LYLE%20ROBERT%20W&rft.date=2010-01-12&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS7647296B2%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 |