Oracle Database, currently in edition 23c, offers native support for property graph data structures and graph queries. If you're looking for flexibility to build graphs in conjunction with transactional data, JSON, Spatial, and other data types, we got you covered. Developers can now easily build graph applications with SQL using existing SQL development tools and frameworks.
N/A
Oracle ZFS
Score 8.2 out of 10
N/A
Oracle ZFS Storage Appliance is designed to power diverse workloads so users efficiently consolidate legacy storage systems and achieve universal application acceleration and reliable data protection for data.
I believe Oracle Database is still the best RDBMS database which is the database to consider for OLTP applications and for Adhoc requests. They are good in Datawarehousing in certain aspects but not the best. Oracle is also a great database for scaling up with their Clusterware solution which also makes the database highly available with services moving to the live instance without much trouble.
For scenarios where the implementation is an Oracle ecosystem and the need for high-performance storage is present, undoubtedly the ideal solution is Oracle ZFS due to the native integration that exists, for example, with SPARC equipment, Exadata, and traditional architecture running Oracle Linux or Solariums (depending on the case), as well as in highly demanding industries in terms of storage.
Software RAIDZ. Create storage arrays using best available RAID technologies for excellent disk stability
Array images and backups. Allows administrators to instantly create disk snapshots, to minimize time disk is unavailable (on the order of seconds, not minutes or hours).
Automatic de-deduplication/compression. ZFS will automatically de-dedup data on disk, allowing for more efficient use of the entire disk for unique data. It will also automatically compress data stored on the disk, allowing for even more usage of the available disk space. Great for infrequently accessed backups (There is some performance cost to compression).
Because it was due to a software originally designed for Solaris. configuration in other environments can be cumbersome for inexperienced implementers.
The proprietary particularity of this File System makes it in some cases very difficult to implement in highly heterogeneous environments.
I think that additional forms of integration with more environments should be created.
There is a lot of sunk cost in a product like Oracle 12c. It is doing a great job, it would not provide us much benefit to switch to another product even if it did the same thing due to the work involved in making such a switch. It would not be cost effective.
Many of the powerful options can be auto-configured but there are still many things to take into account at the moment of installing and configuring an Oracle Database, compared with SQL Server or other databases. At the same time, that extra complexity allows for detailed configuration and guarantees performance, scalability, availability and security.
1. I have very good experience with Oracle Database support team. Oracle support team has pool of talented Oracle Analyst resources in different regions. To name a few regions - EMEA, Asia, USA(EST, MST, PST), Australia. Their support staffs are very supportive, well trained, and customer focused. Whenever I open Oracle Sev1 SR(service request), I always get prompt update on my case timely. 2. Oracle has zoom call and chat session option linked to Oracle SR. Whenever you are in Oracle portal - you can chat with the Oracle Analyst who is working on your case. You can request for Oracle zoom call thru which you can share the your problem server screen in no time. This is very nice as it saves lot of time and energy in case you have to follow up with oracle support for your case. 3.Oracle has excellent knowledge base in which all the customer databases critical problems and their solutions are well documented. It is very easy to follow without consulting to support team at first.
Overall the implementation went very well and after that everything came out as expected - in terms of performance and scalability. People should always install and upgrade a stable version for production with the latest patch set updates, test properly as much as possible, and should have a backup plan if anything unexpected happens
Oracle is more of an enterprise-level database than Access and SAP Adaptive Server Enterprise isn't getting developed much (some people wonder how close it is to end of life) but SQL Server is miles ahead of Oracle IMO in terms of user experience and comparable in terms of performance AFAIK. As stated, a vendor forced our hand to use Oracle so we did not have a choice. If you are looking for help with an issue you are having, there are lots of SQL Server articles, etc. on the web and the community of SQL Server developers and DBA's is very strong and supportive. Oracle's help on the web is much more limited and often has an attitude that goes with it of superiority and lacking in compassion, IMO. For instance, check out the Ask Tom Oracle blog - a world of difference. If you choose Oracle, go into it with eyes wide open.
ZFS is so far beyond the other filesystems available right now, offering full suites of tools for data management, backup, recovery, maintenance, monitoring, etc. It's not even fair to compare them.
Oracle Database 12c has had a very positive impact on our ability to build strong and robust custom applications in house without the need to come up with our own methods of data storage and management.
Oracle Database 12c has the strongest user interface of any database I have worked with and continuously is improving its strength with the addition of support for JSON and XML type objects in the database.
Oracle Database 12c is sometimes very heavy and DBA intensive, but the benefits far outweigh the costs, which we need to spend on DBA support for enabling security and access features.
In highly transactional and data-intensive environments such as 200 million records per month or more.
Banking also represents an ideal niche for this type of implementation due to its high volume of data and the need for security in this industry with over 100 million records per day and online history maintenance for more than 10 years (in most cases).
The Return on Investment or ROI is clearly seen in the medium term since your storage solution would be in your safekeeping without having to pay anything additional to regular maintenance.