Another thing you can do is start recording all requests that cause changes to the system in an event store (a la event sourcing). Once you have this in place,

Another thing you can do is start recording all requests that cause changes to the system in an event store (a la event sourcing). Once you have this in place, you can use the event stream to project a new read model (e.g.a new, coherent, database structure).