Oracle Database

Avantages

Plusieurs aspects sont à mettre en évidence comme la possibilité de récupérer des données en cas de panneLa conformité Acid

Inconvénients

Oracle est le meilleur sur le marché mais son coût est vraiment coûteux pour nous les freelancers

Alternatives envisagées 

Logiciel antérieur 

Avantages

la performance, la fiabilité et la disponibilité, la sécurité et l'évolutivité.

Inconvénients

Complexité : Oracle Database est un système de gestion de bases de données puissant et complexe. Sa configuration, son déploiement et son administration peuvent nécessiter des compétences techniques avancées.

Avantages

Sécurité avancée, gestion des transactions ACID, propose des outils pour l'analyse de données avancée

Inconvénients

Alternative open source, dépendance à l'égard de l'éditeur, installation volumineux

Avantages

J'ai utilisé Oracle Database dans le cadre des projets d'applications web et mobile, il faut dire que Oracle Database est un SGDB, très robuste et adapter à plusieurs types de projets peu importe la taille

Inconvénients

L'inconvénient majeur d'Oracle Database est que sa prise en main requière des connaissances techniques assez avancée

Avantages

Version utilisé pour la de données : Oracle 10g express
Excellent outil pour l'administration de base de données.

Inconvénients

Aucun inconvénients trouvé lors de l'utilisation

Avantages

La performance du logiciel et sa fiabilité. Les fonctionnalités sont également nombreuse et avancées.

Inconvénients

Le coût du logiciel est vraiment très élevé.
Les alternatives Open Source comme MySQL, PostgreSQL et MongoDB a été le basculement.
En plus d'être coûteux, le logiciel est très complexe à utiliser.
Enfin... On est dépend d'Oracle .. Donc pas trop de flexibilité pour l'Entreprise.

Avantages

Only a few databases (such as IBM DB2) have this attribute. Due to this main features of the Oracle database, Oracle engineers have taken advantage of years of evolution and created a truly robust database that supports a large amount of data. I don't think any other database on the market can handle data volume like Oracle does while maintaining a high level of performance. Another thing I like about the Oracle database is that the company has invested in creating not only one of the best databases on the market, but also hardware with a high level of performance and has recently added interesting capabilities of artificial intelligence to the database engine.

Inconvénients

There are two widely known issues about Oracle databases that most people in the database community complain about (and so do I). The first is related to cost, as the cost of Oracle licenses, training and consulting are generally higher when compared to other alternative products. Second, is Oracle’s licensing structure, particularly for those who are in the process of obtaining a new Oracle license. In general, Oracle licensing is complex; A lawyer will most likely be essential during negotiations, as Oracle's license terms are complicated.

Alternatives envisagées 

Pourquoi passer à Oracle Database

Avantages

Can handle large datasets and heavy workloads; making it ideal for enterprises with growing data needs also is renowned for its stability and reliability, making it suitable for mission-critical applications, prioritizes security with features like encryption, auditing, and role-based access control.

Inconvénients

Licensing is expensive, especially for larger deployments or enterprise editions. While powerful and feature-rich, is often associated with significant additional costs. These costs can be a major factor influencing the decision to adopt or continue using Oracle for organizations of all sizes.

Alternatives envisagées 

Pourquoi choisir Oracle Database 

Logiciel antérieur 

Pourquoi passer à Oracle Database

Avantages

After working with DB2, Oracle was a breath of fresh air

Avantages

It is the only place where I can get all information regarding me as an employee: what training do I have pending, what training have I had, what are the updates to my contract, etc

Inconvénients

I find the structuring of the page to be very confusing, terms are too generalized so I never get to what I want in the first try

Avantages

Oracle Database is one of the options that you can choose for RDBMS. It provides a lot of features and tools to support our databases. The performance itself is quite fast.

Inconvénients

The Oracle's license is quite expensive especially if we just started with a minimum budget.

Avantages

Oracle Database has been my number one choice when teaching enterprise application development. Although it is a bit heavy and not that easy to deploy, students can get a lot of advantages learning a highly demanded DBMS platform that really adds a lot on their resume. The SQL concepts are easily tested against the database using the SQL Developer software. Moreover, JDBC drivers allow seamless integrations and very high performance when using Java to connect to the database on the client side, or when relying on the Java Servlets and Java Server Pages middleware on the Application server. Using Oracle with Java based technologies was definitely a very compatible option that simplifies and speeds up the development process.

