X

Testing Distributed Joins in Oracle TimesTen Scaleout

This article was created by Jason Feldhaus, Consulting Member of Technical Staff at Oracle. Oracle TimesTen Scaleout is a high performance distributed shared-nothing in-memory RDBMS. TimesTen Scaleout provides comprehensive SQL support for both OLTP and analytic workloads. This article describes how table rows are distributed across nodes in a TimesTen Scaleout grid and how distributed SQL join queries are tested to ensure correct results in a wide range of...

Wednesday, February 28, 2018 | Read More

Food, Drink, Raffle and In-Memory Database

Are you in London on Feb 7, 2018 and available for some food and drinks at 6:30pm?  Come and meet Chris Jenkins to learn more about Oracle's Next Generation Distributed Relational IMDB at the inaugural gathering of the London In-memory Computing Meetup!   Disclaimer: These are my thoughts, they don't represent Oracle's official point of view.  

Wednesday, January 24, 2018 | Read More

How do you develop apps for Oracle TimesTen Velocity Scale?

Summary Oracle TimesTen Velocity Scale is a scale out, shared nothing, OLTP, SQL RDBMS which is similar but different than the Oracle RDBMS. This article gives a brief overview of how to develop applications on Velocity Scale and makes comparisons with the Oracle RDBMS.   Short Answer The way that you design, build, test and deploy applications for Velocity Scale is almost exactly the same to how that you would do it for an Oracle database. For most OLTP applications, the...

Monday, November 6, 2017 | HowTo | Read More

Beer, wine and the fastest In-Memory RDBMS

Do you want more performance and scalability from your SQL RDBMS? Do you need simple high availability than spans data centers? Do you like beer, wine and food? Do you want to learn more about state of the art In-Memory RDBMS? Are you free on Tuesday, Nov 14th from 6:30 to 8:30pm? Can you get to Mountain View? Come to the Bay Area In-Memory Computing Meetup to learn about Oracle Velocity Scale and Apache Ignite. Disclaimer: these are my personal thoughts and do not represent Oracle's...

Friday, November 3, 2017 | General | Read More

See Oracle TimesTen Velocity Scale at Big Mountain Dev & Data Conference @UtahGeekEvents #UtahGeekEvents

Learn about Oracle TimesTen Velocity Scale, see the demos in the cloud and on premise, ask the hard questions. Salt Lake City, Nov 10th and 11th, https://www.utahgeekevents.com/ Learn about Velocity Scale, how to develop applications for Velocity Scale and just how fast that it goes. It is not to late to register for this conference. Disclaimer: these are my personal thoughts and do not represent Oracle's official viewpoint in any way, shape, or form.

Thursday, November 2, 2017 | TimesTen Talk | Read More

OLTP write scaling is hard

Summary As a follow up article to The evolution of of DB architectures in the quest for scalability, this article talks about the different techniques that can be used for massive read and write scaling for OLTP databases.  The traditional methods for write scaling all have serious down sides.  Two alternative techniques are discussed.  Ultimately how you choose to scale your database is as much a business decision as a technical one.  Just make sure you know all of the pros...

Tuesday, October 31, 2017 | Performance | Read More

The evolution of DB architectures in the quest for scalability

Summary This article looks at how database architectures have evolved over time to address ever increasing scalability challenges.  Only the major architectural changes are covered and usually only a few examples for each phase are covered so your favorite technology is likely missing. A taxonomy of DB architectures is provided and the question of what the next evolution will be is raised. The emphasis is on the 'commercially successful' systems and systems used by the author.  ...

Tuesday, October 24, 2017 | General | Read More

How to create heat maps using R for Oracle TimesTen Velocity Scale

This article was created by Jason Feldhaus, Consulting Member of Technical Staff at Oracle. In data science, the open source R language is popular for statistical analysis and graphics. The combination of R and the RStudio IDE creates a powerful and productive environment for analysis, visualization and reporting. Oracle created the ROracle package which is an open source SQL interface enabling optimized access to data in Oracle Database. As the ROracle package uses OCI drivers...

