[B! OracleDatabase] elfã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

elf id:elf

OracleDatabaseã«é–¢ã™ã‚‹elfã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (13)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(4) - SH2ã®æ—¥è¨˜
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚ã®ç¬¬4å›žã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(1) TPC-Bã€TPC-Wãƒ™ãƒ¼ã‚¹ã®ãƒ„ãƒ¼ãƒ«ã‚’6ã¤ç´¹ä»‹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(2) TPC-Cãƒ™ãƒ¼ã‚¹ã®ãƒ„ãƒ¼ãƒ«ã‚’6ã¤ç´¹ä»‹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(3) TPC-Hãƒ™ãƒ¼ã‚¹ã®ãƒ„ãƒ¼ãƒ«ã‚’2ã¤ç´¹ä»‹ ä»Šå›žã¯TPC-Eãƒ™ãƒ¼ã‚¹ã®ãƒ„ãƒ¼ãƒ«ã‚’è¦‹ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ TPC-Eã¨ã¯ TPC-Eã¯RDBMSãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ä»•æ§˜ã®ä¸€ã¤ã§ã€ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³(OLTP)ã®æ€§èƒ½ã‚’æ¸¬å®šã™ã‚‹ã‚‚ã®ã§ã™ã€‚è¨¼åˆ¸ä¼šç¤¾ã®æ¥å‹™ã‚’ãƒ¢ãƒ‡ãƒ«ã¨ã—ã¦å–å¼•ã‚„å¸‚å ´ã®ç›£è¦–ã€ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹å‡¦ç†ã‚’è¡Œã„ã€1ç§’ã‚ãŸã‚Šã«è¡Œã£ãŸå–å¼•ä»¶æ•°ã‚’æ€§èƒ½ã®æŒ‡æ¨™å€¤ã¨ã—ã¾ã™ã€‚ OLTPã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ã¨ã—ã¦ã¯ã“ã‚Œã¾ã§TPC-CãŒã‚ˆãç”¨ã„ã‚‰ã‚Œã¦ãã¾ã—ãŸã€‚ã—ã‹ã—TPC-Cã¯1992å¹´ã®ç–å®šã‹ã‚‰å®Ÿã«18å¹´ãŒçµŒéŽã—ã¦ãŠã‚Šã€ãã®é–“ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ã®CPUæ€§èƒ½ã¯ãƒ ãƒ¼ã‚¢ã®æ³•å‰‡ã«ã—ãŸãŒã£ã¦ä¼¸
elf 2010/05/13
Database

Benchmark

PostgreSQL

MySQL

OracleDatabase

sh2
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(3) - SH2ã®æ—¥è¨˜
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚ã®ç¬¬3å›žã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(1) TPC-Bã€TPC-Wãƒ™ãƒ¼ã‚¹ã®ãƒ„ãƒ¼ãƒ«ã‚’6ã¤ç´¹ä»‹ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(2) TPC-Cãƒ™ãƒ¼ã‚¹ã®ãƒ„ãƒ¼ãƒ«ã‚’6ã¤ç´¹ä»‹ ã‹ãªã‚ŠæœŸé–“ãŒç©ºã„ã¦ã—ã¾ã„ã¾ã—ãŸãŒã€ä»Šå›žã¯TPC-Hãƒ™ãƒ¼ã‚¹ã®ãƒ„ãƒ¼ãƒ«ã‚’è¦‹ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ TPC-Hã¨ã¯ TPC-Hã¯RDBMSãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ä»•æ§˜ã®ä¸€ã¤ã§ã€æ„æ€æ±ºå®šæ”¯æ´ã‚·ã‚¹ãƒ†ãƒ (DSS)ã¨ã—ã¦ã®æ€§èƒ½ã‚’æ¸¬å®šã™ã‚‹ã‚‚ã®ã§ã™ã€‚å¤§è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿ã‚’å¯¾è±¡ã«ã‚¢ãƒ‰ãƒ›ãƒƒã‚¯ãªã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã¾ã™ã€‚ã‚¯ã‚¨ãƒªã¯å…¨éƒ¨ã§22ç¨®é¡žå®šç¾©ã•ã‚Œã¦ã„ã¾ã™ã€‚ TPC-Hã¯TPC-B/W/Cãªã©ã¨ç•°ãªã‚Šã€å®Ÿè¡Œã™ã‚‹ã‚¯ã‚¨ãƒªãã®ã‚‚ã®ã‚„ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ç”Ÿæˆãƒ„ãƒ¼ãƒ«ãŒTPCã‹ã‚‰æä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚è©¦ã—ã«ã€ä¸€ç•ªè² è·ãŒé«˜ã„9ç•ªã®ã‚¯ã‚¨ãƒªã‚’ç¢ºèªã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ -- $ID$ -- TPC-H/TPC-R Product Type Profit Me
elf 2010/05/13
Database

Benchmark

PostgreSQL

MySQL

OracleDatabase

sh2
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚(2) - SH2ã®æ—¥è¨˜
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è² è·ãƒ†ã‚¹ãƒˆãƒ„ãƒ¼ãƒ«ã¾ã¨ã‚ã®ç¬¬2å›žã§ã™ã€‚ å‰å›žã¯TPC-Bãƒ™ãƒ¼ã‚¹ã€TPC-Wãƒ™ãƒ¼ã‚¹ã®ã‚‚ã®ã‹ã‚‰6ã¤ã®ãƒ„ãƒ¼ãƒ«ã‚’ã”ç´¹ä»‹ã—ã¾ã—ãŸã€‚ä»Šå›žã¯TPC-Cãƒ™ãƒ¼ã‚¹ã®ã‚‚ã®ã«ã¤ã„ã¦è¦‹ã¦ã„ããŸã„ã¨æ€ã„ã¾ã™ã€‚ tpcc-mysql å¯¾å¿œRDBMSï¼šMySQL å¯¾å¿œOSï¼šLinuxãªã© è¨€èªžï¼šC ä½œè€…ï¼šPercona Inc. ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ï¼šä¸æ˜Ž(ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã«é–¢ã™ã‚‹è¨˜è¿°ãŒãªã„) ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ä»•æ§˜ï¼šTPC-Cãƒ™ãƒ¼ã‚¹ URLï¼šhttps://code.launchpad.net/~percona-dev/perconatools/tpcc-mysql tpcc-mysqlã¯MySQLã®ã‚³ãƒ³ã‚µãƒ«ä¼šç¤¾ã§ã‚ã‚‹Percona Inc.ã«ã‚ˆã£ã¦é–‹ç™ºã•ã‚ŒãŸãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ãƒ„ãƒ¼ãƒ«ã§ã€TPC-Cã‚’ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã„ã¾ã™ã€‚TPC-Cã®ä»•æ§˜ã‚„tpcc-mysqlã«ã¤ã„ã¦ã¯ä»¥å‰ã®ã‚¨ãƒ³ãƒˆãƒªã§è©³ã—ãæ‰±ã£ã¦ã„ã‚‹ã®ã§ã€ãã¡ã‚‰ã‚’ã”è¦§ãã ã•ã„ã€‚ tpc
elf 2010/05/13
Database

Benchmark

PostgreSQL

MySQL

OracleDatabase

