Analytics and Data Summit 2018: Full Schedule

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

10:10am PDT

An Introduction to Graph: Database, Analytics, and Cloud Services

Graph analysis employs powerful algorithms to explore and discover relationships in social network, IoT, big data, and complex transaction data. Learn how graph technologies are used in applications such as fraud detection for banking, customer 360, public safety, and manufacturing. This session will provide an overview and demos of graph technologies for Oracle Cloud Services, Oracle Database, NoSQL, Spark and Hadoop, including PGX analytics and PGQL property graph query language.

Speakers

Jean (Oracle) Ihm

Product Manager, Spatial and Graph, Oracle Spatial and Graph

I'm a Product Manager for Oracle Spatial and Graph technologies. Mapping and location and graph analysis for Database, Big Data, and the Cloud.

Jan Michels

Principal Member of Technical Staff, Oracle

Jan Michels represents Oracle on the ANSI and ISO committees responsible for standardizing SQL, while working closely with the Oracle database server development teams. He has been involved in designing extensions for the SQL language for 20 years. Jan is chair of the DM32.2 Ad Hoc... Read More →

Hans Viehmann

Product Manager, ORACLE Corporation

Hans Viehmann is working for ORACLE Corporation as Product Manager for the Oracle Spatial and Graph option and the „Location Products“. He holds a degree in Physics from Hamburg University and started his career in Research before joining ORACLE over twenty years ago. After various... Read More →

Tuesday March 20, 2018 10:10am - 11:00am PDT
3-Rm 103

Spatial and Graph

Products Big Data Cloud Service (OBDCS), Platform as a Service (PaaS), Spatial and Graph (OSG)
Track Spatial and Graph, Analytics, Big Data, Cloud Computing, Internet of Things

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

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 →

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

Data Warehousing and SQL

11:15am PDT

Sneak Preview: Graph Cloud Services and Spatial Console for Database Cloud

Cloud services change the way we provision, deploy and perform analytic application development. They can simplify the development and deployment experience and make it possible for developers and data scientists to use analytics in which they had little or no expertise.

Two new planned cloud services from Oracle for spatial and graph analysis offer low-code and no-code capabilities. The spatial cloud services include no-code spatial analysis, automated geo-enrichment of data, visual map analysis, and simplified spatial application creation for analysts and developers. The graph cloud services provide an analyst and developer studio with dozens of prebuilt, low-code graph algorithms with wizards to automate modeling, loading, and visualizing graph data and analysis results.

These mapping and graph analysis services offer over hundreds of geospatial and graph analysis functions. Data access will be available through rich APIs, along with SQL-based spatial and graph query languages.

Speakers

Jayant Sharma

Sr Dir, Prod Mgmt, Oracle USA Inc

Dr. Jayant Sharma is Director, Spatial Product Management at Oracle . He has over twenty years experience in databases and spatial information systems. He is currently focused on the product strategy, and design, of spatial components for Oracle's database and middleware products... Read More →

Jim Steiner

VICE PRESIDENT, ORACLE

Jim Steiner is Vice President of Product Management in the Oracle Server Technologies Division. He heads product management and strategy for Oracle’s spatial, graph, and several Big Data technologies. Mr. Steiner joined Oracle in 1995 as Director of Product Management and Marketing... Read More →

Tuesday March 20, 2018 11:15am - 12:05pm PDT
1-Auditorium

Spatial and Graph

Products Big Data Cloud Service (OBDCS), Platform as a Service (PaaS), Spatial and Graph (OSG)
Track Spatial and Graph, Analytics, Big Data, Cloud Computing, Machine Learning, Strategy

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

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 →

Hayk Chakhchakhyan

Head of Marketing, Fivetran

Data Pipelines, ETL, ELT, Data warehousing, BI, Analytics, SQL, Snowflake, Redshift, Looker, Tableau, BigQuery.

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 →

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 →

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 →

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 →

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 →

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 →

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 →

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 →

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 →

Dan Vlamis

President, Vlamis Software Solutions, Inc.

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

