Mark,

I have used Lightroom since the beta version before 1.0, so I have developed my own storage system that I am very happy with.

The first thing I do upon importing is have the program rename the file by adding the date to the filename. The reason for this is that the Canon cameras I have reuse filenames after 9,999 so I will shoot more than 10,000 pictures but never on the same day! I import them into a folder system that is organized by location and then date, so for example:

USA - California - March ARB - 2009 - 2009-01-01

This is all done by importing with presets, you can also add keywords at this stage, so I add all my location keywords to the photos at this stage, i.e. all these imported photos would have March ARB added as a keyword during import and the date directory is automatically made.

Once imported I then add keywords to the photos. Now please bear in mind that I am probably an extreme case wih the details I keep but maybe not.

So the key here is a layered system of keywords. For example I have a keyword of Boeing that then contains keywords such as "KC-135 Stratotanker" and "C-17 Globemaster III". Because these keywords are nested I only have to add the lowest level I want and Lightroom knows that the parent keyword of "Boeing" also applies to that photo. I do the same for units and serial numbers, for example, USAF - 452nd AMW - 05-5145 or US Navy - VFA11 - Modex - Buno.

You can then search for keywords to find the photos you want.

I use Collections to group photos that have a common end use, so I have a collection called AirFighters with all my pictures that have been accepted here, one call Anet for all my pictures there etc.

I also use Smart Collections for common photos I need, an example of that woudl be my C-17 smart collection, which looks through my photos for any that are keyworded C-17 and also have a 5 star rating. This smart collection is updated on the fly so as I rank a new C-17 shot with 5 stars it is automatically added to the collection. A normal collection has to have photos manually added to it.

The database in lightroom is very good and quite flexible, you can narrow your searches down by lens used, camera serial number etc. (these are automatically added to each shot upon import) But like all databases the more information you add to it the more powerful it becomes.

The only other thing to note is that I have two catalogues, one for my aviation photos and one for the rest of my stuff. With more and more companies developing plug-ins for Lightroom many photographers no longer use photoshop to the same degree they used to.

I hope this long winded reply helps in some way,
Nathan

PS. To answer your last question, will this be viable in 10,20 or 30 years. Yes so long as adobe keep updating the kinds of RAW files Lightroom can read, of course new products will be released but I think the essence of the program is great.