{"id":"https://openalex.org/W97945502","doi":null,"title":"Speeding Up Materialized View Maintenance Using Cheap Filters at the Warehouse","display_name":"Speeding Up Materialized View Maintenance Using Cheap Filters at the Warehouse","alternate_titles":[],"publication_year":1999,"publication_date":"1999-01-01","ids":{"openalex":"https://openalex.org/W97945502","mag":"97945502"},"language":"en","primary_location":{"id":"mag:97945502","doi":null,"is_oa":false,"landing_page_url":"http://dbpubs.stanford.edu/pub/1999-28","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},"parent_works":[],"lineage":["https://openalex.org/W97945502"],"child_works_count":0,"type":"article","is_traditional":true,"indexed_in":[],"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/A5042592027","display_name":"Nam Huyn","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":true,"contributor_roles":[],"raw_author_name":"Nam Huyn","raw_affiliation_strings":[],"raw_orcid":null,"affiliations":[]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":["https://openalex.org/A5042592027"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":2,"reviewed_by_count":0,"citation_normalized_percentile":{"value":0.0,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":93},"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9984999895095825,"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/T10317","display_name":"Advanced Database Systems and Queries","score":0.9984999895095825,"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/T11106","display_name":"Data Management and Algorithms","score":0.0003000000142492354,"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/T11891","display_name":"Big Data and Business Intelligence","score":0.00019999999494757503,"subfield":{"id":"https://openalex.org/subfields/1404","display_name":"Management Information Systems"},"field":{"id":"https://openalex.org/fields/14","display_name":"Business, Management and Accounting"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/materialized-view-maintenance","display_name":"materialized view maintenance","score":0.9800000190734863},{"id":"https://openalex.org/keywords/incremental-view-maintenance","display_name":"incremental view maintenance","score":0.8410000205039978},{"id":"https://openalex.org/keywords/conjunctive-queries","display_name":"conjunctive queries","score":0.925000011920929},{"id":"https://openalex.org/keywords/runtime-optimization","display_name":"runtime optimization","score":0.625}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9486868381500244},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7567776441574097},{"id":"https://openalex.org/C68339613","wikidata":"https://www.wikidata.org/wiki/Q1549489","display_name":"Speedup","level":2,"score":0.748134195804596},{"id":"https://openalex.org/C55166926","wikidata":"https://www.wikidata.org/wiki/Q2892946","display_name":"Oracle","level":2,"score":0.7314645051956177},{"id":"https://openalex.org/C42058472","wikidata":"https://www.wikidata.org/wiki/Q810214","display_name":"Base (topology)","level":2,"score":0.6417285203933716},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.61937415599823},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.6043304800987244},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5632597208023071},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5552039742469788},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.44630664587020874},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.22573649883270264},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.18600308895111084},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.1727723777294159},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.13960576057434082},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.08225741982460022},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"mag:97945502","doi":null,"is_oa":false,"landing_page_url":"http://dbpubs.stanford.edu/pub/1999-28","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":null},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.17.7396","doi":null,"is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.17.7396","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www-db.stanford.edu/pub/papers/vmf.ps","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":13,"referenced_works":["https://openalex.org/W52840101","https://openalex.org/W180056467","https://openalex.org/W1497285001","https://openalex.org/W1568393695","https://openalex.org/W1569140596","https://openalex.org/W1968378971","https://openalex.org/W2038947899","https://openalex.org/W2054458150","https://openalex.org/W2134600551","https://openalex.org/W2137935534","https://openalex.org/W2160825121","https://openalex.org/W2160983447","https://openalex.org/W2462092264"],"related_works":["https://openalex.org/W7097676043","https://openalex.org/W1916111770","https://openalex.org/W3004349271","https://openalex.org/W2118385974","https://openalex.org/W2038176938","https://openalex.org/W2989084213","https://openalex.org/W254982000","https://openalex.org/W2981846407","https://openalex.org/W2367157686","https://openalex.org/W7100376096"],"abstract_inverted_index":{"We":[0,64],"consider":[1],"the":[2,7,36,58,61,73,76,80],"problem":[3],"of":[4,10,32,69,79],"speeding":[5],"up":[6],"incremental":[8],"maintenance":[9],"materialized":[11],"views":[12,59],"defined":[13],"by":[14,47],"conjunctive":[15],"queries":[16],"(CQ)":[17],"over":[18],"external":[19],"base":[20,25,37,49],"relations,":[21,38],"when":[22],"querying":[23],"these":[24],"relations":[26],"is":[27,44],"expensive.":[28],"Our":[29],"approach":[30],"consists":[31],"detecting,":[33],"without":[34],"using":[35,56],"situations":[39],"where":[40],"a":[41,48],"view":[42,70],"either":[43],"not":[45],"a#ected":[46],"update":[50],"(VDU)":[51],"or":[52],"can":[53],"be":[54],"maintained":[55],"only":[57],"in":[60],"warehouse":[62,81],"(VSM).":[63],"are":[65],"doing":[66],"runtime":[67],"optimization":[68],"maintenance,":[71],"since":[72],"tests":[74],"take":[75],"current":[77],"state":[78],"database":[82],"into":[83],"account.":[84],"Testing":[85],"VSM":[86]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W97945502","counts_by_year":[{"year":2012,"cited_by_count":1}],"updated_date":"2026-11-15T12:55:33.944570","created_date":"2016-06-24T00:00:00"}
