Đang Thực Hiện

Complex MySql query

We need a MySQL / DBA expert. We have a mysql databse, a java based webservice using jdbc and mobile apps that communicate with the service.

Requirements:

1) Analyze/Make recommendations for optimizing and improving schema of an existing small mysql database (not currently in production, sample data, 8 tables total). Specifically we need recommendations for a Twitter like "follower" table. Our existing table looks like this:

create table

followers(

user bigint,

follower bigint,

primary key(user, follower),

key(follower, user),

constraint `fk_user` foreign key (user) references userID(user),

constraint `fk_friend` foreign key (friend) references userID(user)

);

We need to know the best way to find both the logged in user's followers, and the people he/she is following. Should we also have a "following" table? We would like freelancer to make any database schema improvements.

2) Analyze/Optimize existing query for efficiency, etc.

SELECT " +

"[url removed, login to view], [url removed, login to view], [url removed, login to view], " +

"[url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view]," +

"[url removed, login to view], [url removed, login to view], [url removed, login to view] " +

"FROM catchDetail as cd, ratingMaster as rm, species as sp" +

" WHERE [url removed, login to view] = [url removed, login to view] and [url removed, login to view] = [url removed, login to view] and [url removed, login to view] = ? " ;

3) Create new query based on existing query

- grab id of logged in user - This is done through our mobile app and transmitted to webservice

- grab all of the people he is following

- see if any of these people have any rows from the first query in the past X days and produce the same results as the first query. We need mixed results from all people the user is following who meet the criteria listed.

- limit results to X rows at a time, be able to repeat the query and get the next X results

We'll have more consulting work of this type available for the right freelancer. Please contact us with any questions.

Kỹ năng: Java, MySQL

Xem thêm: who to create id on freelancer, where to find work as a freelancer, where to find java, where to find freelancer work, where to find app freelancer, where is freelancer based, small improvements, rm freelancer, recommendations freelancer, n query, next available freelancer, Mysql questions, mysql city state database, key criteria, java freelancer work, java freelancer new, grab the freelancer, get right freelancer, get listed as a freelancer, freelancer webservice, freelancer user id, freelancer sp sp, freelancer small city, freelancer recommendations, freelancer no cd key

Về Bên Thuê:
( 7 nhận xét ) Reno, United States

Mã Dự Án: #1038714

Đã trao cho:

projectxmaker

thanks for checking my PM :)

$50 USD trong 1 ngày
(1 Đánh Giá)
3.4

8 freelancer đang chào giá trung bình $137 cho công việc này

eperfections

Dear Sir, We have few years of experience in database and queries building. We are interested in your project. Can you please provide more details for JAVA based web service. We are ready to start this project but f Thêm

$136 USD trong 2 ngày
(381 Đánh Giá)
7.2
jacekphp

Hello, please check PM. Regards, Jacek

$250 USD trong 3 ngày
(3 Đánh Giá)
5.6
gangabass

I can do this job for you. See PM for details.

$150 USD trong 2 ngày
(51 Đánh Giá)
4.8
mohsshahid

we can do this with in 6 hours cuz we are having a gr8 command

$100 USD trong 1 ngày
(5 Đánh Giá)
3.3
utd2009

Hi, I am a Database expert and we have great experts in MySQL, MS SQL server and Oracle database. I myself worked with Intel Corporation on creating a database. We believe we can provide you good solution within least Thêm

$130 USD trong 2 ngày
(3 Đánh Giá)
2.7
nilogram

Hello, I am an expert at constructing efficient database designs and queries. Please pm to further discuss this project.

$250 USD trong 2 ngày
(0 Đánh Giá)
0.0
Frankie4Fingers

Check PM, please.

$30 USD trong 2 ngày
(0 Đánh Giá)
0.0