By Meghan Fritz-Oracle on Apr 21, 2014
If you're a hammer, everything looks like a nail.
Now let’s apply this tenet to big data. Data growth is a primary driver of application issues and proves to be a pressing challenge faced by organizations. A logical conclusion might be that adding more disk space can solve the problem; however this method often proves costly and inefficient.
Several Oracle approaches to easing the influx of data:
- Leverage the features of Oracle Database such as Automatic Data Optimization with Heat Map technology as well as Advanced Compression option to compress and tier data at a higher density and maximize resource efficiency. In particular, Hybrid Columnar Compression (HCC) can compress data 10X-50X, reducing storage capacity, footprint, and TCO.
- Boost performance by taking advantage of unique Oracle Database features, such as HCC, available only to Oracle storage systems, including the Oracle ZFS Storage Appliance ZS3 Series;
- Move your systems to Oracle Exadata Database Machine to free up space in existing storage environments for general storage use; see our January blog post on HCC to compress data in the Exadata environment;
- Address non-database data with tiered storage; more on this topic in Part 2.
So for now – put away the hammer – remember that adding more storage capacity isn’t the only solution to combat the rapid influx of data into your systems. We believe the priority should be on looking at storage issues from Oracle Database and taking advantage of free features like HCC, which decrease storage requirements and improve query performance in real customer environments. The ultimate choice is yours.
Until Part 2!
- The OPN Comms Team