Encerrado

Database setup

Hi there,

I have a project in which I need to develop a database, so I am posting a bid request to find someone to help me do this. There are a few quarks to the database though. The DB is not built yet, so please read the description of what I need and decide if you can help complete it, and how.

One column of the database will be binary data of 144 bytes. A second column will be an identifier column (string). Then of course a unique identifier column so there aren't duplicate entries.

However, querying the database is where I am having some conceptual issues. To query I have another binary variable of 144 bytes that I need to multiple by the binary column of the database to take the dot product. In other words, the first byte of the query data multiplied by the first byte of the binary database record. Then add that to the second byte of the query data multiplied by the second byte of the database record. Then add that to the third....you get the idea. This results an integer, and is called the scalar dot product of the two binary datasets.

Moving on, the query needs to compute the dot product between the query binary data and the binary data for each record in the database and return the highest value.

The problem is that I have millions of records, so using a recursive loop to calculate the dot product seems out of the question. Additionally, the speed of the query is always a concern. Faster is better :)

Can someone see how this type of database should be setup? I am open to using any architecture, so long as it runs on Windows. MSSQL, MySQL, MongoDB, Whatever, etc.

When bidding, please give me a little information about how you might be able to accomplish this...please no "I can do it" bids consisting of one line and doesn't tell me anything about your database programming skills.

Thanks!

Brett

Habilidades: Engenharia, MySQL, Perl, PHP, Gestão de projetos, Python, Ruby on Rails, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Ver mais: what is recursive programming, what is recursive, what is mongodb, what is database programming, what is a variable in programming, what is a string in programming, what is a loop in programming, two string problem, scalar programming, recursive programming, recursive problem, problem setup, how to find that i am for programming, how to do binary, find binary, binary problem, binary integer programming, mssql having, mongodb php, mongodb c++, database skills, php database programming, recursive, mssql mysql, database question

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

ID do Projeto: #3066035

14 freelancers are bidding on average $73 for this job

newgroup4u

See private message.

$85 USD in 14 dias
(133 Comentários)
7.4
dbgeeks

See private message.

$85 USD in 14 dias
(12 Comentários)
5.2
expbingo

See private message.

$51 USD in 14 dias
(22 Comentários)
4.7
alexitkin

See private message.

$61.2 USD in 14 dias
(27 Comentários)
4.6
frankdull

See private message.

$85 USD in 14 dias
(24 Comentários)
4.6
jpcentral

See private message.

$42.5 USD in 14 dias
(20 Comentários)
4.5
kennithnichol

See private message.

$85 USD in 14 dias
(28 Comentários)
4.4
chandreshkumarlx

See private message.

$85 USD in 14 dias
(17 Comentários)
4.2
tabakerka

See private message.

$85 USD in 14 dias
(8 Comentários)
3.8
gerrysvw

See private message.

$85 USD in 14 dias
(4 Comentários)
3.5
cyrusbermejo

See private message.

$85 USD in 14 dias
(10 Comentários)
2.7
vipuldshah77

See private message.

$25.5 USD in 14 dias
(14 Comentários)
2.5
abrukovskyv

See private message.

$76.5 USD in 14 dias
(1 Comentário)
0.0
vw7421755vw

See private message.

$85 USD in 14 dias
(1 Comentário)
0.0