Loading…
  • Sessions appear in the color of their primary track
  • Sessions can be filtered using Products on the right
  • Use the Search bar for more flexibility
See this link for hints on how to search the schedule or sign up for sessions

Sign up or log in to bookmark your favorites and sync them to your phone or calendar.

Data Warehousing and SQL [clear filter]
Tuesday, March 20
 

10:10am

Oracle Autonomous Data Warehouse Cloud: Easy, Fast and Highly Elastic
Oracle recently expanded its Data Management Cloud portfolio with the addition of the Oracle Autonomous Data Warehouse Cloud Service to help customers and partners with the deployment of data-mart or data warehouse environments to gain faster insights from their critical business data. Oracle Autonomous Data Warehouse Cloud is the first of many cloud services built on the “self-driving” Oracle Autonomous Cloud Database technology. This service is integrated with applied machine learning to deliver unmatched high performance, reliability, and instant elasticity.
Oracle Autonomous Data Warehouse Cloud uses the same Oracle Database software and technology found in existing on-premises data warehouse deployment, and is compatible with Oracle’s in-database machine learning algorithms, analytics and BI tools, as well as popular 3rd party offerings. Oracle Autonomous Data Warehouse Cloud is simple to deploy, enabling traditional data mart environments or new monetization use cases.\

Speakers
avatar for George Lumpkin

George Lumpkin

Vice President, Product Management, Oracle
George Lumpkin is Vice President of Product Management for Oracle data warehouse solutions.  George has been with Oracle for twenty-six years, and has a tenured experience across database, data warehouse, big data and analytics foundations. He also has a degree from Harvard University... Read More →


Tuesday March 20, 2018 10:10am - 11:00am
1-Auditorium

11:15am

Architecting for Analytics
This session answers architecture questions related to the overall structure and strategy for an enterprise analytics system. How do we design a data warehouse for analytics purposes? What do we integrate into a central warehouse or maintain in separate data marts? How do we integrate long term storage systems that we need to query only occasionally? Data lakes? Big Data?? What are the tradeoffs with different tools and how much do we invest in custom code? How do we integrate real-time data streaming? What ETL and integration strategies are we going to use? Where and how do we extend our raw data with calculated measures and analytic functions? How do we create a system that has a strong foundation, but can grow and evolve over time? This presentation will draw from real-world data architecture projects that were designed with analytics in mind.

Speakers
avatar for Mike Caskey

Mike Caskey

Senior Consultant, Vlamis Software Solutions
As a senior consultant, I am a veteran Oracle data warehouse architect and a Software Engineer. While I have solid experience working with transactional systems, my specialty has been data warehouse and business intelligence applications. I bring tremendous data warehouse experience... Read More →
avatar for Dan Vlamis

Dan Vlamis

President, Vlamis Software Solutions, Inc.


Tuesday March 20, 2018 11:15am - 12:05pm
2-Rm 102

1:10pm

Oracle Database In-Memory - Real-Time Analytics
Oracle Database In-Memory introduces a new in-memory columnar format that is compatible with all existing applications. Join Oracle Product Management to learn in detail what motivated Oracle to develop this new technology and how it works alongside the traditional row format to provide a unique “dual format” architecture. This session will explore how Database In-Memory enables "Real-Time Analytics" by allowing analytic style queries to be run directly on source data. It will also explore the key performance enhancing features of Database In-Memory including in-memory scans, predicate push down, hash joins with bloom filters, vector group by aggregation, and new high-performance features like In-Memory Expressions and Join Groups. The session will conclude by exploring how the new in-memory functionality interacts with key database performance features such as Real Application Clusters (RAC), Partitioning, parallel execution, and much more.



Speakers
avatar for Andy Rivenes

Andy Rivenes

Product Manager, Oracle
Andy Rivenes is a Senior Principal Product Manager at Oracle Corporation and is a Product Manager for Database In-Memory. Prior to that Andy was a Product Manager for Heat Map, Automatic Data Optimization, SecureFiles and DBFS. Andy has been working with Oracle products since 1992... Read More →


Tuesday March 20, 2018 1:10pm - 2:00pm
5-Rm 105

2:30pm

