Database Project

Closed Posted Jun 24, 2010 Paid on delivery
Closed Paid on delivery

Provision 3D Media is in need of a scalable, searchable database with a front end search, retrieve, and print feature. This DB will collect records from thousands of computers daily. The database will be scalable such that at first it will receive data from only a few computers, but over the course of one year this DB will take in data from up to 100,000 computers daily.

The source data is CSV records of 2 types of kiosk usage. The first is data on 3D videos that played on a computer, these data account for about 6,000 records daily. Provision calls these Holo records. The second is broken into two categories, banner and coupon data. Each day, this type of kiosk records about 45,000 data points (98% of which is banner data) and places these data into a text file, zips the results, and uploads the package to an FTP server.

We need the following functionality:

- A DB that fetches and unzips data from the FTP server automatically

- A DB that sorts the three types of data into three different data categories (holo, coupon, banner) and outputs usable information on each

- A DB front end that allows users (Provision Staff) to easily and quickly retrieve information

- A DB that allows staff to generate and print professional usage reports (with provision's logo and the advertiser's logo and contact info)

- A DB that will scale as we scale up to tens of thousands of computers without the need for a DBA

SQL

Project ID: #721799

About the project

11 proposals Remote project Active Aug 3, 2010

11 freelancers are bidding on average $480 for this job

mastersact

Hi, I have 5+ years of experience in .NET, database and data warehousing related projects. I am quite confident that I can do this project on time and with great quality. Please refer to PMB for more details. Thanks.

$400 USD in 7 days
(2 Reviews)
3.2
mix2009

Hi, Please refer to PM. Thanks

$600 USD in 7 days
(1 Review)
2.4
madisonpaz

I work for 3 years developing web aplications and for almost 1 year developing scheduled tasks for large databases. See PM for details.

$475 USD in 12 days
(0 Reviews)
0.0
freelancemasters

Hello, We are interested in this project.. Please check Project Message Board..

$350 USD in 7 days
(0 Reviews)
0.0
ictforever

I am a database developer and dba with an experience over 12 years and keen to deliver you you the solution. regards

$480 USD in 3 days
(0 Reviews)
0.0
yan19

Hi, I am interested in taking up the project. Thanks, Yan

$750 USD in 25 days
(0 Reviews)
0.0
HollieM

I am an expert DBA and Developer and I am ready to start today. Thanks!

$300 USD in 6 days
(0 Reviews)
0.0
Zekini

I have developed many SQL solutions that fetches, unzipps and parses files to a relational database.

$375 USD in 40 days
(0 Reviews)
0.0
MarutiSoftech

I am not just a developer, I am a Microsoft Certified DBA for SQL Server 2005 and Microsoft Certified IT professional (MCITP/MCPD) for SQL Server 2008 database Programming, A eligible candidate for Microsoft Certified More

$600 USD in 30 days
(0 Reviews)
0.0