This content has been marked as final. Show 5 replies
Generally Oracle Timesten IMDB is running without need the Oracle Database but
If you want to use the oracle timesten cache connect then you need to install the Oracle database separately in same box where you want to install TT
please refer the documentation
It doesn't really matter which you install first.
Just to be clear TimesTen is a standalone database in it' own right and can be used as the database of record. TimesTen doesn't need an Oracle database in order to operate.
You can however use TimesTen as an In-memory database cache in front of an Oracle database to accelerate data access. Typically you would not install TimesTen on the same server as the Oracle database. You would typically install TimesTen in the mid-tier where your application resides. The links provided above should get you started.
Our project which holds nearly 1 million records on peak and some 10k on non peak hours all these are at present kept in files and the process is going smoothly. We would like to go with an In-memory database which reduces the I/O cost since all the process are kept in memory it would be faster than the current one.
After records inserted into database (In-memory) we would like to replicate to a disk database (Oracle or MS SQL or MY SQL)
so i need to keep the records in memory and pass the rows to disk database
For this is Oracle TT will be a right choice?
Ok, yes Oracle TT could help you here.
You could use Oracle TT as a cache to insert your records which are currently in files then as changes/inserts are made to these records in Oracle TT they are propagated to a backend Oracle database. To do this you would use a AWT (Asynchronous Writethrough) Cache Group. An overview is here http://www.oracle.com/technetwork/products/timesten/overview/timesten-imdb-cache-101293.html
BTW: Please also remember that Oracle TT can be the database of record and has it's own local checkpoint files and logs file to persist data.