dbdiagram.io - Database Relationship Diagrams Design ToolQuick and simple free tool to help you draw your database relationship diagrams and flow quickly using simple DSL language.
TwitterãŒæ¤œç´¢ã‚¢ãƒ¼ã‚テクãƒãƒ£ã‚’変更ã€ãƒ„イート処ç†æ€§èƒ½ãŒç´„50å€ã«
ç±³Twitterã¯ã€åŒç¤¾ãŒé‹å–¶ã™ã‚‹ãƒŸãƒ‹ãƒ–ãƒã‚°ã‚µãƒ¼ãƒ“ス「Twitterã€ã®æ¤œç´¢ã‚¢ãƒ¼ã‚テクãƒãƒ£ã‚’変更ã—ã¦ã„ãŸã“ã¨ã‚’米国時間2010å¹´10月6æ—¥ã«æ˜Žã‹ã—ãŸã€‚数週間å‰ã‚ˆã‚Šæ–°ãŸãªã‚¢ãƒ¼ã‚テクãƒãƒ£ã«ç§»è¡Œã—ã¦ãŠã‚Šã€1秒当ãŸã‚Šã®ãƒ„イート（コメント）処ç†æ€§èƒ½ãŒç´„50å€ã«å‘上ã—ãŸã¨ã„ã†ã€‚ TwitterãŒæœ€è¿‘ã¾ã§åˆ©ç”¨ã—ã¦ã„ãŸãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ 検索エンジンã¯ã€åŒç¤¾ãŒ2008å¹´ã«è²·åŽã—ãŸç±³Summizeã®ç‹¬è‡ªæŠ€è¡“をベースã«ã—ã¦ã„ãŸãŒã€ãã®å¤ã„MySQLベースã®ã‚·ã‚¹ãƒ†ãƒ ã¯æ‹¡å¼µãŒå›°é›£ã«ãªã£ã¦ã„ãŸã€‚ãã“ã§åŒç¤¾ã¯ç´„åŠå¹´å‰ã«ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ãªã転置インデックスを用ã„ãŸæ–°ãŸãªæ¤œç´¢ã‚¢ãƒ¼ã‚テクãƒãƒ£ã‚’開発ã™ã‚‹ã“ã¨ã«ã—ãŸã€‚Javaã§è¨˜è¿°ã•ã‚ŒãŸæ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã€ŒLuceneã€ã«ä¸€éƒ¨æ‰‹ã‚’åŠ ãˆã¦æŽ¡ç”¨ã—ãŸã€‚ æ–°ãŸãªæ¤œç´¢ã‚¢ãƒ¼ã‚テクãƒãƒ£ã¯ã€æ¯Žç§’1000件以上ã®ã‚³ãƒ¡ãƒ³ãƒˆã‚’処ç†ã™ã‚‹ã€‚1秒当ãŸã‚Šã®ã‚¯ã‚¨ãƒªãƒ¼å‡¦ç†ä»¶æ•°ã¯1万2000件以上ã§ã€1日当ãŸã‚Š
SQLライクã«Hadoop Hiveを使ã„倒ã™!
パーティションを利用ã™ã‚‹ 今回ã¯å°‘ã—å‡ã£ãŸãƒ†ãƒ¼ãƒ–ルを定義をã—ã¦ã¿ã¾ã—ょã†ã€‚ 郵便番å·ãƒ‡ãƒ¼ã‚¿ã¯æ¯Žæœˆæ›´æ–°ã•ã‚Œã‚‹ã®ã§ã€ãƒ†ãƒ¼ãƒ–ル指定時ã«ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚‚指定ã§ãるよã†ã«ã—ã¾ã™ã€‚ã“ã®ã‚ˆã†ãªå ´åˆã€Hiveã§ã¯ãƒ‘ーティションを使ã„ã¾ã™ã€‚ 以下ã«éƒµä¾¿ç•ªå·ã‚’ä¿å˜ã™ã‚‹ãƒ†ãƒ¼ãƒ–ル「zipã€ã‚’定義ã—ã¾ã™ãŒã€æ—¥ä»˜åž‹DATEã®ãƒ‘ーティションverã‚’è¨å®šã™ã‚‹ã‚ˆã†ã«ã—ã¾ã™ã€‚ hive> CREATE TABLE zip (zip STRING, pref INT, city STRING, town STRING) > PARTITIONED BY (ver DATE) > ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' > LINES TERMINATED BY '\n'; OK Time taken: 0.128 seconds
Data.gov Home - Data.gov
An official website of the United States government Here's how you know The .gov means it's official. Federal government websites often end in .gov or .mil. Before sharing sensitive information, make sure you're on a federal government site. The site is secure. The https:// ensures that you are connecting to the official website and that any information you provide is encrypted and transmitted sec
1
ランã‚ング
ãŠçŸ¥ã‚‰ã›
ランã‚ング
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
Amazon.co.jp: プãƒã‚°ãƒ©ãƒžã®ãŸã‚ã®SQL 第4版: ジョーセルコ: 本
{{#tags}}- {{label}}
{{/tags}}