{"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":{"id":"doi:10.1109/bigdata52589.2021.9671321","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":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2021 IEEE International Conference on Big Data (Big 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/A5109225873","display_name":"Hangu Yeo","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210114115","display_name":"IBM Research - Thomas J. Watson Research Center","ror":"https://ror.org/0265w5591","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210114115"]}],"countries":["US"],"is_corresponding":true,"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":["https://openalex.org/I4210114115","https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5066846011","display_name":"Elahe Khorasani","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210114115","display_name":"IBM Research - Thomas J. Watson Research Center","ror":"https://ror.org/0265w5591","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210114115"]}],"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":["https://openalex.org/I4210114115","https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5073311724","display_name":"Vadim Sheinin","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210114115","display_name":"IBM Research - Thomas J. Watson Research Center","ror":"https://ror.org/0265w5591","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210114115"]}],"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":["https://openalex.org/I4210114115","https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5015531707","display_name":"Ngoc Phuoc An Vo","orcid":"https://orcid.org/0000-0001-5646-5411"},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210114115","display_name":"IBM Research - Thomas J. Watson Research Center","ror":"https://ror.org/0265w5591","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210114115"]}],"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":["https://openalex.org/I4210114115","https://openalex.org/I1341412227"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5034757155","display_name":"Octavian Popescu","orcid":"https://orcid.org/0000-0002-2597-7155"},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210114115","display_name":"IBM Research - Thomas J. Watson Research Center","ror":"https://ror.org/0265w5591","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210114115"]}],"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":["https://openalex.org/I4210114115","https://openalex.org/I1341412227"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5048986206","display_name":"Petros Zerfos","orcid":null},"institutions":[{"id":"https://openalex.org/I1341412227","display_name":"IBM (United States)","ror":"https://ror.org/05hh8d621","country_code":"US","type":"company","lineage":["https://openalex.org/I1341412227"]},{"id":"https://openalex.org/I4210114115","display_name":"IBM Research - Thomas J. Watson Research Center","ror":"https://ror.org/0265w5591","country_code":"US","type":"facility","lineage":["https://openalex.org/I1341412227","https://openalex.org/I4210114115"]}],"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":["https://openalex.org/I4210114115","https://openalex.org/I1341412227"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5109225873"],"corresponding_institution_ids":["https://openalex.org/I1341412227","https://openalex.org/I4210114115"],"apc_list":null,"apc_paid":null,"fwci":0.3441,"has_fulltext":false,"cited_by_count":2,"citation_normalized_percentile":{"value":0.57824043,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":94,"max":96},"biblio":{"volume":null,"issue":null,"first_page":"2848","last_page":"2856"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9904999732971191,"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.9904999732971191,"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.9904000163078308,"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.984499990940094,"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/computer-science","display_name":"Computer science","score":0.8986395597457886},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.8104730844497681},{"id":"https://openalex.org/keywords/query-by-example","display_name":"Query by Example","score":0.7475059628486633},{"id":"https://openalex.org/keywords/data-definition-language","display_name":"Data definition language","score":0.6831005811691284},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.629123330116272},{"id":"https://openalex.org/keywords/query-language","display_name":"Query language","score":0.6234003901481628},{"id":"https://openalex.org/keywords/stored-procedure","display_name":"Stored procedure","score":0.5973519086837769},{"id":"https://openalex.org/keywords/view","display_name":"View","score":0.479069322347641},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.469940721988678},{"id":"https://openalex.org/keywords/sql/psm","display_name":"SQL/PSM","score":0.4695119559764862},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.42879530787467957},{"id":"https://openalex.org/keywords/database-design","display_name":"Database design","score":0.3691312074661255},{"id":"https://openalex.org/keywords/web-search-query","display_name":"Web search query","score":0.22617566585540771},{"id":"https://openalex.org/keywords/search-engine","display_name":"Search engine","score":0.0960325300693512}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8986395597457886},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.8104730844497681},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.7475059628486633},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.6831005811691284},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.629123330116272},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.6234003901481628},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.5973519086837769},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.479069322347641},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.469940721988678},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.4695119559764862},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.42879530787467957},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.3691312074661255},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.22617566585540771},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0960325300693512}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1109/bigdata52589.2021.9671321","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":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"2021 IEEE International Conference on Big Data (Big Data)","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":false,"grobid_xml":false},"content_urls":null,"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/W3196679839","https://openalex.org/W1992658322","https://openalex.org/W1774074187","https://openalex.org/W4206239285","https://openalex.org/W2038123353","https://openalex.org/W2555782585","https://openalex.org/W2044840147","https://openalex.org/W2479269711","https://openalex.org/W3210031882","https://openalex.org/W2372195569"],"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]},"counts_by_year":[{"year":2022,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}