A database system for viewing effects of changes to a index for a query optimization plan

A database system for viewing effects of changes to a index for a query optimization plan

A method and apparatus for viewing the effect of changes to an index for a database table on an optimization plan for a database query, such as an SQL statement. A virtual table is created which mimics the structure of an original table on the database. The virtual table is created by copying the or...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: HUNG-VUONG. VO, EDWARD. KOSCIUSZKO, SREEKUMAR. MENON
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 HUNG-VUONG. VO
EDWARD. KOSCIUSZKO
SREEKUMAR. MENON
description A method and apparatus for viewing the effect of changes to an index for a database table on an optimization plan for a database query, such as an SQL statement. A virtual table is created which mimics the structure of an original table on the database. The virtual table is created by copying the original table, excluding any data in the original table. Any existing original indexes associated with original table are copied to define a virtual index associated with the virtual table. References in the query to the original table are replaced with references to the virtual table. The database management system then determines a new optimization plan for the query.
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_CN1361890A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>CN1361890A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_CN1361890A3</originalsourceid><addsrcrecordid>eNqFyj0KwkAQBtBtLEQ9g3MBwRAQLUNQrKxsrMK4-TZZSHbXzPgTTy-IvdVr3tRcCqpZ-coCklEUPbk40MPj6UNDcA5WhaIj23JoIKSRmHyo8fpOptsdw0gxqe_9m9XHQKnjMDcTx51g8XNmlof9uTyukGIFSWwRoFV5yvJNtt2ti_z_-ACkxDlJ</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>A database system for viewing effects of changes to a index for a query optimization plan</title><source>esp@cenet</source><creator>HUNG-VUONG. VO ; EDWARD. KOSCIUSZKO ; SREEKUMAR. MENON</creator><creatorcontrib>HUNG-VUONG. VO ; EDWARD. KOSCIUSZKO ; SREEKUMAR. MENON</creatorcontrib><description>A method and apparatus for viewing the effect of changes to an index for a database table on an optimization plan for a database query, such as an SQL statement. A virtual table is created which mimics the structure of an original table on the database. The virtual table is created by copying the original table, excluding any data in the original table. Any existing original indexes associated with original table are copied to define a virtual index associated with the virtual table. References in the query to the original table are replaced with references to the virtual table. The database management system then determines a new optimization plan for the query.</description><edition>7</edition><language>eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2002</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&amp;date=20020731&amp;DB=EPODOC&amp;CC=CN&amp;NR=1361890A$$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&amp;date=20020731&amp;DB=EPODOC&amp;CC=CN&amp;NR=1361890A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>HUNG-VUONG. VO</creatorcontrib><creatorcontrib>EDWARD. KOSCIUSZKO</creatorcontrib><creatorcontrib>SREEKUMAR. MENON</creatorcontrib><title>A database system for viewing effects of changes to a index for a query optimization plan</title><description>A method and apparatus for viewing the effect of changes to an index for a database table on an optimization plan for a database query, such as an SQL statement. A virtual table is created which mimics the structure of an original table on the database. The virtual table is created by copying the original table, excluding any data in the original table. Any existing original indexes associated with original table are copied to define a virtual index associated with the virtual table. References in the query to the original table are replaced with references to the virtual table. The database management system then determines a new optimization plan for the query.</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>2002</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNqFyj0KwkAQBtBtLEQ9g3MBwRAQLUNQrKxsrMK4-TZZSHbXzPgTTy-IvdVr3tRcCqpZ-coCklEUPbk40MPj6UNDcA5WhaIj23JoIKSRmHyo8fpOptsdw0gxqe_9m9XHQKnjMDcTx51g8XNmlof9uTyukGIFSWwRoFV5yvJNtt2ti_z_-ACkxDlJ</recordid><startdate>20020731</startdate><enddate>20020731</enddate><creator>HUNG-VUONG. VO</creator><creator>EDWARD. KOSCIUSZKO</creator><creator>SREEKUMAR. MENON</creator><scope>EVB</scope></search><sort><creationdate>20020731</creationdate><title>A database system for viewing effects of changes to a index for a query optimization plan</title><author>HUNG-VUONG. VO ; EDWARD. KOSCIUSZKO ; SREEKUMAR. MENON</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_CN1361890A3</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>eng</language><creationdate>2002</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>HUNG-VUONG. VO</creatorcontrib><creatorcontrib>EDWARD. KOSCIUSZKO</creatorcontrib><creatorcontrib>SREEKUMAR. MENON</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>HUNG-VUONG. VO</au><au>EDWARD. KOSCIUSZKO</au><au>SREEKUMAR. MENON</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>A database system for viewing effects of changes to a index for a query optimization plan</title><date>2002-07-31</date><risdate>2002</risdate><abstract>A method and apparatus for viewing the effect of changes to an index for a database table on an optimization plan for a database query, such as an SQL statement. A virtual table is created which mimics the structure of an original table on the database. The virtual table is created by copying the original table, excluding any data in the original table. Any existing original indexes associated with original table are copied to define a virtual index associated with the virtual table. References in the query to the original table are replaced with references to the virtual table. The database management system then determines a new optimization plan for the query.</abstract><edition>7</edition><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language eng
recordid cdi_epo_espacenet_CN1361890A
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title A database system for viewing effects of changes to a index for a query optimization plan
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2024-12-26T11%3A31%3A58IST&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=HUNG-VUONG.%20VO&rft.date=2002-07-31&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3ECN1361890A%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