Own Query language for non-technical Users, any frameworks known?

[joes]

Hello

We have the challenge to introduce for our database applications a
dynmaic search for the end users. The end users are non-technical
users.

I am looking therefore for possibilities which would allow to build own
query language with expressions according to the need and skills for
the users.

I found one product so far. "EasyAsk - Decision Adviser". does somebody
know also other tools or frameworks which can be integrated?

http://www.easyask.com/product*s/decision-advisor.cfm

The environment is currently MS SQL Servers and C# Webservices.My
vision is to have a framework or library which can be seamless
integrated into our existing solutions which is currently a smart C#
clients. i.e. by using web-service or an C# API.

thanks
Mark Egloff

[Erland Sommarskog]

joes (jo**@bluewin.ch) writes:

We have the challenge to introduce for our database applications a
dynmaic search for the end users. The end users are non-technical
users.

I am looking therefore for possibilities which would allow to build own
query language with expressions according to the need and skills for
the users.

I found one product so far. "EasyAsk - Decision Adviser". does somebody
know also other tools or frameworks which can be integrated?

SQL Server itself comes with English Query, but I have never looked at
it myself.


--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[Trevor B]

I've had a little exposure to the plain english queries in SQL 2000. I can
only offer a little bit of information, unfortunately. The way it works is
by using english keywords to define the objects and fields that are
reflected by records in your database.

You can then ask questions like "How many products of type vegetable were
sold in the first quarter of 2004?" and get a response. I've always wanted
to get into it further but didn't get much more sophisticated than that.

Trevor B
"Erland Sommarskog" <es****@sommarskog.se> wrote in message
news:Xn**********************@127.0.0.1...

joes (jo**@bluewin.ch) writes:

We have the challenge to introduce for our database applications a
dynmaic search for the end users. The end users are non-technical
users.

I am looking therefore for possibilities which would allow to build own
query language with expressions according to the need and skills for
the users.

I found one product so far. "EasyAsk - Decision Adviser". does somebody
know also other tools or frameworks which can be integrated?

SQL Server itself comes with English Query, but I have never looked at
it myself.


--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp