Oracle Autonomous Transaction Processing vs. Oracle MySQL Cloud Service

If your company's value is not increased by maintaining databases, you should use the ATP.

It is very scalable and it gives us backup for everything. Because of this feature, we (as a developer) can do any R&D if required. It is very stable so we can get any type of help. It has a recovery feature also which we used recently for my project. It is very easy to recover.

• Quick and simple to deploy (less than 5 steps to create a new instance)
• No administrative tasks (backup, re-sizing) required

Incentivized

• Oracle database has ability to store large scale of data.
• It can support any kind of scenario with any label of system.
• Encryption and security is the key features of Oracle database 12c.

• Connectivity between ATP and Oracle Kuberentes Engine cluster seems to drop randomly
• The ATP could come in an even smaller shape as the smallest shape is already quite big . But if must be more than always free, as that version does have connectivity limitations about 20 connections

• It has some issues [when] performing local unit testing in personal edition.
• It is costly if we will go for cloud.
• Need license for some features.

You get almost all the features of Oracle Database, including the ability to deploy APEX applications, without having to worry about system, storage or database configuration and maintenance, backups, etc. Also, you can start for free and move up adding resources as you need.

Incentivized

Both Azure SQL Database and Oracle Autonomous Transaction Processing offer a powerful and robust database platform. The advantage of Autonomous Transaction Processing is the ability to host APEX applications for free and without any special/complicated deployment or configuration process. Having a rapid development environment embedded for free was the main advantage for choosing Oracle as my cloud database provider.

Incentivized

It has the most stable database. It smoothly supports [a] huge [amount of] data. Security-wise it is best among them. It is a very large community and has well-defined documentation, which can support [during the] implementation of the Oracle database. We can easily scale up servers whenever [we] change our requirements. Oracle12c is best for large-scale projects like banking and retails.

• Approx 100 times faster spin up than manual setup of an Oracle DB
• 3h annual maintenance for big version releases (18c to 19c) compared to est. 500h annual maintenance with manual database updates

• It has ability to handle [a] huge [amount of] data and give [the] best performance
• Easy to write PL/SQA queries
• Secure and encryption option