Method for index tuning of a SQL statement, and index merging for a multi-statement SQL workload, using a cost-based relational query optimizer

An access structure analysis method is interspersed with the query optimization process. The method can determine the ideal combination of access structures, including both materialized views and indexes, for a given database workload. The interspersed structure analysis method can include advanced...

Ausführliche Beschreibung

Gespeichert in:

Bibliographische Detailangaben
Hauptverfasser:	ZIAUDDIN MOHAMED, SMITH GREGORY SCOTT, LAWANDE SHILPA
Format:	Patent
Sprache:	eng
Schlagworte:	CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS
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	ZIAUDDIN MOHAMED SMITH GREGORY SCOTT LAWANDE SHILPA
description	An access structure analysis method is interspersed with the query optimization process. The method can determine the ideal combination of access structures, including both materialized views and indexes, for a given database workload. The interspersed structure analysis method can include advanced transformations like view merging, star transformation, bitmap access plans, query rewrite using materialized views, for example. The method may be performed using the query optimizer's rules as heuristics to guide the index candidate generation process.
format	Patent
fullrecord	<record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_US8825629B2</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>US8825629B2</sourcerecordid><originalsourceid>FETCH-epo_espacenet_US8825629B23</originalsourceid><addsrcrecordid>eNqNyz0OgkAQQGEaC6PeYQ4ADUaDrUZjoYVBazKyA25cdnB3Nv5cwisbDLG2es33htF7T3JhBRU70FbRAyRYbWvgChDyww68oFBDVmJAq3rUkKs71W0ITTCikx_8bnd2V8OoYgi-kwgle0nO6EmBI4Oi2aKBWyD3BG5FN_pFbhwNKjSeJn1HEWzWx9U2oZYL8i2WZEmKU55l6WyeLpbp9A_yAbIBTaw</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Method for index tuning of a SQL statement, and index merging for a multi-statement SQL workload, using a cost-based relational query optimizer</title><source>esp@cenet</source><creator>ZIAUDDIN MOHAMED ; SMITH GREGORY SCOTT ; LAWANDE SHILPA</creator><creatorcontrib>ZIAUDDIN MOHAMED ; SMITH GREGORY SCOTT ; LAWANDE SHILPA</creatorcontrib><description>An access structure analysis method is interspersed with the query optimization process. The method can determine the ideal combination of access structures, including both materialized views and indexes, for a given database workload. The interspersed structure analysis method can include advanced transformations like view merging, star transformation, bitmap access plans, query rewrite using materialized views, for example. The method may be performed using the query optimizer's rules as heuristics to guide the index candidate generation process.</description><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2014</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=20140902&DB=EPODOC&CC=US&NR=8825629B2$$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=20140902&DB=EPODOC&CC=US&NR=8825629B2$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>ZIAUDDIN MOHAMED</creatorcontrib><creatorcontrib>SMITH GREGORY SCOTT</creatorcontrib><creatorcontrib>LAWANDE SHILPA</creatorcontrib><title>Method for index tuning of a SQL statement, and index merging for a multi-statement SQL workload, using a cost-based relational query optimizer</title><description>An access structure analysis method is interspersed with the query optimization process. The method can determine the ideal combination of access structures, including both materialized views and indexes, for a given database workload. The interspersed structure analysis method can include advanced transformations like view merging, star transformation, bitmap access plans, query rewrite using materialized views, for example. The method may be performed using the query optimizer's rules as heuristics to guide the index candidate generation process.</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>2014</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNqNyz0OgkAQQGEaC6PeYQ4ADUaDrUZjoYVBazKyA25cdnB3Nv5cwisbDLG2es33htF7T3JhBRU70FbRAyRYbWvgChDyww68oFBDVmJAq3rUkKs71W0ITTCikx_8bnd2V8OoYgi-kwgle0nO6EmBI4Oi2aKBWyD3BG5FN_pFbhwNKjSeJn1HEWzWx9U2oZYL8i2WZEmKU55l6WyeLpbp9A_yAbIBTaw</recordid><startdate>20140902</startdate><enddate>20140902</enddate><creator>ZIAUDDIN MOHAMED</creator><creator>SMITH GREGORY SCOTT</creator><creator>LAWANDE SHILPA</creator><scope>EVB</scope></search><sort><creationdate>20140902</creationdate><title>Method for index tuning of a SQL statement, and index merging for a multi-statement SQL workload, using a cost-based relational query optimizer</title><author>ZIAUDDIN MOHAMED ; SMITH GREGORY SCOTT ; LAWANDE SHILPA</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_US8825629B23</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2014</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>ZIAUDDIN MOHAMED</creatorcontrib><creatorcontrib>SMITH GREGORY SCOTT</creatorcontrib><creatorcontrib>LAWANDE SHILPA</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>ZIAUDDIN MOHAMED</au><au>SMITH GREGORY SCOTT</au><au>LAWANDE SHILPA</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Method for index tuning of a SQL statement, and index merging for a multi-statement SQL workload, using a cost-based relational query optimizer</title><date>2014-09-02</date><risdate>2014</risdate><abstract>An access structure analysis method is interspersed with the query optimization process. The method can determine the ideal combination of access structures, including both materialized views and indexes, for a given database workload. The interspersed structure analysis method can include advanced transformations like view merging, star transformation, bitmap access plans, query rewrite using materialized views, for example. The method may be performed using the query optimizer's rules as heuristics to guide the index candidate generation process.</abstract><oa>free_for_read</oa></addata></record>
fulltext	fulltext_linktorsrc
identifier
ispartof
issn
language	eng
recordid	cdi_epo_espacenet_US8825629B2
source	esp@cenet
subjects	CALCULATING COMPUTING COUNTING ELECTRIC DIGITAL DATA PROCESSING PHYSICS
title	Method for index tuning of a SQL statement, and index merging for a multi-statement SQL workload, using a cost-based relational query optimizer
url	https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2024-12-27T11%3A12%3A31IST&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=ZIAUDDIN%20MOHAMED&rft.date=2014-09-02&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3EUS8825629B2%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