convert simple question on different languages (english, german and french) to SQL queries using NLP

Closed Posted 3 years ago Paid on delivery
Closed 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

Machine Learning (ML) SQL Python Java Software Architecture Data Processing Database Administration Database Design Database Development Database Programming Datatables MySQL Programming

Project ID: #25886702

About the project

15 proposals Remote project Active 3 years ago

15 freelancers are bidding on average ₹198900 for this job

matlabxperts

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

₹235294 INR in 20 days
(87 Reviews)
7.5
mmadi

Hello MarcelBang, Yes I have 10 years of experience in Data Processing, Database Administration, Database Design, Database Development, Database Programming, Datatables, Java, Machine Learning (ML), MySQL, Programming More

₹175000 INR in 36 days
(26 Reviews)
6.7
Darwish001

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

₹200000 INR in 7 days
(17 Reviews)
5.7
omanasoft

Hi, I have an already developed NL2SQL-tool that meets at least 50% of your requirements. I am a freelance software architect and NLP Researcher - 15+ years of rich experience, expertise in NLP, UML / OOAD, XML and Jav More

₹200000 INR in 7 days
(6 Reviews)
4.9
WycOj

Dear Client, I have checked your project and I have a clear understanding of this project, I am able to deliver quality work prior to your requirements ASAP. Please consider my bid and proceed with the hiring process More

₹200000 INR in 7 days
(19 Reviews)
4.4
d1master

Hello Nice to meet you. I'm python/database genius. I've read your job description and I have many experiences with such kinds of projects. I hope we can discuss more details in chat. I'll look forward to hearing from More

₹200000 INR in 15 days
(3 Reviews)
4.4
vovapod

Hello, I am a full-stack web developer. I have a lot of experience in CSS, Javascript, jQuery, HTML5, Joomla, Prestashop, Opencart, Drupal, Magento, React.js, React Native, mobile development ect. I also have huge ex More

₹223200 INR in 7 days
(7 Reviews)
3.4
nithyarajeshg

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.

₹150000 INR in 10 days
(26 Reviews)
3.3
Palakash21

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

₹200000 INR in 7 days
(2 Reviews)
2.9
bsgohel17

Hello MarcelBang, I hope are you away from the coronavirus... We have completed a number of projects in NLP also having a good experience and most relevant knowledge about Python, Java, SQL, Machine Learning, and man More

₹150000 INR in 15 days
(4 Reviews)
4.1
praveen2121

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

₹200000 INR in 31 days
(1 Review)
2.4
Fingertipinfo

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

₹200000 INR in 18 days
(0 Reviews)
0.0
nalliancetech

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

₹250000 INR in 120 days
(1 Review)
0.0