In Qlikview, you can store a table in a .qvd file.
You can use an application (commonly called "DATA_name.qvw") who reads the database and store each table in qvd files. So, another application could proccess it, like creating linking tables and make corrections in string fields... And again, stores the new tables in another qvd files... Finally, the end user application only reads this qvd's...
I dont know how are you using Qlikview, but it is the best way to work. If you read the database each time for every application you have, you are losing one of the most better part of Qlikview!!
For example, I have a large database of customer details. I recreate this overnight into a QVD file (which is over 100MB itself) so that I can use it with my other QVW models, where it then loads supertfast.
It is 'internediate' because its between the raw database and the model itself.