(#ubd4zpa) a large part of this comes from experience, dealing with databases, and SQL many times in the past, and then eventually coming to the realizing that everything is basically key value, stores, bloom filters, trees*, tries and various types of indexes and caches.