Oracle Big Data Acquire Hadoop Oracle No SQL
Платформа Oracle для Big Data Acquire Hadoop Oracle No. SQL Database Open source R Analyze Visualize & Decide Oracle Event Processing Oracle Real. Time Decisions Oracle Advanced Analytics Or Oracle Big Data Connectors Data Warehouse Oracle Applications Oracle Data Integrator Database In-Database Analytics Stream Organize & Discover Oracle Business Intelligence Applications Oracle Business Intelligence Tools Oracle Endeca Information Discovery
Платформа Oracle для Big Data Stream Acquire Organize & Discover Analyze Visualize & Decide
История развития технологий Oracle Database для сверхбольших хранилищ данных 1995 1997 Oracle Release 7. 3 Oracle 8 1999 Oracle 8 i 2001 Oracle 9 i 2003 Oracle 9 i. R 2 2005 Oracle 10 g 2008 Oracle 11 g Automatic Storage Exadata Management Compression Real Application Первый 100 TB закзачик: Yahoo! Clusters Первый 30 TB заказчик: France Telecom Composite Partitioning Первый 10 TB заказчик: Amazon. com Range Partitioning Parallel Execution Более 100 терабайтных заказчиков Первый 1 TB заказчик: Acxiom Первая 1 TB БД построена в лаборатории
<Insert Picture Here> Что такое Oracle Exadata?
Пространственные данные в таблицах Oracle Типы данных и модели: Вектор SDO_GEOMETRY SDO_TOPO_GEOMETRY Растр ID NAME SURFACE LANES 1 Pine Cir. Асфальт 4 2 2 nd St. Асфальт 2 3 3 rd St. Асфальт 2 SDO_GEORASTER GEOMETRY
Возможности Oracle Spatial and Graph
<Insert Picture Here> Oracle и Big Data
Map. Reduce. Пример Input Reader The cloud is water vapor. But is water vapor useful? But it is! Map process the, 1 vapor, 1 cloud, 1 but, 1 is, 1 water, 1 Map process water, 1 but, 1 vapor, 1 it, 1 useful, 1 is, 1 Partition, Compare, Redistribute the, 1 is, 1 cloud, 1 but, 1 is, 1 Water, 1 vapor, 1 it, 1 water, 1 useful, 1
Map. Reduce. Пример. the, 1 is, 1 cloud, 1 but, 1 is, 1 Reducer the, 1 is, 3 cloud, 1 but, 2 Consolidate and Write water, 1 vapor, 1 it, 1 water, 1 useful, 1 Reducer water, 2 it, 1 vapor, 2 useful, 1 the, 1 is, 3 it, 1 cloud, 1 but, 2 useful, 1 water, 2 vapor, 2
Oracle Data Integrator
Oracle CEP: Выявление шаблонов Торговля на бирже – шаблон “W” Y X Z W days 1 9 12 19 SELECT FIRST(x. time), LAST(z. time) FROM ticker MATCH_RECOGNIZE (ONE ROW PER MATCH PARTITION BY name PATTERN (X+ Y+ W+ Z+) DEFINE X AS (price < PREV(price)) Y AS (price > PREV(price)) W AS (price < PREV(price)) Z AS (price > PREV(price)))
<Insert Picture Here> Big Data Что такое Big Data Appliance?
Oracle Big Data Appliance Hardware • 18 Sun X 4270 M 2 Servers – 48 GB memory per node = 864 GB memory – 12 Intel cores per node = 216 cores – 36 TB storage per node = 648 TB storage • 40 Gb p/sec Infini. Band • 10 Gb p/sec Ethernet
Oracle Big Data Appliance Software • Oracle Linux 5. 6 • Java Hotspot VM • Cloudera Hadoop Distribution Hadoop Core, HDFS, Hive, HBase, Zookeeper, Oozie, Mahout, Sqoop, Administration Tools • R Distribution • Oracle No. SQL Database • Oracle Adapters for Hadoop: –Oracle R Connector for Hadoop –Oracle SQL to HDFS Connector –Oracle Data Integrator Application Adapter for Hadoop –Oracle Loader for Hadoop
Платформа Oracle для Big Data Acquire Hadoop Oracle No. SQL Database Open source R Analyze Visualize & Decide Oracle Event Processing Oracle Real. Time Decisions Oracle Advanced Analytics Or Oracle Big Data Connectors Data Warehouse Oracle Applications Oracle Data Integrator Database In-Database Analytics Stream Organize & Discover Oracle Business Intelligence Applications Oracle Business Intelligence Tools Oracle Endeca Information Discovery
Платформа Oracle для Big Data Stream Acquire Organize & Discover Analyze Visualize & Decide
Если есть вопросы Andrey. Pivovarov@oracle. com http: //Oracle. BI. RU http: //www. oracle. com/bigdata
- Slides: 40