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
 

8:30am PDT

Analytics and Data Summit 2018 Opening Remarks Tuesday
Dan Vlamis will introduce Analytics and Data Summit 2018 and Spatial Summit leaders will introduce the Spatial Summit during opening talks on Tuesday.

Speakers
avatar for Mark Hornick

Mark Hornick

Senior Director, Oracle
Mark Hornick is the Senior Director of Product Management for the Oracle Machine Learning (OML) family of products. He leads the OML PM team and works closely with Product Development on product strategy, positioning, and evangelization, Mark has over 20 years of experience with integrating... Read More →
avatar for Tracy McLane

Tracy McLane

GIS / Engineering VPD Lead, Bechtel Infrastructure
Tracy McLane has been a Bechtel Distinguished Scientist since 2012, and served as the GIS Technical Discipline Lead for the company from March 2007 to February 2018. In this role, she was responsible for the development of the GIS Technical Center of Excellence, the Enterprise... Read More →
avatar for Nick Salem

Nick Salem

Distinguished Engineer, Neustar
A Distinguished Member of the Technical Staff at Neustar, Nick is the Principal Software Architect behind the ElementOne platform and has over 20 years developing enterprise geospatial analytics applications. He holds 21 Oracle Certified Professional / Expert / Specialist credentials... Read More →
avatar for Dan Vlamis

Dan Vlamis

President, Vlamis Software Solutions, Inc.
Dan Vlamis is President and founder of Vlamis Software Solutions, a boutique consultancy which has led more than 200 Business Analytics implementations for more than 25 years at many of the world’s leading organizations. Recognized by Oracle as an Oracle ACE Director, he consults with Oracle Product Management regularly. Dan covers Oracle Analytics... Read More →


Tuesday March 20, 2018 8:30am - 9:00am PDT
1-Auditorium

9:00am PDT

Oracle Autonomous Data Warehouse Cloud and Oracle Analytics Cloud—Better Together!
Oracle Autonomous Data Warehouse Cloud is the industry’s first self-driving, self-securing, self-repairing database cloud service, offering you high availability, performance and security without human intervention. Oracle Autonomous Analytics Cloud is the industry’s leading cloud analytics platform, empowering you to achieve broader, deeper, and faster insights with augmented analytics in a hands-free platform. Join Oracle executives Andy Mendelsohn and Waqar Hasan to hear how Oracle’s new Cloud services leverage AI and machine learning to redefine the state-of-the-art for data warehousing and analysis, so you can ask any question of any data and get better answers faster

Speakers
avatar for Waqar Hasan

Waqar Hasan

Senior Vice President, Oracle Big Data Analytics
Dr. Hasan serves as Senior Vice President with responsibility for development of analytics products. Prior to Oracle, he was Senior Vice President of Data at Visa with responsibility for Visa’s data platform and data-driven products targeted at 15,000 banks, 40 million merchants and... Read More →
avatar for Andy Mendelsohn

Andy Mendelsohn

Executive VP, Database Server Technologies, Oracle
Andrew Mendelsohn is executive vice president for database server technologies at Oracle. He is responsible for the development and product management of Oracle’s family of database products including Oracle Database, Oracle TimesTen In-Memory Database, Oracle Berkeley DB, and... Read More →


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

10:10am PDT

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 PDT
1-Auditorium

11:15am PDT

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.
Dan Vlamis is President and founder of Vlamis Software Solutions, a boutique consultancy which has led more than 200 Business Analytics implementations for more than 25 years at many of the world’s leading organizations. Recognized by Oracle as an Oracle ACE Director, he consults with Oracle Product Management regularly. Dan covers Oracle Analytics... Read More →


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

12:20pm PDT

Lightning Round
Join us for our lightning round presentations by our sponsors. These are about 4-minute presentations by each sponsor, moving quickly between sponsors. Come have lunch with us! You can also download each of the sponsors' presentations.

Speakers
avatar for Robert Brown

Robert Brown

Kumaran
Providing Technology Engineering Services, Sales, Business Development, contract negotiations, ERP solutions, software development and IT services to enterprise and technology companies. Also, specializing in software & technology business development in the Silicon Valley and Southern... Read More →
avatar for Hayk Chakhchakhyan

Hayk Chakhchakhyan

