Stop using Integer ID’s in your Database
A common workaround is to de-normalize the database so that queries that previously require joins can be performed on a single table.
Alex • System Design Interview - An insider's guide
Unfortunately, every single diagram I was using to determine strategy in business lacked one or more of those basic elements.
Simon Wardley • Highlights From medium.com
Second, those building reports must make sure the mechanisms that generate the reports are not too complex. Whenever possible, reports should be drawn directly from the master data, rather than from an intermediate system, which reduces opportunities for error.