Answering queries using views:
The topic of using views to answer queries has been popular for a few decades now, as it cuts across domains such as query optimization, information integration, data warehousing, website design and, recently, database-as-a-service and data placement in cloud systems. This book assembles foundationa...
Gespeichert in:
Hauptverfasser: | , |
---|---|
Format: | Elektronisch E-Book |
Sprache: | English |
Veröffentlicht: |
[San Rafael, California]
Morgan & Claypool Publishers
[2019]
|
Ausgabe: | Second edition |
Schriftenreihe: | Synthesis lectures on data management
#54 |
Schlagworte: | |
Online-Zugang: | Volltext |
Zusammenfassung: | The topic of using views to answer queries has been popular for a few decades now, as it cuts across domains such as query optimization, information integration, data warehousing, website design and, recently, database-as-a-service and data placement in cloud systems. This book assembles foundational work on answering queries using views in a self-contained manner, with an effort to choose material that constitutes the backbone of the research. It presents efficient algorithms and covers the following problems: query containment; rewriting queries using views in various logical languages; equivalent rewritings and maximally contained rewritings; and computing certain answers in the data-integration and data-exchange settings. Query languages that are considered are fragments of SQL, in particular select-project-join queries, also called conjunctive queries (with or without arithmetic comparisons or negation), and aggregate SQL queries. This second edition includes two new chapters that refer to tree-like data and respective query languages. Chapter 8 presents the data model for XML documents and the XPath query language, and Chapter 9 provides a theoretical presentation of tree-like data model and query language where the tuples of a relation share a tree-structured schema for that relation and the query language is a dialect of SQL with evaluation techniques appropriately modified to fit the richer schema |
Beschreibung: | Part of: Synthesis digital library of engineering and computer science Title from PDF title page (viewed on May 3, 2019) |
Beschreibung: | 1 Online-Resource (xix, 253 Seiten) Illustrationen |
ISBN: | 9781681734637 |
DOI: | 10.2200/S00884ED2V01Y201811DTM054 |
Internformat
MARC
LEADER | 00000nmm a2200000zcb4500 | ||
---|---|---|---|
001 | BV046427690 | ||
003 | DE-604 | ||
005 | 20230815 | ||
007 | cr|uuu---uuuuu | ||
008 | 200217s2019 |||| o||u| ||||||eng d | ||
020 | |a 9781681734637 |c ebook |9 978-1-68173-463-7 | ||
024 | 7 | |a 10.2200/S00884ED2V01Y201811DTM054 |2 doi | |
035 | |a (ZDB-105-MCS)8694766 | ||
035 | |a (OCoLC)1141146620 | ||
035 | |a (DE-599)BVBBV046427690 | ||
040 | |a DE-604 |b ger |e rda | ||
041 | 0 | |a eng | |
049 | |a DE-83 | ||
082 | 0 | |a 005.7565 |2 23 | |
100 | 1 | |a Afrati, Foto N. |e Verfasser |0 (DE-588)1053088159 |4 aut | |
245 | 1 | 0 | |a Answering queries using views |c Foto Afrati, Rada Chirkova |
250 | |a Second edition | ||
264 | 1 | |a [San Rafael, California] |b Morgan & Claypool Publishers |c [2019] | |
264 | 4 | |c © 2019 | |
300 | |a 1 Online-Resource (xix, 253 Seiten) |b Illustrationen | ||
336 | |b txt |2 rdacontent | ||
337 | |b c |2 rdamedia | ||
338 | |b cr |2 rdacarrier | ||
490 | 1 | |a Synthesis lectures on data management |v #54 | |
500 | |a Part of: Synthesis digital library of engineering and computer science | ||
500 | |a Title from PDF title page (viewed on May 3, 2019) | ||
520 | |a The topic of using views to answer queries has been popular for a few decades now, as it cuts across domains such as query optimization, information integration, data warehousing, website design and, recently, database-as-a-service and data placement in cloud systems. This book assembles foundational work on answering queries using views in a self-contained manner, with an effort to choose material that constitutes the backbone of the research. It presents efficient algorithms and covers the following problems: query containment; rewriting queries using views in various logical languages; equivalent rewritings and maximally contained rewritings; and computing certain answers in the data-integration and data-exchange settings. Query languages that are considered are fragments of SQL, in particular select-project-join queries, also called conjunctive queries (with or without arithmetic comparisons or negation), and aggregate SQL queries. This second edition includes two new chapters that refer to tree-like data and respective query languages. Chapter 8 presents the data model for XML documents and the XPath query language, and Chapter 9 provides a theoretical presentation of tree-like data model and query language where the tuples of a relation share a tree-structured schema for that relation and the query language is a dialect of SQL with evaluation techniques appropriately modified to fit the richer schema | ||
650 | 4 | |a Querying (Computer science) | |
650 | 0 | 7 | |a Abfrage |0 (DE-588)4198788-3 |2 gnd |9 rswk-swf |
650 | 0 | 7 | |a Datenbanksystem |0 (DE-588)4113276-2 |2 gnd |9 rswk-swf |
650 | 0 | 7 | |a Information Extraction |0 (DE-588)4566641-6 |2 gnd |9 rswk-swf |
650 | 0 | 7 | |a Frage-Antwort-System |0 (DE-588)4277060-9 |2 gnd |9 rswk-swf |
650 | 0 | 7 | |a Information Retrieval |0 (DE-588)4072803-1 |2 gnd |9 rswk-swf |
689 | 0 | 0 | |a Abfrage |0 (DE-588)4198788-3 |D s |
689 | 0 | 1 | |a Datenbanksystem |0 (DE-588)4113276-2 |D s |
689 | 0 | 2 | |a Frage-Antwort-System |0 (DE-588)4277060-9 |D s |
689 | 0 | 3 | |a Information Extraction |0 (DE-588)4566641-6 |D s |
689 | 0 | 4 | |a Information Retrieval |0 (DE-588)4072803-1 |D s |
689 | 0 | |5 DE-604 | |
700 | 1 | |a Chirkova, Rada |e Verfasser |0 (DE-588)1155859448 |4 aut | |
776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe, hardcover |z 978-1-68173-464-4 |
776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe, paperback |z 978-1-68173-462-0 |
830 | 0 | |a Synthesis lectures on data management |v #54 |w (DE-604)BV036731811 |9 54 | |
856 | 4 | 0 | |u https://doi.org/10.2200/S00884ED2V01Y201811DTM054 |x Verlag |z URL des Erstveröffentlichers |3 Volltext |
912 | |a ZDB-105-MCS |a ZDB-105-MCDM | ||
999 | |a oai:aleph.bib-bvb.de:BVB01-031839992 |
Datensatz im Suchindex
_version_ | 1804180976803250176 |
---|---|
any_adam_object | |
author | Afrati, Foto N. Chirkova, Rada |
author_GND | (DE-588)1053088159 (DE-588)1155859448 |
author_facet | Afrati, Foto N. Chirkova, Rada |
author_role | aut aut |
author_sort | Afrati, Foto N. |
author_variant | f n a fn fna r c rc |
building | Verbundindex |
bvnumber | BV046427690 |
collection | ZDB-105-MCS ZDB-105-MCDM |
ctrlnum | (ZDB-105-MCS)8694766 (OCoLC)1141146620 (DE-599)BVBBV046427690 |
dewey-full | 005.7565 |
dewey-hundreds | 000 - Computer science, information, general works |
dewey-ones | 005 - Computer programming, programs, data, security |
dewey-raw | 005.7565 |
dewey-search | 005.7565 |
dewey-sort | 15.7565 |
dewey-tens | 000 - Computer science, information, general works |
discipline | Informatik |
doi_str_mv | 10.2200/S00884ED2V01Y201811DTM054 |
edition | Second edition |
format | Electronic eBook |
fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03804nmm a2200577zcb4500</leader><controlfield tag="001">BV046427690</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20230815 </controlfield><controlfield tag="007">cr|uuu---uuuuu</controlfield><controlfield tag="008">200217s2019 |||| o||u| ||||||eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781681734637</subfield><subfield code="c">ebook</subfield><subfield code="9">978-1-68173-463-7</subfield></datafield><datafield tag="024" ind1="7" ind2=" "><subfield code="a">10.2200/S00884ED2V01Y201811DTM054</subfield><subfield code="2">doi</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(ZDB-105-MCS)8694766</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1141146620</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV046427690</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-83</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.7565</subfield><subfield code="2">23</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Afrati, Foto N.</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)1053088159</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Answering queries using views</subfield><subfield code="c">Foto Afrati, Rada Chirkova</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">Second edition</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">[San Rafael, California]</subfield><subfield code="b">Morgan & Claypool Publishers</subfield><subfield code="c">[2019]</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">© 2019</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 Online-Resource (xix, 253 Seiten)</subfield><subfield code="b">Illustrationen</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">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">Synthesis lectures on data management</subfield><subfield code="v">#54</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Part of: Synthesis digital library of engineering and computer science</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Title from PDF title page (viewed on May 3, 2019)</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">The topic of using views to answer queries has been popular for a few decades now, as it cuts across domains such as query optimization, information integration, data warehousing, website design and, recently, database-as-a-service and data placement in cloud systems. This book assembles foundational work on answering queries using views in a self-contained manner, with an effort to choose material that constitutes the backbone of the research. It presents efficient algorithms and covers the following problems: query containment; rewriting queries using views in various logical languages; equivalent rewritings and maximally contained rewritings; and computing certain answers in the data-integration and data-exchange settings. Query languages that are considered are fragments of SQL, in particular select-project-join queries, also called conjunctive queries (with or without arithmetic comparisons or negation), and aggregate SQL queries. This second edition includes two new chapters that refer to tree-like data and respective query languages. Chapter 8 presents the data model for XML documents and the XPath query language, and Chapter 9 provides a theoretical presentation of tree-like data model and query language where the tuples of a relation share a tree-structured schema for that relation and the query language is a dialect of SQL with evaluation techniques appropriately modified to fit the richer schema</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Querying (Computer science)</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Abfrage</subfield><subfield code="0">(DE-588)4198788-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Datenbanksystem</subfield><subfield code="0">(DE-588)4113276-2</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Information Extraction</subfield><subfield code="0">(DE-588)4566641-6</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Frage-Antwort-System</subfield><subfield code="0">(DE-588)4277060-9</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Information Retrieval</subfield><subfield code="0">(DE-588)4072803-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Abfrage</subfield><subfield code="0">(DE-588)4198788-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Datenbanksystem</subfield><subfield code="0">(DE-588)4113276-2</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="2"><subfield code="a">Frage-Antwort-System</subfield><subfield code="0">(DE-588)4277060-9</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="3"><subfield code="a">Information Extraction</subfield><subfield code="0">(DE-588)4566641-6</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="4"><subfield code="a">Information Retrieval</subfield><subfield code="0">(DE-588)4072803-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="700" ind1="1" ind2=" "><subfield code="a">Chirkova, Rada</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)1155859448</subfield><subfield code="4">aut</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe, hardcover</subfield><subfield code="z">978-1-68173-464-4</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe, paperback</subfield><subfield code="z">978-1-68173-462-0</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Synthesis lectures on data management</subfield><subfield code="v">#54</subfield><subfield code="w">(DE-604)BV036731811</subfield><subfield code="9">54</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="u">https://doi.org/10.2200/S00884ED2V01Y201811DTM054</subfield><subfield code="x">Verlag</subfield><subfield code="z">URL des Erstveröffentlichers</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-105-MCS</subfield><subfield code="a">ZDB-105-MCDM</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-031839992</subfield></datafield></record></collection> |
id | DE-604.BV046427690 |
illustrated | Not Illustrated |
indexdate | 2024-07-10T08:44:19Z |
institution | BVB |
isbn | 9781681734637 |
language | English |
oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-031839992 |
oclc_num | 1141146620 |
open_access_boolean | |
owner | DE-83 |
owner_facet | DE-83 |
physical | 1 Online-Resource (xix, 253 Seiten) Illustrationen |
psigel | ZDB-105-MCS ZDB-105-MCDM |
publishDate | 2019 |
publishDateSearch | 2019 |
publishDateSort | 2019 |
publisher | Morgan & Claypool Publishers |
record_format | marc |
series | Synthesis lectures on data management |
series2 | Synthesis lectures on data management |
spelling | Afrati, Foto N. Verfasser (DE-588)1053088159 aut Answering queries using views Foto Afrati, Rada Chirkova Second edition [San Rafael, California] Morgan & Claypool Publishers [2019] © 2019 1 Online-Resource (xix, 253 Seiten) Illustrationen txt rdacontent c rdamedia cr rdacarrier Synthesis lectures on data management #54 Part of: Synthesis digital library of engineering and computer science Title from PDF title page (viewed on May 3, 2019) The topic of using views to answer queries has been popular for a few decades now, as it cuts across domains such as query optimization, information integration, data warehousing, website design and, recently, database-as-a-service and data placement in cloud systems. This book assembles foundational work on answering queries using views in a self-contained manner, with an effort to choose material that constitutes the backbone of the research. It presents efficient algorithms and covers the following problems: query containment; rewriting queries using views in various logical languages; equivalent rewritings and maximally contained rewritings; and computing certain answers in the data-integration and data-exchange settings. Query languages that are considered are fragments of SQL, in particular select-project-join queries, also called conjunctive queries (with or without arithmetic comparisons or negation), and aggregate SQL queries. This second edition includes two new chapters that refer to tree-like data and respective query languages. Chapter 8 presents the data model for XML documents and the XPath query language, and Chapter 9 provides a theoretical presentation of tree-like data model and query language where the tuples of a relation share a tree-structured schema for that relation and the query language is a dialect of SQL with evaluation techniques appropriately modified to fit the richer schema Querying (Computer science) Abfrage (DE-588)4198788-3 gnd rswk-swf Datenbanksystem (DE-588)4113276-2 gnd rswk-swf Information Extraction (DE-588)4566641-6 gnd rswk-swf Frage-Antwort-System (DE-588)4277060-9 gnd rswk-swf Information Retrieval (DE-588)4072803-1 gnd rswk-swf Abfrage (DE-588)4198788-3 s Datenbanksystem (DE-588)4113276-2 s Frage-Antwort-System (DE-588)4277060-9 s Information Extraction (DE-588)4566641-6 s Information Retrieval (DE-588)4072803-1 s DE-604 Chirkova, Rada Verfasser (DE-588)1155859448 aut Erscheint auch als Druck-Ausgabe, hardcover 978-1-68173-464-4 Erscheint auch als Druck-Ausgabe, paperback 978-1-68173-462-0 Synthesis lectures on data management #54 (DE-604)BV036731811 54 https://doi.org/10.2200/S00884ED2V01Y201811DTM054 Verlag URL des Erstveröffentlichers Volltext |
spellingShingle | Afrati, Foto N. Chirkova, Rada Answering queries using views Synthesis lectures on data management Querying (Computer science) Abfrage (DE-588)4198788-3 gnd Datenbanksystem (DE-588)4113276-2 gnd Information Extraction (DE-588)4566641-6 gnd Frage-Antwort-System (DE-588)4277060-9 gnd Information Retrieval (DE-588)4072803-1 gnd |
subject_GND | (DE-588)4198788-3 (DE-588)4113276-2 (DE-588)4566641-6 (DE-588)4277060-9 (DE-588)4072803-1 |
title | Answering queries using views |
title_auth | Answering queries using views |
title_exact_search | Answering queries using views |
title_full | Answering queries using views Foto Afrati, Rada Chirkova |
title_fullStr | Answering queries using views Foto Afrati, Rada Chirkova |
title_full_unstemmed | Answering queries using views Foto Afrati, Rada Chirkova |
title_short | Answering queries using views |
title_sort | answering queries using views |
topic | Querying (Computer science) Abfrage (DE-588)4198788-3 gnd Datenbanksystem (DE-588)4113276-2 gnd Information Extraction (DE-588)4566641-6 gnd Frage-Antwort-System (DE-588)4277060-9 gnd Information Retrieval (DE-588)4072803-1 gnd |
topic_facet | Querying (Computer science) Abfrage Datenbanksystem Information Extraction Frage-Antwort-System Information Retrieval |
url | https://doi.org/10.2200/S00884ED2V01Y201811DTM054 |
volume_link | (DE-604)BV036731811 |
work_keys_str_mv | AT afratifoton answeringqueriesusingviews AT chirkovarada answeringqueriesusingviews |