Head of Marketing, Fivetran
Data Pipelines, ETL, ELT, Data warehousing, BI, Analytics, SQL, Snowflake, Redshift, Looker, Tableau, BigQuery.
avatar for Julie Herd

Julie Herd

Director, Technical Marketing, E8 Storage
E8 Storage is a pioneer in shared accelerated storage for data-intensive, high-performance applications that drive business revenue. E8 Storage’s affordable, reliable and scalable solution is ideally suited for the most demanding low-latency workloads, including real-time analytics... Read More →
avatar for Peter Koutroubis

Peter Koutroubis

Sr. VP of Operations, ERPA
Eighteen years of Information Technology consulting services experience with eight plus years specifically focused on Oracle technologies. Extensive experience in program and project management in data warehousing and business intelligence. Public Sector Contribution Award from the... Read More →
avatar for Kirby Lunger

Kirby Lunger

Partner, Performance Architects
Kirby Lunger is a Partner at Performance Architects, a leading business and technology consulting firm focused on enterprise analytics (analytics, BI and EPM). She maintains over 22 years of experience in the consulting, internet services, and software markets. She is the Co-Chair... Read More →
avatar for Steve MacCabe

Steve MacCabe

Application Specialist, Safe Software Inc.
Steve has been employed with Safe Software as an FMETechnology Expert since 2011.  His role is helping customers solve theirdata interoperability challenges with a particular focus on FME Server clients.Steve is also FME Certified in Desktop, Server and as a FME Trainer. Prior tothis... Read More →
avatar for Dave Madan

Dave Madan

Managing Director, Qubix, Inc.
We help businesses (big and small) maximize their return on investment for Oracle Business Analytics, Enterprise Performance Management & Big Data. Our recipe for success is our desire to innovate and re-imagine how Oracle EPM and BI solutions are deployed to reduce complexity and... Read More →
avatar for Jay Mason

Jay Mason

Associate Partner | Analytics, IoT & Cybersecurity, M&S Consulting
Digital Transformation Architect: AI, Machine Learning, Big Data, Iot and Cybersecurity20 years of IT consulting experience for commercial and government clients. Senior architect and project manager helping enterprises migrate streaming analytics to modern cloud-based architectures... Read More →
avatar for Sarath Menon

Sarath Menon

Global Partner Manager, HERE Technologies
As partners for more than 17 years, Oracle has relied on HERE Technologies to deliver high quality digital map data and robust location cloud services. Integrating mapping, analytics, geocoding, and routing, our data and location cloud services have helped power Oracle products, including... Read More →
avatar for Richard Solari

Richard Solari

Managing Director, Deloitte Consulting LLP
Richard Solari is a Director in the Deloitte Analytics and Information Management Practice and currently serves as the Oracle Business Intelligence and Analytics National Practice Lead.  Mr. Solari’s primary area of focus and expertise is Oracle Data Warehousing, Business... Read More →
avatar for Tim Tow

Tim Tow

Founder and President, Applied OLAP, Inc
Tim Tow is the Founder and President of Applied OLAP and the visionary for the innovative Dodeca product line. He has been working exclusively with Oracle Essbase since 1995, specializing in the Essbase Java API. An Oracle ACE Alumni, Tim blogs on Essbase topics, leads the development... Read More →
avatar for Dan Vlamis

Dan Vlamis

President, Vlamis Software Solutions, Inc.
Dan Vlamis is President and founder of Vlamis Software Solutions, a boutique consultancy which has led more than 200 Business Analytics implementations for more than 25 years at many of the world’s leading organizations. Recognized by Oracle as an Oracle ACE Director, he consults with Oracle Product Management regularly. Dan covers Oracle Analytics... Read More →
avatar for Matt Vranicar

Matt Vranicar

President & CEO, DataRoad Technologies LLC
An entrepreneur with experience starting firms and managing them on sound business principles, I am a strong believer in optimism, positive attitude and not accepting any limits. I continually look forward to my next set of challenges, opportunities and successes. Failure is not... Read More →


Tuesday March 20, 2018 12:20pm - 1:10pm PDT
1-Auditorium

1:10pm PDT

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 PDT
5-Rm 105

1:10pm PDT

