Video

Automatic Data Optimization with Oracle Database 12c

Oracle’s hyperattentive database diligently guards your data.

In this age of big data, there are certain dangers.  It is normal to expect the volume of data that you are keeping to double every two or three years.  And managing all that data can present to be quite a challenge as IT would need to strive to give users and applications the best performance while also keeping costs down.  The explosion of data is the reason why storage costs is still one of IT’s biggest expenditures even when the cost of storage decreases.

Oracle Database 12c has added two information lifecycle management functionalities:

  1. Heat Map
  2. Automatic Data Optimization

Heat Map allows you to automatically query timestamps and track changes at segment and row levels, so that you can see how your data is being accessed, including when these have been accessed and how often.  You can use this heat map information so that Automatic Data Optimization can compress and move your data automatically, based on the policies that you define.

How does this help?

As you know, applications and users access their data differently.  There are data that are accessed frequently or those that are tagged as critical.  And there are data that are not accessed for long periods of time as well as data that are no longer accessed.  Now, the problem is keeping all of these in single storage, as it would be very costly and inefficient.  So what IT departments do is to implement storage tiering.  Tiering is when the frequently accessed and critical data are placed in the fastest storage, which is very costly, while cold data are placed in slower and more affordable storage.  Because cold data are rarely accessed, the effects of them being stored on slow storage is minimal.  Cold data may also be compressed while in this type of storage.

Heat Map takes a look at segment-level and row-level data and tracks its usage and how these change over time.  It then assigns a color to indicate which sets of data are hot (frequently accessed), warm and cold.

You can then use these information so that Automatic Data Optimization can implement storage tiering and compression tiering.  Automatic Data Optimization works by allowing you to set policies that it can use to determine when to compress and move the data.  You do not even have to do anything beyond setting the policies as Automatic Data Optimization does everything automatically.

For example, you get on Automatic Data Optimization to set policies on what is to be done to data that have not been accessed, have not been changed or were created at a certain date.  Then you need to specify when the policy will be carried out.

On top of this, you can also create other conditions outside of the data you get from heat map by using PL/SQL.

So, basically, with Automatic Data Optimization, you can make sure that your database data is accessed quickly and is always available, while also keeping your storage costs down.  All these without having to spend too much time with it.

Are you convinced that you could benefit tremendously from this and other features of Oracle Database 12c?  Call Four Cornerstone today and find out how you could start using Oracle Database 12c for your enterprise![/expand]

Photo by Oracle.

Cloud Blog

4 Ways To Benefit from…

One of the benefits you get when you work with cloud applications is that you often have quarterly updates that are packed with features. This...

Keep Reading

Artificial Intelligence

Data and Analytics: Cross the…

  Artificial intelligence is a manna sent from digital heaven. That’s how blessed your business can get if you immerse into the AI of things....

Keep Reading

Business Intelligence Blog

How Brand Names Survive in…

  The age of digital marketplace has made it possible for unknown and smaller companies to compete with better-known and well-established brands. Take for example...

Keep Reading

Artificial Intelligence

The Phenomenon That Is Artificial…

  Artificial intelligence is when a machine does cognitive functions that are more associated with humans, such as thinking, learning, problem solving, and reasoning. As...

Keep Reading

Cloud

Digital Transformation in Banking: Shift…

  The start of a new decade is already shaping up to be exciting for financial services, especially for banks as they continue to compete...

Keep Reading

Business Intelligence Blog

Data Science and Its Economic…

It would seem that artificial intelligence is the focus of businesses that are looking to future proof their organizations and stay competitive. And why not?...

Keep Reading

Data Blog

Ensure Efficient Data Science and…

In an ever-expanding landscape called Internet of Things and the exploding development of artificial intelligence, we are bombarded with complex methods of integrating data science...

Keep Reading

Business Intelligence Blog

Cybersecurity: The Top 5 Expectations…

  If you think about it, cybersecurity is closely tied to human rights, privacy, freedom, and even basic safety. As a whole, we have become...

Keep Reading

Business Intelligence Blog

Tech Security Should Be Easy…

  IT professionals know that tech security is important in everything that they do. And that there are a lot of products, tools, innovations, and...

Keep Reading

Business Intelligence Blog

The Top 6 Success Stories…

Nearly nine out of 10 digital transformation initiatives fail. Digital transformation projects fail for a variety of reasons. It can be because of a lack...

Keep Reading

Live Chat | Emergency