{"id":"https://openalex.org/W2039555859","doi":"https://doi.org/10.1002/(sici)1520-684x(200005)31:5<86::aid-scj8>3.0.co;2-w","title":"An efficient procedure for maintaining materialized views on distributed database systems","display_name":"An efficient procedure for maintaining materialized views on distributed database systems","publication_year":2000,"publication_date":"2000-05-01","ids":{"openalex":"https://openalex.org/W2039555859","doi":"https://doi.org/10.1002/(sici)1520-684x(200005)31:5<86::aid-scj8>3.0.co;2-w","mag":"2039555859"},"language":"en","primary_location":{"id":"doi:10.1002/(sici)1520-684x(200005)31:5<86::aid-scj8>3.0.co;2-w","is_oa":false,"landing_page_url":"https://doi.org/10.1002/(sici)1520-684x(200005)31:5<86::aid-scj8>3.0.co;2-w","pdf_url":null,"source":{"id":"https://openalex.org/S58208175","display_name":"Systems and Computers in Japan","issn_l":"0882-1666","issn":["0882-1666","1520-684X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Systems and Computers in Japan","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/A5066531799","display_name":"Takeya Kasukawa","orcid":"https://orcid.org/0000-0001-5085-0802"},"institutions":[{"id":"https://openalex.org/I98285908","display_name":"Osaka University","ror":"https://ror.org/035t8zc32","country_code":"JP","type":"education","lineage":["https://openalex.org/I98285908"]}],"countries":["JP"],"is_corresponding":true,"raw_author_name":"Takeya Kasukawa","raw_affiliation_strings":["Graduate School of Engineering Science, Osaka University, Toyonaka, Japan 560-8531","Graduate School of Engineering Science, Osaka University, Toyonaka, Japan 560-8531#TAB#"],"affiliations":[{"raw_affiliation_string":"Graduate School of Engineering Science, Osaka University, Toyonaka, Japan 560-8531","institution_ids":["https://openalex.org/I98285908"]},{"raw_affiliation_string":"Graduate School of Engineering Science, Osaka University, Toyonaka, Japan 560-8531#TAB#","institution_ids":["https://openalex.org/I98285908"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5102114247","display_name":"Michio Nakanishi","orcid":null},"institutions":[{"id":"https://openalex.org/I98285908","display_name":"Osaka University","ror":"https://ror.org/035t8zc32","country_code":"JP","type":"education","lineage":["https://openalex.org/I98285908"]}],"countries":["JP"],"is_corresponding":false,"raw_author_name":"Michio Nakanishi","raw_affiliation_strings":["Education Center for Information Processing, Osaka University, Toyonaka, Japan 560-8531","Education Center for Information Processing, Osaka University, Toyonaka, Japan 560\u20108531"],"affiliations":[{"raw_affiliation_string":"Education Center for Information Processing, Osaka University, Toyonaka, Japan 560-8531","institution_ids":["https://openalex.org/I98285908"]},{"raw_affiliation_string":"Education Center for Information Processing, Osaka University, Toyonaka, Japan 560\u20108531","institution_ids":["https://openalex.org/I98285908"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5007909918","display_name":"Hideo Matsuda","orcid":"https://orcid.org/0000-0002-4701-3779"},"institutions":[{"id":"https://openalex.org/I98285908","display_name":"Osaka University","ror":"https://ror.org/035t8zc32","country_code":"JP","type":"education","lineage":["https://openalex.org/I98285908"]}],"countries":["JP"],"is_corresponding":false,"raw_author_name":"Hideo Matsuda","raw_affiliation_strings":["Graduate School of Engineering Science, Osaka University, Toyonaka, Japan 560-8531","Graduate School of Engineering Science, Osaka University, Toyonaka, Japan 560-8531#TAB#"],"affiliations":[{"raw_affiliation_string":"Graduate School of Engineering Science, Osaka University, Toyonaka, Japan 560-8531","institution_ids":["https://openalex.org/I98285908"]},{"raw_affiliation_string":"Graduate School of Engineering Science, Osaka University, Toyonaka, Japan 560-8531#TAB#","institution_ids":["https://openalex.org/I98285908"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5102947671","display_name":"Akihiro Hashimoto","orcid":"https://orcid.org/0000-0002-8409-1688"},"institutions":[{"id":"https://openalex.org/I98285908","display_name":"Osaka University","ror":"https://ror.org/035t8zc32","country_code":"JP","type":"education","lineage":["https://openalex.org/I98285908"]}],"countries":["JP"],"is_corresponding":false,"raw_author_name":"Akihiro Hashimoto","raw_affiliation_strings":["Graduate School of Engineering Science, Osaka University, Toyonaka, Japan 560-8531","Graduate School of Engineering Science, Osaka University, Toyonaka, Japan 560-8531#TAB#"],"affiliations":[{"raw_affiliation_string":"Graduate School of Engineering Science, Osaka University, Toyonaka, Japan 560-8531","institution_ids":["https://openalex.org/I98285908"]},{"raw_affiliation_string":"Graduate School of Engineering Science, Osaka University, Toyonaka, Japan 560-8531#TAB#","institution_ids":["https://openalex.org/I98285908"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":4,"corresponding_author_ids":["https://openalex.org/A5066531799"],"corresponding_institution_ids":["https://openalex.org/I98285908"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.08869583,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"31","issue":"5","first_page":"86","last_page":"96"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10621","display_name":"Gene Regulatory Network Analysis","score":0.9941999912261963,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},"topics":[{"id":"https://openalex.org/T10621","display_name":"Gene Regulatory Network Analysis","score":0.9941999912261963,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},{"id":"https://openalex.org/T12029","display_name":"DNA and Biological Computing","score":0.9815000295639038,"subfield":{"id":"https://openalex.org/subfields/1312","display_name":"Molecular Biology"},"field":{"id":"https://openalex.org/fields/13","display_name":"Biochemistry, Genetics and Molecular Biology"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}},{"id":"https://openalex.org/T10715","display_name":"Distributed and Parallel Computing Systems","score":0.960099995136261,"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.9319047927856445},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8339301347732544},{"id":"https://openalex.org/keywords/relation","display_name":"Relation (database)","score":0.7668020725250244},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.7421060800552368},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.7204047441482544},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.6696895360946655},{"id":"https://openalex.org/keywords/base","display_name":"Base (topology)","score":0.6322808265686035},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5450147390365601},{"id":"https://openalex.org/keywords/distributed-database","display_name":"Distributed database","score":0.5120449662208557},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.48907095193862915},{"id":"https://openalex.org/keywords/query-plan","display_name":"Query plan","score":0.4582149386405945},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.3739999830722809},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.3584861755371094},{"id":"https://openalex.org/keywords/sargable","display_name":"Sargable","score":0.27736496925354004},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.2398645579814911},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.17012298107147217},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.13925126194953918},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.11992150545120239}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9319047927856445},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8339301347732544},{"id":"https://openalex.org/C25343380","wikidata":"https://www.wikidata.org/wiki/Q277521","display_name":"Relation (database)","level":2,"score":0.7668020725250244},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.7421060800552368},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.7204047441482544},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.6696895360946655},{"id":"https://openalex.org/C42058472","wikidata":"https://www.wikidata.org/wiki/Q810214","display_name":"Base (topology)","level":2,"score":0.6322808265686035},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5450147390365601},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.5120449662208557},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.48907095193862915},{"id":"https://openalex.org/C2779729312","wikidata":"https://www.wikidata.org/wiki/Q784232","display_name":"Query plan","level":5,"score":0.4582149386405945},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.3739999830722809},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.3584861755371094},{"id":"https://openalex.org/C192939062","wikidata":"https://www.wikidata.org/wiki/Q104840822","display_name":"Sargable","level":4,"score":0.27736496925354004},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.2398645579814911},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.17012298107147217},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.13925126194953918},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.11992150545120239},{"id":"https://openalex.org/C134306372","wikidata":"https://www.wikidata.org/wiki/Q7754","display_name":"Mathematical analysis","level":1,"score":0.0},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1002/(sici)1520-684x(200005)31:5<86::aid-scj8>3.0.co;2-w","is_oa":false,"landing_page_url":"https://doi.org/10.1002/(sici)1520-684x(200005)31:5<86::aid-scj8>3.0.co;2-w","pdf_url":null,"source":{"id":"https://openalex.org/S58208175","display_name":"Systems and Computers in Japan","issn_l":"0882-1666","issn":["0882-1666","1520-684X"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Systems and Computers in Japan","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Reduced inequalities","score":0.46000000834465027,"id":"https://metadata.un.org/sdg/10"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":16,"referenced_works":["https://openalex.org/W1497285001","https://openalex.org/W1968210840","https://openalex.org/W1973382888","https://openalex.org/W1995999642","https://openalex.org/W2012670464","https://openalex.org/W2028864278","https://openalex.org/W2102060767","https://openalex.org/W2116476518","https://openalex.org/W2131165411","https://openalex.org/W6629870147","https://openalex.org/W6643474629","https://openalex.org/W6649511929","https://openalex.org/W6653437496","https://openalex.org/W6675569933","https://openalex.org/W6678326788","https://openalex.org/W6697199873"],"related_works":["https://openalex.org/W2347305876","https://openalex.org/W16924853","https://openalex.org/W1021093982","https://openalex.org/W2382405670","https://openalex.org/W1582942928","https://openalex.org/W1490264602","https://openalex.org/W3193790833","https://openalex.org/W2955180461","https://openalex.org/W1487803663","https://openalex.org/W2549774162"],"abstract_inverted_index":{"This":[0,178],"paper":[1,112,179],"considers":[2],"a":[3,57,87,126],"distributed":[4,54],"database":[5,55,102,216],"represented":[6],"by":[7,28],"the":[8,18,21,29,33,37,45,49,53,61,67,72,75,79,91,94,101,104,111,118,123,129,134,139,147,166,169,172,181,184,189,193,201,209,215],"relational":[9],"model,":[10],"and":[11,116,187,192],"proposes":[12],"an":[13],"efficient":[14],"procedure":[15],"to":[16,41,71,97,114,165,197],"reflect":[17,42],"update":[19,73],"of":[20,44,74,93,122,128,138,171,183,195],"base":[22,34,46,76,95,173],"relation":[23,35,47,96,174],"for":[24,66,217],"materialized":[25,50,68,105,135,142],"views":[26,51],"defined":[27],"inequality":[30,130],"query":[31,81,131,151],"from":[32],"in":[36,52,100,110,150,214],"element":[38],"database.":[39],"Methods":[40],"updates":[43],"on":[48],"include":[56],"method":[58,88,108,211],"that":[59,89,208],"calculates":[60],"tuple":[62,124],"inserted":[63],"or":[64],"deleted":[65],"view":[69],"due":[70],"relation,":[77],"using":[78],"existing":[80,202],"processing":[82,152],"procedure,":[83],"as":[84,86,133],"well":[85],"stores":[90],"copy":[92,170],"be":[98,154,162,198],"utilized":[99],"containing":[103],"view.":[106,143],"The":[107,156],"proposed":[109,185,210],"is":[113,175,205,212],"store":[115],"utilize":[117],"key":[119],"attribute":[120],"value":[121],"satisfying":[125],"part":[127],"condition":[132],"view,":[136],"independently":[137],"originally":[140],"considered":[141],"By":[144],"this":[145],"mechanism,":[146],"communication":[148,190],"cost":[149,191],"can":[153,160],"reduced.":[155],"required":[157],"memory":[158],"area":[159],"also":[161,206],"reduced,":[163],"compared":[164],"case":[167],"where":[168],"directly":[176],"stored.":[177],"shows":[180],"validity":[182],"method,":[186],"compares":[188],"amount":[194],"data":[196],"stored,":[199],"versus":[200],"method.":[203],"It":[204],"shown":[207],"useful":[213],"molecular":[218],"biology.":[219],"\u00a9":[220],"2000":[221,229],"Scripta":[222],"Technica,":[223],"Syst":[224],"Comp":[225],"Jpn,":[226],"31(5):":[227],"86\u201396,":[228]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}