BT

English Query Discontinued in VS 2005

by Jonathan Allen on Oct 10, 2006 |

English Query, a tool that translated queries written in English into SQL queries, has been discontinued. The full MSDN text on the issue is simply "English Query has been discontinued in this release. It cannot be installed or upgraded. If you upgrade a Microsoft SQL Server 2000 installation that includes English Query, English Query is not affected."

English Query required quite a lot of work to initially setup. Nouns and verbs for every table of interest had to be manually mapped by a DBA to the underlying database schema. Once mapped, users can ask questions in plain English like, "How many orders in March were for more than 500 dollars?" English Query then uses a technique known as Natural Language Processing to perform the translations into SQL.

Microsoft hasn't said much as to why English Query was continued. One could speculate that it may be due to lack of interest or an inability to provide accurate translations. But as research into natural language processing continues, we may see it resurface again in another product by another company.

For an in depth overview of English Query, see Buck Woody's article on informit.com.

Hello stranger!

You need to Register an InfoQ account or or login to post comments. But there's so much more behind being registered.

Get the most out of the InfoQ experience.

Tell us what you think

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

SQL? by Michael Neale

Didn't SQL come from :

"Structured english Query Language" to start with?

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

Allowed html: a,b,br,blockquote,i,li,pre,u,ul,p

Email me replies to any of my messages in this thread

1 Discuss

Educational Content

General Feedback
Bugs
Advertising
Editorial
InfoQ.com and all content copyright © 2006-2014 C4Media Inc. InfoQ.com hosted at Contegix, the best ISP we've ever worked with.
Privacy policy
BT