BT

InfoQ Homepage News English Query Discontinued in VS 2005

English Query Discontinued in VS 2005

Bookmarks

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
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.

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

Community comments

  • SQL?

    by Michael Neale /

  • SQL?

    by Michael Neale /

    Your message is awaiting moderation. Thank you for participating in the discussion.

    Didn't SQL come from :

    "Structured english Query Language" to start with?

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

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

BT

Is your profile up-to-date? Please take a moment to review and update.

Note: If updating/changing your email, a validation request will be sent

Company name:
Company role:
Company size:
Country/Zone:
State/Province/Region:
You will be sent an email to validate the new email address. This pop-up will close itself in a few moments.