Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Newbie Questions - Multimedia database


Newbie Questions - Multimedia database

Author
Message
_Adrian_
_Adrian_
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 18
Hey guys and gals...
I'm trying something new and hoping it works.

I have a large collection of movies, cartoons and music that over the years it has grown to over 35TB and growing !!

I want to create a database that will allow me integrate into a internal site im building so it speeds up the search feature, more or less like an indexing service, but i also want it to retrieve information about the file to be displayed.
As an example:

Movies - Thumbnail / Year / Genre / Plot / Actors
Music - Album Art / Artist / Album / Year / Song


I have about 100GB set aside for this "indexing" service across 4x 36GB 15K SAS drives ( RAID5 ) that are going to be running just dedicated for this.

This would speed up the site and make a query simple and fast as all the info is stored in the database and the file location and pointers to the file would reduce search times on the larger slower drives and allowing the system to take advantage of the smaller faster drives.
Queries would be done through IMDB which would have the information listed, just need to point the database to pull the right files and data off the website.

Any input would be greatly appreciated !!

PS:
Working with SQL2012 but haven't found a newbie section on there...
autoexcrement
autoexcrement
SSC Veteran
SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)SSC Veteran (204 reputation)

Group: General Forum Members
Points: 204 Visits: 777
What do you need help with? Designing your database tables? Or writing code to parse IMDb? The latter would be beyond the scope of a database. The former we can help with, but we'd need more information about specifically what data you need to store, etc.


"If I had been drinking out of that toilet, I might have been killed." -Ace Ventura
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search