February 10, 2010 at 9:52 pm
I am exploring the available Natural Language Interfaces for database, then I came across English Query, and faced following problem...
Our schema looks like as shown below:
Customer : (customer_id, customer_name, customer_address)
Transaction : (transaction_id, amount)
Transaction_Customer_Mapping: (transcation_id, customer_id)
Here, transction_id in Transaction_Customer_Mapping refers to transaction_id in Transaction table and customer_id in Transaction_Customer_Mapping refers to customer_id in Customer table.
Whenever we fire a query like:
"Give all transactors with amount > 100 "
It gives us correct answer, with following view part:
transaction_id customer_name amount
1 John 200
1 Rohit 200
2 John 300
2 Mark 300
But it shows replica of transaction_id and amount for each unique transaction performed between two customers. Is it possible to control over view part for this to obtain following result?
transaction_id t1.customer_name t2.customer_name amount
1 John Rohit 200
2 John Mark 300
Hope you help us by suggesting some appropriate solution.
February 10, 2010 at 9:57 pm
If you are looking at upgrading to SQL Server 2005 or newer, I wouldn't bother. English Query goes away with SQL Server 2005.
February 12, 2010 at 12:09 am
Actually, I want to build an application that would allow my users to query in English, that's why I have to stick to English Query, and thus SQL 2000,
Is there a better tool then ENglish query other that ELF(English Language Frontend).
Or is it possible to modify the view as I asked ablove.
Please help me out, as I am really stuck with what to do??
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply