FWIW, my method is to do it all on first download of the card to the computer, using CS2 Bridge. Do your basic culling, then assign keywords, copyright, etc. in the metadata. You can create templates to ease this, apply them in batch. I number every image with a simple sequential number (some folk like YYYYMMDDnnnnn), preserving the original filename (there's an option to do this in Bridge). I then copy all RAW files to DNG and store them on an archive disk, and put all RAW files in another folder (I use a RAID 5 setup so don't copy to CD/DVD). From the RAWs I use Photoshop / Bridge's Image Processor to make small JPEGS for easy viewing. This way the RAW, DNG and JPEG carry identical metadata and identical file naming / numbering. I don't need to store by date as this is part of the metadata and can be searched. Most of this process is batch and automated - very little effort.
For later file manipulation / web / email / printing, I store the files in a separate area, still preserving the original filename and metadata, and I can always find the original from this.
Bridge (or Lightroom) are all you need once you work out a filing / archiving system that is meaningful to you. As said above, you need to make some effort here - I'd do it as soon as you download when it's less effort, and I'd make use of the embedded metadata.
Peter