X

TimesTen In-Memory Database
for Extreme Performance

  • October 14, 2018

Persistent Memory + In-Memory Databases = Database Nirvana

Doug Hood
Evangelist for Oracle TimesTen, Oracle In-Memory and Oracle NoSQL

In-Memory Databases are great (Oracle TimesTen In-Memory Database is the Worlds Fastest OLTP Database), but they still need to persist their data and transactions to storage systems. The latency and bandwidth of storage systems is important for In-Memory Databases.

Storage systems keep getting faster [spinning disks, Flash, SSD, NVMe storage], but they are still a lot slower than memory [DRAM].

New data hierarchy

New technologies like Intel® Optane™ DC Persistent Memory blur the distinction between memory and storage:

  • This persistent memory is byte addressable
  • The contents of the persistent memory exist after you reboot your server hardware
  • The density of the persistent is memory is greater than that of DRAM [eg planned memory sticks for 128GB, 256GB and 512GB]
  • The persistent memory will be more affordable at high capacities
  • The persistent memory has different characteristics than DRAM. Intel and Oracle have worked to optimize the best solutions for Oracle customers.

Intel Optance DC Persistent Memory

In-Memory Databases that are designed to use persistent memory can benefit from:

  • Instant database loads and re-loads for multi terabyte databases
    • A database load is when the contents of the database is read from storage into memory
    • The larger the database, the longer that this takes. The bandwidth [MB/Sec] of the storage determines how long this takes
    • When persistent memory is used, the database load from storage to memory is no longer required!
  • Transaction Durability
    • When persistent storage is used with synchronous writes, the SQL transactions must wait for the storage device to complete the write
    • Writes to persistent memory are significantly faster than synchronous writes to spinning disks, flash, SSD or even NVMe storage

 

Come to Oracle Open World 2018 to learn about this amazing new technology and see demos of a PROTOTYPE of Oracle TimesTen In-Memory Database using multiple TeraBytes of Intel® Optane™ DC Persistent Memory:

Next Gen Cloud Technologies that will Accelerate Business Transformation

        Session ID: ESS6915
        Time: Tuesday, Oct 23, 12:30 - 13:15
        Location: Yerba Buena Center for the Arts
        Presentation Style: Live Demo by Intel and Oracle

Oracle TimesTen Scaleout: A Cloud-Scale In-Memory Database for OLTP

        Session ID: PRO4003
        Time: Monday, Oct 22, 10:30 a.m. - 11:15 a.m.
        Location: Moscone West - Room 3003
        Presentation Style: Slides by Oracle

Oracle TimesTen Scaleout: Developing Applications for OLTP and IoT

        Session ID: PRO4017
        Time: Wednesday, Oct 24, 11:15 a.m. - 12:00 p.m.
        Location: Moscone West - Room 3001
        Presentation Style: Slides by Oracle

Oracle TimesTen Demo Booth

        Location: Booth 1611 in the demo grounds

OOW 2018

Disclaimer: These are my personal thoughts and do not represent Oracle's official viewpoint in any way, shape, or form.

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.