In-Memory Database
Can TimesTen In-Memory database be used as a standalone database?
Yes, the TimesTen IMDB is used by many customers today as a standalone database at the application tier. TimesTen IMDB provides full transactional support for SQL operations and the transaction logs are persisted to disk for recovery (the data is in memory).
Top of Page
What are the data access APIs to the TimesTen In-Memory database?
The TimesTen In-Memory database supports standard ODBC and JDBC interfaces for applications to connect to the database, using SQL-92 standards.
Top of Page
Are the interfaces provided by TimesTen different for 32-bit and 64-bit applications?
No, the application interfaces are the same for both 32-bit and 64-bit applications. In order to take advantage of the 64-bit mode, the application will need to be recompiled and linked to the TimesTen 64-bit library.
Top of Page
What languages can be used to develop Oracle TimesTen applications?
Applications can be developed using C, C++, and Java.
Top of Page
What do you mean by embedded mode?
The Oracle TimesTen In-Memory Database was designed and optimized to run in the application tier. The data store can be directly linked (embedded) with the applicaqtion for best performance. With the database embedded with the application, SQL access does not incur any network or IPC overhead.
Top of Page
Does the IMDB support indexes like conventional RDBMS?
Yes, TimesTen supports indexes. Indexes improve the performance of queries to the database, just as they do in a RDBMS. TimesTen supports two types of indexes: Hash indexes, which are automatically created on the primary key of the table, and T-Tree indexes, which are created with the CREATE INDEX statement. T-Tree indexes are optimized for memory and provide superior performance to the B-Tree indexes provided in disk-optimized RDBMSs..
Top of Page
How are data structures designed and created in the TimesTen IMDB?
TimesTen supports the SQL standard. To create data structures, use the SQL statements CREATE TABLE, CREATE INDEX, and ALTER TABLE. The same database design techniques that are used for RDBMS can also be used for TimesTen. Designing and managing databases in TimesTen is simpler than in a disk-optimized RDBMS, as there is no need to size table extents or to de-fragment disks.
Top of Page
How does the TimesTen product recover from node/power failure, since it is an IMDB?
While the entire database resides in memory, the transaction logs and checkpoint files are saved on disk. In the event of a system restart or failure, the IMDB is recovered from the checkpoint files and transaction logs. In addition, customers can purchase the Replication product option to provide transactional replication to another TimesTen node.
Top of Page
Replication
What is TimesTen Replication?
TimesTen Replication is an optional product that is separately licensed. The TimesTen Replication product enables real-time data replication between TimesTen server nodes. Replication supports simple active/standby or actice/active configuration, using asynchronous or synchronous data transmission. Refer to the TimesTen Replication data sheet for more information.
Top of Page
How does TimesTen Replication product ensure continuous availability in the event of system failures?
TimesTen Replicaiton can be configured to replicate the entire TimesTen data store to one or more TimesTen nodes. After a failover, where the standby node becomes the active node, the failed node can be recovered from the standby (now active) data store.
Top of Page
Can I replicate selected tables in the database?
Yes, table-level replication and data-store level replication are both supported.
Top of Page
What network protocol is supported by the TimesTen Replication product?
TimesTen Replication uses TCP-IP peer-to-peer connections between the replicated nodes. The protocol is our own replication protocol.
Top of Page
Is Replication bi-directional?
Yes, unidirectional and bi-directional replication are supported. For bi-directional replication, it's recommended that the workload be partitioned to avoid high-number of conflicts. In the event of conflicts where updates are made to the same database rows, TimesTen Replication supports timestamp-based conflict detection and resolution.
Top of Page
Cache Connect to Oracle
What is Cache Connect to Oracle?
Cache Connect to Oracle (Cache Connect) is an optional product that is separately licensed. Cache Connect allows the users to create a real-time updatable cache for Oracle data, resides in the application-tier. Cache Connect loads a subset of user-configured Oracle data into TimesTen, propagates updates in both directions to keep the data in the cache synchronized with the Oracle database.
Top of Page
What are the Oracle database releases supported by Cache Connect to Oracle?
Cache Connect to Oracle release 5.1.x supports Oracle Database 8i and 9i, and Cache Connect to Oracle release 6.0 supports Oracle Database 9i Release 2 and Oracle Database 10g.
Top of Page
What are the platforms supported by Cache Connect?
Cache Connect runs as a client application to Oracle database server. The supported platforms include AIX, HP Tru64, HP-UX, Linux, Solaris, and Windows.
Top of Page
Can I run Cache Connect on a different platform from the Oracle database server?
Yes, since Cache Connect runs as an Oracle client, it can be running on a different platform from that of the Oracle database server.
Top of Page
.
|
Bookmark