General

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

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

Spatial and Graph

Products Spatial and Graph (OSG)
Track Spatial and Graph, Analytics, Big Data, Cloud Computing, Data Warehousing and SQL

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

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 →

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

Spatial and Graph

Products Business Intelligence Cloud Service (BICS), Data Visualization (DV), Database In-Memory
Track Spatial and Graph, Data Warehousing and SQL

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

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

Spatial and Graph

Products Spatial and Graph (OSG)
Track Spatial and Graph, Data Warehousing and SQL, General

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

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

Spatial and Graph

Products Database Enterprise Edition, Spatial and Graph (OSG)
Track Data Warehousing and SQL, General, Spatial and Graph, Analytics, Big Data, Cloud Computing

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

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 →

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

Spatial and Graph

Products Database Cloud Service, Database Enterprise Edition, Spatial and Graph (OSG)
Track Spatial and Graph

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

É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

Spatial and Graph

Products Database Enterprise Edition, Partitioning, Real Application Clusters, Spatial and Graph (OSG), Weblogic
Track Spatial and Graph, Analytics, Big Data

4:20pm PDT

Introducing Oracle R Enterprise 1.5.1 New Features

Oracle R Enterprise, a component of the Oracle Advanced Analytics Option, makes the open source R statistical programming language and environment ready for the enterprise and big data. Designed for problems involving both large and small volumes of data, Oracle R Enterprise integrates R with Oracle Database, enabling R users to run R commands and scripts for statistical, machine learning, and graphical analyses on database tables. In this session, we will briefly introduce Oracle R Enterprise, but focus on the new features of Oracle R Enterprise 1.5.1, including:

OREdplyr - transparncy layer package based on the popular and powerful dplyr package from the tidyverse
OAAgraph - enabling combining Oracle Spatial and Graph PGX with OAA machine learning from a common R interface
Explicit Semantic Analysis algorithm - new text analytics capability to extract features based on human curated topics, such as from Wikipedia
Partititioned models - automated building and scoring of predictive models based on data partitions
and more...

Join us to see what how you could take your R-based analytics to the next level of functionality, scalability, and performance.

Speakers

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 →

Tuesday March 20, 2018 4:20pm - 5:10pm PDT
2-Rm 102

Machine Learning

Products Oracle R Enterprise, Oracle R Distribution, Oracle Advanced Analytics, Oracle Spatial and Graph, Oracle PGX
Track General, Machine Learning, Big Data, Spatial and Graph

4:45pm PDT

Country Scale digital maps data with Oracle Spatial & Graph

MapmyIndia builds and provides the most advanced maps of India optimized for in-vehicle and personal navigation and tracking and location-based services for enterprise and personal use. This presentation describes the use and benefits of Oracle Spatial and Graph in the data production pipeline from collection and extraction to production, quality assurance, and delivery. Oracle Database 12 allows the use of common applications for data ingestion and integration and data validation and production. After a rigorous set of quality assurance tests that include topological, statistical, and other validation, consistency, and completeness checks the production database is then used generating data products for delivery in multiple formats. The common platform for storage and applications facilitates quarterly releases that often contain significant updates. This presentation will also discuss planned usage of 3D and point-cloud management for HD maps.

Speakers

Ankeet Bhat

VP Business Development, MapmyIndia

Having been in the mapping space since last 6 years Ankeet has help built various business verticals from scratch in MapmyIndia from enterprise, automotive, international businesses, etc. and has also delved deep into technologies around maps. He has been involved with numerous strategic... Read More →

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

Spatial and Graph

Products Real Application Clusters One Node
Track Spatial and Graph, Big Data, Internet of Things

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

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

Spatial and Graph

Products Bare Metal Cloud Database Service, Big Data SQL, Cloud Machine, Infrastructure as a Service (IaaS), NoSQL Database Enterprise Edition, Spatial and Graph (OSG), Weblogic
Track Spatial and Graph, Analytics, Big Data, Cloud Computing, Data Warehousing and SQL

