{"id":"https://openalex.org/W3093475241","doi":"https://doi.org/10.1002/aisy.202000141","title":"In\u2010Memory Database Query","display_name":"In\u2010Memory Database Query","publication_year":2020,"publication_date":"2020-10-14","ids":{"openalex":"https://openalex.org/W3093475241","doi":"https://doi.org/10.1002/aisy.202000141","mag":"3093475241"},"language":"en","primary_location":{"id":"doi:10.1002/aisy.202000141","is_oa":true,"landing_page_url":"https://doi.org/10.1002/aisy.202000141","pdf_url":"https://onlinelibrary.wiley.com/doi/pdfdirect/10.1002/aisy.202000141","source":{"id":"https://openalex.org/S4210212817","display_name":"Advanced Intelligent Systems","issn_l":"2640-4567","issn":["2640-4567"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Advanced Intelligent Systems","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","datacite","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://onlinelibrary.wiley.com/doi/pdfdirect/10.1002/aisy.202000141","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5038931270","display_name":"Iason Giannopoulos","orcid":"https://orcid.org/0000-0002-5937-2453"},"institutions":[{"id":"https://openalex.org/I35440088","display_name":"ETH Zurich","ror":"https://ror.org/05a28rw58","country_code":"CH","type":"education","lineage":["https://openalex.org/I2799323385","https://openalex.org/I35440088"]},{"id":"https://openalex.org/I4210126328","display_name":"IBM Research - Zurich","ror":"https://ror.org/02js37d36","country_code":"CH","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210114115","https://openalex.org/I4210126328"]}],"countries":["CH"],"is_corresponding":true,"raw_author_name":"Iason Giannopoulos","raw_affiliation_strings":["Department of Information Technology and Electrical Engineering ETH Z\u00fcrich  8092 Zurich Switzerland","IBM Research \u2013 Zurich  8803 R\u00fcschlikon Switzerland"],"affiliations":[{"raw_affiliation_string":"Department of Information Technology and Electrical Engineering ETH Z\u00fcrich  8092 Zurich Switzerland","institution_ids":["https://openalex.org/I35440088"]},{"raw_affiliation_string":"IBM Research \u2013 Zurich  8803 R\u00fcschlikon Switzerland","institution_ids":["https://openalex.org/I4210126328"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5056263300","display_name":"Abhairaj Singh","orcid":"https://orcid.org/0000-0002-2729-7057"},"institutions":[{"id":"https://openalex.org/I98358874","display_name":"Delft University of Technology","ror":"https://ror.org/02e2c7k09","country_code":"NL","type":"education","lineage":["https://openalex.org/I98358874"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Abhairaj Singh","raw_affiliation_strings":["Delft University of Technology  2628 CD Delft The Netherlands","Delft University of Technology, 2628 CD Delft, The Netherlands"],"affiliations":[{"raw_affiliation_string":"Delft University of Technology  2628 CD Delft The Netherlands","institution_ids":["https://openalex.org/I98358874"]},{"raw_affiliation_string":"Delft University of Technology, 2628 CD Delft, The Netherlands","institution_ids":["https://openalex.org/I98358874"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5027282232","display_name":"Manuel Le Gallo","orcid":"https://orcid.org/0000-0003-1600-6151"},"institutions":[{"id":"https://openalex.org/I4210126328","display_name":"IBM Research - Zurich","ror":"https://ror.org/02js37d36","country_code":"CH","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210114115","https://openalex.org/I4210126328"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Manuel Le Gallo","raw_affiliation_strings":["IBM Research \u2013 Zurich  8803 R\u00fcschlikon Switzerland"],"affiliations":[{"raw_affiliation_string":"IBM Research \u2013 Zurich  8803 R\u00fcschlikon Switzerland","institution_ids":["https://openalex.org/I4210126328"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5106418671","display_name":"Vara Prasad Jonnalagadda","orcid":null},"institutions":[{"id":"https://openalex.org/I4210126328","display_name":"IBM Research - Zurich","ror":"https://ror.org/02js37d36","country_code":"CH","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210114115","https://openalex.org/I4210126328"]}],"countries":["CH"],"is_corresponding":false,"raw_author_name":"Vara Prasad Jonnalagadda","raw_affiliation_strings":["IBM Research \u2013 Zurich  8803 R\u00fcschlikon Switzerland"],"affiliations":[{"raw_affiliation_string":"IBM Research \u2013 Zurich  8803 R\u00fcschlikon Switzerland","institution_ids":["https://openalex.org/I4210126328"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5005739146","display_name":"Said Hamdioui","orcid":"https://orcid.org/0000-0002-8961-0387"},"institutions":[{"id":"https://openalex.org/I98358874","display_name":"Delft University of Technology","ror":"https://ror.org/02e2c7k09","country_code":"NL","type":"education","lineage":["https://openalex.org/I98358874"]}],"countries":["NL"],"is_corresponding":false,"raw_author_name":"Said Hamdioui","raw_affiliation_strings":["Delft University of Technology  2628 CD Delft The Netherlands","Delft University of Technology, 2628 CD Delft, The Netherlands"],"affiliations":[{"raw_affiliation_string":"Delft University of Technology  2628 CD Delft The Netherlands","institution_ids":["https://openalex.org/I98358874"]},{"raw_affiliation_string":"Delft University of Technology, 2628 CD Delft, The Netherlands","institution_ids":["https://openalex.org/I98358874"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5017236774","display_name":"Abu Sebastian","orcid":"https://orcid.org/0000-0001-5603-5243"},"institutions":[{"id":"https://openalex.org/I4210126328","display_name":"IBM Research - Zurich","ror":"https://ror.org/02js37d36","country_code":"CH","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210114115","https://openalex.org/I4210126328"]}],"countries":["CH"],"is_corresponding":true,"raw_author_name":"Abu Sebastian","raw_affiliation_strings":["IBM Research \u2013 Zurich  8803 R\u00fcschlikon Switzerland"],"affiliations":[{"raw_affiliation_string":"IBM Research \u2013 Zurich  8803 R\u00fcschlikon Switzerland","institution_ids":["https://openalex.org/I4210126328"]}]}],"institutions":[],"countries_distinct_count":2,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5017236774","https://openalex.org/A5038931270"],"corresponding_institution_ids":["https://openalex.org/I35440088","https://openalex.org/I4210126328"],"apc_list":{"value":2750,"currency":"USD","value_usd":2750},"apc_paid":{"value":2750,"currency":"USD","value_usd":2750},"fwci":2.2881,"has_fulltext":true,"cited_by_count":29,"citation_normalized_percentile":{"value":0.88750151,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":99},"biblio":{"volume":"2","issue":"12","first_page":null,"last_page":null},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10502","display_name":"Advanced Memory and Neural Computing","score":1.0,"subfield":{"id":"https://openalex.org/subfields/2208","display_name":"Electrical and Electronic Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10502","display_name":"Advanced Memory and Neural Computing","score":1.0,"subfield":{"id":"https://openalex.org/subfields/2208","display_name":"Electrical and Electronic Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12808","display_name":"Ferroelectric and Negative Capacitance Devices","score":0.9965000152587891,"subfield":{"id":"https://openalex.org/subfields/2208","display_name":"Electrical and Electronic Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12236","display_name":"Photoreceptor and optogenetics research","score":0.9958000183105469,"subfield":{"id":"https://openalex.org/subfields/2804","display_name":"Cellular and Molecular Neuroscience"},"field":{"id":"https://openalex.org/fields/28","display_name":"Neuroscience"},"domain":{"id":"https://openalex.org/domains/1","display_name":"Life Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7960010766983032},{"id":"https://openalex.org/keywords/crossbar-switch","display_name":"Crossbar switch","score":0.7902183532714844},{"id":"https://openalex.org/keywords/binary-number","display_name":"Binary number","score":0.5675113201141357},{"id":"https://openalex.org/keywords/memory-management","display_name":"Memory management","score":0.4313161075115204},{"id":"https://openalex.org/keywords/routing","display_name":"Routing (electronic design automation)","score":0.4268324673175812},{"id":"https://openalex.org/keywords/computer-hardware","display_name":"Computer hardware","score":0.39082929491996765},{"id":"https://openalex.org/keywords/parallel-computing","display_name":"Parallel computing","score":0.3666542172431946},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.33507034182548523},{"id":"https://openalex.org/keywords/arithmetic","display_name":"Arithmetic","score":0.3235013782978058},{"id":"https://openalex.org/keywords/semiconductor-memory","display_name":"Semiconductor memory","score":0.2509755492210388},{"id":"https://openalex.org/keywords/embedded-system","display_name":"Embedded system","score":0.1684388518333435},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.09035170078277588}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7960010766983032},{"id":"https://openalex.org/C29984679","wikidata":"https://www.wikidata.org/wiki/Q1929149","display_name":"Crossbar switch","level":2,"score":0.7902183532714844},{"id":"https://openalex.org/C48372109","wikidata":"https://www.wikidata.org/wiki/Q3913","display_name":"Binary number","level":2,"score":0.5675113201141357},{"id":"https://openalex.org/C176649486","wikidata":"https://www.wikidata.org/wiki/Q2308807","display_name":"Memory management","level":3,"score":0.4313161075115204},{"id":"https://openalex.org/C74172769","wikidata":"https://www.wikidata.org/wiki/Q1446839","display_name":"Routing (electronic design automation)","level":2,"score":0.4268324673175812},{"id":"https://openalex.org/C9390403","wikidata":"https://www.wikidata.org/wiki/Q3966","display_name":"Computer hardware","level":1,"score":0.39082929491996765},{"id":"https://openalex.org/C173608175","wikidata":"https://www.wikidata.org/wiki/Q232661","display_name":"Parallel computing","level":1,"score":0.3666542172431946},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.33507034182548523},{"id":"https://openalex.org/C94375191","wikidata":"https://www.wikidata.org/wiki/Q11205","display_name":"Arithmetic","level":1,"score":0.3235013782978058},{"id":"https://openalex.org/C98986596","wikidata":"https://www.wikidata.org/wiki/Q1143031","display_name":"Semiconductor memory","level":2,"score":0.2509755492210388},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.1684388518333435},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.09035170078277588},{"id":"https://openalex.org/C76155785","wikidata":"https://www.wikidata.org/wiki/Q418","display_name":"Telecommunications","level":1,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"doi:10.1002/aisy.202000141","is_oa":true,"landing_page_url":"https://doi.org/10.1002/aisy.202000141","pdf_url":"https://onlinelibrary.wiley.com/doi/pdfdirect/10.1002/aisy.202000141","source":{"id":"https://openalex.org/S4210212817","display_name":"Advanced Intelligent Systems","issn_l":"2640-4567","issn":["2640-4567"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Advanced Intelligent Systems","raw_type":"journal-article"},{"id":"pmh:oai:www.research-collection.ethz.ch:20.500.11850/497216","is_oa":true,"landing_page_url":"http://hdl.handle.net/20.500.11850/497216","pdf_url":"http://hdl.handle.net/20.500.11850/497216","source":{"id":"https://openalex.org/S4306402302","display_name":"Repository for Publications and Research Data (ETH Zurich)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I35440088","host_organization_name":"ETH Zurich","host_organization_lineage":["https://openalex.org/I35440088"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Advanced Intelligent Systems, 2 (12)","raw_type":"info:eu-repo/semantics/publishedVersion"},{"id":"doi:10.3929/ethz-b-000497216","is_oa":true,"landing_page_url":"https://doi.org/10.3929/ethz-b-000497216","pdf_url":null,"source":{"id":"https://openalex.org/S7407051236","display_name":"ETH Z\u00fcrich Research Collection","issn_l":null,"issn":[],"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":null,"is_accepted":false,"is_published":null,"raw_source_name":null,"raw_type":"article-journal"}],"best_oa_location":{"id":"doi:10.1002/aisy.202000141","is_oa":true,"landing_page_url":"https://doi.org/10.1002/aisy.202000141","pdf_url":"https://onlinelibrary.wiley.com/doi/pdfdirect/10.1002/aisy.202000141","source":{"id":"https://openalex.org/S4210212817","display_name":"Advanced Intelligent Systems","issn_l":"2640-4567","issn":["2640-4567"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310320595","host_organization_name":"Wiley","host_organization_lineage":["https://openalex.org/P4310320595"],"host_organization_lineage_names":["Wiley"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Advanced Intelligent Systems","raw_type":"journal-article"},"sustainable_development_goals":[{"display_name":"Affordable and clean energy","score":0.9100000262260437,"id":"https://metadata.un.org/sdg/7"}],"awards":[{"id":"https://openalex.org/G4756485743","display_name":"PROJECTED MEMRISTOR: A nanoscale device for cognitive computing","funder_award_id":"682675","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"},{"id":"https://openalex.org/G778160037","display_name":"Computation-in-memory architecture based on resistive devices","funder_award_id":"780215","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"},{"id":"https://openalex.org/G8318064016","display_name":null,"funder_award_id":"Horizon","funder_id":"https://openalex.org/F4320320300","funder_display_name":"European Commission"}],"funders":[{"id":"https://openalex.org/F4320320300","display_name":"European Commission","ror":"https://ror.org/00k4n6c32"}],"has_content":{"grobid_xml":true,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W3093475241.pdf","grobid_xml":"https://content.openalex.org/works/W3093475241.grobid-xml"},"referenced_works_count":41,"referenced_works":["https://openalex.org/W1998177673","https://openalex.org/W1999871211","https://openalex.org/W2000747118","https://openalex.org/W2018774711","https://openalex.org/W2025674646","https://openalex.org/W2036687738","https://openalex.org/W2076239964","https://openalex.org/W2080391538","https://openalex.org/W2107012212","https://openalex.org/W2112980698","https://openalex.org/W2163818407","https://openalex.org/W2230247842","https://openalex.org/W2269100828","https://openalex.org/W2272315143","https://openalex.org/W2338228311","https://openalex.org/W2407339173","https://openalex.org/W2472686838","https://openalex.org/W2516467421","https://openalex.org/W2518320872","https://openalex.org/W2543286055","https://openalex.org/W2617093514","https://openalex.org/W2765081478","https://openalex.org/W2768359949","https://openalex.org/W2782791387","https://openalex.org/W2786966443","https://openalex.org/W2790344283","https://openalex.org/W2803163155","https://openalex.org/W2805362231","https://openalex.org/W2883451745","https://openalex.org/W2904231959","https://openalex.org/W2923010225","https://openalex.org/W2944687873","https://openalex.org/W2948661249","https://openalex.org/W2966740705","https://openalex.org/W2976918410","https://openalex.org/W3013080934","https://openalex.org/W3032819016","https://openalex.org/W3099073033","https://openalex.org/W3101272433","https://openalex.org/W4234276901","https://openalex.org/W4254436426"],"related_works":["https://openalex.org/W2145932742","https://openalex.org/W2554791727","https://openalex.org/W1874409533","https://openalex.org/W1981395029","https://openalex.org/W3135507399","https://openalex.org/W2108083791","https://openalex.org/W4250137794","https://openalex.org/W2063341228","https://openalex.org/W2111673944","https://openalex.org/W2571519720"],"abstract_inverted_index":{"In":[0],"recent":[1],"years,":[2],"several":[3],"in\u2010memory":[4,36,142],"logic":[5,37,143,147],"primitives":[6],"were":[7],"proposed":[8,138],"where":[9,51],"bit\u2010wise":[10,73],"logical":[11,122],"operations":[12,74,123],"are":[13,42,67,76,124],"performed":[14],"in":[15,26,56,69,78,167],"memory":[16,79,103],"by":[17,80,91],"exploiting":[18,81],"the":[19,46,118,121,141],"physical":[20],"attributes":[21],"of":[22,48,59,71,107,111,120,178],"memristive":[23,61],"devices":[24,62],"organized":[25],"a":[27,31,52,96,132,154],"crossbar":[28,108],"array.":[29],"However,":[30],"convincing":[32],"real\u2010world":[33],"application":[34,47],"for":[35,134],"and":[38,75,114,128,148],"its":[39,149],"experimental":[40],"validation":[41],"still":[43],"lacking.":[44],"Herein,":[45],"database":[49,53],"query":[50,136,164],"is":[54,63,88,137,151,158,165],"stored":[55],"an":[57,161,175],"array":[58],"binary":[60],"presented.":[64],"The":[65,86,105],"queries":[66,94],"formulated":[68],"terms":[70],"bulk":[72],"executed":[77,166],"Kirchhoff's":[82],"current":[83],"summation":[84],"law.":[85],"concept":[87],"experimentally":[89],"demonstrated":[90],"executing":[92],"error\u2010free":[93],"on":[95,117,153],"small":[97],"4":[98],"\u00d7":[99],"8":[100],"selector\u2010less":[101],"phase\u2010change":[102],"crossbar.":[104],"impact":[106],"size,":[109],"resistance":[110],"routing":[112],"wires,":[113],"interdevice":[115],"variability":[116],"accuracy":[119],"studied":[125],"through":[126],"numerical":[127],"circuit\u2010level":[129],"simulations.":[130],"Finally,":[131],"system":[133],"cascaded":[135],"that":[139,160],"combines":[140],"with":[144],"conventional":[145],"digital":[146],"functionality":[150],"verified":[152],"healthcare\u2010related":[155],"database.":[156],"It":[157],"estimated":[159],"11\u2010step":[162],"long":[163],"36":[168],"ns,":[169],"consuming":[170],"560":[171],"\u03bcW,":[172],"thus":[173],"achieving":[174],"energy":[176],"efficiency":[177],"166":[179],"TOPS/W.":[180]},"counts_by_year":[{"year":2026,"cited_by_count":1},{"year":2025,"cited_by_count":4},{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":6},{"year":2022,"cited_by_count":10},{"year":2021,"cited_by_count":6}],"updated_date":"2026-04-13T07:58:08.660418","created_date":"2025-10-10T00:00:00"}