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.

Database Enterprise Edition [clear filter]
Tuesday, March 20
 

10:10am PDT

Path to Data Architect: Hadoop, Spark, Flink, and Beam Explained to Oracle DBAs
Big Data is growing exponentially, requiring massive-scale infrastructure however, business analytics has shifted from reactive to proactive analysis; this is the era of streaming data (a.k.a. Fast Data). Apache Hadoop is very good for analyzing data at rest but cannot handle streaming data.
Big Data analytics needs new Big data frameworks. Apache Spark brings in-memory processing and RDD data abstraction which allow real-time processing of streaming data however its micro batch architecture incurs high latency. Apache Flink brings low latency and could address Spark limitations however it is not as mature and largely adopted as Spark.
Apache Beam promotes its portable Beam model across Big data frameworks (Spark, Flink, Dataflow).
Tis session presents and overview of the major Big Data frameworks and suggests that DBA should embrace these frameworks and expand their skills as a necessary path to becoming Data Architects.

Speakers
avatar for Kuassi Mensah

Kuassi Mensah

Director Product Management, Oracle Corporation
Kuassi is Director of Product Management at Oracle. He covers the following product areas (i) Java connectivity to DB  (Cloud,  on-premises): JDBC, JDBC Reactive Extensions, in-place DB processing with embedded JVM  (ii) Zero downtime, multi-tenancy, and sharding for Java apps... Read More →


Tuesday March 20, 2018 10:10am - 11:00am PDT
4-Rm 104

11:15am PDT

Turning Relational Database Tables into Spark Data Sources
Big Data Analytics requires unstructured data (a.k.a. Big Data) but also Master data generally stored in RDBMS tables.

Apache Spark furnishes the Spark SQL interface for querying unstructured data using SQL. This interface provisions the Datasource API with a JDBC interface for accessing relational databases. How to join RDBMS tables with Big data using Spark SQL without moving data over?

This session describes an implementation of the Spark Datasource API and explains the optimizations that (i) allow parallel and direct access to the RDBMS database (with the option of controlling the number of concurrent connections); (ii) introspect the RDBMS table, generate partitions of Spark JDBCRDDs based on the split pattern and rewrite Spark SQL queries into the RDBMS SQL; (iii) use hooks in the JDBC driver for faster type conversions; (iv) push down predicates to the RDBMS, prune partitions based on the where clause to reduce the amount of data returned to the RDBMS.

Speakers
avatar for Kuassi Mensah

Kuassi Mensah

Director Product Management, Oracle Corporation
Kuassi is Director of Product Management at Oracle. He covers the following product areas (i) Java connectivity to DB  (Cloud,  on-premises): JDBC, JDBC Reactive Extensions, in-place DB processing with embedded JVM  (ii) Zero downtime, multi-tenancy, and sharding for Java apps... Read More →


Tuesday March 20, 2018 11:15am - 12:05pm PDT
5-Rm 105

11:15am PDT

Autonomous Data Warehouse Cloud - Experiences of an Early Adopter
In the Cloud managed Data Warehouse services are still rare. Amazon Red Shift and Snowflake are examples of new contenders in the market place. At Oracle Open World Larry Ellison announced the Oracle Autonomous Data Warehouse Cloud service (ADWC). It shall become available at the turn of the calendar year as a fully managed DWH service, running on Exadata hardware.

sumIT took part in a preview programme in summer and autumn of 2017 and has gained insights and experience with the new service. In this presentation those experiences will be shared with the audience. Key features of the service, like its ease of provisioning, use, and interfacing other systems and clouds will be presented and also demonstrated.

Lessons learned will be told, the services sweet spot and limits be discussed. Moreover, AWDC will be compared to other managed DWH cloud services. This will illustrate the advantages AWDC gives customers, but will also help identify room for improvement in future AWDC versions.

Speakers
avatar for Holger Friedrich

Holger Friedrich