9:00am PDT

HOL: Using R for Big Data Advanced Analytics, Machine Learning, and Graph

Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Oracle R Enterprise (ORE), a component of the Oracle Advanced Analytics Option, provides a comprehensive, database-centric environment for end-to-end analytical processes in R, enabling immediate deployment to production environments. Entire R scripts can be operationalized in production applications - eliminating the need to port R code. Using ORE with Oracle Database enables R users to transparently analyze and manipulate data in Oracle Database thereby eliminating memory constraints imposed by client R engines. In this hands-on lab, attendees will work with the latest Oracle R Enterprise software, getting experience with the transparency layer, machine learning algorithms, and embedded R execution. Working with the instructors through scripted scenarios, users will understand how R is used in combination with Oracle Database to analyze big data.

Speakers

Mark Hornick

Senior Director, Oracle

Wednesday March 21, 2018 9:00am - 10:55am PDT
6-Bldg 500

Machine Learning

Track Machine Learning, Big Data, Spatial and Graph

10:05am PDT

Follow the Money: A Graph Model for Monitoring Bank Transactions

Examining the flow of bank transactions is key to analyzing financial operations such as fraud detection, client segmentation, personalized offers, risk modeling, client retention, etc. In particular, bank analysts are challenged to understand the behavior of companies that make large bank deposits and then transfer significant sums – to entities both inside and outside the bank’s network. They are also challenged by the limitation of relational and traditional BI tools to effectively model and analyze the money flows between a customer, its bank, and external 3rd parties. Banco Galicia has addressed this challenge by modeling money flows as a complex graph of transactions. The result is a powerful approach to support the analysis and visualization of money flows across a large network of bank-affiliated transactions. This session will desdescribe how Banco Galicia uses Oracle Big Data Spatial and Graph to understand the topology and behavior of money transfers.

Speakers

Federico Garcia Calabria

Senior Consultant, Oracle

Federico Garcia Calabria has a college Degree in Informatics Engineer and a Masters Degree in Data Mining. He currently works as a Senior Consultant in Oracle Consulting Services where he has been contributing primarily as a Big Data/Business Intelligence/SOA analyst on banking and... Read More →

Wednesday March 21, 2018 10:05am - 10:55am PDT
3-Rm 103

Spatial and Graph

Track Spatial and Graph, Analytics, Big Data, Machine Learning

11:10am PDT

Graph Modeling and Analysis for Complex Automotive Data Management

Mazda is an automotive manufacturer that routinely needs to link and analyze data from different sources like production, sales, inventory, and logistics. Most manufacturers use a bill of materials (BoM) to provide a master system for parts and their relationships. However, BoM developers have long realized the difficulties of modeling the complex relationships between components using a RDBMS. Moreover, BoM data must also align with master (or transaction) data from disparate IT systems. This paper highlights a novel approach to apply a graph database to create a flexible BoM of interconnected auto components. This system uses the property graph database and in-memory analytics in Oracle Spatial and Graph. We found the graph data model to be more effective at modeling, querying, and visualizing complex relationships in our data, while also integrating with different production systems. We will also share performance results of complicated pattern matching queries using PGQL._x000D_
_x000D_
_x000D_
_x000D_

Speakers

Masahiro Yoshioka

Principal Engineer, Mazda Motor Corporation

Yoshioka Masahiro is currently responsible for evaluating and implementing advanced technologies in IT at Mazda Motor Corporation, Hiroshima, Japan. He and his team are currently focused on technologies in Big Data & AI – to identify opportunities to apply those technologies to... Read More →

Wednesday March 21, 2018 11:10am - 11:35am PDT
3-Rm 103

Spatial and Graph

Products Spatial and Graph (OSG)
Track Spatial and Graph, Analytics, Big Data, Internet of Things

11:35am PDT

Construct a Public Security Data Analysis Engine Using Oracle Big Data Solution