sh2
ãƒªãƒ³ã‚¯
æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã¨å¯Œå£«é€š ãƒ•ãƒ©ãƒƒã‚·ãƒ¥æŠ€è¡“æ´»ç”¨ã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é«˜é€ŸåŒ–ã‚’å…±åŒæ¤œè¨¼ - å¯Œå£«é€š
2010å¹´4æœˆ22æ—¥ æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«æ ªå¼ä¼šç¤¾ï¼ˆä»¥ä¸‹ã€æ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ï¼‰ã¨å¯Œå£«é€šæ ªå¼ä¼šç¤¾ï¼ˆä»¥ä¸‹ã€å¯Œå£«é€šï¼‰ã¯ã€ã€ŒSPARC Enterpriseâ„¢ M3000ã€ã¨Solid State Driveï¼ˆä»¥ä¸‹ã€SSDï¼‰ã‚’æè¼‰ã—ãŸã€ŒETERNUS DX80ã€ã§æ§‹æˆã•ã‚Œã‚‹ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ãƒ»ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å‡¦ç†ï¼ˆä»¥ä¸‹ã€OLTPï¼‰ã‚·ã‚¹ãƒ†ãƒ ã«ãŠã„ã¦ã€ã€ŒOracle Database 11g Release 2 Enterprise Editionã€ã®é«˜é€ŸåŒ–æŠ€è¡“ã€ŒDatabase Smart Flash Cacheã€ã®æ€§èƒ½æ¤œè¨¼ã‚’å®Ÿæ–½ã—ã¾ã—ãŸã€‚ ã€ŒDatabase Smart Flash Cacheã€ã¯SSDã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ã¨ã—ã¦æ´»ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚SSDã¨ã€ŒDatabase Smart Flash Cacheã€ã®é©ç”¨ã«ã‚ˆã‚Šã€é€šå¸¸ã®ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ãƒ‰ãƒ©ã‚¤ãƒ–ï¼ˆä»¥ä¸‹ã€HDDï¼‰ã‚’ä½¿ç”¨ã—ãŸã‚·ã‚¹ãƒ†ãƒ ã¨æ¯”è¼ƒã—ã€æœ€å¤§2.4å€ã®
elf 2010/04/27
Oracle

Fujitsu

Database

Storage

SAN

OracleDatabase

ETERNUS

Knowledge
ãƒªãƒ³ã‚¯
HDDã‚’SSDã«ã—ãŸã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã©ã‚Œã ã‘é€Ÿããªã‚‹ã‹ï¼Ÿ ã‚ªãƒ©ã‚¯ãƒ«ã¨å¯Œå£«é€šãŒå®Ÿé¨“
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’åˆ©ç”¨ã™ã‚‹éš›ã«ã¯ã€é«˜ã„æ€§èƒ½ã‚’å¼•ãå‡ºã™ãŸã‚ã«ç‰©ç†è¨è¨ˆã‚’ã—ã€ã‚¹ã‚ãƒ¼ãƒžã‚’å·¥å¤«ã—ã€ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã‚’è¡Œã†ã“ã¨ãŒã¤ãã«è¡Œã‚ã‚Œã¦ãã¾ã—ãŸã€‚ æ€§èƒ½ã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¯ãŸã„ãŒã„HDDã«ã‚ã‚Šã€ã„ã‹ã«ãã®ãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã‚’å›žé¿ã™ã‚‹ã‹ãŒãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ãƒã‚¤ãƒ³ãƒˆã§ã™ãŒã€æœ€è¿‘ã§ã¯æ€§èƒ½å‘ä¸Šã®ãŸã‚ã®æ¦å™¨ã¨ã—ã¦ã€HDDã‚ˆã‚Šã‚‚ãšã£ã¨ã‚¢ã‚¯ã‚»ã‚¹æ€§èƒ½ã®é«˜ã„SSDãŒæ³¨ç›®ã•ã‚Œã¦ã„ã¾ã™ã€‚SSDã¯HDDã¨ç½®ãæ›ãˆã‚‹ã ã‘ã§ã€ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«ã¾ã£ãŸãæ‰‹ã‚’åŠ ãˆãšã«æ€§èƒ½å‘ä¸Šã‚’å¯èƒ½ã«ã™ã‚‹æ‰‹æ®µã¨ã—ã¦éžå¸¸ã«é…åŠ›çš„ã§ã™ã€‚ HDDã®ä»£ã‚ã‚Šã«SSDã‚’åˆ©ç”¨ã—ãŸã‚‰ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ€§èƒ½ã¯ã©ã‚Œã ã‘å‘ä¸Šã™ã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ã‚ªãƒ©ã‚¯ãƒ«ã¨å¯Œå£«é€šãŒå…±åŒæ¤œè¨¼ã‚’è¡Œã„ã€ãã®çµæžœã‚’ãƒ›ãƒ¯ã‚¤ãƒˆãƒšãƒ¼ãƒ‘ãƒ¼ã¨ã—ã¦å…ˆé€±ç™ºè¡¨ã—ã¾ã—ãŸï¼ˆå‚è€ƒã€Œæ—¥æœ¬ã‚ªãƒ©ã‚¯ãƒ«ã¨å¯Œå£«é€š ãƒ•ãƒ©ãƒƒã‚·ãƒ¥æŠ€è¡“æ´»ç”¨ã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é«˜é€ŸåŒ–ã‚’å…±åŒæ¤œè¨¼ã€ï¼‰ã€‚ ãƒ›ãƒ¯ã‚¤ãƒˆãƒšãƒ¼ãƒ‘ãƒ¼ã§ã¯ã€HDDã®ä»£ã‚ã‚Š
elf 2010/04/27
Oracle

