Category Archives: Oracle Internals

This category list all articles about internal functionnalites of oracle, optimizer, statistics, internal components of the Oracle database

Intoduction to Oracle Rest Data Services

Presentation

First, let’s talk about REST apis. REST apis are very popular nowdays because they are easily accessible from any client able to make http(s) requests. The beauty of this is that you can access different systems through these rest apis independantly of how the system is built in the backend. For example I can access with a simple curl command the twitter, youtube or any public api which will return me data.

Rest APIs usually present data as a JSON object. If your are not already familiar with JSON here is an example of a JSON object:

{"menu": {
  "id": "file",
  "value": "File",
  "popup": {
    "menuitem": [
      {"value": "New", "onclick": "CreateNewDoc()"},
      {"value": "Open", "onclick": "OpenDoc()"},
      {"value": "Close", "onclick": "CloseDoc()"}
    ]
  }
}}

Oracle 12.1.0.2 introduced the support of JSON as a datatype and methods to query JSON objects. This make things a lot easier when you have to work with these data structures.

Continue reading Intoduction to Oracle Rest Data Services

Information Lifecycle Management

Presentation of Information Lifecycle Management (ILM)

With data volume growing, finding adapted storage solutions to storage costs and performance objectives is a real challenge for IT department in large companies.
Information Lifecycle management is about managing the data all along its useful life while offering the best performance and storage cost.
The concept is simple, data is spread into multiple storage tiers, each one with specific properties. According to this, you can keep active data on fast storage devices and inactive or less active data compressed or into cheap storage devices or offline storage (tape for example).

Information LifeCycle Management

 

As you can see in previous diagram, storage tiers are classed by usage, these data classes are definied in the database using partitions. The only thing missing here is the way to manage where and when to move the data.

Oracle 12c offers a new tool to achieve this objective. Continue reading Information Lifecycle Management