Find Jobs
Hire Freelancers

Database setup

$30-100 USD

Closed
Posted over 14 years ago

$30-100 USD

Paid on delivery
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
Project ID: 3066035

About the project

14 proposals
Remote project
Active 14 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
14 freelancers are bidding on average $73 USD for this job
User Avatar
See private message.
$85 USD in 14 days
4.9 (133 reviews)
7.4
7.4
User Avatar
See private message.
$85 USD in 14 days
5.0 (12 reviews)
5.2
5.2
User Avatar
See private message.
$51 USD in 14 days
5.0 (22 reviews)
4.7
4.7
User Avatar
See private message.
$61.20 USD in 14 days
4.8 (27 reviews)
4.6
4.6
User Avatar
See private message.
$85 USD in 14 days
5.0 (24 reviews)
4.6
4.6
User Avatar
See private message.
$42.50 USD in 14 days
5.0 (20 reviews)
4.5
4.5
User Avatar
See private message.
$85 USD in 14 days
5.0 (28 reviews)
4.4
4.4
User Avatar
See private message.
$85 USD in 14 days
4.9 (17 reviews)
4.2
4.2
User Avatar
See private message.
$85 USD in 14 days
5.0 (8 reviews)
3.8
3.8
User Avatar
See private message.
$85 USD in 14 days
5.0 (4 reviews)
3.5
3.5
User Avatar
See private message.
$85 USD in 14 days
4.9 (10 reviews)
2.7
2.7
User Avatar
See private message.
$25.50 USD in 14 days
3.3 (14 reviews)
2.5
2.5
User Avatar
See private message.
$76.50 USD in 14 days
0.0 (1 review)
0.0
0.0
User Avatar
See private message.
$85 USD in 14 days
0.0 (1 review)
0.0
0.0

About the client

Flag of UNITED STATES
United States
5.0
57
Payment method verified
Member since May 4, 2004

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.