Criminal analysis and prediction involves using many, varied data sources with various data formats. A city level public security department in China looked to Oracle's big data technologies to address their business requirements. We delivered this project to our customer using Oracle Database 11.2, Big Data Spatial and Graph 2.2, BIEE 12c, Data Visualization, Big Data Discovery 1.3.2 products.
We integrated various data including emergency call (911), demographic, hotel bookings, criminal records, live traffic, and other data sets, to perform accommodation analysis, criminal prediction analysis, correlation analysis, and operation efficiency dashboard and reporting. The property graph features in Big Data Spatial and Graph were key to performing these analytics, and the solution integrated Oracle's big data technology into one platform.

Speakers

Justin Zou

Senior Sales Consultant, Oracle

Justin Zou has more than 10 years hands on experiences of IT/consulting work , especially at Big Data field.

Wednesday March 21, 2018 11:35am - 12:00pm PDT
3-Rm 103

Big Data

Products Spatial and Graph (OSG)
Track Big Data, Analytics, Spatial and Graph

1:00pm PDT

Serving Ireland's Authoritative Geospatial Data as Linked Data

Ordnance Survey Ireland (OSi) is Ireland's national mapping agency and is charged with managing authoritative geospatial information for the country. OSi has developed a complex relation database model to store this information called Prime2, using the Oracle 12c suite. To make some of this data more readily accessible to third parties, OSi has adopted Linked Data practices to do so. Through work between OSi and the ADAPT Centre in Trinity College Dublin, a Linked Data platform (data.geohive.ie) has been developed to publish this data. The platform currently relies on multiple tools for transforming relational data to RDF, storage, querying (GeoSPARQL over geospatial information), a Linked Data front-end and a back-end tool to reduce server load. The next design of the platform will utilise more functionality of the Oracle 12c suite to make access more efficient. This presentation will discuss how we worked with OSi to make available their Oracle based geospatial data as Linked Data.

Speakers

Alan Meehan

Research Fellow, ADAPT Centre, Trinity College Dublin

Alan Meehan is a Research fellow in the ADAPT Centre based in Trinity College Dublin, Ireland. His research interests are in the domains of Semantic Web and Linked Data; in particular ontology mappings and management thereof. In addition to this, he applies his Linked Data expertise... Read More →

Wednesday March 21, 2018 1:00pm - 1:25pm PDT
3-Rm 103

Spatial and Graph

Products Spatial and Graph (OSG)
Track Spatial and Graph

1:25pm PDT

Publication of Statistical Linked Open Data in Japan with Oracle RDF graph

The National Statistics Center of Japan is responsible for managing and publishing a wide variety of national statistical data on its e-Stat portal site. The Center works with national and local agencies to make statistics widely accessible to government and the public. Inconsistent metadata definitions from the myriad of data sources made it difficult to align data semantics to support effective search and discovery.
To break through this problem, the Center developed a Linked Open Data
(LOD) platform in 2016, which publishes Japan statistics such as the population census and consumer price index.
This platform was built using the RDF graph capability in Oracle Database Spatial and Graph, and configured on Exadata and Oracle's SPARQL endpoint service.
To improve provisioning and manageability, the platform was migrated to the Oracle Public Cloud.
This move freed up limited resources to focus on developing new services, such as spatial search on sub-regional geometries using GeoSPARQL.

Speakers

Shoki Nishimura

Deputy Director, National Statistics Center

Shoki Nishimura serves as a Deputy Director at the National statistics center of Japan.He is engaged in designing and developing data dissemination system for the Japanese statistics, and recently has expanded his work to promote open-data provided with APIs and a Linked Open Data... Read More →

Yusuke Takeyoshi

Consultant, Oracle Japan

Yusuke Takeyoshi serves as a Senior Principal Consultant at Oracle Japan in Tokyo.He has several years' experience in technical consultation for Oracle database administrators and is expanding his work to promote the utilization of big-data and open-data with analytics and graph... Read More →

Wednesday March 21, 2018 1:25pm - 1:50pm PDT
3-Rm 103

Spatial and Graph