Tuesday, October 17, 2017 | HowTo | Read More

Testing TimesTen, the world's fastest OLTP database

The content of this blog was provided by Olaf van der Geest, Senior Director, TimesTen QA/Release Management at Oracle. Our team develops, executes and evaluates tests for TimesTen, the world's fastest OLTP database. Testing a relational database is hard. The surface area to test is very large and requires a wide range of expertise and different programming skills. Over the years we have developed a very robust and extensive set of tests and completely streamlined our...

Tuesday, October 10, 2017 | General | Read More

How fast is Oracle TimesTen Velocity Scale?

Oracle TimesTen Velocity Scale is based on a foundation of the TimesTen In-Memory Database. TimesTen has very low latency for SQL operations which are measured in microseconds.   It is hard to make apples-to-apples comparisons between databases as there are so many variables. When DB vendors benchmark each others products, there is always the suspicion that the competitors DB is not tuned optimally. The following is an example of an apples-to-apples DB benchmark: In August 2016,...

Wednesday, October 4, 2017 | Performance | Read More

How do you create the world's fastest OLTP DB?

Trying to manually shard an RDBMS or scale out a NoSQL DB is so last year. There is a better way. At Oracle, we used the following recipe to create the world's fastest OLTP DB: Use the lowest latency SQL RDBMS as a building block (TimesTen In-Memory Database) Use many instances of TimesTen in a scale out, shared nothing architecture Enhance the TimesTen SQL so that the applications see a single database image Enable high availability via K-Safety Use ACID transactions so that your...

Saturday, September 30, 2017 | Introduction | Read More

Back to the future, Sql vs Non SQL

There is a lot of discussion about the pros and cons of NoSQL databases and where and when you should use them versus using an RDBMS. This discussion sounds really familiar.  Before relational databases existed, there were several choices: Sequential files Indexed sequential files (ISAM and VSAM) The Hierarchical Database Model The Network Database Model (CODASYL) These choices provided various ways to create, read, update and delete records of information which were stored in...

Friday, September 29, 2017 | General | Read More

Do not manually shard your DB

While striving for maximum DB scalability, many people are tempted by the allures of DB sharding. While DB sharding may help scale out your DB system, there are some real dis-advantages of this approach: Instead of managing a single DB, you are now managing many independent databases Someone, usually the application developers, needs to design and develop [or re-write] their applications to use a sharded DB If your DB is relational, instead of being able to use SQL to do complex...

Thursday, September 28, 2017 | General | Read More

How awesome is your DB?

Asking which is the coolest DB is bit like asking which is the coolest car. Debating whether a Porsche 911 is better than a Honda Civic is meaningless unless you define the comparison criteria (eg top speed & cornering vs price and MPG). I am defining some criteria for DB comparison. Given these criteria, how awesome is your DB? Does your DB have high availability? Can your DB scale both reads and writes? Does your DB use schemas with PK and FKs? Does your DB use popular APIs like...

Thursday, September 28, 2017 | Performance | Read More

Is your DB too fast?

All DBAs, architects and developers. Ask yourself these questions: Is your DB too fast? Is the latency of your DB operations too low? Does your DB provide too much throughput? Is your DB more highly available than you need? Is your data more consistent than you need? Is your DB too easy to develop for? Is your DB too easy to install and manage? If True    Then do nothing. Put your feet up and chill. Even better, go to the beach :-) Else    Check out Oracle TimesTen Velocity Scale...

Tuesday, September 26, 2017 | Performance | Read More

Common Database Scaling Myths

For the last several years many people believed that you needed to abandon relational databases to produce highly scalable database systems.  The existence of various NoSQL, sharded, key-value or document databases that could scale seemed to be evidence of this theory. The good news is that Oracle TimesTen Velocity Scale In-Memory Database proves all of these myths to be false. Come to Oracle Open World 2017 to see how Velocity Scale busts these myths: Disclaimer: these are my...

