{"id":8718,"date":"2017-08-29T18:49:20","date_gmt":"2017-08-29T18:49:20","guid":{"rendered":"https:\/\/rsoftsolution.com\/blog\/salesforce-is-using-ai-to-democratize-sql-so-anyone-can-query-databases-in-natural-language.html"},"modified":"2017-08-29T18:49:20","modified_gmt":"2017-08-29T18:49:20","slug":"salesforce-is-using-ai-to-democratize-sql-so-anyone-can-query-databases-in-natural-language","status":"publish","type":"post","link":"https:\/\/www.rbsitsoftwaresolution.in\/blog\/salesforce-is-using-ai-to-democratize-sql-so-anyone-can-query-databases-in-natural-language.html","title":{"rendered":"Salesforce is using AI to democratize SQL so anyone can query databases in natural language"},"content":{"rendered":"


\n<\/p>\n

SQL is about as easy as it gets in the world of programming, and yet its learning curve is still steep enough to prevent many people from interacting with relational databases. Salesforce\u2019s AI research team took it upon itself to explore how machine learning might be able to open doors for those without knowledge of SQL.<\/p>\n

Their recent paper<\/a>,\u00a0Seq2SQL: Generating Structured Queries from\u00a0Natural Language using Reinforcement Learning, builds on sequence to sequence models typically employed in machine translation. A reinforcement learning twist allowed the team to obtain promising results translating natural language database queries into SQL.<\/p>\n

In practice this means that you could simply ask who the winningest team in college football is and an appropriate database could be automatically queried to tell you that it is in fact the University of Michigan.<\/p>\n

\u201cWe don\u2019t actually have just one way of writing a query the correct way,\u201d Victor Zhong, one of the Salesforce researchers who worked on the project,\u00a0explained to me in an interview. \u201cIf I give a natural language question, there might be two or three ways to write the query. We use reinforcement learning to encourage use of queries that obtain same result.\u201d<\/p>\n

\"\"<\/a><\/p>\n

You can imagine how machine translation problems can quickly become massively complex with large vocabularies. The more you can limit the number of possible translations for each missing word, the simpler your problem becomes. To this avail, Salesforce opted to limit its vocabulary to words used in database labels, the words in the question being asked and the words typically used in SQL queries.<\/p>\n

The idea of democratizing SQL isn\u2019t new. Startups like ClearGraph, which was recently acquired by Tableau, have made it their business to open up data with English rather than SQL.<\/p>\n

\u201cSome models perform execution on a database itself,\u201d added\u00a0Zhong.\u00a0\u201cBut there\u2019s potential privacy concerns if you\u2019re asking a question about Social Security numbers.\u201d<\/p>\n

Outside of the paper itself, Salesforce\u2019s biggest contribution here comes in the form of the WikiSQL data set it constructed to aid in building its model. First HTML tables were collected from Wikipedia. These tables became the basis for randomly generated SQL queries. These queries were used to form questions that were then passed off to humans for paraphrasing over Amazon Mechanical Turk. Each paraphrasing was verified twice with additional human guidance. The resulting data set is the largest such data set in existence.<\/p>\n

<\/p>\n

Featured Image: Bloomberg \/ Contributor\/Getty Images<\/small><\/p>\n

Article source: http:\/\/feedproxy.google.com\/~r\/techcrunchIt\/~3\/-WTER6JCQe4\/<\/p>","protected":false},"excerpt":{"rendered":"

SQL is about as easy as it gets in the world of programming, and yet its learning curve is still steep enough to prevent many people from interacting with relational <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[19],"tags":[25],"class_list":["post-8718","post","type-post","status-publish","format-standard","hentry","category-enterprise-software","tag-enterprise"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t