Closed

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

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

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

See more: saying thank russian spanishchinese english german french, convert web page different languages, english translation french simple past, generating sql queries from natural language stanford, convert question to query, nl to sql, nlp2sql, automated sql query generator by understanding a natural language statement, convert text to sql query, nlp query parser, nlp to sql c#, 100 words english german french, joomla convert text different languages, translations english german polish portuguese french spanish italian, convert website different languages, convert different languages, translation different languages needed english going regular work, convert name different languages, net convert different languages, web design german english russian french

About the Employer:
( 0 reviews ) Bottrop, Germany

Project ID: #25886702

18 freelancers are bidding on average ₹210194 for this job

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
(25 Reviews)
6.7
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.4
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
(7 Reviews)
5.3
vorasiddh4it

I have read your requirements. I am managing director of software company and I have team for development so we can complete it perfectly. I am from India GMT +5:30 and I am available from 8:00 AM to 11:00 PM. We hav More

₹200000 INR in 20 days
(26 Reviews)
5.2
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
blakehamm

With 3+ years as a statistician and piloting of successful NLP projects, I am an ideal candidate. I have experience with a variety of packages and data formats including the NLTK package in Python. With an Economics an More

₹250000 INR in 14 days
(6 Reviews)
4.5
BEAS24X7

Hi, This is from BEAS Consultancy and Services Pvt Ltd ( [login to view URL] ). We are an India based CMMI level 5 and ISO Certified Organization. We produce quality and Cost-effective solution for our inter More

₹200000 INR in 15 days
(3 Reviews)
3.6
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
(2 Reviews)
3.4
nmladen83

Hi, I'm SQL (Oracle DB) expert and deep learning engineer. I'd love to help you with my experience. Best regards, Mladen

₹400000 INR in 5 days
(2 Reviews)
3.1
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
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
(5 Reviews)
2.5
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
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
(1 Review)
1.8
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
(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
(0 Reviews)
0.0
gsinfotechsingh4

Note : We are Requesting Read Carefully Our Description if your Ok with our Term's & Condition Then We can chat or call us else thanks we dont wanna waste our & your time. Description: Before Finalize Deal Our company More

₹150000 INR in 15 days
(0 Reviews)
0.0
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
(0 Reviews)
0.0
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