Tuesday, September 26, 2017 | Performance | Read More

Need a faster, more scalable SQL DB?

Need an OLTP SQL DB that scale writes as well as reads? Need HA with ACID transactions and massive scalability? Want standard Oracle SQL and PLSQL with common analytic functions? Need a database solution that works both on premise and in your favorite clouds? Come to Oracle Open World 2017 to learn about the Oracle Velocity Scale. Oracle Velocity Scale is a scale out, shared nothing RDBMS powered by TimesTen In-Memory Database. Disclaimer: these are my personal thoughts and do not...

Thursday, September 21, 2017 | General | Read More

What is Oracle TimesTen Velocity Scale ?

Come to Oracle Open World 2017 to find out about Oracle TimesTen Velocity Scale. Velocity Scale is a new SQL, shared nothing, scale out, In-Memory RDBMS based on TimesTen. At Oracle Open World 2017, you can find out the important things about Velocity Scale like: How to scale out SQL writes How to scale out SQL reads How does High Availability and recovery work Which SQL and PLSQL features are supported How is data distributed across machines Which APIs does Velocity Scale support How...

Saturday, August 26, 2017 | General | Read More

TimesTen and Velocity Scale at Oracle Open World 2017

The catalog for OOW 2017 is now available. This is a great opportunity for you to learn about the new Oracle TimesTen product Velocity Scale. Velocity Scale is a Scale Out, Shared Nothing, In-Memory RDBMS that will be announced at Oracle Open World. There are three TimesTen presentations at OOW that will include Velocity Scale: Oracle's New, Scale Out, OLTP-Optimized, In-Memory RDBMS Monday, Oct 02, 11:00 a.m. - 11:45 a.m. | Moscone West - Room 3014 Accelerate OLTP Performance with...

Saturday, August 26, 2017 | General | Read More

Why are my TimesTen queries getting slower?

Help! My once fast data lookups are now going slower. As databases grow, if you are not careful, data access can take longer. This is very undesirable and can be avoided by understanding the issues and tuning your database accordingly. There can be several reasons for data access getting slower over time: Incorrectly sized hash pages Statistics not being updated Shared memory getting paged in/out We will cover each of these issues: Incorrectly Sized Hash index Pages Remember that...

Thursday, June 1, 2017 | General | Read More

What is the best TimesTen index for my OLTP application

Recently I needed to do some TimesTen OLTP performance tuning for a customer and they wanted to know whether they should use a hash index or a B+tree index for optimal query performance.  I said that it depends on your workloads, but that sometimes you can have the best of both! Range and hash indexes have different pros and cons: So range and hash indexes are good at different things.  Unlike some RDBMS, TimesTen can support multiple different indexes for the same column.   For...

Thursday, June 1, 2017 | Performance | Read More

How to use a TimesTen Active Standby Pair on Oracle Bare Metal Cloud

My blog about How do I create a simple TimesTen HA config in the Oracle Bare Metal Cloud, resulted in a TimesTen Active Standby Pair being created on two HighIO instances in the cloud. This blog uses that TimesTen Active Standby Pair to do some simple SQL operations. My active standby pair used the following IP addresses: To use this TimesTen Active Standby Pair I needed to use a bash shell (from Linux, MacOS or Cygwin): ssh to the 'active database' Bare Metal Compute machine as...

Tuesday, May 16, 2017 | HowTo | Read More

How to create a simple TimesTen HA config on Oracle Bare Metal Cloud

My blog How do I install TimesTen in the Oracle Bare Metal Cloud, resulted in the TimesTen In-Memory Database software being installed on a set of machines in the Cloud. This blog uses those TimesTen installations and covers how to create the simplest TimesTen high availability configuration, a TimesTen Active Standby Pair via the mkasp script: The mkasp script will create a database, populate it with data, create the active standby pair and replicate some data. Using the...

Monday, May 15, 2017 | Read More

How do I install TimesTen in the Oracle Bare Metal Cloud

