Best Relational Database- Oracle Database
Use Cases and Deployment Scope
I have used this Database for storing and retrieving the data for a web application. As it is a relational database management system and data is stored in the form of tables. We usually retrieve the data using the SQL queries. The oracle database helps me to easily retrieve the complex data. By implementing permission and altering user activities, we can simply prohibit unauthorized access and provide separate access to users.
Pros
- Easily retrieve complex data using SQL queries
- Provides high level of security from unauthorized access.
- Data can be easily recoverable it it is deleted by mistake
- Installing in windows machine is easy
Cons
- Price is one of the reason, as its licensing cost is expensive. Rest is good
Likelihood to Recommend
According to me, Oracle database can be used by multiple applications. So in my case I have used for two applications- EMR and cognitive search, which makes my life easier.
I can say it is less appropriate in some cases when it required high maintenance. Also its licensing cost is too expensive.
