Something went wrong. Try again later

drewbert

This user has not updated recently.

9000 4598 2601 67287
Forum Posts Wiki Points Following Followers

The Wonderful World of Video Data Management

Giant Bomb's Game of the Year awards are fast approaching, and you know what that means! Asset compilation! This is the time of year when we descend into the dusty catacombs of Giant Bomb's video archives and pull out all the relevant footage of games we're talking about. Since a few of you have requested insight into such topics, I thought now would be a good time to shed some light on how we manage our video data.

 Capturing some exciting gameplay footage.
 Capturing some exciting gameplay footage.
The life of a Giant Bomb gameplay video, such as a Quick Look, begins at the capture stage. We plug our consoles into our capture gear, turn on the microphones, and hit "record" (it's a little more complicated than that, but that's for another post). The resulting video file is saved onto our capture machine, which resides in the control room. From there, the producer copies this "master" file over the network to their machine so they can work on it.

At the same time, the master is copied from the capture machine's local hard drive to an attached external hard drive. This is so we can delete the master from the local drive to save space (the local drive is only 500GB, which lasts us a week at most). When the external hard drive gets full, we unplug it, label it "Capture Archive ##," and set it on the shelf. A new hard drive goes in its place, ready to accept hours upon hours of game footage.

 The compressor machine's output log.
 The compressor machine's output log.
Meanwhile, the producer is toiling away on a video, using the master file brought over from the capture machine. Once the video is edited and complete (at this point, we call it an "export"), it gets copied, over the network, to our compressor machine, where magical things happen. Because we use an off-site compression solution (i.e., we send our videos across the Internet for someone else to compress), we first have to get our videos down to an Internet-friendly size. To do this, we do a preliminary compression using the compressor machine in our office. This turns our unruly 30GB video files (for a 30-minute video), into a little under 1GB. This file also ends up becoming the HD version of the video that members download/see on the site. From there, our off-site encoder chews through the video we give it and spits the result out onto the website.

When that's done, the original file from the producer (the "export") and the resulting compressed file (the "output") are copied to an external hard drive attached to the compressor machine. As before, when that hard drive fills up, we unplug it and label it "Exports ##." So now, we have three iterations of the video file (master, export, and output) in two places (Capture Archive and Export Archive drives). But THAT'S. NOT. ALL.

We still have all the files on the producer's machine! As you can imagine, a project like a Video Review takes up a LOT of hard drive space with all the footage we have to capture (sometimes upwards of 100GB). Technically, we could archive all that stuff, but in reality, when you're done with a project, there's really no reason to keep all that unused footage around. That's where "trimmed" projects come in.

 Media manager, making it look easy.
 Media manager, making it look easy.
Final Cut Pro, the software we use to edit all our videos, has a feature called "Media Manager." Media Manager looks at all the clips you used in your project and copies only those sections of the original video file to a folder you designate. That means, if I have an hour-long gameplay video, but only use 15 seconds of it, Media Manager will only keep the 15 seconds, not the entire hour. This cuts down the project from a suicidal 100GB to a much more manageable 5-10GB. When Media Manager is done doing its thing, we copy the folder it makes to an external drive called "Trimmed Projects." The cool thing about trimmed projects is that they keep the Final Cut project files as well, allowing us to make small changes to the video after the fact if we find a typo or something.

 Our super-secret hard drive database software.
 Our super-secret hard drive database software.
Now all our projects are now safe and secure in the Capture, Export, and Trimmed Projects archives. Nice, but how do you FIND something if you have to go back and dig something up? We here at Giant Bomb use an extremely powerful and highly technical database application known as Google Docs. When a drive fills up, we enter the file names of all the files on that drive into a Google Spreadsheet document, with each drive getting its own tab. That way, all we have to do is search the document for the game we want footage of, and we can see exactly where it is.

And there you have it! Now, hard drives aren't the best backup solution (they are subject to data corruption, hardware failure, and nuclear strikes, unlike cloud-based storage), but they are cheap and easy. Our archiving solution may not be the most secure and flexible, but it is cost-effective and easy to do. And best of all, it works for us!
 
 The BOBOD: Big ol' Box o' Drives.
 The BOBOD: Big ol' Box o' Drives.
65 Comments

66 Comments

Avatar image for vr00m
vr00m

223

Forum Posts

2

Wiki Points

0

Followers

Reviews: 0

User Lists: 1

Edited By vr00m

 Awesome write up.
I'd be great to see the evolution of the video work flow for whiskey media. Just some huge timeline with pictures of the gear and setups you have used from the inception of all this till now. I love gear porn.
 