Many customers have asked me how do I run TimesTen in the Cloud. This series of blogs shows you how to quickly and cheaply run TimesTen in the Oracle Bare Metal Cloud. The formula is simple: A single script installs and configures TimesTen on any of the available Bare Metal compute shapes. A white paper explains all of the steps in great detail. TimesTen will run on metered compute instances which are charged by the hour. TimesTen will use a "bring your own license model".   Downl...

Monday, May 15, 2017 | HowTo | Read More

How compatible is TimesTen In-Memory Database with the Oracle Database?

Customers often ask me how compatible is TimesTen In-Memory Database with the Oracle Database.  The answer, like most things is life is that it depends. If you are doing OLTP workloads using JDBC, OCI, ODP.NET, Pro*C or PLSQL with compatible data types then TimesTen is highly compatible.     plsqlJDBC.javaTptbm.java addemp.cplsqlOCI.ctptbmOCI.c DemoODP.cs addempPROC.pccursorPROC.pcplsqlPROC.pc case_procedures.sqlcursor_update_logic.sqlinner_loop_block.sqlselect_exception.sql The TimesT...

Sunday, May 7, 2017 | General | Read More

What is the best High Availability option for TimesTen?

Almost all TimesTen In-Memory Database customers use some form of high availability configuration as they want high performance RDBMS solutions without a single point of failure. Not all customers have the same sort of applications or availability requirements, so they have to choose which TimesTen replication configuration best suits them.   The following picture shows a subset of the possible replication configurations: There are two main types of Replication, Active Standby...

Saturday, May 6, 2017 | General | Read More

How does TimesTen give lower latency for OLTP when all of my data is in the Oracle SGA

The TimesTen In-Memory Database is optimized for low latency OLTP workloads.  A disk based database such as Oracle stores all of its data on disk and a subset of its data in the SGA. Oracle uses a buffer pool/cache to transfer data blocks to and from disk and the SGA as needed. Surely if all of the data is in a huge Oracle SGA so that no disk IOs are required, then Oracle would be as fast as TimesTen In-Memory Database? Even in this best case scenario when Oracle has cached...

Sunday, April 30, 2017 | General | Read More

What is the difference between Oracle In-Memory and Oracle TimesTen In-Memory Database

Many customers ask me whether Oracle In-Memory and Oracle TimesTen-In Memory Database as the same thing; they are not. Oracle In-Memory is a feature of the Oracle Database and is great for analytics (read mostly workloads) Oracle TimesTen In-memory Database (is a separate product from the Oracle Database) and is great for latency critical OLTP applications Tirthankar Lahiri and I did a presentation at OOW 2016 that neatly summarized the differences in a picture: So Oracle...

Sunday, April 30, 2017 | General | Read More

Oracle TimesTen and Oracle In-Memory leaders in Forrester Wave In-Memory Databases Q1 2017

In the The Forrester WaveTM: In-Memory Databases, Q1 2017 report, Oracle TimesTen In-Memory Database and Oracle In-Memory were rated the top In-Memory Databases: The report states: "Oracle offers Oracle TimesTen In-Memory Database and Oracle Database In-Memory products. With the combination of these two options, customers can deploy any type of application -- transactional, operational, and analytical." "Oracle customers building new transactional or analytical...

Sunday, April 30, 2017 | General | Read More

Is TimesTen an RDBMS or a Cache for Oracle 11g/12c?

A question that many customers have asked me is whether TimesTen is just a cache for their Oracle database or an (RDBMS) system of record. TimesTen can be configured to be either a read/write cache for Oracle databases, or act as a system of record. TimesTen as an RDBMS system of record TimesTen is a low latency In-Memory RDBMS which persists data to disk and supports ACID transactions. The checkpoint files and transaction logs persist the data to enable database recovery in...

Saturday, April 29, 2017 | General | Read More

Just how fast is TimesTen In-Memory Database?

