{"id":317,"date":"2015-08-27T17:22:19","date_gmt":"2015-08-27T08:22:19","guid":{"rendered":"http:\/\/saphanadb.com\/?p=317"},"modified":"2022-06-28T10:06:26","modified_gmt":"2022-06-28T01:06:26","slug":"sap-hana-%ec%82%ac%ec%9d%b4%ec%a7%95sizing","status":"publish","type":"post","link":"http:\/\/saphanadb.com\/?p=317","title":{"rendered":"SAP HANA \uc0ac\uc774\uc9d5(Sizing)"},"content":{"rendered":"<p>SAP HANA \uc0ac\uc774\uc9d5(Sizing)<\/p>\n<p>SAP HANA(High Performance Analytic Appliance)\uc758 \uc0ac\uc774\uc9d5\uc5d0 \ub300\ud574\uc11c \uc124\uba85\ud558\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p>HANA\uac00 In-Memory Database\ub85c \ud558\ub4dc\uc6e8\uc5b4(Hardware)\uc640 \uc18c\ud504\ud2b8\uc6e8\uc5b4(Software)\uc744 \uacb0\ud569\ud55c \uc5b4\ud50c\ub77c\uc774\uc120\uc2a4(Appliance)\ud615\ud0dc\ub85c \uad6c\uc131\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>HANA\uac00 \ub0b4\uc138\uc6b0\ub294 \uc7a5\uc810\uc740 \uc2e4\uc2dc\uac04\uc73c\ub85c \ubd84\uc11d\uc774 \uac00\ub2a5\ud558\uace0 \ube60\ub978 \ud2b8\ub79c\uc7ad\uc158(Transaction)\uc744 \ucc98\ub9ac\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. HANA\ub294 \ubaa8\ub4e0 \uc5c5\ubb34\ucc98\ub9ac\ub97c \uba54\ubaa8\ub9ac \uc0c1\uc5d0\uc11c \uc218\ud589\ud558\uace0 \ub514\uc2a4\ud06c\ub294 \ub2e8\uc21c\uc774 \uc804\uc6d0 \uacf5\uae09\uc774 \uc911\ub2e8\ub418\uc5c8\uc744\ub54c \ub370\uc774\ud130\ub97c \ubcf4\uc874\ud558\uae30 \uc704\ud574\uc11c \uc874\uc7ac\ud569\ub2c8\ub2e4.<\/p>\n<p>\ubaa8\ub4e0 \uc5c5\ubb34 \ucc98\ub9ac(Transaction)\ub97c \uba54\ubaa8\ub9ac \uc0c1\uc5d0\uc11c \uc218\ud589\ud558\uace0, \uc5c5\ubb34 \uc5f0\uc0b0(Calculation)\uc744 \uc218\ud589\ud558\ub294 CPU \ub2f4\ub2f9\ud558\uae30 \ub54c\ubb38\uc5d0 HANA\ub97c \uad6c\ucd95\ud560 \ub54c \uc6b0\ub9ac \ud68c\uc0ac\uc5d0 \ub9de\uac8c \uba87 \uac1c\uc758 CPU\ub97c \uaf42\uc544\uc57c \ud558\uace0, \uba54\ubaa8\ub9ac\ub97c \uba87 GB\ub97c \ub123\uc5b4\uc57c \uc6b0\ub9ac \ud68c\uc0ac \uc9c1\uc6d0\uc774 \ub290\ub9ac\ub2e4\uace0 \ud558\uc9c0 \uc54a\uace0 \uc6d0\ud558\ub294 \uacb0\uacfc(\ub9ac\ud3ec\ud2b8)\ub97c \ucc98\ub9ac \ud560 \uc218 \uc788\uc744\uc9c0 \uacb0\uc815\ud558\ub294 \uac83 \uc774\uae30 \ub54c\ubb38\uc5d0 HANA \uc0ac\uc774\uc9d5\uc774 HANA \ub97c \uad6c\ucd95\ud558\ub294\ub370 \uc911\uc6a9\ud55c \uc694\uc18c\ub85c \uc791\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc774\uc81c HAHA \ub97c \uad6c\ucd95\ud558\ub294\ub370 \ud558\ub4dc\uc6e8\uc5b4(H\/W)\uc815\ud655\ud558\uac8c \uc0ac\uc774\uc9d5\ud558\ub294 3\uac00\uc9c0 \ubc29\ubc95\uc5d0 \ub300\ud574\uc11c \uc124\uba85\ud558\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4<\/p>\n<ul>\n<li>QuickSizer\ub97c \uc774\uc6a9\ud55c HANA \uc0ac\uc774\uc9d5(<a href=\"http:\/\/service.sap.com\/quicksizer\">http:\/\/service.sap.com\/quicksizer<\/a>)<\/li>\n<li>DB \ubcc4 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc774\uc6a9\ud55c HANA \uc0ac\uc774\uc9d5<\/li>\n<li>ABAP \ub9ac\ud3ec\ud2b8\ub97c \uc774\uc6a9\ud55c HANA \uc0ac\uc774\uc9d5<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<ol>\n<li>QuickSizer\ub97c \uc774\uc6a9\ud55c HANA \uc0ac\uc774\uc9d5(<a href=\"http:\/\/service.sap.com\/quicksizer\">http:\/\/service.sap.com\/quicksizer<\/a>)<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p>\uc774 \uc0ac\uc774\uc9d5\uc740 \uc804\ud1b5\uc801\uc778 SAP \uc81c\ud488\uc758 \uc0ac\uc774\uc9d5 \ubc29\ubc95\uc73c\ub85c SAP\uc0ac\uc774\ud2b8\uc5d0 \uc694\uad6c\ud558\ub294 DATA \uac12\uc744 \uc785\ub825\ud558\uba74 \uc0ac\uc774\uc9d5\ud55c \uacb0\uacfc(CPU, Memory, Disk)\uc774 \ub098\uc624\uac8c \ub41c\ub2e4. \uc774 \ubc29\ubc95\uc740 \uc774 \uc0ac\uc774\uc9d5\uc744 \ud558\ub294 \uc0ac\uc774\ud2b8\uc5d0 \uc5bc\ub9c8\ub098 \uc815\ud655\ud55c \uac12\uc744 \uc785\ub825\ud558\ub294\ub0d0 \uc815\ud655\ud55c \uc0ac\uc774\uc9d5\uc744 \ud560 \uc218 \uc788\ub294\ub370 \ud504\ub85c\uc81d\ud2b8\ub97c \ud558\ub2e4\ubcf4\uba74 \uc608\uc0c1 \uc0ac\uc6a9\uc790\uc218, \uc608\uc0c1 \uc8fc\ubb38\uac74\uc218, \ub3d9\uc2dc \uc811\uc18d\uc790 \uc218, \ub370\uc774\ud130 \ub7c9\ub4f1 \uc774\ub7ec\ud55c \uac12\ub4e4\uc744 \uc608\uc0c1\uc5d0\uc11c \uc785\ub825\ud574\uc57c \ud558\ub294\ub370 \uc774 \uc22b\uc790 \uc790\uccb4\ub3c4 \ud604\uc5c5\ud558\uace0 IT\ub2f4\ub2f9\uc790\ub4e4\uc774 \uc608\uc0c1\ud558\ub294 \uc22b\uc790\uc5ec\uc11c \uc815\ud655\ud55c H\/W \uc0ac\uc774\uc9d5\uc744 \ud604\uc2e4\uc801\uc73c\ub85c \ubd88\uac00\ub2a5\ud569\ub2c8\ub2e4.<\/p>\n<p>\uadf8\ub7ec\ub098 \uac04\ub2e8\ud558\uac8c \uc774 \ud035 \uc0ac\uc774\uc9d5\uc73c\ub85c \uc0ac\uc774\uc9d5\ud558\ub294 \ubc29\ubc95\uc5d0 \ub300\ud574\uc11c \uc124\uba85\ud558\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774 \uc0ac\uc774\ud2b8(<a href=\"http:\/\/service.sap.com\/quicksizer\">http:\/\/service.sap.com\/quicksizer<\/a>)\uc5d0 \uc811\uc18d\ud558\uac8c \ub418\uba74 \uace0\uac1d\uc5d0\uac8c \ubc1c\uae09\ub41c SAP \ub9c8\ucf13\ud50c\ub808\uc774\uc2a4\uc758 ID\/Password \ub97c \uc785\ub825\ud558\uac8c \ub418\uba74 \uc0ac\uc774\uc9d5\ud560\uc218 \uc788\ub294 \ud654\uba74\uc774 \ub098\uc624\uac8c \ub429\ub2c8\ub2e4.<\/p>\n<p>\uc544\ub798 \ud654\uba74\uc5d0\uc11c HANA Version\uc744 \uc120\ud0dd\ud558\uac8c \ub429\ub2c8\ub2e4. Classic Version\uc740 \uc774\uc804 \ubc29\uc2dd\uc73c\ub85c \uc0ac\uc774\uc9d5\ud588\ub358 \ubc29\ubc95\uc73c\ub85c Oracle, MS SQL, DB2\ub4f1 \uc804\ud1b5\uc801\uc778 \ubc29\uc2dd\uc758 \uc0ac\uc774\uc9d5\uc740 Classic Version\uc73c\ub85c \ud558\uc2dc\uba74 \ub429\ub2c8\ub2e4. \uc5ec\uae30\uc11c \uc6b0\ub9ac\ub294 HANA Version\uc73c\ub85c \uc120\ud0dd\ud558\uace0 \uc0ac\uc774\uc9d5\uc744 \ud558\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n<p><a href=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-00001.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-318\" src=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-00001.jpg\" alt=\"Image-0000\" width=\"968\" height=\"427\" srcset=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-00001.jpg 968w, http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-00001-300x132.jpg 300w\" sizes=\"auto, (max-width: 968px) 100vw, 968px\" \/><\/a><\/p>\n<p>Project Name\uc5d0 \ud504\ub85c\uc81d\ud2b8 \uc774\ub984\uc744 \uc785\ub825\ud558\uace0 Create Project \ub97c \uc120\ud0dd\ud558\uace0 \uc2e0\uaddc \ud504\ub85c\uc81d\ud2b8\ub97c \uc0dd\uc131\ud558\uba74 \uc0ac\uc774\uc9d5\ud558\ub294\ub370 \ud544\uc694\ud55c \ub370\uc774\ud130\ub97c \uc785\ub825\ud560 \uc218 \uc788\ub294 \uc790\uc138\ud55c \ub0b4\uc6a9\uc774 \ub098\uc624\uac8c \ub429\ub2c8\ub2e4.<\/p>\n<p><a href=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0004.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-322\" src=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0004.jpg\" alt=\"Image-0004\" width=\"289\" height=\"271\" \/><\/a><\/p>\n<p>BW powered by SAP HANA \uc5d0 \ub300\ud574\uc11c \uba3c\uc800 \uc124\uba85\ud558\uaca0\uc2b5\ub2c8\ub2e4. HANA \uac00 \ucc98\uc74c\uc5d0 \uc194\ub8e8\uc158\uc744 \ucd9c\uc2dc\ud558\uac8c \ub418\uba74\uc11c BW\uc6a9\uc73c\ub85c \ucc98\uc74c \ub098\uc624\uac8c \ub418\uc5b4\uc11c \ud604\uc7ac\uae4c\uc9c0 BW\uc6a9\uc73c\ub85c \ub9ce\uc774 \uc0ac\uc6a9\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uc774\uac83\uc740 \uc544\ubb34\ub798\ub3c4 BW\uc758 \ub9ac\ud3ec\ud2b8 \uc870\ud68c\ud560 \ub54c \uc18d\ub3c4\uac00 \uc911\uc694\ud55c \uc694\uc778\uc774\uae30 \ub54c\ubb38\uc5d0 HANA \uc194\ub8e8\uc158 \uc774\uc804\uc5d0 BIA(Business Intelligence Accelerator)\ub85c \ub9ce\uc774 \uc0ac\uc6a9\ud558\uc600\ub358 \uace0\uac1d\uc740 BW on HANA\ub97c \uc0ac\uc6a9\ud558\ub294\ub370 \ud070 \uac70\ubd80\uac10 \uc5c6\uc774 \uc0ac\uc6a9\ud558\uac8c \ub418\uc5b4\uc11c \uad6d\ub0b4 \ud658\uacbd\uc5d0\ub294 BW on HANA\uac00 \ucd08\uae30\uc5d0 \ub9ce\uc774 \uc124\uce58\ub418\uace0 \uc0ac\uc6a9\ud558\uace0 \uc788\ub294 \uc0c1\ud669\uc785\ub2c8\ub2e4.<\/p>\n<p><a href=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-00021.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-320\" src=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-00021.jpg\" alt=\"Image-0002\" width=\"291\" height=\"383\" srcset=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-00021.jpg 291w, http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-00021-228x300.jpg 228w\" sizes=\"auto, (max-width: 291px) 100vw, 291px\" \/><\/a><\/p>\n<p>\uc544\ub798\uc640 \uac19\uc774 \ube68\uac04\uc0c9 \ud14c\ub450\ub9ac \uc548\uc5d0 \ud544\uc694\ub85c \ud558\ub294 \uc785\ub825 \uac12\uc744 \ub123\ub294\ub2e4. \uc608\ub97c \ub4e4\uba74 \ub3d9\uc2dc\uc0ac\uc6a9\uc790(Concurrent users)\uc5d0 \uc0ac\uc6a9\uc790 \uc218\ub97c \uc785\ub825\ud558\uace0, \uc0ac\uc6a9\uc790\ub2f9 \uacc4\ud68d\ub41c \ud654\uba74(Plan steps\/user)\ub4f1 \uc0ac\uc774\uc9d5\uc5d0 \ud544\uc694\ub85c \ud558\ub294 \uac12\ub4e4\uc744 \uc785\ub825\ud55c\ub2e4.<\/p>\n<p><a href=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0006.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-324\" src=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0006.jpg\" alt=\"Image-0006\" width=\"856\" height=\"642\" srcset=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0006.jpg 856w, http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0006-300x225.jpg 300w\" sizes=\"auto, (max-width: 856px) 100vw, 856px\" \/><\/a><\/p>\n<p>\uc544\ub798\uc640 \uac19\uc774 \uc0ac\uc774\uc9d5\ud55c \uacb0\uacfc\ub97c \ubcf4\uae30 \uc704\ud574 \u201cCalculate result\u201d\ubc84\ud134\uc744 \ub204\ub8e8\uac8c \ub418\uba74 \uacb0\uacfc\ub098 \ub098\uc624\uac8c \ub41c\ub2e4. \uc774\uac83\uc73c\ub85c CPU \ub294 XS(T-Shirt\uc758 \uc637 \uc0ac\uc774\uc988)\ub85c SAPS \uc218\uce58 12,000 \uc774 \ub098\uc624\uace0 \uba54\ubaa8\ub9ac\ub294 AP\uc11c\ubc84 199,680MB(199GB), DB\uc11c\ubc84 196,608MB(196GB)\ub85c \ub098\uc624\uac8c \ub41c\ub2e4.<\/p>\n<p><a href=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0005.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-323\" src=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0005.jpg\" alt=\"Image-0005\" width=\"842\" height=\"294\" srcset=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0005.jpg 842w, http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0005-300x105.jpg 300w\" sizes=\"auto, (max-width: 842px) 100vw, 842px\" \/><\/a><\/p>\n<p>\uc774\ub7ec\ud55c SAPS \uc218\uce58\uc640 \uba54\ubaa8\ub9ac \ub7c9\uc774 \ub098\uc628 \uacb0\uacfc\ub97c \ud558\ub4dc\uc6e8\uc5b4 \ubca4\ub354(IBM, HP, DELL)\uc5d0 \ubcf4\ub0b4\uac8c \ub418\uba74 \uc774 \uc218\uce58\uc5d0 \ub9de\ub294 H\/W \uacac\uc801\uc11c\ub97c \ubc1b\uc744 \uc218 \uc788\ub2e4. \uc608\ub97c \ub4e4\uba74 IBM\uc758 H\/W \ubca4\ud130 \ud30c\ud2b8\ub108\uc0ac\uc758 \uc601\uc5c5 \ub2f4\ub2f9\uc790\ubd84\uc5d0\uac8c \uc774 \uacb0\uacfc\ub97c \ubcf4\ub0b4\uc8fc\uba74 SAPS \uc218\uce58\uc5d0 \ub9de\ub294 IBM \uc11c\ubc84 \ubaa8\ub378\uc744 \ubc1b\uc744 \uc218 \uc788\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<ol start=\"2\">\n<li>DB \ubcc4 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc774\uc6a9\ud55c HANA \uc0ac\uc774\uc9d5<\/li>\n<\/ol>\n<p>\uc774 DB \ubcc4 HAHA \uc0ac\uc774\uc9d5\uc740 BW on HAHA\uc5d0\ub9cc \ud574\ub2f9\ub418\ub294 \ubc29\ubc95\uc774\ub2e4.<\/p>\n<p>\uc774 \ubc29\ubc95\uc740 2014\ub144\ub3c4\uc5d0 \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc774\uc9c0\ub9cc \uc815\ud655\ud55c \uce21\uc815\uc774 \uc548\ub418\uc5b4 \uc0ac\uc6a9\ud558\ub294\ub370 \ucc38\uace0 \uc0ac\ud56d\uc73c\ub85c \uc0ac\uc6a9\ud558\uba74 \uc88b\uc744 \uac83 \uac14\uc2b5\ub2c8\ub2e4.<\/p>\n<p>\uc774 \ubc29\ubc95\uc740 DB \ub808\ubca8\uc774\uc11c \uae30\uc874 BW\uac00 \uc124\uce58\ub41c Oracle \ud658\uacbd\uc5d0\uc11c HANA\ub85c \uc804\ud658\ud588\uc744\ub54c DATA \uc0ac\uc774\uc988\ub97c \uce21\uc815\ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/p>\n<p>\uc608\ub97c \ub4e4\uba74 \ud604\uc7ac BW\uc11c\ubc84\uac00 BW 7.0(Windows 2008, Oracle 10g)\uac00 \uc124\uce58\ub41c \uac83\uc744 BW 7.4(Windows 2012, HANA DB)B\ub85c \uc804\ud658 \ud558\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. \uc774 DB \ub808\ubca8\uc5d0\uc11c \uce21\uc815\ud558\ub294 \uc608\ub294 SAP\uac00 \uc124\uce58\ub418\uc9c0 \uc54a\ub294 \uc21c\uc218\ud55c Oracle DB\ub97c HANA DB\ub85c \uc804\ud658\ud588\uc744 \ub54c \uc0ac\uc6a9\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p>&nbsp;<\/p>\n<p>\uc774 \ubc29\ubc95\uc5d0 SAP Note 1637145 \uc5d0 \ucca8\ubd80\ub41c get_size.zip \ud30c\uc77c\uc744 \ub2e4\uc6b4\ub85c\ub4dc \ud558\uc5ec DB\uac00 Oralce\uc774\uba74 get_ora_win_size.sql \uc744 \uc2e4\ud589\ud558\uc5ec \uacb0\uacfc\ub97c \uac00\uc9c0\uace0 \uc0ac\uc774\uc9d5\uc744 \uc218\ud589\ud569\ub2c8\ub2e4.<\/p>\n<p>\uc800\ub294 \uc5ec\uae30\uc5d0\uc11c Windows 2008 \uc11c\ubc84\uc5d0 Oracle 10g\uc5d0 \ub300\ud574\uc11c \uce21\uc815 \uacb0\uacfc\ub97c \uac00\uc9c0\uace0 \uc124\uba85\ud558\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. Oracle\uc744 \ucd5c\uc2e0 \ubc84\uc804\uc73c\ub85c \uc5c5\uadf8\ub808\uc774\ub4dc \uc5c6\uc774 BW on HANA\ub85c \ub9c8\uc774\uadf8\ub808\uc774\uc158\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n<ul>\n<li>Note\uc5d0 \ucca8\ubd80\ub41czip \ub97c \ub2e4\uc6b4\ub85c\ub4dc \ud55c\ub2e4.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0007.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-325\" src=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0007.jpg\" alt=\"Image-0007\" width=\"672\" height=\"557\" srcset=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0007.jpg 672w, http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0007-300x249.jpg 300w\" sizes=\"auto, (max-width: 672px) 100vw, 672px\" \/><\/a><\/p>\n<p>\ucca8\ubd80\ud30c\uc77c\uc5d0\uc11c get_ora_win_size.sql \uc744 \uc2e4\ud589\ud558\uc5ec \uae30\uc874\uc5d0 Windows 2008\uc5d0 Oracle 10g\uc5d0 \uc0ac\uc6a9\ud558\uace0 \uc788\ub294 BW\ub97c HANA\ub85c \ub9c8\uc774\uadf8\ub808\uc774\uc158 \ud588\uc744 \ub54c \ud544\uc694\ud55c \uc0ac\uc774\uc988\ub97c \uacc4\uc0b0\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n<p><a href=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0011.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-329\" src=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0011.jpg\" alt=\"Image-0011\" width=\"663\" height=\"284\" srcset=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0011.jpg 663w, http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0011-300x129.jpg 300w\" sizes=\"auto, (max-width: 663px) 100vw, 663px\" \/><\/a><\/p>\n<ul>\n<li>\ucca8\ubd80\ub41c \ud30c\uc77c\uc911\uc5d0 sql \uacfc load_RowStore_List.sql \uc744 \uac19\uc740 \ub514\ub809\ud1a0\ub9ac\uc5d0 \uc704\uce58\ud569\ub2c8\ub2e4.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0012.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-330\" src=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0012.jpg\" alt=\"Image-0012\" width=\"804\" height=\"602\" srcset=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0012.jpg 804w, http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0012-300x225.jpg 300w\" sizes=\"auto, (max-width: 804px) 100vw, 804px\" \/><\/a><\/p>\n<ul>\n<li>sql \uc2a4\ud06c\ub9bd\ud2b8 \ubd80\ubd84\uc5d0\uc11c &#8216;%dbs_ora_schema%&#8217; \uc744 \uc2a4\ud0a4\ub9c8 \uc624\ub108\uc778 SAPSR3 \ub85c \ubcc0\uacbd\ud558\uace0 \uc800\uc7a5\ud55c\ub2e4.<\/li>\n<li>\uc2a4\ud06c\ub9bd\ud2b8\ub97c SQLPLUS \uba85\ub839\uc5b4\ub85c \uc2e4\ud589\ud55c\uba74 \uacb0\uacfc\uac00 \ub098\uc628\ub2e4.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0013.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-331\" src=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0013.jpg\" alt=\"Image-0013\" width=\"737\" height=\"491\" srcset=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0013.jpg 737w, http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0013-300x200.jpg 300w\" sizes=\"auto, (max-width: 737px) 100vw, 737px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0014.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-332\" src=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0014.jpg\" alt=\"Image-0014\" width=\"930\" height=\"572\" srcset=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0014.jpg 930w, http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0014-300x185.jpg 300w\" sizes=\"auto, (max-width: 930px) 100vw, 930px\" \/><\/a><\/p>\n<p>\uacb0\uacfc\uc5d0\uc11c \ubcf4\uba74\u00a0 Row\ub85c \uc800\uc7a5\ub418\ub294 \ud14c\uc774\ube14 \uc0ac\uc774\uc988\uac00 35GB, Column\uc73c\ub85c \uc800\uc7a5\ub418\ub294 \uc0ac\uc774\uc988\ub294 66GB\uc774\ub2e4.\uc5ec\uae30\uc5d0\uc11c \uc911\uc694\ud558\uac8c \uc0dd\uac01\ub418\ub294 \ubd80\ubd84\uc774 \uc18c\uc2a4 DB\uc5d0\uc11c(\uae30\uc874 BW)\uc5d0\uc11c Row Table\uacfc Column Table\uc758 \uc0ac\uc774\uc988\uc774\ub2e4.<\/p>\n<p>RowStore Tables [GB]\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0ColumnStore Tables [GB] \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0Total Size [GB]<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0&#8212;&#8212;&#8212;&#8212;&#8212;<\/p>\n<p>35.15\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a066.68\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0101.83<\/p>\n<p>&nbsp;<\/p>\n<ul>\n<li>\uc774 \uacb0\uacfc\ub97c \uac00\uc9c0\uace0 \uacc4\uc0b0\uc2dd\uc744 \uc218\ud589\ud574\uc57c \ud55c\ub2e4. \uacc4\uc0b0\ud558\ub294 \uacf5\uc2dd\uc740 \uc544\ub798\ub85c \uc124\uba85\ud574 \uc900\ub2e4.<\/li>\n<\/ul>\n<p><a href=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0016.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-334\" src=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0016.jpg\" alt=\"Image-0016\" width=\"920\" height=\"597\" srcset=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0016.jpg 920w, http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0016-300x195.jpg 300w\" sizes=\"auto, (max-width: 920px) 100vw, 920px\" \/><\/a><\/p>\n<p><a href=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0015.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-333\" src=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0015.jpg\" alt=\"Image-0015\" width=\"864\" height=\"542\" srcset=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0015.jpg 864w, http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0015-300x188.jpg 300w\" sizes=\"auto, (max-width: 864px) 100vw, 864px\" \/><\/a><\/p>\n<p>\uc0ac\uc774\uc9d5 \uacf5\uc2dd\uc774 \uc880 \ubcf5\uc7a1\ud558\ub2e4. \uadf8\ub7ec\ub098 \uc6b0\ub9ac\ub294 \uc5ec\uae30\uc11c \ud3ec\uae30\ud558\uba74 \uc548\ub41c\ub2e4. \uc815\ud655\ud788 \uc9d1\uace0 \ub118\uc5b4 \uac00\uc57c \uc81c\ub300\ub85c\ub41c \uc0ac\uc774\uc9d5\uc744 \ud588\ub2e4\uace0 \ub9d0\ud560 \uc218 \uc788\uc9c0 \uc54a\uc744\uae4c?<\/p>\n<p><a href=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0017.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-335\" src=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0017.jpg\" alt=\"Image-0017\" width=\"612\" height=\"471\" srcset=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0017.jpg 612w, http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0017-300x231.jpg 300w\" sizes=\"auto, (max-width: 612px) 100vw, 612px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0018.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-336\" src=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0018.jpg\" alt=\"Image-0018\" width=\"600\" height=\"502\" srcset=\"http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0018.jpg 600w, http:\/\/saphanadb.com\/wp-content\/uploads\/2015\/08\/Image-0018-300x251.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/a><\/p>\n<ol start=\"3\">\n<li>ABAP \ub9ac\ud3ec\ud2b8\ub97c \uc774\uc6a9\ud55c HANA \uc0ac\uc774\uc9d5<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SAP HANA \uc0ac\uc774\uc9d5(Sizing) SAP HANA(High Performance Analytic Appliance)\uc758 \uc0ac\uc774\uc9d5\uc5d0 \ub300\ud574\uc11c \uc124\uba85\ud558\ub3c4\ub85d \ud558\uaca0\uc2b5\ub2c8\ub2e4. HANA\uac00 In-Memory Database\ub85c \ud558\ub4dc\uc6e8\uc5b4(Hardware)\uc640 \uc18c\ud504\ud2b8\uc6e8\uc5b4(Software)\uc744 \uacb0\ud569\ud55c \uc5b4\ud50c\ub77c\uc774\uc120\uc2a4(Appliance)\ud615\ud0dc\ub85c \uad6c\uc131\ub418\uc5b4 \uc788\uc2b5\ub2c8\ub2e4. HANA\uac00 \ub0b4\uc138\uc6b0\ub294 \uc7a5\uc810\uc740 \uc2e4\uc2dc\uac04\uc73c\ub85c \ubd84\uc11d\uc774 \uac00\ub2a5\ud558\uace0 \ube60\ub978 \ud2b8\ub79c\uc7ad\uc158(Transaction)\uc744 \ucc98\ub9ac\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. HANA\ub294 \ubaa8\ub4e0 \uc5c5\ubb34\ucc98\ub9ac\ub97c \uba54\ubaa8\ub9ac \uc0c1\uc5d0\uc11c \uc218\ud589\ud558\uace0 \ub514\uc2a4\ud06c\ub294 \ub2e8\uc21c\uc774 \uc804\uc6d0 \uacf5\uae09\uc774 \uc911\ub2e8\ub418\uc5c8\uc744\ub54c \ub370\uc774\ud130\ub97c \ubcf4\uc874\ud558\uae30 \uc704\ud574\uc11c \uc874\uc7ac\ud569\ub2c8\ub2e4. \ubaa8\ub4e0 \uc5c5\ubb34 \ucc98\ub9ac(Transaction)\ub97c \uba54\ubaa8\ub9ac \uc0c1\uc5d0\uc11c \uc218\ud589\ud558\uace0, \uc5c5\ubb34 \uc5f0\uc0b0(Calculation)\uc744 \uc218\ud589\ud558\ub294 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-317","post","type-post","status-publish","format-standard","hentry","category-hana-db"],"_links":{"self":[{"href":"http:\/\/saphanadb.com\/index.php?rest_route=\/wp\/v2\/posts\/317","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/saphanadb.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/saphanadb.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/saphanadb.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/saphanadb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=317"}],"version-history":[{"count":5,"href":"http:\/\/saphanadb.com\/index.php?rest_route=\/wp\/v2\/posts\/317\/revisions"}],"predecessor-version":[{"id":2730,"href":"http:\/\/saphanadb.com\/index.php?rest_route=\/wp\/v2\/posts\/317\/revisions\/2730"}],"wp:attachment":[{"href":"http:\/\/saphanadb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=317"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/saphanadb.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=317"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/saphanadb.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=317"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}