SAP HANA vs Oracle

Simple report about SAP HANA vs Oracle, but it covers about the history of storages and benefit of in-memory processing.

Transcript

1. ੿࢚ળ HANA vs.
2. ࣽࢲ
3. ࣽࢲ HANA
4. ࣽࢲ HANA = In Memory DB
5. ࣽࢲ HANA Databaseо ו۰ࢲ = In Memory DB
6. ࣽࢲ HANA Database = = In Memory DB
7. ࣽࢲ HANA Database HDD ࠁ׮ ࡅܲ RAM = = In Memory DB
8. ࣽࢲ HANA Database HDD ࠁ׮ ࡅܲ RAM ੷੢੢஖੄ ৉ࢎ = = = In Memory DB
9. = = = ࣽࢲ HANA HDD ࠁ׮ ࡅܲ RAM Database ੷੢੢஖੄ ৉ࢎ ࢸݺ ࣽࢲ In Memory DB
10. 1. DBח ৵ కয լաਃ?
11. ীפঈ੄ ١੢ = ҅࢑ӝ Reference: http://ftp.arl.mil/ftp/historic-computers/, Copyright Rovio Entertainment Ltd.
12. ীפঈ੄ ١੢ = ҅࢑ӝ Reference: http://ftp.arl.mil/ftp/historic-computers/, Copyright Rovio Entertainment Ltd.
14. Data
15. Data Data Data
16. ؘ੉ఠ ૐо = DB ࣻਃ Copyright (C) Apple Inc., Template - CoreData.icns
17. Ӓؘ۠
    ࢿמ੉
    ݅઒झۣ૑
    ঋই
    ৵
    Ӓ۠Ѧө
18. 2. ੷੢੢஖੄ ৉ࢎ
19. زҷ ߷ച Reference: http://en.wikipedia.org/wiki/File:AltamiraBison.jpg
20. ੗ӝ ప੉೐ Reference: http://en.wikipedia.org/wiki/File:Quarter-Inch_Cartridges.jpg
21. ೞ٘ ٣झ௼ Reference: http://en.wikipedia.org/wiki/File:Seagate_ST33232A_hard_disk_inner_view.jpg
22. ۔ Reference: http://en.wikipedia.org/wiki/File:4GB_DDR3_SO-DIMM.jpg
23. ޙઁ = וܽ HDD
24. HDDо ঴݃ա וܽоਃ
25. HDDо ঴݃ա וܽоਃ ؀৉಩ ߈਽ ࣘب CPU GPU RAM RAM HDD 25.6GB/s 0.32ns 153GB/s 0.83ns 17.06GB/s 6ns 120MB/s 4.16ms
26. HDDо ঴݃ա וܽоਃ 0 50 100 150 200 CPU GPU RAM HDD 0 1.5 3.0 4.5 6.0 ؀৉಩ ߈਽ ࣘب GB/s ns
27. ׹׹ೞפө
28. ؀৉಩ = ੍ӝ ࣘب
29. Contributed by AvatarP
30. ؀৉಩ = ੍ӝ ࣘب 3.63GB LEGENDS LEAGUEof League of Legends and Riot Games Inc. are trademarks or registered trademarks of Riot Games, Inc.
31. ؀৉಩ = ੍ӝ ࣘب 30ୡ 3.63GB LEGENDS LEAGUEof League of Legends and Riot Games Inc. are trademarks or registered trademarks of Riot Games, Inc.
32. ؀৉಩ = ੍ӝ ࣘب 30ୡ 0.21ୡ 3.63GB LEGENDS LEAGUEof League of Legends and Riot Games Inc. are trademarks or registered trademarks of Riot Games, Inc.
33. ؀৉಩ = ੍ӝ ࣘب 30ୡ 0.21ୡ 3.63GB LEGENDS LEAGUEof League of Legends and Riot Games Inc. are trademarks or registered trademarks of Riot Games, Inc. ߓ
34. ߈਽ ࣘب CPU HDD
35. ߈਽ ࣘب CPU ੗ܐખ ׮য় HDD
36. ߈਽ ࣘب CPU ੗ܐખ ׮য় ܻ٘ѷणפ׮ HDD
37. ߈਽ ࣘب CPU ੗ܐખ ׮য় ܻ٘ѷणפ׮ HDD 4.16ms
38. ߈਽ ࣘب CPU ੗ܐખ ׮য় ܻ٘ѷणפ׮ RAM
39. ߈਽ ࣘب CPU ੗ܐખ ׮য় ܻ٘ѷणפ׮ RAM 6ns
40. HDD RAM ߈਽ ࣘب
41. HDD RAM 4.16ms 6ns ߈਽ ࣘب
42. HDD RAM 4.16ms 6ns 1ୡ ߈਽ ࣘب
43. HDD RAM 4.16ms 6ns 1ୡ 8ੌ ߈਽ ࣘب
44. HDD RAM 4.16ms 6ns 1ୡ 8ੌ ߈਽ ࣘب  ߓ
45. ஹೊఠ ҳઑ
46. ஹೊఠ ҳઑ CPU
47. ஹೊఠ ҳઑ CPU GPU
48. ஹೊఠ ҳઑ CPU GPU Chipset
49. ஹೊఠ ҳઑ CPU GPU 16GB/s (PCIe v3.0) Chipset
50. ஹೊఠ ҳઑ CPU GPU 16GB/s (PCIe v3.0) Chipset 17GB/s (DDR3-2133)
51. ஹೊఠ ҳઑ CPU GPU 16GB/s (PCIe v3.0) 25.6GB/s (QPI@3.2GHz) Chipset 17GB/s (DDR3-2133)
52. ஹೊఠ ҳઑ CPU GPU 16GB/s (PCIe v3.0) 25.6GB/s (QPI@3.2GHz) Chipset 17GB/s (DDR3-2133) 0.1GB/s
53. ஹೊఠ ҳઑ CPU GPU 16GB/s (PCIe v3.0) 25.6GB/s (QPI@3.2GHz) Chipset 17GB/s (DDR3-2133) 0.1GB/s ߽ݾഅ࢚
54. )%%ܳ
    ॳח
    ੉ਬח
