Yup, Swat is definitely correct, especially about the compression and using the FAA1 files to recover data.
There isn't a database table with location info, because CMOD knows that all data is in one of two places: In the cache, or in TSM.
When someone tries to retrieve a document, CMOD looks inside the RETR directory in the cache to see if there's a link to the data object it's looking for. If there is no link, it goes to TSM to ask for the data. If CMOD *does* find a link, it uses the link to have the operating system open the file, and CMOD reads the contents, and sends it to the user.
I hope that helps!
-JD.