• No results found

DW & Big Data on your smartphone

N/A
N/A
Protected

Academic year: 2021

Share "DW & Big Data on your smartphone"

Copied!
16
0
0

Loading.... (view fulltext now)

Full text

(1)

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

 

(2)
(3)

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  

(4)

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  

(5)

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}  

(6)

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,  

}

 

(7)

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  

(8)

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  

(9)

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  

(10)

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  

(11)

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  

(12)

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  

(13)

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  

(14)

Copyright  ©  2014,  Oracle  and/or  its  affiliates.  All  rights  reserved.    |  

THANK  YOU  FOR    

JOINING  US  TODAY  

 

 

 

(15)
(16)

References

Related documents

 It is important that the version of the Training Setup Macros matches the version of AVEVA Plant Products being used as the training set up is frequently changed to reflect

Our results suggest that FDI tends to increase competition, as measured by price cost margins, but there is no visible effect of competition on R&D intensities in Chinese

1977 - La Unión Internacional para la Conservación de la Naturaleza y sus Recursos; 1977 - La Unión Internacional para la Conservación de la Naturaleza y sus

One way to begin this reconsideration of the relationship between manuscript and print in Whitman’s work is to revisit the relation- ship between the published “Calamus” poems

8 Please bring (if applicable) copies of your child’s report cards, multi-factored evaluations/ETR, IEP, 504 Plan, cognitive testing (Iowa Test, SCOGAT, Stanford Tests,

Analizamos a ontinua ión el omportamiento de la traye toria solu ión del modelo de. red neuronal

Red Tomato, a 501 ©3 organization, will convene 10-12 stakeholders from 5 Northeastern states—MA, NH, VT, CtT NY. Members will include Northeast apple growers, researchers,

E.g., files being processed (in Elan, Toolbox or Flex) and ancillary files (.typ, .prj, etc) that are only necessary while working to create the..