Loading…
View analytic
Wednesday, March 21 • 9:45am - 10:45am
Leveraging Partitioned External Tables: Primer and Practical Examples

Sign up or log in to save this to your schedule and see who's attending!

Feedback form is now closed.
Oracle Database 12is the first release to offer the capability to access a file in HDFS or HIVE format as an external table. Through live and recorded demonstrations, this session will explain how an Oracle DBA can leverage these new features to gather data in tabular format from these file formats while leveraging the best tool ever designed to filter, sort, aggregate, and report information: Structured Query Language. Through presentations and online demonstrations, this session will:
• Review the growing need to access big data in different file formats stored in NoSQL databases and data lakes.
• Illustrate how to leverage Oracle Big Data SQL to access and process data in other formats.
• Provide practical boundaries for leveraging these techniques to access data in various external formats

Agenda:
1. Big Data and IoT: Beyond Simplistic Rows and Columns
2. A Sharper Knife You Already Own: The Case for SQL vs. NoSQL
3. New EXTERNAL Table Drivers: ORACLE_HDFS and ORACLE_HIVE
4. Leveraging Partitioning and Parallelism with EXTERNAL Tables
5. Practical Examples of Leveraging Big Data Access Drivers
6. Now, a Warning: Limitations of Big Data SQL and Its New Drivers

Speakers
avatar for Jim Czuprynski

Jim Czuprynski

Oracle ACE Director, ViON Corporation
Jim Czuprynski has 35+ years of professional experience in his career in information technology, serving diverse roles at several Fortune 1000 companies before becoming an Oracle DBA in 2001. He was awarded the status of Oracle ACE Director in March 2014 and is a sought-after pub... Read More →



Wednesday March 21, 2018 9:45am - 10:45am
0110, Lower Level 1655 East Campus Center Drive, Salt Lake City, Utah 84112