Avis clients sur 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 

PhpStorm

Logiciel antérieur 

Microsoft SQL Server, MariaDB et SQLite

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

Oracle Database est un l'un des SGBD les plus complet et polyvalent, avec un langage de requête très simple

Inconvénients

Oracle Database demande d'avoir de solides compétences dans la gestion des bases de donné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

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.

Inconvénients

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.

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 

Microsoft SQL Server

Pourquoi passer à Oracle Database

Well, the choice between Oracle and SQL Server is typically made at the top levels of management. But in my opinion, Oracle is still preferable to Sql Server in the majority of situations.

Avantages

Had to use it for work. It was ok for filesharing, but I feel like half the time it didn't work anyway.

Inconvénients

DEFINITELY needs a facelift in terms of its GUI. I thiiiink it needs to be more secure too, I feel like we had issues with security but I could be wrong. Seems old and outdated and like it should have already been replaced and made obsolete by some sexy new Google or startup product.

Avantages

It is a very solid database, with a lot of official and community support and documentation. Very good for those who want to start with database management.

Inconvénients

With all of its features, it can be heavy and complex.

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

To increase the performance, Oracle has some features as partitioning and compression. Also it secure the information with encryption technology.

Inconvénients

Some features have additional license. So if you want to add additional features you pay more.

Alternatives envisagées 

Microsoft SQL Server

Pourquoi choisir Oracle Database 

Because of the Adabas old technology, we have to move the best one.

Pourquoi passer à Oracle Database

It is the best database according to its features.

Avantages

Widely used software for the applications we need to run our business. With support options we need to ensure it remains online 100%

Inconvénients

Ridiculously expensive to purchase and complex license terms and conditions. Support is painful to get to the right team. however, resolution for issues once you get to the team is quick and painless.

Alternatives envisagées 

Microsoft SQL Server et MongoDB

Pourquoi passer à Oracle Database

We needed oracle DBMS as the primary applications we need to use primarily only supported oracle database software. It made the decision pretty easy at that point.

Avantages

1. It did almost everything I wanted to did for my semester project and what it wasn't able to do was always added in the next update. A pleasant surprise.
2. PL/SQL was so difficult for me . But still the documentation made it easy.
3. It's core is a relational database, which is a mathematical model and makes it easier for people from science and mathematics background to understand and use.

Inconvénients

1. Felt a bit overwhelming in the first few days of its use.
2. So many features and syntax are prone to be forgotten.
3. Expensive if you want to use a particular or minority of features.

Avantages

You can create a database in which you are controlling all aspects of it, allowing you to better manage the resources you have.

Inconvénients

Database administration can become more complex than it should.

Alternatives envisagées 

Microsoft SQL Server

Pourquoi passer à Oracle Database

The performance and control that Oracle offers.

Avantages

What I liked most about this software is selecting tree structure data by just "Connect By" keyword. It provides the most flexibility which you can consider.

Inconvénients

Oracle database best performance can be gained just by installing it on the Linux Distributions. If you install it on the Windows, performance will decrease and some times Listener Service will stop without any specific reason.

Avantages

+ Enterprise features such as High availability, Concurrency, Disaster Recovery.
+ Comprehensive documentation from Oracle.
+ Best vendor support -paid
+ Best security features such as encryption, data masking , redaction and auditing
+ Maximum Availability architecture to provide best protection to our data
+ Performance monitoring capabilities

Inconvénients

+ Enterprise licence are very costly.
+ Data Gurad licence sold separately.
+ Not easy to Install,configure and maintain, need high skilled resources.

Avantages

It's easy to find all triggers, procs, views, and tables on the left side. There are also great tables like all_tables and all_source that make it easy to search our entire database for the proc or table I'm looking for. There's a super convenient button that changes the case of all code you highlight in the editor, so you can type in the case that's convenient for you and update everything with the button.

I also like that you can pin your query results so they don't go away if you re-run the query or run a different one on the same tab. Each set of query results can be named, so you can run, pin, and rename everything you need, and paste your results somewhere when everything is done running.

Inconvénients

There are more slowness problems in this database than in sql server for large tables. I'm not sure if it's due to table design though. I have to be more careful how I write queries here since some of them can run for hours.

Avantages

