{"id":"https://openalex.org/W1487010321","doi":"https://doi.org/10.1109/icde.2015.7113371","title":"Evolving the architecture of SQL Server for modern hardware trends","display_name":"Evolving the architecture of SQL Server for modern hardware trends","publication_year":2015,"publication_date":"2015-04-01","ids":{"openalex":"https://openalex.org/W1487010321","doi":"https://doi.org/10.1109/icde.2015.7113371","mag":"1487010321"},"language":"en","primary_location":{"id":"doi:10.1109/icde.2015.7113371","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2015.7113371","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 IEEE 31st 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":"Per-Ake Larson","raw_affiliation_strings":["Microsoft","Microsoft , USA "],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft","institution_ids":["https://openalex.org/I4210164937"]},{"raw_affiliation_string":"Microsoft , USA ","institution_ids":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5112728890","display_name":"Eric N. Hanson","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":"Eric N. Hanson","raw_affiliation_strings":["Microsoft","Microsoft , USA "],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft","institution_ids":["https://openalex.org/I4210164937"]},{"raw_affiliation_string":"Microsoft , USA ","institution_ids":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5091124872","display_name":"Mike Zwilling","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":"Mike Zwilling","raw_affiliation_strings":["Microsoft","Microsoft , USA "],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft","institution_ids":["https://openalex.org/I4210164937"]},{"raw_affiliation_string":"Microsoft , USA ","institution_ids":["https://openalex.org/I1290206253","https://openalex.org/I4210164937"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":3,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":1.7533,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.85770945,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":96},"biblio":{"volume":"5","issue":null,"first_page":"1239","last_page":"1245"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9998999834060669,"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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9998999834060669,"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/T10317","display_name":"Advanced Database Systems and Queries","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"}},{"id":"https://openalex.org/T11181","display_name":"Advanced Data Storage Technologies","score":0.9983999729156494,"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.8524642586708069},{"id":"https://openalex.org/keywords/online-transaction-processing","display_name":"Online transaction processing","score":0.7587276697158813},{"id":"https://openalex.org/keywords/in-memory-processing","display_name":"In-Memory Processing","score":0.6765643954277039},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.576000988483429},{"id":"https://openalex.org/keywords/online-analytical-processing","display_name":"Online analytical processing","score":0.5179711580276489},{"id":"https://openalex.org/keywords/transaction-processing","display_name":"Transaction processing","score":0.5143030881881714},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5119799375534058},{"id":"https://openalex.org/keywords/sql-server","display_name":"Sql server","score":0.5048752427101135},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.48691046237945557},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.48120978474617004},{"id":"https://openalex.org/keywords/data-transformation-services","display_name":"Data Transformation Services","score":0.479610800743103},{"id":"https://openalex.org/keywords/column","display_name":"Column (typography)","score":0.4647136926651001},{"id":"https://openalex.org/keywords/transactional-memory","display_name":"Transactional memory","score":0.4625059962272644},{"id":"https://openalex.org/keywords/workload","display_name":"Workload","score":0.4393959045410156},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.4373752176761627},{"id":"https://openalex.org/keywords/log-shipping","display_name":"Log shipping","score":0.420066773891449},{"id":"https://openalex.org/keywords/transaction-data","display_name":"Transaction data","score":0.41048532724380493},{"id":"https://openalex.org/keywords/database-transaction","display_name":"Database transaction","score":0.38629966974258423},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.2953881025314331},{"id":"https://openalex.org/keywords/client\u2013server-model","display_name":"Client\u2013server model","score":0.26439785957336426},{"id":"https://openalex.org/keywords/data-warehouse","display_name":"Data warehouse","score":0.2442077398300171},{"id":"https://openalex.org/keywords/server","display_name":"Server","score":0.2175191044807434},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.16937679052352905},{"id":"https://openalex.org/keywords/computer-network","display_name":"Computer network","score":0.07556629180908203}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8524642586708069},{"id":"https://openalex.org/C191087605","wikidata":"https://www.wikidata.org/wiki/Q1501395","display_name":"Online transaction processing","level":4,"score":0.7587276697158813},{"id":"https://openalex.org/C123593499","wikidata":"https://www.wikidata.org/wiki/Q6008583","display_name":"In-Memory Processing","level":5,"score":0.6765643954277039},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.576000988483429},{"id":"https://openalex.org/C201932085","wikidata":"https://www.wikidata.org/wiki/Q642514","display_name":"Online analytical processing","level":3,"score":0.5179711580276489},{"id":"https://openalex.org/C72108876","wikidata":"https://www.wikidata.org/wiki/Q844565","display_name":"Transaction processing","level":3,"score":0.5143030881881714},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5119799375534058},{"id":"https://openalex.org/C2984286706","wikidata":"https://www.wikidata.org/wiki/Q400708","display_name":"Sql server","level":2,"score":0.5048752427101135},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.48691046237945557},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.48120978474617004},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.479610800743103},{"id":"https://openalex.org/C2780551164","wikidata":"https://www.wikidata.org/wiki/Q2306599","display_name":"Column (typography)","level":3,"score":0.4647136926651001},{"id":"https://openalex.org/C134277064","wikidata":"https://www.wikidata.org/wiki/Q878206","display_name":"Transactional memory","level":3,"score":0.4625059962272644},{"id":"https://openalex.org/C2778476105","wikidata":"https://www.wikidata.org/wiki/Q628539","display_name":"Workload","level":2,"score":0.4393959045410156},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.4373752176761627},{"id":"https://openalex.org/C94925161","wikidata":"https://www.wikidata.org/wiki/Q6666854","display_name":"Log shipping","level":4,"score":0.420066773891449},{"id":"https://openalex.org/C127722929","wikidata":"https://www.wikidata.org/wiki/Q7833714","display_name":"Transaction data","level":3,"score":0.41048532724380493},{"id":"https://openalex.org/C75949130","wikidata":"https://www.wikidata.org/wiki/Q848010","display_name":"Database transaction","level":2,"score":0.38629966974258423},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.2953881025314331},{"id":"https://openalex.org/C152880691","wikidata":"https://www.wikidata.org/wiki/Q146813","display_name":"Client\u2013server model","level":3,"score":0.26439785957336426},{"id":"https://openalex.org/C135572916","wikidata":"https://www.wikidata.org/wiki/Q193351","display_name":"Data warehouse","level":2,"score":0.2442077398300171},{"id":"https://openalex.org/C93996380","wikidata":"https://www.wikidata.org/wiki/Q44127","display_name":"Server","level":2,"score":0.2175191044807434},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.16937679052352905},{"id":"https://openalex.org/C31258907","wikidata":"https://www.wikidata.org/wiki/Q1301371","display_name":"Computer network","level":1,"score":0.07556629180908203},{"id":"https://openalex.org/C126042441","wikidata":"https://www.wikidata.org/wiki/Q1324888","display_name":"Frame (networking)","level":2,"score":0.0},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.0},{"id":"https://openalex.org/C153349607","wikidata":"https://www.wikidata.org/wiki/Q36649","display_name":"Visual arts","level":1,"score":0.0},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"score":0.0},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/icde.2015.7113371","is_oa":false,"landing_page_url":"https://doi.org/10.1109/icde.2015.7113371","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2015 IEEE 31st International Conference on Data Engineering","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.4399999976158142,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":9,"referenced_works":["https://openalex.org/W1549799160","https://openalex.org/W1963674762","https://openalex.org/W2010908209","https://openalex.org/W2011395086","https://openalex.org/W2014977566","https://openalex.org/W2020463726","https://openalex.org/W2135003477","https://openalex.org/W2399381860","https://openalex.org/W6712726491"],"related_works":["https://openalex.org/W2978286473","https://openalex.org/W4229729417","https://openalex.org/W637012668","https://openalex.org/W1487010321","https://openalex.org/W2529489995","https://openalex.org/W2099290222","https://openalex.org/W1144128981","https://openalex.org/W2512476881","https://openalex.org/W2379872950","https://openalex.org/W1526644996"],"abstract_inverted_index":{"The":[0,97],"basic":[1],"architecture":[2],"of":[3,56,75,117,120],"SQL":[4,80],"Server,":[5],"as":[6,8],"well":[7],"other":[9],"major":[10],"database":[11],"systems,":[12],"goes":[13],"back":[14],"to":[15,69],"a":[16,30],"time":[17],"when":[18],"main":[19,53],"memories":[20],"were":[21],"(very)":[22],"small,":[23],"data":[24],"lived":[25],"on":[26,106],"disk,":[27],"machines":[28],"had":[29],"single":[31],"(slow)":[32],"processor,":[33],"and":[34,58,61,72,89,108,124],"OLTP":[35],"was":[36],"the":[37,76,93,118,121,125],"only":[38],"workload":[39],"that":[40],"mattered.":[41],"This":[42,112],"is":[43],"not":[44],"an":[45,115],"optimal":[46],"design":[47,119],"for":[48,85],"today's":[49],"environment":[50],"with":[51],"large":[52],"memories,":[54],"plenty":[55],"cores,":[57],"where":[59],"transactional":[60,109],"analytical":[62,107],"processing":[63],"are":[64,100],"equally":[65],"important.":[66],"To":[67],"adapt":[68],"these":[70],"trends":[71],"take":[73],"advantage":[74],"opportunities":[77],"they":[78,128],"offer":[79],"Server":[81],"has":[82],"added":[83],"support":[84],"column":[86],"store":[87],"indexes":[88],"in-memory":[90],"tables":[91],"over":[92],"last":[94],"two":[95,98,122],"releases.":[96],"features":[99,123],"aimed":[101],"at":[102],"dramatically":[103],"improving":[104],"performance":[105,126],"workloads,":[110],"respectively.":[111],"paper":[113],"gives":[114],"overview":[116],"improvements":[127],"provide.":[129]},"counts_by_year":[{"year":2020,"cited_by_count":1},{"year":2018,"cited_by_count":2},{"year":2017,"cited_by_count":2},{"year":2016,"cited_by_count":1}],"updated_date":"2026-06-11T09:08:48.828518","created_date":"2025-10-10T00:00:00"}