Query optimization strategies for browsing sessions:
Abstract: "Optimization of isolated queries in relational systems is a proven and reasonably well-understood technology. This paper describes techniques and experiments to obtain response time improvement for a browsing session, i.e. a sequence of interrelated queries to locate a subset of inte...
Saved in:
| Main Authors: | , |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Amsterdam
1992
|
| Series: | Centrum voor Wiskunde en Informatica <Amsterdam> / Department of Computer Science: Report CS
92,68 |
| Subjects: | |
| Summary: | Abstract: "Optimization of isolated queries in relational systems is a proven and reasonably well-understood technology. This paper describes techniques and experiments to obtain response time improvement for a browsing session, i.e. a sequence of interrelated queries to locate a subset of interest. The optimization technique is based on a symbolic analysis of the query interdependencies and exploitation of (partial) query answers retained automatically. A prototype browsing session optimizer (BSO) has been constructed that runs as a front-end to the Ingres relational system. Based on the experiments reported, we propose to extend (existing) DBMSs with a mechanism to keep and reuse small answers by default Such investments quickly pay off in sessions with interrelated queries. Moreover, it is shown that our optimization techniques can outperform ad-hoc index construction and repetitive join evaluations that are already supported by an index. |
| Physical Description: | 16 S. |
Staff View
MARC
| LEADER | 00000nam a2200000 cb4500 | ||
|---|---|---|---|
| 001 | BV009033869 | ||
| 003 | DE-604 | ||
| 005 | 00000000000000.0 | ||
| 007 | t | ||
| 008 | 940227s1992 |||| 00||| eng d | ||
| 035 | |a (OCoLC)29452367 | ||
| 035 | |a (DE-599)BVBBV009033869 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-29T | ||
| 100 | 1 | |a Kersten, Martin L. |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Query optimization strategies for browsing sessions |c M. L. Kersten ; M. F. N. de Boer |
| 264 | 1 | |a Amsterdam |c 1992 | |
| 300 | |a 16 S. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 1 | |a Centrum voor Wiskunde en Informatica <Amsterdam> / Department of Computer Science: Report CS |v 92,68 | |
| 520 | 3 | |a Abstract: "Optimization of isolated queries in relational systems is a proven and reasonably well-understood technology. This paper describes techniques and experiments to obtain response time improvement for a browsing session, i.e. a sequence of interrelated queries to locate a subset of interest. The optimization technique is based on a symbolic analysis of the query interdependencies and exploitation of (partial) query answers retained automatically. A prototype browsing session optimizer (BSO) has been constructed that runs as a front-end to the Ingres relational system. Based on the experiments reported, we propose to extend (existing) DBMSs with a mechanism to keep and reuse small answers by default | |
| 520 | 3 | |a Such investments quickly pay off in sessions with interrelated queries. Moreover, it is shown that our optimization techniques can outperform ad-hoc index construction and repetitive join evaluations that are already supported by an index. | |
| 650 | 4 | |a Relational databases | |
| 700 | 1 | |a Boer, M. F. de |e Verfasser |4 aut | |
| 810 | 2 | |a Department of Computer Science: Report CS |t Centrum voor Wiskunde en Informatica <Amsterdam> |v 92,68 |w (DE-604)BV008928356 |9 92,68 | |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-005976657 | ||
Record in the Search Index
| _version_ | 1804123387371454464 |
|---|---|
| any_adam_object | |
| author | Kersten, Martin L. Boer, M. F. de |
| author_facet | Kersten, Martin L. Boer, M. F. de |
| author_role | aut aut |
| author_sort | Kersten, Martin L. |
| author_variant | m l k ml mlk m f d b mfd mfdb |
| building | Verbundindex |
| bvnumber | BV009033869 |
| ctrlnum | (OCoLC)29452367 (DE-599)BVBBV009033869 |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01997nam a2200313 cb4500</leader><controlfield tag="001">BV009033869</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">00000000000000.0</controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">940227s1992 |||| 00||| eng d</controlfield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)29452367</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV009033869</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakddb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-29T</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Kersten, Martin L.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Query optimization strategies for browsing sessions</subfield><subfield code="c">M. L. Kersten ; M. F. N. de Boer</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Amsterdam</subfield><subfield code="c">1992</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">16 S.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">Centrum voor Wiskunde en Informatica <Amsterdam> / Department of Computer Science: Report CS</subfield><subfield code="v">92,68</subfield></datafield><datafield tag="520" ind1="3" ind2=" "><subfield code="a">Abstract: "Optimization of isolated queries in relational systems is a proven and reasonably well-understood technology. This paper describes techniques and experiments to obtain response time improvement for a browsing session, i.e. a sequence of interrelated queries to locate a subset of interest. The optimization technique is based on a symbolic analysis of the query interdependencies and exploitation of (partial) query answers retained automatically. A prototype browsing session optimizer (BSO) has been constructed that runs as a front-end to the Ingres relational system. Based on the experiments reported, we propose to extend (existing) DBMSs with a mechanism to keep and reuse small answers by default</subfield></datafield><datafield tag="520" ind1="3" ind2=" "><subfield code="a">Such investments quickly pay off in sessions with interrelated queries. Moreover, it is shown that our optimization techniques can outperform ad-hoc index construction and repetitive join evaluations that are already supported by an index.</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Relational databases</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Boer, M. F. de</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="810" ind1="2" ind2=" "><subfield code="a">Department of Computer Science: Report CS</subfield><subfield code="t">Centrum voor Wiskunde en Informatica <Amsterdam></subfield><subfield code="v">92,68</subfield><subfield code="w">(DE-604)BV008928356</subfield><subfield code="9">92,68</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-005976657</subfield></datafield></record></collection> |
| id | DE-604.BV009033869 |
| illustrated | Not Illustrated |
| indexdate | 2024-07-09T17:28:58Z |
| institution | BVB |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-005976657 |
| oclc_num | 29452367 |
| open_access_boolean | |
| owner | DE-29T |
| owner_facet | DE-29T |
| physical | 16 S. |
| publishDate | 1992 |
| publishDateSearch | 1992 |
| publishDateSort | 1992 |
| record_format | marc |
| series2 | Centrum voor Wiskunde en Informatica <Amsterdam> / Department of Computer Science: Report CS |
| spelling | Kersten, Martin L. Verfasser aut Query optimization strategies for browsing sessions M. L. Kersten ; M. F. N. de Boer Amsterdam 1992 16 S. txt rdacontent n rdamedia nc rdacarrier Centrum voor Wiskunde en Informatica <Amsterdam> / Department of Computer Science: Report CS 92,68 Abstract: "Optimization of isolated queries in relational systems is a proven and reasonably well-understood technology. This paper describes techniques and experiments to obtain response time improvement for a browsing session, i.e. a sequence of interrelated queries to locate a subset of interest. The optimization technique is based on a symbolic analysis of the query interdependencies and exploitation of (partial) query answers retained automatically. A prototype browsing session optimizer (BSO) has been constructed that runs as a front-end to the Ingres relational system. Based on the experiments reported, we propose to extend (existing) DBMSs with a mechanism to keep and reuse small answers by default Such investments quickly pay off in sessions with interrelated queries. Moreover, it is shown that our optimization techniques can outperform ad-hoc index construction and repetitive join evaluations that are already supported by an index. Relational databases Boer, M. F. de Verfasser aut Department of Computer Science: Report CS Centrum voor Wiskunde en Informatica <Amsterdam> 92,68 (DE-604)BV008928356 92,68 |
| spellingShingle | Kersten, Martin L. Boer, M. F. de Query optimization strategies for browsing sessions Relational databases |
| title | Query optimization strategies for browsing sessions |
| title_auth | Query optimization strategies for browsing sessions |
| title_exact_search | Query optimization strategies for browsing sessions |
| title_full | Query optimization strategies for browsing sessions M. L. Kersten ; M. F. N. de Boer |
| title_fullStr | Query optimization strategies for browsing sessions M. L. Kersten ; M. F. N. de Boer |
| title_full_unstemmed | Query optimization strategies for browsing sessions M. L. Kersten ; M. F. N. de Boer |
| title_short | Query optimization strategies for browsing sessions |
| title_sort | query optimization strategies for browsing sessions |
| topic | Relational databases |
| topic_facet | Relational databases |
| volume_link | (DE-604)BV008928356 |
| work_keys_str_mv | AT kerstenmartinl queryoptimizationstrategiesforbrowsingsessions AT boermfde queryoptimizationstrategiesforbrowsingsessions |