Short Presentation Title - PDF 무료 다운로드

Retail 산업혁신을위한 SAP Database 전략 서원설 / D&T 2012 년 6 월 26 일

Market Trend

데이터베이스선택을위한게임의룰이변하고있다. 실시간 모바일 가상화 최적화 클라우드 빅데이터 총소유비용 (TCO) 효과

새로운접근법이필요! PAST FUTURE 실시간 모바일 가상화 최적화 클라우드 빅데이터 총소유비용 (TCO) 효과

SAP as Database Innovator SAP Database 전략및비전

SAP 데이터관리솔루션현황 SAP Sybase ASE SAP Sybase IQ SAP Sybase SQL Anywhere Sybase ESP, Replication Server, PowerDesigner, + SAP EIM 최고의 TCO 를제공하는 #1 트랜잭션데이터베이스 최고의 TCO 를갖춘 #1 분석전용데이터베이스 #1 모바일및임베디드데이터베이스 #1 통일된실시간 EIM 플랫폼 SAP HANA 실시간데이터플랫폼 파트너사에개방 2012 SAP AG. All rights reserved. 8

SAP 데이터활용현황 사용목적에맞는최적화된솔루션제공 Continuous Intelligence Transactions Real Time Business Open EWD Embedded ESP Event Stream Processing ASE Transaction processing HANA Real-time analytics & planning IQ Advanced EDW, SQLAnywhere Embedded mobile DB 활용용도 : 지속적인정보에대한즉각적인대응 ; 나타난기회와위협에대한즉각적인경고 ; 상황인식을통한새로운트랜잭션처리 ; 활용용도 : 사용자및솔루션어플리케이션개발 DB 를필요로하는전통적인 SAP 어플리케이션과 NW 구성요소에적용 활용용도 : 실시간분석, 새로운메모리기반어플리케이션 메모리기반데이터마이닝및의사결정지원환경 Business Suit 계획프로세스가속화 활용용도 : IQ 기반의분석어플리케이션, 향상된 DW 시나리오, Hadoop 상호연동, BW 및 HANA 를위한니어라인저장장치 활용용도 : 원격사무실과노트북을포함한모든주요기업용디바이스에서운영되는무선기업업무용어플리케이션 특장점 : 이벤트스트림분석과처리하기위한실시간어플리케이션을보다빠르고, 간편하게개발배포 ; 전문개발자에대한의존감소 ; 보다낮은 TCO 와보다탁월한유연성 특장점 : 전체적으로 TCO 를낮추면서탁월한신뢰성과성능을중시하는데이터기반의중요한업무어플리케이션지원 특장점 : 게임룰을바꾸는업무프로세스성능상의이점확보. 중복 ETL + materialization 제거를통한데이터지연감소 특장점 : 정형 / 비정형데이터를아우르는상관데이터분석을통한보다심도있는전망 다양한데이터솔루션을통해중요한기업데이터를비용효과적으로관리 특장점 : DBA 의지원이거의필요없는데이터기반어플리케이션을지원하기위해기본성능보장과자체관리기능을가진서버또는모바일어플리케이션에탑재 2012 SAP AG. All rights reserved. 9

PowerDesigner DBMS 시장을위한 SAP 혁신과정 Integrate Optimize Synthesize OLTP 및분석용데이터관리 OLTP 와분석모두에대한애플리케이션투명성 분석용계층형데이터 데이터이동선택최적화 리얼타임빅데이터 OLTP 를익스트림트랜잭션용으로확장 빅데이터를인메모리역량으로확장 모든데이터통합기법에걸쳐이동및인제스트능력최적화 리얼타임비즈니스 OLTP + OLAP 역량통합 (SAP + custom) 모바일적용확장 자율적데이터이동 오케스트레이션환경통폐합 SAP Sybase ASE SAP HANA SAP Sybase IQ SAP Sybase SQL Anywhere Open for Partners Sybase ESP, Replication Server SAP EIM SAP Real-time Data Platform 2012 SAP AG. All rights reserved. 10

