convert simple question on different languages (english, german and french) to SQL queries using NLP
₹150000-250000 INR
Paid on delivery
using NLP generate SQL queries for any database from simple search
like
what are the sales today
compare iPhone sales with Samsung S10 everyday this year
etc
Detail of the project:
It is about the analysis of a denormalized dataset by the SQL Select command
That means there is no complex join. Since there is only one table where the data is denormalized.
The complete synthax of a select must work.
SELECT [ALL | DISTINCT] [AGREGAT FUNCTION],
[Alias.] Select_Item [AS Column_Name]
[, [Alias.] Select_Item [AS Column_Name] ...]
FROM [DatabaseName!]Table [Local_Alias]
[, DatabaseName!] Table [Local_Alias] ...
[WHERE Filter Condition]
[GROUP BY GROUPColumn
[HAVING FilterCondition]
[ORDER BY Order_Item [ASC | DESC] [, Order_Item [ASC | DESC] ...]
The NLP logic should be so strong that e.g. the column name does not have to be explicitly present in the query in the natural language to identify the column automatically.
For example, the following queries should be converted correctly to SQL.
1) What is the sales by product line ?
2) What is the evolution of sales by month?
3) how many sales did i get in EMEA by countries ?
4) what is the total of profit by type of product in usa?
5) what is the evolution of sales per city in the EMEA
The code must be properly documented. I was programming in Java at the time. That means I favor Open NLP as NLP Lib. But if you think Python is better, e.g. NLTK, you can use the library.
I have to be able to train my dataset in German, French and English without much programming. An interface via webservice is required after successful programming of the logic. In addition to the rule-based system, a learning system through machine learning must be implemented.
Please contact me if you have any questions. We can discuss about the budget and project plan as well as milestones.
Best regards
Marcel
Project ID: #25886702
About the project
15 freelancers are bidding on average ₹198900 for this job
Having more than 7 years of experience in data analytics, databases and Machine learning I believe that I can do your project perfectly. I have completed a number of projects related to NLP. I always try to give 100% t More
I CAN COMPLETE YOUR PROJECT EASILY Hello, I am software developer with enough experiences on Java/JavaFX for 13 years. Java/JavaFX is nice programming language and I am majoring on it for long years so I have confident More
My work strategy is to give regular status updates and intermediate version whenever required. I have experience in SQL, Data administration and programming and also in different ML techniques.
I am a full-time Full Stack Freelance having 7+ years of experience and have team working on Web App Developer-Designer (Specialising in CRM, ERP, Ecommerce, Website Developing & Designing, Android Apps, Ios Apps, web- More
Hi, Greetings! Let's join hands for long term relationships with the best Technical Team. Concerning your requirement, I have worked on similar projects and features to what you are looking for, and I am confident More
Hello, Sir. I read your opinion seriously. I have experience of 7 years and done similar projects in done similar projects before. As a man of trust, I can develop your project with full perfection. Let me go on, y More
Narinder Alliance Technologies LLC An IT Consulting and Software Development company. We have a team expert in Web Designing, Application Development and Databases. We have worked on various projects across various in More