Oracle Database

Kommentare: Really for me it has been very satisfactory to develop applications with this DBMS, because it has made the work more pleasant and simple, besides having the peace of mind that the database is very secure

Vorteile: Oracle is the object-relational database engine most used worldwide.
It can run on all platforms, from a PC to a supercomputer. It is a super complete DBMS, with a high degree of performance, stability and scalability, supports all the functions expected of a server is a very complete database design language (PL / SQL) that allows implementing "active" designs , with triggers and stored procedures, with a fairly powerful declarative referential integrity. It allows to implement the security of the database efficiently and effectively through the management of users, roles and passwords. It allows the use of partitions to improve efficiency, replication and even certain versions support the administration of distributed databases. The server can be run on a multitude of operating systems. The great support that the organization offers its users. It has tools that allow the database administrator to perform its function efficiently and effectively. It has tools that make the backup of the database very simple. Great capacity to restore the database and very fast recovery, in addition to having a wide type of data which facilitates the design of the database

Nachteile: What I like least is that it is a bit expensive. Another problem is the need for adjustments. A common mistake is to think that it is enough to install Oracle on a server and directly plug in client applications. A misconfigured Oracle can be desperately slow. Misconfigured Oracle can be desperately slow.

Kommentare: Overall it is a good database for clients whose applications needs to handle the heavy load of data.

Vorteile: Oracle database supports PL/SQL which allows user to write complex queries in procedures/functions which relatively gives better performance. Oracle database can be better equipped and scaled for heavy load applications. we have lot of documentation in the internet for oracle database usage. Oracle Drivers(API) are available for all the Programming languages which makes easy to connect database from the code. It has reliable security configuration which makes database administrator life easier. This is platform independent and can be installed in any OS(Windows, Linux ). It supports CSV, Excel and Plain Text files for Uploading. It also supports inbuilt AQ (Advanced queue) which can be used for event based applications.

Nachteile: Licensing cost is not greatly affordable for smaller size companies. Query performance is slow for tables which has millions of rows unless you optimize(tune) the query. Oracle Customer Service response is not that friendly.

Kommentare: I have learned a lot using Oracle, it would be great if it were not so expensive, as well as being certified in it. It is important to know that a well-crafted database will work in any database manager, Oracle can not solve faults or problems in a poorly-related database

Vorteile: - Allows the management of relational databases from very simple to large volumes of data.
- Because it is relational, the PL / SQL language is used.
- It is agile, consistent and robust.
- It has all the functionalities that a DBA would like to have for the management, control and performance of the databases.
- A well-configured cluster with Oracle is practically invincible.
- Oracle is currently bringing all its products and services to the cloud, that is, based on Internet.
- The graphic tools used with Oracle are intuitive and easy to use, practically They do all the work.
- The tools also allow you to intone databases, improve performance, give you alerts.
- Allows to make backup copies, partitions, manage users to control the security of information.

Nachteile: - An Oracle license is very expensive, so it is not accessible to everyone.
- Staff with knowledge in Oracle is equally expensive, information costs money!
- It is difficult to access information related to the driver, its configuration and maintenance.
- For DBA without experience, a configuration is complicated by the amount of details that must be consider.
- If you do not have a graphical interface to work with Oracle, you should have knowledge in commands to work in consoles or terminals.

Kommentare: Oracle Database is a powerful, flexible and enriched tool with unparalleled coding for database creation at different scales.

Vorteile: There are many advantages of Oracle Database, I can say that its performance and use of resources for me is of a competent efficiency since it is a multiplatform system. Its data dictionary is extensive giving extraordinary support to the programming language, thanks to the fact that 80% of Oracle's internal codes are the same as those established in the operating system platforms, which allows creating data and tables quickly and easily according to the needs you want to achieve in a company or organization. The Forms, SQLFORMS are very simple and effective for the design of screens, the best of all is that, after defining the form you can work on it without generating codes, this at user level is very useful. It can be used both for personal information and for large data stores. is run in high and low range equipment, this is a great advantage. As I said at the beginning there are many advantages of Oracle to create a reliable and secure database.

Nachteile: Just as it has a simple and adaptable interface, it's necessary to have a broad knowledge of programming and creation of tables to take advantage of the entire box of functionality that Oracle has. It's worth it.

Kommentare: Scale, security, easy migration, analytics etc

Vorteile: Oracle has been investing heavily in its flagship database products and improving it constantly over the years. Oracle Database is available both on premise and on the cloud.Built on the new self-driving database technology, Oracle Autonomous Database Cloud removes complexity, human error, and manual tuning by performing fully automated administration and tuning, including automatic configurations and online recovery to ensure higher availability. Routine but important maintenance tasks, such as upgrade, update, and patching are executed automatically, eliminating costly manual error-prone human processing.
Highly Secure. Easy Access. Drawing on nearly four decades of expertise in building data management and data protection for massive enterprise-grade operations, Oracle has engineered in-depth security into all computing layers to ensure data privacy and safety.
Oracle supports all data types, from SQL and NoSQL to Hadoop, as well as workloads of any size for everyone, from developers for DevTest to IT for the most mission-critical workloads

Nachteile: Oracle can work and improve its customer service. Oracle customer service is not that great. However it is changing.