Products Spatial and Graph (OSG)
Track Spatial and Graph, Cloud Computing

2:20pm PDT

HOL: Using Property Graph and Graph Analytics on Oracle NoSQL DB to analyze data on Meetup.com

Limited Capacity full
Adding this to your schedule will put you on the waitlist.

Meetup.com is a social media platform for people interested in the same subject to gather in groups, also to plan, and organize meetings in order to connect with meetup group members for the purpose of exchanging knowledge, discussing subjects and form new networks. All data related to meetup groups and their members, the events they organize and speakers at events as well as comments regarding events can perfectly representated as a property graph. This gives the opportunity to use graph algorithms to analyze these data.
The purpose of this presentation is to show how to build a graph from Meetup.com data and how to use Oracle´s Property Graph In-Memory Analytics Framework to analyze the graph in order to (1) find influencers for certain topics in different locations or (2) identify hot topics people are interested in most. The HOL is "tell & show" using BDL VM 4.11 as environment, RStudio for data wrangling and Big Data Spatial and Graph with Oracle NoSQL DB as data layer. Scripts will be uploaded to and available via Github.

Speakers

Karin Patenge

Business Development Manager, Oracle Deutschland B.V. & Co. KG

Karin Patenge is currently working as a Business Development Manager for Technology. She joined Oracle in 2007 as a PreSales Consultant with the focus to enable customers and partners in embedding Oracle Technologies (software products and services) in their solutions. Having a background... Read More →

Wednesday March 21, 2018 2:20pm - 3:10pm PDT
6-Bldg 500

Spatial and Graph

Products Big Data SQL, Big Data Cloud Service (OBDCS)
Track Spatial and Graph, Analytics

2:45pm PDT

Graph-enabled Data Discovery and Lightweight records of processing tool supporting GDPR requirements

Organizations are managing greater amounts of information from different sources and countries, and face complex privacy and data protection requirements. The European Union has introduced a sweeping General Data Protection Regulation (GDPR). As of May 2018, GDPR will enforce new accountability obligations and restrictions on international data flows affecting all organizations offering goods or services to EU residents.

GDPR SMART is an Oracle Consulting solution designed to help organizations address and mitigate potential risks associated with data processing activities. GDPR SMART is a graph-enabled platform that identifies all user Personal Information stored in their systems; automatically categorizes existing data sets; and analyzes potential risks inherent in these data. We will show how GDPR SMART supports the 2018 mandate. We will demo its rich functionality using Oracle Big Data Spatial and Graph technologies, with Big/Fast Data processing, NLP and machine learning.

Speakers

Wojciech Wcislo

Head of EMEA Warsaw ICCC, Oracle

Experienced consulting manager and architect with 10+ years of IT consulting experience out of which 6+ on various management positions. Consulting manager and P&L owner in EMEA consulting. Responsible for the delivery of consulting services and projects to regional customers, business... Read More →

Wednesday March 21, 2018 2:45pm - 3:10pm PDT
3-Rm 103

Spatial and Graph

Products Analytics Cloud (OAC), Data Visualization (DV), Data Visualization Cloud Service (DVCS), Spatial and Graph (OSG)
Track Spatial and Graph, Analytics, Cloud Computing

3:25pm PDT

Using Spatial in Oracle Cloud with Developer Tools and Frameworks

Developers can now build location analytics and map visualization into their cloud applications with Spatial using popular developer tools and frameworks. This session will provide examples of Spatial development for the cloud using mainstream frameworks such as Oracle REST Data Services (ORDS), Oracle Application Express (APEX), Oracle JET, NODE.js, and Python. These examples typify Spatial in the mainstream of cloud development.

Speakers

David Lapp

Product Manager, Oracle

David Lapp is senior principal product manager for Oracle's spatial and graph technologies, focused on Cloud and Big Data solutions. His experience includes working as Spatial and Business Intelligence solutions specialist in Oracle's Public Sector group, where he engaged with several... Read More →

Siva Ravada

Senior Director of Engineeting, Oracle, USA

