[B! SQL] ZAORIKUã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ZAORIKU id:ZAORIKU

SQLã«é–¢ã™ã‚‹ZAORIKUã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (17)

${{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}}

ã€Œé›‘èªŒã‚ªãƒ³ãƒ©ã‚¤ãƒ³æ ªå¼ä¼šç¤¾è¨ç«‹ã®ãŠçŸ¥ã‚‰ã›ã€ - é›‘èªŒã‚ªãƒ³ãƒ©ã‚¤ãƒ³+BOOKS
ZAORIKU 2017/10/20
SQL

@
ãƒªãƒ³ã‚¯
ã‚°ãƒ«ãƒ¼ãƒ—å˜ä½ã§ä¸Šä½nä»¶ã‚’å–å¾—ã™ã‚‹SQL
ã¡ãªã¿ã«ã€PostgreSQL8ã§ç¢ºèªã—ã¾ã—ãŸãŒã€ä»–ã®RDBã§ã¯ç¢ºèªã—ã¦ã„ã¾ã›ã‚“ã€‚ã“ã®SQLã§ã¯åŒç‚¹ã®å ´åˆã«IDé †ã§ä¸Šä½ã‚’æ±ºã‚ã¦ã„ã¾ã™ã€‚åŒç‚¹ã¯å…¨ã¦å‡ºã™ã¨ã„ã†ãƒ«ãƒ¼ãƒ«ã«ãªã‚‹ã¨è©¦ã—ã¦ã„ãªã„ã§ã™ãŒã€inå¥ã®ä¸ã®ã‚µãƒ–ã‚¯ã‚¨ãƒªã®whereå¥ã«ãƒã‚¤ãƒ³ãƒˆä¸Šä½2ä»¶ã‚’å–å¾—ã—ã¦ã€ãƒã‚¤ãƒ³ãƒˆåŒå£«ã§ãã£ã¤ã‘ã‚‹å¿…è¦ãŒã‚ã‚‹ã§ã—ã‚‡ã†ã€‚ï¼ˆæ˜Žæ—¥ã§ã‚‚è©¦ã—ã¦ã¿ã‚ˆã†ã‹ãªãƒ»ãƒ»ãƒ»ï¼‰ æŠ•ç¨¿æ—¥æ™‚ : 2007å¹´6æœˆ7æ—¥ 22:10 Feedback #Â re: ã‚°ãƒ«ãƒ¼ãƒ—å˜ä½ã§ä¸Šä½nä»¶ã‚’å–å¾—ã™ã‚‹SQL 2007/07/02 17:49 ã˜ã‚ƒã‚“ã¬ãã£ã¨ å½¹ç«‹ã£ã¦ã„ã‚‹ã‚ˆã†ã§ã™ãã€‚ http://www.atmarkit.co.jp/bbs/phpBB/viewtopic.php?topic=39369&forum=26 #Â re: ã‚°ãƒ«ãƒ¼ãƒ—å˜ä½ã§ä¸Šä½nä»¶ã‚’å–å¾—ã™ã‚‹SQL 2007/07/02 19:22 ã‹ã¤ã®ã‚Š ã³ã£ãã‚Šã—ãŸï½— #Â ???????
ZAORIKU 2017/02/05
SQL