Accelerating Joins and Aggregations on the Oracle In-Memory Database
Analytic workloads are dominated by joins, aggregations, and scans. In-Memory columnar databases have optimized scans using compressed data formats and SIMD vectorization techniques, but have made little impact to the rest of the query execution plan. The Oracle Database In-Memory (DBIM) Option introduced new SQL execution operators that accelerate analytic queries by optimizing aggregation over joins for star schemas. Group-by expressions are pushed down into the scans of dimension tables, creating a unique key per distinct group called a Dense Grouping Key (DGK). A Key Vector is allocated that maps join keys to DGKs, which is used to filter non-matching rows during the fact table scan. Passing rows are then aggregated directly on compressed codes into DGK-indexed result buffers using SIMD. Our solution replaces traditional join and group-by processing (bloom filters, hash table build/probe, etc) with blazing fast inlined scan operators, improving query elapsed time by as much as 10X.

Speakers
avatar for Shasank Chavan

Shasank Chavan

Vice President, In-Memory Technologies, Oracle
Lead an amazing team of brilliant engineers in the Database organization responsible for developing Oracle's In-Memory Column Store. We currently are hyper-focused on leveraging emerging hardware technologies to build the next-generation data storage engine that powers the cloud... Read More →
avatar for Ekrem Soylemez

Ekrem Soylemez

Architect, Oracle
I have been working in Oracle RDBMS development for 23 years. During that time, I have worked on data storage, Oracle OLAP, and most recently the SQL engine.  My current focus is improving performance of analytic queries, particularly those that are run against In-Memory Columnar... Read More →


Tuesday March 20, 2018 2:30pm - 3:20pm
2-Rm 102

4:20pm

Bringing your Data Warehouse to the the Lake
As early as 2001 Enterprise Data Warehousing (EDW) design patterns like "Corporate Information Factory" (CIF) began to emerge. Theses patterns established EDW as the central focus of reporting. Current BI/DW 1.0 projects still follow these patterns today. Problems in the BI/DW 1.0 methodology have appeared. Increases in data volume, variety and velocity have all created considerable challenges for this legacy architecture. In this presentation we will review the legacy of BI/DW 1.0 and dive into the future BI/DW 2.0 and 3.0 architectures. Taking a close look and advanced staging areas, operational data stores and how those architectures can be used for cloud facilitation in BI/DW 2.0. Additionally, this presentation will drive into the BI/DW 3.0 data tipping point and where various Oracle products fit in these new emerging modern data architectures.

Speakers
avatar for Jeremy Simmons

Jeremy Simmons

Managing Consultant, DataRoad Technologies
A business and technology consultant with over 20 years of experience in delivering value to organizations by closing the gap between business needs and IT capabilities. I take a hands on approach to delivering technical work, with a strong ability to speak to and gather C-Level requirements... Read More →


Tuesday March 20, 2018 4:20pm - 5:10pm
5-Rm 105
 
Wednesday, March 21
 

10:05am

Analyzing and resolving performance through aggregation tables in OBIEE 12c
This presentation will cover the process of resolving performance issues in OBIEE 12c. We will explain how to analyze poorly performing reports and dashboards. How to view the sql behind poorly performing analytics and dashboards. Explain the process implementing aggregate tables to improve performance.

Speakers
avatar for Ervin Mcfadden

Ervin Mcfadden

Consultant, Independent Consultant
Certified Professional Business IntelligenceOver fifteen years of Accounting and Information Systems experience. Extensive use of Oracle Business Intelligence Enterprise Edition (OBIEE), Oracle Financial / Manufacturing Applications and development tools. Including the following Oracle... Read More →


Wednesday March 21, 2018 10:05am - 10:55am
4-Rm 104

11:10am

What's New in Oracle Database 18c
Oracle Database recently switched to new annual Release Model with Oracle Database 18c the first annual release in the new model. This session is a unique opportunity to get ahead of the curve and learn what's new in Oracle Database 18c directly from the Oracle Database development team.

Speakers
avatar for Penny Avril

Penny Avril

Vice President, Oracle
Penny Avril is a Vice President in Oracle Server Technology Division, leading product management for Oracle Database. Penny works with release and development management on taking the product from design spec through development to production. Her team runs the customer advisory board... Read More →


Wednesday March 21, 2018 11:10am - 12:00pm
4-Rm 104

