x
Cloud Native/NFV

Salesforce Using AI, Natural Language to Search Databases

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.

<<   <   Page 2 / 2
Joe Stanganelli 8/30/2017 | 12:21:43 PM
Re: 44 zettabytes of data The 44-ZB forecast is dubious at best. IDC has a record of vastly overestimating/overhyping when it comes to tech predictions. (Case in point: The firm's ridiculously off-base IoT predictions of the recent past.)

 
Susan Fourtané 8/30/2017 | 8:16:04 AM
44 zettabytes of data If by 2020 there will be some 44 zettabytes of data you can only imagine the speed that you will need to search and analyze such amount to find the bits that you actually need. You’d better be prepared.
Susan Fourtané 8/30/2017 | 8:03:22 AM
Re: Sign me up John, what pros and cons do you see now if you use this technology, considering it will also be available to your competition?
Scott_Ferguson 8/30/2017 | 7:32:08 AM
Re: Sign me up @John: I assume that by allowing everyone to search the database, you would level the competitive field -- as long as you used what Salesforce was selling. 
JohnMason 8/29/2017 | 8:06:28 PM
Sign me up Sign me up for that. It will make it easier for me to do my work. On the other hand, it was a business advantage for me to be able to manipulate data bases better than my competition. Now the competition will be as good as I am at it. (But it will cost less to hire someone else to do the searching.)
<<   <   Page 2 / 2
HOME
Sign In
SEARCH
CLOSE
MORE
CLOSE