Introduction to Oralce memory database TimesTen

Welcome to the Oracle community forum and interact with 2 million technical staff. Introduction to memory database: applications of memory databases are available in multiple projects of the Institute, however, the memory database used by the Institute has multiple versions, and there is no uniform version. FastDb is currently the mainstream. The following problems are common: the access method does not comply with the SQL92 specification and does not support customer service.

Welcome to the Oracle community forum and interact with 2 million technical staff> introduction to memory databases: applications of memory databases are available in multiple projects of the Institute, however, the memory database used by the Institute has multiple versions, and there is no uniform version. FastDb is currently the mainstream. The following problems are common: the access method does not comply with the SQL92 specification and does not support customer service.

Welcome to the Oracle community forum and interact with 2 million technical staff> enter

Memory Database Introduction

There are applications of memory databases in multiple projects of the Institute, but there are multiple versions of memory databases applied by the Institute, and there is no uniform version. FastDb is currently the mainstream. The following problems are common: the access method does not comply with the SQL92 specification, the client server mode is not supported, there is no complete API, the reliability is not high, and data interoperability with databases is difficult.

Recently, I spoke with Oracle technical engineers about TimesTen, Oracle10G, and Oracle9i. During the communication, Oracle engineers gave a detailed description of Oracle's memory database TimesTen. Therefore, during the communication with Oracle technical engineers, they paid special attention to TimesTen according to the requirements of the Institute.

ORACLE and Times Ten announced in Shanghai on September 18 that the two sides had formally reached a final agreement on ORACLE's acquisition of Times Ten. Times Ten is a private supplier of real-time data management software. It mainly provides infrastructure software for telecommunications, networking, securities trading, and other industries, use this software to manage events, transactions, and data. Its global customers include Amdocs, asbeck, Ericsson, JPMorgan, NEC, Nokia, sprint, and American Airlines. The company currently supports real-time billing systems, stock trading systems, call center systems, and route operation systems. ORACLE's acquisition of Times Ten marks Oracle's entry into the memory database field.

Introduction

Official definition of Times Ten: TimesTen? /Cache (Cache) is a real-time dynamic data caching system. it uses des TimesTen's in-memory database and data exchange technologies. together, they enable applications to combine the real-time performance of TimesTen with the large storage capacity of an RDBMS.

Times Ten features:

Independent Memory Database Service compliant with RDBMS standards

Support SQL92

Support for ODBC & JDBC

High Performance

It can be used as the front-end Cache of the Oracle database. Currently, it does not support other databases.

Supports local high-speed access and network access

High reliability. Supports full logs and image copy.

It is not open source code and requires a high cost.

Currently, stored procedures and triggers are not supported.

Times TenAndOracleDatabase comparison

System features	Oracle	TimesTen
Architecture	Disk-centric	Memory-centric
Driver Mode	Human-Computer Interaction	Computer to computer
Implementation Method	Separate Server	Embedded applications
Response Speed	Millisecond level	Microseconds to milliseconds
Data capacity	DozensTG	DozensG
Management	DBAAnd system management	Special management is not required

3. Times Ten Architecture

Concurrency management:

Supports multi-threaded access.

Supports different transaction isolation levels: Read committed Serializable

Supports different levels of lock control: database-level, table-level, row-level

Support: used to protect internal data structures

Automatic Deadlock Detection and Removal

Complete transaction control mechanisms, including commit/rollback

Data Consistency: databases always maintain data consistency, and can restore consistency based on disks (logs, etc.) when power loss occurs.

Reliability: ensure reliability through log and Checkpoint file

Logs:

Supports automatic checkpoints

Manual force checkpoint supported

Supports the complete log mechanism.

Supports writing logs to hard disks and memory, and does not write logs to improve efficiency.

Image copy:

Flexible configuration: supports multiple forms

Fast and reliable: it is based on logs instead of data replication.

Supports synchronous or asynchronous mode

Supports auto recovery between images

In case of failure, application access is automatically switched to standby quickly and securely.

Oracle database cache:

Table conformity model in TimesTen Cache

Cache provides read-only, automatic refresh of database data, automatic flushing of database, manual flushing of database and other data synchronization mechanisms.

SQL statement transfer function: for access to tables not in the memory database, timesten is transferred to the database for execution.

SQL Development

Functions supporting SQL92

Cost-based Query Optimization Mechanism

Comprehensive Indexing Methods

Supports non-transactional processing.

Support for ODBC2.5 JDBC3.0

Supports c and c ++ Libraries

Supports command interaction ttlsql

Event triggers can partially replace triggers.

Security Control

Allows you to enable or disable Secure Access Control.

Seven types of access permission control: Instance Administrator, Connect, CreateDatastore, Select, Write, DDL, and Admin

Supports SQL GRANT/REVOKE authorization

Performance

Below isTimestenPerformance Test Data

Application Cases

Is a pre-paid (Real-Time billing) case.TimestenIt is used for real-time billing and billing, and image (copy) technology is used to ensure reliability.