The TimesTen In-Memory Database provides excellent performance on even commodity hardware. RDBMS performance has two important factors, latency and throughput. Latency is about how fast SQL Select, Insert, Update, Delete or Merge operations can be completed. TimesTen is known for enabling really low latency SQL transactions. We measure TimesTen latency in microseconds rather than milliseconds: This latency benchmark was run on commodity Linux / Intel hardware: 2 CPU sockets, 22...

Saturday, April 29, 2017 | HowTo | Read More

Back to Basics - Multiple Connections in ttIsql

A user recently asked if ttIsql can support multiple concurrent connections to a TimesTen database. We thought the answer might be of interest to other users as well, and decided to include it in this blog. ttIsql is an interactive SQL command line utility for working with TimesTen databases. In addition to supporting SQL command execution, ttIsql provides a rich set of functionality to enable the users to connect to the databases, execute built-inprocedures and utilities,...

Wednesday, April 29, 2015 | HowTo | Read More

New TimesTen Plug-in Release 12.1.0.3.0 for Oracle Enterprise Manager

Last Friday, Oracle released a new version 12.1.0.3 of TimesTen Plug-in for Oracle Enterprise Manager 12c Cloud Control. This is a landmark release with many new features for database administrators in the enterprise. Besides database performance and availability monitoring; the new plug-in offers administrators the ability to manage and administer their TimesTen instances and databases, such as starting and stopping TimesTen services, loading andunloading databases to and...

Wednesday, April 1, 2015 | General | Read More

Product News on SUSE 12 and HP-UX Itanium

Thursday – March 12, 2015 Recently, we added support for two new platforms with the latest release of Oracle TimesTen In-Memory Database: TimesTen 11.2.2.8.0 is certified for use with SUSE Linux Enterprise Server 12 (download the same binary for Linux X86-64 bit) TimesTen 11.2.2.8.1 is certified for the HP-UX Itanium platform (v11.31) The software is available for download from the Oracle Support site http://support.oracle.com

Friday, March 13, 2015 | General | Read More

Product News – TimesTen 11.2.2.8

In case you missed it, the latest TimesTen release, version 11.2.2.8.0, was released at the end of January for all supported platforms.  I want to call out a couple new features which provide significant performance improvement. 1.  Dramatic Increase in Parallel Replication Throughput For users who have OLTP application workloads running at very high transaction rates and are using TimesTen Replication for high availability, the new replication feature in this release willbe of...

Tuesday, February 24, 2015 | General | Read More

TimesTen client support for OS X 10.9 (Mavericks)

A new TimesTen 11.2.2 client for OS X Mavericks is available for download from OTN.   This client driver allows applications running on OS X to access TimesTen databases that reside on other supported operating systems.  Developers using applications such as SQL Developer may find this very valuable!  Download the new TimesTen 11.2.2 client for OS X today at: http://www.oracle.com/technetwork/database/database-technologies/timesten/downloads Also ... thanks to everyone who came...

Wednesday, October 8, 2014 | General | Read More

TimesTen at Oracle OpenWorld 2014

Coming to Oracle OpenWorld 2014 in San Francisco?  It's almost here! It's also a great opportunity to learn more about the Oracle TimesTen In-Memory Database.   We have some exciting presentations, and will be available in the DemoGrounds to answer your questions!   Check out the schedule below.  We hope to see you there!  TimesTen In-Memory Database Oracle OpenWorld 2014 Sessions The Oracle OpenWorld session schedule and locations may change. Please refer to the Content...

Friday, September 19, 2014 | General | Read More

Oracle TimesTen In-Memory Database release 11.2.2.6 is available for download

This release provides new capabilities that further improve performance and scalability for applications with extremely fast response time and very high throughput requirements, specifically for Online Transaction Processing (OLTP) workloads and Business Intelligence (BI) in-memory analytics workloads for the Oracle Exalytics In-Memory Machine. The release also contains bug fixes as detailed in the release notes. Feature highlights: Performance for In-Memory Analytics Significant...

Thursday, December 12, 2013 | General | Read More