Inconvénients

As stated, Oracle is not very easy to install and configure by novice developers. It is a bit heavy on low end devices.

Alternatives envisagées 

Logiciel antérieur 

Pourquoi passer à Oracle Database

Avantages

The advanced relational database management features from transaction management, SQL query optimization, concurrency control, security in design, to cloud integration to mention few make Oracle a way ahead of competition in the RDBMS cloud database market.

Inconvénients

Oracle is a bit expensive with a complicated licensing process. This is justified in return of the smartest DBMS algorithms available but still some more flexible cloud licensing strategies would make the system much better accessible to developers and administrators.

Alternatives envisagées 

Pourquoi choisir Oracle Database 

Logiciel antérieur 

Avantages

Accurate information collected and grouped into meaning full tables. Highly customizable database with ability to connect with other DB with APIs.

Inconvénients

Compared to the other DB in the market the Oracle DB is little user friendly and less sophisticated. Tools and icons in the DB itself must be remembered for fluent use. Limited analytics is available unless you want to pay more for the additional analytics and BI.

Avantages

I think the most fantastic thing about Oracle Database is the capability of solving hard problems with simple solutions. We've faced a lot of troubles and it still gives a fair fight even to AI solutions, and it's awesome.

Inconvénients

I think for sure the ease of use could be better, but with some addins and tools to support the everyday work, you can make this tool one of your best to deal with your data storing problems.

Avantages

It’s great for big businesses that need reliable and secure database solutions

Inconvénients

It can be expensive, and setting it up or managing it isn’t always easy

Avantages

Oracle is the #1 reliable RDBMS database in the world. It is fast, reliable and secured. It is the gold standard in the database world. To scale how good is a database product, it will be placed in front of Oracle database and compare with it

Inconvénients

1. Oracle is not Windows operating system friendly. It is usually built on Linux, which is not user friendly for most people. Anyone who wants to become an Oracle expert will take many years to become a senior level developer or administrator2. very expensive, not for personal usage

Alternatives envisagées 

Pourquoi passer à Oracle Database

Avantages

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.

Inconvénients

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.

Avantages

-vastly used DB in the market for a reason.-Excellent and responsive.-Well supported.

Inconvénients

Nothing much to point out. All seems fine.

Avantages

I have used oracle database mainly because of its scalability and high performance and because of that, it can handle high transactional data. It supports ACID properties and SQL PL/SQL languages to perform operations. It supports data backup, security and data replication.

Inconvénients

The cost and resource consumption is high.

Avantages

oracle is very easy to use and inexpensive would recommend it anytime!

Inconvénients

haven't really find any cons while using oracle

Avantages

Oracle cooperation has always been a reliable option for professional cloud infrastructures.Oracle Database helps us to deploy our apps (and even clients') to clouds with more flexibility. Its infrastructural capacities are extremely reliable and the company provides adequate security measures too.It's our first choice when it comes to recommending database solutions to our clients.

Inconvénients

The cost prediction is very high in most cases. I think the pricing options are more enterprise-oriented and in most cases can't be suitable for small or low-budget companies.We would have loved to use the Oracle Database integrator for most projects, but we wouldn't due to high pricing deficits.

Avantages

+ High performance and high scability with large datas+ Clustering structure

Inconvénients

- Complex licence options. Expensive for small/medium businesses.- More difficult to setup then other RDBMS

Avantages

Its without doubt that the Oracle Database stands out among its competitor dues to its ease of use as well as security features that come along with the tool.

Inconvénients

Its a tool worth every coin, nothing is annoying about the tool

Avantages

Oracle DBMS is the best when you talk about large data manipulation SQL/PL-SQL runtime is way beyond its counterparts such as MySQL and MS SQL. Another feature is the availability of support (API) for different programming languages. Programmers can easily develop applications using whether it be mobile apps, web based or other server based applications, Oracle is a sure bet. Oracle's availability, recoverability, performance feature is also an added advantage. The new feature that removes human error of patching and upgrading by automating the process is another key benefit.

Inconvénients

Oracle DBMS may not be the right choice for a small organization just starting if they do not have enough money to purchase its license. Oracle license is really expensive. One other thing is that you will need a highly skilled oracle professional to harness all the benefits Oracle truly provides.