Powerful Spatial Features You Never Knew Existed in Oracle Spatial and Graph
Even expert users may not know some of the powerful functions available in Oracle Spatial and Graph, or how to optimize common spatial requirements. I often find myself working with customers that implement spatial requirements the way they had to with other spatial solutions, instead of the best way they can by leveraging powerful unique capabilities available in Oracle Spatial and Graph. Many times the reason is "I didn't know that existed". This session will cover how Oracle Spatial and Graph natively integrates with key Oracle Database features such as transparent data encryption (TDE), redaction, partitioning (all types), and also powerful nearest neighbor strategies, new spatial functions introduced in 12c, as well as an overview of spatial functions you never knew existed. Customer use cases and code examples will be included. This session is intended for a technical audience, but others will also gain useful insights on the powerful capabilities of Oracle Spatial and Graph.

Speakers
avatar for Daniel Geringer

Daniel Geringer

Spatial Solutions Specialist, Oracle Corporation
Spatial Solutions Specialist -- Joined Oracle in 1995 to work on Oracle's spatial technologies -- Works with customers and partners around the world to solve spatial requirements in a scalable manner. -- Test, benchmark, and develop Oracle spatial technologies on Oracle Engineered... Read More →


Tuesday March 20, 2018 1:10pm - 2:00pm PDT
3-Rm 103

1:10pm PDT

HOL: Machine Learning 101 with Oracle Data Miner and ADWC's Machine Learning Notebook
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Learn the fast and way to perform machine learning using SQL Developer 17.2’s Oracle Data Miner drag and drop workflow UI. Learn from multiple experts in the room who will provide 1:1 coaching, guidance and instruction as requested in performing several hands on tutorials. Ask questions, get answers and come away with a comfort level of using Oracle’s machine learning capabilities in your use cases.
Also, try the new Oracle Machine Learning (OML) Zeppelin-based notebook for the Autonomous Data Warehouse Cloud (ADWC). OML extends Oracle’s offerings for data science in the cloud. OML’s collaborative, notebook environment helps data scientists built, share, document and automate data analysis methodologies that run in ADWC. Come learn about how easy it is to use Oracle’s newest SQL notebook technology to access and view data and build and deploy predictive machine learning models.

Speakers
avatar for Charlie Berger

Charlie Berger

Sr. Dir. Product Mgmt, Oracle Machine Learning, AI, Oracle
Charlie Berger is the Sr. Director of Product Management, Machine Learning, AI and Cognitive Analytics in Oracle Server Technology. Since 1999, he has been responsible for Oracle’s machine learning—starting when Oracle acquired Thinking Machines Corporation where he was VP of... Read More →
avatar for Karl Rexer

Karl Rexer

President, Rexer Analytics
My company: www.RexerAnalytics.comI started Rexer Analytics in 2002. We're a small data science, predictive modeling & analytic CRM consulting firm. We help clients explore and understand their customers' needs, market to them more effectively, and use data to make better strategic... Read More →
avatar for Tim Vlamis

Tim Vlamis

VP and Analytics Strategist, Vlamis Software Solutions, Inc.
An Oracle Ace and expert in the visualization of data and the design of business analytics strategies, Tim combines a strong background in the application of Oracle-based business analytics and data mining with extensive experience in business modeling and valuation analysis. Tim... Read More →


Tuesday March 20, 2018 1:10pm - 3:20pm PDT
6-Bldg 500

2:30pm PDT

Feeding a Hungry World: Using Oracle Products to Ensure Global Food Security
The International Production Assessment Division (IPAD) of the USDA’s Foreign Agricultural Service predicts two of the leading economic indicators: Global Agricultural Output and US Agricultural Output.
The Division uses a convergence of evidence approach that incorporates observation and ground truth but is also heavily dependent on remotely sensed satellite (raster) data.
IPAD’s approach has been to unpack rasters and store them as vectors in database rows and columns and then to create derivative products. Decades of product development were built on this model.
Vectorizing rasters is slow and wasteful. With pixel sizes decreasing from 25 km to 10 km for IPAD's main data streams in 2018, data size and CPU usage are expected to grow by a factor of 2.5.
IPAD will stop preparing rolled up answers to questions that may never be asked. This presentation will focus on the use of Oracle technologies including the native SDO_GEORASTER type, Columnar In Memory, and the Exadata.

Speakers
avatar for Bertin Noutchang

Bertin Noutchang

