Oracle Database

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

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 

Pourquoi passer à Oracle Database

Avantages

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

Inconvénients

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

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

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

Inconvénients

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

Avantages

good for large enterprises That need high performance that why big company in my country always usually use it

Inconvénients

Not an open source , oracle always search for earning , Any tools using (SAP,FORMS BUILDER, APEX , ADF) from Oracle will get you to pay alot their website is difficult to get information or learn from it , Oracle support is too weak

Avantages

The most important services is middleware, 3-4 madule can connect and generate output as per desired, For Costing point of view, We can connect Meterial Management system & inventory Management system and Billing management system to produce final costing of a product.Secondly its very easy to modify the oracle forms, reports and Formulas.Through multiple languages we can modify Oracle forms.Third its cloud services, for multi-branches organization we can avail its cloud services, from these services we can collect data form every branch at one window. We can cloud partial data for public and complete data for employees based on organization behaviour.

Inconvénients

Complexity is the main issue of oracle data base, Non technical user cannot use it properly.During Development Error Expectation is high due to its Senstivity of character.

Avantages

Para mi tiene todas las funcionalidades que necesito para mi trabajo diario

Inconvénients

Con una carga muy grande de datos puede ir un poco lento

Avantages

With Oracle Database you can be sure you are backed up by one of the best RDBS available on the market.
Features like query hints mark the difference with its competitors and can be very important when evaluating the performance of your data source tier.

Oracle Database provides flexibility of data representation and all kinds of tools that help you succeed in your platform development.
Preserving data is the most important thing in every organization.

Inconvénients

Licensing can be quite costly if you take into account that there are very good Open source solutions available out there.

Avantages

I have been using Oracle Database since the version 10g. I have had a chance to work on several other database platforms like Sybase, MS SQL and MySQL. Oracle database comes with tons of features which many of the other databases don't have. I am not sure if i can say that other way round for other databases i have used.
It's quite complicated to learn and definitely complicated to master, but it provides you with enough tools to do complicated tasks quite easily.
You can also code your application programming languages using it's native PL/SQL language. Oracle Database also let's you make calls to Java programs and embed some Java inside the PL/SQL.

Inconvénients

It's costly! It's quite costly if you are using it for small businesses. Some of the very sophisticated features are only available for enterprise version of Oracle Database which is quite costly. Oracle is very price oriented, so be careful about the budget when you chose Oracle Database.

Avantages

What I love the most about this tool is that Oracle database is quite efficient and high performance database program. It is also compatible with various different platforms and the best thing about Oracle is the connectivity feature. Besides that we have the possibility to mention that it is also quite flexible and easy to use, which means that it is very useful for ourselves.

Inconvénients

In my personal opinion, we ourselves have the possibility to mention that it is a great tool, in addition, that we have not found a failure in this instrument because we use the Oracle database in order to preserve the entire database of the company. company.

Avantages

1. Robust Data Backup and recovery Options is the major capability of Oracle2. Flexible to implement or host in both Cloud as well as in on premise.3. In Built Data Movement tools like Export and Import Data Pump, which help is secured Data copy4.Java Support is the key feature that differentiate this from other databases5. Operational Data Stores can be maintained and is so reliable6. Access controls are at a granular level and too secure

Inconvénients

Complex Architecture, Average Customer Support , Price is expensive, not an easy DB for Begineers

Avantages

Being a oracle database administrator I like to manage and work on unique technologies that are available, like Real application cluster,Golden gate,RMAN, Datapump and its is really challenging at times when we receive performance related issues. It provides high level security on data where we can recover lost data or corrupt data using various technologies like RMAN,DATAPUMP,DATAGUARD,RAC.
ASM makes the database maintenance even more simple while adding new disks into storage or adding datafiles. Goldengate can be used to configure data replication between different vender databases and OEM 12C and above can be used to monitor other vendor databases and OS alerts too.The Cloud enviornment makes it look cooler.

Inconvénients

I don't find any cons as such as but the ORACLE-SUPPORT response is slow sometimes even on high priority issues and we need to raise a call to the manager

Avantages

Easy to use, install and manage. There is extensive documentation all over the Internet, which makes it very easy to ask questions (including in several languages).

Inconvénients

License is very expansive, including cloud Oracle Databases. Some versions requires high hardware requirements.

Alternatives envisagées 

Pourquoi passer à Oracle Database

Avantages

As a Java programmer, for me personally, Oracle database is one of the most important platforms that I use. The overwhelming features of the platform, its history, scalabillity and the overall usability is almost breathtaking. Java and Oracle, connected with Hibernate are a really powerful triumvirate of technology.
As a user, I use oracle database every single day for dispatching customer engineers, managing the work orders, pulling data and creating reports.

