Find Jobs
Hire Freelancers

Complicated database programming involving millions of searches within a few seconds.

$250-750 USD

En curso
Publicado hace casi 8 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 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. Our service relies on MySQL and Python along with open source libraries and frameworks. You should be familiar with: - SQL - Python and frameworks: • Bottle • SQLAlchemy You must be familiar with remotely accessing and managing Linux servers, developing multi-threaded applications, extracting/entry of JSON and XML formats, dealing with text of different encodings. You have to be good at search based algorithms and implement them using Python and SQL.
ID del proyecto: 10864306

Información sobre el proyecto

12 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
12 freelancers están ofertando un promedio de $601 USD por este trabajo
Avatar del usuario
The project is interesting for me. The requirements is very high-flying. I'm pretty sure that it is possible, but roughly estimated hardware requirements includes 100-1000 servers for parallel processing. I'm familiar with design, programming and deployment of similar systems, so I can implement it for you. For proposed budget and schedule I can implement the system for 1000 stations. Then having required hardware while next 2 months and $2000 the full specification.
$611 USD en 10 días
5,0 (14 comentarios)
5,2
5,2
Avatar del usuario
Hi. I'm a programmer from Russia with strong skills in C++ and Python. You can see the full list of my skills on my profile page. I've read the description of the project and have some questions. First, your hardware is important, because the one cannot perform true multithreading search algorithm on processor that has only one core. So the time of execution depends of it. Second. Is data sorted in the dump? This affects on complexity (and time) of the search algorithm. And third. Could you provide an information about accents? I don't see the example. Thanks for your answer. All the best, Sergey.
$500 USD en 10 días
5,0 (5 comentarios)
4,4
4,4
Avatar del usuario
Hello, My name is Irshad, I am certified python expert I have 4 years+ experience in python language and . i have completed 100+ projects using python .. would love to work on your project though its complicated ,but can make you satisfy , Expertise : Python, Django, Django-Rest- Framework and many python packages. My key Skills are: Python, AngularJS, Scala, JavaScript, Go, PHP, SQL, HTML, Jython, Perl, CSS. Platforms: Linux, Amazon Web Services (AWS), Google App Engine, Windows, Mac OS X You can test the quality of my work, if needed. Regards Irshad…
$490 USD en 9 días
2,8 (4 comentarios)
2,7
2,7
Avatar del usuario
Hello, I'm an experienced database programmer/designer/architect (more than 10 years of Oracle, mysql and postgresql) from Russia. I have a rich experience in databases (from small to huge data warehouses). Also I have strong knowledge in python and overall system administration (linux, freebsd). I hope I can help you with your project. Best regards, Andrey Kropachev
$500 USD en 10 días
5,0 (1 comentario)
0,4
0,4
Avatar del usuario
Thanks for posting this job, from the brief on your project, i discovered that this job takes so much professionalism and competence, I am known for professionalism and efficiency, i can assure you of a wonderful and great job that will surpass your expectation, I am committed to do your job proficiently and deliver it with excellence within a short period of time...All these can be done if you award me this project, Don't hesitate to give your project the best treat
$500 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Helo sir/ madam first of all thanks for posting this project.... i can do this project because i have a good platform of 250+emloyees are working which they having 10-15 years experienced employees , which u require to complete this project...i will deliver this project before the time period so that we can made good relationship in future., if u think you can contact us..and our team will prove you that we are the best..i can do this project before time..please contact us sir.. thank you .. SOURAV DUTTA
$250 USD en 4 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I have been working with databases (Oracle, Postgres) full time in the last 10 years. I feel confident and capable to work this out for you! Contact me and we'll work it out.
$700 USD en 7 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
Avatar del usuario
A proposal has not yet been provided
$333 USD en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de INDIA
Lucknow, India
5,0
44
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.