ALLOCATION OF RESOURCES FOR CONCURRENT QUERY EXECUTION VIA ADAPTIVE SEGMENTATION
An enterprise data warehouse or business intelligence system having a plurality of processors and memory resources. The system includes at least a database server, a workload management system, a query compiler, and a query executor. The database server configured to receive a database query from an...
Gespeichert in:
| Hauptverfasser: | , , , , , , |
|---|---|
| Format: | Patent |
| Sprache: | eng ; fre ; ger |
| 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 | WEHRMEISTER, ROBERT, M SIDDIQUI, KASHIF, A FRIEDENBACH, PETER KAKARLAMUDI, SUBBARAO ZELLER, HANSJORG OMANSKI, ZBIGNIEW AL-OMARI, AWNY, K |
| description | An enterprise data warehouse or business intelligence system having a plurality of processors and memory resources. The system includes at least a database server, a workload management system, a query compiler, and a query executor. The database server configured to receive a database query from an application at a database client system. The query compiler configured to prepare the execution plan for the query and compute the number of executive server processes (ESPs) in each ESP layer of the query. The workload management system is configured to generate an affinity value, and the query executor is configured to execute the query. As disclosed herein, placement of the executive server process layers of the query onto processors of the computing system is determined using the affinity value. Other embodiments, aspects and features are also disclosed. |
| format | Patent |
| fullrecord | <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_EP2212806B1</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>EP2212806B1</sourcerecordid><originalsourceid>FETCH-epo_espacenet_EP2212806B13</originalsourceid><addsrcrecordid>eNrjZAhw9PHxd3YM8fT3U_B3UwhyDfYPDXJ2DVZw8w9ScPb3cw4NCnL1C1EIDHUNilRwjXB1DgWrDfN0VHB0cQwI8QxzVQh2dfcFKgKbwsPAmpaYU5zKC6W5GRTcXEOcPXRTC_LjU4sLEpNT81JL4l0DjIwMjSwMzJwMjYlQAgBNUC8R</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>ALLOCATION OF RESOURCES FOR CONCURRENT QUERY EXECUTION VIA ADAPTIVE SEGMENTATION</title><source>esp@cenet</source><creator>WEHRMEISTER, ROBERT, M ; SIDDIQUI, KASHIF, A ; FRIEDENBACH, PETER ; KAKARLAMUDI, SUBBARAO ; ZELLER, HANSJORG ; OMANSKI, ZBIGNIEW ; AL-OMARI, AWNY, K</creator><creatorcontrib>WEHRMEISTER, ROBERT, M ; SIDDIQUI, KASHIF, A ; FRIEDENBACH, PETER ; KAKARLAMUDI, SUBBARAO ; ZELLER, HANSJORG ; OMANSKI, ZBIGNIEW ; AL-OMARI, AWNY, K</creatorcontrib><description>An enterprise data warehouse or business intelligence system having a plurality of processors and memory resources. The system includes at least a database server, a workload management system, a query compiler, and a query executor. The database server configured to receive a database query from an application at a database client system. The query compiler configured to prepare the execution plan for the query and compute the number of executive server processes (ESPs) in each ESP layer of the query. The workload management system is configured to generate an affinity value, and the query executor is configured to execute the query. As disclosed herein, placement of the executive server process layers of the query onto processors of the computing system is determined using the affinity value. Other embodiments, aspects and features are also disclosed.</description><language>eng ; fre ; ger</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><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><linktohtml>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20120627&DB=EPODOC&CC=EP&NR=2212806B1$$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=20120627&DB=EPODOC&CC=EP&NR=2212806B1$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>WEHRMEISTER, ROBERT, M</creatorcontrib><creatorcontrib>SIDDIQUI, KASHIF, A</creatorcontrib><creatorcontrib>FRIEDENBACH, PETER</creatorcontrib><creatorcontrib>KAKARLAMUDI, SUBBARAO</creatorcontrib><creatorcontrib>ZELLER, HANSJORG</creatorcontrib><creatorcontrib>OMANSKI, ZBIGNIEW</creatorcontrib><creatorcontrib>AL-OMARI, AWNY, K</creatorcontrib><title>ALLOCATION OF RESOURCES FOR CONCURRENT QUERY EXECUTION VIA ADAPTIVE SEGMENTATION</title><description>An enterprise data warehouse or business intelligence system having a plurality of processors and memory resources. The system includes at least a database server, a workload management system, a query compiler, and a query executor. The database server configured to receive a database query from an application at a database client system. The query compiler configured to prepare the execution plan for the query and compute the number of executive server processes (ESPs) in each ESP layer of the query. The workload management system is configured to generate an affinity value, and the query executor is configured to execute the query. As disclosed herein, placement of the executive server process layers of the query onto processors of the computing system is determined using the affinity value. Other embodiments, aspects and features are also disclosed.</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>2012</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZAhw9PHxd3YM8fT3U_B3UwhyDfYPDXJ2DVZw8w9ScPb3cw4NCnL1C1EIDHUNilRwjXB1DgWrDfN0VHB0cQwI8QxzVQh2dfcFKgKbwsPAmpaYU5zKC6W5GRTcXEOcPXRTC_LjU4sLEpNT81JL4l0DjIwMjSwMzJwMjYlQAgBNUC8R</recordid><startdate>20120627</startdate><enddate>20120627</enddate><creator>WEHRMEISTER, ROBERT, M</creator><creator>SIDDIQUI, KASHIF, A</creator><creator>FRIEDENBACH, PETER</creator><creator>KAKARLAMUDI, SUBBARAO</creator><creator>ZELLER, HANSJORG</creator><creator>OMANSKI, ZBIGNIEW</creator><creator>AL-OMARI, AWNY, K</creator><scope>EVB</scope></search><sort><creationdate>20120627</creationdate><title>ALLOCATION OF RESOURCES FOR CONCURRENT QUERY EXECUTION VIA ADAPTIVE SEGMENTATION</title><author>WEHRMEISTER, ROBERT, M ; SIDDIQUI, KASHIF, A ; FRIEDENBACH, PETER ; KAKARLAMUDI, SUBBARAO ; ZELLER, HANSJORG ; OMANSKI, ZBIGNIEW ; AL-OMARI, AWNY, K</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_EP2212806B13</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng ; fre ; ger</language><creationdate>2012</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>WEHRMEISTER, ROBERT, M</creatorcontrib><creatorcontrib>SIDDIQUI, KASHIF, A</creatorcontrib><creatorcontrib>FRIEDENBACH, PETER</creatorcontrib><creatorcontrib>KAKARLAMUDI, SUBBARAO</creatorcontrib><creatorcontrib>ZELLER, HANSJORG</creatorcontrib><creatorcontrib>OMANSKI, ZBIGNIEW</creatorcontrib><creatorcontrib>AL-OMARI, AWNY, K</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>WEHRMEISTER, ROBERT, M</au><au>SIDDIQUI, KASHIF, A</au><au>FRIEDENBACH, PETER</au><au>KAKARLAMUDI, SUBBARAO</au><au>ZELLER, HANSJORG</au><au>OMANSKI, ZBIGNIEW</au><au>AL-OMARI, AWNY, K</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>ALLOCATION OF RESOURCES FOR CONCURRENT QUERY EXECUTION VIA ADAPTIVE SEGMENTATION</title><date>2012-06-27</date><risdate>2012</risdate><abstract>An enterprise data warehouse or business intelligence system having a plurality of processors and memory resources. The system includes at least a database server, a workload management system, a query compiler, and a query executor. The database server configured to receive a database query from an application at a database client system. The query compiler configured to prepare the execution plan for the query and compute the number of executive server processes (ESPs) in each ESP layer of the query. The workload management system is configured to generate an affinity value, and the query executor is configured to execute the query. As disclosed herein, placement of the executive server process layers of the query onto processors of the computing system is determined using the affinity value. Other embodiments, aspects and features are also disclosed.</abstract><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | |
| ispartof | |
| issn | |
| language | eng ; fre ; ger |
| recordid | cdi_epo_espacenet_EP2212806B1 |
| source | esp@cenet |
| subjects | CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS |
| title | ALLOCATION OF RESOURCES FOR CONCURRENT QUERY EXECUTION VIA ADAPTIVE SEGMENTATION |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-14T03%3A03%3A01IST&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=WEHRMEISTER,%20ROBERT,%20M&rft.date=2012-06-27&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EEP2212806B1%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 |