{"id":"https://openalex.org/W2469745933","doi":"https://doi.org/10.1109/hpec.2016.7761647","title":"Associative array model of SQL, NoSQL, and NewSQL databases","display_name":"Associative array model of SQL, NoSQL, and NewSQL databases","publication_year":2016,"publication_date":"2016-09-01","ids":{"openalex":"https://openalex.org/W2469745933","doi":"https://doi.org/10.1109/hpec.2016.7761647","mag":"2469745933"},"language":"en","primary_location":{"id":"doi:10.1109/hpec.2016.7761647","is_oa":false,"landing_page_url":"https://doi.org/10.1109/hpec.2016.7761647","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2016 IEEE High Performance Extreme Computing Conference (HPEC)","raw_type":"proceedings-article"},"type":"article","indexed_in":["arxiv","crossref"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/1606.05797","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":null,"display_name":"Jeremy Kepner","orcid":null},"institutions":[{"id":"https://openalex.org/I4210122954","display_name":"MIT Lincoln Laboratory","ror":"https://ror.org/022z6jk58","country_code":"US","type":"facility","lineage":["https://openalex.org/I4210122954","https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Jeremy Kepner","raw_affiliation_strings":["MIT Computer Science & AI Laboratory","MIT Lincoln Laboratory","MIT Mathematics Department"],"affiliations":[{"raw_affiliation_string":"MIT Computer Science & AI Laboratory","institution_ids":[]},{"raw_affiliation_string":"MIT Lincoln Laboratory","institution_ids":["https://openalex.org/I4210122954"]},{"raw_affiliation_string":"MIT Mathematics Department","institution_ids":[]}]},{"author_position":"middle","author":{"id":null,"display_name":"Vijay Gadepally","orcid":null},"institutions":[{"id":"https://openalex.org/I4210122954","display_name":"MIT Lincoln Laboratory","ror":"https://ror.org/022z6jk58","country_code":"US","type":"facility","lineage":["https://openalex.org/I4210122954","https://openalex.org/I63966007"]},{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Vijay Gadepally","raw_affiliation_strings":["Massachusetts Institute of Technology Lincoln Laboratory, Lexington, MA, US"],"affiliations":[{"raw_affiliation_string":"Massachusetts Institute of Technology Lincoln Laboratory, Lexington, MA, US","institution_ids":["https://openalex.org/I4210122954","https://openalex.org/I63966007"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Dylan Hutchison","orcid":null},"institutions":[{"id":"https://openalex.org/I4210122954","display_name":"MIT Lincoln Laboratory","ror":"https://ror.org/022z6jk58","country_code":"US","type":"facility","lineage":["https://openalex.org/I4210122954","https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Dylan Hutchison","raw_affiliation_strings":["MIT Lincoln Laboratory"],"affiliations":[{"raw_affiliation_string":"MIT Lincoln Laboratory","institution_ids":["https://openalex.org/I4210122954"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Hayden Jananthan","orcid":null},"institutions":[{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Hayden Jananthan","raw_affiliation_strings":["Massachusetts Institute of Technology, Cambridge, MA, US"],"affiliations":[{"raw_affiliation_string":"Massachusetts Institute of Technology, Cambridge, MA, US","institution_ids":["https://openalex.org/I63966007"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Timothy Mattson","orcid":null},"institutions":[{"id":"https://openalex.org/I4210158342","display_name":"Intel (United Kingdom)","ror":"https://ror.org/058cxws58","country_code":"GB","type":"company","lineage":["https://openalex.org/I1343180700","https://openalex.org/I4210158342"]}],"countries":["GB"],"is_corresponding":false,"raw_author_name":"Timothy Mattson","raw_affiliation_strings":["Intel Corporation"],"affiliations":[{"raw_affiliation_string":"Intel Corporation","institution_ids":["https://openalex.org/I4210158342"]}]},{"author_position":"middle","author":{"id":null,"display_name":"Siddharth Samsi","orcid":null},"institutions":[{"id":"https://openalex.org/I4210122954","display_name":"MIT Lincoln Laboratory","ror":"https://ror.org/022z6jk58","country_code":"US","type":"facility","lineage":["https://openalex.org/I4210122954","https://openalex.org/I63966007"]},{"id":"https://openalex.org/I63966007","display_name":"Massachusetts Institute of Technology","ror":"https://ror.org/042nb2s44","country_code":"US","type":"education","lineage":["https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Siddharth Samsi","raw_affiliation_strings":["Massachusetts Institute of Technology Lincoln Laboratory, Lexington, MA, US"],"affiliations":[{"raw_affiliation_string":"Massachusetts Institute of Technology Lincoln Laboratory, Lexington, MA, US","institution_ids":["https://openalex.org/I4210122954","https://openalex.org/I63966007"]}]},{"author_position":"last","author":{"id":null,"display_name":"Albert Reuther","orcid":null},"institutions":[{"id":"https://openalex.org/I4210122954","display_name":"MIT Lincoln Laboratory","ror":"https://ror.org/022z6jk58","country_code":"US","type":"facility","lineage":["https://openalex.org/I4210122954","https://openalex.org/I63966007"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Albert Reuther","raw_affiliation_strings":["MIT Lincoln Laboratory"],"affiliations":[{"raw_affiliation_string":"MIT Lincoln Laboratory","institution_ids":["https://openalex.org/I4210122954"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":7,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I4210122954"],"apc_list":null,"apc_paid":null,"fwci":3.9477,"has_fulltext":false,"cited_by_count":24,"citation_normalized_percentile":{"value":0.93988575,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":{"min":89,"max":98},"biblio":{"volume":null,"issue":null,"first_page":"1","last_page":"9"},"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.9976000189781189,"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.9976000189781189,"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/T12292","display_name":"Graph Theory and Algorithms","score":0.9973999857902527,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9952999949455261,"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"}}],"keywords":[{"id":"https://openalex.org/keywords/associative-property","display_name":"Associative property","score":0.8493000268936157},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.5181999802589417},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.4221000075340271},{"id":"https://openalex.org/keywords/key","display_name":"Key (lock)","score":0.4189000129699707},{"id":"https://openalex.org/keywords/the-internet","display_name":"The Internet","score":0.41280001401901245},{"id":"https://openalex.org/keywords/data-exchange","display_name":"Data exchange","score":0.41179999709129333},{"id":"https://openalex.org/keywords/associative-array","display_name":"Associative array","score":0.385699987411499},{"id":"https://openalex.org/keywords/reflection","display_name":"Reflection (computer programming)","score":0.384799987077713}],"concepts":[{"id":"https://openalex.org/C159423971","wikidata":"https://www.wikidata.org/wiki/Q177251","display_name":"Associative property","level":2,"score":0.8493000268936157},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7563999891281128},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.5181999802589417},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4745999872684479},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.4221000075340271},{"id":"https://openalex.org/C26517878","wikidata":"https://www.wikidata.org/wiki/Q228039","display_name":"Key (lock)","level":2,"score":0.4189000129699707},{"id":"https://openalex.org/C110875604","wikidata":"https://www.wikidata.org/wiki/Q75","display_name":"The Internet","level":2,"score":0.41280001401901245},{"id":"https://openalex.org/C15845906","wikidata":"https://www.wikidata.org/wiki/Q1172338","display_name":"Data exchange","level":2,"score":0.41179999709129333},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.40149998664855957},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.4000000059604645},{"id":"https://openalex.org/C168781493","wikidata":"https://www.wikidata.org/wiki/Q80585","display_name":"Associative array","level":2,"score":0.385699987411499},{"id":"https://openalex.org/C65682993","wikidata":"https://www.wikidata.org/wiki/Q1056451","display_name":"Reflection (computer programming)","level":2,"score":0.384799987077713},{"id":"https://openalex.org/C138390121","wikidata":"https://www.wikidata.org/wiki/Q5283219","display_name":"Distributivity","level":3,"score":0.37070000171661377},{"id":"https://openalex.org/C162319229","wikidata":"https://www.wikidata.org/wiki/Q175263","display_name":"Data structure","level":2,"score":0.32510000467300415},{"id":"https://openalex.org/C67186912","wikidata":"https://www.wikidata.org/wiki/Q367664","display_name":"Data modeling","level":2,"score":0.3248000144958496},{"id":"https://openalex.org/C61797465","wikidata":"https://www.wikidata.org/wiki/Q1188986","display_name":"Term (time)","level":2,"score":0.32100000977516174},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.30079999566078186},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.2888999879360199},{"id":"https://openalex.org/C53442348","wikidata":"https://www.wikidata.org/wiki/Q745101","display_name":"Content-addressable memory","level":3,"score":0.2800999879837036},{"id":"https://openalex.org/C100463513","wikidata":"https://www.wikidata.org/wiki/Q5227322","display_name":"Data model (GIS)","level":2,"score":0.2736999988555908},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.26899999380111694},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.2526000142097473},{"id":"https://openalex.org/C95916125","wikidata":"https://www.wikidata.org/wiki/Q840540","display_name":"Relational algebra","level":3,"score":0.2508000135421753}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.1109/hpec.2016.7761647","is_oa":false,"landing_page_url":"https://doi.org/10.1109/hpec.2016.7761647","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2016 IEEE High Performance Extreme Computing Conference (HPEC)","raw_type":"proceedings-article"},{"id":"pmh:oai:arXiv.org:1606.05797","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1606.05797","pdf_url":"https://arxiv.org/pdf/1606.05797","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:1606.05797","is_oa":true,"landing_page_url":"http://arxiv.org/abs/1606.05797","pdf_url":"https://arxiv.org/pdf/1606.05797","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I205783295","host_organization_name":"Cornell University","host_organization_lineage":["https://openalex.org/I205783295"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"text"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"referenced_works_count":33,"referenced_works":["https://openalex.org/W1511106582","https://openalex.org/W1573666807","https://openalex.org/W1838659430","https://openalex.org/W1964530510","https://openalex.org/W1974695870","https://openalex.org/W1974951461","https://openalex.org/W1978979183","https://openalex.org/W1981420413","https://openalex.org/W1990391007","https://openalex.org/W1991697528","https://openalex.org/W2013344760","https://openalex.org/W2048006137","https://openalex.org/W2062058882","https://openalex.org/W2064028777","https://openalex.org/W2087946700","https://openalex.org/W2098935637","https://openalex.org/W2113640782","https://openalex.org/W2125584498","https://openalex.org/W2128379730","https://openalex.org/W2130216506","https://openalex.org/W2133384222","https://openalex.org/W2153704625","https://openalex.org/W2155070484","https://openalex.org/W2185907055","https://openalex.org/W2260616469","https://openalex.org/W2539193928","https://openalex.org/W4231526268","https://openalex.org/W6638231387","https://openalex.org/W6658951638","https://openalex.org/W6680852931","https://openalex.org/W6687322159","https://openalex.org/W6785432261","https://openalex.org/W6785865135"],"related_works":[],"abstract_inverted_index":{"The":[0,33],"success":[1],"of":[2,11,49,58,90,148],"SQL,":[3],"NoSQL,":[4],"and":[5,18,30,78,93,112,118,150],"NewSQL":[6],"databases":[7,51],"is":[8],"a":[9,39,64,139],"reflection":[10],"their":[12],"ability":[13],"to":[14,37,41,44,67,144],"provide":[15,38,63,138],"significant":[16],"functionality":[17],"performance":[19],"benefits":[20,48],"for":[21,142],"specific":[22],"domains,":[23],"such":[24],"as":[25],"financial":[26],"transactions,":[27],"internet":[28],"search,":[29],"data":[31,149],"analysis.":[32],"BigDAWG":[34],"polystore":[35],"seeks":[36],"mechanism":[40],"allow":[42],"applications":[43,54],"transparently":[45],"achieve":[46],"the":[47,56,68,84,95,121,146],"diverse":[50],"while":[52],"insulating":[53],"from":[55],"details":[57],"these":[59,123],"databases.":[60],"Associative":[61],"arrays":[62,92,136],"common":[65],"approach":[66],"mathematics":[69],"found":[70],"in":[71,88],"different":[72],"databases:":[73],"sets":[74],"(SQL),":[75],"graphs":[76],"(NoSQL),":[77],"matrices":[79],"(NewSQL).":[80],"This":[81],"work":[82],"presents":[83],"SQL":[85],"relational":[86],"model":[87,141],"terms":[89],"associative":[91,128,135],"identifies":[94],"key":[96],"mathematical":[97,140],"properties":[98,105,124],"that":[99,134],"are":[100],"preserved":[101],"within":[102],"SQL.":[103],"These":[104,131],"include":[106],"associativity,":[107],"commutativity,":[108],"distributivity,":[109],"identities,":[110],"annihilators,":[111],"inverses.":[113],"Performance":[114],"measurements":[115],"on":[116,127],"distributivity":[117],"associativity":[119],"show":[120],"impact":[122],"can":[125],"have":[126],"array":[129],"operations.":[130],"results":[132],"demonstrate":[133],"could":[137],"polystores":[143],"optimize":[145],"exchange":[147],"execution":[151],"queries.":[152]},"counts_by_year":[{"year":2025,"cited_by_count":2},{"year":2023,"cited_by_count":1},{"year":2022,"cited_by_count":2},{"year":2021,"cited_by_count":5},{"year":2020,"cited_by_count":1},{"year":2019,"cited_by_count":4},{"year":2018,"cited_by_count":3},{"year":2017,"cited_by_count":5},{"year":2016,"cited_by_count":1}],"updated_date":"2026-03-20T23:20:44.827607","created_date":"2016-07-22T00:00:00"}