CTO, sumIT AG
Dr.-Ing. Holger Friedrich is co-founder and CTO of sumIT. sumIT is a Swiss based consulting firm, specialized on Data Warehousing, Business Intelligence, and Big Data projects. Holger holds a Ph.D. in computer science from the Karlsruhe Institute of Technology (KIT). He is a regular... Read More →


Tuesday March 20, 2018 11:15am - 12:05pm PDT
4-Rm 104

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

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

3:35pm PDT

HOL: Property Graph 101 in Oracle Database for the Completely Clueless
Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Oracle Database 12c now includes property graphs - a powerful feature that goes beyond relational, to analyze relationships in big data, such as finding the most influential people in a social network, discovering patterns of fraud within financial transaction data, or recommending products based on what similar customers are buying.
Don’t have the slightest clue on how to get started with and use property graphs? Good news! If you can form a complete sentence (coffee allowed) then you can do this! This hands on lab by Vlamis will show you exactly how to create, load and use property graphs on the Oracle Database. We will cover how to create a property graph using Java or PLSQL, how to load data into a property graph from existing database tables, how to create an in-memory instance of a property graph, how to run algorithms such as page rank against a property graph, how to use PGQL (a sql like language for property graphs) to query a graph and ways to visualize graph data.

In order to complete the hands on lab you will need to bring your own laptop with VNC Viewer installed (https://www.realvnc.com/en/connect/download/viewer/) so you can access the virtual machines we have set up for the lab.

Speakers
avatar for Arthur Dayton

Arthur Dayton

Senior Consultant, Vlamis Software Solutions Inc
Arthur Dayton is a business analytics and data integration professional who works as a Senior Consultant for Vlamis Software Solutions. He teaches technology fundamentals to students at the University of Nebraska Omaha and also shares technical knowledge on his blog https://helpm... Read More →
avatar for Cathye Pendley

Cathye Pendley

VP of Consulting Services, Vlamis Software Solutions, Inc.
Cathye has 23 years of experience working with Oracle Business Intelligence (BI) technologies; 14 of those years have been with Vlamis. Prior to entering the Oracle BI world, Cathye owned her own insurance agency. As VP of Consulting Services, Cathye leads the consulting organization... Read More →


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

4:20pm PDT

Ordnance Survey Ireland: National Mapping as a Service
Ordnance Survey Ireland (OSi), the Irish national mapping agency, maintains national spatial data sets and creates mapping products for government agencies and the public. Achieving a leadership role in national mapping requires addressing many challenges: dealing with the explosion of 3D terrain data from aerial photos and satellites, needing to automate complex workflow processes, handling 1.2+ petabytes of data holdings including geospatial data with scalability and security, and sharing data widely with the public._x000D_
_x000D_
With the Oracle Spatial and Graph, Database 12c, and Exadata platform, OSi has addressed these challenges. OSi uses Oracle Spatial and Graph point cloud, raster, and linked open data capabilities for solutions in the areas of Cartographic Automation, 3D Solid Geometry, Point Cloud Classification, Visualisation & Dissemination and Geospatial Linked Data. OSi is also looking toward cloud-based solutions using Oracle. Learn about OSi’s innovative geospatial solutions._x000D_
_x000D_

Speakers
avatar for Éamonn Clinton

Éamonn Clinton

General Manager, Geospatial Services, Ordnance Survey Ireland
Éamonn Clinton is the General Manager, Geospatial Services, Data Governance & Quality and Spatial Strategist with Ordnance Survey Ireland, the Irish national mapping agency. Éamonn has worked in the geospatial industry for over 20 years. He has worked on a large number of public... Read More →


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

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

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

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

1:00pm PDT

Using Machine Learning in OBIEE for Predictive Analytics and Actionable BI
This presentation focuses on unlocking the power of Data Science for data-driven decision support. It details the pragmatics of using Machine Learning techniques in OBIEE for actionable BI and Predictive Analytics from a business standpoint. Two industry use cases are presented to illustrate the implementation of the same using OBIEE 12c.

Speakers
avatar for Lakshman Bulusu

Lakshman Bulusu

Consultant, 1967
Lakshman Bulusu is a senior Oracle consultant with 25 years of experience in the fields of Oracle RDBMS, SQL, PL/SQL, EDW/BI/EPM,  Oracle-related Java and Oracle-related R, machine learning, Vertica and Alteryx. As an enterprise level data warehouse and BI solution architect/technical... Read More →


Wednesday March 21, 2018 1:00pm - 1:50pm PDT
2-Rm 102

4:30pm PDT

Anomaly Detection in Medicare Provider Data using OAAgraph
Graph analysis is an effective methodology in data analysis which considers fine-grained relationships between data entities. This session presents an example of anomaly detection using graph analysis on data stored in Oracle Database with Oracle R Enterprise and the OAAgraph package, using a real-world public data set.
Specifically, we analyze the public information of medical transactions from CMS (United States Center for Medicare and Medicaid Services) for the year 2012. We load this data set as a graph into Oracle Database, and use the OAAgraph package to apply graph analysis algorithms whose results are be visualized using R's ggplot2 visualization package. 
Our analysis successfully identifies suspicious records in the data set -- medical providers who perform procedures far from their specialties. We also discuss techniques how to reduce false positive outcomes. 

Speakers
avatar for Sungpack Hong

Sungpack Hong

Research Director, Oracle
Research Director at Oracle Labs.Leading projects regarding large-scale graph and data analysis -- platforms and applications
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 →
FM

Francisco Morales

Software Developer, Oracle Labs


Wednesday March 21, 2018 4:30pm - 5:00pm PDT
2-Rm 102
 
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

1:55pm PDT

Oracle Machine Leaning & Adaptive Intelligent Applications for Manufacturing
In this session learn about Oracle's soon to be released prepackaged "SaaS on PaaS" cloud applications called "Adaptive Intelligent Applications for Manufacturing". This product is built directly on top of several Oracle’s PaaS components to collect, store, and analyze massive amounts of Operational Technology (OT) data coming from shopfloor systems such as MES, quality systems, LIMS, Equipment, Test stations and contextualizes this data with Information Technology (IT) data residing in HCM/CRM/SCM/ERP applications in a single consolidated operational data store and analyzed by applying advanced analytics, data mining/data science, and AI techniques to discover key patterns and correlations from historical data related to manufacturing efficiencies and also provide actionable predictive analytics to improve yield, reduce defects, reduce scrap, minimize cycle times, manufacturing costs, and equipment downtime.

Speakers
avatar for Gopal Ratnam

Gopal Ratnam

Sr. Director, Product Management & Strategy, Oracle
Software leader with proven track record of product ideation, execution, and management of cutting edge SaaS solutions that enable business and digital transformation for enterprises. Drive performance through dynamic leadership, strategic planning, process design, product innovation... Read More →


Thursday March 22, 2018 1:55pm - 2:20pm PDT
1-Auditorium

3:40pm PDT

Using GeoJSON in the Oracle Database
Location and other geographical information is traditionally stored in Oracle databases using specialized data types, such as the SDO_GEOMETRY type. That data type is powerful and flexible, but can be difficult to use. A modern alternative is to use a JSON-based encoding, called GeoJSON instead. GeoJSON is a lightweight format suited to data exchange and transfer, popular for reading and publishing spatial data on the Web, in Big Data, and for the Internet of Things.

This session will explain the way GeoJSON encodes a variety of geographical objects, from simple points to complex multi-polygonal structures. It will also explain how those structures can be indexesd, and how they can be used in spatial analytics, in isolation or in conjunction with classic SDO_GEOMETRY types.
Finally we will show how the GeoJSON objects can be displayed on a map.

Speakers
avatar for Albert Godfrind

Albert Godfrind

Spatial and Graph Solutions Architect, Oracle
Albert Godfrind has over 25 years of experience in designing, developing, and deploying IT applications. His interest and enthusiasm for spatial information and geographical information systems started at Oracle when he started using the spatial extensions of the Oracle database in... Read More →


Thursday March 22, 2018 3:40pm - 4:05pm PDT
3-Rm 103
 

Twitter Feed