Also use off site compression at work sometimes.  Our computers are slow compared to our internet line that uploading it to a video hosting service, then downloading it and then uploading to our servers is quicker than doing it all locally.  As well as freeing up the computer.

Avatar image for azteck
Azteck

7415

Forum Posts

5

Wiki Points

0

Followers

Reviews: 0

User Lists: 2

Edited By Azteck

You're the man, Drew!

Avatar image for confideration
confideration

607

Forum Posts

7

Wiki Points

0

Followers

Reviews: 0

User Lists: 1

Edited By confideration

Super cool!

Avatar image for gideonamos
GideonAmos

215

Forum Posts

0

Wiki Points

0

Followers

Reviews: 0

User Lists: 0

Edited By GideonAmos

This is a very interesting read Drew! A look into what's behind the video production such as this is always inspiring to me. Please do share more of the technical side of Whiskey Media's video production!

Avatar image for 1p
1p

798

Forum Posts

42

Wiki Points

0

Followers

Reviews: 0

User Lists: 3

Edited By 1p

Thanks for posting stuff like this, it's very interesting to me.

Question: What's the capture format you use? I'm guessing a lossless one at 720p?

Avatar image for guthwulf
guthwulf

330

Forum Posts

1338

Wiki Points

0

Followers

Reviews: 0

User Lists: 4

Edited By guthwulf

Cool Drew. That was really interesting.
It's nice to get a glimpse into what's going on in the "background" your site. Also. I'm surprised how many steps there are between recording the footage and the final product. I had imagined it would be a little easier than that.
 
Well, there goes my dream of recording gameplay videos of my own :P

Avatar image for enchantedecho
EnchantedEcho

810

Forum Posts

659

Wiki Points

0

Followers

Reviews: 17

User Lists: 6

Edited By EnchantedEcho

Thanks for doing this, looking forward to hear about the capture process and the specific hardware that you use to do the job.

Avatar image for buhssuht
buhssuht

477

Forum Posts

3994

Wiki Points

0

Followers

Reviews: 0

User Lists: 4

Edited By buhssuht

I love it when GB or any other Whiskey Media crew share their work.

Avatar image for bjorno
bjorno

1476

Forum Posts

509

Wiki Points

0

Followers

Reviews: 0

User Lists: 3

Edited By bjorno

It looks just like my bog box of hentai HDs

Avatar image for ghostdog
ghostdog

22

Forum Posts

3

Wiki Points

0

Followers

Reviews: 0

User Lists: 1

Edited By ghostdog

Great article Drew! I hadn't really thought about how you handle all of the video but I immediately gravitated to the post.

Avatar image for mithhunter55
mithhunter55

1104

Forum Posts

709

Wiki Points

0

Followers

Reviews: 1

User Lists: 1

Edited By mithhunter55

  @drewbert:  I wonder if I helped encouraged this.   ; ) 
 GoogleDocs haha, very nice.
 
 @drewbert said:

" @bluephoenixmedia said:

" Have you looked at Carbonite Pro yet? "

According to this page, it's $250 per month for up to 500GB. Even if they could accommodate all our data, at that rate we'd be paying over $15,000 per month. Is there another option you're referring to? Services like that are tricky, too, since they often require the data to be resident on your computer at all times, which is impossible for us.
 Yeah, I think there unlimited was for home use and all the data actually on the computer and externals. 
 
I would be interested to know what your server set-up is like aswell, where are you hosted? Where do our video downloads come from? And members should back the video up at home. :P
Avatar image for hamst3r
Hamst3r

5520

Forum Posts

7837

Wiki Points

0

Followers

Reviews: 11

User Lists: 2

Edited By Hamst3r
@drewbert:  Awesome! :D
 
What capture gear do you use for the consoles?
Avatar image for alistercat
alistercat

8533

Forum Posts

7626

Wiki Points

0

Followers

Reviews: 2

User Lists: 27

Edited By alistercat

Thanks for the info drew. As an aspiring designer/video producer I have so many questions I want to ask you and Vinny. All this stuff must be hell, but it looks like magic to the average user.

Avatar image for philsmith007
philsmith007

80

Forum Posts

18

Wiki Points

0

Followers

Reviews: 0

User Lists: 3

Edited By philsmith007

Fuckin great article, Drew!

Avatar image for philsmith007
philsmith007

80

Forum Posts

18

Wiki Points

0

Followers

Reviews: 0

User Lists: 3

Edited By philsmith007

Fuckin great article, Drew!

Avatar image for winternet
Winternet