Perhaps the most well tested relational database for large installations. It can handle a huge amount of data and perform well under load
Reliability!!! Without a doubt, the Oracle database series (I think it's up to Oracle 12c now) is the `godfather' of commercial transaction and government RDBMS software. With it's different version releases, the software has been around close to 40 years!!! It's the originsl flagship product of the Oracle corporation.

Inconvénients

It's expensive. So, if you don't need to support a lot of data and transactions per second you should seriously consider a cheaper option like MySQL or a nosql database like MongoDB.

Installation Time per individual instance!!! I've automated the whole thing from a fresh install of a Linux Operating system and it still takes at least ~3.5 hours to install it, although I've done it in as little as 2.5 hours, but it depends on where the package repository is, and how version control is being handle! (POINT THE MATTER IS, IT CAN TAKE VERY LONG TIME FOR MERE INSTALLATION) On Windows operating systems it can take up to 8 hours or more, your first time around!

Avantages

The PL/SQL support makes writing complex queries easier. It is most stable data storage engine. It support huge databases very well. It is very reliable for data safety. It is also very well in database security management.

Inconvénients

The high licensing cost makes it inaccessible to the most of its lovers. Modern programming languages are not well supported. It is difficult to learn for novice users.

Alternatives envisagées 

Microsoft SQL Server

Avantages

Oracle database is best manager of the data, PL/SQL used to arrange data which makes possible to arrange data 100% accurate.Huge data can be manage through a simple click.its spread sheets have millions of rows and columns.we can extract spread sheet of oracle database toMS Excle through refreahable files.

Inconvénients

PL/SQL is very senstive language and its resources persons are highly paid.secondly its license is much expensive.
We have to refresh exi file while entring any new data.

Avantages

Oracle provides an easy and powerful way to interact with data. Capabilities such as data dictionaries and indexes make it easy to optimize the performance of existing procedures, and the organization of schemas make finding and editing current stored tables and scripts intuitive. I transitioned to using Oracle from MySQL and it has been an easy transition. It also integrates seamlessly with Spotfire to enable dynamic visualizations and enables insight into business decisions.

Inconvénients

The permissions granted to different departments and the access for different schemas can be confusing to navigate. I know that these permissions are enabled as a safety feature, but it is still frustrating to move through the ranks in order to enable certain accesses. The software also crashes occasionally, which was frustrating. If you are working on an already overtaxed system, be aware and save your work often in case of an unexpected closeout.

Avantages

Oracle is a versatile, robust and reliable database. Can be used for a variety of work loads like OLTP and OLAP. Provides options for easy installation and maintenance but can also be tweaked by advanced users.

Inconvénients

License management is complex. If licenses are understood properly and not managed or tracked, it may lead to legal/financial implications.

Alternatives envisagées 

Microsoft SQL Server et PostgreSQL

Avantages

1. Within the Oracle databases, the application can use multiple schemas.
2. Database tables are assigned to table spaces such that their extent size reflects the size of the table
3.Ability to create all functions and procedures inside Packages [No stand Alone Implementation], and those which define the interface of the package to the outside can be declared in the package header
4. By using Dynamic SQL we've replaced bulky queries by input based optimized queries.
5. Using Oracle's 'Advanced Queuing' we implemented Asynchronous calls in the database enabling us to run processes in the background, when a separate process got executed in the foreground.

Inconvénients

These days capabilities like Oracle are being provided by other open source DB's like Postgres etc at a very nominal cost.

Avantages

I have been working as a Database Administrator since 2011, Oracle is by far the best relational database I have used. It works better on unix-like systems, it is very fast, has lots of parameters to tune to your specific needs and it also has a lot of features like partinioning, high availability soluctions like RAC and Dataguard that make this the best database on the market for mission critical systems.

Inconvénients

The online documentation needs improvement, sometimes it is incomplete, there are not enough examples for some features. Customer Support is erratic, sometimes it´s great and sometimes not so much, it depends on the support tech.

Avantages

I have been working on database technologies since more than a decade now. Oracle database is the most powerful relational database in market with tonnes of features. If you buy enterprise edition of the software, you get features like data guard, Oracle Enterprise Manager for free.

Inconvénients

Oracle database can be overly complicated for someone who has worked with other database vendors like Microsoft or SAP. Also, Oracle database is costly in terms of license price compared to other database options.

Avantages

The high availability features like RAC, the replication features like GoldenGate, the different reporting capabilities using views and DBA_ views, the manageability using Oracle Enterprise Manager, all these make it the most loved Database flavor among its customers. Other flavors of databases are dwarfed when compared to its functionality.

Inconvénients

Oracle RDBMS gives too much importance to data consistency, and can sometimes look complex when trying to solve simple recovery issues. That is one reason why some customers are afraid to use this otherwise powerful software.