Sr Software Engineer, USDA/Asrc Federal
Mr. Noutchang has over 25 years of experience in software development, database design and Database administration. He is currently employed by InuTeq LLC as Sr software Engineer and is assigned to the International Production Assessment Division of the USDA Foreign Agricultural Service... Read More →
avatar for Mark Pelletier

Mark Pelletier

Database Engineer Senior Principal, USDA/Inuteq LLC
Mr. Pelletier has approximately 30 years of experience in sviceoftware development, database design, systems architecture and program management. He is currently employed by InuTeq LLC and is detailed to the International Production Assessment Division of the USDA Foreign Agricultural... Read More →


Tuesday March 20, 2018 2:30pm - 2:55pm PDT
3-Rm 103

2:30pm PDT

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 PDT
2-Rm 102

2:55pm PDT

3D Spatial Utility Database at CALTRANS
The California Department of Transportation (CALTRANS) was awarded a federal grant to create a spatial database for the purpose of collecting utility data and locations. Oracle 12c was chosen as the spatial database software and Bentley Map Enterprise V8i (SELECTseries4) was chosen as the software to interface with Oracle 12c. Autodesk Civil 3D and Arc GIS will eventually link to the database.
The multitenant architecture of Oracle 12c is being utilized; pluggable databases were created to separate data by CA Coordinate Systems (CCS). Within the pluggable database, tablespaces were created to separate the CCS zones.
 It is essential that 3D geometry is stored and the Spatial Reference System Identifier (SRID) value be assigned to the Oracle geometry so that coordinates can be re-projected from one coordinate system to another. Compound Coordinate Systems were created.
Creating and maintaining a utility database with a standardized set of data attributes will ensure that the utility infrastructure can be accurately identified during project planning and for conflict resolution during design and construction. This system can easily be adapted to other disciplines.

Speakers
avatar for Donna Rodrick

Donna Rodrick

Transportation Surveyor, CALTRANS
I graduated from CA State University, Fresno with a degree in Surveying Engineering and Applied Mathematics. I have worked for the California Department of Transportation as a Transportation Surveyor for over 25 years; working in San Luis Obispo and Fresno for the first 4 years in... Read More →


Tuesday March 20, 2018 2:55pm - 3:20pm PDT
3-Rm 103

3:35pm PDT

Forecasting the storm recovery resource allocation in electric utility network
A leading cause of power outages in the US is weather driven equipment failure events. Oracle utility customers are seeking machine learning techniques (recommended by the USDOE) to improve real-time risk assessment for critical assets based upon incoming weather forecast. Given an accurate prediction for the location, type, and amount of the storm-damaged equipment, the utility company can position the right number of specialized crews and material resources ahead of time. We develop a novel machine-learning model trained on the history of asset failures and reported weather. Since the weather-reporting stations might be far from the assets and some weather data measurements might be missing, we interpolate the weather conditions at the asset locations using a triangularization function computed with a barycentric coordinates technique implementation. We report performance comparison of multiple machine learning models to recommend the best damage prediction tool.

Speakers
avatar for Kenny  Gross

Kenny Gross

Architect, Oracle
Kenny C Gross, PhD, is an AI Architect in Oracle's Physical Sciences Research Center in San Diego, CA. Kenny specializes in advanced pattern recognition and prognostic anomaly discovery for Big Data applications in IoT industries, life sciences, and business business-critical data... Read More →
avatar for Andrew Vakhutinsky

Andrew Vakhutinsky

Consulting Member of Technical Staff, Oracle
Andrew Vakhutinsky is a Consulting Member of Technical Staff at Oracle Labs. He has Ph.D. in Operations Research from University of Maryland, College Park, and M.Sc. in Physics and Applied Mathematics from Moscow University of Physics and Technology. Andrew's previous experience includes... Read More →


Tuesday March 20, 2018 3:35pm - 4:05pm PDT
4-Rm 104

3:35pm PDT

