Em Andamento

mySQL/PHP Database Project

Experienced mySQL/PHP developer needed for a complex database project. Do not apply unless you can reference several successful projects you have completed involving large mySQL databases.

You will be tasked with creating a unified mySQL database by combining 30 datasets (totaling between 30,000,000 - 60,000,000 records) and developing a search interface and optimizing the database to allow certain queries to be performed very quickly.

This is not a simple project- so DO NOT APPLY UNLESS YOU ARE VERY CONFIDENT IN YOUR mySQL/PHP skills!

## Deliverables

**Database Indexing and Search Project:**

The goal of this project is to take a large set of records and create a database that can be searched using a variety of queries.

The initial goal is to replicate the functionality and query speed of this site: [[url removed, login to view]][1]

**Project Details:**

We have 30 data sets for various states in the U.S. Each set contains between 100,000 ??" 8,000,000 records. Cumulatively the total number of records is expected to be in the 40,000,000 ??" 60,000,000 range (that is our best estimate and may change a little).

Here is a sample record:

{First Name}{Middle Initial}{Last Name}{Address}{Address2}{City}{State}{Zip Code}{Property Type}{Property Amount}{Property ID}

We need a provider to take all these data sets (some are in .csv and some are in .sql format) and create a single unified structure and database.

We need the provider to create, using whatever technique he deems best, an index and optimize the database so that queries can be performed extremely quickly (none taking longer than 5 seconds). We also want the application to be built to handle a significant number of queries and spikes in the number of queries.

Query #1: {First Name}{Last Name} ->generate an amount that sums all the {Property Amount}s associated with the name entered. The query needs to display {First Name}{Last Name}{Sum of All Property Amounts}. This query will need to execute very quickly even when searching for common names that will match many of the records. Logic will also need to be built to search for common variations of the name entered. (Speed is critical for this query)

Query #2: {First Name}{Last Name}{State} -> generate results that include all the records (with all their information displayed) that match the query.

We have 3-4 other queries that we need to add to the website after the first two are completed.

**System Admin and Ongoing Database Support:**

We are also looking for a provider to recommend the hardware and software configuration (all open source) that will allow for optimal site performance. The provider will also set up (or work with our hosting provider to set up) all the servers and related software. We expect the provider to monitor database performance and perform general database admin functions on an ongoing basis.

**Additional Ongoing Activity:**

As we get user feedback we plan to add additional database driven functionality to the website. We expect the provider to continue to be available to work on these projects.

Habilidades: PHP

Ver mais: type searching data structure, best php developer, sql open source projects, sql developer open source, software developer names, sets data structure, searching index, searching software developer, searching data structure, sample system using php, recommend website developer, range query, property provider, property id, php developer information, php developer application, php code property search, needs property developer, need hardware developer, mysql search performance, mysql city state database, index data structure, developing website using php, data structure searching, common query

Acerca do Empregador:
( 17 comentários ) United States

ID do Projeto: #3021521

Premiar a:

kmzacks

See private message.

$892.5 USD em 160 dias
(187 Avaliações)
6.9

40 freelancers estão ofertando em média $869 para este trabalho

NetzPro

See private message.

$1062.5 USD in 160 dias
(370 Comentários)
8.5
devexpertsteam

See private message.

$1062.5 USD in 160 dias
(82 Comentários)
8.0
aviontechnology

See private message.

$1062.5 USD in 160 dias
(45 Comentários)
7.8
canlevw

See private message.

$1062.5 USD in 160 dias
(55 Comentários)
6.8
solutionsummit

See private message.

$1062.5 USD in 160 dias
(72 Comentários)
6.7
samirkumardas

See private message.

$1062.5 USD in 160 dias
(218 Comentários)
6.7
suthernsoftware

See private message.

$850 USD in 160 dias
(61 Comentários)
6.6
informatixt

See private message.

$935 USD in 160 dias
(68 Comentários)
6.5
AliQ

See private message.

$1062.5 USD in 160 dias
(52 Comentários)
6.0
aalogicvw

See private message.

$680 USD in 160 dias
(59 Comentários)
5.8
ssspl

See private message.

$807.5 USD in 160 dias
(54 Comentários)
5.8
saseow

See private message.

$1062.5 USD in 160 dias
(18 Comentários)
5.5
milliard

See private message.

$935 USD in 160 dias
(8 Comentários)
5.4
pabloglez

See private message.

$595 USD in 160 dias
(36 Comentários)
5.2
norberto108vw

See private message.

$1062.5 USD in 160 dias
(23 Comentários)
5.2
trkr

See private message.

$1062.5 USD in 160 dias
(40 Comentários)
5.1
aruhat

See private message.

$1062.5 USD in 160 dias
(12 Comentários)
5.0
c0nvurs3

See private message.

$850 USD in 160 dias
(14 Comentários)
4.9
xolutionsvw

See private message.

$1020 USD in 160 dias
(10 Comentários)
4.8
alexitkin

See private message.

$509.15 USD in 160 dias
(27 Comentários)
4.6