Oracle Big Data SQL HOL

农文瑶

2017/11/26 发布于 技术 分类

2017 Oracle OpenWorld 大会已经结束,从10月1日至10月5日,历时5天,60,000 人的参会规模,声势浩大的数据库盛宴,喧嚣散去,我来总结一下具体大会的感受,国内的国庆假期也接近尾声,大家可以在假期之后来扫描一下Oracle的发展创新和技术发布。

文字内容
2. Oracle Big Data SQL HOL Subtitle Marty Gubar Director - Oracle Big Data PM Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal/Restricted/Highly Restricted
3. Safe Harbor Statement The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle. Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal/Restricted/Highly Restricted 3
4. Big Data SQL Goals Easily access any data across big data stores Provides a unified security model across the sources Analyze all data using Oracle’s rich SQL dialect Fast performance using Big Data SQL Smart Scan Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal/Restricted/Highly Restricted 4
5. Big Data SQL Architecture REST Python node.js SQL R Graph Java Oracle SQL Engine Oracle Big Data SQL Table Table Big Data-enabled Oracle Tables Storage Hive Leverage Metadata DN DN DN DN Data Local Processing Big Data SQL Cells Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal/Restricted/Highly Restricted
6. Big Data SQL Performance Features Compound IO Reduction thru Smart Scans 1 2 3 User Query 100 TB Partition Pruning 10 TB Storage Indexing 1 TB Predicate Pushdown 100 GB Copyright © 2017, Oracle and/or its affiliates. All rights reserved. 6
7. Flexible Deployment Options Engineered Systems Oracle Cloud Commodity Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal/Restricted/Highly Restricted 7
8. Scenario: On-line Movie Streaming Site • Data sources – Recommendations in NoSQL DB – User behavior in HDFS – Data Warehouse in Oracle Database • Gain value from all data! Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Confidential – Internal/Restricted/Highly Restricted 8
9. Hands-on Lab • Part 1 – Query raw JSON data • Part 2 – Leveraging Hive Metadata • Part 3 – Review performance features • Part 4 - Applying Oracle Database Security Policies Across the Big Data Platform • Part 5 – Using analytic SQL to query all data Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Confidential – Internal/Restricted/Highly Restricted
10. For More Information • OTN: Big Data Lite Virtual Machine (a free sandbox environment to get started): http://www.oracle.com/technetwork/database/bigdata-appliance/oraclebigdatalite-2104726.htmlOracle.com: https://www.oracle.com/big-data/index.html • Big Data SQL Blog: https://blogs.oracle.com/datawarehousing/big-data-sql-2 Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Oracle Confidential – Internal/Restricted/Highly Restricted 10
11. Copyright © 2017, Oracle and/or its affiliates. All rights reserved. Confidential – Oracle Internal/Restricted/Highly Restricted 11