My physical storage is just printfile sleeves in a binder with a numbered index tab for each sheet. Black and white and slide film go into the same binder in the order I put them in, so things get somewhat out of order as the slide film goes to the lab every few months while B&W is done shortly after I shoot it. I just number my rolls 2012-XXX so 2012-025 is my 25th roll this year.
I scan all my film and import it into Lightroom which is where I keyword it all. My digital library is a disaster but I keep my film scans in their own library and have managed to keep up on the keywording. I also create collections for my different projects so I can keep track of them.