Method and apparatus for projecting the effect of maintaining an auxiliary database structure for use in executing database queries

Method and apparatus for projecting the effect of maintaining an auxiliary database structure for use in executing database queries

A database management system maintains a record of queries which can be executed against the database. For a given auxiliary database structure, an advisory function automatically reviews the query record and identifies those queries which might execute with greater efficiency using the auxiliary da...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: Bestgen, Robert Joseph, Flanagan, James Michael, Pfeifer, Michael Donald
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 Bestgen, Robert Joseph
Flanagan, James Michael
Pfeifer, Michael Donald
description A database management system maintains a record of queries which can be executed against the database. For a given auxiliary database structure, an advisory function automatically reviews the query record and identifies those queries which might execute with greater efficiency using the auxiliary database structure, presenting analytical information to the user. Preferably, the auxiliary database structure is an index, and the information is used for determining whether to include the index in the database definition. Preferably, a query optimizer records potentially useful indexes when considering multiple alternative database optimizations, and this information is later retrieved to identify queries which would benefit from an index.
format Patent
fullrecord <record><control><sourceid>uspatents_EFH</sourceid><recordid>TN_cdi_uspatents_grants_07743052</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>07743052</sourcerecordid><originalsourceid>FETCH-uspatents_grants_077430523</originalsourceid><addsrcrecordid>eNqNjE0KwjAQhbtxIeod5gJCsUoPIIobd-5lTCdtpCZxMgN17cVNi7h28Xi8H7558T6TdKEB9FkxIqNoAhsYIoc7GXG-BekIyNqcIFh4oPOSNS7oAXVwvUN-QYOCN0wESViNKNME0tw4DzSQ0Qn3-z2V2FFaFjOLfaLV1xcFHA-X_WmtKaKQl3RtGUcr63pblbtN9cflA_sbS7o</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Method and apparatus for projecting the effect of maintaining an auxiliary database structure for use in executing database queries</title><source>USPTO Issued Patents</source><creator>Bestgen, Robert Joseph ; Flanagan, James Michael ; Pfeifer, Michael Donald</creator><creatorcontrib>Bestgen, Robert Joseph ; Flanagan, James Michael ; Pfeifer, Michael Donald ; International Business Machines Corporation</creatorcontrib><description>A database management system maintains a record of queries which can be executed against the database. For a given auxiliary database structure, an advisory function automatically reviews the query record and identifies those queries which might execute with greater efficiency using the auxiliary database structure, presenting analytical information to the user. Preferably, the auxiliary database structure is an index, and the information is used for determining whether to include the index in the database definition. Preferably, a query optimizer records potentially useful indexes when considering multiple alternative database optimizations, and this information is later retrieved to identify queries which would benefit from an index.</description><language>eng</language><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><linktopdf>$$Uhttps://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/7743052$$EPDF$$P50$$Guspatents$$Hfree_for_read</linktopdf><link.rule.ids>230,308,776,798,881,64012</link.rule.ids><linktorsrc>$$Uhttps://image-ppubs.uspto.gov/dirsearch-public/print/downloadPdf/7743052$$EView_record_in_USPTO$$FView_record_in_$$GUSPTO$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>Bestgen, Robert Joseph</creatorcontrib><creatorcontrib>Flanagan, James Michael</creatorcontrib><creatorcontrib>Pfeifer, Michael Donald</creatorcontrib><creatorcontrib>International Business Machines Corporation</creatorcontrib><title>Method and apparatus for projecting the effect of maintaining an auxiliary database structure for use in executing database queries</title><description>A database management system maintains a record of queries which can be executed against the database. For a given auxiliary database structure, an advisory function automatically reviews the query record and identifies those queries which might execute with greater efficiency using the auxiliary database structure, presenting analytical information to the user. Preferably, the auxiliary database structure is an index, and the information is used for determining whether to include the index in the database definition. Preferably, a query optimizer records potentially useful indexes when considering multiple alternative database optimizations, and this information is later retrieved to identify queries which would benefit from an index.</description><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2010</creationdate><recordtype>patent</recordtype><sourceid>EFH</sourceid><recordid>eNqNjE0KwjAQhbtxIeod5gJCsUoPIIobd-5lTCdtpCZxMgN17cVNi7h28Xi8H7558T6TdKEB9FkxIqNoAhsYIoc7GXG-BekIyNqcIFh4oPOSNS7oAXVwvUN-QYOCN0wESViNKNME0tw4DzSQ0Qn3-z2V2FFaFjOLfaLV1xcFHA-X_WmtKaKQl3RtGUcr63pblbtN9cflA_sbS7o</recordid><startdate>20100622</startdate><enddate>20100622</enddate><creator>Bestgen, Robert Joseph</creator><creator>Flanagan, James Michael</creator><creator>Pfeifer, Michael Donald</creator><scope>EFH</scope></search><sort><creationdate>20100622</creationdate><title>Method and apparatus for projecting the effect of maintaining an auxiliary database structure for use in executing database queries</title><author>Bestgen, Robert Joseph ; Flanagan, James Michael ; Pfeifer, Michael Donald</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-uspatents_grants_077430523</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2010</creationdate><toplevel>online_resources</toplevel><creatorcontrib>Bestgen, Robert Joseph</creatorcontrib><creatorcontrib>Flanagan, James Michael</creatorcontrib><creatorcontrib>Pfeifer, Michael Donald</creatorcontrib><creatorcontrib>International Business Machines Corporation</creatorcontrib><collection>USPTO Issued Patents</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>Bestgen, Robert Joseph</au><au>Flanagan, James Michael</au><au>Pfeifer, Michael Donald</au><aucorp>International Business Machines Corporation</aucorp><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Method and apparatus for projecting the effect of maintaining an auxiliary database structure for use in executing database queries</title><date>2010-06-22</date><risdate>2010</risdate><abstract>A database management system maintains a record of queries which can be executed against the database. For a given auxiliary database structure, an advisory function automatically reviews the query record and identifies those queries which might execute with greater efficiency using the auxiliary database structure, presenting analytical information to the user. Preferably, the auxiliary database structure is an index, and the information is used for determining whether to include the index in the database definition. Preferably, a query optimizer records potentially useful indexes when considering multiple alternative database optimizations, and this information is later retrieved to identify queries which would benefit from an index.</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language eng
recordid cdi_uspatents_grants_07743052
source USPTO Issued Patents
title Method and apparatus for projecting the effect of maintaining an auxiliary database structure for use in executing 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-02-05T14%3A43%3A30IST&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=Bestgen,%20Robert%20Joseph&rft.aucorp=International%20Business%20Machines%20Corporation&rft.date=2010-06-22&rft_id=info:doi/&rft_dat=%3Cuspatents_EFH%3E07743052%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