A blog by Oleg Shilovitsky
Information & Comments about Engineering and Manufacturing Software

Natural Language and Future of PLM queries

Natural Language and Future of PLM queries
Oleg
Oleg
29 August, 2017 | 3 min for reading

PLM is all about bringing right information to the right people at the right time. Nice marketing you can say. And it sound simple… Huh? Well, it is sounds very simple, but implementation of this simple formula is not very simple. It takes time and effort to bring right data from PLM databases. Sometimes, the data is coded in a very complex set of tables and relationships.

How to get data out to users when you need it the most. For the last few years, the idea of applying search technology was promising. PLM products have adopted variety of search implementation  – full text, graph, 3D, semantic etc. Even search is one of the most promising strategy to democratize the data extraction, it is not an easy way to do so. Queries can bring too many results and to apply filters can be sub-optimal.

What is the alternative to search? Structural queries are much easier to  implement and they can return more precise results. However, to implement such queries wasn’t a simple thing. But, there are some good news coming on the horizon. My attention was caught by Tech Crunch article – Salesforce is using AI to democratize SQL so anyone can query databases in natural language (http://techcrunch.com/2017/08/29/salesforce-is-using-ai-to-democratize-sql-so-anyone-can-query-databases-in-natural-language/). Read the article and draw your opinion.

The article speaks about the development of Seq2SQL – a technique Salesforce.com is using to build more faster and comprehensive queries based on natural language analysis. The following passage can give you an idea of what is that and how it works.

Their recent paper, Seq2SQL: Generating Structured Queries from Natural 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.

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.

“We don’t actually have just one way of writing a query the correct way,” Victor Zhong, one of the Salesforce researchers who worked on the project, explained to me in an interview. “If 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.”

Here is an interesting video shows you the idea  how it might work.

What is my conclusion? The idea of generating SQL can be potentially applied to complex PLM databases struggling how to extract data in a meaningful way. Query generated using the algorithm described in the article and it is promising. So, the time when you will be query your PLM database using NL tools is not so far. Just my thoughts…

Best, Oleg

Want to learn more about PLM? Check out my new PLM Book website.

Disclaimer: I’m co-founder and CEO of openBoM developing cloud based bill of materials and inventory management tool for manufacturing companies, hardware startups and supply chain. My opinion can be unintentionally biased.

 

Recent Posts

Also on BeyondPLM

4 6
1 August, 2019

I’m coming to PI PLMx 2019 San-Diego. If you never heard about PI PLMx, check it out here. One of...

12 September, 2020

Customer preferences changed significantly since Henry Ford invented the Model-T and built a completely vertically integrated manufacturing facility making everything...

25 August, 2010

I’m continuing to explore various aspects of relations between PLM and social systems and tools in my blog. The social...

12 January, 2017

“Data as a Platform” is one of the most interesting trends to watch these days. I wrote about it in...

11 May, 2016

Collaboration was an important element in the development of product lifecycle technologies. First PDM and PLM systems allowed to control...

1 July, 2023

In the fast-paced world of manufacturing business, staying ahead of the competition requires efficient management of product development, manufacturing, and...

2 August, 2016

Our environment is getting more distributed then ever. The borders between work, home and mobile environments are blurring. What is the...

16 March, 2009

Today, I’d like to discuss the relationships between Product Lifecycle Management and Enterprise Collaboration. Enterprise collaboration continues to be important....

9 April, 2015

Communication is an important element of our work. We live in an extremely connected world. To communicate with people you...

Blogroll

To the top