{"id":"https://openalex.org/W2117317732","doi":"https://doi.org/10.1145/2320765.2320788","title":"Cost models for view materialization in the cloud","display_name":"Cost models for view materialization in the cloud","publication_year":2012,"publication_date":"2012-03-30","ids":{"openalex":"https://openalex.org/W2117317732","doi":"https://doi.org/10.1145/2320765.2320788","mag":"2117317732"},"language":"en","primary_location":{"id":"doi:10.1145/2320765.2320788","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2320765.2320788","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2012 Joint EDBT/ICDT Workshops","raw_type":"proceedings-article"},"type":"conference-paper","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/A5073761189","display_name":"Thi-Van-Anh Nguyen","orcid":null},"institutions":[{"id":"https://openalex.org/I98702875","display_name":"Universit\u00e9 de Caen Normandie","ror":"https://ror.org/051kpcy16","country_code":"FR","type":"education","lineage":["https://openalex.org/I4210105918","https://openalex.org/I98702875"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Thi-Van-Anh Nguyen","raw_affiliation_strings":["Universit\u00e9 de Caen Basse, Normandie, France"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universit\u00e9 de Caen Basse, Normandie, France","institution_ids":["https://openalex.org/I98702875"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5022668631","display_name":"Sandro Bimonte","orcid":"https://orcid.org/0000-0003-1727-6954"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Sandro Bimonte","raw_affiliation_strings":["Irstea, UR TSCF, Clermont-Ferrand, France"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Irstea, UR TSCF, Clermont-Ferrand, France","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5023360779","display_name":"Laurent d\u2019Orazio","orcid":"https://orcid.org/0000-0001-8614-1848"},"institutions":[{"id":"https://openalex.org/I198244214","display_name":"Universit\u00e9 Clermont Auvergne","ror":"https://ror.org/01a8ajp46","country_code":"FR","type":"education","lineage":["https://openalex.org/I198244214"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"Laurent d'Orazio","raw_affiliation_strings":["Universit\u00e9 Blaise Pascal, Clermont-Ferrand, France"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universit\u00e9 Blaise Pascal, Clermont-Ferrand, France","institution_ids":["https://openalex.org/I198244214"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5080624394","display_name":"J\u00e9r\u00f4me Darmont","orcid":"https://orcid.org/0000-0003-1491-384X"},"institutions":[{"id":"https://openalex.org/I100532134","display_name":"Universit\u00e9 Claude Bernard Lyon 1","ror":"https://ror.org/029brtt94","country_code":"FR","type":"education","lineage":["https://openalex.org/I100532134","https://openalex.org/I203339264"]}],"countries":["FR"],"is_corresponding":false,"raw_author_name":"J\u00e9r\u00f4me Darmont","raw_affiliation_strings":["Universit\u00e9 de Lyon, France"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Universit\u00e9 de Lyon, France","institution_ids":["https://openalex.org/I100532134"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":false,"cited_by_count":36,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"47","last_page":"54"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10101","display_name":"Cloud Computing and Resource Management","score":0.9998999834060669,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9998999834060669,"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/T12292","display_name":"Graph Theory and Algorithms","score":0.9983999729156494,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/T11106","display_name":"Data Management and Algorithms","score":0.9972000122070312,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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/cloud-computing","display_name":"Cloud computing","score":0.8933271169662476},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8385306596755981},{"id":"https://openalex.org/keywords/context","display_name":"Context (archaeology)","score":0.5800772309303284},{"id":"https://openalex.org/keywords/task","display_name":"Task (project management)","score":0.5581672787666321},{"id":"https://openalex.org/keywords/set","display_name":"Set (abstract data type)","score":0.5488395094871521},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.523857831954956},{"id":"https://openalex.org/keywords/selection","display_name":"Selection (genetic algorithm)","score":0.4454713463783264},{"id":"https://openalex.org/keywords/distributed-computing","display_name":"Distributed computing","score":0.44398555159568787},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.37405267357826233},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.36051082611083984},{"id":"https://openalex.org/keywords/artificial-intelligence","display_name":"Artificial intelligence","score":0.14035001397132874},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.1362745463848114},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.10969588160514832}],"concepts":[{"id":"https://openalex.org/C79974875","wikidata":"https://www.wikidata.org/wiki/Q483639","display_name":"Cloud computing","level":2,"score":0.8933271169662476},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8385306596755981},{"id":"https://openalex.org/C2779343474","wikidata":"https://www.wikidata.org/wiki/Q3109175","display_name":"Context (archaeology)","level":2,"score":0.5800772309303284},{"id":"https://openalex.org/C2780451532","wikidata":"https://www.wikidata.org/wiki/Q759676","display_name":"Task (project management)","level":2,"score":0.5581672787666321},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.5488395094871521},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.523857831954956},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.4454713463783264},{"id":"https://openalex.org/C120314980","wikidata":"https://www.wikidata.org/wiki/Q180634","display_name":"Distributed computing","level":1,"score":0.44398555159568787},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.37405267357826233},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.36051082611083984},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.14035001397132874},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.1362745463848114},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.10969588160514832},{"id":"https://openalex.org/C187736073","wikidata":"https://www.wikidata.org/wiki/Q2920921","display_name":"Management","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C162324750","wikidata":"https://www.wikidata.org/wiki/Q8134","display_name":"Economics","level":0,"score":0.0},{"id":"https://openalex.org/C151730666","wikidata":"https://www.wikidata.org/wiki/Q7205","display_name":"Paleontology","level":1,"score":0.0},{"id":"https://openalex.org/C86803240","wikidata":"https://www.wikidata.org/wiki/Q420","display_name":"Biology","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}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1145/2320765.2320788","is_oa":false,"landing_page_url":"https://doi.org/10.1145/2320765.2320788","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2012 Joint EDBT/ICDT Workshops","raw_type":"proceedings-article"},{"id":"pmh:oai:HAL:hal-02597014v1","is_oa":false,"landing_page_url":"https://hal.inrae.fr/hal-02597014","pdf_url":null,"source":{"id":"https://openalex.org/S4306402512","display_name":"HAL (Le Centre pour la Communication Scientifique Directe)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1294671590","host_organization_name":"Centre National de la Recherche Scientifique","host_organization_lineage":["https://openalex.org/I1294671590"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"DANAC, Mar 2012, Berlin, Germany. pp.8","raw_type":"info:eu-repo/semantics/conferenceObject"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.6499999761581421,"display_name":"Affordable and clean energy","id":"https://metadata.un.org/sdg/7"}],"awards":[{"id":"https://openalex.org/G3501429805","display_name":null,"funder_award_id":"SYSEO ANR-10-TECSAN-005-01","funder_id":"https://openalex.org/F4320320883","funder_display_name":"Agence Nationale de la Recherche"}],"funders":[{"id":"https://openalex.org/F4320320883","display_name":"Agence Nationale de la Recherche","ror":"https://ror.org/00rbzpz17"}],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":26,"referenced_works":["https://openalex.org/W180056467","https://openalex.org/W1489843519","https://openalex.org/W1575324001","https://openalex.org/W1578512165","https://openalex.org/W1597931764","https://openalex.org/W1970290925","https://openalex.org/W1976597724","https://openalex.org/W1993892970","https://openalex.org/W2014185546","https://openalex.org/W2072927190","https://openalex.org/W2086028392","https://openalex.org/W2094755648","https://openalex.org/W2098935637","https://openalex.org/W2101610060","https://openalex.org/W2103128343","https://openalex.org/W2114296561","https://openalex.org/W2118385974","https://openalex.org/W2119558533","https://openalex.org/W2124711321","https://openalex.org/W2128525985","https://openalex.org/W2149728808","https://openalex.org/W2156919037","https://openalex.org/W2162247086","https://openalex.org/W2173213060","https://openalex.org/W2949956165","https://openalex.org/W3147052988"],"related_works":["https://openalex.org/W2125738398","https://openalex.org/W2038176938","https://openalex.org/W2376402673","https://openalex.org/W2953224074","https://openalex.org/W1606751452","https://openalex.org/W2585331044","https://openalex.org/W2588278736","https://openalex.org/W2114713465","https://openalex.org/W2395940163","https://openalex.org/W2389015757"],"abstract_inverted_index":{"In":[0,19],"classical":[1],"databases,":[2],"query":[3,62],"performance":[4],"is":[5,48,122],"casually":[6],"achieved":[7],"through":[8],"physical":[9],"data":[10,32],"structures":[11],"such":[12,31],"as":[13],"caches,":[14],"indexes":[15],"and":[16,116],"materialized":[17],"views.":[18],"this":[20,35,69],"context,":[21],"many":[22],"cost":[23,56,72,84],"models":[24,73,85],"help":[25,86],"select":[26],"a":[27,88,110],"\"best":[28],"set\"":[29],"of":[30,57,80,91,113],"structures.":[33],"However,":[34],"selection":[36],"task":[37],"becomes":[38],"more":[39],"complex":[40],"in":[41,68],"the":[42,54,59,77,92],"cloud.":[43],"The":[44],"criterion":[45],"to":[46],"optimize":[47],"indeed":[49],"at":[50],"least":[51],"two-dimensional,":[52],"with":[53],"monetary":[55],"using":[58],"cloud":[60,81,119],"balancing":[61],"response":[63],"time.":[64],"Thus,":[65],"we":[66,104],"define":[67],"paper":[70],"new":[71],"that":[74,108,118],"fit":[75],"into":[76],"pay-as-you-go":[78],"paradigm":[79],"computing.":[82],"These":[83],"achieve":[87],"multi-criteria":[89],"optimization":[90],"view":[93,120],"materialization":[94,121],"vs.":[95],"CPU":[96],"power":[97],"consumption":[98],"problem,":[99],"under":[100],"budget":[101],"constraints.":[102],"Finally,":[103],"present":[105],"experimental":[106],"results":[107],"provide":[109],"first":[111],"validation":[112],"our":[114],"contribution":[115],"show":[117],"always":[123],"desirable.":[124]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":2},{"year":2015,"cited_by_count":5},{"year":2014,"cited_by_count":6},{"year":2013,"cited_by_count":9},{"year":2012,"cited_by_count":2}],"updated_date":"2026-07-14T23:27:15.235271","created_date":"2025-10-10T00:00:00"}