Wednesday March 21, 2018 3:25pm - 4:15pm PDT
3-Rm 103

Spatial and Graph

Products Database Cloud Service
Track Spatial and Graph, Analytics, Cloud Computing

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

Sungpack Hong

Research Director, Oracle

Research Director at Oracle Labs.Leading projects regarding large-scale graph and data analysis -- platforms and applications

Mark Hornick

Senior Director, Oracle

Francisco Morales

Software Developer, Oracle Labs

Wednesday March 21, 2018 4:30pm - 5:00pm PDT
2-Rm 102

Machine Learning

Products Advanced Analytics (OAA), Spatial and Graph (OSG), Oracle R Enterprise, Database Enterprise Edition
Track Machine Learning, Spatial and Graph

4:30pm PDT

Easy To Use Self Service Maps in Oracle Database Cloud

See a newly designed self-service spatial visualization and analysis component for Oracle Database Cloud. The tool is intended to simplify the use of Oracle Spatial and Graph features for Database Cloud Service users and developers. It is designed to benefit users with or without domain expertise in spatial data management and analytics.
The session will demonstrate end-to-end workflows such as:

Select database content (one or more tables or views with spatial information), visualize it on map, customize the map, share the result
Upload a spreadsheet with spatial data (e.g. Lat/Long points) or identifiers (e.g. city or state names) and perform the same set of steps as above
Perform ad-hoc spatial queries, visualize and share the results
Create a dashboard-like page with multiple maps to show comparisons (e.g. Sales by Year)

Speakers

Carol Palmer

Sr. Principal Product Manager, Oracle

Carol is a senior principal product manager in Oracle's Spatial & Graph product group. She is focused on spatial and graph cloud services and components and serves as Oracle representative to the Spatial & Graph SIG board.

LJ Qian

Director, Software Development, Oracle

Dr. Liujian (LJ) Qian obtained his Ph.D from Penn State, and Master's degree from the Institute of Computing Technology, Academia

Wednesday March 21, 2018 4:30pm - 5:00pm PDT
3-Rm 103

Spatial and Graph

Products Database Cloud Service
Track Spatial and Graph, Analytics, Cloud Computing

8:45am PDT

Analyzing Blockchain and Bitcoin Transaction Data as Graph

Blockchain technology and Bitcoin will potentially revolutionize business transactions. Blockchain offers a robust, decentralized platform for privacy and trust. It underlies the digital crypto-currency Bitcoin, which can be exchanged freely and anonymously, without a central authority. Bitcoin transactions - recorded publicly, and growing at a rate of 100,000's of transactions per day - provide an invaluable dataset to gain insight into the behavior of digital currency and the underlying Blockchain technology. Blocks, transactions with potential multiple inputs and outputs, and flow of bitcoins between addresses, form a sophisticated real-time graph. This talk details a pipeline used to gather bitcoin transaction data and analyze it with powerful graph cloud database technologies.

Speakers

Xavier Lopez

Senior Director, Oracle

Xavier Lopez is Senior Director of Product Management in Oracle's Spatial and Graph products group. Over the last 20 years he has played a key role championing the development of spatial and graph database technologies in Oracle. He is currently focusing on the development... Read More →

Zhe Wu

Architect, Oracle

Zhe Wu is an architect working on semantic and graph technologies in Oracle USA. He leads the design, architecture, and development of the inference engine for W3C RDFS/SKOS/OWL in the database, Java APIs for RDF Semantic Graph, RDF triple-level security, SQL-based graph analytics... Read More →

Thursday March 22, 2018 8:45am - 9:35am PDT
3-Rm 103

Spatial and Graph

Products Big Data Cloud Service (OBDCS)
Track Spatial and Graph, Analytics, Big Data, Cloud Computing, Machine Learning

9:50am PDT

Ingesting streaming data into Graph database