Inconvénients

So far I can only say good things about Oracle DB.

Avantages

It's a fantastic database with a wealth of functionality that is optimised, and I am the one that utilised it for a few years before moving to the cloud. Because of Oracle's excellent support and ability to manage complicated IT applications, database operations are straightforward to do and data processing is quick.

Inconvénients

As it's not an open-source database, we will always have to pay up front when putting a small-scale application into place. I experienced no further drawbacks, therefore if at all possible, utilise this.

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

Integrity and data security
Standardized the use of sql
It can be run on any operating system and on any machine from PC to high-tech servers
Allows database replication in a secure and consistent manner
Allows multiple databases (Instances) in the same server
The export and backup of the database is done according to the different needs of the user if it is a table excluding certain parameters, etc.
It can be monitored by application such as cloud control.
It allows to generate reports, statistics, multiple queries.

Inconvénients

Incompatibility with previous versions at the time of restoration
High costs

Avantages

Reliability and Robustness, Even if data grows exponentially Oracle DB remains performant. They have few tools to configure optimization but out of the box, it has an inbuilt performant engine.

Inconvénients

Small learning curve and need to little more knowledge to work and use it.

Avantages

Due to its excellent disaster recovery and data security feature it is the best solution for big companies and organizations. It has one of the best framework for performance tuning of data and architect. Very good support of SQL and PLSQL. Regular bug fix available form the ORACLE.

Inconvénients

It is memory hungry software so on native machine it is nearly impossible to test anything. To run it on the Cloud, the cost is very high.

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

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 

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

Well I am Using it from my college days, I have used it for small a project and am using it currently in my organization's project also.

Here I am listing pros :

it's a very robust database as compared to others.
There is a lot of support and documentation available over the internet.
Very secure
Built in Administraion tools and customizable settings.
So many drivers are available as it's one of the oldest database available.

Inconvénients

Cons -
The size of the software is quite heavy.
Expensive
It could be little difficult for a beginner to setup it and go through it.

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

Oracle is an absolute powerhouse. Currently it is the best database management system on the market and the only paid one. That is for a reason, nd that reason is that it features the best scripting language called PLSQL. It's turing-complete (meaning you can theoretically do literally anything) and makes room for unimaginambly complex calculations and transformations. Oracle DB allows for storing huge amounts of data and have access to it at a moments notice.

Inconvénients

Despite offering more than enough value for money, I do still consider it overpriced. Huge price tags often deter smaller enterprises from using a platform and nobody should miss out on Oracle DB.

Avantages

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

Inconvénients

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

Avantages

Even when being competitors, SAP ERP and Oracle Database was the best to pair up for a long time. Among the different databases I've worked with as an SAP developer during my career, Oracle has been the most trustworthy and easy to work with when doing native SQL.

Inconvénients

Licensing is expensive, as is often the case with Oracle and SAP.

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

-oracle database comes in 4 editions: standard,enterprise,personal,express. we have flexibility to use one of the edition on specific needs.
-cloud ready architecture
-strong user community

Inconvénients

- expensive pricing models
- extremely complicated architecture , not easy to acquire complete
- separate costs for additional features like partitioning and performance tuning

Avantages

His use and access platform is fantastic. Very visual and intuitive. It is a very secure and fast database, with many tools for administration.

Inconvénients

During all the time that I used the database, I was unable to find anything that darkened his image.

Avantages

Performance and stability is the horsepower of Oracle Database.

Inconvénients

RMAN and Tivoli integration needs improvements.

Avantages

I like that this software is a workhorse and really is capable of everything. I also like that it is customizable to the needs of the company using it.

Inconvénients

It really takes a lot of specific training and experience to get to know this system really well. There are a lot of little caveats and silly rules to follow to get things where they need to be. Once you learn the tricks of the trade it's no problem but it is not intuitive or user-friendly at all.

Avantages

Oracle Database is a well-known professional-level database. It does it's job well, storing data, and having countless ways to query and access it's data. Updating, inserting, deleting are accompanied by every clause you could want to control your data. It's a robust database, and works seamlessly with most IDEs.

Inconvénients

There are more than a few different "big player" databases in the market, other than Oracle, and they each often have their own spin of SQL commands. It's hard to keep the nuances straight, and thus there's a learning curb to getting the syntax correct. This is more an annoyance overall, and not specific to Oracle - just note, that it's different then MySQL.

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

Es un programa super sencillo de utilizar en el que puedes guardar toda la informacion de los empleados de la compañía con total seguridad

