BT

Your opinion matters! Please fill in the InfoQ Survey!

English Query Discontinued in VS 2005

| by Jonathan Allen Follow 190 Followers on Oct 10, 2006. Estimated reading time: less than one minute |

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.

Rate this Article

Adoption Stage
Style

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

Login to InfoQ to interact with what matters most to you.


Recover your password...

Follow

Follow your favorite topics and editors

Quick overview of most important highlights in the industry and on the site.

Like

More signal, less noise

Build your own feed by choosing topics you want to read about and editors you want to hear from.

Notifications

Stay up-to-date

Set up your notifications and don't miss out on content that matters to you

BT