乐胖代购免代理版

{"id":"https://openalex.org/W2061751973","doi":"https://doi.org/10.1145/503099.503100","title":"A case for dynamic view management","display_name":"A case for dynamic view management","publication_year":2001,"publication_date":"2001-12-01","ids":{"openalex":"https://openalex.org/W2061751973","doi":"https://doi.org/10.1145/503099.503100","mag":"2061751973"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/503099.503100","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"journal-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/A5055320698","display_name":"Yannis Kotidis","orcid":null},"institutions":[{"id":"https://openalex.org/I1283103587","display_name":"AT&T (United States)","ror":"https://ror.org/02bbd5539","country_code":"US","type":"company","lineage":["https://openalex.org/I1283103587"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Yannis Kotidis","raw_affiliation_strings":["AT&T Labs Research"],"affiliations":[{"raw_affiliation_string":"AT&T Labs Research","institution_ids":["https://openalex.org/I1283103587"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5113488700","display_name":"Nick Roussopoulos","orcid":null},"institutions":[{"id":"https://openalex.org/I66946132","display_name":"University of Maryland, College Park","ror":"https://ror.org/047s2c258","country_code":"US","type":"education","lineage":["https://openalex.org/I66946132"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Nick Roussopoulos","raw_affiliation_strings":["University of Maryland"],"affiliations":[{"raw_affiliation_string":"University of Maryland","institution_ids":["https://openalex.org/I66946132"]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":2,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":3.629,"has_fulltext":false,"cited_by_count":81,"citation_normalized_percentile":{"value":0.969224,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":94,"max":95},"biblio":{"volume":"26","issue":"4","first_page":"388","last_page":"423"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9996,"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.9996,"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/T11106","display_name":"Data Management and Algorithms","score":0.9983,"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"}},{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9932,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.9511524},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.82552147}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9511524},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.92340636},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.82552147},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.7615603},{"id":"https://openalex.org/C4679612","wikidata":"https://www.wikidata.org/wiki/Q866298","display_name":"Aggregate (composite)","level":2,"score":0.5515282},{"id":"https://openalex.org/C177264268","wikidata":"https://www.wikidata.org/wiki/Q1514741","display_name":"Set (abstract data type)","level":2,"score":0.54546636},{"id":"https://openalex.org/C81917197","wikidata":"https://www.wikidata.org/wiki/Q628760","display_name":"Selection (genetic algorithm)","level":2,"score":0.5087462},{"id":"https://openalex.org/C165696696","wikidata":"https://www.wikidata.org/wiki/Q11287","display_name":"Exploit","level":2,"score":0.5059704},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.47506353},{"id":"https://openalex.org/C2776505523","wikidata":"https://www.wikidata.org/wiki/Q4785468","display_name":"Plan (archaeology)","level":2,"score":0.4175484},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3829968},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.36031717},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.20575073},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.10827547},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.08948782},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.0},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0},{"id":"https://openalex.org/C159985019","wikidata":"https://www.wikidata.org/wiki/Q181790","display_name":"Composite material","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}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1145/503099.503100","pdf_url":null,"source":{"id":"https://openalex.org/S90119964","display_name":"ACM Transactions on Database Systems","issn_l":"0362-5915","issn":["0362-5915","1557-4644"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[],"grants":[],"datasets":[],"versions":[],"referenced_works_count":60,"referenced_works":["https://openalex.org/W1485145428","https://openalex.org/W1514949376","https://openalex.org/W1527733826","https://openalex.org/W1538267625","https://openalex.org/W1549717312","https://openalex.org/W1556601737","https://openalex.org/W1563590781","https://openalex.org/W1578513732","https://openalex.org/W1581670235","https://openalex.org/W1581805425","https://openalex.org/W1584914510","https://openalex.org/W1596620276","https://openalex.org/W1596823748","https://openalex.org/W1835416193","https://openalex.org/W187851124","https://openalex.org/W1964345410","https://openalex.org/W1973382888","https://openalex.org/W1975733288","https://openalex.org/W1976590378","https://openalex.org/W1998147193","https://openalex.org/W1999276015","https://openalex.org/W2001852222","https://openalex.org/W2007625694","https://openalex.org/W2012670464","https://openalex.org/W2026745535","https://openalex.org/W2044236594","https://openalex.org/W2044240774","https://openalex.org/W2047809518","https://openalex.org/W2054170837","https://openalex.org/W2058978608","https://openalex.org/W2068739275","https://openalex.org/W2068901259","https://openalex.org/W2069811933","https://openalex.org/W2072764742","https://openalex.org/W2098416578","https://openalex.org/W2103201239","https://openalex.org/W2111845378","https://openalex.org/W2113888164","https://openalex.org/W2114712170","https://openalex.org/W2132582487","https://openalex.org/W2134791164","https://openalex.org/W2143401113","https://openalex.org/W2150950420","https://openalex.org/W2157219191","https://openalex.org/W2160677885","https://openalex.org/W2160983447","https://openalex.org/W2164049396","https://openalex.org/W2171492933","https://openalex.org/W2174672995","https://openalex.org/W2248652221","https://openalex.org/W2287610671","https://openalex.org/W2509242913","https://openalex.org/W2910328769","https://openalex.org/W2918864124","https://openalex.org/W2951321531","https://openalex.org/W3021753108","https://openalex.org/W38346608","https://openalex.org/W4244600136","https://openalex.org/W4255826646","https://openalex.org/W99733817"],"related_works":["https://openalex.org/W6138692","https://openalex.org/W2381646725","https://openalex.org/W2378213774","https://openalex.org/W2367419170","https://openalex.org/W2363019959","https://openalex.org/W2357522326","https://openalex.org/W2343314637","https://openalex.org/W23190051","https://openalex.org/W1988774479","https://openalex.org/W1535822977"],"abstract_inverted_index":{"Materialized":[0],"aggregate":[1,72],"views":[2,73,179],"represent":[3],"a":[4,10,64,75,83,108,153],"set":[5,129],"of":[6,28,36,70,150],"redundant":[7],"entities":[8],"in":[9,74],"data":[11,30,76],"warehouse":[12,31],"that":[13,47,66,91,120,183],"are":[14,92,100],"frequently":[15],"used":[16],"to":[17,24,130,160,168],"accelerate":[18],"On-Line":[19],"Analytical":[20],"Processing":[21],"(OLAP).":[22],"Due":[23],"the":[25,29,33,37,52,112,124,127,139,146,169,173,178,181],"complex":[26],"structure":[27],"and":[32,50,55,126,144,180],"different":[34,174],"profiles":[35],"users":[38],"who":[39],"submit":[40],"queries,":[41],"there":[42],"is":[43],"need":[44],"for":[45,87,95,177],"tools":[46],"will":[48],"automate":[49],"ease":[51],"view":[53,142],"selection":[54,143],"management":[56],"processes.":[57],"In":[58,111],"this":[59],"article":[60],"we":[61,115],"present":[62,116],"DynaMat,":[63],"system":[65],"manages":[67],"dynamic":[68],"collections":[69],"materialized":[71,128,141],"warehouse.":[77],"At":[78],"query":[79],"time,":[80],"DynaMat":[81,137],"utilizes":[82],"dedicated":[84],"disk":[85],"space":[86],"storing":[88],"computed":[89],"aggregates":[90],"further":[93,131],"engaged":[94],"answering":[96],"new":[97],"queries.":[98],"Queries":[99],"executed":[101],"independently":[102],"or":[103],"can":[104],"be":[105],"bundled":[106],"within":[107,152],"multiquery":[109],"expression.":[110],"latter":[113],"case,":[114],"an":[117,162],"execution":[118],"mechanism":[119],"exploits":[121],"dependencies":[122,182],"among":[123,185],"queries":[125],"optimize":[132],"their":[133],"execution.":[134],"During":[135],"updates,":[136],"reconciles":[138],"current":[140],"refreshes":[145],"most":[147],"beneficial":[148],"subset":[149],"it":[151],"given":[154],"maintenance":[155,171],"window.":[156],"We":[157],"show":[158],"how":[159],"derive":[161],"efficient":[163],"update":[164,175],"plan":[165],"with":[166],"respect":[167],"available":[170],"window,":[172],"policies":[176],"exist":[184],"them.":[186]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2061751973","counts_by_year":[{"year":2022,"cited_by_count":3},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":3},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":1},{"year":2016,"cited_by_count":3},{"year":2014,"cited_by_count":4},{"year":2013,"cited_by_count":8},{"year":2012,"cited_by_count":8}],"updated_date":"2025-01-07T11:18:49.095152","created_date":"2016-06-24"}