Inconvénients

Si lo dejas de usar por unos minutos se bloquea pero esta perfecto porque todo esto es por seguridad de la informacion

Avantages

Oracle's powerful relational database engine can scale up from a small server to a huge server farm and has famed reliability features. I like its support for multicore and multi-server environments and how well it integrates with just about any enterprise-grade application you can think of.

Inconvénients

It's a bit pricey, though it has a pay-as-you-grow pricing model, so it may not be a problem for you.

Avantages

Every Oracle job I have worked has had a solid
proactive team that is well read on standards and best practices
and has many years of experience.
Oracle is definitely one of the best implementations of RDBMS. It manages memory very efficiently and can handle complex JOIN operations which easilly cripple MySQL and MsSQL. Oracle has a great Architecture, because it is very easy to organise different applications data very well. I think the best plus for me is the SQL Engine that Oracle possess, it is very advanced, making it the only database to operate a data warehouse! Running complex queries on Oracle is just easy.Other features like Materialized Views, PL/SQL e.t.c. make Oracle have value for money

Inconvénients

Unintuitive performance tuning tools, and finicky optimizer.
SQL*Plus with a built-in tabular format output; useful for rows that span across many lines. No, Grid Control SQL Output just doesn't cut it; it's a static output of the entire table. It doesn't have the powerful SQL*Plus commands.

Avantages

Oracle Database aligns with the topics you learned in your Intro to Databases class. It has tables, columns, keys, indexes, triggers, and all the things you want to avoid in your modern applications.

Inconvénients

It is big, resource-intensive, expensive, hard to maintain, hard to patch, unreliable, impossible to distribute without an equally cumbersome and expensive add-on, and it keeps your applications mired in the past.

Avantages

One of the most powerful database environments, too many drivers for every programming language, you can access to an open version easily.

Inconvénients

Poor support for the open version, hard to maintain for small companies, the learning curve could be high and complicate to read every detail about custom installations.

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

It performed well and managed large amounts of data efficiently.

Inconvénients

The update process is very complicated. It was necessary to review the procedure well in advance. Just running the installer is not enough to update.

Alternatives envisagées 

Pourquoi passer à Oracle Database

Avantages

It provides us the transaction/data integrity and read consistency that lower down chances of data corruption.
Most of real life business scenarios are taken care by it easily.
It works with variety of applications and easily integrated.

Inconvénients

Its deployement and maintenance requires expert level skills.
Its license is very expensive.
Difficult to diagnose performance issues over here.

Avantages

There's a database version and feature for every need. For instance, my company started using Oracle Database Express Edition, right now we are using Oracle Database EE with RAC feature. The announced autonomous feature looks fantastic.

Inconvénients

I had to think a lot to find something to like least and I have to say that I would like to have a standard feature for database performance without using Cloud Control.

Avantages

Oracle SQL syntax is my preferred one. Performance on relational DBs is good. No need to create a separate DB, you can use tablespaces.
SQL Developer as OracleDB client is great. TNS names integration for third-party software is awesome.

Inconvénients

Performance for simple solutions could be improved, but of couse it is not what this type of DBs is designed for.

Avantages

I am used to PL/SQL syntax so I prefer it to other SQL dialects. The fact that Oracle drivers and tools are stable and widely used. That the free version of Oracle client SQL Developer is good enought for most use cases.

Inconvénients

It is more expensive as alternative products.
It doesn't come with IDE out of the box.

Avantages

It is a powerful database engine, which is designed for large volumes of data. It has the classic functionalities of every top database engine.

Inconvénients

It has a very high cost. It is not intended for small projects. incredibly it has a concept of sequences and has no autoincremental fields. It is really unusual to allow a bad programmer to use a sequence for several tables. beyond that that would be a bad development practice the biggest mistake is that the tool invites you to commit it

Avantages

For inventory management Oracle is the best option available. It has been deployed in procurement, store and other operational departments.

Inconvénients

It's data coding becomes sometimes a bit tricky.

Avantages

We have been using Oracle Databases more than 10 years in our critical databases. We are using 10, 11 and 12c versions on different projects. If you give Oracle Database lots of physical memory and fast SAN storage, you can get unbelievable performance results compared with other free db solutions. It is easy to manage with EM Console, too. Customer service and metalink support are also magnificent.

Inconvénients

Only negative side is the price policy. It's an expensive solution.

Avantages

Fiablilidad, potencia, rapidez. Producto muy estable

Inconvénients

Complejidad de configuración y mantenimiento. Política de licenciamiento muy complicada