Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Smartphone app helping
you get the most from this
year’s OpenWorld
Access to all the most
important informaAon
•
Presenter profiles
•
Must-‐see sessions
•
Must-‐aGend hands-‐on labs
•
Useful links
h7p://:nyurl.com/kmbsxbu
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Oracle Big Data SQL Hands-‐on Lab
Unified SQL Analysis Across the Big Data PlaIorm
Keith Laker & Marty Gubar
Oracle Big Data & DW Product Management
September 2014
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Oracle Big Data SQL
Securely analyze data across big data sources using Oracle SQL
4
NoSQL
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Start with ApplicaAon Log Data Stored in Hadoop
Oracle ConfidenAal –
Internal/Restricted/Highly
Restricted
5 {"custId":1185972,"movieId":null,"genreId":null,"Ame":"2012-‐07-‐01:00:00:07","recommended":null,"acAvity":8} {"custId":1354924,"movieId":1948,"genreId":9,"Ame":"2012-‐07-‐01:00:00:22","recommended":"N","acAvity":7} {"custId":1083711,"movieId":null,"genreId":null,"Ame":"2012-‐07-‐01:00:00:26","recommended":null,"acAvity":9} {"custId":1234182,"movieId":11547,"genreId":44,"Ame":"2012-‐07-‐01:00:00:32","recommended":"Y","acAvity":7} {"custId":1010220,"movieId":11547,"genreId":44,"Ame":"2012-‐07-‐01:00:00:42","recommended":"Y","acAvity":6} {"custId":1143971,"movieId":null,"genreId":null,"Ame":"2012-‐07-‐01:00:00:43","recommended":null,"acAvity":8} {"custId":1253676,"movieId":null,"genreId":null,"Ame":"2012-‐07-‐01:00:00:50","recommended":null,"acAvity":9} {"custId":1351777,"movieId":608,"genreId":6,"Ame":"2012-‐07-‐01:00:01:03","recommended":"N","acAvity":7} {"custId":1143971,"movieId":null,"genreId":null,"Ame":"2012-‐07-‐01:00:01:07","recommended":null,"acAvity":9} {"custId":1363545,"movieId":27205,"genreId":9,"Ame":"2012-‐07-‐01:00:01:18","recommended":"Y","acAvity":7} {"custId":1067283,"movieId":1124,"genreId":9,"Ame":"2012-‐07-‐01:00:01:26","recommended":"Y","acAvity":7} {"custId":1126174,"movieId":16309,"genreId":9,"Ame":"2012-‐07-‐01:00:01:35","recommended":"N","acAvity":7} {"custId":1234182,"movieId":11547,"genreId":44,"Ame":"2012-‐07-‐01:00:01:39","recommended":"Y","acAvity":7}} {"custId":1346299,"movieId":424,"genreId":1,"Ame":"2012-‐07-‐01:00:05:02","recommended":"Y","acAvity":4}Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Tables in Hadoop Tables in DB
SQL join
CUSTOMER
SALES FACT
Oracle Big Data SQL
Customer behavioral data from
weblogs stored as JSON documents
Securely analyze customer behavior
and sales transacAons for targeted
markeAng using Oracle’s rich SQL
dialect
WEBLOGS
MOVIELOG (External Table)
WEBLOG
{"cusAd":1185972,
"movieid":3445,
"genreid":21,
"Ame":"2012-‐07-‐01:00:00:07",
"recommended":null,
"acAvity":8,
”price":2.99,
}
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Let’s Get Started!
•
Start the VM
•
Double-‐click the Reset Hans-‐on Lab icon
•
Double-‐click the Start Here icon to open the lab
•
Start SQL Developer using the icon at top
7
SQL Developer
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Here’s what you’re going to do…
•
Learn how to configure the database to access data in Hadoop
•
Create tables that access data in Hadoop – with and without Hive
•
Redact sensiAve fields coming from Hadoop
•
Query data across both Hadoop and Oracle Database 12c using analyAcal
SQL
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Follow us on
social media
Where to get more informa:on
•
Big Data Home Page on OTN
•
SQL AnalyAcs Home Page on OTN
•
Oracle Learning Library
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |
Come and visit us in the Mosocone South Exhibi:on Hall
DW and Big Data Demo Booths
Regular Hours
Dedicated Hours
Monday
9:45 a.m.–6:00 p.m. 9:45 a.m.–10:15 a.m.
Tuesday
10:00 a.m.–6:00 p.m. 10:00 a.m.–10:45 a.m.
Wednesday 9:30 a.m.–3:30 p.m. 9:30 a.m.–10:15 a.m.
2:45 p.m.–3:30 p.m
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | 11
Monday
DW and Big Data Sessions @OOW2014
Time
Session Title
Loca:on
2:45pm Oracle Big Data: Strategy and Roadmap
South 104
4:00pm Using AnalyCcal SQL to Intelligently Explore Big Data
North 131
5:15pm Oracle Big Data Appliance: Deep Dive and Roadmap for Customers and
Partners
South 104
Time
Session Title
Loca:on
10:45pm Data Warehousing and Big Data Customer Panel
South 302
12:00pm Top Five Things to Know About Oracle Database In-‐Memory
South 104
6:00pm
Meet the Experts -‐ Oracle’s Big Data Management System
South 303
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | 12
Wednesday
DW and Big Data Sessions @OOW2014
Time
Session Title
LocaAon
10:15pm Big Data & PredicAve AnalyAcs: Fiserv Data Mining Case Study
South 301
12:45pm If You Think ParAAoning Is Only for Performance, Think Again
South 103
3:45pm
Oracle Big Data SQL: Deep Dive (SQL over RelaAonal, NoSQL, and Hadoop) South 103
4:45pm
Parallel ExecuAon and Resource Management in Concurrent
Environments
North 131
Time
Session Title
Loca:on
12:00pm Oracle Database In-‐Memory Meets Oracle OpAmizer
South 104
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | 13
Oracle Big Data SQL: Unified SQL Analysis Across the Big Data PlaIorm
DW and Big Data Hands-‐on Lab @OOW2014
Date
Time
Loca:on
Monday
11:45am -‐ 12:45pm
Hotel Nikko -‐ Peninsula
Tuesday
3:45pm – 4:45pm
Hotel Nikko -‐ Peninsula
Wednesday 1:15pm – 2:15pm
Hotel Nikko -‐ Peninsula
Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |