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: 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.

Kommentare: My experience with Oracle has been as administrator and developer which gives me an overview of the projects and has allowed me, thanks to the tools it provides, to achieve projects that with other database managers could not have been successfully completed, that is, the multiple tools provided by oracle are very helpful although the examples and the documentation seem scarce

Vorteile: It is a very powerful database from the point of view of storage and development, I have used oracle in many aspects, as a database engine and for a large amount of data it is perfect because it handles high volume data efficiently, as well It provides the advantage of being able to develop with SQL ansi standard procedures and tasks that automate the management of data, the advantage of being able to run on any platform and with any development tool allows development projects to be carried out in the expected time, compatibility It is your biggest advantage

Nachteile: As a disadvantage I think that the way to handle the downloads of the connection drivers for the different platforms is a bit tedious since other databases do not require so much protocol to download the drivers. it may be necessary in some cases to document about the new functionalities because the examples provided by the provider are not so clear and / or non-existent