55. ࠺ऴ
    3". )%%ܳ
    ॳח
    ੉ਬח
56. 3. ڄয૑ח ݫݽܻ оѺ
57. 1955 109 1 10-5 $/1MB Reference: http://www.jcmit.com/mem2012.htm 2010
58. 1955 109 1 10-5 $/1MB Reference: http://www.jcmit.com/mem2012.htm 2010 DIMM SIMM IC
59. 1955 109 1 10-5 $/1MB Reference: http://www.jcmit.com/mem2012.htm 2010 DIMM SIMM IC Flash
60. 1955 109 1 10-5 $/1MB Reference: http://www.jcmit.com/mem2012.htm 2010 DIMM SIMM IC Flash HDD
61. 1955 109 1 10-5 $/1MB Reference: http://www.jcmit.com/mem2012.htm 2010 DIMM SIMM IC Flash HDD ݆੉ ղ۷׮
62. Ӓېࢲ աৡѪ੉
63. In Memory DB
64. In Memory DB
65. In Memory DB Data Data
66. In Memory DB Data Data
67. In Memory DB • ݫݽܻо ऱ૑פө • ݫݽܻо ࡅܰפө • ݆਷ ؘ੉ఠ ૊द ࠙ࢳ
68. ৘ܳ ٜযࠁݶ • DB • ݽٚ द೷ ੿ࠁ • ١ࣻо ҾӘ
69. ৘ܳ ٜযࠁݶ • ա੄ ࢿ੸ ઑഥ • ࣻъ ղ৉ оઉয়ӝ • ࣻъ ղ৉ ߹ ੼ࣻ • ١ࣻ ҅࢑ೞӝ • ࠁৈ઱ӝ Data Data
70. ৘ܳ ٜযࠁݶ • ա੄ ࢿ੸ ઑഥ • ݒ द೷ 10ޙઁ * 2ߣ • ೠ ೟ӝ 6җݾ • 8೟ӝ • ࣻъࢤ 20ݺ • 10*2*6*8*20*4.16ms = 79ୡ Data Data
71. 예를 들어 일본 노무라연구소는 인메모리 컴퓨팅을 이용해 도쿄에서 운행하고 있는 1만2000대 택시에서 발생하는 교통정보를 1초에 분석해 최단 이동경로를 운전자들에게 제공한다. 교통흐름을 실시간으로 분석 해 막히지 않는 구간을 안내하는 것. 택시들이 최단 이동 경로로 움직이기 때문에 교통 혼잡으로 인한 손실을 막을 수 있다. 또 단순히 택시 회사의 이익뿐 아니라 교통 분산 효과를 가져오기 때문에 공공인프라 개선이라는 부수적 효과도 가져온다. Reference: http://www.ddaily.co.kr/news/news_view.php?uid=99448
72. 예를 들어 일본 노무라연구소는 인메모리 컴퓨팅을 이용해 도쿄에서 운행하고 있는 1만2000대 택시에서 발생하는 교통정보를 1초에 분석해 최단 이동경로를 운전자들에게 제공한다. 교통흐름을 실시간으로 분석 해 막히지 않는 구간을 안내하는 것. 택시들이 최단 이동 경로로 움직이기 때문에 교통 혼잡으로 인한 손실을 막을 수 있다. 또 단순히 택시 회사의 이익뿐 아니라 교통 분산 효과를 가져오기 때문에 공공인프라 개선이라는 부수적 효과도 가져온다. Reference: http://www.ddaily.co.kr/news/news_view.php?uid=99448
73. 실시간 처리 실시간 분석 실시간 예측 인공지능 사용자 프로파일링 무서운 미래
74. ORLANDO, Fla. — HP and SAP AG (NYSE:SAP) today announced advancements to a joint initiative, codenamed “Project Kraken,” to improve business processes and mitigate risks for customers. ... Project Kraken’s goal is to provide customers additional choice in scalability for large, online transaction processing applications, with requirements for real-time analytical insights into this data. This allows organizations, including retailers, financial institutions, utilities and governments, another alternative to quickly detect patterns, analyze massive data volumes on the fly, and perform their operations quickly. The prototype system, optimized with 16 Intel® Xeon® processor E7 family (codenamed Ivy Bridge-EX) central processing units (CPUs) and 12 terabytes of memory, has been engineered specifically for complex, data-intensive workloads. These include supply chain, customer relationship management (CRM), enterprise resource planning (ERP) and data analysis. HP and SAP chose Intel processors because of the company’s leading-edge technology that enables customers to improve system performance. HP and SAP Advance SAP HANA through Joint Innovation SAP, SAP HANA and all SAP logos are trademarks or registered trademarks of SAP AG in Germany and in several other countries. Intel and Xeon are trademarks of Intel Corporation in the U.S. and other countries.
75. • Project Kraken • ؀ഋ DBীࢲ पदр ࠙ࢳ • ಁఢ ଺ӝ, ؀ਊ۝ ؘ੉ఠ पदр ࠙ࢳ ١ • 16 Intel® Xeon® processor E7 • 12 TB ݫݽܻ (12,228 GB) HP ৬ SAP ഈ۱
76. Apple NAB Bay (2007), Photo from http://sysadminporn.com/wp-content/uploads/2011/01/Xserve-HD_2560.jpg
77. 1 U =
78. 1 U = 44.45mm
80. Apple XServe, http://www.creativeplanetnetwork.com/videography/uploadedimages/VideoGraphy/Videography_News/0408AppleXserve-1bg.jpg 79cm 48cm
81. SuperComputing 2012, IBM Power7, Photo from http://hpc.uark.edu/hpc/blog/sc12.html
82. 4. Ӓٜ਷ ־ҳੋо
83. Public Domain by amadeusm
84. • 1972֙ ةੌীࢲ ࢸ݀ • ERPҙ۲ (੹ࢎ੸ ੗ਗ ҙܻ) • ERPীח DBо ೙ਃ
85. द੢ ੼ਬਯ SAP Salesforce Oracle Microsoft Amdocs Other Source: Market Share Analysis: ERP Software, Worldwide, 2012, http://www.forbes.com/sites/louiscolumbus/2012/12/04/roundup-of-crm-forecasts-and-market-estimates-2012/
86. द੢ ੼ਬਯ 19% SAP Salesforce Oracle Microsoft Amdocs Other Source: Market Share Analysis: ERP Software, Worldwide, 2012, http://www.forbes.com/sites/louiscolumbus/2012/12/04/roundup-of-crm-forecasts-and-market-estimates-2012/
87. Video: http://youtu.be/KT5XMBzWpMc
88. Reference: http://www.flickr.com/photos/93755244@N00/4140459965 by dahlstroms
89. • 1977֙ ޷Ҵীࢲ ࢸ݀ • ഥࢎਊ H/W, S/W (ౠ൤ DB) • ݆਷ ഥࢎ ੋࣻ (85 + 11 ੉࢚) • SUN(Java) - $7.4B @ 2010 #3 • MySQL - ($1.0B @ 2008 #9) • PeopleSoft - $10.3B @ 2005 #1
90. Oracle DB IBM DB2 MS SQL SAP/Sybase Teradata Others द੢ ੼ਬਯ Source: Gartner 2012, RDBMS Software Revenue, http://itknowledgeexchange.techtarget.com/eye-on-oracle/oracle-the-clear-leader-in-24-billion-rdbms-market/
91. 49% 20% 17% 5% 4% 6% Oracle DB IBM DB2 MS SQL SAP/Sybase Teradata Others द੢ ੼ਬਯ Source: Gartner 2012, RDBMS Software Revenue, http://itknowledgeexchange.techtarget.com/eye-on-oracle/oracle-the-clear-leader-in-24-billion-rdbms-market/
92. $12B $5B $4B $1B $1B $1B Oracle DB IBM DB2 MS SQL SAP/Sybase Teradata Others DB ݒ୹ Source: Gartner 2012, RDBMS Software Revenue, http://itknowledgeexchange.techtarget.com/eye-on-oracle/oracle-the-clear-leader-in-24-billion-rdbms-market/
94.  ஝ OS  339S0073ARM K2132C2PD-50-F ONO650908 APL0298 N1PVNMPP 0919 iPhone OS
95.  ஝ OS TIZEN ANDROID PA SAMI
96.  ஝ OS OS ஝ ҃੬ ҙ҅
97. DB ERP PeopleSoft Transaction In Memory -Oracle이 PeopleSoft를 2005년에 $10,300M (103억 달러 = 11조...) -SAP의 TIM인수는 2005년. 가격은 안밝 혀짐
98. DB ERP -Oracle이 PeopleSoft를 2005년에 $10,300M (103억 달러 = 11조...) -SAP의 TIM인수는 2005년. 가격은 안밝 혀짐 DB ERP ҃੬ ҙ҅
99. 
100. 마지막 원칙, 이 바닥엔 영원한 친구도 원수도 없어. ఋ૞, ©2006 CJ Entertainment
101. Ѿۿ
102. Ѿۿ • In Memory DBח ޖ૑ ࡅܰ׮.
103. Ѿۿ • In Memory DBח ޖ૑ ࡅܰ׮. • पदрਵ۽ ୊ܻೡ ࣻ ੓׮.
104. Ѿۿ • In Memory DBח ޖ૑ ࡅܰ׮. • पदрਵ۽ ୊ܻೡ ࣻ ੓׮. • ݫݽܻח ষ୒ ऱ઎׮.
105. Ѿۿ • In Memory DBח ޖ૑ ࡅܰ׮. • पदрਵ۽ ୊ܻೡ ࣻ ੓׮. • ݫݽܻח ষ୒ ऱ઎׮. • Oracleب ௼Ҋ SAPب ௼׮. ل੉ ҃੬ೠ׮.
106. Ѿۿ • In Memory DBח ޖ૑ ࡅܰ׮. • पदрਵ۽ ୊ܻೡ ࣻ ੓׮. • ݫݽܻח ষ୒ ऱ઎׮. • Oracleب ௼Ҋ SAPب ௼׮. ل੉ ҃੬ೠ׮. • ৈ۞࠙ب જ਷Ѫ ٜ݅য ੜ ౹ইࠁ੗.
107. Q&A