Oracle Database

Oracle has long been the world’s largest RDBMS vendor and is now a global provider of enterprise cloud computing, offering modern SaaS, PaaS and IaaS solutions. The company employs more than 132,000 people worldwide. With over 430,000 customers and deployments, Oracle offers a comprehensive stack of data management solutions, enterprise applications and cloud services, as well as platform services and engineered systems.

Over several decades and technology cycles, Oracle has built a very strong foundation and an unmatched footprint in the world of data management, analytics and data-driven business solutions. For many years, the Oracle Database, including the Oracle Data Warehouse Builder, was its primary focus, core competence and main reason for the company’s extraordinarily good reputation. With these tools working together, DWH systems could be implemented on a database originally developed for OLTP workloads. The relational database has been developed significantly since version 11 to support analytical workloads while valuable functions and in-memory options have been added. The current version (21c at the time of writing) supports all facets of modern data management, from in-memory over JSON to machine learning. Oracle Database is widely used today, and also often as the basis for data warehouse systems. and forms the constantly enhanced basis for Oracle’s Autonomous Data Warehouse.

In the area of data and analytics, the Oracle portfolio includes data integration and data quality solutions, solutions for master data management, industry solutions, IoT solutions and more. For data storage, Oracle offers not only the Oracle Database but also systems optimized for analysis. For on-premises installations, Oracle Exadata and the Oracle Big Data Appliance offer powerful, massively parallel query engines, which are delivered preconfigured with the appropriate hardware. These technologies are also available in the cloud. Here, Oracle pushes the Autonomous Data Warehouse, a cloud database service, which can serve different workloads for BI, analytics and machine learning as well as transactional workloads. In addition, NoSQL database services are available for the implementation of special applications.

The Oracle Database itself is a massively parallel database, which can be distinguished from other databases primarily through its shared disk architecture. In addition to storage on disk, in-memory is also available and storage organization forms optimized for analytics are supported for different data formats. The database has matured over the years so there are numerous configuration options for data management, which allow granular settings. One example is the data protection functions, which permit data anonymization down to field level. In response to the hype around digitalization and the rise of analytics, the Oracle Database has been upgraded to support “big data workloads”. This refers primarily to the storage and query of poly-structured data.

With the introduction of Oracle 21c at the end of 2020, Oracle released a new technical generation of its core database platform, containing many improvements, new capabilities and innovations. Oracle 21c is the first release to be designed as a ‘cloud first’ database, supporting deployments as a ‘Cloud Virtual Machine DB System’ (single node or cluster) or as a ‘Cloud Bare Metal DB System’, but will later also support on-premises scenarios (expected in 2021). With 21c, Oracle follows and strengthens its strategy to offer a “converged database”, meaning that all kinds of database paradigms (e.g., relational, time series, graph, spatial, text, OLAP or JSON data) can be delivered from within a single, unified platform. This makes a lot of sense, as users can take advantage of the various approaches for different use cases without the need to manage and master multiple technologies or even vendors. This also reduces the need for data movements to a minimum. The data can stay in one place and be processed in many ways.

User & Use Cases

The main purpose of the database is obviously data warehousing/BI, as it has been used in this way for years. Although there is a multi-storage concept implemented to provide a single platform for multiple use cases, customers are not using it today to a great extent. However, it should be noted that all users in this survey are using older versions of the Oracle Database. While data storage and data integration are easy to understand, the use of the database for data preparation is surprising. For years, Oracle Database has been known as a platform that is highly configurable to a very deep technical level. But this configurability also has its downsides: it requires expert, highly skilled, technical people. And that is reflected in the experience we have had with Oracle in the market. The finding that business users in 55 percent of companies perform data preparation with Oracle databases is not what we expected.

The Oracle Database is mainly used in midsize and large companies. It therefore follows that there is a high number of users working with the database (the mean is 1955). If we exclude users without SQL knowledge, the number is impressively high. These figures show that Oracle installations are widespread within companies and implementations have a rather strategic character. Unsurprisingly, there is a mean of 15 administrators per installation, which is above average. Complexity in general is a hiccup Oracle Database is known for. However, the survey reveals that only 6 percent complain of ‘complexity in operation’. As a result, we should assume that this high amount of administrators is needed for bigger server farms instead of single Oracle implementations.

Current use

n=33

Total number of users per company

n=33

Total number of administrators per company

n=29

Company size (number of employees)

n=33

Want to see the whole picture?

BARC’s Vendor Performance Summary contains an overview of The Data Management Survey results based on feedback from Oracle Database users, accompanied by expert analyst commentary.

Contact us to purchase the Vendor Performance Summary

Oracle Database

Peer Groups Analytical Database Products, Business Software Generalists (data management), Data Warehouse Technologies
VendorOracle
Number of responses33
ProductOracle Database
Offices295
Employees132,000
Customers430,000
Revenues (2020)$40.5 billion (in total, no isolated figures for Oracle Database available)
Websitewww.oracle.com