パーティション・プルーニングã®æœ‰åŠ¹æ€§ã‚’検証ã™ã‚‹
本連載ã§ã¯ã€å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã®ãƒ‘フォーマンス・ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®æ‰‹æ³•ã¨ã—ã¦ã€Oracleパーティショニングを解説ã™ã‚‹ã€‚å˜ãªã‚‹æ©Ÿèƒ½èª¬æ˜Žã«ã¨ã©ã¾ã‚‰ãšã€å®Ÿæ©Ÿã«ã‚ˆã‚‹æ¤œè¨¼çµæžœã‚’åŠ ãˆã¦ã€ã‚ˆã‚Šå®Ÿè·µçš„ãªå†…容をãŠå±Šã‘ã™ã‚‹ã€‚（編集部） (2/4)
オラクルパーティション分割メモ(Hishidama's parition for Oracle10g Memo)
パーティションã®å¤‰æ›´ åå‰ è¿½åŠ ãƒ»å‰Šé™¤ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ä½œæˆ [/2008-06-28] パーティション定義ã®ç…§ä¼š [/2009-01-06] パーティション内ã®ãƒ‡ãƒ¼ã‚¿ データæ“作SQL [/2009-10-06] 特定パーティションã¸ã®SQL実行 [/2010-02-04] æ ¼ç´ã•ã‚Œã¦ã„るパーティションã®ç¢ºèª [2009-01-09] パーティションã®ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆ [2007-12-13] パーティションを使ã†ã«ã¯ã€Enterprise Editionã§ã‚ã‚‹å¿…è¦ãŒã‚る。[2009-12-24] SQL> create table part_test 2 (key number) 3 partition by hash(key); create table part_test * è¡Œ1ã§ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã—ã¾ã—ãŸã€‚: ORA-00439: 機能ã¯ä½¿ç”¨å¯èƒ½ã§ã¯ã‚ã‚Šã›ã‚“: Partitioning SQ
Partitioning Concepts
2 Partitioning Concepts Partitioning enhances the performance, manageability, and availability of a wide variety of applications and helps reduce the total cost of ownership for storing large amounts of data. Partitioning allows tables, indexes, and index-organized tables to be subdivided into smaller pieces, enabling these database objects to be managed and accessed at a finer level of granularit
連載記事 「Oracleãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ‹ãƒ³ã‚°å®Ÿè·µè¬›åº§ã€ ï¼ ï¼ IT
Oracleライセンス「SE2ã€æ¤œè¨¼ã€€CPUスレッド数制é™ã¯ã©ã‚“ãªä»•çµ„ã¿ã§åˆ¶å¾¡ã•ã‚Œã‚‹ã®ã‹ （2017/7/26） データベース管ç†ã‚·ã‚¹ãƒ†ãƒ ã®é‹ç”¨ã§ãƒˆãƒ©ãƒ–ルãŒç™ºç”Ÿã—ãŸã‚‰ã©ã†ã™ã‚‹ã‹ã€‚DBサãƒãƒ¼ãƒˆã‚¹ãƒšã‚·ãƒ£ãƒªã‚¹ãƒˆãŒç¾å ´ç›®ç·šã®è§£æ±ºTipsã‚’ãŠå±Šã‘ã—ã¾ã™ã€‚今回ã¯ã€Oracle SE2ã®ã€ŒCPUスレッド数制é™ã€ãŒã©ã‚“ãªä»•çµ„ã¿ã§è¡Œã‚れるã®ã‹ã‚’検証ã—ã¾ã™ ドメインå‚åŠ å¾Œã€SQL ServerãŒèµ·å‹•ã—ãªããªã£ãŸ （2017/7/24） 本連載ã§ã¯ã€ã€ŒSQL Serverã€ã§ç™ºç”Ÿã™ã‚‹ãƒˆãƒ©ãƒ–ルを「ã©ã‚“ãªæ–¹æ³•ã§ã€ã€Œã©ã®ã‚ˆã†ã«ã€è§£æ±ºã—ã¦ã„ãã‹ã€æ£ã—ã„対処ã®ãŸã‚ã®ãƒŽã‚¦ãƒã‚¦ã‚’紹介ã—ã¾ã™ã€‚今回ã¯ã€ã€Œãƒ‰ãƒ¡ã‚¤ãƒ³å‚åŠ å¾Œã«SQL ServerãŒèµ·å‹•ã—ãªããªã£ãŸå ´åˆã®å¯¾å‡¦æ–¹æ³•ã€ã‚’解説ã—ã¾ã™ ã•ã‚‰ã«é«˜åº¦ãªSQL実行計画ã®å–å¾—ã€ã®ãŸã‚ã«ç†è§£ã—ã¦ãŠãã¹ãã“㨠（2017/7/21） 日本オラクルã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¹ãƒšã‚·ãƒ£ãƒªã‚¹ãƒˆãŒã€ŒDBAãŒã™ã
Disk partitioning - Wikipedia
GParted is a popular utility used for disk partitioning Disk partitioning or disk slicing[1] is the creation of one or more regions on secondary storage, so that each region can be managed separately.[2] These regions are called partitions. It is typically the first step of preparing a newly installed disk after a partitioning scheme is chosen for the new disk before any file system is created. Th
Martin Fowler's Bliki in Japanese - トランザクションレス
http://martinfowler.com/bliki/Transactionless.html 2007/3/18 (更新：Bill Caputoã‹ã‚‰ã‚‚経験談をã„ãŸã ã„ãŸ) æ•°å¹´å‰ã«eBayã§åƒãå‹äººãŸã¡ã¨è©±ã—ã¦ã„ãŸã¨ãã®ã“ã¨ã 。 大è¦æ¨¡ã‚µã‚¤ãƒˆã§ä½¿ã‚れる技術ã®è©±ã‚’èžãã®ã¯ã„ã¤ã‚‚楽ã—ã„ãŒã€ç‰¹ã«èˆˆå‘³æ·±ã‹ã£ãŸã®ãŒã€eBayã§ã¯æ»…多ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’使用ã—ãªã„ã¨ã„ã†è©±ã ã£ãŸã€‚ トランザクションãŒãªã„環境ã¨ã„ã†ã®ã¯é©šãã¹ãã“ã¨ã§ã¯ãªã„ã ã‚ã†ã‹ã€‚ データベースを扱ã†ã¨ãã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’使ã†ã®ã¯ã”ãã”ã一般的ãªã“ã¨ã 。 多ãã®äººã«ã¨ã£ã¦ï¼ˆç§ã‚‚ãã†ã ãŒï¼‰ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’使ã†åˆ©ç‚¹ã®ã²ã¨ã¤ã 。 eBayãŒãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’使ã‚ãªã„ã®ã¯ã€ã‚ã®ã‚ˆã†ãªè¦æ¨¡ã§ã¯ãƒ‘フォーマンスã«å½±éŸ¿ãŒå‡ºã¦ã—ã¾ã†ã‹ã‚‰ã ã¨ã„ã†ã‚‚ã®ã ã£ãŸã€‚ eBayã§ã¯ãƒ‡ãƒ¼ã‚¿ã‚’ã„ãã¤ã‚‚ã®ç‰©ç†çš„データベースã«ãƒ‘ーテショ
ãŠã„ã¬ã¾æ—¥å ±(ä¸å®šæœŸ) - YAPC::Asia 2007 Tokyoã«è¡Œã£ã¦ãã¾ã—㟠, perl I18N in 20 minutes - Dan Kogaiã•ã‚“ , Perlãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°å†è€ƒ - Naoya..
@ [yapc] YAPC::Asia 2007 Tokyoã«è¡Œã£ã¦ãã¾ã—㟠今日ã¨æ˜Žæ—¥é–‹å‚¬ã•ã‚Œã‚‹YAPC::Asia 2007 Tokyoã«ä»Šå¹´ã‚‚å‚åŠ ã—ã¦ãã¾ã—ãŸã€‚仕事ã®éƒ½åˆã¨ã‹ã§å…¨éƒ¨ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã«ã¯å‚åŠ ã§ããªã‹ã£ãŸã®ã§ã™ãŒã€å‚åŠ ã§ããŸã‚„ã¤ã¯ã©ã‚Œã‚‚内容ãŒæ¿ƒãã¦éžå¸¸ã«å‚考ã«ãªã‚Šã¾ã—ãŸã€‚ã¨ã„ã†ã‚ã‘ã§ãƒŽãƒ¼ãƒˆã‚’å°‘ã—å–ã£ãŸã®ã§ãƒ¡ãƒ¢ä»£ã‚ã‚Šã«æ›¸ã„ã¦ãŠãã¾ã™ã€‚ @ perl I18N in 20 minutes - Dan Kogaiã•ã‚“ スライド Perl内部ã§ã¯ãƒ‡ãƒ¼ã‚¿ã¯å…¨ã¦Unicodeã§ä¿æŒã•ã‚Œã¦ã„ã‚‹ã®ã¯æœ‰åã§ã™ãŒã€Perlã®Unicodeã®ã‚µãƒãƒ¼ãƒˆã£ã·ã‚Šã¯ä»–ã®LL言語ã«æ¯”ã¹ã¦ã™ã”ã進んã§ã‚‹ã‚ˆã€ã¨ã„ã†è©±ã€‚ Encode.pm ã“ã‚Œã¯æ–‡å—コードを変æ›ã™ã‚‹ãŸã‚ã®ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã®ã²ã¨ã¤ã€‚ä»–ã®ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ãƒ¼ã‚¹ã¨ã—ã¦ã¯PerlIO(open)ã¨ã‹ã€binmodeã¨ã‹ã€‚ Perlã®Unicodeサãƒãƒ¼ãƒˆå…·åˆ
パーティショニング機能 - mir the developer
MySQL 5.1ã§ã¯ãƒ‘ーティショニング機能ãŒå®Ÿè£…ã•ã‚Œã¦ã„ã‚‹ã®ã§ã™ãŒã€ãã®ãŠã•ã‚‰ã„ã‚’ã™ã‚‹ãœã€‚（｀・ω・´） パーティショニング機能ã®åˆ©ç”¨å¯å¦ç¢ºèªã€‚ [test] > show variables like '%partition%'; +-------------------+-------+ | Variable_name | Value | +-------------------+-------+ | have_partitioning | YES | +-------------------+-------+ 1 row in set (0.00 sec)SQL構文。CREATE TABLEã®table optionã®å¾Œã«ã¤ã‘る。ALTER TABLEã§ã‚‚ã¤ã‹ãˆã‚‹ã€‚ partition_options: PARTITION BY [LINEAR] HASH(expr) | [LIN
MySQL :: Developer Zone
"The Documents contained within this site may include statements about Oracle's product development plans. Many factors can materially affect Oracle's product development plans and the nature and timing of future product releases. Accordingly, this Information is provided to you solely for information only, is not a commitment to deliver any material, code, or functionality, and should not be reli
1
ランã‚ング
ãŠçŸ¥ã‚‰ã›
ランã‚ング
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
Teradata | Data and Analytics, Cloud Analytics, & Consulting
https://www.db2dean.com/Previous/RangePart.html
LiveJournal: Begind The Scenes / Scaling Storytime
MySQL :: MySQL Forums :: Partitioning
PARTITION by a date column
http://mt.taf.to/archives/2006/07/partitioning_wi.html
{{#tags}}- {{label}}
{{/tags}}