{"id":"https://openalex.org/W2787219882","doi":"https://doi.org/10.48550/arxiv.1802.02872","title":"SQL Query Completion for Data Exploration","display_name":"SQL Query Completion for Data Exploration","alternate_titles":[],"publication_year":2018,"publication_date":"2018-02-08","ids":{"openalex":"https://openalex.org/W2787219882","doi":"https://doi.org/10.48550/arxiv.1802.02872","mag":"2787219882"},"language":"en","primary_location":{"id":"pmh:oai:arXiv.org:1802.02872","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/1802.02872","pdf_url":"https://arxiv.org/pdf/1802.02872","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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"},"parent_works":[],"lineage":["https://openalex.org/W2787219882"],"child_works_count":0,"type":"preprint","is_traditional":true,"indexed_in":["arxiv","datacite"],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"https://arxiv.org/pdf/1802.02872","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5034148005","display_name":"Marie Le Guilly","orcid":null,"observed_orcids":[]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Guilly, Marie Le","raw_affiliation_strings":["BD","Base de Donn\u00e9es"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"BD","institution_ids":[]},{"raw_affiliation_string":"Base de Donn\u00e9es","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5064659680","display_name":"Jean-Marc Petit","orcid":"https://orcid.org/0000-0002-0015-745X","observed_orcids":["https://orcid.org/0000-0002-0015-745X"]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Petit, Jean-Marc","raw_affiliation_strings":["BD","Base de Donn\u00e9es"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"BD","institution_ids":[]},{"raw_affiliation_string":"Base de Donn\u00e9es","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5063350327","display_name":"Vasile-Marian Scuturici","orcid":"https://orcid.org/0000-0001-8139-0212","observed_orcids":["https://orcid.org/0000-0001-8139-0212"]},"institutions":[],"countries":[],"is_corresponding":false,"contributor_roles":[],"raw_author_name":"Scuturici, Vasile-Marian","raw_affiliation_strings":["BD","Base de Donn\u00e9es"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"BD","institution_ids":[]},{"raw_affiliation_string":"Base de Donn\u00e9es","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":0,"corresponding_author_ids":[],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":null,"has_fulltext":true,"cited_by_count":13,"reviewed_by_count":0,"citation_normalized_percentile":null,"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":null,"last_page":null},"is_retracted":false,"is_pulled":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.576200008392334,"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"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.576200008392334,"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"}},{"id":"https://openalex.org/T10260","display_name":"Software Engineering Research","score":0.18569999933242798,"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"}},{"id":"https://openalex.org/T10799","display_name":"Data Visualization and Analytics","score":0.021900000050663948,"subfield":{"id":"https://openalex.org/subfields/1704","display_name":"Computer Graphics and Computer-Aided Design"},"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/exploratory-data-analysis","display_name":"exploratory data analysis","score":0.8140000104904175},{"id":"https://openalex.org/keywords/relational-databases","display_name":"relational databases","score":0.7129999995231628},{"id":"https://openalex.org/keywords/query-writing","display_name":"query writing","score":0.43799999356269836},{"id":"https://openalex.org/keywords/user-adoption","display_name":"user adoption","score":0.47200000286102295},{"id":"https://openalex.org/keywords/big-data","display_name":"big data","score":0.47999998927116394},{"id":"https://openalex.org/keywords/database-management-systems","display_name":"database management systems","score":0.6430000066757202}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8494496941566467},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.790972113609314},{"id":"https://openalex.org/C194222762","wikidata":"https://www.wikidata.org/wiki/Q114486","display_name":"Query by Example","level":4,"score":0.717367947101593},{"id":"https://openalex.org/C154420247","wikidata":"https://www.wikidata.org/wiki/Q846619","display_name":"Stored procedure","level":5,"score":0.7037723660469055},{"id":"https://openalex.org/C55596503","wikidata":"https://www.wikidata.org/wiki/Q1431648","display_name":"Data definition language","level":3,"score":0.5960894823074341},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5448813438415527},{"id":"https://openalex.org/C33882796","wikidata":"https://www.wikidata.org/wiki/Q4826222","display_name":"Autocommit","level":5,"score":0.47518932819366455},{"id":"https://openalex.org/C167544706","wikidata":"https://www.wikidata.org/wiki/Q360842","display_name":"SQL/PSM","level":5,"score":0.47499266266822815},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.4599558115005493},{"id":"https://openalex.org/C192028432","wikidata":"https://www.wikidata.org/wiki/Q845739","display_name":"Query language","level":2,"score":0.4524570107460022},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.4474501609802246},{"id":"https://openalex.org/C54239708","wikidata":"https://www.wikidata.org/wiki/Q1329910","display_name":"View","level":3,"score":0.4144099950790405},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4113262891769409},{"id":"https://openalex.org/C98045186","wikidata":"https://www.wikidata.org/wiki/Q205663","display_name":"Process (computing)","level":2,"score":0.41119837760925293},{"id":"https://openalex.org/C148840519","wikidata":"https://www.wikidata.org/wiki/Q1049878","display_name":"Database design","level":2,"score":0.25069504976272583},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.21923840045928955},{"id":"https://openalex.org/C164120249","wikidata":"https://www.wikidata.org/wiki/Q995982","display_name":"Web search query","level":3,"score":0.18762686848640442},{"id":"https://openalex.org/C97854310","wikidata":"https://www.wikidata.org/wiki/Q19541","display_name":"Search engine","level":2,"score":0.0}],"mesh":[],"locations_count":3,"locations":[{"id":"pmh:oai:arXiv.org:1802.02872","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/1802.02872","pdf_url":"https://arxiv.org/pdf/1802.02872","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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"},{"id":"pmh:oai:HAL:hal-01703346v1","doi":null,"is_oa":true,"landing_page_url":"https://hal.science/hal-01703346","pdf_url":null,"source":{"id":"https://openalex.org/S4306402512","display_name":"HAL","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I4405252976","host_organization_name":"Centre pour la Communication Scientifique Directe","host_organization_lineage":["https://openalex.org/I4405252976"],"host_organization_lineage_names":[],"type":"repository"},"license":"other-oa","license_id":"https://openalex.org/licenses/other-oa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"[Research Report] INSA Lyon. 2018","raw_type":"info:eu-repo/semantics/report"},{"id":"doi:10.48550/arxiv.1802.02872","doi":"https://doi.org/10.48550/arxiv.1802.02872","is_oa":true,"landing_page_url":"https://doi.org/10.48550/arxiv.1802.02872","pdf_url":null,"source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":null,"is_accepted":false,"is_published":false,"raw_source_name":null,"raw_type":"Preprint"}],"best_oa_location":{"id":"pmh:oai:arXiv.org:1802.02872","doi":null,"is_oa":true,"landing_page_url":"http://arxiv.org/abs/1802.02872","pdf_url":"https://arxiv.org/pdf/1802.02872","source":{"id":"https://openalex.org/S4306400194","display_name":"arXiv (Cornell University)","issn_l":"2331-8422","issn":["2331-8422"],"is_oa":true,"is_in_doaj":false,"is_core":false,"listed_in":[],"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":[],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2787219882.pdf","grobid_xml":"https://content.openalex.org/works/W2787219882.grobid-xml"},"referenced_works_count":24,"referenced_works":["https://openalex.org/W115903057","https://openalex.org/W1493938990","https://openalex.org/W1524492696","https://openalex.org/W1556285385","https://openalex.org/W2003251288","https://openalex.org/W2024958874","https://openalex.org/W2057513751","https://openalex.org/W2072343647","https://openalex.org/W2099239777","https://openalex.org/W2101234009","https://openalex.org/W2131440147","https://openalex.org/W2140034560","https://openalex.org/W2140190241","https://openalex.org/W2142376925","https://openalex.org/W2150593711","https://openalex.org/W2152592483","https://openalex.org/W2290079659","https://openalex.org/W2294895571","https://openalex.org/W2341117600","https://openalex.org/W2518579368","https://openalex.org/W2575117149","https://openalex.org/W2605153230","https://openalex.org/W2997591727","https://openalex.org/W7099941650"],"related_works":["https://openalex.org/W3210031882","https://openalex.org/W2003251288","https://openalex.org/W4400910469","https://openalex.org/W4391443423","https://openalex.org/W3114629911","https://openalex.org/W7099250742","https://openalex.org/W7024029363","https://openalex.org/W3087096020"],"abstract_inverted_index":{"Within":[0],"the":[1,23,40,44,49,88,93,115,143,146,157,168,181,203,213,217,225,251,254],"big":[2],"data":[3,38,45,144,169,173],"tsunami,":[4],"relational":[5],"databases":[6,72],"and":[7,12,32,66,163,253,266],"SQL":[8,26,60,111,118,177,185,193,220],"are":[9,153,264],"still":[10],"there":[11],"remain":[13],"mandatory":[14],"in":[15,191,246],"most":[16],"of":[17,43,79,83,117,174,183,197,219,240],"cases":[18],"for":[19,74],"accessing":[20],"data.":[21],"On":[22,48],"one":[24,75,256],"hand,":[25,51],"is":[27,53,64,101,137,224],"easy-to-use":[28],"by":[29,229],"non":[30],"specialists":[31],"allows":[33],"to":[34,58,69,91,109,128,131,208,258],"identify":[35],"pertinent":[36,89],"initial":[37],"at":[39],"very":[41,267],"beginning":[42],"exploration":[46,182],"process.":[47],"other":[50,255],"it":[52,63,107,124,140],"not":[54],"always":[55],"so":[56],"easy":[57],"formulate":[59],"queries:":[61],"nowadays,":[62],"more":[65,67],"frequent":[68],"have":[70],"several":[71],"available":[73],"application":[76],"domain,":[77],"some":[78],"them":[80],"with":[81,250],"hundreds":[82],"tables":[84],"and/or":[85],"attributes.":[86],"Identifying":[87],"conditions":[90,127],"select":[92],"desired":[94],"data,":[95],"or":[96],"even":[97],"identifying":[98],"relevant":[99],"attributes":[100],"far":[102],"from":[103,145],"trivial.":[104],"To":[105],"make":[106],"easier":[108],"write":[110],"queries,":[112],"we":[113],"propose":[114],"notion":[116],"query":[119,178,186],"completion:":[120],"given":[121],"a":[122,192,198,238],"query,":[123],"suggests":[125],"additional":[126],"be":[129,160,209],"added":[130],"its":[132],"WHERE":[133],"clause.":[134],"This":[135],"completion":[136,150,179,187,214,226,252],"semantic,":[138],"as":[139],"relies":[141],"on":[142,195,237],"database,":[147],"unlike":[148],"current":[149],"tools":[151],"that":[152],"mostly":[154],"syntactic.":[155],"Since":[156],"process":[158],"can":[159],"repeated":[161],"over":[162,164],"again":[165],"--":[166],"until":[167],"analyst":[170],"reaches":[171],"her":[172],"interest":[175],"--,":[176],"facilitates":[180],"databases.":[184],"has":[188,234],"been":[189,235],"implemented":[190],"editor":[194],"top":[196],"database":[199],"management":[200],"system.":[201],"For":[202],"evaluation,":[204],"two":[205,247],"questions":[206],"need":[207],"studied:":[210],"first,":[211],"does":[212],"speed":[215],"up":[216],"writing":[218],"queries?":[221],"Second":[222],",":[223],"easily":[227],"adopted":[228],"users?":[230],"A":[231],"thorough":[232],"experiment":[233],"conducted":[236],"group":[239],"70":[241],"computer":[242],"science":[243],"students":[244],"divided":[245],"groups":[248],"(one":[249],"without)":[257],"answer":[259],"those":[260],"questions.":[261],"The":[262],"results":[263],"positive":[265],"promising.":[268]},"cited_by_api_url":"https://api.openalex.org/works?filter=cites:W2787219882","counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2022,"cited_by_count":1},{"year":2021,"cited_by_count":4},{"year":2020,"cited_by_count":2},{"year":2019,"cited_by_count":2},{"year":2018,"cited_by_count":2}],"updated_date":"2026-11-22T12:46:00.618207","created_date":"2018-02-23T00:00:00"}
