{"id":"https://openalex.org/W1489872200","doi":"https://doi.org/10.5555/1181849.1181863","title":"Implementing materialized views in an open source database engine","display_name":"Implementing materialized views in an open source database engine","publication_year":2007,"publication_date":"2007-01-01","ids":{"openalex":"https://openalex.org/W1489872200","doi":"https://doi.org/10.5555/1181849.1181863","mag":"1489872200"},"language":"en","primary_location":{"id":"mag:1489872200","is_oa":false,"landing_page_url":"https://dl.acm.org/doi/10.5555/1181849.1181863","pdf_url":null,"source":{"id":"https://openalex.org/S56112914","display_name":"Journal of computing sciences in colleges","issn_l":"1937-4763","issn":["1937-4763","1937-4771"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4361727485","host_organization_name":"Consortium for Computing Sciences in Colleges","host_organization_lineage":["https://openalex.org/P4361727485"],"host_organization_lineage_names":["Consortium for Computing Sciences in Colleges"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"Journal of computing sciences in colleges","raw_type":null},"type":"article","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/A5070739023","display_name":"Anurag Naidu","orcid":null},"institutions":[{"id":"https://openalex.org/I155173764","display_name":"Rochester Institute of Technology","ror":"https://ror.org/00v4yb702","country_code":"US","type":"education","lineage":["https://openalex.org/I155173764"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Anurag Naidu","raw_affiliation_strings":["Rochester\u00a0Institute\u00a0of\u00a0Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Rochester\u00a0Institute\u00a0of\u00a0Technology","institution_ids":["https://openalex.org/I155173764"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037844866","display_name":"Harita Chilukuri","orcid":null},"institutions":[{"id":"https://openalex.org/I155173764","display_name":"Rochester Institute of Technology","ror":"https://ror.org/00v4yb702","country_code":"US","type":"education","lineage":["https://openalex.org/I155173764"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Harita Chilukuri","raw_affiliation_strings":["Rochester\u00a0Institute\u00a0of\u00a0Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Rochester\u00a0Institute\u00a0of\u00a0Technology","institution_ids":["https://openalex.org/I155173764"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5063892011","display_name":"Gaurav Gargate","orcid":null},"institutions":[{"id":"https://openalex.org/I155173764","display_name":"Rochester Institute of Technology","ror":"https://ror.org/00v4yb702","country_code":"US","type":"education","lineage":["https://openalex.org/I155173764"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Gaurav Gargate","raw_affiliation_strings":["Rochester\u00a0Institute\u00a0of\u00a0Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Rochester\u00a0Institute\u00a0of\u00a0Technology","institution_ids":["https://openalex.org/I155173764"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5065055570","display_name":"Sushil Magdum","orcid":null},"institutions":[{"id":"https://openalex.org/I155173764","display_name":"Rochester Institute of Technology","ror":"https://ror.org/00v4yb702","country_code":"US","type":"education","lineage":["https://openalex.org/I155173764"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Sushil Magdum","raw_affiliation_strings":["Rochester\u00a0Institute\u00a0of\u00a0Technology"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Rochester\u00a0Institute\u00a0of\u00a0Technology","institution_ids":["https://openalex.org/I155173764"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5039893757","display_name":"Rajendra K. Raj","orcid":"https://orcid.org/0000-0003-2378-1068"},"institutions":[{"id":"https://openalex.org/I155173764","display_name":"Rochester Institute of Technology","ror":"https://ror.org/00v4yb702","country_code":"US","type":"education","lineage":["https://openalex.org/I155173764"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Rajendra K. Raj","raw_affiliation_strings":["Rochester institute of Technology, Rochester, NY"],"raw_orcid":"https://orcid.org/0000-0003-2378-1068","affiliations":[{"raw_affiliation_string":"Rochester institute of Technology, Rochester, NY","institution_ids":["https://openalex.org/I155173764"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5070739023"],"corresponding_institution_ids":["https://openalex.org/I155173764"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":1,"citation_normalized_percentile":{"value":0.05971142,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"22","issue":"3","first_page":"59","last_page":"59"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9944000244140625,"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.9944000244140625,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9916999936103821,"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/T11719","display_name":"Data Quality and Management","score":0.9890999794006348,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.9313430786132812},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8260407447814941},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.642863929271698},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.5998690724372864},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.5612871646881104},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.550052285194397},{"id":"https://openalex.org/keywords/database-server","display_name":"Database server","score":0.5211905837059021},{"id":"https://openalex.org/keywords/variety","display_name":"Variety (cybernetics)","score":0.4688262641429901},{"id":"https://openalex.org/keywords/server","display_name":"Server","score":0.450755774974823},{"id":"https://openalex.org/keywords/visualization","display_name":"Visualization","score":0.44295060634613037},{"id":"https://openalex.org/keywords/distributed-database","display_name":"Distributed database","score":0.4242894649505615},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.39574134349823},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.39258790016174316},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.36317741870880127},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.15559986233711243}],"concepts":[{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.9313430786132812},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8260407447814941},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.642863929271698},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.5998690724372864},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.5612871646881104},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.550052285194397},{"id":"https://openalex.org/C205295232","wikidata":"https://www.wikidata.org/wiki/Q76320","display_name":"Database server","level":2,"score":0.5211905837059021},{"id":"https://openalex.org/C136197465","wikidata":"https://www.wikidata.org/wiki/Q1729295","display_name":"Variety (cybernetics)","level":2,"score":0.4688262641429901},{"id":"https://openalex.org/C93996380","wikidata":"https://www.wikidata.org/wiki/Q44127","display_name":"Server","level":2,"score":0.450755774974823},{"id":"https://openalex.org/C36464697","wikidata":"https://www.wikidata.org/wiki/Q451553","display_name":"Visualization","level":2,"score":0.44295060634613037},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.4242894649505615},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.39574134349823},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.39258790016174316},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.36317741870880127},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.15559986233711243},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"mag:1489872200","is_oa":false,"landing_page_url":"https://dl.acm.org/doi/10.5555/1181849.1181863","pdf_url":null,"source":{"id":"https://openalex.org/S56112914","display_name":"Journal of computing sciences in colleges","issn_l":"1937-4763","issn":["1937-4763","1937-4771"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4361727485","host_organization_name":"Consortium for Computing Sciences in Colleges","host_organization_lineage":["https://openalex.org/P4361727485"],"host_organization_lineage_names":["Consortium for Computing Sciences in Colleges"],"type":"journal"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":null,"raw_source_name":"Journal of computing sciences in colleges","raw_type":null}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":0,"referenced_works":[],"related_works":["https://openalex.org/W2130275086","https://openalex.org/W2356239617","https://openalex.org/W204909595","https://openalex.org/W89380407","https://openalex.org/W2318712826","https://openalex.org/W2296573204","https://openalex.org/W2070917020","https://openalex.org/W318284924","https://openalex.org/W1987489978","https://openalex.org/W2978004695","https://openalex.org/W2506898509","https://openalex.org/W6804244","https://openalex.org/W1486998273","https://openalex.org/W1979258073","https://openalex.org/W2156751739","https://openalex.org/W1863720712","https://openalex.org/W2766650518","https://openalex.org/W3157531502","https://openalex.org/W140947743","https://openalex.org/W1551434653"],"abstract_inverted_index":{"Materialized":[0,36],"views,":[1],"a":[2,7,26,43],"relatively":[3],"new":[4],"feature":[5],"for":[6,16],"modern":[8,47],"relational":[9],"database":[10,19,27],"system,":[11],"reduce":[12],"query":[13],"processing":[14],"time":[15],"frequently":[17],"accessed":[18],"views.":[20],"In":[21],"essence,":[22],"materialized":[23],"views":[24,37],"provide":[25],"system-managed":[28],"cache":[29],"thus":[30],"improving":[31],"data":[32,51,57,60],"integrity":[33],"and":[34,62],"performance.":[35],"have":[38],"been":[39],"found":[40],"useful":[41],"in":[42],"wide":[44],"variety":[45],"of":[46],"applications":[48],"such":[49],"as":[50],"warehousing,":[52],"replication":[53],"servers,":[54],"chronicle":[55],"or":[56],"recording":[58],"systems,":[59],"visualization,":[61],"mobile":[63],"systems.":[64]},"counts_by_year":[],"updated_date":"2026-04-28T14:05:53.105641","created_date":"2025-10-10T00:00:00"}