Oracle Big Data SQL Licensing
- Licenses are required for each Hadoop cluster.
- All data nodes within a cluster must be licensed.
- Every disk drive accessed by the tool needs a license ($4000 per drive).
- Includes Oracle Database server-side components and WebLogic Server.
- It covers Oracle Copy to Hadoop and metadata storage for the Query Server.
Oracle Big Data SQL is a unique tool for querying data across Oracle Database, Hadoop, and NoSQL data stores. However, understanding its licensing policy can be challenging.
This article aims to demystify the Oracle Big Data SQL licensing policy for you, including the licensing requirements for Hadoop clusters, data nodes, and disk drives, as well as the included licenses for Oracle Database server side, Oracle Copy to Hadoop, and WebLogic Server.
Oracle Big Data SQL Licensing: The Basics
Oracle Big Data SQL licensing is separate from the licensing for other Oracle products.
When you purchase a license for Oracle Big Data SQL, there are several key points to note:
- A separate license is required for each Hadoop cluster. This means that if you have multiple Hadoop clusters, you must purchase a separate license for each one.
- All data nodes within the Hadoop cluster must be licensed. Partial licensing within a node is not an option.
- All disk drives accessed by Oracle Big Data SQL must be licensed. This includes disks used by Kafka or NoSQL stores when Oracle Big Data SQL accesses those sources.
- No additional license is required for the Oracle Database server side, and you won’t need to purchase an additional Oracle Big Data SQL license if you already use Oracle Database.
- Oracle Copy to Hadoop licensing is included in the Oracle Big Data SQL license. This allows you to copy data from Oracle Database to Hadoop without purchasing an additional charge.
- WebLogic Server is also included in Oracle Big Data SQL. No additional license is required for this.
- Oracle Big Data SQL includes a Query Server that queries data sources, including HDFS, Kafka, and NoSQL stores. It also includes a restricted-use license of Oracle Database for storing metadata (i.e., external tables and views) maintained by the Query Server. No other objects may be created in this Oracle Database.
Oracle Big Data SQL Licensing: Cost Per Disk Drive
Oracle Big Data SQL is licensed per disk drive; the license fee is USD 4000.
This means that the total cost of your Oracle Big Data SQL license will depend on the number of disk drives you have that Oracle Big Data SQL accesses.
In conclusion, while Oracle Big Data SQL offers powerful capabilities for querying data across various data stores, understanding its licensing policy is crucial to avoid non-compliance and unnecessary costs.
By understanding the licensing requirements for Hadoop clusters, data nodes, and disk drives, as well as the licenses included for the Oracle Database server side,
Oracle Copy to Hadoop and WebLogic Server, you can ensure that you’re making the most of your Oracle Big Data SQL investment.
Licensing Oracle Big Data SQL: Practical Explanation and Cost Analysis
Licensing Model Overview Oracle Big Data SQL licensing is distinct from other Oracle product licenses.
When you purchase an Oracle Big Data SQL license, you must meet several specific requirements, particularly those regarding Hadoop clusters and data nodes.
Licensing Requirements
- Hadoop Clusters
- Each Hadoop cluster requires a separate Oracle Big Data SQL license. For example, if you operate three Hadoop clusters, you need three licenses, one for each cluster.
- Data Nodes
- All data nodes within a Hadoop cluster must be licensed. Partial licensing (licensing only some nodes within a cluster) is not permitted. For instance, if a Hadoop cluster has 10 data nodes, you must license all 10 nodes.
- Disk Drives
- Every disk drive accessed by Oracle Big Data SQL needs to be licensed. This includes any disks used by sources like Kafka or NoSQL stores if Oracle Big Data SQL accesses those data sources. For example, if your Hadoop cluster uses 50 disk drives, each drive needs a license.
- Oracle Database and WebLogic Server
- You do not need additional server-side licenses if you already use Oracle Database. WebLogic Server is included in the Oracle Big Data SQL license, so no separate license is required.
Included Components
- Oracle Copy to Hadoop: This feature is included in the Oracle Big Data SQL license and allows data to be copied from Oracle Database to Hadoop without extra charges.
- Query Server: The license includes a Query Server that can query data sources such as HDFS, Kafka, and NoSQL stores. It also comes with a restricted-use license of Oracle Database for storing metadata managed by the Query Server.
Cost Analysis
- Per Disk Drive Licensing Fee
- Oracle Big Data SQL is licensed at USD 4000 per disk drive. For example, if your setup includes 100 disk drives that Oracle Big Data SQL will access, the total cost would be 100 drives x USD 4000 = USD 400,000.
Practical Example
Let’s consider a practical scenario to understand the licensing and cost implications:
- Scenario: A company runs two Hadoop clusters with 20 data nodes and 150 disk drives.
- Step 1: License each Hadoop cluster separately.
- 2 clusters x 1 license each = 2 licenses.
- Step 2: License all data nodes within each cluster.
- Cluster 1: 20 data nodes
- Cluster 2: 20 data nodes
- Step 3: License each disk drive.
- 150 disk drives x $4000 USD per drive = $600,000 USD.
- Step 1: License each Hadoop cluster separately.
FAQ: Oracle Big Data SQL Licensing
What is Oracle Big Data SQL?
Oracle Big Data SQL is a tool for querying data across Oracle Database, Hadoop, and NoSQL data stores. It provides a unified platform for data analysis.
Is Oracle Big Data SQL licensing separate from other Oracle products?
Yes, Oracle Big Data SQL licensing is independent and requires separate licenses specific to its use.
Do I need a separate license for each Hadoop cluster?
Yes, a separate license is required for each Hadoop cluster.
Are all data nodes within a Hadoop cluster required to be licensed?
Yes, all data nodes within the cluster must be licensed. Partial licensing is not allowed within a cluster.
Do I need to license all disk drives accessed by Oracle Big Data SQL?
Every disk drive accessed by Oracle Big Data SQL must be licensed, including those used by Kafka or NoSQL stores.
What is the cost per disk drive for Oracle Big Data SQL licensing?
The cost is USD 4000 per disk drive accessed by Oracle Big Data SQL.
Does the license include Oracle Database server-side components?
The license includes Oracle Database server-side components, so no additional license is required.
Is Oracle Copy to Hadoop included in the Oracle Big Data SQL license?
Yes, Oracle Copy to Hadoop is included, allowing data to be copied from Oracle Database to Hadoop without additional charges.
Does Oracle Big Data SQL include a WebLogic Server?
Yes, WebLogic Server is included in the Oracle Big Data SQL license, and no additional licensing is needed.
What is the purpose of the Query Server included in the license?
The Query Server enables querying data sources like HDFS, Kafka, and NoSQL stores. It also includes a restricted-use license of Oracle Database for storing metadata.
Do I need to license metadata storage separately?
No, the restricted-use Oracle Database license for metadata storage is included with the Oracle Big Data SQL license.
Can Oracle Big Data SQL be used across multiple clusters?
Each cluster requires its license, but the tool can be applied across clusters if licensing requirements are met.
Is there flexibility in licensing fewer data nodes or drives?
No, all data nodes and drives accessed by Oracle Big Data SQL must be fully licensed.
How can I calculate the total cost for Oracle Big Data SQL licensing?
Multiply the number of disk drives by USD 4000. For example, if you have 100 disk drives, the total cost is 100 x $4000 = USD 400,000.
What happens if I don’t license all required components?
Non-compliance with Oracle Big Data SQL licensing policies can lead to penalties and additional costs during audits. It’s important to ensure full compliance.