sqlite

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
SQLå®Ÿè¡Œæ™‚ã®ãƒ–ãƒ«ãƒ¼ãƒ ãƒ•ã‚£ãƒ«ã‚¿(Bloom Filter)ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ | ãƒ•ãƒ¥ãƒ¼ãƒãƒ£ãƒ¼æŠ€è¡“ãƒ–ãƒã‚°
1. åˆã‚ã«DBã«ãŠã‘ã‚‹å‡¦ç†ã¯SQLã«ã‚ˆã£ã¦è¨˜è¿°ã—ã¾ã™ãŒã€ãƒ‡ãƒ¼ã‚¿ã®å–å¾—ã™ã‚‹ãŸã‚ã«å…·ä½“çš„ã«ã©ã®ã‚ˆã†ãªå†…éƒ¨å‡¦ç†ã‚’è¡Œã†ã‹ã¨ã„ã†ç‚¹ã¾ã§ã¯è¨˜è¿°ã—ã¾ã›ã‚“ã€‚ ã“ã“ã§ã„ã†å†…éƒ¨å‡¦ç†ã¨ã¯ã€ŒSQLã®æ›¸ãæ›ãˆã€ã€Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½¿ç”¨ã€ã€Œçµåˆã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã®é¸æŠžã€ãªã©ãŒDBMSã®ã‚ªãƒ—ãƒ†ã‚£ãƒžã‚¤ã‚¶ã«ã‚ˆã£ã¦é¸æŠžã•ã‚Œã¦å®Ÿæ–½ã•ã‚Œã‚‹ã“ã¨ã‚’æŒ‡ã—ã¾ã™ã€‚ SQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’è¦‹ã‚‹ã«ã‚ãŸã£ã¦ã¯ä¸Šè¨˜ã®å†…éƒ¨å‡¦ç†ã«ã¤ã„ã¦æ£ã—ãç†è§£ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ æœ¬Blogã§ã¯ã€é‡è¦ãªã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ ã§ã‚ã‚‹ã«ã‚‚ã‹ã‹ã‚ã‚‰ãšã€ã¾ã¨ã¾ã£ãŸæƒ…å ±ãŒå°‘ãªã„SQLå®Ÿè¡Œæ™‚ã«ãŠã‘ã‚‹ãƒ–ãƒ«ãƒ¼ãƒ ãƒ•ã‚£ãƒ«ã‚¿(Bloom Filter)ã«ã¤ã„ã¦Oracleã‚’ã‚‚ã¨ã«ç´¹ä»‹ã‚’è¡Œã„ã¾ã™ã€‚ Bloom Filterã¯çµåˆå‡¦ç†ã‚’åŠ¹çŽ‡åŒ–ã™ã‚‹ãŸã‚ã«ã€çµåˆã®å‰æ®µéšŽã§åˆ©ç”¨ã•ã‚Œã‚‹æŠ€è¡“ã«ãªã‚Šã¾ã™ã€‚ å…¬å¼ãªãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã¨ã—ã¦ã¯ä»¥ä¸‹ã«ãªã‚Šã¾ã™ã€‚ Oracle Database SQLãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ãƒ»ã‚¬ã‚¤ãƒ‰ 12cãƒª
ZAORIKU 2016/11/01
SQL

ãƒãƒƒã‚·ãƒ¥

ã‚¢ãƒ«ã‚´ãƒªã‚ºãƒ

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
https://qiita.com/kantomi/items/357b592f48c6d5ddb182
ZAORIKU 2016/09/17
sql
ãƒªãƒ³ã‚¯
ã€ŽãªãœUber Engineeringã¯Postgresã‹ã‚‰MySQLã«åˆ‡ã‚Šæ›¿ãˆãŸã®ã‹ã€ã«ã¤ã„ã¦ : RavenDBå‰µå§‹è€…ã®è¦‹åœ°ã‹ã‚‰ | POSTD
ã€ŽãªãœUber Engineeringã¯Postgresã‹ã‚‰MySQLã«åˆ‡ã‚Šæ›¿ãˆãŸã®ã‹ã€ã«ã¤ã„ã¦ : RavenDBå‰µå§‹è€…ã®è¦‹åœ°ã‹ã‚‰ (è¨³æ³¨ï¼š2016/9/28ã€é ‚ãã¾ã—ãŸãƒ•ã‚£ãƒ¼ãƒ‰ãƒãƒƒã‚¯ã‚’å…ƒã«è¨˜äº‹ã‚’ä¿®æ£ã„ãŸã—ã¾ã—ãŸã€‚) Uber Engineering ã‚°ãƒ«ãƒ¼ãƒ—ã¯ã€ãƒ–ãƒã‚°ã§Postgresã‹ã‚‰MySQLã«åˆ‡ã‚Šæ›¿ãˆãŸã“ã¨ã«ã¤ã„ã¦ éžå¸¸ã«ç´ æ™´ã‚‰ã—ã„å ±å‘Š (è¨³æ³¨ï¼šå¼Šã‚µã‚¤ãƒˆã§ã®å’Œè¨³ã¯ ã“ã¡ã‚‰ )ã‚’ã—ã¾ã—ãŸã€‚ãƒ‡ã‚£ã‚¹ã‚¯ä¸Šã®ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã‚„ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã¸ã®å½±éŸ¿äºˆæ¸¬ãªã©ã®è©³ç´°ã¾ã§è¸ã¿è¾¼ã‚“ã§ãŠã‚Šã€æ–‡å—é€šã‚Šã€èªã¿å¿œãˆãŒã‚ã‚Šã¾ã™ã€‚ è©±ã®ãƒã‚¿ã¨ã—ã¦ã¯ã€Uberã‹ã‚‰ã‚‚ã†1ã¤ç´ æ™´ã‚‰ã—ã„è¨˜äº‹ãŒå‡ºã¦ã„ã¾ã™ã€‚ MySQLã‹ã‚‰Postgresã¸ã®åˆ‡ã‚Šæ›¿ãˆ ã«ã¤ã„ã¦ã§ã€ã“ã¡ã‚‰ã‚‚èˆˆå‘³æ·±ã„å†…å®¹ã§ã™ã€‚ ãœã²ã€ä¸¡æ–¹èªã‚“ã§ã¿ã¦ãã ã•ã„ã€‚èªã¿çµ‚ãˆãŸã‚‰ã€æ„è¦‹äº¤æ›ã—ã¾ã—ã‚‡ã†ã€‚ãƒ–ãƒã‚°å†…ã§ã®è°è«–ã‚’ç§ãŸã¡ãŒã“ã‚Œã¾ã§å–ã‚Šçµ„ã‚“ã§ããŸã“ã¨ã¨æ¯”è¼ƒã—ãŸã„ã¨æ€
ZAORIKU 2016/09/02
DB

