TimesTen version 7.0

TimesTen version 7.0 was just released for TimesTen” home page. The product is available for Linux, Windows, Solaris, HP Tru64, HP-UX, HP-UX Itanium, and IBM AIX.

Oracle TimesTen In-Memory Database is a memory-resident relational database that empowers applications with the instant responsiveness and very high throughput required by today�s real-time enterprises and industries such as telecom, capital markets and defense. Deployed in the application tier as an embedded database, Oracle TimesTen In-Memory Database operates on databases that fit entirely in physical memory using standard SQL interfaces.

The biggest feature of the 7.0 release is easy-to-use caching. What this allows you to do is leverage your middleware tier and reduce latency to customer interaction. Instead of going back to the master database, you can hit the TimesTen cache copy of the master database. The driving trends helpign with adoption of this product is the demand for real-time enterprise analysis. SOA is requiring an increase in data and metadata access. Business intelligence is looking at data flows and metadata descriptors. Many of the batch analytics that were done during the night can be done during the day and not after hours. The key benefits are offloading the database hardware requirements, reducing data latency, and allowing for extension of the middleware analytics.

Some of the new features also includes support for upto a terabyte of memory to host data as well as international language support. All of the languages supported by the Oracle database are now supported by TimesTen. There are hardware vendors that allow for multi terabytes to be configured in memory; Sun, Fujitsu (1T), HP, IBM(2T), and SGI(128T).

The cache component allows for rows, columns, or tables to be pulled into the TimesTen cache and available to the application layer. If data is changed in the backend database, updates are pushed to the cache rather than invalidated. The caches should always contain the latest updates from the master repository. Alternatively, data that is active or soon to be active can be pulled into the cache based on who is logged into the web service. Instead of pulling a whole table into the cache, just the customer relevant data is pre-populated before the customer asks for the data. This mechanism is very good for supporting portals that don’t currently scale, product information, and shipping data based on a customer. A third mechanism that can be used is a sliding window. Users can define a sliding window that defines relevance. Instead of loading a whole table, only data changed since a given fixed date is pulled into the cache. For example, when a customer logs into their bank they typically only want to look at current ballances and transactions since the last statement. The login can pull the last 30 days transactions for this customer and get the in-memory database populated before the customer wants to start looking at the data. The different cache methods can be mixed and matched to support applications at the middle tier.

One thing that is interesting with TimesTen is that it allows for data replication from the master repository similar to what is done with RAC. It functions differently than RAC in that the querries are performed at the middle tier layer and not at the database. This is an alternate way of providing scalability without RAC or on top of RAC. 

TimesTen is a relational database cache for data shared via Oracle database. TimesTen allows you to pull this from the master reposiroty. This differs from Coherence which is a distributed data repository that shares data in a peer-to-peer grid. The data is not stored on a disk but is kept as an ad-hoc data grid that stays in memory on all of the nodes. 

As part of our library system design, I will look at how we can use TimesTen as an optimizer to speed up user requests. We will also look at locking requirements for the database and how this can be done at the TimesTen layer.


417 thoughts on “TimesTen version 7.0”

  1. Thanks so much for providing individuals with an extremely brilliant chance to read from this site. It’s usually so beneficial and also stuffed with a good time for me and my office mates to search your website at the least 3 times in a week to read through the newest items you have. And indeed, we are always fulfilled concerning the cool methods you give. Some two areas in this post are completely the very best we have all had.

  2. I simply had to appreciate you once more. I am not sure the things that I would have tried without these techniques discussed by you about such a situation. Completely was a traumatic crisis for me personally, however , taking a look at the very well-written tactic you treated the issue made me to jump for happiness. I am thankful for your guidance and in addition trust you realize what a great job you have been accomplishing training other individuals thru your blog post. I am sure you haven’t encountered any of us.

  3. I’m just commenting to let you understand what a great experience our princess developed visiting the blog. She came to understand a lot of issues, not to mention what it is like to possess an amazing coaching mindset to make a number of people quite simply understand a variety of impossible matters. You really did more than readers’ expected results. I appreciate you for showing those invaluable, dependable, informative as well as cool guidance on that topic to Jane.

  4. I just wanted to write down a simple remark to appreciate you for all of the unique tips and tricks you are showing at this website. My extensive internet research has at the end been honored with useful points to exchange with my neighbours. I would assert that many of us visitors are very endowed to exist in a decent place with so many wonderful individuals with very helpful advice. I feel somewhat grateful to have encountered the web page and look forward to many more excellent times reading here. Thank you once more for everything.

  5. I definitely wanted to write down a brief remark to say thanks to you for these unique recommendations you are posting at this website. My extensive internet investigation has now been recognized with useful insight to write about with my company. I would assert that most of us visitors actually are truly fortunate to be in a decent website with very many brilliant individuals with useful tactics. I feel extremely grateful to have come across your website and look forward to tons of more excellent moments reading here. Thanks a lot again for a lot of things.

  6. Thanks a lot for giving everyone remarkably brilliant chance to check tips from here. It’s always so pleasant and as well , stuffed with fun for me and my office acquaintances to search the blog at the least 3 times in a week to learn the fresh things you have got. Not to mention, I am also at all times satisfied considering the superb information served by you. Selected 1 tips in this posting are in truth the most suitable we’ve had.

  7. I not to mention my friends came reviewing the excellent tactics found on your web blog and the sudden I had a horrible feeling I had not thanked the website owner for those techniques. These young men became as a consequence very interested to learn them and already have in fact been taking advantage of them. Appreciation for genuinely indeed considerate as well as for making a decision on this form of magnificent areas most people are really eager to be informed on. My very own sincere apologies for not expressing appreciation to sooner.

Leave a Reply

Your email address will not be published. Required fields are marked *