8454

Forum Posts

2255

Wiki Points

0

Followers

Reviews: 0

User Lists: 6

Edited By Winternet
@Red12b: I didn't ask anything.
Avatar image for bluephoenixmedia
bluephoenixmedia

58

Forum Posts

306

Wiki Points

0

Followers

Reviews: 0

User Lists: 0

Edited By bluephoenixmedia
@drewbert: wow, I assumed they had a flat rate...my bad...what about the amazon s3 service? I know shit gets expensive with video but maybe whiskey media could front the cost? what does tested use? the same method? 
Avatar image for lamiafusion
lamiafusion

79

Forum Posts

515

Wiki Points

0

Followers

Reviews: 0

User Lists: 6

Edited By lamiafusion

 I am doing this kind of stuff in school right now so it is awesome to see how you guys have streamlined the process for yourselves.     

Avatar image for drewbert
drewbert

9000

Forum Posts

4598

Wiki Points

0

Followers

Reviews: 0

User Lists: 7

Edited By drewbert
@bluephoenixmedia said:

" Have you looked at Carbonite Pro yet? "

According to this page, it's $250 per month for up to 500GB. Even if they could accommodate all our data, at that rate we'd be paying over $15,000 per month. Is there another option you're referring to? Services like that are tricky, too, since they often require the data to be resident on your computer at all times, which is impossible for us.
 
@Video_Game_King said:

" @drewbert:  Shit. I'd ask for cheaper alternatives, but right now, I'm just concerned with how you get it on the computer, given that I don't see a USB plug or any cable that plugs into a computer. Balls don't plug into things. "

Yeah, sorry, that's an XLR mic. It won't plug into a computer without something like this, but if you're serious about your audio, XLR is the way to go. I don't know much about USB mics, but I'm sure there are some armchair podcasters out there who can point you in the right direction.
Avatar image for video_game_king
Video_Game_King

36563

Forum Posts

59080

Wiki Points

0

Followers

Reviews: 54

User Lists: 14

Edited By Video_Game_King
@drewbert:
 
Shit. I'd ask for cheaper alternatives, but right now, I'm just concerned with how you get it on the computer, given that I don't see a USB plug or any cable that plugs into a computer. Balls don't plug into things.
Avatar image for bluephoenixmedia
bluephoenixmedia

58

Forum Posts

306

Wiki Points

0

Followers

Reviews: 0

User Lists: 0

Edited By bluephoenixmedia
@drewbert:  Have you looked at Carbonite Pro yet? I believe it's roughly $100 a year or so and they support external drives for unlimited data. (at least they advertise it, not sure if there's an invisible cap) I'm pretty sure that's what leo laporte uses for his twit network.  I swear I'm not affiliated I just seriously have seen some terrible things happen to folks with data loss and I use a home media server myself with redundancy but I'm not dealing in the levels of data you guys are. As long as you don't mind the slow upload cap to their servers and run the system non stop for a few months you'll probably be able to have all of your drives backed up eventually.  I'm sure you guys could write if off in taxes as a business expense too.
Avatar image for drewbert
drewbert

9000

Forum Posts

4598

Wiki Points

0

Followers

Reviews: 0

User Lists: 7

Edited By drewbert
@99X said:

" Are you using just regular sata drives and an enclosure to make them into externals? "

We use these. They make swapping drives all the time super easy.
 

@dudeglove

said:

" Does the off site processing not end up a little costly? "

Each video gets three separate compressions (Low, High, and HD), and we have five websites with video content, so it makes more sense to outsource it to a place that can process an unlimited number of videos at the same time. Since our office machine can only process a few videos at a time, the compression queue would fill up real quick.
 

@MrHeist

said:

" Are drives segregated by WM site,  or does it all flow together depending on who's doing what? Now that you're doing more and more videos with picture in picture (quick looks for kinect, move, etc) how much does that additional feed add to the storage size? And has it put a major increase on prep time for those videos?   Have you thought about doing some sort of expandable RAID solution for backup (something like a bigass Drobo), or would you still tear through those too fast? "

1. All Whiskey videos end up on the same Capture and Export drives. Trimmed drives are producer-specific.
2. The Quick Looks that use picture-in-picture/green screen stuff get composited in real time using our Tricaster system (yet another post for the future), so it doesn't require any post-processing and gets archived the same way a normal Quick Look would. The green screen on I Love Mondays, however, is done in post, so that ends up on the Trimmed drive. The green screen stuff does add to the turnaround time, but it's way faster with the Tricaster.
3. Right now, it's cheaper to keep pumping out hard drives than to have a huge RAID system. The initial purchase and setup cost for those things is significant, and we would still have to keep adding drives anyway.
 