Oracle TimesTen Software Update 11.2.2.5 Release Availability

Oracle TimesTen In-Memory Database release 11.2.2.5 is available for download. This release provides new capabilities that further improve performance and scalability for applications with extremely fast response time and very high throughput requirements, specifically for Online Transaction Processing (OLTP) workloads and Business Intelligence (BI) in-memory analytics workloads for Oracle Exalytics In-Memory Machine. Feature highlights for Business Intelligence...

Friday, September 27, 2013 | General | Read More

ROracle support for TimesTen In-Memory Database

Today's guest post comes from Jason Feldhaus, a Consulting Member of Technical Staff in the TimesTen Database organization at Oracle.  He shares with us a sample session using ROracle with the TimesTen In-Memory database.  Beginning in version 1.1-4, ROracle includes support for the Oracle Times Ten In-Memory Database, version 11.2.2. TimesTen is a relational database providing very fast and high throughput through its memory-centric architecture.  TimesTen is designed for low...

Friday, September 28, 2012 | General | Read More

Announcing Oracle TimesTen In-Memory Database 11g Release 2!

Big news!  The new major release of the Oracle TimesTen In-Memory Database is out!   TimesTen 11g Release 2 (aka TimesTen 11.2.2) is now available for download from oracle.com.   Since it first started shipping to customers 14 years ago, TimesTen has been used for performance-critical applications in real-time online transaction processing (OLTP) applications.  The newest release continues that tradition, providing significant scalability and throughput improvements that...

Thursday, January 12, 2012 | General | Read More

Developing Applications using TimesTen

As we've discussed before, the TimesTen In-Memory Database is a fully featured relational database.  Because of its in-memory architecture it provides very fast response time, while providing standard APIs and interfaces as any relational database would. Due to these standard interfaces developing applications that run at in-memory speeds is easy with TimesTen, and leverages skills that developers already have.   Concepts Like any relational database, data in TimesTen is stored...

Tuesday, December 20, 2011 | Introduction | Read More

TimesTen and In-Memory Database Cache

Several recent posts I’ve written so far are intended to help explain the basics of what the Oracle TimesTen In-Memory Database is. If you’ve been reading along, you know that TimesTen is a very fast relational database that provides standard interfaces like SQL, PL/SQL, JDBC, ODBC and OCI to access data. TimesTen provides this very fast access to data in large part due to its “in-memory” architecture. TimesTen, unlike most databases, stores all data in RAM. (A copy is also...

Monday, December 12, 2011 | Introduction | Read More

Direct And To The Point

In my previous post I explained how the TimesTen In-Memory Database is a very fast relational database. Like any relational database, TimesTen executes standard SQL via standard APIs Because of TimesTen’s “In-Memory” architecture, TimesTen can often use fewer CPU cycles than competing technologies to achieve the same result … yielding very fast response times. In addition to its use of RAM, TimesTen provides another feature which helps it to provide very fast performance. Relati...

Friday, December 9, 2011 | Introduction | Read More

What is TimesTen?

Since this blog is about the Oracle TimesTen In-Memory Database, let’s start by explaining what it is. The product documentation contains an introduction, and the Oracle Technology Network has several overview presentations that get into the details. But here’s another quick version. TimesTen is… A relational database Providing standard APIs and interfaces That runs very fast through its memory-centric architecture It can be used standalone Or in conjunction with anexisting Oracle...

Tuesday, December 6, 2011 | Introduction | Read More

Welcome to this new blog!

Hi, my name is Sam Drake; I am an Architect here at Oracle. I have worked for the past fifteen years on the Oracle TimesTen In-Memory Database. In this blog I’ll tell you a little bit about TimesTen … what it is, how it works, and how you can use it. I hope to post a variety of short articles here … some aimed at new users of TimesTen, others for long term users, and some for folks who are just curious about what it is. Thisblog won’t replace TimesTen’s formal product...

Tuesday, December 6, 2011 | Introduction | Read More