How can I optimize the storage and retrieval of buildable component combinations in a large database?

I have a large database of components that are grouped by series.