Along with the move to a new Windows 11 desktop, I want to transition to a new image database program.
My images are on a NAS stored in a structure where the folder names have significance as to the contents, e.g. "\Location\YYYY + Event Name\Activity Name During Event" where any number of Activities could occur during the event. In general, I would want to find images associated with a specific activity. The majority of the images are related to motorsports.
Option 1. One could create a single catalog for the Location and use the rest of the file structure names (YYYY + Event Name, Activity Name During Event) as searchable keywords/other parameters. In this scenario,to find images of a specific activity, you would have to know what activities exist before you can search. This approach would yield the minimum number of catalogs.
Option 2. At the other end of the spectrum, one could create multiple catalogs with naming that includes the current file path information. In this scenario, the catalog name itself gets you down to the activity and you can immediately see all the images in that activity. However, his approach would create the maximum number of catalogs.
Option 1 would be my preferred approach but Option 2 seems more practical.
Option 1 could more usable if it's possible to find all the unique keywords/other parameters ala SQL SELECT DISTINCT ... . This would allow you to find out what activites were actually defined in the catalog. Is this possible?
What are the other options or methodologies I am overlooking, I'm certain there are many? TIA
Best Regards