18c Spatial New Features Update
With the Oracle Database 18c release, Oracle Spatial and Graph brings new performance and usability features across the board to complement features introduced in Oracle Database 12c Release 2. This release also makes it easy to develop spatial applications in Oracle Cloud. Spatial now supports distributed transactions, making it easy to develop web applications that update spatial data.  More geometry types can be converted between SDO_GEOMETRY and JSON formats, and Oracle REST Data Services supports spatial queries.  Sharding support (introduced in 12.2) is now extended to spatial tables and indexes. Web services are enhanced to support multiple data sources so that a single web service instance can serve data from different database schemas, and CSW 2.0.2 ISO metadata application profiles are supported. GeoRaster now supports many GDAL functions via external procedures.  
Learn what’s new with the leading spatial platform that’s fast, cloud-ready, and developer-friendly.


Speakers
avatar for Siva Ravada

Siva Ravada

Senior Director of Engineeting, Oracle, USA
Siva manages the development team for Oracle’s spatial technologies. He is one of the founding members of the development of Spatial technologies in Oracle since the Oracle7 release. He holds numerous patents, has several journal and conference publications, and authored a book... Read More →


Tuesday March 20, 2018 3:35pm - 4:05pm PDT
3-Rm 103

4:20pm PDT

Architecture Live - Designing an Analytics Platform for the Big Data Era
Don't miss the Architecture Live experience! In this interactive session, you'll witness two industry experts digitally illustrating data-driven architectures live, with input and feedback from the audience.

Kafka, Lambda, and Streaming Analytics will be all covered. We’ll tell you what these words mean, and more importantly how they affect the choices we make building an enterprise architecture. With the Oracle Information Management Reference Architecture as the backdrop, we'll clarify and delineate the different components involved in delivering big data, fast data, and all the gray area in between. The Architecture Live experience will be fun and different, and we'll all learn something along the way.

Speakers
avatar for Stewart Bryson

Stewart Bryson

Owner, Red Pill Analytics
Stewart is the Owner and Co-founder of Red Pill Analytics, and has been designing and implementing BI systems since 1996. He is an Oracle ACE Director, is an internationally recognized writer and speaker in the Oracle Community, and co-host for the audio and video podcast See Data... Read More →
avatar for Jean-Pierre Dijcks

Jean-Pierre Dijcks

Master Product Manager, Oracle
Highly experienced product manager with 15 years of experience in enterprise software and enterprise data. Currently responsible for all product management aspects (technology, GTM, Enablement etc.) of Oracle Big Data Appliance and Big Data Cloud Service at Oracle.Active interest... Read More →


Tuesday March 20, 2018 4:20pm - 5:10pm PDT
1-Auditorium

4:20pm PDT

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 PDT
5-Rm 105
 
Wednesday, March 21
 

9:00am PDT

Advanced Dashboard Techniques: Ultimate 360 Student View
Learn how Florida International University takes advantage of the OBIEE Business Intelligence technologies for report design, end-user interactive tools and data delivery. From requirement and validation phases to benefits realized from using the dashboard as a centralized source for actionable data.

Speakers
avatar for Ayodele Osikoya

Ayodele Osikoya

Business Intelligence Developer, Florida International University
Ayodele Osikoya has over 5 years of diversified experience in the areas of Business Intelligence and Business Process Improvement. He has experience in requirement analyses, data mining ,forecasting and statistical analysis. Currently, he and his team are implementing the Florida... Read More →


Wednesday March 21, 2018 9:00am - 9:25am PDT
4-Rm 104

9:00am PDT

Analyze the Global Knowledge Graph with Visualization, Cloud, & Spatial Tech
Every 15 minutes the world’s news is captured into the Global Knowledge Graph. The data set contains nearly a trillion sentiment snapshots and more than 1.5 billion location references. 
Oracle ingested the data set on the Bare Metal Cloud to create a data warehouse. The project was designed to meet the needs of big data users, such as cyber threat and defense intelligence analysts. They require analysis of the connections between people, places, events, content and sentiment embedded in traditional data sources. They also need a pipeline and robust visualizations to filter the data, carve out relevant subsets and save the results to a property graph database for further analysis.
This session will describe the challenges, complexities, and technologies used to create a 35TB data warehouse, and filter, visualize, analyze and write results back, with a single click, to the Oracle Spatial and Graph database using Tom Sawyer Perspectives.

Speakers
avatar for Kevin Madden

Kevin Madden

Chief Software Engineer, Tom Sawyer Software
With more than 20 years of experience in the software industry, Kevin Madden brings an innovative approach to Tom Sawyer Software. Originally the third software engineer at Tom Sawyer Software, today he plays a strategic role in the direction of the company's server-based products... Read More →


