{"id":"https://openalex.org/W1966558147","doi":"https://doi.org/10.1145/1376616.1376725","title":".NET database programmability and extensibility in microsoft SQL server","display_name":".NET database programmability and extensibility in microsoft SQL server","publication_year":2008,"publication_date":"2008-06-09","ids":{"openalex":"https://openalex.org/W1966558147","doi":"https://doi.org/10.1145/1376616.1376725","mag":"1966558147"},"language":"en","primary_location":{"id":"doi:10.1145/1376616.1376725","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1376616.1376725","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2008 ACM SIGMOD international conference on Management of data","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/A5083815095","display_name":"Jos\u00e9 A. Blakeley","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":"Jos\u00e9 A. Blakeley","raw_affiliation_strings":["Microsoft Corporation, Redmond, WA, USA"],"affiliations":[{"raw_affiliation_string":"Microsoft Corporation, Redmond, WA, USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5021909209","display_name":"Vineet Rao","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":false,"raw_author_name":"Vineet Rao","raw_affiliation_strings":["Microsoft Corporation, Redmond, WA, USA"],"affiliations":[{"raw_affiliation_string":"Microsoft Corporation, Redmond, WA, USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5033462078","display_name":"Isaac Kunen","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":false,"raw_author_name":"Isaac Kunen","raw_affiliation_strings":["Microsoft Corporation, Redmond, WA, USA"],"affiliations":[{"raw_affiliation_string":"Microsoft Corporation, Redmond, WA, USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5037955437","display_name":"Adam Prout","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":false,"raw_author_name":"Adam Prout","raw_affiliation_strings":["Microsoft Corporation, Redmond, WA, USA"],"affiliations":[{"raw_affiliation_string":"Microsoft Corporation, Redmond, WA, USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5024545358","display_name":"Mat Henaire","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":false,"raw_author_name":"Mat Henaire","raw_affiliation_strings":["Microsoft Corporation, Redmond, WA, USA"],"affiliations":[{"raw_affiliation_string":"Microsoft Corporation, Redmond, WA, USA","institution_ids":["https://openalex.org/I1290206253"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5010059772","display_name":"Christian Kleinerman","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":false,"raw_author_name":"Christian Kleinerman","raw_affiliation_strings":["Microsoft Corporation, Redmond, WA, USA"],"affiliations":[{"raw_affiliation_string":"Microsoft Corporation, Redmond, WA, USA","institution_ids":["https://openalex.org/I1290206253"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5083815095"],"corresponding_institution_ids":["https://openalex.org/I1290206253"],"apc_list":null,"apc_paid":null,"fwci":3.4305,"has_fulltext":false,"cited_by_count":28,"citation_normalized_percentile":{"value":0.92644818,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":99},"biblio":{"volume":null,"issue":null,"first_page":"1087","last_page":"1098"},"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.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/T10317","display_name":"Advanced Database Systems and Queries","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/T10772","display_name":"Distributed systems and fault tolerance","score":0.9944999814033508,"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/T11106","display_name":"Data Management and Algorithms","score":0.9937000274658203,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"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.8641190528869629},{"id":"https://openalex.org/keywords/user-defined-function","display_name":"User-defined function","score":0.7767148017883301},{"id":"https://openalex.org/keywords/language-integrated-query","display_name":"Language Integrated Query","score":0.7656773328781128},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.6123889088630676},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5411483645439148},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.5231503248214722},{"id":"https://openalex.org/keywords/data-transformation-services","display_name":"Data Transformation Services","score":0.5211129784584045},{"id":"https://openalex.org/keywords/extensibility","display_name":"Extensibility","score":0.5038022398948669},{"id":"https://openalex.org/keywords/programming-language","display_name":"Programming language","score":0.4854350686073303},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.47296303510665894},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.42604243755340576},{"id":"https://openalex.org/keywords/operating-system","display_name":"Operating system","score":0.4256141185760498},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.33499085903167725},{"id":"https://openalex.org/keywords/world-wide-web","display_name":"World Wide Web","score":0.14875611662864685}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8641190528869629},{"id":"https://openalex.org/C206384180","wikidata":"https://www.wikidata.org/wiki/Q599380","display_name":"User-defined function","level":5,"score":0.7767148017883301},{"id":"https://openalex.org/C179531526","wikidata":"https://www.wikidata.org/wiki/Q595637","display_name":"Language Integrated Query","level":5,"score":0.7656773328781128},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.6123889088630676},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5411483645439148},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.5231503248214722},{"id":"https://openalex.org/C141589383","wikidata":"https://www.wikidata.org/wiki/Q644775","display_name":"Data Transformation Services","level":5,"score":0.5211129784584045},{"id":"https://openalex.org/C32833848","wikidata":"https://www.wikidata.org/wiki/Q4115054","display_name":"Extensibility","level":2,"score":0.5038022398948669},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.4854350686073303},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.47296303510665894},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.42604243755340576},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.4256141185760498},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.33499085903167725},{"id":"https://openalex.org/C136764020","wikidata":"https://www.wikidata.org/wiki/Q466","display_name":"World Wide Web","level":1,"score":0.14875611662864685},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","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}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/1376616.1376725","is_oa":false,"landing_page_url":"https://doi.org/10.1145/1376616.1376725","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the 2008 ACM SIGMOD international conference on Management of data","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"score":0.41999998688697815,"id":"https://metadata.un.org/sdg/8","display_name":"Decent work and economic growth"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":8,"referenced_works":["https://openalex.org/W1583928555","https://openalex.org/W1802428003","https://openalex.org/W1973524520","https://openalex.org/W2061587502","https://openalex.org/W2153670461","https://openalex.org/W2158595459","https://openalex.org/W2169207323","https://openalex.org/W4249171797"],"related_works":["https://openalex.org/W2750425440","https://openalex.org/W2898367493","https://openalex.org/W2240099544","https://openalex.org/W638381921","https://openalex.org/W2512476881","https://openalex.org/W619366292","https://openalex.org/W2912795851","https://openalex.org/W1510725189","https://openalex.org/W1432037690","https://openalex.org/W2376524225"],"abstract_inverted_index":{"The":[0],"integration":[1,72,108],"of":[2,49,70,73,84,118,167,228],"the":[3,10,27,46,50,65,71,74,90,103,106,116,128,226],".NET":[4,21,206],"Common":[5],"Language":[6,200],"Runtime":[7],"(CLR)":[8],"into":[9],"SQL":[11,77,110,122],"Server":[12,111],"DBMS":[13,51],"enables":[14,165],"rich":[15],"business":[16,34],"logic":[17,35],"written":[18],"in":[19,98,109,205],"modern":[20],"languages":[22,207],"to":[23,26,105,157,208,234],"run":[24],"close":[25],"data.":[28],"Database":[29],"application":[30],"developers":[31],"can":[32,43],"write":[33],"as":[36,171,173,188,190],"functions,":[37],"stored":[38],"procedures,":[39],"and":[40,58,67,96,138,143,184,231],"triggers.":[41],"They":[42],"also":[44],"extend":[45],"native":[47,236],"capabilities":[48],"by":[52,121],"adding":[53],"new":[54,82],"scalar":[55,154],"data":[56,162,217],"types,":[57,187],"aggregates.":[59],"A":[60],"previous":[61],"paper":[62],"[2]":[63],"described":[64],"architecture":[66],"design":[68],"principles":[69],"CLR":[75,107],"inside":[76],"Server.":[78,123],"Here":[79],"we":[80,88,101,126,149,152,195,198,220],"present":[81,102,196,221],"aspects":[83],"this":[85],"work.":[86],"First,":[87],"describe":[89,127],"extensibility":[91,156],"contracts":[92],"for":[93,130,176],"user-defined":[94,136,141],"types":[95,137],"aggregates":[97,232],"detail.":[99],"Second,":[100],"advances":[104],"2008":[112],"which":[113],"significantly":[114],"enhances":[115],"breath":[117],"applications":[119],"supported":[120],"In":[124],"particular,":[125],"support":[129,175,180],"large":[131],"(greater":[132],"than":[133],"8000":[134],"byte)":[135],"aggregates,":[139,142],"multiple-input":[140],"order-aware":[144],"table":[145],"valued":[146],"functions.":[147],"Third,":[148],"show":[150],"how":[151,197],"leveraged":[153],"type":[155,163],"provide":[158],"a":[159,191],"hierarchical":[160],"identifier":[161],"that":[164,215],"encoding":[166],"keys":[168],"describing":[169],"hierarchies":[170],"well":[172,189],"built-in":[174],"spatial":[177,186,192],"applications.":[178],"This":[179],"includes":[181],"both":[182],"flat-":[183],"round-earth":[185],"index.":[193],"Fourth,":[194],"use":[199],"Integrated":[201],"Query":[202],"(LINQ)":[203],"enhancements":[204],"improve":[209],"developer":[210],"productivity":[211],"when":[212],"creating":[213],"routines":[214],"require":[216],"access.":[218],"Finally,":[219],"preliminary":[222],"performance":[223],"results":[224],"showing":[225],"efficiency":[227],"streaming":[229],"TVFs":[230],"relative":[233],"equivalent":[235],"features.":[237]},"counts_by_year":[{"year":2025,"cited_by_count":1},{"year":2021,"cited_by_count":1},{"year":2015,"cited_by_count":2},{"year":2014,"cited_by_count":5},{"year":2013,"cited_by_count":7},{"year":2012,"cited_by_count":3}],"updated_date":"2026-04-05T17:49:38.594831","created_date":"2025-10-10T00:00:00"}