{"id":"https://openalex.org/W2137420824","doi":"https://doi.org/10.1109/tkde.2002.1047768","title":"Efficient queries over Web views","display_name":"Efficient queries over Web views","publication_year":2002,"publication_date":"2002-11-01","ids":{"openalex":"https://openalex.org/W2137420824","doi":"https://doi.org/10.1109/tkde.2002.1047768","mag":"2137420824"},"language":"en","primary_location":{"id":"doi:10.1109/tkde.2002.1047768","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2002.1047768","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5008291639","display_name":"Giansalvatore Mecca","orcid":"https://orcid.org/0000-0002-1189-1481"},"institutions":[{"id":"https://openalex.org/I20272500","display_name":"University of Basilicata","ror":"https://ror.org/03tc05689","country_code":"IT","type":"education","lineage":["https://openalex.org/I20272500"]}],"countries":["IT"],"is_corresponding":true,"raw_author_name":"G. Mecca","raw_affiliation_strings":["Universit\u00e0 della Basilicata, Potenza, Italy","Universita della Basilicata, Italy"],"affiliations":[{"raw_affiliation_string":"Universit\u00e0 della Basilicata, Potenza, Italy","institution_ids":["https://openalex.org/I20272500"]},{"raw_affiliation_string":"Universita della Basilicata, Italy","institution_ids":["https://openalex.org/I20272500"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5004768561","display_name":"Alberto O. Mendelzon","orcid":null},"institutions":[{"id":"https://openalex.org/I185261750","display_name":"University of Toronto","ror":"https://ror.org/03dbr7087","country_code":"CA","type":"education","lineage":["https://openalex.org/I185261750"]}],"countries":["CA"],"is_corresponding":false,"raw_author_name":"A.O. Mendelzon","raw_affiliation_strings":["Department of Computer Science, University of Toronto, Toronto, ONT, Canada","Department of Computer Science University of Toronto, Canada#TAB#"],"affiliations":[{"raw_affiliation_string":"Department of Computer Science, University of Toronto, Toronto, ONT, Canada","institution_ids":["https://openalex.org/I185261750"]},{"raw_affiliation_string":"Department of Computer Science University of Toronto, Canada#TAB#","institution_ids":["https://openalex.org/I185261750"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5022736687","display_name":"Paolo Merialdo","orcid":"https://orcid.org/0000-0002-3852-8092"},"institutions":[{"id":"https://openalex.org/I119003972","display_name":"Roma Tre University","ror":"https://ror.org/05vf0dg29","country_code":"IT","type":"education","lineage":["https://openalex.org/I119003972"]}],"countries":["IT"],"is_corresponding":false,"raw_author_name":"P. Merialdo","raw_affiliation_strings":["Dipartimento di Informatica e Automazione, Universit\u00e0 Roma Tre, Rome, Italy","Dip. Informatica e Automazione, Universit\u00e0 di Roma Tre, Roma, Italy"],"affiliations":[{"raw_affiliation_string":"Dipartimento di Informatica e Automazione, Universit\u00e0 Roma Tre, Rome, Italy","institution_ids":["https://openalex.org/I119003972"]},{"raw_affiliation_string":"Dip. Informatica e Automazione, Universit\u00e0 di Roma Tre, Roma, Italy","institution_ids":["https://openalex.org/I119003972"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5008291639"],"corresponding_institution_ids":["https://openalex.org/I20272500"],"apc_list":null,"apc_paid":null,"fwci":0.6746,"has_fulltext":false,"cited_by_count":9,"citation_normalized_percentile":{"value":0.75084893,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"14","issue":"6","first_page":"1280","last_page":"1298"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12016","display_name":"Web Data Mining and Analysis","score":0.9997000098228455,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8774755001068115},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.619682788848877},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.6193253397941589},{"id":"https://openalex.org/keywords/redundancy","display_name":"Redundancy (engineering)","score":0.5614322423934937},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.5124145150184631},{"id":"https://openalex.org/keywords/data-redundancy","display_name":"Data redundancy","score":0.5053778290748596},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.44371387362480164},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.42230382561683655},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.4173443019390106},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.3888636827468872},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.354765921831131},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3498508930206299},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.29167336225509644},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.2650548219680786},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.1805466115474701}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8774755001068115},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.619682788848877},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.6193253397941589},{"id":"https://openalex.org/C152124472","wikidata":"https://www.wikidata.org/wiki/Q1204361","display_name":"Redundancy (engineering)","level":2,"score":0.5614322423934937},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.5124145150184631},{"id":"https://openalex.org/C7545210","wikidata":"https://www.wikidata.org/wiki/Q838123","display_name":"Data redundancy","level":2,"score":0.5053778290748596},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.44371387362480164},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.42230382561683655},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4173443019390106},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.3888636827468872},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.354765921831131},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3498508930206299},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.29167336225509644},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2650548219680786},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1805466115474701},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1109/tkde.2002.1047768","is_oa":false,"landing_page_url":"https://doi.org/10.1109/tkde.2002.1047768","pdf_url":null,"source":{"id":"https://openalex.org/S30698027","display_name":"IEEE Transactions on Knowledge and Data Engineering","issn_l":"1041-4347","issn":["1041-4347","1558-2191","2326-3865"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320439","host_organization_name":"IEEE Computer Society","host_organization_lineage":["https://openalex.org/P4310320439","https://openalex.org/P4310319808"],"host_organization_lineage_names":["IEEE Computer Society","Institute of Electrical and Electronics Engineers"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"IEEE Transactions on Knowledge and Data Engineering","raw_type":"journal-article"},{"id":"pmh:oai:iris.unibas.it:11563/1581","is_oa":false,"landing_page_url":"http://hdl.handle.net/11563/1581","pdf_url":null,"source":{"id":"https://openalex.org/S4377196360","display_name":"CINECA IRIS Institutional Research Information System (University of Basilicata)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I20272500","host_organization_name":"University of Basilicata","host_organization_lineage":["https://openalex.org/I20272500"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"info:eu-repo/semantics/article"},{"id":"pmh:oai:iris.uniroma3.it:11590/117570","is_oa":false,"landing_page_url":"http://hdl.handle.net/11590/117570","pdf_url":null,"source":{"id":"https://openalex.org/S4377196120","display_name":"Iris (Roma Tre University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I119003972","host_organization_name":"Roma Tre University","host_organization_lineage":["https://openalex.org/I119003972"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"info:eu-repo/semantics/article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":47,"referenced_works":["https://openalex.org/W53782684","https://openalex.org/W174407363","https://openalex.org/W197511871","https://openalex.org/W253264081","https://openalex.org/W1481805023","https://openalex.org/W1526124194","https://openalex.org/W1529031897","https://openalex.org/W1530044031","https://openalex.org/W1548300172","https://openalex.org/W1558832481","https://openalex.org/W1564646625","https://openalex.org/W1588659924","https://openalex.org/W1623511323","https://openalex.org/W1661321285","https://openalex.org/W1710641084","https://openalex.org/W1943411325","https://openalex.org/W1969375478","https://openalex.org/W1976607278","https://openalex.org/W1977685051","https://openalex.org/W1994933468","https://openalex.org/W2007857312","https://openalex.org/W2012531809","https://openalex.org/W2021611189","https://openalex.org/W2049851508","https://openalex.org/W2066575439","https://openalex.org/W2072881690","https://openalex.org/W2081874103","https://openalex.org/W2083317499","https://openalex.org/W2096806473","https://openalex.org/W2109660182","https://openalex.org/W2119461823","https://openalex.org/W2134350535","https://openalex.org/W2145404631","https://openalex.org/W2170192471","https://openalex.org/W2295596515","https://openalex.org/W2751199251","https://openalex.org/W2753439427","https://openalex.org/W3007065685","https://openalex.org/W3008586834","https://openalex.org/W3142009611","https://openalex.org/W4206031975","https://openalex.org/W4248717900","https://openalex.org/W4250456398","https://openalex.org/W6607149019","https://openalex.org/W6633691337","https://openalex.org/W6634974852","https://openalex.org/W6640690195"],"related_works":["https://openalex.org/W2002428578","https://openalex.org/W2573939812","https://openalex.org/W2120098008","https://openalex.org/W2897258045","https://openalex.org/W2898886863","https://openalex.org/W1639806124","https://openalex.org/W2902831276","https://openalex.org/W2018406690","https://openalex.org/W2165259096","https://openalex.org/W2540682188"],"abstract_inverted_index":{"Large":[0],"Web":[1,89],"sites":[2],"are":[3],"becoming":[4],"repositories":[5],"of":[6,41,78,87,111,132,149],"structured":[7],"information":[8],"that":[9,100,137],"can":[10,58,140],"benefit":[11],"from":[12],"being":[13,48],"viewed":[14],"and":[15,35,97,118],"queried":[16],"as":[17,38],"relational":[18,109],"databases.":[19],"However,":[20],"querying":[21],"these":[22],"views":[23,110,146],"efficiently":[24],"requires":[25],"new":[26],"techniques.":[27],"Data":[28],"usually":[29],"resides":[30],"at":[31],"a":[32,39,49,72,76,88,112,115],"remote":[33],"site":[34,68,113],"is":[36],"organized":[37],"set":[40],"related":[42],"HTML":[43,150],"documents,":[44],"with":[45,95],"network":[46,133],"access":[47],"primary":[50],"cost":[51,57],"factor":[52],"in":[53,67,104],"query":[54],"evaluation.":[55],"This":[56],"be":[59,141],"reduced":[60],"by":[61],"exploiting":[62],"the":[63,79,85,93,102,105,123,130],"redundancy":[64],"often":[65],"found":[66],"design.":[69],"We":[70,91,107,135],"use":[71,122],"simple":[73],"data":[74,81],"model,":[75,82],"subset":[77],"Araneus":[80],"to":[83,114,121,125,143],"describe":[84],"structure":[86],"site.":[90,106],"augment":[92],"model":[94],"link":[96],"inclusion":[98],"constraints":[99,124],"capture":[101],"redundancies":[103],"map":[108],"navigational":[116],"algebra":[117],"show":[119,136],"how":[120],"rewrite":[126],"algebraic":[127],"expressions,":[128],"reducing":[129],"number":[131],"accesses.":[134],"similar":[138],"techniques":[139],"used":[142],"maintain":[144],"materialized":[145],"over":[147],"sets":[148],"pages.":[151]},"counts_by_year":[{"year":2016,"cited_by_count":1},{"year":2014,"cited_by_count":1},{"year":2012,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}