Big Data SQL Cloud Service

home nav

View Accounts

Back Oracle Account

Cloud Account Sign in to Cloud Sign Up for Free Cloud Tier

Contact Sales

No results found

Your search did not match any results.

We suggest you try the following to help find what you're looking for:

Check the spelling of your keyword search.
Use synonyms for the keyword you typed, for example, try “application” instead of “software.”
Try one of the popular searches shown below.
Start a new search.

Big Data SQL Cloud Service

Oracle Big Data SQL Cloud Service enables organizations to immediately analyze data across Apache Hadoop, NoSQL and Oracle Database leveraging their existing SQL skills, security policies and applications with extreme performance. From simplifying data science efforts to unlocking data lakes, Big Data SQL makes the benefits of Big Data available to the largest group of end users possible.

Find Out More

Product Features

Open all Close all

Integrated Metadata

Specialized External Tables

Big Data SQL gives users a single location to catalog and secure data in Hadoop and NoSQL systems: Oracle Database.

Seamless Integration

Seamless metadata integration and queries which join data from Oracle Database with data from Hadoop and NoSQL databases.

Automatic Mappings and Access

Utilities and conversion routines support automatic mappings from metadata stored in HCatalog (or the Hive Metastore) to Oracle Tables. Enhanced access parameters give administrators the flexibility to control column mapping and data access behavior.

Multi-Cluster Support

Multiple cluster support enables one Oracle Database to query multiple Hadoop clusters and/or NoSQL systems within a single query.

Optimized Performance

Smart Scan

Locally filtered data
Join optimization via Bloom filters
Scoring for data mining models and enhanced processing for JSON or XML

Optimizations for External Storage Formats

Prune partitions from tables managed by Apache Hive
Minimize I/O on files stored in Apache Parquet and Apache ORC formats
Enable remote reads on data stored in Oracle NoSQL Database or Apache HBase

Storage Indexes

Storage Index technology ensures that data blocks that are not relevant to the query are not read.

Secure across All Data

Simplification

Standard Oracle Database roles and privileges to govern access to data across platforms, simplifying security set up through a unified system.

Data Redaction

Ensures that sensitive information is obscured when accessed by unauthorized users.

Advanced Security Functions

Virtual Private Database functionality to better enforce governance policies.

Life Cycle Management

Copy to Hadoop

Oracle Big Data SQL includes the Oracle Copy to Hadoop utility enabling data copy in:

Parquet or ORC file formats
Oracle Data Pump Formats

Smart Scan on TableSpaces in HDFS

Enables immutable archive data within a table to reside in HDFS. Database queries access this data exploiting the optimized access and storage structures (like indexes) for fast query performance.