How to spot a good database solution

Categories: Software Product Development |

For any developer, the use of databases is critical  and choosing one might become a quite difficult task.  There’s a wide variety of products in the market, and every company is making a great effort to be competitive and differentiate from the rest of the competitors. A few weeks ago I participated in an Oracle event where the new database version was presented: Oracle 12c + Oracle Social.

Oracle 12c databaseAfter attending the event and learning about the new features, i remained with a highly positive feeling: I could see why Oracle is the first option when you want an Enterprise database solution. It has a lot of impressive capabilities (commercially emphasized, but they’re still real) such as: Database consolidation, Query optimization, Performance tuning, High availability, Partitioning, Backup and recovery, among others.

If you are looking for technical information, you can read the official page. From a developer’s point of view, I could appreciate more things than just the commercial benefits. I would like to show you some interesting features that, in my opinion, make Oracle a leader in this matter.

Oracle 12c strengths

Multi tenant Architecture: Wikipedia defines Multitenancy as “a principle in software architecture where a single instance of the software runs on a server, serving multiple client-organizations (tenants)”

Oracle introduced the idea of a main container. All the databases are connected to it, instead of having a separated server per data base. This practical idea reduces the resources applied to tasks related to optimization/backup/recovery to a single point.

Does this sound familiar to you? Yes, it’s the cloud solution, applied in all multiple technologies nowadays.

 And what about the data management? I enjoyed in special two nice ideas:

  • Heath Map: identifies and manages the data that should be moved or compressed. It keeps track of data accessed at the segment and row level,  dividing it into three different categories:
      1. Hot: Data that has been actively accessed and the latest activity date is less than a week.
      2. Warm: Data that has been moderately accessed and the latest activity data has occurred less than a week but less than a year ago.
      3. Cold: Data has not been actively accessed and the latest activity date is more than a year ago.
  • Automatic Data Optimization: Once you have identified the objects or tablespaces by hot, warm and cold, you can now define policies using ADO to move or compress this automatically. You define policies and attach them to objects and, when a policy condition is met, then action specified in policy description will be performed automatically.

The magic of Oracle Social

Oracle Social was presented almost at the end of the event. You can watch a demo in the following video:

What was important about it? It wasn’t the social media generation or the accounts management. The real magic lies in the data analysis.

You can start a search about brands or public people setting rules and filters. After that, the portal will look over social sources (twitter, facebook, etc), newspapers and blogs, among others. Using its own databases, it will process the data and show us different graphs, statistics and trends that will help us understand the behavior of our search over the web.

What we need to keep in mind here is that we can always improve our business and, more important reinvent it.

The core improvements in Oracle 12c don’t require hardware investment, or a main program change. What really makes the difference is the engineering solutions. So the message I got is to start thinking about how we could change things just by doing them more practical, accessible, functional and, most important, different.