Wednesday March 21, 2018 9:00am - 9:50am PDT
3-Rm 103

9:25am PDT

Comprehensive Cloud Analytics on Oracle Planning and Budgeting Cloud Service!!!
In this session, you will learn how DiLytics integrated Oracle Planning and Budgeting Cloud Service (PBCS) data into Oracle Analytics Cloud Service. DiLytics designed a Data Warehouse for Planning and Budgeting Analytics and developed a package to load data from Oracle Planning and Budgeting Cloud Service into the data warehouse. This enabled creation of metrics, KPIs and Dashboards in Oracle Analytics Cloud for extensive insight into the PBCS data. This empowered City of Oakland’s Financial Planning team to analyze budget details, actual spend, planned position details by job class, one-time and ongoing costs, Variance by department, etc. FP&A team is able to get insight into performance of planning process, effectiveness of budget, etc.

Speakers
avatar for Shyam Panda

Shyam Panda

Founder and President, DiLytics Inc
Data Integration, Analytics, Business Intelligence. Shyam was Product Manager for BI Applications at Oracle. In his current role, Shyam:- Consults with customers on their current situation in the evolution of BI/Analytics in their enterprise- Recommends the best course of actions... Read More →


Wednesday March 21, 2018 9:25am - 9:50am PDT
4-Rm 104

10:05am PDT

Data Integration in the Cloud Era
With the drastic rise in cloud offerings from Oracle, developers and users are scrambling to integrate data from on-premise and cloud solutions. This can range from small file transfers containing financial data to solutions for tools like Essbase Cloud Services, to large data sets containing millions of records sourced from a data warehouse loaded into Oracle Analytics Cloud (OAC). We also find ourselves integrating across cloud applications (for example, sourcing data from financial systems for reporting and analytics in other cloud tools). This presentation focuses on the gears that move the data, and presents an array of options and best practices to manage data integration and data movement. Come learn about a variety of methodologies available, as well as a cross-product overview. Finally, hear about real world examples, and how data integration actually works with various Oracle cloud products.

Speakers
avatar for Thomas Blakeley

Thomas Blakeley

Manager / Architect, Performance Architects Inc
Tom Blakeley is a Manager & Architect at Performance Architects, with over six years of experience with business analytics solutions, utilizing Oracle Essbase, Hyperion Planning, and Oracle Business Intelligence to name a few. His specialties include consulting, IT, corporate finance... Read More →


Wednesday March 21, 2018 10:05am - 10:55am PDT
1-Auditorium

10:05am PDT

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

Senior BI Consultant, US-Analytics
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 PDT
4-Rm 104

11:10am PDT

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 PDT
4-Rm 104

11:10am PDT

Operationalizing Machine Learning
Most data science projects begin with data, “tools” and scripts but fail to get beyond the data scientist. They hit a wall when attempting to “operationalize” the models. Netflix never implemented the algorithm that won the Netflix $1 Million Challenge. This dichotomy between enterprise and algorithms is eliminated when algorithms are built into the data management platforms. By “moving algorithms to the data”, Oracle Database and Big Data Clouds are now data management and advanced analytical platforms. “Robots” can replicate human tasks by capturing best practices discovered in the data and automating that process using machine learning deployed models. Developers use SQL, R and Oracle Data Miner UI to build, evaluate and deploy advanced analytical methodologies. See how to go beyond “tools” to enabling RPA (robotic process automation) applications. Several Oracle “predictive” Applications will be shown as examples._x000D_

Speakers
avatar for Charlie Berger

Charlie Berger

Sr. Dir. Product Mgmt, Oracle Machine Learning, AI, Oracle
Charlie Berger is the Sr. Director of Product Management, Machine Learning, AI and Cognitive Analytics in Oracle Server Technology. Since 1999, he has been responsible for Oracle’s machine learning—starting when Oracle acquired Thinking Machines Corporation where he was VP of... Read More →


Wednesday March 21, 2018 11:10am - 12:00pm PDT
2-Rm 102

11:10am PDT

