Database 12cR2 legújabb release Big Data és adatintegráció a hibrid felhőben Fekete Zoltán Principal Presales Consultant
CEE Database Cloud Presales, Big Data Expert blogs.oracle.com/zfekete 2016. november 22.
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 © 2016, Oracle and/or its affiliates. All rights reserved. |
3
Oracle Database 12c folyamatos fejlődés 1990s Client-Server Oracle 5, 6, 7, 8
2000s
2010s
Internet
Cloud
Oracle 8i, 9i, 10g
Oracle 11g, 12c
Scalability
Row Level Locking, B-tree Indexes, Read Consistency, Parallel Server, Shared Cursors, Shared Server
Real Application Clusters, Automatic Storage Management, IOTs Advanced Compression, Bitmap Indexes
Exadata, Smart Flash, In-Memory DB, Software-in-Silicon, Native Database Sharding
Availability
Transactions, Ref Integrity, Online Backup, Point-in-Time Recovery
Data Guard (Active), Recovery Manager, Flashback, Clusterware, Online DDL, TAF
Zero Data Loss Recovery Appliance, Edition Based Redefinition, App. Cont.
Analytics
Partitions, Parallel SQL, Optimizer
Analytic Function, Data Mining, OLAP, MVs
Security
Privileges, Roles, Auditing, Network Encryption, Views
Data Encrypt, Masking, Virtual Private DB, Label Security, DB Vault, Audit Vault, PKI
Developers
SQL, Views, PL/SQL, Triggers, LOBs, Object Types, Spatial, Text
Java in DB, Native XML, Table Functions, .Net, PHP, App Express, SQL Developer
Management
Enterprise Manager, v$, wait event
Diagnostics, Tuning, Testing, Lifecycle Packs
MultiTenant, DB & Exa Cloud, DB Appl
Integration
DB Links, 2PC, Replication, AQ
GoldenGate, XA Transaction,External Table
Big Data SQL, Big Data Analytics
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. | Public
SQL Pattern Match, R, Big Data Appl Real Application Security, DB Firewall, Privilege Analysis, Redaction, Key Vault Native JSON, REST Services, Node.js, RDF Social Graph, Network Graph
4
Bejelentés: Oracle Database 12c Release 2 on Oracle Cloud • Elérhető most: – Exadata Express Cloud Service – Database Cloud Service – Exadata Cloud Service
• Elérhető decembertől – Exadata Cloud Machine cloud@customer
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
5
Transzformáció a Database-re optimalizált felhőre • Alacsonyabb költség – Sok adatbázis egységes menedzselése
• Nagyobb agilitás – Gyors létrehozás, klónozás, mozgatás
• Elasztikus skálázhatóság – Scale-up, scale-out és scale-down
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
7
Alacsonyabb költség On-prem
• Előre fizetés – csúcs kapacitás szükségletre
a Database-re optimalizált felhőre • Használat alapú fizetés – capacity on-demand
• Manuális létrehozás és upgrade
• Önkiszolgáló létrehozás és upgrade
• Magas működtetési költségek
• Alacsony működtetési költségek
– sok adatbázis menedzselése
– menedzselés: Many-as-One
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
8
Oracle Database 12c Multitenant architektúra DW ERP
CRM
• Adatbázis virtualizálás: Container Database – Változatlan alkalmazások
• Kisebb OpEx – Menedzselés: sok PDB-t egyben
• Kisebb CapEx – Több PDB szervernként Container Database
• Agilisabb – gyors provisioning, mozgatás és klónozás
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
9
ÚJ: 12.2 on Oracle Cloud
Nagyobb konszolidáció és izoláció, skálázhatóság
Pricing
Retail
• Akár 4 096 PDB / container
• Memória, CPU és I/O resource prioritás szabályozás • Konfigurálható izoláció a privát és publikus cloud között
Container Database
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
10
Agilitás On-prem
• Manuális database konfigurálás – Teljes HW/SW megtervezése
a Database-re optimalizált felhőre • Önkiszolgáló adatbázis provisioning – Kiválasztás a felhő szolg. listáról
• Hónapok alatt lesz bevezetve, upgrade-elve
• Percek alatt kész
• Single tenant adatbázisok
• Multitenant container adatbázisok – Hot cloning és PDB áthelyezés
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
11
ÚJ: 12.2 on Oracle Cloud Online PDB műveletek
CRM
• PDB Hot Clone
HR
– Gyorsabb test master létrehozás
• PDB frissítés – Egyszerűen a legfrissebb adatokra
• PDB áthelyezés – Leállás nélkül
Oracle Cloud Pricing
Retail
CRM
On-Premises Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
12
Elasztikus skálázhatóság On-prem • Manuális scale-up és scale-out RAC klaszterek – Nincs bursting
a Database-re optimalizált felhőre • Önkiszolgáló scale-up és scale-out RAC klaszterek – Van bursting
• Csúcsra tervezve
• Capacity on-demand
• Masszív skálázhatóság és megbízhatóság
• Masszív skálázhatóság és megbízhatóság
– Manuális adatbázis sharding
– Automatikus adatbázis sharding
Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
13
Egyedülálló scale-out és hibatűrés: Oracle RAC Az alkalmazásokon nem kell változtatni
• Szerver hibáktól megvédi az adatbázist • Scale-out: adatbázis teljesítmény – Egyszerű bővíteni, szűkíteni: bursting
• A világ legnagyobb OLTP és DW rendszereit támogatja • ÚJ: 12.2 on Oracle Cloud – Multitenant database-re optimalizált – Scale-out: node-ok százaira
Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
14
ÚJ: 12.2 on Oracle Cloud Natív Database Sharding: masszív skálázhatóság és megbízhatóság: OLTP
Customers Americas
Customers Europe
• RAC és Data Guard az alkalmazások 99%-ára: alkalmazásokat nem kell változtatni • Néhány globális OLTP alkalmazás számára: sharding nagy adatbázisok kisebb adatbázisokra darabolása • Alkalmazást erre kell tervezni, hogy a farm egyes shardjaira automatikus routing legyen
Customers
Customers Asia
• SQL a sharded táblákra, akár sok ezer shard
One giant database partitioned into many small databases (shards) Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
15
Oracle Database 12c In-Memory Teljesítmény a nagyvállalati felhőre is Valós idejű analitika
Teljesítmény
Egyszerű implementálni
12.1 OLTP & Analytics on same single server or RAC database
Sub-second reporting & analytics
No application changes
SQL in Silicon
In-Memory on Exadata Flash
12.2 Offload analytics to Active Data Guard standby
3x faster joins, 10x faster expressions, 60x faster JSON
Dynamic data movement between storage & memory
Copyright © 2016 Oracle and/or its affiliates. All rights reserved.Public
16
Oracle Exadata Cloud Service #1 adatbázis az adatbázisra optimalizált felhőkben Online Scale-up Through Hourly Compute Bursting
• Oracle Database az összes opcióval
Burst 16 OCPU
• Elasztikus skálázhatóság és online bursting – nem kell csúcsra tervezni a belépéskor
16 8
• Egységes, minden workload-ra: OLTP, DW, konszolidáció, stb.
0
OCPUs
24
32
• Leggyorsabb és legmegbízhatóbb Database Cloud Platform
Month 3
Month 4
End of Quarter
Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
Confidential – Oracle Internal
17
100% kompatibilis Hybrid Cloud Együttműködés és migráció: privát és publikus felhő között
On-Premises
Ugyanaz az architektúra Ugyanaz a szoftver Ugyanaz a tudás Ugyanaz a support Ugyanazok a fejlesztő eszközök
Oracle Cloud
Automatizált mozgatás: alkalmazás és adat Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
18
Választási lehetőségek: Exadata Exadata Database Machine
Exadata Cloud Machine
Exadata Cloud Service
Customer Data Center
Customer Data Center
Oracle Cloud
Vásárlás
Előfizetés
Előfizetés
Customer Managed
Oracle Managed
Oracle Managed
Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
19
Bejelentés: Exadata Express Cloud Service Egyszerűen használható, legkisebb költségű Database Cloud Service, 12.2
#1 Database, opciókkal együtt, Exadatán Teljesen Oracle által menedzselt
Alacsony költség: 175 $ / hónaptól
Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
20
Oracle Database Cloud szolgáltatások családja Belépő szinttől a működéskritikus alkalmazásokig
Exadata Express
Enterprise
Database Development SMB & Departmental Applications Enterprise Applications Highest availability, scalability and performance Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
Exadata
LiveSQL.oracle.com – ingyenes • SQL scratch pad in the Oracle Cloud
• Ingyenes: 2015. OOW • Google kereshető SQL szintaxis • Elmenthető és megosztható SQL példák
• Tervezett integráció az Oracle dokumentációval
Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
Transzformáció: Database Optimized Cloud Transform how you do business Gain massive scalability in the cloud to rapidly grow your business Extend your datacenter and preserve your existing investment Accelerate Test / Dev cycles
Secure data with the best data management cloud platform Focus on higher value tasks that directly impact your business
Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
28
Big Data, DW & SQL innováció
Copyright © 2016 Oracle and/or its affiliates. All rights reserved.Public
29
30
Transforming to Big Data From Data Warehouse
To Big Data
• Relational
• Relational + Hadoop and NoSQL
– On-Premises
– On-Premises + Cloud
• Transactional data
• Transactional + Social, Web and IoT
• Analytics + Data Mining
• Analytics + Data Mining + Machine Learning
Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
31
Analytics – Continuous Innovation & Improvement
1990s Client-Server Epoch
Analytics
2000s
2010s
Internet Epoch
Oracle 5, 6, 7, 8
Oracle 8i, 9i, 10g
Partitioned Tables/Indexes Parallel Query (SQL) Cost Based Optimizer Queries on Hierarchies Direct Data Load
Analytic Functions Data Mining OLAP Materialized Views Resource Manager
Cloud Epoch Oracle 11g, 12c Big Data Appliance SQL Pattern Matching R Analytics
Copyright © 2016 Oracle and/or its affiliates. All rights reserved.Public
32
Oracle Big Data SQL From Data Warehouse To Big Data REST
Java
Data Lake
node.js
SQL
Python
Data Warehouse
R
Scala
Consolidate ApplicationsMetadata Analytics Fast Data Silos across Unique Architecture to Simplicity Complexity deliver Performance: Specialization Fragmentation Optimize queries Performance Delays Pushing down processing Extend Security model
Social, Web
Transactional
IoT
Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
33
Comprehensive Data Science Capabilities Any analysis across relational, Hadoop, Spark and NoSQL Graph
Machine Learning
• Massively-Scalable Graph Database
• Scale to big data using R and SQL
• 40+ in-memory parallel algorithms
• 40+ parallel, distributed algorithms
• Simple standard interfaces: R, Python...
• Automated data preparation and modeling
• Enhances and extends SparkML
Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
34
Faster Time to Results: Graph
Oracle PGX outperforms GraphX up to 160X
• Parallel and Distributed Graph Processing • Ultra balanced workload partitioning using state-of-the-art, proprietary techniques
Execution Time (seconds) log scale
• Optimized for InfiniBand network
1000
100
10
1 2
4
8 Cluster Size
16
32
Weakly Connected Components (WCC) 1.4 Billion edge graph Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
35
Oracle Cloud Platform for Big data Innovation through data experiments and advanced analytics
COLLECT
Connect people to information they need
MANAGE
Manage, secure and make all data available
ANALYZE EXPERIMENT & ACT
Transform workplace and workforce through insights
36
COLLECT
MANAGE
EXPERIMENT
DataFlow ML CS Big Data Preparation CS IoT CS GoldenGate CS Event Hub CS Data Integrator CS
Big Data CS NoSQL Database CS Big Data CS CE Big Data SQL CS NoSQL Database CS Exadata CS
Big Data Discovery CS Stream Analytics CS* R on Hadoop* Spatial and Graph*
ANALYZE & ACT Data Visualization CS Business Intelligence CS Spatial and Graph* Advanced Analytics* R on Hadoop*
* Bundled with other Cloud Services 37
Choice of Big Data Cloud Services Big Data CS
Announcing Big Data CS – Compute Edition
• Spark and all Hadoop services
• Spark and HDFS services
• Bursting new
• Fully Elastic
• Dedicated compute and storage
• Shared compute and storage
• Automated, Flexible
• Fully Managed
• Includes: R, multimedia, Spatial, Graph analytics; data integration tools, Cloudera Enterprise Data Hub
• Big Data SQL Cloud Service coming Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
38
Choice of Big Data Deployment Models Big Data Appliance
Big Data Cloud Machine
Big Data Cloud Service
Customer Data Center
Customer Data Center
Oracle Cloud
Purchased
Subscription
Subscription
Customer Managed
Oracle Managed
Oracle Managed
Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
39
Data Integration For Everyday Moments • • • • • • • • • • • • •
Use Starbucks loyalty card to buy a Latte Pay for a purchase with PayPal Withdraw cash at an ATM from Bank of America, or Citibank, or Wells Fargo, or CapitalOne, or American Express, or JP Morgan Chase, or… most other banks in the world Click on an Google AdWords link Select a recommended item from EBay.com Buy something from Amazon Use a store coupon from Safeway Check flight availability on American Airlines Use the Cartwheel App at Target stores Take your General Motors car in for service Go shopping at Macy’s online store on Black Friday Buy a song on Apple iTunes Change your profile or add a skill on LinkedIn.com
Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
Oracle Confidential
40
1. DBusiness Continuity A A ATA
Five Core Capabilities
LWAYS VAILABLE
2. Data Movement DATA ANYWHERE IT’S NEEDED
3. Data Transformation D A F ATA
CCESSIBLE IN ANY ORMAT
4. Data Governance D ATA THAT CAN BE TRUSTED
5. Streaming Data DATA IN MOTION OR AT REST
Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
Eight Core Products
Cloud or OnPremise Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
43
Oracle GoldenGate Cloud Service for Database Replication Database as a Service
On Premises GGCS
Database Cloud Service
Exadata Cloud Service
Hadoop as a Service* GGCS GoldenGate
Big Data Cloud Service
3rd Party Cloud
*: Expected in FYQ1
Real-time Data Replication Service in Oracle Cloud via Subscription or Hourly basis
Key Benefits
GoldenGate
3rd Party Cloud
GoldenGate Cloud Service
Changed Data delivery is more effective than batch processes No Data Loss reliable and proven core GG technology Realtime Data always up to the moment replication & visibility
3rd Party Cloud Migrate from Amazon any database from AWS RDS Deliver to 3rd Party Clouds from on-premise databases
Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
44
For More Information Oracle Database Cloud 30-Day Free Trial cloud.oracle.com/database www.facebook.com/OracleCloudComputing @OracleCloudZone #OracleCloud
Copyright © 2016 Oracle and/or its affiliates. All rights reserved.
45
Copyright © 2016, Oracle and/or its affiliates. All rights reserved. |
46