{"id":"https://openalex.org/W1585730347","doi":"https://doi.org/10.1109/icde.2004.1319994","title":"MTCache: transparent mid-tier database caching in SQL server","display_name":"MTCache: transparent mid-tier database caching in SQL server","publication_year":2004,"publication_date":"2004-09-28","ids":{"openalex":"https://openalex.org/W1585730347","doi":"https://doi.org/10.1109/icde.2004.1319994","mag":"1585730347"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2004.1319994","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2004.1319994","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings. 20th International Conference on Data Engineering","raw_type":"proceedings-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/A5109039470","display_name":"Per-\u00c5ke Larson","orcid":null},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]},{"id":"https://openalex.org/I4210164937","display_name":"Microsoft Research (United Kingdom)","ror":"https://ror.org/05k87vq12","country_code":"GB","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}],"countries":["GB","US"],"is_corresponding":false,"raw_author_name":"P.-A. Larson","raw_affiliation_strings":["Microsoft, Inc., USA","Microsoft , USA "],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft, Inc., USA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"Microsoft , USA ","institution_ids":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5113173708","display_name":"J. Goldstein","orcid":null},"institutions":[{"id":"https://openalex.org/I1290206253","display_name":"Microsoft (United States)","ror":"https://ror.org/00d0nc645","country_code":"US","type":"company","lineage":["https://openalex.org/I1290206253"]},{"id":"https://openalex.org/I4210164937","display_name":"Microsoft Research (United Kingdom)","ror":"https://ror.org/05k87vq12","country_code":"GB","type":"company","lineage":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}],"countries":["GB","US"],"is_corresponding":false,"raw_author_name":"J. Goldstein","raw_affiliation_strings":["Microsoft, Inc., USA","Microsoft , USA "],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft, Inc., USA","institution_ids":["https://openalex.org/I1290206253"]},{"raw_affiliation_string":"Microsoft , USA ","institution_ids":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5057864403","display_name":"Jingren Zhou","orcid":"https://orcid.org/0000-0002-4220-2634"},"institutions":[{"id":"https://openalex.org/I78577930","display_name":"Columbia University","ror":"https://ror.org/00hj8s172","country_code":"US","type":"education","lineage":["https://openalex.org/I78577930"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"J. Zhou","raw_affiliation_strings":["Columbia University, USA","Columbia University"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Columbia University, USA","institution_ids":["https://openalex.org/I78577930"]},{"raw_affiliation_string":"Columbia University","institution_ids":["https://openalex.org/I78577930"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":30.6914,"has_fulltext":false,"cited_by_count":108,"citation_normalized_percentile":{"value":0.99523039,"is_in_top_1_percent":true,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":90,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"177","last_page":"188"},"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.9990000128746033,"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.9990000128746033,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9988999962806702,"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/T11181","display_name":"Advanced Data Storage Technologies","score":0.9986000061035156,"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/computer-science","display_name":"Computer science","score":0.8857924938201904},{"id":"https://openalex.org/keywords/server","display_name":"Server","score":0.7447624206542969},{"id":"https://openalex.org/keywords/log-shipping","display_name":"Log shipping","score":0.7080018520355225},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.662376880645752},{"id":"https://openalex.org/keywords/scalability","display_name":"Scalability","score":0.5982661247253418},{"id":"https://openalex.org/keywords/database-server","display_name":"Database server","score":0.5931405425071716},{"id":"https://openalex.org/keywords/replication","display_name":"Replication (statistics)","score":0.5435568690299988},{"id":"https://openalex.org/keywords/materialized-view","display_name":"Materialized view","score":0.5377894043922424},{"id":"https://openalex.org/keywords/distributed-database","display_name":"Distributed database","score":0.5082609057426453},{"id":"https://openalex.org/keywords/database-tuning","display_name":"Database tuning","score":0.4742680788040161},{"id":"https://openalex.org/keywords/benchmark","display_name":"Benchmark (surveying)","score":0.4574105441570282},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.4526521861553192},{"id":"https://openalex.org/keywords/cache","display_name":"Cache","score":0.45227155089378357},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4486503601074219},{"id":"https://openalex.org/keywords/data-transformation-services","display_name":"Data Transformation Services","score":0.4452214241027832},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.4435877203941345},{"id":"https://openalex.org/keywords/overhead","display_name":"Overhead (engineering)","score":0.4331561326980591},{"id":"https://openalex.org/keywords/application-server","display_name":"Application server","score":0.4222300946712494},{"id":"https://openalex.org/keywords/client\u2013server-model","display_name":"Client\u2013server model","score":0.3365069031715393},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.16969388723373413},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.163397878408432},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.12745332717895508},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.08312883973121643},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.07795336842536926}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8857924938201904},{"id":"https://openalex.org/C93996380","wikidata":"https://www.wikidata.org/wiki/Q44127","display_name":"Server","level":2,"score":0.7447624206542969},{"id":"https://openalex.org/C94925161","wikidata":"https://www.wikidata.org/wiki/Q6666854","display_name":"Log shipping","level":4,"score":0.7080018520355225},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.662376880645752},{"id":"https://openalex.org/C48044578","wikidata":"https://www.wikidata.org/wiki/Q727490","display_name":"Scalability","level":2,"score":0.5982661247253418},{"id":"https://openalex.org/C205295232","wikidata":"https://www.wikidata.org/wiki/Q76320","display_name":"Database server","level":2,"score":0.5931405425071716},{"id":"https://openalex.org/C12590798","wikidata":"https://www.wikidata.org/wiki/Q3933199","display_name":"Replication (statistics)","level":2,"score":0.5435568690299988},{"id":"https://openalex.org/C98199447","wikidata":"https://www.wikidata.org/wiki/Q2445044","display_name":"Materialized view","level":4,"score":0.5377894043922424},{"id":"https://openalex.org/C70061542","wikidata":"https://www.wikidata.org/wiki/Q989016","display_name":"Distributed database","level":2,"score":0.5082609057426453},{"id":"https://openalex.org/C107535962","wikidata":"https://www.wikidata.org/wiki/Q2459880","display_name":"Database tuning","level":4,"score":0.4742680788040161},{"id":"https://openalex.org/C185798385","wikidata":"https://www.wikidata.org/wiki/Q1161707","display_name":"Benchmark (surveying)","level":2,"score":0.4574105441570282},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.4526521861553192},{"id":"https://openalex.org/C115537543","wikidata":"https://www.wikidata.org/wiki/Q165596","display_name":"Cache","level":2,"score":0.45227155089378357},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4486503601074219},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.4452214241027832},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.4435877203941345},{"id":"https://openalex.org/C2779960059","wikidata":"https://www.wikidata.org/wiki/Q7113681","display_name":"Overhead (engineering)","level":2,"score":0.4331561326980591},{"id":"https://openalex.org/C164554305","wikidata":"https://www.wikidata.org/wiki/Q71550","display_name":"Application server","level":2,"score":0.4222300946712494},{"id":"https://openalex.org/C152880691","wikidata":"https://www.wikidata.org/wiki/Q146813","display_name":"Client\u2013server model","level":3,"score":0.3365069031715393},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.16969388723373413},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.163397878408432},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.12745332717895508},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.08312883973121643},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.07795336842536926},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.0},{"id":"https://openalex.org/C13280743","wikidata":"https://www.wikidata.org/wiki/Q131089","display_name":"Geodesy","level":1,"score":0.0},{"id":"https://openalex.org/C205649164","wikidata":"https://www.wikidata.org/wiki/Q1071","display_name":"Geography","level":0,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.2004.1319994","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2004.1319994","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings. 20th International Conference on Data Engineering","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":22,"referenced_works":["https://openalex.org/W1485782945","https://openalex.org/W1563590781","https://openalex.org/W1564133079","https://openalex.org/W1573401580","https://openalex.org/W1968403101","https://openalex.org/W1974901864","https://openalex.org/W2022261236","https://openalex.org/W2028800250","https://openalex.org/W2041881718","https://openalex.org/W2059581035","https://openalex.org/W2072001200","https://openalex.org/W2077515046","https://openalex.org/W2108255083","https://openalex.org/W2118173195","https://openalex.org/W2171492933","https://openalex.org/W2406557711","https://openalex.org/W2918864124","https://openalex.org/W4230607199","https://openalex.org/W4243755493","https://openalex.org/W6633638976","https://openalex.org/W6634328207","https://openalex.org/W6668758487"],"related_works":["https://openalex.org/W3153041035","https://openalex.org/W2581822898","https://openalex.org/W2379273002","https://openalex.org/W2913707658","https://openalex.org/W2349501796","https://openalex.org/W2357250331","https://openalex.org/W2359751531","https://openalex.org/W2364778724","https://openalex.org/W2381938722","https://openalex.org/W3152811026"],"abstract_inverted_index":{"Many":[0],"applications":[1,64],"today":[2],"run":[3],"in":[4,132],"a":[5,15,77,118],"multitier":[6],"environment":[7],"with":[8,147],"browser-based":[9],"clients,":[10],"midtier":[11,79],"(application)":[12],"servers":[13,39],"and":[14,27,73,101,106],"backend":[16,46],"database":[17,20,34,38,80],"server.":[18,47],"Midtier":[19],"caching":[21,72,81],"attempts":[22],"to":[23,36,55,63,128],"improve":[24],"system":[25],"throughput":[26],"scalability":[28],"by":[29],"offloading":[30],"part":[31,120],"of":[32,67,121,140,152],"the":[33,45,68,111,122,137,141],"workload":[35,124],"intermediate":[37,57],"that":[40,50,86,117],"partially":[41],"replicate":[42],"data":[43],"from":[44],"The":[48,114],"fact":[49],"some":[51],"queries":[52,100],"are":[53],"offloaded":[54,127],"an":[56,148],"server":[58,85],"should":[59],"be":[60,126],"completely":[61],"transparent":[62],"-":[65],"one":[66],"key":[69],"distinctions":[70],"between":[71],"replication.":[74,102],"MTCache":[75,105],"is":[76],"prototype":[78],"solution":[82],"for":[83,96],"SQL":[84,93],"achieves":[87],"this":[88],"transparency.":[89],"It":[90],"builds":[91],"on":[92,110,136],"server's":[94],"support":[95],"materialized":[97],"views,":[98],"distributed":[99],"We":[103],"describe":[104],"report":[107],"experimental":[108],"results":[109],"TPC-W":[112],"benchmark.":[113,142],"experiments":[115],"show":[116],"significant":[119],"query":[123],"can":[125],"cache":[129],"servers,":[130],"resulting":[131],"greatly":[133],"improved":[134],"scale-out":[135],"read-dominated":[138],"workloads":[139],"Replication":[143],"overhead":[144],"was":[145],"small":[146],"average":[149],"replication":[150],"delay":[151],"less":[153],"than":[154],"two":[155],"seconds.":[156]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":2},{"year":2020,"cited_by_count":6},{"year":2019,"cited_by_count":1},{"year":2018,"cited_by_count":1},{"year":2017,"cited_by_count":4},{"year":2016,"cited_by_count":3},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":6},{"year":2013,"cited_by_count":6},{"year":2012,"cited_by_count":5}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}