HOL: Oracle Big Data SQL: Analyze Data Across Oracle Database, Hadoop, and NoSQL
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Organizations are capturing data in a variety of data stores including Oracle Database, NoSQL, and Hadoop. Oracle Big Data SQL allows you to use Oracle SQL and security policies to seamlessly query across these stores. This means that existing Oracle Database query applications—without changes—will now be able to take advantage of this new information. This hands-on lab introduces you to how this is achieved: providing access to big data sources, implementing unified security, and delivering analyses that combine and correlate all data.

Speakers
avatar for Martin Gubar

Martin Gubar

PM Director, Oracle
I'm part of Oracle's big data product management team - with a key focus on Big Data SQL. I have a long history at Oracle - starting in the sales consulting organization - and then working in the BI, OLAP and Big Data PM groups


Wednesday March 21, 2018 11:10am - 1:50pm PDT
6-Bldg 500

1:00pm PDT

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 PDT
4-Rm 104

4:30pm PDT

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 PDT
5-Rm 105
 
Thursday, March 22
 

8:45am PDT

Leveraging Analytics in Higher Education
Big data is still a trending topic in higher education and other industries. While understanding the importance of big data is critical, most universities are not leveraging the power of small data. Many data warehouse implementations in higher education fail as they only provide reports that do not aid in improving daily business functions. This session will highlight various technologies and strategies in incorporating data and analytics into the institutional culture. Business intelligence is not just getting sophisticated reports but being integrated into the applications that students, faculty, advisors, and staff use daily. Data and analytics should be used to drive processes and provide alerts when interventions are needed. This session will provide an overview of how Valdosta State University have integrated data into the academic and administrative functions of the university, leading to improved insight and value.

Speakers
avatar for Brian Haugabrook

Brian Haugabrook

CIO, Valdosta State University
IT executive with extensive experience in business intelligence, data analysis, enrollment and retention management. Ability to blend leadership, strategic vision, innovation, and technical expertise to define and deliver a campus-wide vision and strategic plan for all academic and... Read More →


Thursday March 22, 2018 8:45am - 9:35am PDT
4-Rm 104

8:45am PDT

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 PDT
6-Rm 106

9:00am PDT

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 PDT
5-Rm 105

12:00pm PDT

Oracle Big Data SQL: What's happening under the covers?
You may have heard that Oracle Big Data SQL allows applications to query data across Oracle Database, Hadoop and NoSQL stores. This session will step you thru its architecture. You'll learn how Big Data SQL fits into the Oracle Database and Hadoop infrastructure, how it leverages standards for data access and how it optimizes query execution to achieve good performance. The session will help you understand how you can leverage your Oracle Database investment and effectively augment your analyses with data from across the big data stack.

Speakers
avatar for Martin Gubar

Martin Gubar

PM Director, Oracle
I'm part of Oracle's big data product management team - with a key focus on Big Data SQL. I have a long history at Oracle - starting in the sales consulting organization - and then working in the BI, OLAP and Big Data PM groups


Thursday March 22, 2018 12:00pm - 12:30pm PDT
1-Auditorium

1:30pm PDT

Headache Due To Merger or Acquisition? Here's The Prescription for Financials
This session will describe a customer success story where the customer needed to quickly replace the budget/forecasting and financial reporting systems of a large business unit they had acquired (or they would face severe penalties). The customer is a large financial services company that is based in Jersey City, NJ (2.9bn annual revenues).

The customer chose to implement PBCS and BICS and have them run on Oracle DbaaS. Apps Associates performed the implementation and developed near real time integration across PBCS, BICS, EBS R12 and Workday. Apps Associates’ BICS Financial Accelerator was used to load data from EBS R12 into BICS/DbaaS and provide financial reporting. BICS was implemented as the single BI solution for all financial reporting and analysis - including drill down to detail.

The PBCS/BICS platform is now being rolled out to other areas of the organization.

Speakers
avatar for Myles Gilsenan

Myles Gilsenan

Practice Director, Apps Associates
Myles is a Director with Apps Associates and has more than 20 years of global experience in the design and deployment of large scale data warehousing and analytics solutions.  He spent the first 10 years of his career at a Big 4 consulting firm leading international ERP and BI deployments... Read More →


Thursday March 22, 2018 1:30pm - 2:20pm PDT
2-Rm 102

1:30pm PDT

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 PDT
4-Rm 104

3:40pm PDT

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 PDT
2-Rm 102
 

Twitter Feed