An algorithm to optimize database queries that run multiple times https://pubkey.github.io/event-reduce/ - View it on GitHub