This talk presents the experience of a customer project where we built a stream-based ingestion into a graph database. It is one thing to load the graph first and then querying it. But it is another story if the data to be added to the graph is constantly streaming in, while querying it. Data is easy to add, if each single message ends up as a new vertex in the graph. But if a message consists of hierarchical information, it most often means creating multiple new vertices as well adding edges to connect this information. What if a node already exists in the graph? Do we create it again or do we rather add edges which link to the existing node? Creating multiple nodes for the same real-life entity is not the best choice, so we have to check for existence first. We end up requiring multiple operations against the graph, which demonstrated to be a bottle neck. This talk presents the implementation of an ingestion pipeline and the design choice we made to improve performance.

Speakers

Guido Schmutz

Platform Architect, Trivadis

Guido Schmutz works for the Oracle Platinum Partner Trivadis. He has more than 30 years of technology experience. At Trivadis he leads the Trivadis Architecture Board. He has long-time experience as developer, coach, trainer, and architect in the area of building IT systems. In the... Read More →

Thursday March 22, 2018 9:50am - 10:40am PDT
3-Rm 103

Spatial and Graph

Products Business Intelligence, Cloud Machine, Cloud Management Pack for Oracle Database, Database Cloud Service, Real Application Testing
Track Spatial and Graph, Analytics, Big Data

10:55am PDT

Fake News, Trolls, Bots and Money Laundering -- Find the Truth with Graphs

Millions of dollars are spent every year on big data analysis of tweets, trends, Facebook commentary and social media sentiment. Detecting money laundering, fraud and other financial crimes becomes more difficult as the structure of shell corporations and the flow of transactions follow labyrinthine structures. Identifying suspicious activities, false information and fraudulent patterns is increasingly important in today’s information economy. See how graph analysis, database and visualization tools expose fabricated trends, troll and bot-created content and fraudulent financial transactions. Learn about the powerful graph capabilities in Oracle Spatial and Graph, Oracle Big Data Spatial and Graph and Oracle’s Cloud services.

Speakers

Sungpack Hong

Research Director, Oracle

Research Director at Oracle Labs.Leading projects regarding large-scale graph and data analysis -- platforms and applications

Jim Steiner

VICE PRESIDENT, ORACLE

Thursday March 22, 2018 10:55am - 11:45am PDT
3-Rm 103

Spatial and Graph

Products Spatial and Graph (OSG)
Track Spatial and Graph, Analytics, Big Data, Cloud Computing

12:00pm PDT

Spatial analytics with Oracle DV, Analytics Cloud, and Database Cloud Service

Oracle Data Visualization (DV) and Oracle Analytics Cloud (OAC) include powerful features to gain insights from spatial and location-based information. This session will first review the built-in spatial and mapping capabilities of DV and OAC. We will then cover techniques to extend these built-in capabilities with additional spatial analytics and mapping using using features of Oracle Spatial and Graph in Oracle Database Cloud Service.

Speakers

David Lapp

Product Manager, Oracle

Jayant Sharma

Sr Dir, Prod Mgmt, Oracle USA Inc

Thursday March 22, 2018 12:00pm - 12:30pm PDT
3-Rm 103

Spatial and Graph

Products Analytics Cloud (OAC), Data Visualization (DV), Data Visualization Cloud Service (DVCS), Spatial and Graph (OSG)
Track Spatial and Graph, Analytics, Cloud Computing

1:30pm PDT

The Role of Master Data Management (MDM) for Data Centric Automation Strategies

In the engineering and construction industry, master data is key to data centric execution strategies for data exchange and integration. Innovative architectures for the digitization and deployment of master data support engineering information from its conceptual 2D and 3D design phases to their downstream uses in procurement, scheduling and construction. Building Information Management (BIM) hierarchical classification standards and other master data play a key role in the automated transformation and normalization of BIM 3-dimensional model records and their integration with other business system data. This presentation will identify some of the key master data needed to support the engineering automation processes for the exchange and integration of 3D model data in an Oracle Spatial and Graph data environment, and the data dictionary-driven architectures that help leverage master data as part of data centric innovation strategies.

Speakers

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 →