1:00pm

Cloud Data Center, Infrastructure, Analytics and integration. Mind the gap!
There is a long list of products and services, but what do I need for Analytics? Is it just the Cloud service? Can I simply connect everything? Let's get to the bottom of this. Let’s get a holistic view on the infrastructure for hybrid cloud analytics. These topics are based on an onshore/offshore industry company moving it's analytics to the cloud, while having to deal with offshore locations as well.
This session will elaborate on how Analytics Cloud, RDC, VPN, GoldenGate, Data Integrator, ETL, FastConnect, Internet Exchanges, your ISP and datacenters are related to each other. 
The case study is a datawarehouse and analytics platform in the Oracle Cloud connecting to on-premises sources. The analytics-to-the-cloud first approach is often a great start in the cloud, but at that time you need to think beyond running queries, offloading the ETL-load and moving BI users to the Cloud.
We will mind the gap and compare the upside and downside of different infrastructural approaches.

Speakers
avatar for Hasso Schaap

Hasso Schaap

Analytics Designer, Qualogy
Come talk with me about all kinds of Business Analytics and Business Process Management. Especially the Oracle Cloud Platform is in my interest. Just like specific Finance and Human Capital Management topics.I'm a certfied specialist in Business Analytics and Big Data.


Wednesday March 21, 2018 1:00pm - 1:50pm
4-Rm 104

4:30pm

Setting up Oracle BI with Amazon Redshift
So you want to use Oracle Business Intelligence but your organization doesn't have an Oracle Database, or maybe you do but most of your data sources are stored in a warehouse such as Redshift or Snowflake.

At first glance it might seem that Oracle BI is no longer an option, but don't worry -- it is. In this presentation, we'll guide the audience through the nuanced complexity faced when installing a JDBC Driver for the purpose of connecting Oracle Business Intelligence to a database that isn't Oracle. While we use Redshift as an example, the shared insights will be helpful for anyone connecting Oracle BI to any warehouse or database.

Speakers
avatar for George Fraser

George Fraser

CEO & Co-founder, Fivetran
George Fraser is co-founder and CEO of Fivetran, a fully managed data pipeline built for analysts. Fivetran is a Y Combinator-backed company with over 350 customers relying on it to centralize their data. When Fivetran began in 2012, they realized that ETL tools were ill-equipped... Read More →


Wednesday March 21, 2018 4:30pm - 5:00pm
5-Rm 105
 
Thursday, March 22
 

8:45am

Governance? Governance!! Ensuring Trust, Compliance and Collaboration
Join Oracle Engineering to hear real world use cases of how Oracle Customers have utilized Data Integration Platform Cloud – Governance Edition, DIPC-GE, as the foundation for data governance across their big data enterprise. This will include use case patterns, known pitfalls, as well as tips and tricks for future proofing your data governance investment. Oracle Engineering will review how our customers have utilized DIPC-GE to provide a proactive, trusted big data platform, which enables collaboration and enforces compliance across the enterprise. At the core of DIPC-GE is the data catalog which is used to create comprehensive catalog of data entities as well as business terms. The data catalog enables many advanced use cases within data governance, such as; data classification, data quality insights, data profiling, data lineage, impact analysis, AI/ML linkage of data assets to a business glossary, all with rich collaboration and built in flexible workflows and auditing. Join us!

Speakers
avatar for Jayant Mahto

Jayant Mahto

Product Manager, Oracle
Jayant Mahto has been working with Data Integration for the past 20 years. His history in Oracle dates back 15 years ago first developing Business Intelligence Applications and then as product manager for the Oracle Data Integrator and Oracle Metadata Management products.


Thursday March 22, 2018 8:45am - 9:35am
6-Rm 106

9:00am

A Day with Development – Autonomous Information Management in the Cloud Workshop
Limited Capacity filling up

This session is given by Oracle's Global Leaders organization.  Attendance is limited and requires a full-day commitment, as material builds throughout the day.

See https://eventreg.oracle.com/profile/web/index.cfm?PKwebID=0x519423abcd to sign up.

Join Cemil Alper, Consulting Member of Technical Staff, and Alexey Filanowisky, and more from Oracle Product Development at this in-depth workshop

