Solved

IMDBcache_produuct.

Posted on 2011-09-26
3
184 Views
Last Modified: 2012-05-12

Is anyone faimilar with IMDB (In memory database or times ten) cache?

I am trying to see why/when would you use this cache with oracle/mysql database or web applications if the database already had cache?

Would it work better than something like memcached for relational databases and why?
0
Comment
Question by:sam15
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 7

Accepted Solution

by:
Jacobfw earned 500 total points
ID: 36710323
I have not used Times Ten, it is actually a fully relational database that runs in memory.  There is impied speed improvement by doing this.

There are really two products here, the "Times Ten Database" and the "Times Ten Cache for Oracle".

The caching product doesn't not do cache as normal database cache but actually syncs the database into a Time Ten in memory database, processes the transactions in memory and then does sync back to your database.  The difference is having then entire database or part completely in memory (instead of caching only those high used items when they are needed).

Remember, cache normally needs to load upon first usage and can be driven back out of cache (although you can work around this).  With this product, you ensure constant in-memory allocation of needed resources from database startup through shutdown.

Some of the same speed can be accomplished by using Solid State disk drives.
0
 

Author Comment

by:sam15
ID: 36714266
Which product will compare to memcached?

The times ten database is an HPproduct orignally for database in RAM (no disk involved)l.

But i am thinking how the other cache will work with regular DB on disk. Because of the concurreny controls and database cache itself unless you only cache STATIC data. You can also pin objects in oracle cache so it is not pushed out if desired.
0
 
LVL 7

Expert Comment

by:Jacobfw
ID: 36716103
Neither compare to memcached which is a different type of product.  I have not used memcached but appears to require you to make code changes to your application.

Times Ten is an in-memory product, but remember that at some point the data must be stored to disk drives so that if the computer turns off, the data is not lost.

Oracle does let you pin for more control on cache and therefore "work around" the automatic caching algorithims.

However, knowing your applicaton and database is going to be critical to making a decision on which methods to utilize (alone or together) to find the best performance mix.  Clustering can also improve performance and provide redundancy (either web server cluster and/or database cluster)
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to write a Context Sensitive Help (an online help that is obtained from a specific point in state of software to provide help with that state) ,  first we need to make the file that contains all topics, which are given exclusive IDs. …
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
The viewer will learn how to count occurrences of each item in an array.

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question