& cplSiteName &

Salesforce Using AI, Natural Language to Search Databases

Scott Ferguson
8/29/2017
50%
50%

Salesforce is proposing using artificial intelligence and natural language capabilities to allow almost anyone to search relational databases, such as SQL, making it easier for all workers, not only developers, to find the data they need.

On Tuesday, Salesforce introduced Seq2SQL, which allows anyone to search a database by typing a question into a search field or speaking a question into a device, without having to know much about relational database development and programming languages.

In addition to a blog post, Salesforce Research released a paper entitled "Seq2SQL: Generating Structured Queries from Natural Language using Reinforcement Learning," which details how researchers are using neural networks to translate questions into SQL queries.

In the August 29 blog post, Richard Socher, chief scientist at Salesforce, notes that by 2020, IDC found that the world of connected devices and software will produce some 44 zettabytes of data, and it'll be more important than ever to be able to search that data to find the answers that businesses need.

(Source: Salesforce)
(Source: Salesforce)

The problem is that not everyone has a background in database management or development.

This is where Seq2SQL, when applied to a SQL database, comes in.

"The ability to quickly and easily communicate with relational databases allows business users to achieve new levels of productivity and a better understanding of their customers," Socher writes. "For example, with Seq2SQL, we take a first step towards a world in which service leaders can quickly access their most important key performance indicators (KPIs) in plain English versus manually selecting columns or inputting conditions."

In the example within the blog, researchers ask: "What place did Phil Mickelson finish with a total of 282?" within a standard search bar. The Seq2SQL then matches up the query with the appropriate database to provide the answer. (The answer, by the way, is tied for 16th place in 2005.)

Part of the ability to find accurate answers comes from the second part of the announcement.

Salesforce also detailed its work on WikiSQL, which is an open source dataset that researchers used to help train the model to work and to take advantage of the various machine learning capabilities. The wiki is a "dataset of 87,726 hand-annotated examples of questions and SQL queries distributed across 26,375 tables from Wikipedia. This dataset is required to train our model and is an order of magnitude larger than comparable datasets," according to the research paper.


Keep up with the latest enterprise cloud news and insights. Sign up for the weekly Enterprise Cloud News newsletter.


Taken together, Seq2SQL and WikiSQL look to pare down the amount of answers that a query could return and "learn" to return the most accurate answers possible.

In its blog post, Salesforce did not announce a specific commercial application for this new AI technology but Socher wrote that the "impact of this research does not stop at service, and can also benefit sales and marketing by unlocking valuable insights about incoming leads, opportunities and overall pipeline health."

That likely means that Salesforce is planning to incorporate this technology into its Einstein AI offering at some point, or create a whole new commercial offering. (See Salesforce Brings Einstein AI to Field Service Lightning.)

Related posts:

— Scott Ferguson, Editor, Enterprise Cloud News. Follow him on Twitter @sferguson_LR.

(15)  | 
Comment  | 
Print  | 
Newest First  |  Oldest First  |  Threaded View        ADD A COMMENT
More Blogs from Scott Ferguson
From its roots in industrial farm machinery and other equipment, John Deere has always looked for a technological edge. About 20 years ago, it was GPS and then 4G LTE. Now it's turning its attention to AI, machine learning and IoT.
Artificial intelligence and automation will become more integral to the enterprise, and 90% of all apps will have integrated AI capabilities by 2020, according to Oracle CEO Mark Hurd.
IBM is now offering access to Nvidia's Tesla V100 GPUs through its cloud offerings to help accelerate AI, HPC and other high-throughput workloads.
CIO Rhonda Gass is spearheading an effort to bring more automation and IoT to the factories making Stanley Black & Decker tools and other equipment.
Workday is looking to build out its machine learning and artificial intelligence capabilities with the acquisition of startup SkipFlag.
Featured Video
From The Founder
John Chambers is still as passionate about business and innovation as he ever was at Cisco, finds Steve Saunders.
Flash Poll
Upcoming Live Events
June 26, 2018, Nice, France
September 12, 2018, Los Angeles, CA
September 24-26, 2018, Westin Westminster, Denver
October 9, 2018, The Westin Times Square, New York
October 17, 2018, Chicago, Illinois
October 23, 2018, Georgia World Congress Centre, Atlanta, GA
November 7-8, 2018, London, United Kingdom
November 8, 2018, The Montcalm by Marble Arch, London
November 15, 2018, The Westin Times Square, New York
December 4-6, 2018, Lisbon, Portugal
All Upcoming Live Events
Hot Topics
NFV Is Down but Not Out
Iain Morris, News Editor, 5/22/2018
Trump Denies ZTE Deal, Faces Senate Backlash
Dan Jones, Mobile Editor, 5/22/2018
What VeloCloud Cost VMware
Phil Harvey, US News Editor, 5/21/2018
5G in the USA: A Post-BCE Update
Dan Jones, Mobile Editor, 5/23/2018
Vanquished in Video, Verizon Admits OTT Defeat
Mari Silbey, Senior Editor, Cable/Video, 5/23/2018
Animals with Phones
Live Digital Audio

A CSP's digital transformation involves so much more than technology. Crucial – and often most challenging – is the cultural transformation that goes along with it. As Sigma's Chief Technology Officer, Catherine Michel has extensive experience with technology as she leads the company's entire product portfolio and strategy. But she's also no stranger to merging technology and culture, having taken a company — Tribold — from inception to acquisition (by Sigma in 2013), and she continues to advise service providers on how to drive their own transformations. This impressive female leader and vocal advocate for other women in the industry will join Women in Comms for a live radio show to discuss all things digital transformation, including the cultural transformation that goes along with it.

Like Us on Facebook
Twitter Feed