@MooseyMcMan

said:

" I'm not an expert on cloud stuff, but wouldn't a nuclear strike mess that up too?  "

The way I understand it, a lot of cloud backup services duplicate their data across multiple data centers around the country. That way, if Seattle gets nuked, Atlanta still has a copy of your data.
 
@bluephoenixmedia said:

" wow you guys are nuts to not use an online back up service. "

We'd love to, but it's ridiculously expensive for how much data we generate.
 
@Video_Game_King said:

" any microphone recommendations? "

We use these.
 
@Gaff said:

" Hard questions must be asked: stacking all the drives on top of each other, which Whiskey Media staff measuring unit would we get? A Chloe, an Ana, a Norm, a Brad or a Coonce? "

Actually, each Export drive gets duplicated and stuck in a different box under Vinny's desk, so really we have about double the amount of hard drives you see in the picture. If we're assuming the hard drives are laying flat, I'm guessing about an Ana.
Avatar image for bigheart711
Bigheart711

1272

Forum Posts

1023

Wiki Points

0

Followers

Reviews: 0

User Lists: 13

Edited By Bigheart711

Nice. Very nice! :)

Avatar image for death_unicorn
Death_Unicorn

2879

Forum Posts

12136

Wiki Points

0

Followers

Reviews: 3

User Lists: 6

Edited By Death_Unicorn

That was super interesting, thanks!

Avatar image for red12b
Red12b

9363

Forum Posts

1084

Wiki Points

0

Followers

Reviews: 0

User Lists: 6

Edited By Red12b

Could you get Ryan to do one of these for the Bombcast?  
 
Because he edits that doesn't he? 

Avatar image for red12b
Red12b

9363

Forum Posts

1084

Wiki Points

0

Followers

Reviews: 0

User Lists: 6

Edited By Red12b
@Winternet said:

" I hope you're getting well paid, because you're doing the Lord's work. "

Never ask a man that, it's like asking a woman how old she is. 
 
1 gig?  
fuck... 
 
No wonder my monthly NZ gig allowance gets filled...
Avatar image for winternet
Winternet

8454

Forum Posts

2255

Wiki Points

0

Followers

Reviews: 0

User Lists: 6

Edited By Winternet

I hope you're getting well paid, because you're doing the Lord's work.

Avatar image for brackynews
Brackynews

4385

Forum Posts

27681

Wiki Points

0

Followers

Reviews: 5

User Lists: 48

Edited By Brackynews

Fascinating. Love these "how-we-dos" for inspiration and general curiosity.
Though, lost opportunity not calling it the Wonderful Universe...
WU-DaMn

Avatar image for moloney
moloney

56

Forum Posts

81

Wiki Points

0

Followers

Reviews: 1

User Lists: 1

Edited By moloney

Interesting read. Cheers.
Avatar image for gaff
Gaff

2768

Forum Posts

120

Wiki Points

0

Followers

Reviews: 0

User Lists: 2

Edited By Gaff

Hard questions must be asked: stacking all the drives on top of each other, which Whiskey Media staff measuring unit would we get?
A Chloe, an Ana, a Norm, a Brad or a Coonce?

Avatar image for gaff
Gaff

2768

Forum Posts

120

Wiki Points

0

Followers

Reviews: 0

User Lists: 2

Edited By Gaff

Hard questions must be asked: stacking all the drives on top of each other, which Whiskey Media staff measuring unit would we get?
A Chloe, an Ana, a Norm, a Brad or a Coonce?

Avatar image for video_game_king
Video_Game_King

36563

Forum Posts

59080

Wiki Points

0

Followers

Reviews: 54

User Lists: 14

Edited By Video_Game_King

Now that I have a rough idea of how you guys do videos, another question: any microphone recommendations?

Avatar image for countinhallways
countinhallways

633

Forum Posts

5

Wiki Points

0

Followers

Reviews: 0

User Lists: 0

Edited By countinhallways

Great post Drew. I have often found myself pondering these very subjects while browsing the site. Thanks.

Avatar image for killroycantkill
killroycantkill

1608

Forum Posts

7870

Wiki Points

0

Followers

Reviews: 9

User Lists: 13

Edited By killroycantkill

*Takes note and steals all information from this blog*

Avatar image for shreik
Shreik

28

Forum Posts

0

Wiki Points

0

Followers

Reviews: 0

User Lists: 0

Edited By Shreik

Nice post Drew! I'm a sucker for everything behind the scenes,

