| dc.contributor.author | Γεργατσούλης, Μανώλης | el_GR |
| dc.contributor.author | Αφράτη, Φώτο | el_GR |
| dc.contributor.author | Παυλάκη, Βάσια | el_GR |
| dc.contributor.author | Chirkova, Rada | en |
| dc.contributor.author | Gergatsoulis, Manolis | en |
| dc.contributor.author | Afrati, Foto | en |
| dc.contributor.author | Pavlaki, Vassia | en |
| dc.date.available | 2014-01-16T06:29:56Z | |
| dc.date.issued | 2005 | |
| dc.identifier.issn | 3029743 | |
| dc.identifier.uri | http://hdl.handle.net/10797/13673 | en |
| dc.description | Περιέχει το πλήρες κείμενο | el_GR |
| dc.description.abstract | The problem of optimizing queries in the presence of materialized views and the related view-design problem have recently attracted a lot of attention. Significant research results have been reported, and materialized views are increasingly used in query evaluation in commercial data-management systems. At the same time, most results in the literature assume set-theoretic semantics, whereas SQL queries have bagtheoretic semantics (duplicates are not eliminated unless explicitly requested). This paper presents results on selecting views to answer queries in relational databases under set, bag, and bag-set semantics. The results can be used under each of the three assumptions, to find sound and complete algorithms for designing views and rewriting queries efficiently. | en |
| dc.language.iso | eng | en |
| dc.rights | info:eu-repo/semantics/openAccess | en |
| dc.source | Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume 3607 LNAI, 2005, Pages 332-346 | en |
| dc.source | Scopus | en |
| dc.source.uri | http://www.scopus.com/record/display.url?eid=2-s2.0-26944488977&origin=resultslist&sort=plf-f&src=s&st1=gergatsoulis&nlo=1&nlr=20&nls=count-f&sid=3721C8512648DE367D76686B2D82F7FD.zQKnzAySRvJOZYcdfIziQ%3a63&sot=anl&sdt=aut&sl=41&s=AU-ID%28%22Gergatsoulis%2c+Manolis%22+6602969138%29&relpos=23&relpos=3&citeCnt=0&searchTerm=AU-ID%28%5C%26quot%3BGergatsoulis%2C+Manolis%5C%26quot%3B+6602969138%29 | en |
| dc.title | Designing views to efficiently answer real SQL queries | en |
| dc.type | Article | en |
| dc.subject.JITA | Τεχνολογίες πληροφόρησης και τεχνολογίες βιβλιοθηκών, Αυτοματοποιημένη επεξεργασία γλώσσας | el_GR |
| dc.subject.JITA | Information technology and library technology, Automated language processing | en |
| dc.identifier.JITA | LL | en |