I need large datasets (>100,000) for some query questions using natural language and their corresponding answers
The Stack Exchange data dump is in XML format.
https://archive.org/details/stackexchange
It contains a huge amount of questions and corresponding answers. For example, you can get over 1,200,000 questions with the "java" tag. You can get any types of questions and answers. For example, you can extract only the "android" questions that have question scores larger than 10. You can extract only the answers with scores larger than 20, etc.
But it is in XML though parsing XML is easy.
I understood from the question that you need questions in natural language and their SQL statements. As I understand the stackexchange contains natural language questions and natural language answers so I'm not sure that this one could help if I understand right.
Yes, you are right. What I need is something like that:
For example (based on the famous Northwind database):
Natural Language Query:
Get the last name, job title, city and phone number of all employees who live in either Seattle or Kirkland, and have a phone number that starts with (206) and works as Sales Representatives.
Corresponding SQL Statement is:
SELECT LastName , Title , City , HomePhone FROM Employees WHERE City IN ('Seattle','Kirkland') AND HomePhone LIKE '(206)%' AND Title = 'Sales Representative'
I have developed a technique does what you want and I called it Intelligent query, I don't know if that you are asking about or not.
in this technique I get the query in almost natural language form the user in the application environment, after that I build its corresponding SQL then I execute it, displaying the data set result to the user
I'm not talking about the technique, I need the dataset. How did you validate your technique?
I know you are not talking about the technique but I thought if you liked my answer , I can cooperate with you by developing an application uses my technique to get your answers with user's query defined in natural language.
Validation of the technique has been achieved through its algorithm and case studies.
Did you get your answer?
I have been researching for such a dataset so came here.
- Badges
- Science topic
- Similar topics
- Mathematical Sciences
- Graphs