Fujitsu

Database

Storage

SAN

OracleDatabase

ETERNUS

Knowledge

publickey
ãƒªãƒ³ã‚¯
ãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ“ãƒ¥ãƒ¼ - Wikipedia
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ã¯é–¢ä¿‚ãƒ¢ãƒ‡ãƒ«ã«å¾“ã†ãŸã‚ã€ãƒ“ãƒ¥ãƒ¼ ã¯ä»®æƒ³çš„ãª ãƒ†ãƒ¼ãƒ–ãƒ« ã§ã‚ã‚Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã™ã‚‹ã‚¯ã‚¨ãƒªã®çµæžœã‚’è¡¨ã™ã€‚ãƒ“ãƒ¥ãƒ¼ã‚’å‚ç…§ã¾ãŸã¯æ›´æ–°ã™ã‚‹ã¨ã€ãã®å‡¦ç†ã¯ãƒ“ãƒ¥ãƒ¼ã®å¯¾è±¡ã¨ãªã£ãŸå®Ÿéš›ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®å‚ç…§ã¾ãŸã¯æ›´æ–°ã¸å¤‰æ›ã•ã‚Œã€å®Ÿè¡Œã•ã‚Œã‚‹ã€‚ ãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ“ãƒ¥ãƒ¼ (Materialized View; ä½“ç¾ãƒ“ãƒ¥ãƒ¼ã¨ã‚‚ã„ã†)ã¯ã“ã‚Œã¨ã¯ç•°ãªã‚‹ã‚¢ãƒ—ãƒãƒ¼ãƒã‚’å–ã‚Šã€ã‚¯ã‚¨ãƒªã®çµæžœã‚’å®Ÿéš›ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«ã‚ãƒ£ãƒƒã‚·ãƒ¥ã™ã‚‹ã€‚ã‚ãƒ£ãƒƒã‚·ãƒ¥ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã¯å…ƒã®ãƒ†ãƒ¼ãƒ–ãƒ«ãŒå¤‰æ›´ã•ã‚Œã‚‹ãŸã³ã«æ›´æ–°ã•ã‚Œã‚‹ã€‚ãã®ãŸã‚ã€æœ€æ–°ã§ãªã„çŠ¶æ…‹ã‚’å–å¾—ã™ã‚‹å¯èƒ½æ€§ã¯ã‚ã‚‹ãŒã€åŠ¹çŽ‡çš„ãªã‚¢ã‚¯ã‚»ã‚¹ãŒå¯èƒ½ã«ãªã‚‹ã€‚ç‰¹ã«ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ã§ã¯å®Ÿéš›ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦é »ç¹ã«ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹ã“ã¨ã¯éžå¸¸ã«ã‚³ã‚¹ãƒˆãŒé«˜ã„ãŸã‚ã€ãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ“ãƒ¥ãƒ¼ãŒæœ‰åŠ¹ã§ã‚ã‚‹ã€‚ ã•ã‚‰ã«ã€ãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ“ãƒ¥ãƒ¼ã¯å®Ÿéš›ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ã—ã¦å®Ÿä½“åŒ–ã•ã‚Œã‚‹ãŸã‚ã€å®Ÿéš›ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾ã—ã¦é©ç”¨å¯èƒ½ãªæ“ä½œã¯
elf 2010/04/10
Materialized View

