Find Jobs
Hire Freelancers

Database query design and explanation

$30-5000 USD

已关闭
已发布将近 16 年前

$30-5000 USD

货到付款
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: 3922638

关于此项目

3提案
远程项目
活跃16 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
3威客以平均价$1,700 USD来参与此工作竞价
用户头像
See private message.
$4,250 USD 在10天之内
4.6 (24条评论)
6.7
6.7
用户头像
See private message.
$425 USD 在10天之内
5.0 (6条评论)
4.6
4.6
用户头像
See private message.
$425 USD 在10天之内
0.0 (0条评论)
0.0
0.0

关于客户

BELGIUM的国旗
Zelzate, Belgium
5.0
70
付款方式已验证
会员自10月 9, 2009起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。