{"id":"https://openalex.org/W2030159528","doi":"https://doi.org/10.14778/2536222.2536248","title":"Microsoft SQL server's integrated database approach for modern applications and hardware","display_name":"Microsoft SQL server's integrated database approach for modern applications and hardware","publication_year":2013,"publication_date":"2013-08-01","ids":{"openalex":"https://openalex.org/W2030159528","doi":"https://doi.org/10.14778/2536222.2536248","mag":"2030159528"},"language":"en","primary_location":{"id":"doi:10.14778/2536222.2536248","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2536222.2536248","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","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/A5009686443","display_name":"David Lomet","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"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"David Lomet","raw_affiliation_strings":["Microsoft Research, Redmond, WA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Microsoft Research, Redmond, WA","institution_ids":["https://openalex.org/I1290206253"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":["https://openalex.org/A5009686443"],"corresponding_institution_ids":["https://openalex.org/I1290206253"],"apc_list":null,"apc_paid":null,"fwci":0.366,"has_fulltext":false,"cited_by_count":5,"citation_normalized_percentile":{"value":0.65415522,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":89,"max":94},"biblio":{"volume":"6","issue":"11","first_page":"1178","last_page":"1179"},"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.9997000098228455,"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.9997000098228455,"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.9993000030517578,"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.9975000023841858,"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.8193026781082153},{"id":"https://openalex.org/keywords/data-transformation-services","display_name":"Data Transformation Services","score":0.7479017972946167},{"id":"https://openalex.org/keywords/exploit","display_name":"Exploit","score":0.6258705258369446},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.6107801795005798},{"id":"https://openalex.org/keywords/sql-server","display_name":"Sql server","score":0.5940842628479004},{"id":"https://openalex.org/keywords/user-defined-function","display_name":"User-defined function","score":0.513794481754303},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.49717357754707336},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.48964768648147583},{"id":"https://openalex.org/keywords/business-intelligence-markup-language","display_name":"Business Intelligence Markup Language","score":0.4723851680755615},{"id":"https://openalex.org/keywords/architecture","display_name":"Architecture","score":0.4243919551372528},{"id":"https://openalex.org/keywords/database-server","display_name":"Database server","score":0.4239412248134613},{"id":"https://openalex.org/keywords/in-memory-processing","display_name":"In-Memory Processing","score":0.4166756570339203},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.41235196590423584},{"id":"https://openalex.org/keywords/log-shipping","display_name":"Log shipping","score":0.39966750144958496},{"id":"https://openalex.org/keywords/client\u2013server-model","display_name":"Client\u2013server model","score":0.3362659215927124},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.2792743742465973},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.23602253198623657},{"id":"https://openalex.org/keywords/server","display_name":"Server","score":0.20103254914283752},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.07553312182426453},{"id":"https://openalex.org/keywords/computer-security","display_name":"Computer security","score":0.06283918023109436}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8193026781082153},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.7479017972946167},{"id":"https://openalex.org/C165696696","wikidata":"https://www.wikidata.org/wiki/Q11287","display_name":"Exploit","level":2,"score":0.6258705258369446},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.6107801795005798},{"id":"https://openalex.org/C2984286706","wikidata":"https://www.wikidata.org/wiki/Q400708","display_name":"Sql server","level":2,"score":0.5940842628479004},{"id":"https://openalex.org/C206384180","wikidata":"https://www.wikidata.org/wiki/Q599380","display_name":"User-defined function","level":5,"score":0.513794481754303},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.49717357754707336},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.48964768648147583},{"id":"https://openalex.org/C114724005","wikidata":"https://www.wikidata.org/wiki/Q5001740","display_name":"Business Intelligence Markup Language","level":5,"score":0.4723851680755615},{"id":"https://openalex.org/C123657996","wikidata":"https://www.wikidata.org/wiki/Q12271","display_name":"Architecture","level":2,"score":0.4243919551372528},{"id":"https://openalex.org/C205295232","wikidata":"https://www.wikidata.org/wiki/Q76320","display_name":"Database server","level":2,"score":0.4239412248134613},{"id":"https://openalex.org/C123593499","wikidata":"https://www.wikidata.org/wiki/Q6008583","display_name":"In-Memory Processing","level":5,"score":0.4166756570339203},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.41235196590423584},{"id":"https://openalex.org/C94925161","wikidata":"https://www.wikidata.org/wiki/Q6666854","display_name":"Log shipping","level":4,"score":0.39966750144958496},{"id":"https://openalex.org/C152880691","wikidata":"https://www.wikidata.org/wiki/Q146813","display_name":"Client\u2013server model","level":3,"score":0.3362659215927124},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.2792743742465973},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.23602253198623657},{"id":"https://openalex.org/C93996380","wikidata":"https://www.wikidata.org/wiki/Q44127","display_name":"Server","level":2,"score":0.20103254914283752},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.07553312182426453},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.06283918023109436},{"id":"https://openalex.org/C142362112","wikidata":"https://www.wikidata.org/wiki/Q735","display_name":"Art","level":0,"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}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.14778/2536222.2536248","is_oa":false,"landing_page_url":"https://doi.org/10.14778/2536222.2536248","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.406.2731","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.406.2731","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://www.vldb.org/pvldb/vol6/p1178-lomet.pdf","raw_type":"text"},{"id":"pmh:oai:CiteSeerX.psu:10.1.1.679.7922","is_oa":false,"landing_page_url":"http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.679.7922","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"http://db.disi.unitn.eu/pages/VLDBProgram/pdf/flash/MS.pdf","raw_type":"text"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.5099999904632568,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":5,"referenced_works":["https://openalex.org/W1963674762","https://openalex.org/W2011395086","https://openalex.org/W2014977566","https://openalex.org/W2020463726","https://openalex.org/W2135003477"],"related_works":["https://openalex.org/W2537627208","https://openalex.org/W637012668","https://openalex.org/W101460764","https://openalex.org/W3154079580","https://openalex.org/W2991049034","https://openalex.org/W976811131","https://openalex.org/W2808265933","https://openalex.org/W2379872950","https://openalex.org/W2359751531","https://openalex.org/W2390642524"],"abstract_inverted_index":{"Recently,":[0],"there":[1],"has":[2,38,90],"been":[3,39],"much":[4],"renewed":[5],"interest":[6],"in":[7,82],"re-architecting":[8],"database":[9,60],"systems":[10,61],"to":[11,40],"exploit":[12],"new":[13],"hardware.":[14],"While":[15],"some":[16],"efforts":[17],"have":[18],"suggested":[19],"that":[20,62],"one":[21],"needs":[22],"specialized":[23],"engines":[24],"(\"one":[25],"size":[26],"does":[27],"not":[28],"fit":[29],"all\"),":[30],"the":[31,86],"approach":[32],"pursued":[33],"by":[34,54],"Microsoft's":[35],"SQL":[36,87],"Server":[37,88],"integrate":[41],"multiple":[42,67],"elements":[43],"into":[44],"a":[45],"common":[46],"architecture.":[47],"This":[48,69],"brings":[49],"customers":[50],"what":[51,85],"they":[52,63],"want":[53],"reducing":[55],"data":[56],"impedance":[57],"mismatches":[58],"between":[59],"are":[64],"using":[65],"for":[66],"purposes.":[68],"integration":[70],"is,":[71,81],"of":[72],"course,":[73],"more":[74],"easily":[75],"said":[76],"than":[77],"done.":[78,91],"But":[79],"this":[80],"fact,":[83],"precisely":[84],"team":[89]},"counts_by_year":[{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":1},{"year":2016,"cited_by_count":1}],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}