Common Modeling Sybase PowerDesigner MPP Scale-Out HADOOP 3 rd Party DB Common Landscape Management SAP 데이터관리비전 : SAP 실시간데이터플랫폼 빅데이터 분석 클라우드 모바일 소셜미디어 3rd Party BI Client SAP Business Suite SAP Business Warehouse SAP Big Data Applications SAP Analytics SAP Mobile Custom Apps SAP NetWeaver (On Premise / Cloud) SAP 실시간데이터플랫폼 Open Developer APIs and Protocols SAP Sybase SQLA SAP Sybase ASE SAP HANA Platform SAP Sybase ESP SAP Sybase IQ SAP Sybase Replication Server SAP Data Services SAP MDG, MDM SAP Smart Data Services Platform SAP innovation without customer disruption 2012 SAP AG. All rights reserved. 11

Retail 산업지원데이터베이스구성 ASE V15.7, IQ V15.4, & HANA

Retail 산업의혁신키워드 실기간비즈니스와통찰력 대고객통찰력 현재운영시스템이고객지원을위해위해실기간으로운영할수있는가? 핵심고객보상프로그램을제공할수있도록고객프로필이적합하게구분되어있는가? 당신의고객구분전략을얼마나동적으로운영되고있는가? 대서비스통찰력 경쟁사에비해제품과서비스들이어떻게운영되고있는가? 실시간으로콜센터와 Social 미디어에서발생하는불만사항을추적하고있는가? 혁신방안들이기업내부어디에서활용되고있는가? 대 IT 운영통찰력 비즈니스에앞서 IT 를제공하고있는가? 어떻게중단없이수급전망을예측할수있는가? 비용, 품질, 시간에의해공급자망에서공급자들의순위를정할수있는가? 어떻게고객에대한전달율을구분하여나타낼것인가? 2012 SAP AG. All rights reserved. 13

SAP 데이터베이스지원방향 SAP Sybase ASE OLTP: Extreme Transaction 비용절감 TCO IDC Report Oct, 2011 Sybase ASE 를운영하는전체비용이타 DBMS 를사용시대비 28% 적게소요, 특히, 전체운영인력자원대비 27% 적게소요 TCO Category Total Deployment Costs Software License & Maintenance Servers, Storage, Power & Floor Sp ace DBA and Other Staffing Business Value/Opportunity Costs 28% less than other RDBMSs 31% less than other vendors ASE Savings 24% less storage capacity and 29% less processor power 27% fewer IT staff resources 89% less downtime annually (3.8 hours vs. 7.2 hours for other RDBMSs) Bloor Research Sept, 2011 Sybase ASE TCO, Sybase ASE VS Oracle 11g Sybase ASE 가비용측정항목의 85% 이상에서경제적인것으로조사되었으며, 비용, 관리, 지원모든항목을고려할경우 20% 이상저렴한것으로입증 SAP Sybase IQ OLAP: Smarter Analytic TCO 비교에있어 Oracle EXADATA 에비해 61% ~ 69% 낮음 시스템종속없이더적은하드웨어와복잡한구성제거 EXADATA 의 ½ 수준의하드웨어에서동일한성능제공 Sybase IQ 에비해 EXADATA 의경우 6 배이상에너지를소비, IQ 의에너지소비비용은 EXDATA 의 16% 수준 2012 SAP AG. All rights reserved. 15

SAP 데이터베이스지원방향 SAP Sybase ASE ERP on ASE 비용절감 TCO 가장최적화된 Database SAP 어플리케이션과 NETWEAVER 제품에최적화 표준 SAP tool 을통해어플리케이션과 DB 를통합관리 전체적인어플리케이션비용감소 License 및지원비용, 유지보수지원노력등이낮고 TCO 예측가능 DB 를위한추가적인지원비용없음 IT 스트레스감소 단일벤더를통한단일정책제공 SAP 어플리케이션과의제품주기와유지보수정책동기화 SAP 어플리케이션이 Sybase ASE 출시에맞추어자체인증되어제공 2012 SAP AG. All rights reserved. 16

