sap sybase iq sunumu-sybase türkiye
DESCRIPTION
16 Mart 201TRANSCRIPT
Big Data Analytics with Sybase IQ
Mustafa KUTLUSybase Türkiye
SAP ANALYTICS & INNOVATION FORUM '12
© 2012 SAP AG. All rights reserved. 2
AGENDA
Big Data Analytics
Market Drivers
Sybase IQ Proven for Big Data
Sybase IQ 15.4 Revolutionizing Big Data Analytics
Summary
BIG DATA ANALYTICSMARKET DRIVERS
© 2012 SAP AG. All rights reserved. 4
BIG DATA ANALYTICS ISSUES
Dealing with volume, variety, velocity, costs, skills
© 2012 SAP AG. All rights reserved. 5
BIG DATA ANALYTICS MATURITY
*A McKinsey study titled “Big Data: Next frontier for innovation, competition, and productivity”, May 2011, has found huge potential for Big Data Analytics with metrics as impressive as 60% improvements in Retail operating margins, 8% reduction in (US) national healthcare expenditures, and $150M savings in operational efficiencies in European economies
From jargon to transformational business value*
© 2012 SAP AG. All rights reserved. 6
BIG DATA ANALYTICS IN THE REAL WORLD
Prevalent in data intensive verticals and functional areas
Sybase IQPROVEN FOR BIG DATA
© 2012 SAP AG. All rights reserved. 8
SYBASE IQ
Mature, industrial strength analytic DBMS
© 2012 SAP AG. All rights reserved. 9
SYBASE IQReferences
Maliye Bakanlığı – Gelir İdaresi Başkanlığı– Tax compliance data warehouse– 4 TB compressed data in IQ
Yapı Kredi Bankası– 50 TB compressed data in IQ– 3000 + users– 2000 ad-hoc queries per day
Türk Telekom– IQ as an enterprise reporting database– 80% data compression
© 2012 SAP AG. All rights reserved. 10
Turkcell Bank Asya İETT Anadolu Sigorta Digiturk Meteoroloji Genel Müdürlüğü Toprak Mahsulleri Ofisi PTT Mali Suçları Araştırma Kurulu Milli Emlak Genel Müdürlüğü
SYBASE IQReferences
© 2012 SAP AG. All rights reserved. 11
SYBASE IQArchitecture Diagram
© 2012 SAP AG. All rights reserved. 12
SYBASE IQFirst Columnar Database
- Sybase IQ’s “only-needed-colums” scan and disk I/O -
Select avg(salary) from employees group by department
Sybase IQ
Title Department Location Salary
© 2012 SAP AG. All rights reserved. 13
SYBASE IQPatented Indexes
Fast Project Compressed raw data for result sets (Default Index)Using IQ UNIQUE (cardinality) 1 byte FP - 0 < cardinality > 255 2 byte FP - 256 < cardinality > 65,536 3 byte FP – 65K < cardinality > 16 Million
Low Fast Low cardinality data (< 1500)
High Non Group Aggregation and range searches
High Group Key fields, High cardinality equality and groupings Multi-column indexes allowed
Date Date searches and date functions
Word, Text Keyword or phrase searches
Compare Data column comparisons ( >, <, !=, = )
© 2012 SAP AG. All rights reserved. 14
SYBASE IQData Compression
10TBOLTP
Database
Data + Indexes +Summary & Aggregate Tables
~3TBRaw Data
~1TB
Exported Raw Data
Up to 90% decrease in data storage costs
Sybase IQ DatabaseData + IndexesReady for Reporting !
Ease of backup and restore
Efficient use of data cache
© 2012 SAP AG. All rights reserved. 15
SYBASE IQ 15
A powerful Big Data Analytics platform in making decisions
SYBASE IQ 15.4REVOLUTIONIZING BIG DATA ANALYTICS
Click icon to add picture
© 2012 SAP AG. All rights reserved. 17
INTRODUCING SYBASE IQ 15.4
A comprehensive Big Data Analytics platform
© 2012 SAP AG. All rights reserved. 18
INTRODUCING SYBASE IQ 15.4
Focus areas overview
© 2012 SAP AG. All rights reserved. 19
INTRODUCING SYBASE IQ 15.4
Data management — compression and loading
© 2012 SAP AG. All rights reserved. 20
INTRODUCING SYBASE IQ 15.4
App services — native MapReduce using TPF API
© 2012 SAP AG. All rights reserved. 21
INTRODUCING SYBASE IQ 15.4
App services — integrating Sybase IQ + Hadoop
© 2012 SAP AG. All rights reserved. 22
INTRODUCING SYBASE IQ 15.4
App services — Sybase family of products integration
© 2012 SAP AG. All rights reserved. 23
SYBASE IQECO-SYSTEM – RICH MULTI-PRODUCT SUPPORT
© 2012 SAP AG. All rights reserved. 24
SUMMARY
A complete platform for data analytics use cases