Remember that while your folder filing systems will be the same for whatever software you use, albums and collections exist only within that specific application. You get more organisational capabilities but only by committing to a single software solution.
Collection
Lightroom‘s name for Albums, its ‘virtual’ image containers. Some programs call them ‘albums’, but the terms ‘album’ and ‘collection’ are generally interchangeable. You use Collections to bring together related images with actually changing their location on your hard disk.
DxO PhotoLab vs Lightroom Classic – using PhotoLab for cataloguing
That’s an interesting question. PhotoLab 6 offers better RAW processing and noise reduction than Lightroom and more extensive local adjustment tools, but with the improvements to the PhotoLibrary in PhotoLab 6, can it also do the same job as an image cataloguing tool?
Cataloguing software explained
Cataloguing software can organize your entire photo collection, but how does it work and what do you look for?