Find Jobs
Hire Freelancers

Database query design and explanation

$30-5000 USD

Cerrado
Publicado hace casi 16 años

$30-5000 USD

Pagado a la entrega
I have a database with information in several tables. I need to produce a 4 dimentional matrix (see below). Currently i use a series of inefficient queries and i need someone experienced in database query design to create efficient queries. The database is MySQL 5 and i use Java for application programming. ## Deliverables I am currently after a specific query ( or combination of queries ) but it is a situation that i encounter often so i need someone who is also able to explain how to approach database structure and query design. Please register your interest and be specific about your experience. If i feel you are suitable i will give you access to the actual database which is on-line. You will have ample opportunity to look at it before making a bid price. Please make a bid price for the required query(s) including some explanation. Also indicate an hourly rate should i require more extensive explaining. The matrix i need to produce consists of prices for betting opportunities. The colums consist of bookmaker prices, the rows are betting selections. An example of such a situation can be seen here: <[login to view URL]> The 4th dimension arises in handicap markets where the same bookmaker may offer several prices on the same selection including a score handicap. Example: <[login to view URL]> ( if these examples no longer exist by the time you read this then simply lookup other matches with "winner" and "asian handicap" markets ) I have tables for "market" ,"bookmaker"? , "selections" , "prices" , all can be linked using ID's in what i think is a fairly standard way. Again, if i feel you are suitable i will give you access to the actual database before you make a bid price. I need a query , or combination of queries and programming (Java only!), that is efficient and allows me to extract a full table. In case a bookmaker has multiple prices i want? these to appear as additional columns. ( so not as it's in the example, i want the bookmaker to? appear with multiple columns? ) - I understand that to obtain an efficient query i may need to change the structure of the database. - I understand i may need to combine multiple queries and possibly use some application programming in between. I'm currently producing a table by running each colum as an individual query filling array's as i go along. Highly in-efficient and there must be a better way. Any experience with Java serverside using Tomcat and JDBC will be a big plus.
ID del proyecto: 3922638

Información sobre el proyecto

3 propuestas
Proyecto remoto
Activo hace 16 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
3 freelancers están ofertando un promedio de $1.700 USD por este trabajo
Avatar del usuario
See private message.
$4.250 USD en 10 días
4,6 (24 comentarios)
6,7
6,7
Avatar del usuario
See private message.
$425 USD en 10 días
5,0 (6 comentarios)
4,6
4,6
Avatar del usuario
See private message.
$425 USD en 10 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de BELGIUM
Zelzate, Belgium
5,0
70
Forma de pago verificada
Miembro desde oct 9, 2009

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.