SAP 데이터베이스지원방향 SAP HANA In Memory Computing Engine 실시간프로세스 사전구성된분석 In Memory Appliance 데이터모델링, 데이터관리, 보안등을위한통합관리환경제공 실시간데이터복제, ETL 데이터서비스와 SAP BO 클라이언트런타임을모두포함 다양한데이터소스환경의지원 HW Technology Innovations Multi-Core ( ~ 10 core CPU) MPP with many blades One blade < $50.000 64bit 주소체계 2TB 100GB/s data throughput 성능대비가격의급속한하락 SAP SW Technology Innovations Row and Column Store Compression Partitioning No Aggregate Tables SAP BI 4.0 Business Analytics Business Suite (ERP, CRM) Business Analytics In Memory 분석업무 / 산업별분석솔루션 OLTP + OLAP 결합 (2012 년이후 ) 2012 SAP AG. All rights reserved. 17

SAP 데이터베이스지원방향 SAP HANA 성능 PoC 결과 실시간프로세스 1) Mart 변경적재 테이블데이터건수분석계 HANA 개선비율 F_GBP_BP 88,918 건 1,132 초 10 초 113 배 UNICOM 11,660 건 1,416 초 13 초 109 배 2) 정형 Query 처리 Query 결과건수 분석계 HANA 개선비율 Heros's Idling 767 건 780 초 65 초 12 배 Account Number Monitoring by Agent 25 건 401 초 1 초 401 배 PL_FREIGHT_SUMMARY_BY_MONT H(GRAPH) 9 건 432 초 1 초 432 배 3) Data 압축률 테이블 데이터건수 파일 (MB) IBM DB(MB) HANA(MB) 압축비율 BSAS 94,635,488 건 - 59,477 7,788 87 % BSIS 80,469,866 건 - 62,828 1,545 97 % FAGLFLEXA 349,594,018 건 - 153,034 6,719 96 % O_MPLACDTL 142,227,572 건 37,071-9,471 75 % S_EQP_STOCK 297,035,953 건 33,720-17,099 50 % F_PL_SUMMARY 7,566,813 건 12,048-209 98 % 2012 SAP AG. All rights reserved. 18

SAP 데이터베이스지원방향 빅데이터와 Retail 산업 빅데이터구현 SERICEO 설문조사결과 (2012 년 4 월 ) Big Data 를알고있는비율은 56.4%, 적극활용하는경우는 19.4%, 현업의데이터실무자들이 Big Data 를실제보유하고활용하는한국기업은 10 개미만, 통신사, 포털업체, 온라인게임업체등 IT 업체가대부분, 다른산업에는거의없음. Retail: 금융권과더불어빅데이터활용이적합한산업 빅데이터접근 Business Big Data VS Enterprise Big Data 데이터속성 구분 Business Big Data Enterprise Big Data 정형정보위주반정형정보 + 비정형정보포함 데이터관리요구사항정확성, 정합성, 독립성 비정형정보위주반정형정보 + 정형정보 가용성, 확장성 데이터의중요도중요도높음중요도낮음 데이터서비스 Real Time 지원필수 Time Latency 허용 BI Tool 지원범위범용 Tool 지원필요 Open Source 기반의지원 사용자범위기업내다양한사용자지원필요 Data Scientists, Experts 등이주로사용 지원기술 RDBMS 기반의지원기술위주 SQL 기반의분산처리기술적용 Open Source 기술연계 Open Source 기반 Platform NoSQL 기반의분산처리시스템 Map/Reduce + Hadoop 적용 운영환경데이터통합운영이적합데이터분산환경이적합 2012 SAP AG. All rights reserved. 19

SAP 데이터베이스지원방향 SAP Sybase IQ Smarter Analytic 빅데이터구현 강력한분석전용 DBMS 국내에서가장많은사용되는 EDW 전용데이터베이스 최초의 Columnar 기반데이터베이스 개방환경구조지원 솔루션종속적인환경배제 제한없는동시사용자운영환경지원 복잡한운영환경에최적화 자유로운시스템확장기능 SAP Sybase IQ c 1 c 2 c 3 c 4 c 5 c 6 c 7 c 8 c 9 r1 r2 r3 r4 r5 2012 SAP AG. All rights reserved. 20