OracleDatabase

Database

Wikipedia
ãƒªãƒ³ã‚¯
FirewireæŽ¥ç¶šHDDã§Oracle 11g RAC
Oracleç¤¾ãŒå…¬é–‹ã—ã¦ã„ã‚‹ä»¥ä¸‹ã®æƒ…å ±ã‚’åŸºã«ã€FireWireæŽ¥ç¶šã®HDDã‚’å…±æœ‰ãƒ‡ã‚£ã‚¹ã‚¯ã¨ã—ã¦åˆ©ç”¨ã—ã¦ã€CentOS 5.2ä¸Šã«Oracle 11g RACã‚’æ§‹ç¯‰ã—ã¦ã¿ãŸã®ã§ã€ãã®æ‰‹é †ã‚’èª¬æ˜Žã—ã¾ã™ã€‚
elf 2009/11/24
CentOS

Linux

OracleDatabase

OCFS

Database

File System

RAC
ãƒªãƒ³ã‚¯
â€“ ã“ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ã¯ãŠåå‰.comã§å–å¾—ã•ã‚Œã¦ã„ã¾ã™ã€‚
ã“ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ã¯ ãŠåå‰.com ã‹ã‚‰å–å¾—ã•ã‚Œã¾ã—ãŸã€‚ ãŠåå‰.com ã¯ GMOã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆ(æ ª) ãŒé‹å–¶ã™ã‚‹å›½å†…ã‚·ã‚§ã‚¢No.1ã®ãƒ‰ãƒ¡ã‚¤ãƒ³ç™»éŒ²ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚
elf 2009/11/01
OracleDatabase

PostgreSQL

Database

ThinkIT
ãƒªãƒ³ã‚¯
Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è©³ç´°è§£æžã‚’ å¯èƒ½ã«ã—ãŸMaxGaugeå°Žå…¥ã§ã€ I/O è² è·ã‚’å¤§å¹…ã«è»½æ¸›
elf 2009/06/01
RecoChoku

Interview

OracleDatabase

MaxGauge
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç›£è¦–ã‚’ã€ã‚ˆã‚Šæ—©ãç¢ºå®Ÿã«è§£æ±ºï½œMaxGaugeï¼ˆãƒžãƒƒã‚¯ã‚¹ã‚²ãƒ¼ã‚¸ï¼‰æ—¥æœ¬ã‚¨ã‚¯ã‚»ãƒ æ ªå¼ä¼šç¤¾
MaxGaugeï¼ˆãƒžãƒƒã‚¯ã‚¹ã‚²ãƒ¼ã‚¸ï¼‰ã¯ã€éŸ“å›½EXEMç¤¾ã«ã‚ˆã£ã¦é–‹ç™ºã•ã‚ŒãŸã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å¯è¦–åŒ–ã—äº‹æ¥ã®å¯è¦³æ¸¬æ€§ã‚’é«˜ã‚ã‚‹ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã§ã™ã€‚ ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ã«ã‚ˆã‚‹æƒ…å ±åŽé›†ã¨è¨ºæ–ã«ã‚ˆã‚Šã€ã‚ã‚‰ã‚†ã‚‹ãƒˆãƒ©ãƒ–ãƒ«ã®äºˆå…†ã‚’æ¤œçŸ¥ã—ãªãŒã‚‰ã€è‡ªç¤¾ã§å•é¡Œã‚’ç©¶æ˜Žã§ãã‚‹ä½“åˆ¶ã®ç¢ºç«‹ã‚’ã‚µãƒãƒ¼ãƒˆã€‚ ã‚µãƒ¼ãƒãƒ¼ã‚„ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’å«ã‚€ã‚¤ãƒ³ãƒ•ãƒ©é ˜åŸŸã«ãŠã‘ã‚‹éšœå®³ã®å›žé¿ã¨ã€æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ æ‹…å½“è€…æ§˜ã®æ¥å‹™åŠ¹çŽ‡åŒ–ã‚’æ”¯æ´ã—ã¾ã™ã€‚
elf 2009/03/06
OracleDatabase

