With the denormalization, we must create the table and logic, and then we can create a new endpoint that fetches the tree listing data from this new table. Later on we can replace the current tree listing endpoints with the new one.

• Create new table for TreeListing
• Create new view to gather data from that table
• Alter ingester to insert the latest tree data (checkout) on that table
• Alter ingester to update TreeListing table with build counts
• Alter ingester to update TreeListing table with test counts
• Add an ExpectedCheckouts SQLite/map to store build/boot/test countings for builds and tests that arrived before to a checkout
• Add an ExpectedBuilds SQLite/map to store boot/test countings for tests that arrived before to a build
• Integrate ExpectedCheckouts table onto ingester
• Integrate ExpectedBuilds table onto ingester