{"id":"https://openalex.org/W2003125651","doi":"https://doi.org/10.1145/1967486.1967560","title":"Multi-constraint selection of materialized webviews","display_name":"Multi-constraint selection of materialized webviews","publication_year":2010,"publication_date":"2010-11-08","ids":{"openalex":"https://openalex.org/W2003125651","doi":"https://doi.org/10.1145/1967486.1967560","mag":"2003125651"},"language":"en","primary_location":{"id":"doi:10.1145/1967486.1967560","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1967486.1967560","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 12th International Conference on Information Integration and Web-based Applications & Services","raw_type":"proceedings-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/A5110391035","display_name":"Ali Ben Ammar","orcid":null},"institutions":[{"id":"https://openalex.org/I4400573161","display_name":"Institut Sup\u00e9rieur d\u2019Informatique et de Gestion de Goma","ror":"https://ror.org/01cfdpz73","country_code":null,"type":"education","lineage":["https://openalex.org/I4400573161"]},{"id":"https://openalex.org/I55167344","display_name":"University of Kairouan","ror":"https://ror.org/024mpte60","country_code":"TN","type":"education","lineage":["https://openalex.org/I55167344"]}],"countries":["TN"],"is_corresponding":true,"raw_author_name":"Ali Ben Ammar","raw_affiliation_strings":["Institut Sup\u00e9rieur d'Informatique et de Gestion de Kairouan, Kairouan, Tunisie"],"affiliations":[{"raw_affiliation_string":"Institut Sup\u00e9rieur d'Informatique et de Gestion de Kairouan, Kairouan, Tunisie","institution_ids":["https://openalex.org/I55167344","https://openalex.org/I4400573161"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023408244","display_name":"Abdelaziz Abdellatif","orcid":"https://orcid.org/0000-0002-4763-9827"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Abdelaziz Abdellatif","raw_affiliation_strings":["Tunis, Tunisie"],"affiliations":[{"raw_affiliation_string":"Tunis, Tunisie","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5113495421","display_name":"Henda Ben Gh\u00e9zala","orcid":null},"institutions":[{"id":"https://openalex.org/I29607241","display_name":"\u00c9cole Normale Sup\u00e9rieure - PSL","ror":"https://ror.org/05a0dhs15","country_code":"FR","type":"funder","lineage":["https://openalex.org/I2746051580","https://openalex.org/I29607241"]},{"id":"https://openalex.org/I83259278","display_name":"Manouba University","ror":"https://ror.org/0503ejf32","country_code":"TN","type":"education","lineage":["https://openalex.org/I83259278"]}],"countries":["FR","TN"],"is_corresponding":false,"raw_author_name":"Henda Ben Ghezala","raw_affiliation_strings":["Ecole Nationale des Sciences de l'Informatique, Manouba, Tunisie","Ecole Nationale des Sciences de l'Informatique, Manouba, Tunisie#TAB#"],"affiliations":[{"raw_affiliation_string":"Ecole Nationale des Sciences de l'Informatique, Manouba, Tunisie","institution_ids":["https://openalex.org/I83259278"]},{"raw_affiliation_string":"Ecole Nationale des Sciences de l'Informatique, Manouba, Tunisie#TAB#","institution_ids":["https://openalex.org/I29607241"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5110391035"],"corresponding_institution_ids":["https://openalex.org/I4400573161","https://openalex.org/I55167344"],"apc_list":null,"apc_paid":null,"fwci":0.6937,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.81736364,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":null,"issue":null,"first_page":"477","last_page":"482"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"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"}},"topics":[{"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"}},{"id":"https://openalex.org/T11478","display_name":"Caching and Content Delivery","score":0.9991000294685364,"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/T11269","display_name":"Algorithms and Data Compression","score":0.992900013923645,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"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/materialized-view","display_name":"Materialized view","score":0.9756084680557251},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7789811491966248},{"id":"https://openalex.org/keywords/constraint","display_name":"Constraint (computer-aided design)","score":0.6213722229003906},{"id":"https://openalex.org/keywords/time-constraint","display_name":"Time constraint","score":0.5258905291557312},{"id":"https://openalex.org/keywords/limiting","display_name":"Limiting","score":0.5162441730499268},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.507682204246521},{"id":"https://openalex.org/keywords/plan","display_name":"Plan (archaeology)","score":0.4434850811958313},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.41599202156066895},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3933522701263428},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.37670260667800903},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.13588416576385498},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.10411587357521057},{"id":"https://openalex.org/keywords/engineering","display_name":"Engineering","score":0.09999909996986389},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.0806889533996582},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.07515954971313477}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9756084680557251},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7789811491966248},{"id":"https://openalex.org/C2776036281","wikidata":"https://www.wikidata.org/wiki/Q48769818","display_name":"Constraint (computer-aided design)","level":2,"score":0.6213722229003906},{"id":"https://openalex.org/C2775907273","wikidata":"https://www.wikidata.org/wiki/Q7805281","display_name":"Time constraint","level":2,"score":0.5258905291557312},{"id":"https://openalex.org/C188198153","wikidata":"https://www.wikidata.org/wiki/Q1613840","display_name":"Limiting","level":2,"score":0.5162441730499268},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.507682204246521},{"id":"https://openalex.org/C2776505523","wikidata":"https://www.wikidata.org/wiki/Q4785468","display_name":"Plan (archaeology)","level":2,"score":0.4434850811958313},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.41599202156066895},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3933522701263428},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.37670260667800903},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.13588416576385498},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.10411587357521057},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.09999909996986389},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0806889533996582},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.07515954971313477},{"id":"https://openalex.org/C199539241","wikidata":"https://www.wikidata.org/wiki/Q7748","display_name":"Law","level":1,"score":0.0},{"id":"https://openalex.org/C95457728","wikidata":"https://www.wikidata.org/wiki/Q309","display_name":"History","level":0,"score":0.0},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.0},{"id":"https://openalex.org/C2524010","wikidata":"https://www.wikidata.org/wiki/Q8087","display_name":"Geometry","level":1,"score":0.0},{"id":"https://openalex.org/C78519656","wikidata":"https://www.wikidata.org/wiki/Q101333","display_name":"Mechanical engineering","level":1,"score":0.0},{"id":"https://openalex.org/C17744445","wikidata":"https://www.wikidata.org/wiki/Q36442","display_name":"Political science","level":0,"score":0.0},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1967486.1967560","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1967486.1967560","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 12th International Conference on Information Integration and Web-based Applications & Services","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":6,"referenced_works":["https://openalex.org/W1528527048","https://openalex.org/W1570347237","https://openalex.org/W1986365041","https://openalex.org/W2007224838","https://openalex.org/W2185209027","https://openalex.org/W4243755493"],"related_works":["https://openalex.org/W2064309607","https://openalex.org/W2074713486","https://openalex.org/W2351972041","https://openalex.org/W3200670168","https://openalex.org/W2081528512","https://openalex.org/W2163764339","https://openalex.org/W2090344631","https://openalex.org/W2307158532","https://openalex.org/W3125309996","https://openalex.org/W4313469555"],"abstract_inverted_index":{"In":[0],"this":[1],"paper,":[2],"we":[3,93,121],"propose":[4],"a":[5,16,37,41,46],"new":[6,52],"constraint":[7,54],"to":[8,19,69,84,95],"select":[9],"materialized":[10,63,76,113],"webviews.":[11,64],"The":[12],"webview":[13],"materialization":[14,104,108,135,161],"is":[15,33,68,120,173,179],"term":[17],"used":[18],"represent":[20],"the":[21,34,58,71,75,81,85,97,100,103,107,116,124,130,138,150,157,168,175],"transformation":[22],"of":[23,36,40,56,60,62,74,99,106,112,126,129,137,149,160,170],"dynamic":[24,42],"web":[25,30,43],"data":[26,86],"into":[27],"equivalent":[28],"static":[29,38],"data.":[31],"That":[32,119],"creation":[35],"instance":[39],"page,":[44],"at":[45],"certain":[47],"point":[48],"in":[49],"time.":[50],"Our":[51,65,141],"selection":[53,117,131],"consists":[55],"limiting":[57],"number":[59,169],"sources":[61,87],"first":[66],"aim":[67,94],"reduce":[70,123],"update":[72],"frequency":[73],"webview.":[77],"This":[78],"will":[79,122],"decrease":[80],"access":[82],"cost":[83],"which":[88],"may":[89],"be":[90],"distant.":[91],"Secondly,":[92],"guarantee":[96],"stability":[98],"profit":[101,159],"and":[102],"load":[105],"plan":[109],"(the":[110],"set":[111],"webviews)":[114],"during":[115],"period.":[118],"probability":[125],"early":[127,134],"violation":[128],"constraints":[132],"or":[133],"loss":[136],"selected":[139],"plan.":[140],"experiment":[142],"results":[143],"show":[144],"that":[145],"for":[146],"small":[147],"values":[148],"source":[151],"constraint,":[152],"our":[153,183],"approach":[154],"can":[155],"improve":[156],"average":[158],"by":[162,181],"more":[163],"than":[164],"15%.":[165],"Also,":[166],"when":[167],"candidate":[171],"webviews":[172],"high,":[174],"query":[176],"response":[177],"time":[178],"improved":[180],"applying":[182],"solution.":[184]},"counts_by_year":[{"year":2013,"cited_by_count":1}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}