MaxGuage

SunBridge

Database

Management
ãƒªãƒ³ã‚¯
ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ ã‚¨ã‚¯ã‚¹ãƒãƒ¼ã‚¿ãƒ¼
ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸ã‚¨ã‚¯ã‚¹ãƒãƒ¼ã‚¿ãƒ¼(TDE)ã¯æ—¢å˜ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©æ›¸(Excelãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆ)ã‚’ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã™ã‚‹ãƒ„ãƒ¼ãƒ«ã§ã™ã€‚ å››ç¨®é¡ž(Oracleã€SQL Serverã€PostgreSQLã€MySQL)ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¯¾å¿œã§ãã¾ã™ã€‚ å‡ºåŠ›Excelãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã€é …ç›®ã€é †ç•ªãªã©è‡ªç”±ã«è¨å®šã§ãã¾ã™ã€‚è‡ªç¤¾å°‚ç”¨ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã‚‚ç°¡å˜ã«å¯¾å¿œã§ãã¾ã™ã€‚ ã‚³ãƒ¡ãƒ³ãƒˆå‡ºåŠ›ã§ãã¾ã™ã€‚
elf 2009/02/09
TDE

Windows

OracleDatabase

SQL Server

PostgreSQL

MySQL

Excel
ãƒªãƒ³ã‚¯
Oracleã®æ©Ÿèƒ½ã‚’ä½¿ã£ã¦è¡¨ã®çµåˆã‚’é«˜é€ŸåŒ–ã™ã‚‹ï¼ˆ1/4ï¼‰ ï¼ ï¼ IT
æœ¬é€£è¼‰ã§ã¯ã€Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ãƒ»ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ä¸ã‹ã‚‰ã€ç‰¹ã«SQLã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã«æ³¨ç›®ã—ã¦ã€å®Ÿè·µãƒ¬ãƒ™ãƒ«ã®æ‰‹æ³•ã‚’è§£èª¬ã™ã‚‹ã€‚èªè€…ã¯Oracleãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’ç†è§£ã—ã€é‹ç”¨ç®¡ç†ã®å®Ÿå‹™çµŒé¨“ã‚’ç©ã‚“ã§ã„ã‚‹ã“ã¨ãŒæœ›ã¾ã—ã„ã€‚å¯¾è±¡ã¨ã™ã‚‹ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯ç¾çŠ¶ã§åºƒãä½¿ã‚ã‚Œã¦ã„ã‚‹Oracle9iã®æ©Ÿèƒ½ã‚’åŸºæœ¬ã¨ã™ã‚‹ãŒã€Oracle 10gã§æœ‰åŠ¹ãªæƒ…å ±ã‚‚éšæ™‚ç´¹ä»‹ã—ã¦ã„ãã€‚ï¼ˆç·¨é›†å±€ï¼‰ é€£è¼‰ç›®æ¬¡ å‰å›žã€Œè¡¨ã®çµåˆã‚’æ¥µã‚ã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ»ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã€ã§ã¯ã€çµžã‚Šè¾¼ã¿æ¡ä»¶ãŒãªã„çµåˆã‚’å«ã‚€SQLã€çµžã‚Šè¾¼ã¿æ¡ä»¶ã®ã‚ã‚‹çµåˆã‚’å«ã‚€SQLã«ã¤ã„ã¦å®Ÿä¾‹ã‚’åŸºã«æœ€é©ãªçµåˆæ–¹æ³•ã‚’èª¬æ˜Žã—ã¾ã—ãŸã€‚ ä»Šå›žã¯ã€Oracleã®æ©Ÿèƒ½ã§ã‚ã‚‹ã€Œãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ»ãƒ“ãƒ¥ãƒ¼ã€ã€ŒBIT MAP JOIN INDEXã€ã€Œã‚¯ãƒ©ã‚¹ã‚¿ã€ã‚’åˆ©ç”¨ã—ãŸçµåˆå‡¦ç†ã«é–¢ã™ã‚‹ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ»ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ ãƒžãƒ†ãƒªã‚¢ãƒ©ã‚¤ã‚ºãƒ‰ãƒ»ãƒ“ãƒ¥ãƒ¼ã‚’ç†è§£ã™ã‚‹ çµåˆå‡¦ç†ãª
elf 2009/01/08
OracleDatabase

