How to deal with a large database containing zipped files.
Your file system is already a database, one made specifically for storing files in a hierarchical structure just like the one you have here. So without knowing more about your use case, the proper way of handling them is exactly what you have already.

If the problem is that extracting all the zip files uses too much disk space, the obvious solution is to not extract them until you actually need them.