@

SQL
ãƒªãƒ³ã‚¯
pandasã«sqlã§ã‚ˆãã‚„ã‚‹å‡¦ç†ã‚’ã‚„ã‚‰ã›ã¦ã¿ã‚‹ | mwSoft
æ¦‚è¦ pythonã«ã‚ˆã‚‹ãƒ‡ãƒ¼ã‚¿åˆ†æžå…¥é–€ã‚’å‚è€ƒã«ã€MovieLens 1Mã‚’ä½¿ã£ã¦sqlã§æ™®æ®µã‚„ã£ã¦ã‚‹ã‚ˆã†ãªã“ã¨ï¼ˆjoinã¨ã‹group byã¨ã‹sortã¨ã‹ï¼‰ã‚’pandasã«ã‚„ã‚‰ã›ã¦ã¿ã‚‹ã€‚ ãƒ•ã‚¡ã‚¤ãƒ«ã®èªã¿è¾¼ã¿ è½ã¨ã—ã¦ããŸãƒ•ã‚¡ã‚¤ãƒ«ã‚’è§£å‡ã™ã‚‹ã¨ã€movies.datã€rating.datã€users.datã¨ã„ã†3ã¤ã®ãƒ•ã‚¡ã‚¤ãƒ«ãŒå…¥ã£ã¦ã„ã‚‹ã®ã§ã€read_csvã§èªã¿è¾¼ã‚€ã€‚ import pandas as pd movies = pd.read_csv( 'ml-1m/movies.dat', sep='::', header=None, names=['movie_id', 'title', 'genres'] ) ratings = pd.read_csv( 'ml-1m/ratings.dat', sep='::', header=None, names=['user_id', 'mo
ZAORIKU 2016/07/04
SQL

pandas

python
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
ZAORIKU 2015/11/29
SQL

@

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
sqlite: SQLite ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ä¼šè©±ã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ
sqlite: SQLite ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ç®¡ç†ã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ (This page was last modified on 2003/06/29 16:11:13 UTC) SQLite ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã«ã¯ sqlite ã¨ã„ã†ã‚·ãƒ³ãƒ—ãƒ«ãªã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ ãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£ãŒå«ã¾ã‚Œã¾ã™ã€‚ã“ã‚Œã‚’ä½¿ã†ã¨ã€ãƒ¦ãƒ¼ã‚¶ã¯æ‰‹ä½œæ¥ã§ SQLite ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æŽ¥ç¶šã—ã¦ SQL ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã§ãã¾ã™ã€‚ã“ã®æ–‡æ›¸ã§ã¯ sqlite ã®ä½¿ã„æ–¹ã«é–¢ã™ã‚‹æ¦‚ç•¥ã‚’ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚ èµ·å‹•ã™ã‚‹ sqlite ã‚’èµ·å‹•ã™ã‚‹ã«ã¯å˜ã« "sqlite" ã¨ã‚¿ã‚¤ãƒ—ã—ã€ãã®å¾Œã‚ã« SQLite ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä¿æŒã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«åã‚’ä»˜ã‘ã¾ã™ã€‚ãƒ•ã‚¡ã‚¤ãƒ«ãŒå˜åœ¨ ã—ãªã„å ´åˆã¯ã€è‡ªå‹•çš„ã«æ–°ã—ãä½œã‚‰ã‚Œã¾ã™ã€‚èµ·å‹•å¾Œ sqlite ãƒ—ãƒã‚°ãƒ©ãƒ ã¯ã€SQL ã‚’ã‚¿ã‚¤ãƒ—ã™ã‚‹ãŸã‚ã®ãƒ—ãƒãƒ³ãƒ—ãƒˆã‚’è¡¨ç¤ºã—ã¾ã™ã€‚ SQL ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆï¼ˆçµ‚äº†ã¯ã‚»ãƒŸã‚³ãƒãƒ³ï¼‰ã‚’ã‚¿ã‚¤ãƒ—ã—ã€ "E
ZAORIKU 2015/11/25
SQL

sqlite

@

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
bitbucketã®ä½¿ã„æ–¹
Elevate your software delivery from planning to production and beyond, with built-in AI, CI/CD, and a best-in-class Jira integration.
ZAORIKU 2015/11/03
SQL

Python

SQLite
ãƒªãƒ³ã‚¯
ããƒ¼ã ã„ãªã‚‹ã‚‰ããŒãå¸³: 2å¤§OSSãƒ†ã‚™ãƒ¼ã‚¿ãƒ˜ã‚™ãƒ¼ã‚¹ã®MySQLã¨PostgreSQLã®é•ã„ã«ã¤ã„ã¦è©±ã—ã¦ããŸ
ç¬¬32å›ž PostgreSQL å‹‰å¼·ä¼š(2015å¹´10æœˆ10æ—¥)ã§ç™»å£‡ã—ã¦ãã¾ã—ãŸã€‚ å†…å®¹ã¯å‰ã«æ›¸ã„ãŸã‚¨ãƒ³ãƒˆãƒªãƒ¼ã® MySQLä½¿ã„ãŒçŸ¥ã‚‹ã¹ãPostgreSQLã¨ã®é•ã„ã¨å¤‰ã‚ã‚‰ãªã„ä¸€ã¤ã®ã“ã¨ MySQLä½¿ã„ã®äººãŒPostgreSQLã‚’å§‹ã‚ã‚‹ã¨ãã®ç½ ã‚’ã¾ã¨ã‚ã¦ã¿ãŸ ã‚’å…ƒã«ç™ºè¡¨ã—ã¦ãã¾ã—ãŸã€‚ ã¨è¨€ã£ã¦ã‚‚ä»Šå›žã¯å‚åŠ è€…ãŒPostgresSQLã«è©³ã—ã„å‰æã ã£ãŸã®ã§MySQLã‚’ä¸å¿ƒã«è©±ã‚’ã—ã¾ã—ãŸã€‚ å®Ÿéš›ã®è³‡æ–™ã¯ä¸‹è¨˜ã®ã¨ãŠã‚Šã§ã™ã€‚ å½“æ—¥ã¯ãƒ“ãƒ‡ã‚ªæ’®å½±ãŒã‚ã£ãŸã®ã§ãã®ã†ã¡å‹•ç”»ãŒä¸ŠãŒã‚‹ã¨æ€ã„ã¾ã™ã€‚ ç¬¬32å›ž PostgreSQL å‹‰å¼·ä¼šã¾ã¨ã‚ ~ togetter ~ æµçŸ³ã«ï¼’æ™‚é–“ã¯ç–²ã‚Œã¾ã—ãŸã€‚ å†…å®¹ã¨ã—ã¦ã¯çœ ããªã‚‰ãªã„ã‚ˆã†ã«é¢ç™½ãŠã‹ã—ãä¼ãˆã‚ˆã†ã¨æ€ã£ãŸã®ã§ã™ãŒãªã‹ãªã‹é›£ã—ã‹ã£ãŸã§ã™ã€‚ å‰åŠã¯MySQLã¨PostgreSQLã®æ–¹å‘æ€§ã®é•ã„ã‚’ãƒ¡ã‚¤ãƒ³ã«ã—ã¾ã—ãŸã€‚ å¾ŒåŠã¯MySQLã¯åƒ•ãŒå®Ÿéš›ã«ãƒãƒžã£ãŸäº‹ãªã©ã‚’ãƒ¡ã‚¤
ZAORIKU 2015/10/13
PostgreSQL

SQL

db

@

è³‡æ–™

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
Entity-Attribute-Value: SQL ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ - ãƒšãƒ³ã‚®ãƒ³ãƒ©ãƒœ Wiki
Bill Karwin â€œSQL Antipatterns: Avoiding the Pitfalls of Database Programmingâ€ ã®èªæ›¸ãƒ¡ãƒ¢ã€‚ Jaywalking ç›®çš„ ã‚ã‚‹å±žæ€§ã«ã¤ã„ã¦ã€è¤‡æ•°ã®å€¤ã‚’æŒãŸã›ã‚‹ã€‚ ã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³ : ã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šãƒªã‚¹ãƒˆ ã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šã§è¤‡æ•°ã®å€¤ã‚’ 1 ã¤ã®åˆ—ã«ç´ã‚ã‚‹ã€‚ ä¾‹ã§ã¯ã€ç‰¹å®šã®è£½å“ã«ã¤ã„ã¦ã®æ‹…å½“è€…ã‚’è¤‡æ•°è¨å®šã™ã‚‹ã®ã«ã‚«ãƒ³ãƒžåŒºåˆ‡ã‚Šã§ã€æ‹…å½“è€…ã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆIDã‚’è¨˜è¿°ã—ã¦ã„ã‚‹ã€‚ create table products ( product_id integer, product_name varchar(1000), acount_id varchar(100), -- comma separated list -- ... ); insert into products (product_id, product_name, accou
ZAORIKU 2014/03/06
SQL

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

è¨è¨ˆ

è³‡æ–™
ãƒªãƒ³ã‚¯
PHPã§ã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ãƒ¡ãƒ³ãƒã‚’SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ ¼ç´ã™ã‚‹å ´åˆã«ã€è¤‡æ•°ã®ArrayList ã¯ã©ã†ã™ã‚‹ã®ãŒã„ã„ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿâ€¦
PHPã§ã€ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã®ãƒ¡ãƒ³ãƒã‚’SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ ¼ç´ã™ã‚‹å ´åˆã«ã€è¤‡æ•°ã®ArrayList ã¯ã©ã†ã™ã‚‹ã®ãŒã„ã„ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ PEAR ã«è©²å½“ã™ã‚‹ã‚¯ãƒ©ã‚¹ãªã©ã‚ã‚‹ã§ã—ã‚‡ã†ã‹ï¼Ÿã€€ä¸‹è¨˜ã®XMLã§ã®ArrayListãƒ¡ãƒ³ãƒã®æ°¸ç¶šåŒ–ã‚’ã—ãŸã„ã¨ã‚¤ãƒ¡ãƒ¼ã‚¸ã—ã¦ã‚‚ã‚‰ãˆã‚‹ã¨ç†è§£ã—ã‚„ã™ã„ã‹ã¨æ€ã„ã¾ã™ã€‚ http://www.microsoft.com/japan/msdn/thisweek/step7/XML_Persistence/PersistenceOfObject.aspx
ZAORIKU 2014/02/17
php

SQL
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ ï¼† ã‚¢ãƒŠãƒªãƒ†ã‚£ã‚¯ã‚¹ | ã‚¢ã‚¯ã‚»ãƒ³ãƒãƒ¥ã‚¢
ãƒ‡ãƒ¼ã‚¿åˆ†æžã‹ã‚‰å°Žãå‡ºã•ã‚ŒãŸã‚¤ãƒ³ã‚µã‚¤ãƒˆç„¡ã—ã«AIï¼ˆäººå·¥çŸ¥èƒ½ï¼‰ã®æ´»ç”¨ã¯å§‹ã¾ã‚Šã¾ã›ã‚“ã€‚ç§ãŸã¡ã¯ã€å„æ¥ç•ŒçŸ¥è˜ã¨ãƒ‡ãƒ¼ã‚¿ãƒ»ã‚¢ãƒŠãƒªãƒ†ã‚£ã‚¯ã‚¹æŠ€è¡“ã‚’é§†ä½¿ã—ãƒ‡ãƒ¼ã‚¿ãƒ‰ãƒªãƒ–ãƒ³çµŒå–¶ã‚’å¼·åŠ›ã«æ”¯æ´ã—ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã€ã‚¢ãƒŠãƒªãƒ†ã‚£ã‚¯ã‚¹ã€AIã¯ä¼æ¥ã«ã¨ã£ã¦ç«¶åˆä»–ç¤¾ã¨ã®å·®åˆ¥åŒ–ã‚’å›³ã‚‹ã‹ã¤ã¦ãªã„ã»ã©å¤§ããªè¦å› ã«ãªã£ã¦ã„ã¾ã™ã€‚ä»Šæ—¥ã®çµŒå–¶å¹¹éƒ¨ãŒåŠ¹çŽ‡ã‚’å‘ä¸Šã—ãªãŒã‚‰æ–°ãŸãªåŽç›Šæºã‚’é–‹æ‹“ã—ã€æ–°ã—ã„ãƒ“ã‚¸ãƒã‚¹ãƒ¢ãƒ‡ãƒ«ã‚’ã‚¿ã‚¤ãƒ ãƒªãƒ¼ã«æ§‹ç¯‰ã™ã‚‹æ–¹æ³•ã‚’æ¨¡ç´¢ã™ã‚‹ä¸ã€ä¾¡å€¤ã‚’ç”Ÿã¿å‡ºã—æˆé•·ã‚’ç¶šã‘ã‚‹ä¼æ¥ã«ã¯ã€Œãƒ‡ãƒ¼ã‚¿æ´»ç”¨ã€ã¨ã„ã†å…±é€šé …ãŒã‚ã‚Šã¾ã™ã€‚ç§ãŸã¡ã¯ã€ç„¡æ•°ã®ãƒ‡ãƒ¼ã‚¿ã‹ã‚‰ä¼æ¥ã«ã¨ã£ã¦æœ¬å½“ã«å¿…è¦ãªãƒ‡ãƒ¼ã‚¿ã‚’æ´»ç”¨ã™ã‚‹ãŸã‚ã®æ–¹æ³•ã‚’çŸ¥ã£ã¦ã„ã¾ã™ã€‚ å°†æ¥ã‚’è¦‹æ®ãˆãŸã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ä½“åˆ¶ã‚’å‚™ãˆã¦ã„ã‚‹ä¼æ¥ã®åŠæ•°ä»¥ä¸Šï¼ˆ52ï¼…ï¼‰ã¯ã€ã™ã§ã«ãƒ‡ãƒ¼ã‚¿ã¨ã‚¢ãƒŠãƒªãƒ†ã‚£ã‚¯ã‚¹ã‚’å¤§è¦æ¨¡ã«æ´»ç”¨ã—ã¦ã„ã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ã¨AIã«é–¢ã™ã‚‹å–ã‚Šçµ„ã¿ã‚’ãƒ“ã‚¸ãƒã‚¹æˆ¦ç•¥ã«æ²¿ã£ã¦å®Ÿæ–½ã™ã‚‹ã“ã¨ã§æŠ•è³‡åˆ©ç›ŠçŽ‡ã‚’è¿…é€Ÿã«æœ€å¤§åŒ–ã—ã€æœ€çµ‚çš„ã«ã¯AIã‚’ãƒ“
ZAORIKU 2013/11/09
SQL
ãƒªãƒ³ã‚¯
æ¤œç´¢åŠ¹çŽ‡ã‚’å‘ä¸Šã•ã›ã‚‹æ–°ãŸãªæ©Ÿèƒ½ã€€â€•â€•é¡žä¼¼ãƒ‡ãƒ¼ã‚¿æŠ½å‡ºã€ç©ºé–“ã€é–¢æ•°
ã¯ã˜ã‚ã« SQL Serverã‚’ä½¿ç”¨ã—ãŸã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’ã‚ˆã‚Šç°¡æ½”ã«ã€å¿…è¦ã¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’å®¹æ˜“ã«å–å¾—ã§ãã‚‹ã‚ˆã†ã«æ”¹å–„ãŒã•ã‚Œã¦ã„ã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿é–“ã®é¡žä¼¼æ€§ãƒ»é–¢é€£æ€§ã‚’èª¿ã¹ãŸã„ã¨ãã«ã¯ã€çµ±è¨ˆçš„ã‚»ãƒžãƒ³ãƒ†ã‚£ãƒƒã‚¯æ¤œç´¢ã‚’ä½¿ç”¨ã™ã‚‹ã¨ã€çµ±è¨ˆçš„ã«ä½œæˆã•ã‚ŒãŸã‚ãƒ¼ãƒ•ãƒ¬ãƒ¼ã‚ºã®é‡ã¿ã¥ã‘ã‹ã‚‰é¡žä¼¼ãƒ»é–¢é€£ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’æŠ½å‡ºã§ãã¾ã™ã€‚æ–°ãŸã«è¿½åŠ ã•ã‚ŒãŸé–¢æ•°ã‚’ä½¿ç”¨ã™ã‚Œã°ã€ã‚¯ã‚¨ãƒªã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’ç°¡æ½”ã«ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ä»Šå›žã¯ã€ã‚¯ã‚¨ãƒªã‚’æ›¸ãéš›ã®åŠ¹çŽ‡åŒ–ã€å®¹æ˜“æ€§å‘ä¸Šã‚’å®Ÿç¾ã—ãŸã€Œçµ±è¨ˆçš„ã‚»ãƒžãƒ³ãƒ†ã‚£ãƒƒã‚¯æ¤œç´¢ã€ã¨ã€Œç©ºé–“ã€ã€ã€Œ14å€‹ã®é–¢æ•°ã€ã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã™ã€‚ å¯¾è±¡èªè€… SQL Serverã‚’ä½¿ç”¨ã™ã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è¨è¨ˆã€é–‹ç™ºè€… SQL Serverãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†è€… SQL Server 2012ã®æ–°æ©Ÿèƒ½ã«èˆˆå‘³ã®ã‚ã‚‹æ–¹ é¡žä¼¼ãƒ»é–¢é€£ã—ãŸå€¤ã‚’æŠ½å‡ºã™ã‚‹çµ±è¨ˆçš„ã‚»ãƒžãƒ³ãƒ†ã‚£ãƒƒã‚¯æ¤œç´¢ çµ±è¨ˆçš„ã‚»ãƒžãƒ³ãƒ†ã‚£ãƒƒã‚¯æ¤œç´¢ã¯ã€æ–‡ç« ã‚’å½¢æ…‹ç´ è§£æžã‚’å®Ÿæ–½ã—ã€å˜èªžãƒ»ã‚ãƒ¼ãƒ•ãƒ¬ãƒ¼ã‚ºã‚’æŠ½å‡ºã—
ZAORIKU 2012/08/01
SQL

ã‚»ãƒžãƒ³ãƒ†ã‚£ãƒƒã‚¯

æ¤œç´¢
ãƒªãƒ³ã‚¯
ã‚°ãƒ¼ã‚°ãƒ«ã€BigQueryã‚’æ£å¼å…¬é–‹ã€‚SQLã§å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã¦é«˜é€Ÿå‡¦ç†
BigQueryã¯ã‚«ãƒ©ãƒ åž‹ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã®ä¸€ç¨®ã§ã€ãƒ†ãƒ©ãƒã‚¤ãƒˆã‚¯ãƒ©ã‚¹ã®å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã¦å¤§é‡ã®ä¸¦åˆ—å‡¦ç†ã‚’è¡Œã†ã“ã¨ã§é«˜é€Ÿã«çµæžœã‚’å¾—ã‚‹ã“ã¨ãŒå¯èƒ½ã€‚ã‚°ãƒ¼ã‚°ãƒ« ä½è—¤ä¸€æ†²æ°ã®ç™ºè¨€ã«ã‚ˆã‚‹ã¨ã€ OLAP/DWH/Data Miningã§è¡Œã‚ã‚Œã‚‹ã‚ˆã†ãªread onlyã®ad hocã‚¯ã‚¨ãƒªã‚’ãã‚ã‚ã¦é«˜é€Ÿï¼ˆæ•°ç§’ã€œæ•°åç§’ï¼‰ã«å®Ÿè¡Œã—ã¾ã™ã€‚ ã¨ã®ã“ã¨ã€‚ SQLã«ã‚ˆã‚‹å•ã„åˆã‚ã›ãŒå¯èƒ½ ã“ã®é«˜é€Ÿæ€§ã«åŠ ãˆã€BigQueryã§ã¯SQLã‚’å•ã„åˆã‚ã›è¨€èªžã«ä½¿ãˆã‚‹ã¨ã„ã†ç‚¹ã«ã‚‚å¤§ããªç‰¹å¾´ãŒã‚ã‚Šã¾ã™ã€‚æ•°ç§’ç¨‹åº¦ã®ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã¨SQLæ–‡ã«ã‚ˆã‚‹è¨˜è¿°ã¯ã€å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã™ã‚‹ã‚¢ãƒ‰ãƒ›ãƒƒã‚¯ãªå‡¦ç†ã‚’è¡Œã†ã®ã«é©ã—ãŸã‚µãƒ¼ãƒ“ã‚¹ã ã¨ã„ãˆã‚‹ã§ã—ã‚‡ã†ã€‚ BigQueryã®SQLã®æ§‹æ–‡ã¯ã€ŒQuery Referenceã€ã§è§£èª¬ã•ã‚Œã¦ã„ã¾ã™ãŒã€SELECTæ–‡ã«FROMã€WHEREã€JOINã€HAVINGã€GROUP BYã€ORDER BYã€LIMITãªã©ãŒä½¿ãˆã‚‹ãŸã‚
ZAORIKU 2012/05/07
DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

BigQuery

google

SQL
ãƒªãƒ³ã‚¯
ã‚¦ãƒŽã‚¦ãƒ©ãƒœ Unoh Labs: ãƒ–ãƒ©ã‚¦ã‚¶ã§ERå›³ãŒæã‘ã‚‹ã€ŒWWW SQL Designerã€ç´¹ä»‹
GT Nitro: Car Game Drag Raceã¯ã€å…¸åž‹çš„ãªã‚«ãƒ¼ã‚²ãƒ¼ãƒ ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã‚Œã¯ã‚¹ãƒ”ãƒ¼ãƒ‰ã€ãƒ‘ãƒ¯ãƒ¼ã€ã‚¹ã‚ãƒ«å…¨é–‹ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚ãƒ–ãƒ¬ãƒ¼ã‚ã¯å¿˜ã‚Œã¦ã€ã“ã‚Œã¯ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã€ãƒ™ã‚¤ãƒ“ãƒ¼ï¼å¤å…¸çš„ãªã‚¯ãƒ©ã‚·ãƒƒã‚¯ã‹ã‚‰æœªæ¥çš„ãªãƒ“ãƒ¼ã‚¹ãƒˆã¾ã§ã€æœ€ã‚‚ã‚¯ãƒ¼ãƒ«ã§é€Ÿã„è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã§ãã¾ã™ã€‚ã‚¹ãƒ†ã‚£ãƒƒã‚¯ã‚·ãƒ•ãƒˆã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã€ãƒ‹ãƒˆãƒã‚’è³¢ãä½¿ã£ã¦ç«¶äº‰ã‚’æ‰“ã¡ç ´ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã“ã®ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã¯ãã®ãƒªã‚¢ãƒ«ãªç‰©ç†å¦ã¨ç´ æ™´ã‚‰ã—ã„ã‚°ãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚¹ã§ã‚ãªãŸã®å¿ƒã‚’çˆ†ç™ºã•ã›ã¾ã™ã€‚ã“ã‚Œã¾ã§ãƒ—ãƒ¬ã‚¤ã—ãŸã“ã¨ã®ãªã„ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ GT Nitroã¯ã€ãƒªãƒ•ãƒ¬ãƒƒã‚¯ã‚¹ã¨ã‚¿ã‚¤ãƒŸãƒ³ã‚°ã‚’è©¦ã™ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã‚²ãƒ¼ãƒ ã§ã™ã€‚æ£ã—ã„çž¬é–“ã«ã‚®ã‚¢ã‚’ã‚·ãƒ•ãƒˆã—ã€ã‚¬ã‚¹ã‚’æ€ã„åˆ‡ã‚Šè¸ã‚€å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã¾ãŸã€å¤§ç‰©ãŸã¡ã¨ç«¶ã„ã¤ã¤ã€è»Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã¨ã‚¢ãƒƒãƒ—ã‚°ãƒ¬ãƒ¼ãƒ‰ã‚‚è¡Œã‚ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ä¸–ç•Œä¸ã§æœ€é«˜ã®ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ã¨è»Šã¨ã‚«ãƒ¼ãƒ¬ãƒ¼ã‚¹ã«æŒ‘ã‚€ã“ã¨ã«ãªã‚Šã€ãƒ‰ãƒ©ãƒƒã‚°ãƒ¬ãƒ¼ã‚¹ã®çŽ‹å†
ZAORIKU 2007/10/06
tool

sql

MySQL
ãƒªãƒ³ã‚¯
å‹•çš„SQLã«ã‚ˆã‚‹æ•°ç‹¬ã®è¶…é«˜é€Ÿè§£æ³•ï¼šCodeZine
Pinskiã•ã‚“ã®è¨˜äº‹ã¯ã€ã€ŒSQLã§æ•°ç‹¬ã‚’è§£ã‘ã‚‹ã€ã“ã¨ã‚’ç¤ºã—ãŸã¨ã„ã†ç‚¹ã§è©•ä¾¡ã§ãã¾ã™ã€‚ã—ã‹ã—ãªãŒã‚‰ã€ãã®ãŸã‚ã®ã‚³ãƒ¼ãƒ‰ã¨å®Ÿè¡Œæ™‚é–“ãŒå…±ã«é•·å¤§ã§ã‚ã‚‹ãŸã‚ã€ã€ŒSQLã¯é¢å€’ã§é…ã„ã€ã¨ã„ã†èª¤è§£ã‚’èªè€…ã«ä¸Žãˆã‹ãã¾ã›ã‚“ã€‚æœ¬ç¨¿ã§ç´¹ä»‹ã™ã‚‹æ–¹æ³•ã§ã€èª¤è§£ãŒæ‰•æ‹ã•ã‚Œã‚‹ã“ã¨ã‚’æœŸå¾…ã—ã¾ã™ã€‚ã€€ç¬¬1ã€2éƒ¨ã¨ç¬¬3éƒ¨ã®æ‰‹æ³•ã‚’ç°¡å˜ã«ã¾ã¨ã‚ã¦ãŠãã¾ã—ã‚‡ã†ã€‚ã€€ç¬¬1ã€2éƒ¨ã§ã¯ã€æ‰‹ç¶šãçš„ãªè¨˜è¿°ã€ã¤ã¾ã‚Šã€ã©ã†ã™ã‚Œã°æ•°ç‹¬ã®è§£ãŒå¾—ã‚‰ã‚Œã‚‹ã‹ã®å…·ä½“çš„ãªè¨˜è¿°ã«ã‚ˆã£ã¦æ•°ç‹¬ã‚’è§£ã„ã¦ã„ã¾ã™ã€‚æ‰‹ç¶šãçš„ã¨ã¯è¨€ã£ã¦ã‚‚ã€ã›ã£ã‹ãå®£è¨€åž‹è¨€èªžã§ã‚ã‚‹SQLã‚’ä½¿ã†ã®ã§ã€æ‰‹é †ã®å„ã‚¹ãƒ†ãƒƒãƒ—ã¯ãªã‚‹ã¹ãå®£è¨€çš„ã«è¨˜è¿°ã™ã‚‹ã‚ˆã†ã«å¿ƒãŒã‘ã¦ã„ã¾ã™ã€‚ã€€ç¬¬3éƒ¨ï¼ˆæœ¬ç¨¿ï¼‰ã®æ–¹æ³•ã®æœ¬è³ªã¯ãŸã£ãŸ1è¡Œã®SELECTæ–‡ã§ã™ã€‚ã“ã®SELECTæ–‡ã«ã¯ã€Œæ•°ç‹¬ã®è§£ã¨ã¯ã©ã†ã„ã†ã‚‚ã®ã‹ã€ã ã‘ãŒè¨˜è¿°ã—ã¦ã‚ã‚Šã€ãã®è§£ã‚’å¾—ã‚‹ãŸã‚ã®å…·ä½“çš„ãªæ–¹æ³•ã¯ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ã‚¿ãŒè€ƒãˆã¾ã™ã€‚ãŸã ã—ã€ã“ã®SELECTæ–‡ã¯äººé–“ãŒæ‰‹ã§ç°¡å˜ã«æ›¸ã‘ã‚‹ã‚ˆ
ZAORIKU 2007/09/23
SQL

æ•°ç‹¬

puzzle
ãƒªãƒ³ã‚¯
1