Materialized View

Knowhow

@IT
ãƒªãƒ³ã‚¯
ã€ãƒã‚¦ãƒ„ãƒ¼ã€‘åˆå¿ƒè€…å¿…è¦‹! Oracle 10gã‚’RHEL4ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«(1) - ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€ãã®å‰ã« (1) ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã«å¿…è¦ãªç’°å¢ƒã‚’ãã‚ãˆã‚‹ | ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚º | ãƒžã‚¤ã‚³ãƒŸã‚¸ãƒ£ãƒ¼ãƒŠãƒ«
å•†æ¥ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å®šç•ªã¨è¨€ãˆã°ã€Oracle Database 10g(ä»¥ä¸‹ã€Oracle 10g)ã ã€‚Oracle 10gã¯é«˜ã„ä¿¡é ¼æ€§ã¨ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£(è¦æ¨¡ã«å¿œã˜ãŸæ‹¡å¼µæ€§ã®é«˜ã•)ã‚’èª‡ã‚Šã€å•†æ¥å¸‚å ´ã§ã¯ä»–ç¤¾è£½å“ã‚’å¯„ã›ä»˜ã‘ãªã„ã€‚ã“ã“æ•°å¹´ã¯ã€PostgreSQLã‚„MySQLãªã©ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æŽ¡ç”¨ã—ãŸã‚·ã‚¹ãƒ†ãƒ ã‚‚å¢—ãˆã¦ããŸã€‚ã ãŒã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãŒæ´»èºã™ã‚‹å ´æ‰€ã¯ã€ã©ã¡ã‚‰ã‹ã¨è¨€ã†ã¨ã€ä¿¡é ¼ã‚’é‡è¦–ã™ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã‚ˆã‚Šã‚‚éŠã³å¿ƒã‚’ãã™ãã‚‹Web2.0ç³»ã‚µãƒ¼ãƒ“ã‚¹ã®ã‚·ã‚¹ãƒ†ãƒ ãŒå¤šã„ã€‚ã¾ãŸã€Oracle 10gãŒå¤šãå‹•ä½œã—ã¦ã„ã‚‹ç’°å¢ƒ(OS)ã¯ã€å•†ç”¨åˆ©ç”¨ã‚’å‰æã«ã‚µãƒãƒ¼ãƒˆã‚µãƒ¼ãƒ“ã‚¹ãŒæä¾›ã•ã‚Œã¦ã„ã‚‹UNIXãƒ™ãƒ¼ã‚¹ã®ã‚·ã‚¹ãƒ†ãƒ ã ã€‚ã¤ã¾ã‚Šã€ä¿¡é ¼æ€§ãŒä½•ã‚ˆã‚Šã‚‚é‡è¦ãªç’°å¢ƒã§ã€æœ€ã‚‚ä½¿ã‚ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒOracle 10gã€ã¨ã„ã†ã“ã¨ã«ãªã‚‹ã€‚ ã“ã®ãƒã‚¦ãƒ„ãƒ¼ã§ã¯RedHat Enterprise Linuxãƒãƒ¼ã‚¸ãƒ§ãƒ³4(ä»¥
elf 2006/12/27
RHEL

OracleDatabase
ãƒªãƒ³ã‚¯
1