Oracle Database

It is considered the database manager par excellence worldwide, however it has its detractors

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

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.

Oracle Database review

Commentaires : Oracle Database is a widely-used database management system that has been in use for many years. With 2 years of experience using Oracle Database, a person may have gained significant knowledge of its features, benefits, and limitations.Overall, users often report that Oracle Database is a powerful and reliable database management system that is capable of handling large amounts of data and scaling to meet the needs of businesses of all sizes. It also offers a range of security features, such as encryption and access controls, to protect data from unauthorized access and ensure regulatory compliance.However, some users may find Oracle Database to be complex and difficult to manage, particularly when it comes to performing advanced tasks such as database tuning and optimization. Additionally, licensing costs for Oracle Database can be high, which may be a consideration for some organizations.Despite these potential challenges, many users continue to rely on Oracle Database as a core component of their IT infrastructure, due to its robust features, performance, and reliability.

Avantages :

With 2 years of experience using Oracle Database, I know that it has the ability to handle large amounts of data and can be easily scaled up or down to meet our business requirements.One of the most impressive aspects of Oracle Database is its robust security features, which include encryption, access controls, and auditing, that protect data from unauthorized access and ensure compliance with industry regulations.Overall, Oracle Database has proven to be a powerful and reliable database management system that is capable of meeting the needs of a diverse range of businesses and applications.

Inconvénients :

I don't dislike this Oracle Database. It's amazing.

Alternatives envisagées : Microsoft SQL Server

Old and Outdated and in need of refurbishing/needs to be replaced by some new Google product

Commentaires : Oracle helped our business use secure filesharing, but wasn't great. We stored a lot of stuff on their database but I am overall not a fan. It was helpful to our company, but I feel like there HAS to be bigger and better and more user-friendly products out there doing a better job.

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.

World's best RDBMS database

Commentaires : Since I've been an Oracle DBA for about ten years, I greatly appreciate how well Oracle Database manages the deployment of the majority of the data for the company I work for. It also enables stable backup and storage of vast volumes of data and supports a number of programming languages. Oracle offers PL/SQL, a complicated but effective query language that is not simple. The world's most potent characteristics include data auditing, backup and recovery, data encryption, as well as the capability for data analysis. Companies that use Oracle databases pay for technical support services, which are provided by highly knowledgeable and competent Oracle professionals who are available 24/7. This implies that you will never be without a solution to a problem or an issue. Cost is by far Oracle database's largest drawback.

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.

Oracle database Middleware & Cloud services

Commentaires : By using oracle database, Meterial management and costing is shown on one window.I immediate realize the product cost and price.Handling All productions Operation Due to its middleware services at one place.

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.