Hello,
my image date consist of scans of slides, negatives and prints (linear scans and processed images), digital camera (non-raw) and smartphone images.
For a start I copy my images onto an internal hard disk with a directory structure named year/month for digital camera data, which only holds images. For scans I just use consecutive numbering (but see below).
All of these are in irregular intervals copied to 4 external hard disks with identical content using a free tool traybackup (unfortunately it is only in German), which does all I need ,e.g. copy only files that have changed.
For the scans I produce quick-look jpgs to select good images to work with and they are also used to document via the metadata the images using EXIFtool GUI and geosetter (when done I will copy the metadata to the originals).
I do not rely on a dedicated archiving tool (like Picasa) since you never know, how long it will be supported. I export the metadata with EXIFtoolGUI into text files and import these into an EXCEL spreadsheet with a VBA macro I have written. So I can select images via filtering (e.g. images of my father in France between August 1968 and December 1970) and display images from within EXCEL. The macro also allows to copy the selected images to e.g. another directory for distribution to friends and relatives. From EXCEL I always can fall back to pure text files, which should be supported forever.
Hermann-Josef