The main, most important feature is the integration of the database, security, and performance. Those are the three main features. They have evolved it very well since version 6. It used to be rule-based, now it's cost-based, which is great because there are so many routes to bring in the data. It's a really complex architecture, and the way Oracle has done it is really good.
I work with a couple of other databases too, but with Oracle, it allows you to drill down to a very small level inside the database and return a result that you want. That's another pretty good feature.
Also, Database has low-level security through a virtual private database. Within the same database, we can show two businesses simultaneously without having a different architecture. This really helps us.
A lot of things like a low level security. One of the features that we use virtual private database, which is a low level security. Within the same data base we can show two businesses at the same time, without having a different architecture. It actually helps us.
Improvements to My Organization
It's beneficial for our organization because we have a lot of financial data where it has to make sure that something came before on the master data layer. You have to have a node created before you insert the data that leads it to the node.
Room for Improvement
When there is the high insertion of data and bursts of insertions, Database has to manage the integration, but the way it tries to maintain all the integrations is not necessary. There's a way to de-normalize all this, but not if an application is already downloaded. Database has a lot of limitations, especially when you have a huge data insertion that you're trying to query. That really becomes a limiting factor with Database.
Use of Solution
I've been using Oracle products for 22 years.
We have no real issues with deployment.
It's one of the most stable database that I work with. They have been improving with every version. As far as stability goes, I give a very high marks to Oracle.
There are ways you can scale it, but one of the limiting factor is the way Oracle licensing works. The moment you try to out scale it vertically or horizontally, you multiply the Oracle licenses, and a lot of customers are looking into that. How do we optimize those with the performance that you need?
Customer Service and Technical Support
The problem is the way the technical support works. A lot of people try to pass the ball around, and that's a lot of challenge with management of all that. Most of the time, if you really want to work on something you have to raise it to Level 1. You've got to escalate, otherwise things doesn't get worked on. If it's a critical thing, there's no other option.
The initial setup was straightforward, but maybe I'm so experienced that I don't have many issues with it. A new DBA may have a different view of the setup. I would suggest, however, that Oracle should develop a feature in Database that lets you know which products you have a license for and which ones you don't during the setup.
We implemented it with our in-house team.
It's a good, stable system. When it comes to Oracle, you need to understand what to use, how to use it, and look into the cost of it, which is very important.