Compression & Archiving
Oracle Database Compression & Archiving
With the increased prominence of data, every company is looking to store, manage, and utilize maximum data with minimum overhead.
Even though the cost of storage is decreasing every year, the increased data volume makes storage one of the biggest cost elements of IT Budgets. In addition, as your databases grow at accelerating rates, we know that it is difficult to meet performance requirements while staying within budget.
To improve performance speed and reduce storage cost, physical storage is minimized by using two techniques to reorganize the database. Implementation of these techniques is called Database Compression and Archiving.
Database Archiving is the practice of identifying data that is no longer active and moving it out of production systems into long-term storage systems.
Depending on the data cardinality compression can reduce storage consumption from 60% to as low as 20% of the original space.
With Data Compression, basic read operations can be speed up to 10x.
More data will fit into a page in the disk, in memory, or in the buffer pool, thereby minimizing I/O costs.
Archived data is typically stored on low performance, high capacity media with lower associated maintenance and operation costs.
Archiving removes data from backups, reducing their size and eliminating restoration of unnecessary files.
Built-in policies ensure records are kept for an appropriate amount of time and indexing makes data more retrievable.
How Do We Do It?
We use Advanced Compression to conduct Oracle Database Compression. It is an algorithm that eliminates duplicate values within a database block, even across columns.
Verify if the table can be redefined online.
Create an interim table.
Copy dependent objects.
Synchronise interim table.
Complete the redefinition.
Drop the interim table.
Compress the indexes on the table.
Immediate focused attention to all high priority issues
Continual seamless operation of ERP System
On top of changes like regulations and market trends