Some Modifications of Bucket-Based Algorithms for Query Rewriting Using Views

Query rewriting using views is an important topic in data integration. A number of rewriting algorithms, such as the SVB algorithm, the MiniCon algorithm and the inverse rules algorithm, have been developed. All the algorithms can generate a maximally-contained rewriting of a given query, which is t...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Veröffentlicht in:Advances in Information Systems 2004-01, p.57-67
Hauptverfasser: Bai, Qingyuan, Hong, Jun, McTear, Michael F.
Format: Artikel
Sprache:eng
Schlagworte:
Online-Zugang:Volltext
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
container_end_page 67
container_issue
container_start_page 57
container_title Advances in Information Systems
container_volume
creator Bai, Qingyuan
Hong, Jun
McTear, Michael F.
description Query rewriting using views is an important topic in data integration. A number of rewriting algorithms, such as the SVB algorithm, the MiniCon algorithm and the inverse rules algorithm, have been developed. All the algorithms can generate a maximally-contained rewriting of a given query, which is the union of a set of conjunctive rewritings contained in the given query. In this paper, we first argue that the condition for forming a shared-variable bucket in the SVB algorithm can be modified in the case where a shared variable in a query is mapped to a distinguished variable that is also a join attribute in a view. Under the modified condition, we may create more shared-variable buckets so that fewer rewritings can be generated than the SVB algorithm. Second, the SVB algorithm does not handle a constant in a view properly in the case where a shared variable of a query is mapped to a constant of a view. We propose to use a pseudo shared-variable bucket to address this issue. The only difference between the SVB algorithm and the MiniCon algorithm is that the latter considers a head homomorphism on a view. However, the head homomorphism on a view is not related to the condition we intend to modify in this paper. The modifications we present are also applicable to the MiniCon algorithm.
doi_str_mv 10.1007/978-3-540-30198-1_7
format Article
fullrecord <record><control><sourceid>pascalfrancis_sprin</sourceid><recordid>TN_cdi_pascalfrancis_primary_16368501</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>16368501</sourcerecordid><originalsourceid>FETCH-LOGICAL-p227t-6e5dac5674540479ddba7724db076cae09befc967a8e85b204b9bfe48b7d4a7c3</originalsourceid><addsrcrecordid>eNotkElvwjAQhd1NKqX8gl586dGtHTuxfYSqmwSqutCr5S3UBWIUByH-fR3oHGY0bz6Nnh4ANwTfEYz5veQCUVQyjCgmUiCi-Am4olk47OwUDEhFCKKUyTMwynh_Kyjjgp2DQaYKJDmjl2CU0i_uSwpB2ADMPuPaw1l0oQ5WdyE2CcYaTrZ26Ts00ck7OF4tYhu6n3WCdWzh-9a3e_jhd1kLzQLOU9-_g9-la3BR61Xyo_85BPOnx6-HFzR9e359GE_Rpih4hypfOm3LirPsknHpnNGcF8wZzCurPZbG11ZWXAsvSlNgZqSpPROGO6a5pUNwe_y70cnqVd3qxoakNm1Y63avSEUrUWKSOXLkUj41C98qE-MyKYJVn6vKQSmqsgl1yFHlXOkfuS1mfQ</addsrcrecordid><sourcetype>Index Database</sourcetype><iscdi>true</iscdi><recordtype>article</recordtype></control><display><type>article</type><title>Some Modifications of Bucket-Based Algorithms for Query Rewriting Using Views</title><source>Springer Books</source><creator>Bai, Qingyuan ; Hong, Jun ; McTear, Michael F.</creator><contributor>Yakhno, Tatyana</contributor><creatorcontrib>Bai, Qingyuan ; Hong, Jun ; McTear, Michael F. ; Yakhno, Tatyana</creatorcontrib><description>Query rewriting using views is an important topic in data integration. A number of rewriting algorithms, such as the SVB algorithm, the MiniCon algorithm and the inverse rules algorithm, have been developed. All the algorithms can generate a maximally-contained rewriting of a given query, which is the union of a set of conjunctive rewritings contained in the given query. In this paper, we first argue that the condition for forming a shared-variable bucket in the SVB algorithm can be modified in the case where a shared variable in a query is mapped to a distinguished variable that is also a join attribute in a view. Under the modified condition, we may create more shared-variable buckets so that fewer rewritings can be generated than the SVB algorithm. Second, the SVB algorithm does not handle a constant in a view properly in the case where a shared variable of a query is mapped to a constant of a view. We propose to use a pseudo shared-variable bucket to address this issue. The only difference between the SVB algorithm and the MiniCon algorithm is that the latter considers a head homomorphism on a view. However, the head homomorphism on a view is not related to the condition we intend to modify in this paper. The modifications we present are also applicable to the MiniCon algorithm.</description><identifier>ISSN: 0302-9743</identifier><identifier>ISBN: 9783540234784</identifier><identifier>ISBN: 3540234780</identifier><identifier>EISSN: 1611-3349</identifier><identifier>EISBN: 3540301984</identifier><identifier>EISBN: 9783540301981</identifier><identifier>DOI: 10.1007/978-3-540-30198-1_7</identifier><language>eng</language><publisher>Berlin, Heidelberg: Springer Berlin Heidelberg</publisher><subject>Applied sciences ; Computer science; control theory; systems ; Exact sciences and technology ; Information systems. Data bases ; Memory organisation. Data processing ; Software</subject><ispartof>Advances in Information Systems, 2004-01, p.57-67</ispartof><rights>Springer-Verlag Berlin Heidelberg 2004</rights><rights>2005 INIST-CNRS</rights><lds50>peer_reviewed</lds50><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktopdf>$$Uhttps://link.springer.com/content/pdf/10.1007/978-3-540-30198-1_7$$EPDF$$P50$$Gspringer$$H</linktopdf><linktohtml>$$Uhttps://link.springer.com/10.1007/978-3-540-30198-1_7$$EHTML$$P50$$Gspringer$$H</linktohtml><link.rule.ids>309,310,779,780,784,789,790,793,27925,38255,41442,42511</link.rule.ids><backlink>$$Uhttp://pascal-francis.inist.fr/vibad/index.php?action=getRecordDetail&amp;idt=16368501$$DView record in Pascal Francis$$Hfree_for_read</backlink></links><search><contributor>Yakhno, Tatyana</contributor><creatorcontrib>Bai, Qingyuan</creatorcontrib><creatorcontrib>Hong, Jun</creatorcontrib><creatorcontrib>McTear, Michael F.</creatorcontrib><title>Some Modifications of Bucket-Based Algorithms for Query Rewriting Using Views</title><title>Advances in Information Systems</title><description>Query rewriting using views is an important topic in data integration. A number of rewriting algorithms, such as the SVB algorithm, the MiniCon algorithm and the inverse rules algorithm, have been developed. All the algorithms can generate a maximally-contained rewriting of a given query, which is the union of a set of conjunctive rewritings contained in the given query. In this paper, we first argue that the condition for forming a shared-variable bucket in the SVB algorithm can be modified in the case where a shared variable in a query is mapped to a distinguished variable that is also a join attribute in a view. Under the modified condition, we may create more shared-variable buckets so that fewer rewritings can be generated than the SVB algorithm. Second, the SVB algorithm does not handle a constant in a view properly in the case where a shared variable of a query is mapped to a constant of a view. We propose to use a pseudo shared-variable bucket to address this issue. The only difference between the SVB algorithm and the MiniCon algorithm is that the latter considers a head homomorphism on a view. However, the head homomorphism on a view is not related to the condition we intend to modify in this paper. The modifications we present are also applicable to the MiniCon algorithm.</description><subject>Applied sciences</subject><subject>Computer science; control theory; systems</subject><subject>Exact sciences and technology</subject><subject>Information systems. Data bases</subject><subject>Memory organisation. Data processing</subject><subject>Software</subject><issn>0302-9743</issn><issn>1611-3349</issn><isbn>9783540234784</isbn><isbn>3540234780</isbn><isbn>3540301984</isbn><isbn>9783540301981</isbn><fulltext>true</fulltext><rsrctype>article</rsrctype><creationdate>2004</creationdate><recordtype>article</recordtype><recordid>eNotkElvwjAQhd1NKqX8gl586dGtHTuxfYSqmwSqutCr5S3UBWIUByH-fR3oHGY0bz6Nnh4ANwTfEYz5veQCUVQyjCgmUiCi-Am4olk47OwUDEhFCKKUyTMwynh_Kyjjgp2DQaYKJDmjl2CU0i_uSwpB2ADMPuPaw1l0oQ5WdyE2CcYaTrZ26Ts00ck7OF4tYhu6n3WCdWzh-9a3e_jhd1kLzQLOU9-_g9-la3BR61Xyo_85BPOnx6-HFzR9e359GE_Rpih4hypfOm3LirPsknHpnNGcF8wZzCurPZbG11ZWXAsvSlNgZqSpPROGO6a5pUNwe_y70cnqVd3qxoakNm1Y63avSEUrUWKSOXLkUj41C98qE-MyKYJVn6vKQSmqsgl1yFHlXOkfuS1mfQ</recordid><startdate>20040101</startdate><enddate>20040101</enddate><creator>Bai, Qingyuan</creator><creator>Hong, Jun</creator><creator>McTear, Michael F.</creator><general>Springer Berlin Heidelberg</general><general>Springer</general><scope>IQODW</scope></search><sort><creationdate>20040101</creationdate><title>Some Modifications of Bucket-Based Algorithms for Query Rewriting Using Views</title><author>Bai, Qingyuan ; Hong, Jun ; McTear, Michael F.</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-LOGICAL-p227t-6e5dac5674540479ddba7724db076cae09befc967a8e85b204b9bfe48b7d4a7c3</frbrgroupid><rsrctype>articles</rsrctype><prefilter>articles</prefilter><language>eng</language><creationdate>2004</creationdate><topic>Applied sciences</topic><topic>Computer science; control theory; systems</topic><topic>Exact sciences and technology</topic><topic>Information systems. Data bases</topic><topic>Memory organisation. Data processing</topic><topic>Software</topic><toplevel>peer_reviewed</toplevel><toplevel>online_resources</toplevel><creatorcontrib>Bai, Qingyuan</creatorcontrib><creatorcontrib>Hong, Jun</creatorcontrib><creatorcontrib>McTear, Michael F.</creatorcontrib><collection>Pascal-Francis</collection><jtitle>Advances in Information Systems</jtitle></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext</fulltext></delivery><addata><au>Bai, Qingyuan</au><au>Hong, Jun</au><au>McTear, Michael F.</au><au>Yakhno, Tatyana</au><format>journal</format><genre>article</genre><ristype>JOUR</ristype><atitle>Some Modifications of Bucket-Based Algorithms for Query Rewriting Using Views</atitle><jtitle>Advances in Information Systems</jtitle><date>2004-01-01</date><risdate>2004</risdate><spage>57</spage><epage>67</epage><pages>57-67</pages><issn>0302-9743</issn><eissn>1611-3349</eissn><isbn>9783540234784</isbn><isbn>3540234780</isbn><eisbn>3540301984</eisbn><eisbn>9783540301981</eisbn><abstract>Query rewriting using views is an important topic in data integration. A number of rewriting algorithms, such as the SVB algorithm, the MiniCon algorithm and the inverse rules algorithm, have been developed. All the algorithms can generate a maximally-contained rewriting of a given query, which is the union of a set of conjunctive rewritings contained in the given query. In this paper, we first argue that the condition for forming a shared-variable bucket in the SVB algorithm can be modified in the case where a shared variable in a query is mapped to a distinguished variable that is also a join attribute in a view. Under the modified condition, we may create more shared-variable buckets so that fewer rewritings can be generated than the SVB algorithm. Second, the SVB algorithm does not handle a constant in a view properly in the case where a shared variable of a query is mapped to a constant of a view. We propose to use a pseudo shared-variable bucket to address this issue. The only difference between the SVB algorithm and the MiniCon algorithm is that the latter considers a head homomorphism on a view. However, the head homomorphism on a view is not related to the condition we intend to modify in this paper. The modifications we present are also applicable to the MiniCon algorithm.</abstract><cop>Berlin, Heidelberg</cop><pub>Springer Berlin Heidelberg</pub><doi>10.1007/978-3-540-30198-1_7</doi><tpages>11</tpages></addata></record>
fulltext fulltext
identifier ISSN: 0302-9743
ispartof Advances in Information Systems, 2004-01, p.57-67
issn 0302-9743
1611-3349
language eng
recordid cdi_pascalfrancis_primary_16368501
source Springer Books
subjects Applied sciences
Computer science
control theory
systems
Exact sciences and technology
Information systems. Data bases
Memory organisation. Data processing
Software
title Some Modifications of Bucket-Based Algorithms for Query Rewriting Using Views
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-01-01T04%3A10%3A38IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-pascalfrancis_sprin&rft_val_fmt=info:ofi/fmt:kev:mtx:journal&rft.genre=article&rft.atitle=Some%20Modifications%20of%20Bucket-Based%20Algorithms%20for%20Query%20Rewriting%20Using%20Views&rft.jtitle=Advances%20in%20Information%20Systems&rft.au=Bai,%20Qingyuan&rft.date=2004-01-01&rft.spage=57&rft.epage=67&rft.pages=57-67&rft.issn=0302-9743&rft.eissn=1611-3349&rft.isbn=9783540234784&rft.isbn_list=3540234780&rft_id=info:doi/10.1007/978-3-540-30198-1_7&rft_dat=%3Cpascalfrancis_sprin%3E16368501%3C/pascalfrancis_sprin%3E%3Curl%3E%3C/url%3E&rft.eisbn=3540301984&rft.eisbn_list=9783540301981&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true