12c Flashcards
12cr2 avail in cloud
Fall 2016
12cr2 avail on premises
March 2017
Exadata express GA DATE
9/17/16
Want pct of Helpdesk calls are 12c
40 pct
NYSE case study
ExData
350 TV
Large transactional systems
1 pb transactions daily
Mysql cloud service ga date
9/20/16
Db service on bare metal ga date
12/15/16
3 types exadata
Private cloud - Exadata db machine
Cloud @customer - Exadata cloud machine
Public cloud - Exadata cloud service
Project exacloud
Massive pool Exadata storage servers shared across thousands of dbs
Exadata moving from 40 FBI infiniband to
100 FBI/sec Ethernet
Nvram ga?
2018
Omega
Absolute avail No applis change In memory oltp Fast Scale out
Dw cloud service
Openworld
No dba
Load and go
Ula 2 Paas
$2 paas investment yields $1 support decrease
Exadata express cloud service pricing
X20 - $175/mo 20 gb
X50 - 750/mo 50 gb
X50-im- 50 FBI +dbim $950/mo
Oracle db machine learning product
Autonomous Health Framework
Ahf components
Hang Mgr Mem guard Who's mgt Cluster verif util Orachk Cluster health monitor Cluster health advisor Trace file analyzer
Big data sql query targets
Nosql (oracle nosql, apache hbase -no sql sits on hdfs)
Oracle db
Hadoop hdfs, apache hive (sql access hdfs), parquet (columnar storage in hdfs), apache orc(columnar storage for Hadoop), apache avro
Oracle db cloud services -4
Exadata express - 5/20/50 gb
Database cloud service - se2, we, HP, ep
Database cloud access bare metal
Exadata cloud avec - 42 TV - pbs
Big data sql storage differentiator
Smart query at storage - no sql, oracle db, Hadoop
Big data cloud service
3 node start Cloudera full - cdh, spark(in memory query engine), impala(sql query engine), hbase, kafka - handle real time data feeds Oracle big data connectors Big data spatial and graph Odi Bdd Big data sql - coming
Free db cloud service when?
End 2017
Masking and audit vault svcs eta?
Q4 2017
Zdlra service eta
End 2017
Big data cloud machine eta?
End 2017
Sparc m7 cores ghz
32 core
4 ghz
Sparc m7 software in silicon
How many database Accel engines on chip?
32
Sparc m7 simd vector
Independent search for all values that match calif in a column -170b rows/sec
Capacity in silicon m7
Doubles memory capacity by compressing data on chip and m7 adds 32 decompress engines
ExadatA sl6
Sparc Linux 6
X86 database servers replaced. Y sparc servers
2x faster than x86
32 core sparc m7
Exadata cloud service
All advanced options included
Compute. Bursting
Min cores for exdata cloud machine
16
Amazons compute and storage services
Amazon elastic compute cloud - ec2
Amazon simple storage service - s3
Amazon database offerings
Redshift - dw
AurorA - mysql compatible db
Dynamodb - nosql
Amazon relational database service - supports mysql, oracle db, sql server, postgresql, Maria db
Amazon EMR -
Elasticache - IMDb
Simpledb
Non volatile memory
Between flash and dram speed wise
Survive power failure
Better write endurance than flash
Larger capacity than dram
Cost bête flash and dram