Thursday March 22, 2018 1:30pm - 1:55pm PDT
3-Rm 103

Spatial and Graph

Products Enterprise Metadata Management, Spatial and Graph (OSG)
Track Spatial and Graph, Analytics

1:55pm PDT

Measuring Published Citation using Graph Modeling and Analysis

Research organizations, along with their funding agencies, routinely need to measure the performance of their organization. The application of scientific citation indexing is a widely used metric for evaluating the success of a research organization. This paper highlights the novel use of graph modeling, analytics and visualization to improve this metric of scientific performance. Our approach models an index of published scientific publication and citations as a connected graph. We used the Oracle in-memory graph analytics engine (PGX) to carry out graph analysis, statistical inferencing, and visual exploratory analysis. Our results illustrate how these graph modeling combined with statistical analysis, such as stochastic block model (SBM), can improve the measurement and evaluation of scientific research.

Speakers

Keisuke Honda

Research Administrator, The Institute of Statistical Mathematics

Keisuke Honda, Ph.D. is a Research Administrator in The Institute of Statistical Mathematics at Tokyo, Japan, where he works to enhancement research collaboration with industry and to promote several HPC projects. He leads project which is to develop new criteria to measure research... Read More →

Mio Takei

Project Senior Technical Support Specialist, The Institute of Statistical Mathematics

Mio Takei is a Technical Specialist in Analytics at The Institute of Statistical Mathematics, Tokyo, Japan. She has previously worked as a consultant specializing in Business Intelligence and Analytics at Oracle Japan.

Thursday March 22, 2018 1:55pm - 2:20pm PDT
3-Rm 103

Spatial and Graph

Track Spatial and Graph, Analytics, Big Data

2:30pm PDT

Spatial Analytics with Spark & Big Data

Sensor feeds and social media data contain much latent location information such as addresses, place names, and GPS coordinates. How can you uncover those location relationships and patterns for better business insights? How can build applications to track moving objects in real time? Learn about spatial technologies for Spark, Hadoop, and NoSQL, and how to build analytic applications using Java. Oracle Big Data Spatial and Graph offers a set of analytic algorithms, services, and data models that support big data workloads. Data scientists and developers can be more productive by using dozens of prebuilt spatial functions and services. Users can harmonize data and group results based on spatial relationships, track moving objects, and apply spatial services to cleanse, filter, normalize, and process geospatial data sets, and easily perform spatial queries with new Hive and Spark SQL features.

Speakers

LJ Qian

Director, Software Development, Oracle

Dr. Liujian (LJ) Qian obtained his Ph.D from Penn State, and Master's degree from the Institute of Computing Technology, Academia

Siva Ravada

Senior Director of Engineeting, Oracle, USA

Thursday March 22, 2018 2:30pm - 3:20pm PDT
3-Rm 103

Spatial and Graph

Products Spatial and Graph (OSG)
Track Spatial and Graph, Analytics, Big Data

3:40pm PDT

Getting Started with Graphs on Oracle Database Cloud Service

With Oracle Database Release 12.2, property graph capabilities are now offered in Oracle Spatial and Graph, and can be easily deployed in Oracle Database Cloud Service. You can store and model graph data, and run sophisticated graph analytics such as detecting patterns and generating recommendations using the In-Memory Parallel Graph Analytics (PGX) engine. This session walks you through the steps, including how to enable Oracle Database Cloud Service with property graph capability, set up a remote PGX server with Oracle Java Cloud Service, and run queries for graph analysis.

Speakers

David Lapp

Product Manager, Oracle

Charles Wang

Consultant, Oracle Spatial and Graph, Oracle

Zhe Wu

Architect, Oracle

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

Spatial and Graph

Products Database Cloud Service, Java Cloud Service, Spatial and Graph (OSG), Weblogic
Track Spatial and Graph, Analytics, Cloud Computing, Machine Learning

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

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

Spatial and Graph

Products Database Enterprise Edition, Spatial and Graph (OSG)
Track Spatial and Graph, Analytics, Big Data, Internet of Things