Microsoft Access vs. MySQL vs. Oracle Cloud Infrastructure

As a Material Purchasing/Planning/inventory tracking application, Microsoft Access serves its purpose well. It's presentation is clean, data entry is simple and the ability to customize search fields is welcome. It does, however, come with some caveats; namely, when setting search filters and the need arises to back up a step or two, with Microsoft Access you have to reset, or "clear all", adding extra steps/time to a query.

Incentivized

MySQL is best suited for applications on platform like high-traffic content-driven websites, small-scale web apps, data warehouses which regards light analytical workloads. However its less suited for areas like enterprise data warehouse, OLAP cubes, large-scale reporting, applications requiring flexible or semi-structured data like event logging systems, product configurations, dynamic forms.

Incentivized

As per our usage Oracle Cloud Infrastructure for almost 6 years hosting 500 + customers I can say its well suited application for any small scale to larger scale application as it can handle that capacity and provide more reliable cloud service only if you need any messaging service like pub/sub or sqs better to consider other services.

Incentivized

• Very easy to create entity-relationship diagrams for various tables and designing mock layouts.
• Really easy to navigate as it hold[s] the classic Microsoft UI. Another good thing is that it comes with the complete MS Office Suite.
• It is really fast when joining multiple tables no matter what type of join.
• Works on pretty much same SQL scripts so no need to learn a new language!

Incentivized

• Stable - it just runs, with minimal downtime or errors
• Fast - well-structured data is quickly written and read
• Secure - MySQL is easy to keep data secure from people and applications that shouldn't see it
• Easy to use - SQL is industry standard so no problems with adding, editing and reading data stored in MySQL

Incentivized

• Oracle Cloud Infrastructure has a generous free tier, moreso than other hyperscalers, with an always-free tier that guarantees certain products are always free
• Oracle Cloud Infrastructure allows you to size VMs with differing combinations of CPU and RAM, which is contrary to other hyperscalers that have specific pre-defined combinations only
• Oracle Cloud Infrastructure regularly provides free certification exam offers

Incentivized

• Microsoft Access has not really changed at all for several years. It might be nice to see some upgrades and changes.
• The help info is often not helpful. Need more tutorials for Microsoft Access to show how to do specific things.
• Be careful naming objects such as tables, forms, etc. Names that are too long can get cut off in dialog boxes to choose a table, form, report, etc. So, I wish they would have resizable dialog boxes to allow you to see objects with long names.
• I wish it could show me objects that are not in use in the database for current queries, tables, reports, forms, and macros. That way unused objects can be deleted without worrying about losing a report or query because you deleted the underlying object.

Incentivized

• Learning curve: is big. Newbies will face problems in understanding the platform initially. However, with plenty of online resources, one can easily find solutions to problems and learn on the go.
• Backup and restore: MySQL is not very seamless. Although the data is never ruptured or missed, the process involved is not very much user-friendly. Maybe, a new command-line interface for only the backup-restore functionality shall be set up again to make this very important step much easier to perform and maintain.

Incentivized

• Navigating the UI takes lots of getting used to. It reminds me of older GCP (just to get used to where everything is).
• Permission for different things always seemed to be more difficult than it really needed to be. Once you got them set up you were good but updating anything or creating new permissions for just about anything took longer than I thought it should.
• Based on how the buttons were laid out, it was pretty easy to delete all of your DNS records, and backing them up was not as intuitive as I'd like with the UI, but it was easy to do using a script.

Incentivized

I and the rest of my team will renew our Microsoft Access in the future because we use and maintain many different applications and databases created using Microsoft Access so we will need to maintain them in the future. Additionally, it is a standard at our place of work so it is at $0 cost to us to use. Another reason for renewing Microsoft Access is that we just don' t have the resources needed to extend into a network of users so we need to remain a single-desktop application at this time.

For teaching Databases and SQL, I would definitely continue to use MySQL. It provides a good, solid foundation to learn about databases. Also to learn about the SQL language and how it works with the creation, insertion, deletion, updating, and manipulation of data, tables, and databases. This SQL language is a foundation and can be used to learn many other database related concepts.

Incentivized

Reliability: Very dependable and stable OCI services have been for the business operations.Performance: The speed and efficiency of OCI in meeting their computing and storage needs.Scalability: The ease and effectiveness of scaling resources up or down to accommodate changing demands.Security: The robustness and effectiveness of OCI's security features in protecting their data and applications.

Incentivized

Microsoft Access is easy to use. It is compatible with spreadsheets. It is a very good data management tool. There is scope to save a large amount of data in one place. For using this database, one does not need much training, can be shared among multiple users. This database has to sort and filtering features which seem to be very useful.

Incentivized

I give MySQL a 9/10 overall because I really like it but I feel like there are a lot of tech people who would hate it if I gave it a 10/10. I've never had any problems with it or reached any of its limitations but I know a few people who have so I can't give it a 10/10 based on those complaints.

The services & products in Oracle Cloud Infrastructure needs more improvement to beat other Cloud service providers. The price is good & Security processes are good. We are requiring to put more effort in supporting this Oracle Cloud Infrastructure than other Cloud service providers. Probably better ways are there but is not super easy to find or not super available

I don't think the program has ever failed me. It is one of those programs where there is always a solution if you know where to look.

Incentivized

Yeah sometimes we had to face unplanned outages due to underlying infrastructure issues, so not every time,e but once in a while we face issues with availability. But the good thing is we have redundancy with DR setup and multi region so we can manage.

Incentivized

From the start, I was surprised by response times and image quality accessing windows VMs with RDP. GCP, Azure and -many offerings in AWS- don't perform this speed. Also, that's evident in the quality of Infrastructure Management Team, because I just received one warning regarding a region failure, what confirms that's a mature platform.

Incentivized

While I have never contacted Microsoft directly for product support, for some reason there's a real prejudice against MS Access among most IT support professionals. They are usually discouraging when it comes to using MS Access. Most of this is due to their lack of understanding of MS Access and how it can improve one's productivity. If Microsoft invested more resources towards enhancing and promoting the use of MS Access then maybe things would be different.

Incentivized

We have never contacted MySQL enterprise support team for any issues related to MySQL. This is because we have been using primarily the MySQL Server community edition and have been using the MySQL support forums for any questions and practical guidance that we needed before and during the technical implementations. Overall, the support community has been very helpful and allowed us to make the most out of the community edition.

Incentivized

Overall it is amazing, there is always room for improvement. We have weekly updates that tend to slow the program used more and more. We had to change some reports within Oracle because the others wouldn’t load. This is tied to our payroll and the delays are causing many time constraint issues and panic. We have to create a new report when one breaks. Otherwise awesome!

Incentivized

Effective training provided, much data productivity while doing training

Incentivized

detailed and easy to understand.

Incentivized

there is no key idea, since it is easy to implement Microsoft Access

1. Estimate your data size. 2. Test, test, and test.

Incentivized

Easier way to implement, vary much supportive way doing the implementation

Incentivized

Excel is a fantastic - robust application that can do so much so easily. Its easy to train and understand. However - excel does not provide a reporting function and that is typically where we will suggest a move to [Microsoft] Access. [Microsoft] Access requires a little more knowledge of data manipulation.

Incentivized

MongoDB has a dynamic schema for how data is stored in 'documents' whereas MySQL is more structured with tables, columns, and rows. MongoDB was built for high availability whereas MySQL can be a challenge when it comes to replication of the data and making everything redundant in the event of a DR or outage.

Incentivized

We used Microsoft Azure and Docker earlier and faced some difficulties like Microsoft Azure and Docker. Occasionally, the generation of large images can delay deployment. It is also necessary for me to admit that Microsoft Azure and Docker have a somewhat steep learning curve. Proper paperwork needs to be there. Docker has issues with performance on a number of platforms. On the other hand, OCI is easy to deploy and easy to understand.

Incentivized

was not part of initial purchase team. Anyways, i think unit pricing and billing frequency is good compared to other Cloud service providers, when it comes to Cloud Capital expenditure & Operational expenditure. Would be more interested in exploring more options where customers can get more cost relaxations on trying out new cloud services in Oracle Cloud Infrastructure for example a new App or a feature

We have hosted around 500 + customers on this cloud so till day not faced any major issues, so we can use it for any kind of products and it can hold the load and easily scale based on need.

Incentivized

Services & Infra wise is ok to use & host applications & services. Security wise also good for a Cloud service provider. It is a interesting area to explore & using it for day to day needs can be further improvised in future probably. Modern day Services like AI and Machine learning could be improved

• Not having to recreate queries or reports every time you want to use them.
• Once an item is created and saved as part of the database, you save manpower by not having to recreate them.
• ROI from a usability standpoint is great. Solid product with great functionality that requires low maintenance usually.

Incentivized

• As it is an open source solution through community solution, we can use it in a multitude of projects without cost license
• The acquisition by Oracle makes you need to contract support for the enterprise version
• If you have knowledge about oracle databases, you can get more out of the enterprise version

Incentivized

• Oracle Cloud helps us build and deploy apps quickly, getting our products out the door faster.
• With real-time insights from Oracle Cloud, we can give customers personalized experiences that boost satisfaction.
• Migrating to Oracle saves us cash on hardware and maintenance, which we can use for innovation and growth.

Incentivized