SLIDE 1
Intro to Oracle TimesTen
- -- By Sima Zhu
Topics
- Why in-memory?
- Basic Architecture
- TimesTen replication
- Transactional durability
- Advantages of TimesTen
Intro to Oracle TimesTen --- By Sima Zhu Why in-memory? Basic - - PowerPoint PPT Presentation
Intro to Oracle TimesTen --- By Sima Zhu Why in-memory? Basic - - PowerPoint PPT Presentation
Intro to Oracle TimesTen --- By Sima Zhu Why in-memory? Basic Architecture TimesTen replication Transactional durability Advantages of TimesTen Topics System with GigaBytes, TeraBytes becomes common Avoid frequently
SLIDE 2
SLIDE 3
Why in-memory?
- System with GigaBytes, TeraBytes becomes common
- Avoid frequently touching disk IO
SLIDE 4
Bas Basic ic Arc Archit hitec ecture ure
Picture from http://avdeo.com/2008/11/03/installing-timesten-inmemory-database/
SLIDE 5
Bas Basic ic Arc Archit hitec ecture ure
SLIDE 6
Storage Manager Design
- Row format v.s. column format
- Columnar compression
- Index reduction
SLIDE 7
Storage Manager Design
Picture from: http://arxtecture.com/column_vs_row/
SLIDE 8
Storage Manager Design
- Columnar compression
- Space-saving mechanism
- Improve query processing
SLIDE 9
Storage Manager Design
Picture from: http://www.oracle.com/us/corporate/events/dbim/index.html
Index Reduction
SLIDE 10
Time mesTen Repl plication
SLIDE 11
Time mesTen Repl plication
- High availability
- Log-based
- 2-safe replication
- Replication tracks
SLIDE 12
Transactional durability
- Multi-threaded Logging mechanism
- Checkpoint files
- Read-committed isolation
SLIDE 13
Advantages
- Full-feature SQL
- Standard API
- ACID properties
- High-availability mechanisms
SLIDE 14