New Pornstar Interviews - [more]
Introducing Lady LorReign

"Good oral on me turns me on. Also, knowing that my partner is enjoying themself,"
All Forums > Tech Talk > Tech Talk Forum Page 24 > database organization
AuthorPost
rolemco
Member


220 Posts
7/05
Posted - Dec 9 2008 : 2:18PM
I'm up to about 4 terabyte of content, video and images. I'm looking for a way of filing everything so that it is accessible several ways. At the moment I have individual volumes with folders designated for stars/scenes/sites. I'd like to be able to tag the content to be able to search the content by name/genre/movie/etc..
I'm a microsoft xp user, is this something that can be done with a ms office type product, possibly access? Any help is greatly appreciated. Thanks in advance.
BigBobxxx
Senior Member

2681 Posts
5/04
Posted - Dec 9 2008 : 4:21PM
I harvest my porn collection and archive it on external hard-drives and DVDs.
What you need to do is create a database with as many separate fields of information you wish to be able to sort by. You can create additional fields later on, so don't sweat it.
I believe that a consistent naming scheme for your files is a must!
For example:
Kelly Kline (Barely Legal #46) 1of2.VOB
Kelly Kline (Barely Legal #46) 2of2.VOB
Kelly Kline (Barely Legal #46) cumshot.VOB
Kelly Kline (Blowjob Fantasies #20).VOB
Kelly Kline (Blowjob Fantasies #20) cumshot.VOB
Kelly Kline (North Pole #51).VOB
Kelly Kline (North Pole #51) cumshot.VOB
Kelly Kline (Sex Addicts).VOB
Kelly Kline (Sex Addicts) cumshot.VOB
Kelly Kline _as Kelly Klein (Who's Your Daddy #4) bonus.VOB
Kelly Kline _as Kelly Klein (Who's Your Daddy #4) bonus cumshot.VOB
Star (Name of Movie) Describe
(the .VOB is just the file extension, and not part of my naming scheme)
My basic database includes the following six fields:
File the full file name as shown above
Backup DVD if you're making backup DVDs, this is the DVD # (i.e. 0001, 0002... 0430, 0431... 1005, etc.)
>>> In your case, this might be HD#1, HD#2, etc. <<<
Source the name of the movie (or, I guess, website)
Source Media DVD, VHS, Internet, etc.
File Type .VOB, .MPG, etc.
Scene Type scene, cumshot, BJ, solo, tease, lez, photo shoot, behind-the-scenes, etc.
Some things might not be obvious:
(a) 1of2, 2of2 at the end of the file name are when the scene is larger than 1 GB (i.e. video DVD .vob files are limited to 1 GB). So, when a scene is larger than 1 GB, you must have multiple files.
(b) Cumshot, popshot, ejaculation, BJ are due to the fact that I harvest and create these clips myself in addition to the original scene itself.
I create sequential backup DVDs as I harvest my porn collection.
This is the primary purpose of the database.
As I create each DVD, I maintain a simple word processing file of the contents of each disk.
Then, each disk's contents are also entered into the database.
I also back everything up onto hard-drives for quick and easy access... and use
My external hard-drives archive consists of seven 1 TB drives:
Scenes A-B & W-Z
Scenes C-I
Scenes J-K
Scenes L-Q
Scenes R-V
Cumshots (includes Popshots, Ejaculations and BJs)
XXXtras (includes trailers, title credits, behind-the-scenes, sex ads, photo shoots, etc.)
Since everything on the external hard-drives archive is also (and first) backed-up to DVDs, there is no need to enter the hard-drive contents into the database (it's already there).
The file naming scheme I discussed, by default, sorts everything in alphabetical order. So, all files belonging to a performer sort together.
Your database, basically, will tell you if you have something, and what backup DVD it is on.
If you have it, it will also be on the appropriate external hard-drive.
NOW, if you only have backups on your external drives, and you didn't organize them from the start as I did, you will simply treat your hard-drives the way I treat my DVDs.
We can discuss more once I know more about how you have built your collection, backed it up, and naming scheme (if any).
Heretic
New Member

4 Posts
6/08
Posted - Dec 21 2008 : 12:14AM
Adding metadata when you have a variety of source formats is difficult at best. A naming standard as outlined by Bob is workable, if low-tech. You'll need to build some command-line tools to, for instance, search for all anal scenes after 2005 by a certain star. Look at http://www.romcenter.com/datafiles/tosec/tosec_naming_convention.htm for an example of this approach applied to non-video files. The important thing is to be consistent.
The alternative is to convert to a single format (container) that allows good metadata, and add it from once in that format.



Jump To: