Oracle Database

This database will depend on your needs and the needs of your applications. Some applications must run on this database and there is no way around it. It is very stable but it will require a lot of table maintenance and resizing.

Oracle Databases can and should be implemented in a variety of industries, including the manufacturing environment. In our large organization, we have the advantage of sharing data across many function leaders within the company in order to maintain consistent product data. Small organizations may have trouble with the subscription cost, implementation fees, and/or the time/expertise necessary to maintain the software. It really needs to be taken seriously so it is a worthwhile investment.

In a scenario where large amounts of data need to be stored indefinitely and queried in a timely manner and the people/company involved have the funding to be able to purchase an Oracle database license without going bankrupt, I would recommend Oracle DB.

For any complex ERP and complex data warehouse it is the best. But it comes up short with regard to unstructured data and cost effectiveness.

Oracle works well with large data application. If you have small database needs, it can be too pricey

Oracle is suitable for applications that can benefit from storing input data in relational form and which write reports on that data.

It's amazing at data storage in large numbers and ties in very well as a JDBC data-source for a WebLogic middleware instance. A lot of our in-house applications are Java-based programs that source large amounts of data. The databases are often fed via Informatica, and then the WL Application will source the data and transform or aggregate as needed. Oracle has been a sufficient platform for this in the past, and 12c seems to continue this trend.

I create tons of financial reports that show the highs and lows of sales year over year as well as predictive analysis. Oracle is the tool used for me to get that data I need to create those reports. I also partner Oracle with R for create more granular views of the data I'm presenting.

Oracle Database does really well with complicated database solutions with its optimized performance using CPU resources. For those requiring a simple or basic database system, this product may be an overkill. It is also fairly expensive to procure, run, and expand. Many modules need to be purchased to achieve complete functionality. However it can be very flexible with allowing database designers to create specialized databases for specific data requirements or reporting tools.

Large systems, large projects. Environments where they have to unify many applications or working with legacy applications. If you implement a holistic system for an entire corporation, or ERP, or CRM, you need something as powerful as Oracle Database. If you work with complex server, you need to deploy Oracle Database. If you implement SAP, the best database will be Oracle. On the other hand, if you want to focus on a more specific application, or a startup, you'd better choose another database that will accelerate development times at the cost of much less power.

For ONLINE transactions oracle DB is well suited. In the case of, complex transaction involving many changing tables or data sets, oracle works best.

Oracle is not well suited for documents related data, big objects, pictures, videos etc.

Large scale databases whether OLTP, web apps or data warehouses. No database seems to handle scaling to extremely large sizes as Oracle does.

I would strongly recommend using Oracle to companies with corporate applications, or having processes with high data volume and / or need for processing. On the other hand, for small companies with few users or little volume of information to manage, it might not be justified by the cost of licensing and higher administration costs.

One can try with the Oracle Database Express Edition to see if the product matches their requirements. And if it suits their business needs then one can go for the standard or enterprise edition. Oracle Database is well suited for any type of organization ranging from small, medium or large scale industries. Since it is a renowned and highly used database, any third party integration tool will already have the database drivers enabled with Oracle DB for their third-party tool.

For an ever changing company, the ability to create customized database applications is golden. It's easy to work with large amounts of data. That allows us to discover patterns in this data over time. Solid platform, reliable, compatible, fast. Lots of good qualities plus excellent technical support. For a mid-sized company like ours, Oracle delivered power over our own information empowering our data analysis in a way we never were able to before. The best cost-benefit on the market!

There is no specific scenario: in general, you can use Oracle Database for any type of applications or workloads. However, I think it's more suitable when your database is big and performance is a must. Also, I recommend Oracle Exadata (the engineered version of Oracle Database) when you need to consolidate several installations in one single rack.

Oracle is well suited for large database and data mining operations such as used in the storage of millions of person records, financial aid records, payroll applications, and a plethora of back-end data storage and retrieval for major software applications. It's particularly easy to use with backup software, moving blocks of data, or creating full clones. We also feel it is very secure with its frequent releases of patches and PSUs. It could improve on troubleshooting and documentation, where many of the oracle DBAs have to network in order to solve particular problems, Oracle comes up a little short on being a reliable source for help at times.

It is extremely well suited as a staging platform for most popular BI tools in the market, it is robust and can be depended upon as an enterprise grade DBMS solution. However, Oracle in my experience is expensive and most of the clients I have worked with do not prefer expanding their Oracle infrastructure.

Smaller datasets that are running where you are scratching an itch. Running a business in the past, we opted for MySQL as we knew our industry was small and our needs were not going to require the power. Additionally, we choose MySQL for the event that we MIGHT have needed to upsize to a better database...in which case, Oracle would have been ideal. There are other lightweight DB areas where this might just be too encumbering (i.e., I used another DB to quickly gather information from IoT...but we'd export it out for analysis into various forms).

It's a RDBMS platform that helped us store a great amount of data with minimum hiccups.

Oracle Database 12c is good for medium and large size companies, due to its ability to handle large amounts of data and transactions. It does cost more, however. It is good for companies of any size that need 24 hour mission critical uptime for their software applications. Smaller companies just starting out might be better off picking one of the many low-cost cloud based options to start with. Many of them make moving to Oracle easy when the time comes.

Great platform for any advanced application, that must be scalable, multi-platform, and certainly supporting a multitude of data-related technologies, whether Java, XML, external tables, advanced analytics, or high-availability.

I wouldn't consider Oracle 12c for an appliance application data source (meaning runtime distributions), or even for applications with limited vertical or horizontal customer focus (such as a 100-customer e-Commerce website) simply because it's a 1000lb hammer for a 1lb nail. If I had to choose an Oracle-provided resource in those cases, Oracle MySQL shines as a much easier and lighter footprint data repository, which has superior performance, and some of the most popular performance features, in a low cost-of-entry price point.

Consider Oracle 12c for the following scenarios :

• Where data security is critical
• Where data availability is critical
• Where application downtime needs to be minimal
• Where you will be using HUGE data sets
• When you have senior support and budget for your project.

Don't use Oracle 12c when :

• You don't have a large budget
• Need to get your application/database up quickly
• You're using old(er) hardware
• Check compatibility with Oracle for your application. A lot of freeware apps and scripts are built off other databases and won't make use of the features within Oracle 12c

As a consultant, I have always worked with companies that use Oracle Databases and they have all been well suited to their business scenarios. These companies are small and large, public and private, and also either directly the government or a company that supports a government function.