Skew-based costing for database queries
One embodiment is a method that determines skew to predict costs for query plans for a database query. The method selects a query plan that accounts for the skew to evenly distribute processing load among multiple processors and then executes the query with the selected query plan.
Gespeichert in:
| Hauptverfasser: | , , , |
|---|---|
| Format: | Patent |
| Sprache: | eng |
| 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 | Al-Omari, Awny K Kosuru, Ramakumar Varshneya, Renu Wall, Robert L |
| description | One embodiment is a method that determines skew to predict costs for query plans for a database query. The method selects a query plan that accounts for the skew to evenly distribute processing load among multiple processors and then executes the query with the selected query plan. |
| format | Patent |
| fullrecord | <record><control><sourceid>uspatents_EFH</sourceid><recordid>TN_cdi_uspatents_grants_08190598</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>08190598</sourcerecordid><originalsourceid>FETCH-uspatents_grants_081905983</originalsourceid><addsrcrecordid>eNrjZFAPzk4t101KLE5NUUjOLy7JzEtXSMsvUkhJLEkEiSoUlqYWZaYW8zCwpiXmFKfyQmluBgU31xBnD93S4oLEktS8kuL49KJEEGVgYWhpYGppYUyEEgBslCjD</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Skew-based costing for database queries</title><source>USPTO Issued Patents</source><creator>Al-Omari, Awny K ; Kosuru, Ramakumar ; Varshneya, Renu ; Wall, Robert L</creator><creatorcontrib>Al-Omari, Awny K ; Kosuru, Ramakumar ; Varshneya, Renu ; Wall, Robert L ; Hewlett-Packard Development Company, L.P</creatorcontrib><description>One embodiment is a method that determines skew to predict costs for query plans for a database query. The method selects a query plan that accounts for the skew to evenly distribute processing load among multiple processors and then executes the query with the selected query plan.</description><language>eng</language><creationdate>2012</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktopdf>$$Uhttps://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/8190598$$EPDF$$P50$$Guspatents$$Hfree_for_read</linktopdf><link.rule.ids>230,308,780,802,885,64039</link.rule.ids><linktorsrc>$$Uhttps://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/8190598$$EView_record_in_USPTO$$FView_record_in_$$GUSPTO$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>Al-Omari, Awny K</creatorcontrib><creatorcontrib>Kosuru, Ramakumar</creatorcontrib><creatorcontrib>Varshneya, Renu</creatorcontrib><creatorcontrib>Wall, Robert L</creatorcontrib><creatorcontrib>Hewlett-Packard Development Company, L.P</creatorcontrib><title>Skew-based costing for database queries</title><description>One embodiment is a method that determines skew to predict costs for query plans for a database query. The method selects a query plan that accounts for the skew to evenly distribute processing load among multiple processors and then executes the query with the selected query plan.</description><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2012</creationdate><recordtype>patent</recordtype><sourceid>EFH</sourceid><recordid>eNrjZFAPzk4t101KLE5NUUjOLy7JzEtXSMsvUkhJLEkEiSoUlqYWZaYW8zCwpiXmFKfyQmluBgU31xBnD93S4oLEktS8kuL49KJEEGVgYWhpYGppYUyEEgBslCjD</recordid><startdate>20120529</startdate><enddate>20120529</enddate><creator>Al-Omari, Awny K</creator><creator>Kosuru, Ramakumar</creator><creator>Varshneya, Renu</creator><creator>Wall, Robert L</creator><scope>EFH</scope></search><sort><creationdate>20120529</creationdate><title>Skew-based costing for database queries</title><author>Al-Omari, Awny K ; Kosuru, Ramakumar ; Varshneya, Renu ; Wall, Robert L</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-uspatents_grants_081905983</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2012</creationdate><toplevel>online_resources</toplevel><creatorcontrib>Al-Omari, Awny K</creatorcontrib><creatorcontrib>Kosuru, Ramakumar</creatorcontrib><creatorcontrib>Varshneya, Renu</creatorcontrib><creatorcontrib>Wall, Robert L</creatorcontrib><creatorcontrib>Hewlett-Packard Development Company, L.P</creatorcontrib><collection>USPTO Issued Patents</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Al-Omari, Awny K</au><au>Kosuru, Ramakumar</au><au>Varshneya, Renu</au><au>Wall, Robert L</au><aucorp>Hewlett-Packard Development Company, L.P</aucorp><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Skew-based costing for database queries</title><date>2012-05-29</date><risdate>2012</risdate><abstract>One embodiment is a method that determines skew to predict costs for query plans for a database query. The method selects a query plan that accounts for the skew to evenly distribute processing load among multiple processors and then executes the query with the selected query plan.</abstract><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | |
| ispartof | |
| issn | |
| language | eng |
| recordid | cdi_uspatents_grants_08190598 |
| source | USPTO Issued Patents |
| title | Skew-based costing for database queries |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-04T09%3A03%3A00IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-uspatents_EFH&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=Al-Omari,%20Awny%20K&rft.aucorp=Hewlett-Packard%20Development%20Company,%20L.P&rft.date=2012-05-29&rft_id=info:doi/&rft_dat=%3Cuspatents_EFH%3E08190598%3C/uspatents_EFH%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 |