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.