Database calculation engine having forced filter pushdowns with dynamic joins
A query that requests a filter attribute is received by a database server from a remote application server that is associated with a calculation scenario that defines a data flow model including one or more calculation nodes. Subsequently, the database server instantiates the calculation scenario. A...
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 | Weyerhaeuser, Christoph Merx, Johannes Mindnich, Tobias |
| description | A query that requests a filter attribute is received by a database server from a remote application server that is associated with a calculation scenario that defines a data flow model including one or more calculation nodes. Subsequently, the database server instantiates the calculation scenario. As part of the instantiation, the calculation scenario is optimized by (i) pushing down a filter attribute from a first node to a lowest available child node, (ii) removing the filter attribute from the first node, and (iii) removing non-required join-attributes from the instantiated calculation scenarios. Thereafter, the operations defined by the calculation nodes of the instantiated calculation scenario can be executed to result in a responsive data set. Next, the data set is provided to the application server by the database server. |
| format | Patent |
| fullrecord | <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US10198475B2</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US10198475B2</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US10198475B23</originalsourceid><addsrcrecordid>eNqNyjsOwjAMANAuDAi4gzkAEuWjwspPLEzAXJnEaYyCE9UpFbdn4QBMb3nD4nLAjA9UAoPBdAEzRwGShoXA45ulARdbQxYch0wtpE69jb0o9Jw92I_giw08I4uOi4HDoDT5OSqmp-Ntf55RijVpQkNCub5fy3m53ayq9W6x_Od8AQ0hNs0</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Database calculation engine having forced filter pushdowns with dynamic joins</title><source>esp@cenet</source><creator>Weyerhaeuser, Christoph ; Merx, Johannes ; Mindnich, Tobias</creator><creatorcontrib>Weyerhaeuser, Christoph ; Merx, Johannes ; Mindnich, Tobias</creatorcontrib><description>A query that requests a filter attribute is received by a database server from a remote application server that is associated with a calculation scenario that defines a data flow model including one or more calculation nodes. Subsequently, the database server instantiates the calculation scenario. As part of the instantiation, the calculation scenario is optimized by (i) pushing down a filter attribute from a first node to a lowest available child node, (ii) removing the filter attribute from the first node, and (iii) removing non-required join-attributes from the instantiated calculation scenarios. Thereafter, the operations defined by the calculation nodes of the instantiated calculation scenario can be executed to result in a responsive data set. Next, the data set is provided to the application server by the database server.</description><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2019</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=20190205&DB=EPODOC&CC=US&NR=10198475B2$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,780,885,25564,76547</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&date=20190205&DB=EPODOC&CC=US&NR=10198475B2$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>Weyerhaeuser, Christoph</creatorcontrib><creatorcontrib>Merx, Johannes</creatorcontrib><creatorcontrib>Mindnich, Tobias</creatorcontrib><title>Database calculation engine having forced filter pushdowns with dynamic joins</title><description>A query that requests a filter attribute is received by a database server from a remote application server that is associated with a calculation scenario that defines a data flow model including one or more calculation nodes. Subsequently, the database server instantiates the calculation scenario. As part of the instantiation, the calculation scenario is optimized by (i) pushing down a filter attribute from a first node to a lowest available child node, (ii) removing the filter attribute from the first node, and (iii) removing non-required join-attributes from the instantiated calculation scenarios. Thereafter, the operations defined by the calculation nodes of the instantiated calculation scenario can be executed to result in a responsive data set. Next, the data set is provided to the application server by the database server.</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>2019</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNqNyjsOwjAMANAuDAi4gzkAEuWjwspPLEzAXJnEaYyCE9UpFbdn4QBMb3nD4nLAjA9UAoPBdAEzRwGShoXA45ulARdbQxYch0wtpE69jb0o9Jw92I_giw08I4uOi4HDoDT5OSqmp-Ntf55RijVpQkNCub5fy3m53ayq9W6x_Od8AQ0hNs0</recordid><startdate>20190205</startdate><enddate>20190205</enddate><creator>Weyerhaeuser, Christoph</creator><creator>Merx, Johannes</creator><creator>Mindnich, Tobias</creator><scope>EVB</scope></search><sort><creationdate>20190205</creationdate><title>Database calculation engine having forced filter pushdowns with dynamic joins</title><author>Weyerhaeuser, Christoph ; Merx, Johannes ; Mindnich, Tobias</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US10198475B23</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2019</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>Weyerhaeuser, Christoph</creatorcontrib><creatorcontrib>Merx, Johannes</creatorcontrib><creatorcontrib>Mindnich, Tobias</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Weyerhaeuser, Christoph</au><au>Merx, Johannes</au><au>Mindnich, Tobias</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Database calculation engine having forced filter pushdowns with dynamic joins</title><date>2019-02-05</date><risdate>2019</risdate><abstract>A query that requests a filter attribute is received by a database server from a remote application server that is associated with a calculation scenario that defines a data flow model including one or more calculation nodes. Subsequently, the database server instantiates the calculation scenario. As part of the instantiation, the calculation scenario is optimized by (i) pushing down a filter attribute from a first node to a lowest available child node, (ii) removing the filter attribute from the first node, and (iii) removing non-required join-attributes from the instantiated calculation scenarios. Thereafter, the operations defined by the calculation nodes of the instantiated calculation scenario can be executed to result in a responsive data set. Next, the data set is provided to the application server by the database server.</abstract><oa>free_for_read</oa></addata></record> |
| fulltext | fulltext_linktorsrc |
| identifier | |
| ispartof | |
| issn | |
| language | eng |
| recordid | cdi_epo_espacenet_US10198475B2 |
| source | esp@cenet |
| subjects | CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS |
| title | Database calculation engine having forced filter pushdowns with dynamic joins |
| url | https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2024-12-31T23%3A57%3A49IST&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=Weyerhaeuser,%20Christoph&rft.date=2019-02-05&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS10198475B2%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 |