Timelapse File handling and workflow - advise needed!

i there,

I've started to get into timelapse for several art projects. I shot timelapses with my A7II and my 5D Mark IV. No there is a big question for me regarding file handling / archiving and workflow: Obviously having the RAW files and archive those seems like not too pragmatic, since they use a LOT of space. So I need a solution.

The way I handle it currently

I transfer the RAW files to DNG --> then I use the app Slim RAW to convert the DNG files to 1:4 compressed DNG files.

Pro: I get 1/4 smaller files with having still a benefit of RAW to some degree
Con: Only accessible in Davinci Resolve, quality decrease (?)

Are there other ways / General questions

- how do you story (and archive) timelapse files?
- if i transcode from .CR2 (canon RAW) to DNG to 1:3 or 1:4 DNG...do I really end up with a RAW-alike file with no big quality loss?
- before I transcode to DNG, should I pre-edit the pure RAW file (e.g. Highlight recovery)?

Would appreciate some input here. Since I use the timelapses for different projects (sometimes I don't use the material for a couple of years), I need an option that both saves space though is still is great for color correction.

Thanks & Cheers

anybody?

I would be interested as well by such solution!
I am working with an Olympus 10 D Mark III.
Note that DaVinci Resolve doesn't seem to recognise ORF files.