{"id":"https://openalex.org/W4206239285","doi":"https://doi.org/10.1109/bigdata52589.2021.9671321","title":"Programmatic Database Language Generation for Big Data Applications","display_name":"Programmatic Database Language Generation for Big Data Applications","publication_year":2021,"publication_date":"2021-12-15","ids":{"openalex":"https://openalex.org/W4206239285","doi":"https://doi.org/10.1109/bigdata52589.2021.9671321"},"language":"en","primary_location":{"is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata52589.2021.9671321","pdf_url":null,"source":{"id":"https://openalex.org/S4363607718","display_name":"2021 IEEE International Conference on Big Data (Big Data)","issn_l":null,"issn":null,"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":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false},"type":"article","type_crossref":"proceedings-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/A5109225873","display_name":"Hangu Yeo","orcid":null},"institutions":[],"countries":["US"],"is_corresponding":false,"raw_author_name":"Hangu Yeo","raw_affiliation_strings":["Dept. Incubation Projects, IBM T.J. Watson Research Center, Yorktown Heights, NY, U.S.A."],"affiliations":[{"raw_affiliation_string":"Dept. Incubation Projects, IBM T.J. Watson Research Center, Yorktown Heights, NY, U.S.A.","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5066846011","display_name":"Elahe Khorasani","orcid":null},"institutions":[],"countries":["US"],"is_corresponding":false,"raw_author_name":"Elahe Khorasani","raw_affiliation_strings":["Dept. Incubation Projects, IBM T.J. Watson Research Center, Yorktown Heights, NY, U.S.A."],"affiliations":[{"raw_affiliation_string":"Dept. Incubation Projects, IBM T.J. Watson Research Center, Yorktown Heights, NY, U.S.A.","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073311724","display_name":"Vadim Sheinin","orcid":null},"institutions":[],"countries":["US"],"is_corresponding":false,"raw_author_name":"Vadim Sheinin","raw_affiliation_strings":["Dept. Incubation Projects, IBM T.J. Watson Research Center, Yorktown Heights, NY, U.S.A."],"affiliations":[{"raw_affiliation_string":"Dept. Incubation Projects, IBM T.J. Watson Research Center, Yorktown Heights, NY, U.S.A.","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5015531707","display_name":"Ngoc Phuoc An Vo","orcid":"https://orcid.org/0000-0001-5646-5411"},"institutions":[],"countries":["US"],"is_corresponding":false,"raw_author_name":"Ngoc Phuoc An Vo","raw_affiliation_strings":["Dept. Incubation Projects, IBM T.J. Watson Research Center, Yorktown Heights, NY, U.S.A."],"affiliations":[{"raw_affiliation_string":"Dept. Incubation Projects, IBM T.J. Watson Research Center, Yorktown Heights, NY, U.S.A.","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034757155","display_name":"Octavian Popescu","orcid":"https://orcid.org/0000-0002-2597-7155"},"institutions":[],"countries":["US"],"is_corresponding":false,"raw_author_name":"Octavian Popescu","raw_affiliation_strings":["Dept. Incubation Projects, IBM T.J. Watson Research Center, Yorktown Heights, NY, U.S.A."],"affiliations":[{"raw_affiliation_string":"Dept. Incubation Projects, IBM T.J. Watson Research Center, Yorktown Heights, NY, U.S.A.","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5048986206","display_name":"Petros Zerfos","orcid":null},"institutions":[],"countries":["US"],"is_corresponding":false,"raw_author_name":"Petros Zerfos","raw_affiliation_strings":["Dept. Incubation Projects, IBM T.J. Watson Research Center, Yorktown Heights, NY, U.S.A."],"affiliations":[{"raw_affiliation_string":"Dept. Incubation Projects, IBM T.J. Watson Research Center, Yorktown Heights, NY, U.S.A.","institution_ids":[]}]}],"institution_assertions":[],"countries_distinct_count":1,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.28,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.282675,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":67,"max":72},"biblio":{"volume":null,"issue":null,"first_page":"2848","last_page":"2856"},"is_retracted":false,"is_paratext":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9905,"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"}},"topics":[{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9905,"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"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9904,"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/T10101","display_name":"Cloud Computing and Resource Management","score":0.9845,"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/data-definition-language","display_name":"Data definition language","score":0.6831006},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.5973519},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.46951196}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.89863956},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.8104731},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.74750596},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.6831006},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.62912333},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.6234004},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.5973519},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.47906932},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.46994072},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.46951196},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4287953},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.3691312},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.22617567},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.09603253}],"mesh":[],"locations_count":1,"locations":[{"is_oa":false,"landing_page_url":"https://doi.org/10.1109/bigdata52589.2021.9671321","pdf_url":null,"source":{"id":"https://openalex.org/S4363607718","display_name":"2021 IEEE International Conference on Big Data (Big Data)","issn_l":null,"issn":null,"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":"conference"},"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false}],"best_oa_location":null,"sustainable_development_goals":[],"grants":[],"datasets":[],"versions":[],"referenced_works_count":6,"referenced_works":["https://openalex.org/W2016432059","https://openalex.org/W2148673189","https://openalex.org/W2169528473","https://openalex.org/W2890431379","https://openalex.org/W2950067395","https://openalex.org/W3156729426"],"related_works":["https://openalex.org/W4206239285","https://openalex.org/W3210031882","https://openalex.org/W3196679839","https://openalex.org/W2555782585","https://openalex.org/W2479269711","https://openalex.org/W2372195569","https://openalex.org/W2044840147","https://openalex.org/W2038123353","https://openalex.org/W1992658322","https://openalex.org/W1774074187"],"abstract_inverted_index":{"Database":[0],"management":[1],"systems":[2],"offer":[3],"an":[4,35,128],"efficient":[5],"way":[6],"of":[7,11,27,81,100,114,163],"managing":[8],"huge":[9],"amount":[10],"data":[12,18,21,60,72,83,138],"such":[13],"as":[14,108,110],"financial":[15,170],"and":[16,19,69,152,158,165,171,198],"healthcare":[17,172],"he":[20],"retrieval":[22],"from":[23,66,88,143],"databases":[24,164,214],"requires":[25],"knowledge":[26],"Structured":[28],"Query":[29],"Language":[30,131],"(SQL).":[31],"In":[32],"this":[33],"paper,":[34],"Automatic":[36],"SQL":[37,55,75,92,149,203,207],"Generation":[38],"System":[39],"is":[40,86,125,155],"proposed":[41,54,123,181,202],"to":[42,136],"help":[43,80],"users":[44],"who":[45],"are":[46],"inexperienced":[47],"in":[48,62,145,187],"querying":[49],"database":[50],"with":[51,78,104,127,160,212],"SQL.":[52],"The":[53,91,122,175],"generation":[56,93,204],"system":[57,94,124,135,154,182,197],"reads":[58],"formatted":[59],"items":[61,73,139],"the":[63,67,71,79,153,180,201],"query":[64,102,116,150],"report":[65],"user":[68,185],"converts":[70],"into":[74,148],"statements":[76],"programmatically":[77],"a":[82,89,101,105],"model":[84,195],"that":[85,168,179],"pulled":[87],"database.":[90],"can":[95],"handle":[96],"simple":[97],"queries":[98,112,144,186,208],"composed":[99,113],"block":[103],"SELECT":[106,120],"statement":[107],"well":[109],"complex":[111],"multiple":[115,119],"blocks":[117],"containing":[118],"statements.":[121],"integrated":[126,157],"NLIDB":[129],"(Natural":[130],"Interface":[132],"for":[133,215],"Database)":[134],"translate":[137],"(or":[140],"tokens)":[141],"extracted":[142],"natural":[146,188],"languages":[147],"language,":[151],"also":[156],"adapted":[159],"various":[161,213],"types":[162],"use":[166,173],"cases":[167],"include":[169],"cases.":[174],"experiment":[176],"results":[177],"show":[178],"correctly":[183],"handles":[184],"language":[189],"just":[190],"like":[191],"any":[192],"other":[193],"neural":[194],"based":[196],"more":[199],"importantly,":[200],"engine":[205],"generates":[206],"without":[209],"syntactic":[210],"problems":[211],"all":[216],"queries.":[217]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W4206239285","counts_by_year":[{"year":2022,"cited_by_count":2}],"updated_date":"2025-01-08T14:54:54.629059","created_date":"2022-01-25"}
  <script>parent.window.postMessage('ixistenz.url:https://api.openalex.org/works/doi:10.1109%2FBIGDATA52589.2021.9671321', '*'); </script> <div id='browserdiffcontainer' style='position: fixed; right: 10px; top: 10vh; min-width: 60px;  border: 1px solid white; background: rgb(251, 189, 0);; opacity: 0.9; font-family: helvetica, arial, sans serif;  font-size: 12px; z-index: 20001; padding-bottom: 20px;'><div onclick="toggle('browserdiffcontainerlist'); return false;" style='background: rgb(151, 89, 0);; color: white; '><strong>&nbsp; <span class='glyphicon glyphicon-minus'></span> NODES</strong></div><div id='browserdiffcontainerlist' style='padding-left: 10px; padding-right: 5px; max-height: 50vh; overflow: auto; '><div><a href='#diffid123' style='color: white;' onClick="parent.window.postMessage('ixistenz.opendiff:123', '*');; return false;" style='text-decoration: none; '>INTERN </a> <a style='color: white;' href='#diffid123'><sup>2</sup></a></div><div><a href='#diffid115' style='color: white;' onClick="parent.window.postMessage('ixistenz.opendiff:115', '*');; return false;" style='text-decoration: none; '>Project </a> <a style='color: white;' href='#diffid115'><sup>12</sup></a></div><div><a href='#diffid126' style='color: white;' onClick="parent.window.postMessage('ixistenz.opendiff:126', '*');; return false;" style='text-decoration: none; '>USERS </a> <a style='color: white;' href='#diffid126'><sup>1</sup></a></div></div></div>
<script>
function toggle( divname ) {
  var x = document.getElementById( divname );
  if (x.style.display === 'none') {
    x.style.display = 'block';
  } else {
    x.style.display = 'none';
  }
} </script>