Find Jobs
Hire Freelancers

Complicated database programming for searching and getting information

$250-750 USD

En curso
Publicado hace más de 7 años

$250-750 USD

Pagado a la entrega
You have to realize that you are being hired for a part of the project and not the complete project so don’t worry about the other details not relevant to you You can suggest your own frameworks and the language which you feel are relevant Project Background: We are developing a service that allows developers to access a repository with thousands of radio station streams from around the world. This service has an API formatted in JSON to allow other developers to access our information and build their own applications. Some radio stations provide meta data that can include the currently playing song on the radio station. This metadata is not properly formatted. This metadata is at most 2 strings separated by a hyphen. One for song name, the other for album name. We have already built a database of over 250,000 streams . Now we have a data dump of 150 million songs, roughly 7 million albums and 5 million artists in separate tables. This dump is not on our server, we have this dump in xml format. It needs to be uploaded in the form of tables. In the discogs data dump there are 3 separate tables containing song names, artists, and albums of millions of songs. Your job is to fetch the metadata from 250,000 radio stations. Separate the metadata string into two strings. Then match the two strings against 3 tables (from the data dump) in order to identify which string is the artist and which is the song name. We don't know whether the format is "song name - artist" or "artist - song name" it could also use the album name instead of the artist or song name. This has to be completed within 10 secs for all the radio stations combined. The matching algorithm has to take into account that accents can be different which should not affect the match. Here is an example of a few accents of different letters.
ID del proyecto: 11195784

Información sobre el proyecto

13 propuestas
Proyecto remoto
Activo hace 8 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi, this sounds like a very exciting project to me. I'm very experienced with "big data" projects like this one and I would love to implement this for you. I can write you a script that takes less than 2 seconds to accomplish this task and the script would also take typos into account (by using text distance metrics). Yours sincerely, – Alexander Rath
$300 USD en 3 días
5,0 (1 comentario)
3,0
3,0
13 freelancers están ofertando un promedio de $383 USD por este trabajo
Avatar del usuario
BOOKING! I have +10 years of experience in Python programming. What you want can be simply implemented in Python. But why in 10 seconds!? I am almost sure that you can not make 250,000 compare with 150M set song names, in 10 seconds, even if you have all in memory! Why do you have such restriction? Thanks, Helmot
$400 USD en 10 días
4,9 (146 comentarios)
7,8
7,8
Avatar del usuario
Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: • Expert in SQL Server, Oracle and MS Access Databases • Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) • Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools • Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling • Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. • Basic knowledge of Unix Shell scripting • Web Development using Java, CSS, and HTML ,PHP & Java Script • Expert in excel Macro • Expert in C & C ++ Programming I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14. We recently started our own company “Point5Nyble Your Needs, Our Dream”. We always work to provide Best Delivery with 100 % customer satisfaction Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Ashish-Point5Nyble
$333 USD en 10 días
4,9 (29 comentarios)
4,7
4,7
Avatar del usuario
Hello, I have extensively worked on conversion and interface projects that requires loading of data from file to the database and also have worked extensively on database programming. I should be able to build a query or development PL/mySQL construct identify the matching records for the combination of song/artist/album. The speed of the search as per your expectation is 10 secs, this depends on the server capacity (No of CPU)/RAM and other configurations (database server). If the server is of a high end, then surely it should take less than 10 sec (which also matter on the indexes created on the column and its usuage). Awaiting for your reply Regards Barduga
$350 USD en 10 días
5,0 (1 comentario)
2,6
2,6
Avatar del usuario
I represent a team of highly skilled professionals specializing in Agile/Lean methodologies, SCRUM, Php (Core Php, Symfony, Zend 2, Laravel, Codeigniter, Yii, Magento, Wordpress, Drupal, Joomla), Django-Python, Ruby on Rails, iOS, Android & UI/UX designing. Due to this I prefer fixed price jobs only. Highly skilled in Front-end development using CSS (SCSS/SASS), JavaScript, JavaScript libraries (, AngularJS, , , , , , Meteor), Jquery, Twitter Bootstrap & Html5. Extensive experience with both relational & non-relational databases like MySQL, MongoDB, PostgreSQL, NoSQL, MSSQL, SQLite. Mobile application development experience includes iOS development, iPad app development, Xcode, Objective-C, Swift, Android, Java, Xamarin, Phonegap & SQLite. Successful work experience includes 200+ projects, Real-time communication & VoIP portals (using XMPP, SDP protocols and WebRTC, WebSocket), . Looking for long term challenging work.
$250 USD en 10 días
5,0 (1 comentario)
1,2
1,2
Avatar del usuario
I am a full time freelancer and have no other job of any kind. I really want to build a serious career on this platform and its my start here so I can work for you upto 16 hours a day & 7 days a week, plus I have 24 hours electricity backup and a reliable fast internet connection. I have done Masters in Information Technology and a specialization in Web Design and Development. There is no issue of money as well you can pay little amount or can pay later if you have financial issue currently. Just Rate my work and give a Honest Review and it will be enough. +I have pretty good mastery in PHP and MySQL +JavaScript, jQuery and AngularJS +Specialized in Responsive Design and AJAX +Expert in WordPress, Joomla, Magento and Drupal +Have strong foundations in Laravel, CodeIgniter, Zend, Yii and CakePHP +HTML5 and CSS3 ***Pay ONLY IF you are 100% Completely Satisfied with work done. If you are not satisfied do not pay at all. Thanks for reading my proposal. Regards, Mubbarik Ali ____________ Recent Reviews of My Clients: “Very quick and accurate work, I was very happy with it :)” -Aidamediagroup (UK) Rating: 5/5 “Very professional Good Communication, timely delivery, quality work” -srayancejain from (US) Rating: 5/5 “mubbarikali was fantastic. He came through again on a quick timeline and continued to work making my document better.” -lou0187 (US) Rating: 5/5
$250 USD en 10 días
5,0 (2 comentarios)
0,6
0,6
Avatar del usuario
In which format we are going to get the metadata from 250,000 radio stations? C language is the fastest in text processing (We can use java as well). So we would use C language to separate the two strings. Linux must be used as operating system. Also all the tables that you are going to create from the dump should be properly indexed. Also I need to see if data dump can be inserted into a better designed database. Searching the database has to be done through several threads in parallel. I don't see any sample data attached to the request. I need the sample data to analyse and decide if we can use hadoop here. Please share the sample data with me. I have experience of system level (embedded) programming and very large scale data handling. I have experience of handing huge size file like 1-2 TB in AT&T.
$555 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am already working on a project which has the same type of database and i am very well with writing queries. So that i can finish this work may be in 2 days. Please provide me with first opportunity. I am new to this site but not to programming. i have experience working for MNC. So you can trust that i will complete this project. Waiting for your positive reply
$355 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
My background is in mathematics and philosophy but over the last several years I have been working cross-functionally with IT teams as a product manager and marketing analyst, primarily in charge of designing and implementing marketing strategies for email campaigns using Google Analytics for reporting. I have very good SQL skills (MySQL, Postgres, and T-SQL/MSSQL), I am strong in Excel, and I have a functional familiarity with python, php and the LAMP stack as well. I am proficient in R and planning on completing a Machine Learning course this summer that I hope will not only deepen my experience with Python but also add to my skills as an analyst. My background in logic, mathematics, product management and marketing analytics will translate into problem solving skills that will bring exceptional value to your teams. Finally, I am very familiar with ETL processes in general and working with large data sets/files.
$277 USD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$555 USD en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de INDIA
Lucknow, India
5,0
39
Forma de pago verificada
Miembro desde oct 8, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.