In partnership with the Analytics and Data Summit, Global Leaders Program are offering a deeper dive full day class to Autonomous Data Warehouse Cloud. This class is open to all attendees of the A&D summit, and other approved registrants - contact Laura.j.mckechnie@oracle.com for further details and approval.

You will learn about Oracle's information management strategy in the Cloud, the different cloud services that are available in the information management space, with particular focus on the new Autonomous Data Warehouse Cloud Service (ADWC).

Content will cover a general architecture overview, various cloud service capabilities such as ADWC, Big Data Cloud Service (BDCS), Data Integration Platform Cloud (DIPC) and Oracle Analytics Cloud, and how to migrate existing environments to the Oracle Cloud Platform.

Finally, life on the cloud and how things change will be discussed.  

Supporting Your Needs
As this workshop aims to support your needs, you may be asked to complete a short survey about your current Oracle environment and workloads. If so, this survey will be sent via email following your registration.  


Speakers
avatar for Cemil Alper

Cemil Alper

Consulting Member of Technical Staff, Oracle
Cemil Alper is a Technical Lead in Global Leaders Program who is specialized in Data Warehousing and Big Data Technologies. He started his career at Oracle Turkey where he worked in Support, PreSales and Consultancy groups for 8 years. For the last 9 years, he has been part of the... Read More →
avatar for Alexey Filanovskiy

Alexey Filanovskiy

Product Manager, Oracle
I'm Alexey Filanovskiy - part of the development organization in Oracle. I use to be Oracle Developer, but since 2010 Hadoop world captivated me with his head. Since 2012 I'm working with Big Data technologies in Oracle. I've started my carrier in pre-sales organization and in 2015... Read More →


Thursday March 22, 2018 9:00am - 4:00pm
5-Rm 105

1:30pm

Migrating multilayer Data Warehouse from SAS SPDS to Exadata Database Machine – Migrating proceses by day, fighting with data by night
PZU is the largest financial institution in Central and Eastern Europe and the leader in Polish insurance market.  According to the new strategy, focuses on the growth through use of the latest technological achievements, such as process automation and artificial intelligence. Foundation for this is an efficient and modern Data Warehouse, which provides information about clients and processes taking place within          the company. For this purpose, the insurer undertook a migration project of current SAS SPDS solution to an innovative product - Exadata Database Machine. Thanks to collaboration of specialists from SAS and Oracle, migration to a new environment composed of the SAS Grid analytical platform and Exadata Database Machine, is possible. The migration process is a big challenge, but necessary to guarantee PZU's success in the future.

Speakers
avatar for Daniel Borkowicz

Daniel Borkowicz

DWH and BI Expert, PZU
avatar for Łukasz Bąkowski

Łukasz Bąkowski

DWH and BI Expert, PZU
avatar for Tomasz Przybyszewski

Tomasz Przybyszewski

Analytics Sr. Manager, Oracle
Regional Management - Sales and Marketing Management - Business Development Management - Customer and Partners Relationships Management - Leading the team of Analytics Sales and Co-Primes Team - Sells specialized set of Cloud & OnPremise Analytics (BI, Big Data, Artificial Intelligence... Read More →


Thursday March 22, 2018 1:30pm - 2:20pm
4-Rm 104

3:40pm

Oracle Database In-Memory Implementation and Usage
Oracle Database In-Memory is one of the most fascinating new database features in a long time, promising an incredible performance boast for analytics. This presentation provides a step-by-step guide on when and where you should take advantage of Database In-Memory, as well as outlining strategies to help you ensure you get the promised performance boast regardless of your database environments. These strategies include how to identify which objects to populate into memory, how to identify which indexes to drop, and details on how to integrate with other performance enhancing features. With easy-to-follow real-world examples, this presentation explains exactly what steps you need to take to get up and running on Oracle Database In-Memory.

Speakers
avatar for Andy Rivenes

Andy Rivenes

Product Manager, Oracle
Andy Rivenes is a Senior Principal Product Manager at Oracle Corporation and is a Product Manager for Database In-Memory. Prior to that Andy was a Product Manager for Heat Map, Automatic Data Optimization, SecureFiles and DBFS. Andy has been working with Oracle products since 1992... Read More →


Thursday March 22, 2018 3:40pm - 4:30pm
2-Rm 102
 

Twitter Feed