Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Newbie Questions - Multimedia database Expand / Collapse
Author
Message
Posted Thursday, February 6, 2014 10:32 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 11, 2014 12:15 AM
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...
Post #1539008
Posted Tuesday, February 25, 2014 11:29 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, August 20, 2014 5:06 PM
Points: 154, Visits: 584
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
Post #1545085
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse