At the moment we have repositories for Business Objects and Informatica in the same database as our data warehouse. This has long struck me as a suboptimal architecture, as rapid application interface response can be seriously harmed by the simultaneous execution of reporting or ETL queries. Isolating the two types of database access in some way seems like a beneficial move for application usability.
So given that TimesTen allows in-memory caching of a subset of Oracle database tables, I’m now wondering how practical it would be to cache a subset of the repositories, and also to cache a subset of the data warehouse dimension tables to allow more rapid retrieval of lists of values (either for display through the Web Intelligence interface or for use by the ETL process). Much depends on how transparant the technology is to the client. I do not think that it would be a trivial matter to re-point the List Of Values queries to a different DSN, although with Informatica’s lookups it could be done pretty easily.
Hmmm. Well, since the software is available for download I’ll have a play around with the software and see how it looks.