X

Database Storage Optimization best practices, tips and tricks and guidance from Database Compression Product Management

  • January 22, 2019

Utilizing the Oracle Database Technologies that Best Benefit Your Data Usage

Gregg Christman
Product Manager

Last month I hoped to be able to announce (this month) a new Oracle White paper that discusses utilizing the Oracle Technologies that best benefit your organizations data usage (OLTP, Reporting, Analytics, Archive and/or Storage Tiering). I am pleased to announce that this new white paper is now available.

See the new white paper here.

This new white paper discusses how the various technologies that enable Oracle to deliver a robust Enterprise Data Architecture, benefit organizations in the areas of performance, storage management, data lifecycle automation, data transfer, compliance/versioning and more. The document follows data, from when it is initially loaded into the database, through the entire lifecycle of the data, to ensure organizations are aware of what Oracle technologies exist to benefit and optimize their data usage as their data moves from hot (OLTP) to cold (archive/historic) usage.

The areas of data usage, and related Oracle technologies, include:

OLTP
Heat Map
ADO Compression Tiering
Advanced Row, Index and LOB Compression
ANALYTICS+REPORTING
Database In-Memory (analytics and reporting)
HCC Warehouse Compression
ARCHIVE
HCC Archive Compression
STORAGE TIERING
ADO Storage Tiering

Major performance related technologies discussed in this document, like Oracle Database In-Memory for high speed, real-time analytics, and Oracle Advanced Compression for sophisticated database compression, can significantly improve performance and reduce I/O and storage footprints.

The Enterprise Data Architecture provides organizations the flexibility to leverage Oracle Database's sophisticated scale out and engineered systems to expand their compute footprint as their computing needs grow and change over time.

Also, if you are attending the Italian Oracle User Group Tech Day Roma (#ITOUGTD19) this month, the  Rocky Mountain User Group Training Days (#TD2019) in February, or the Oracle User Group Norway Spring Conference (#OUGN18) in March, please stop by my compression and/or Flashback Data Archive sessions.

The database storage optimization adventure continues.

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.