Oracle Times Ten In Memory Database and OBIEE
Oracle Times Ten In-Memory Database(TimesTen) is a memory-optimized raltional database with persistence. TimesTen stores all its data in memory optimized data structures and supports query alogrithms designed for in-memory processing. With SQL programming interfaces, TimesTen provides real-time data managment that delivers fast response times, and very high throughput for a variety of workloads.
I belive Times Ten in–Memory Database (IMDB) , Oracle In-Memory Database Cache option for oracle database and OBIEE combination opens various possibilities around In-Memory reporting which would be beneficial for real time reporting, near to real time reporting , enterprise reporting (In-Memory Adaptive Data Mart) and implementing intelligent caching for OBIEE.
This blog is an attempt to list down the steps for Times Ten installation followed by verfication of install components on Windows operating system.
Steps to install the Times Ten are as follows
1. Download the software from OTN
2. Extract contents from the downloaded zip file, which contains the Times Ten 11.2.2 software
Extract zip file - timesten112220.win64.zip e.g folder d:/timesten
3. Run the setup.exe file with administrator privileges
4. Follow the instructions on the installer
Select installation folder
270 MB – Memory space is required to install the software
Choose Demo Data Store Location
Choose TNS_ADMIN LOCATION. To use the In-Memory Database Cache, a TNS_ADMIN variable must be set. It can be left blank. A value can be set later using ttModInstall
Chosen the network/admin
Select Program Folder
TimesTen Configuration Options
Select Java Version to add the CLASSPATH
5. Verify that the drivers are installed and that the service is running
To confirm that installation has been successful, check whether the Times Ten drivers are available and service is running.
Open ODBC Data Source Administrator and check to see if both the Times Ten Data Manager 11.2.2 and Times Ten Client Driver 11.2.2 are installed
Check whether the Times Ten Manager 11.2.2 service is running.
Use command line utilities ttversion and ttstatus to verify the software has been installed
Execute ttenv.bat script located at d:\TimesTen\tt1122_64\bin to set the environmental variables