Welcome to the Autonomous Database Must-See guide for OpenWorld 2019. This guide covers everything you need to know about this year's event so that when you...
Welcome to the Autonomous Database Must-See guide for OpenWorld 2019. This guide covers everything you need to know about this year's event so that when you arrive at the Moscone Conference Center in September you are ready to get the most out of this truly amazing conference. This Must-See guide is available in both PDF and Apple iBook formats. The iBook format can be downloaded directly from the iTunes Store to your Mac OS or iOS device or you can download the actual iBook...
Welcome to the Autonomous Database Must-See guide for OpenWorld 2019. This guide covers everything you need to know about this year's event so that when you arrive at the Moscone Conference Center in...
One of the popular new Big Data SQL features is its Query Server. You can think of Query Server as an Oracle Database 18c query engine that uses the Hive...
One of the popular new Big Data SQL features is its Query Server. You can think of Query Server as an Oracle Database 18c query engine that uses the Hive metastore to capture table definitions. Data isn’t stored in Query Server;  it allows you to access data in Hadoop, NoSQL, Kafka and Object Stores (Oracle Object Store and Amazon S3) using Oracle SQL. Installation and Configuration Architecturally, here’s what a Big Data SQL deployment with Query Server looks like: There...
One of the popular new Big Data SQL features is its Query Server. You can think of Query Server as an Oracle Database 18c query engine that uses the Hive metastore to capture table definitions. Data...
I’m excited to announce the availability of Big Data SQL 4.0. This release is packed with new capabilities: Query more sources – including Oracle Object Store...
I’m excited to announce the availability of Big Data SQL 4.0. This release is packed with new capabilities: Query more sources – including Oracle Object Store and S3 Query data without requiring an Oracle Database using Big Data SQL Query Server Enhanced query processing – pushing aggregations to the Hadoop cluster nodes Support Apache Sentry authorization rules Support for CDH 6 Continued improvements to the install process Big Data SQL 4.0 can be downloaded from...
I’m excited to announce the availability of Big Data SQL 4.0. This release is packed with new capabilities: Query more sources – including Oracle Object Store and S3 Query data without requiring an...
Big Data SQL 4.0 introduces a data processing enhancement that can have a dramatic impact on query performance:Â distributed aggregation using in-memory...
Big Data SQL 4.0 introduces a data processing enhancement that can have a dramatic impact on query performance: distributed aggregation using in-memory capabilities. Big Data SQL has always done a great job of filtering data on the Hadoop cluster. It does this using the following optimizations: 1) column projection, 2) partition pruning, 3) storage indexes, 4) predicate pushdown. Column projection is the first optimization. If your table has 200 columns – and you are only...
Big Data SQL 4.0 introduces a data processing enhancement that can have a dramatic impact on query performance:Â distributed aggregation using in-memory capabilities. Big Data SQL has always done a...
You may have spotted from all the recent online news headlines and social media activity that we launched a new service for transactional workloads - ATP...
You may have spotted from all the recent online news headlines and social media activity that we launched a new service for transactional workloads - ATP Dedicated. It allows an organization to rethink how they deliver Database IT, enabling a customizable private database cloud in the public cloud. Obviously this does not affect you if you are using Autonomous Data Warehouse but it does have a subtle impact because our UI has had to change slightly. You will notice in the top...
You may have spotted from all the recent online news headlines and social media activity that we launched a new service for transactional workloads - ATP Dedicated. It allows an organization to...
Autonomous Data Warehouse (ADW) now supports outgoing database links to any database that is accessible from an ADW instance including Database Cloud Service...
Autonomous Data Warehouse (ADW) now supports outgoing database links to any database that is accessible from an ADW instance including Database Cloud Service (DBCS) and other ADW/ATP instances. To use database links with ADW, the target database must be configured to use TCP/IP with SSL (TCPS) authentication. Since both ADW and ATP use TCPS authentication by default, setting up a database link between these services is pretty easy and takes only a few steps. We covered the...
Autonomous Data Warehouse (ADW) now supports outgoing database links to any database that is accessible from an ADW instance including Database Cloud Service (DBCS) and other ADW/ATP instances. To use...
Oracle introduced Autonomous Data warehouse over a year ago, and one of the most common questions that customers ask me is how they can move their data/schema's...
Oracle introduced Autonomous Data warehouse over a year ago, and one of the most common questions that customers ask me is how they can move their data/schema's to ADW (Autonomous Data Warehouse) with minimal efforts. My answer to that is to use datapump, also known as expdp/impdp. ADW doesn't support traditional import and export, so you have to use datapump. Oracle suggests using schema and parallel as a parameter while using datapump. Use the parallel depending upon the...
Oracle introduced Autonomous Data warehouse over a year ago, and one of the most common questions that customers ask me is how they can move their data/schema's to ADW (Autonomous Data Warehouse) with...
You have finally gotten your ducks in a row to future proof your data storage, and uploaded all your necessary production data into Oracle Cloud's object store....
You have finally gotten your ducks in a row to future proof your data storage, and uploaded all your necessary production data into Oracle Cloud's object store. Splendid! Now, how do you get this data into your Autonomous Database? Here I provide some practical examples of how to copy over your data from the OCI object store to your Autonomous Data Warehouse (ADW). You may use a similar method to copy data into your Autonomous Transaction Processing (ATP) instance too. We...
You have finally gotten your ducks in a row to future proof your data storage, and uploaded all your necessary production data into Oracle Cloud's object store. Splendid! Now, how do you get this data...
I would like to provide here some practical examples and best practices of how to make use of the powerful data loading and querying features of the Autonomous...
I would like to provide here some practical examples and best practices of how to make use of the powerful data loading and querying features of the Autonomous Data Warehouse (ADW) in the Oracle Cloud. We will dive into the meaning of the more widely used parameters, which will help you and your teams derive business value out of your Data Warehouse in a jiffy! An extremely useful feature of this fully managed service is the ability to directly query data lying in your...
I would like to provide here some practical examples and best practices of how to make use of the powerful data loading and querying features of the Autonomous Data Warehouse (ADW) in the Oracle...