SAP 데이터베이스지원방향 SAP Sybase IQ Business Big Data Analytic Sybase IQ 핵심기능 : MultiPlex - PlexQ Technology 빅데이터구현 Logical Server (Virtual Data Mart) EDW CRM Finance R&D Node 01 Node 02 Node 03 Node 04 Node 05 Node 06 MultiPlex PlexQ Technology : Distributed Query Platform Shared Everything Massively Parallel Processing Elastic Grid Computing Volume Velocity Variety Complexity Skills Eco-System App. Services DBMS Big Data 분석플랫폼을위한완벽한 Three-Tier 구조 BI 솔루션, 데이터통합솔루션, DBA 관리솔루션, 패키지어플리케이션 In-Database 분석, 다양한개발언어지원, 웹기반의개발, 오픈소스지원 (Hadoop, R ) 고성능, 확장, 클라우드구현 2012 SAP AG. All rights reserved. 21

SAP 데이터베이스지원방향 SAP HANA + SAP Sybase IQ Hybrid Architecture 빅데이터구현 빅데이터관리 / 운영 / 지원을위한통합인프라구현 업무요구사항, 데이터유형에따른서비스구조제공 신속한데이터확장대응과과추가서비스제공 정형 Data 구매주문 실시간복제 (SAP SLT Replication) 이벤트처리 Operational Reporting 주기별적재 (SAP DS) 실시간 Dashboard 상시감사모니터링일부업무보고서 결제 정보계데이터허브 비정형 Data Call Center Log File SNS / Blog 이벤트처리 Sybase ESP Connector (SAP DS) 주기별적재 (SAP DS) EDW Agile Data Mart 과거데이터추이분석정기감사분석 CRM 전략경영정보상품개발 ( 시뮬레이션 ) 2012 SAP AG. All rights reserved. 22

감사합니다! 서원설 SAP D&T wsuh@sybase.com

2012 SAP AG. All rights reserved No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice. Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors. Microsoft, Windows, Excel, Outlook, and PowerPoint are registered trademarks of Microsoft Corporation. IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5, System x, System z, System z10, System z9, z10, z9, iseries, pseries, xseries, zseries, eserver, z/vm, z/os, i5/os, S/390, OS/390, OS/400, AS/400, S/390 Parallel Enterprise Server, PowerVM, Power Architecture, POWER6+, POWER6, POWER5+, POWER5, POWER, OpenPower, PowerPC, BatchPipes, BladeCenter, System Storage, GPFS, HACMP, RETAIN, DB2 Connect, RACF, Redbooks, OS/2, Parallel Sysplex, MVS/ESA, AIX, Intelligent Miner, WebSphere, Netfinity, Tivoli and Informix are trademarks or registered trademarks of IBM Corporation. Linux is the registered trademark of Linus Torvalds in the U.S. and other countries. Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks or registered trademarks of Adobe Systems Incorporated in the United States and/or other countries. Oracle is a registered trademark of Oracle Corporation. UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group. Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin are trademarks or registered trademarks of Citrix Systems, Inc. HTML, XML, XHTML and W3C are trademarks or registered trademarks of W3C, World Wide Web Consortium, Massachusetts Institute of Technology. Java is a registered trademark of Sun Microsystems, Inc. JavaScript is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented by Netscape. SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP BusinessObjects Explorer, StreamWork, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects Software Ltd. Business Objects is an SAP company. Sybase and Adaptive Server, ianywhere, Sybase 365, SQL Anywhere, and other Sybase products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Sybase, Inc. Sybase is an SAP company. All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only. National product specifications may vary. The information in this document is proprietary to SAP. No part of this document may be reproduced, copied, or transmitted in any form or for any purpose without the express prior written permission of SAP AG. This document is a preliminary version and not subject to your license agreement or any other agreement with SAP. This document contains only intended strategies, developments, and functionalities of the SAP product and is not intended to be binding upon SAP to any particular course of business, product strategy, and/or development. Please note that this document is subject to change and may be changed by SAP at any time without notice. SAP assumes no responsibility for errors or omissions in this document. SAP does not warrant the accuracy or completeness of the information, text, graphics, links, or other items contained within this material. This document is provided without a warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability, fitness for a particular purpose, or non-infringement. SAP shall have no liability for damages of any kind including without limitation direct, special, indirect, or consequential damages that may result from the use of these materials. This limitation shall not apply in cases of intent or gross negligence. The statutory liability for personal injury and defective products is not affected. SAP has no control over the information that you may access through the use of hot links contained in these materials and does not endorse your use of third-party Web pages nor provide any warranty whatsoever relating to third-party Web pages. 2012 SAP AG. All rights reserved. 25