Avatar image for scooper
Scooper

7920

Forum Posts

1107

Wiki Points

0

Followers

Reviews: 0

User Lists: 2

Edited By Scooper

That was really interesting. It's insane how much space video takes up.

Avatar image for doctorchimp
Doctorchimp

4190

Forum Posts

0

Wiki Points

0

Followers

Reviews: 0

User Lists: 2

Edited By Doctorchimp

Oh my god, all this is giving me bad flashbacks of me sitting in high school with hard drives all around compiling and compressing high school footage...god damn it... 
 
All that final cut pro knowledge I thought I would have dumped 2 years ago is all coming back.

Avatar image for damswedon
damswedon

3246

Forum Posts

1809

Wiki Points

0

Followers

Reviews: 3

User Lists: 12

Edited By damswedon

I actually feel smarter now.

Avatar image for diabloku
DIABLOKU

68

Forum Posts

58

Wiki Points

0

Followers

Reviews: 0

User Lists: 2

Edited By DIABLOKU

nice post

Avatar image for ladyshayne
LadyShayne

157

Forum Posts

12

Wiki Points

0

Followers

Reviews: 0

User Lists: 4

Edited By LadyShayne

That was a genuinely interesting post. I appreciate the "How Giant Bomb Works" feature. It definitely puts everything you guys do into perspective.

Avatar image for cooljammer00
cooljammer00

3187

Forum Posts

17

Wiki Points

0

Followers

Reviews: 0

User Lists: 0

Edited By cooljammer00

I love busywork!  They should hire me.

Avatar image for zmilla
ZmillA

2519

Forum Posts

195

Wiki Points

0

Followers

Reviews: 0

User Lists: 4

Edited By ZmillA

I use google docs all the time

Avatar image for bluephoenixmedia
bluephoenixmedia

58

Forum Posts

306

Wiki Points

0

Followers

Reviews: 0

User Lists: 0

Edited By bluephoenixmedia

wow you guys are nuts to not use an online back up service....I've lost 2 500GB drives in the past because I was stupid and both contained years worth of video projects....I would immediately get a Carbonite account or something....damn....it's worth the investment trust me

Avatar image for russdog
russdog

71

Forum Posts

1107

Wiki Points

0

Followers

Reviews: 1

User Lists: 11

Edited By russdog

Thanks for the info...very interesting to see how you handle this & compare to my strategies as a fellow videographer (on a much smaller scale.)

Avatar image for mesoian
mesoian

1623

Forum Posts

523

Wiki Points

0

Followers

Reviews: 15

User Lists: 8

Edited By mesoian

Quote: 
"Final Cut Pro, the software we use to edit all our videos, has a feature called "Media Manager." Media Manager looks at all the clips you used in your project and copies only those sections of the original video file to a folder you designate. That means, if I have an hour-long gameplay video, but only use 15 seconds of it, Media Manager will only keep the 15 seconds, not the entire hour. This cuts down the project from a suicidal 100GB to a much more manageable 5-10GB. When Media Manager is done doing its thing, we copy the folder it makes to an external drive called "Trimmed Projects." The cool thing about trimmed projects is that they keep the Final Cut project files as well, allowing us to make small changes to the video after the fact if we find a typo or something. "
 
 
 
OH MY GOD! I Friggen hate Premiere's scratch disk system! I have MASSIVE files spread across 3 SATA external drives because I can't allow my primary HDD to get bogged down in work files. Media Manager sounds so much nicer...
 

Avatar image for evilrazer
evilrazer

550

Forum Posts

1979

Wiki Points

0

Followers

Reviews: 0

User Lists: 4

Edited By evilrazer

 Thank you, Drew, I was very curious about this and now I know the answer (:

Avatar image for mooseymcman
MooseyMcMan

12787

Forum Posts

5577

Wiki Points

0

Followers

Reviews: 0

User Lists: 13

Edited By MooseyMcMan

I'm not an expert on cloud stuff, but wouldn't a nuclear strike mess that up too?  
 
Great read though. Keep up the great work. 

Avatar image for crusader8463
crusader8463

14850

Forum Posts

4290

Wiki Points

0

Followers

Reviews: 7

User Lists: 5

Edited By crusader8463

tl:dr. Make it a video next time. Those things are easy to make anyway. =)

Avatar image for kickinthehead
kickinthehead

113

Forum Posts

611

Wiki Points

0

Followers

Reviews: 27

User Lists: 10

Edited By kickinthehead

Thanks for the informative post! Sounds similar but more organized than the last place that I worked at :P