[B! DB] titan22ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

titan22 id:titan22

DBã«é–¢ã™ã‚‹titan22ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (15)

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

Leo's Chronicle: XMLæ™‚ä»£ã®çµ‚ç„‰ ~ XMLã‹ã‚‰å†ã³Coddã¸
å…ˆæ—¥ã€ACM SIGMODã®æ—¥æœ¬æ”¯éƒ¨å¤§ä¼šã«æ‹›ã„ã¦ã„ãŸã ã„ã¦ã€ã€ŒRelational-Style XML Query (ACM PortalÂ http://doi.acm.org/10.1145/1376616.1376650)ã€ã«ã¤ã„ã¦è¬›æ¼”ã‚’ã—ã¦ãã¾ã—ãŸã€‚Relational-Style XML Queryã¯ã€XMLã¨ã„ã†è¤‡é›‘ãªæ§‹é€ ã‚’ã‚‚ã£ãŸãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã¦ã€SQLã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«ãƒ‡ãƒ¼ã‚¿ã¸ã®æ¤œç´¢ã«ä½¿ã‚ã‚Œã‚‹è¨€èªžã§å•ã„åˆã‚ã›ã™ã‚‹æ‰‹æ³•ã§ã™ã€‚ ã“ã®ç ”ç©¶ã®è‚ã¯ã€æœ¨æ§‹é€ ãƒ‡ãƒ¼ã‚¿ã¨ã„ã‚ã‚Œã‚‹XMLã§ã‚‚ã€å®Ÿã¯ãã®ã»ã¨ã‚“ã©ãŒãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³(Microsoft Excelã®ã‚ˆã†ãªãƒ†ãƒ¼ãƒ–ãƒ«å½¢å¼ã®ãƒ‡ãƒ¼ã‚¿ï¼‰ã®çµ„ã¿åˆã‚ã›ã¨è€ƒãˆã‚‹ã“ã¨ãŒã§ãã€ãã®ãƒ†ãƒ¼ãƒ–ãƒ«æ§‹é€ ã®æƒ…å ±ï¼ˆã‚¹ã‚ãƒ¼ãƒžï¼‰ã‚’ä½¿ã†ã¨ã€æ¤œç´¢ãŒéžå¸¸ã«ç°¡å˜ã«æ›¸ã‘ã‚‹ã¨ã„ã†ç‚¹ã§ã™ã€‚
titan22 2010/01/14
DB

*ã‚ã¨ã§èªã‚€

xml
ãƒªãƒ³ã‚¯
å¤§é‡ã®éžå®šåž‹ãƒ‡ãƒ¼ã‚¿ã‚’ç®¡ç†ã™ã‚‹ã®ã«é©ã—ãŸRDFãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ - TYZOH(ã‚¿ã‚¤ã‚¾ã‚¦)
ã“ã®è¡¨ã‚’å‡¦ç†ã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã¯ã€è£½å“ã®ç¨®åˆ¥ã‹ã‚‰ã€å¾Œè€…ã®è¡¨ã‚’å‚ç…§ã—ã¦ã€å‰è€…ã®è¡¨ã®ãã‚Œãžã‚Œã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã«ãŠã„ã¦ã€åˆ—ï¼‘ãŒä½•ã‚’è¡¨ã—ã¦ã„ã‚‹ã‹ã‚’çŸ¥ã‚‹ã“ã¨ãŒã§ãã¾ã™ãŒã€è¡¨ã®å®šç¾©ã‚’ã¿ãŸã ã‘ã§ã¯ã€å€‹ã€…ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã«ãŠã„ã¦ã€åˆ—1ã®å€¤ãŒä½•ã‚’è¡¨ã—ã¦ã„ã‚‹ã®ã‹çŸ¥ã‚‹ã™ã¹ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ ã¤ã¾ã‚Šå¿…ãšã—ã‚‚äºŒæ¬¡å…ƒã®è¡¨ã®å½¢ã«ãã‚Œã„ã«æ ¼ç´ã™ã‚‹ã“ã¨ã¯ã§ããªã„ãŒã€ãã‚Œã‚‰ã‚’ä¸€ã¾ã¨ã‚ã«ã—ã¦ç®¡ç†ã—ãŸã„ã‚ˆã†ãªå¯¾è±¡ï¼ˆãƒ‡ãƒ¼ã‚¿ï¼‰ãŒå°‘ãªã‹ã‚‰ãšå˜åœ¨ã™ã‚‹ã€‚ãã‚Œã‚’ç„¡ç†ã«äºŒæ¬¡å…ƒã®è¡¨ã®å½¢ã«æŠ¼ã—è¾¼ã‚€ã¨ã€ã©ã“ã‹ã«æªãŒç”Ÿã˜ã¦ã€é–‹ç™ºã€å®Ÿè¡Œã€é‹ç”¨ã«ä½™è¨ˆãªè² è·ãŒã‹ã‹ã‚‹ã€‚ã¾ãŸã€ãã®ãƒ‡ãƒ¼ã‚¿ãŒä½•ã‚’è¡¨ã—ã¦ã„ã‚‹ã®ã‹æ˜Žç¢ºã«ãªã£ã¦ã„ãªã‘ã‚Œã°ã€ãã®ãƒ‡ãƒ¼ã‚¿ã‚’æ´»ç”¨ã™ã‚‹ã“ã¨ã¯ã§ããªã„ã€‚ã¨ã„ã†ã“ã¨ã§ã™ã€‚ ã“ã®ã‚ˆã†ã«äºŒæ¬¡å…ƒã®è¡¨ã«ã¯ãŠã•ã¾ã‚‰ãªã„ã‘ã‚Œã©ã€ä½•ã‚‰ã‹ã®æ§‹é€ ã‚’æŒã£ãŸãƒ‡ãƒ¼ã‚¿ã‚’ã€ŒåŠæ§‹é€ åŒ–ãƒ‡ãƒ¼ã‚¿ã€ã¨å‘¼ã³ã¾ã™ã€‚ãƒ¦ãƒ“ã‚ã‚¿ã‚¹ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ãƒ†ã‚£ãƒ³ã‚°æ™‚ä»£ã«ãŠã„ã¦ã€ã‚»ãƒ³ã‚µãƒ¼ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã‚„ã€ãƒ¢ãƒã‚¤ãƒ«è£…ç½®ã¨ã„ã£ãŸãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹
titan22 2010/01/14
DB

åŠæ§‹é€

RDFDB
ãƒªãƒ³ã‚¯
çž¬æ™‚ã«ãƒ†ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã‚’å¤§é‡ç”Ÿæˆã—ã¦ãã‚Œã‚‹ã€ŽData Generatorã€ - IDEA*IDEA ï½ž ç™¾å¼ç®¡ç†äººã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚° ï½ž
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
titan22 2009/12/31
ä¾¿åˆ©

xml

ãƒ†ã‚¹ãƒˆ

db

*ã¨ã‚Šã‚ãˆãš
ãƒªãƒ³ã‚¯
Hive - HADOOP2 - Apache Software Foundation
The Apache Hive wiki has moved to Confluence! If you're looking for a particular page name, try this list. (There's also a generated HTML version of the Confluence content. Please keep this link here so that search engine crawlers can find it; they're blocked from the live Confluence content by a robots.txt file, and we want them to find the HTML anyway to reduce load on Confluence.)
titan22 2009/12/01
Hadoop

hive

documents

DB

mapreduce

wiki
ãƒªãƒ³ã‚¯
Hatena ID
Hatena ID is an account used for various Hatena services.
titan22 2009/12/01
DB

Hadoop

hive

å…¬å¼
ãƒªãƒ³ã‚¯
Hadoopï¼‹Hiveæ¤œè¨¼ç’°å¢ƒã‚’æ§‹ç¯‰ã—ã¦ã¿ã‚‹
Hadoopï¼‹Hiveæ¤œè¨¼ç’°å¢ƒã‚’æ§‹ç¯‰ã—ã¦ã¿ã‚‹ï¼šHiveâ€•â€•RDBä½¿ã„ã®ãŸã‚ã®Hadoopã‚¬ã‚¤ãƒ‰ï¼ˆå‰ç·¨ï¼‰ï¼ˆ1/3 ãƒšãƒ¼ã‚¸ï¼‰ Hadoop Hiveã¯Hadoopä¸Šã§SQLãƒ©ã‚¤ã‚¯ãªã‚¯ã‚¨ãƒªæ“ä½œãŒå¯èƒ½ãªDWHå‘ã‘ã®ãƒ—ãƒãƒ€ã‚¯ãƒˆã§ã™ã€‚SQLã«è¿‘ã„æ“ä½œãŒå¯èƒ½ãªãŸã‚ã€HBaseã‚ˆã‚Šã‚‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ…£ã‚Œè¦ªã—ã‚“ã ã¿ãªã•ã‚“ã«ã¯ä½¿ã„å‹æ‰‹ãŒã„ã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚æœ¬ç¨¿ã§ã¯ã“ã®Hiveã®ä½¿ã„æ–¹ã¨ãƒ¬ãƒ“ãƒ¥ãƒ¼ã‚’è¡Œã£ã¦ã„ãã¾ã™ã€‚
titan22 2009/12/01
Hadoop

db

hive
ãƒªãƒ³ã‚¯
ã€åˆç´šã€‘æ–°äººSEã®ãŸã‚ã®SQLã®åŸºç¤Žã€€ç¬¬3å›žï¼ˆå¾ŒåŠï¼‰ã€€é›†ç´„é–¢æ•°ï¼ŒGROUP BYå¥ï¼ŒHAVINGå¥ã®æ³¨æ„ç‚¹
å›³6â—HAVINGå¥ã®åˆ©ç”¨ä¸Šã®æ³¨æ„ç‚¹<BR>HAVINGå¥ã¯WHEREå¥ã§ç½®ãæ›ãˆã‚‹ã“ã¨ãŒã§ãã‚‹å ´åˆãŒã‚ã‚‹ã€‚å›³ã¯ï¼ŒåŒã˜çµæžœã‚’æ¤œç´¢ã™ã‚‹HAVINGå¥ã‚’åˆ©ç”¨ã—ãŸSELECTæ–‡ï¼ˆï¼ˆ1ï¼‰ï¼‰ã¨ï¼ŒHAVINGå¥ã‚’ä½¿ã‚ãªã„ã§WHEREå¥ã‚’åˆ©ç”¨ã—ãŸSELECTæ–‡ï¼ˆï¼ˆ2ï¼‰ï¼‰ã®ä¾‹ã§ã‚ã‚‹ã€‚åŒã˜çµæžœã‚’æ¤œç´¢ã™ã‚‹ãŒï¼Œå®Ÿè¡Œæ€§èƒ½ã¯(2)WHEREå¥ã‚’åˆ©ç”¨ã—ãŸSELECTæ–‡ã®æ–¹ãŒé«˜ã„ã€‚WHEREå¥ã‚’ä½¿ã£ãŸå ´åˆã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹æ¤œç´¢ã§ã‚ã‚‹ãŒï¼ŒHAVINGå¥ã‚’ä½¿ã£ãŸå ´åˆã¯å…¨ä»¶æ¤œç´¢ã«ãªã‚‹ RDBMSã«ã¯ï¼Œæ•°å€¤ã‚«ãƒ©ãƒ ã®åˆè¨ˆå€¤è¨ˆç®—ï¼ˆSUMï¼‰ã‚„å¹³å‡å€¤è¨ˆç®—ï¼ˆAVGï¼‰ã‚’è¡Œã†é›†ç´„é–¢æ•°ãŒç”¨æ„ã•ã‚Œã¦ã„ã‚‹ã€‚ä¾‹ãˆã°å›³3[æ‹¡å¤§è¡¨ç¤º]ã®è²©å£²ãƒ†ãƒ¼ãƒ–ãƒ«ã«ãŠã„ã¦ã€Œå€¤å¼•ãã€ã®åˆè¨ˆå€¤ã‚’æ±‚ã‚ã‚‹å ´åˆï¼Œ SELECT SUM(NEBIKI) FROM HANBAI_TBL ; ã¨ã™ã‚‹ã¨ï¼ŒNEBIKIï¼ˆå€¤å¼•ãï¼‰ã®åˆè¨ˆé‡‘é¡ã‚’æ±‚ã‚ã‚‹ã“ã¨ãŒã§ãã‚‹ï¼ˆå›³3(1)ï¼‰ã€‚åˆè¨ˆå€¤ã‚„å¹³å‡å€¤ã®ã»
titan22 2009/11/18
sql

DB

group-by
ãƒªãƒ³ã‚¯
SQL ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚° - 1Keydata SQLå…¥é–€
SQL > SQL ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚° ã“ã®ãƒšãƒ¼ã‚¸ã«ã¯ã€æœ¬ã‚µã‚¤ãƒˆã«æŽ²è¼‰ã—ãŸSQL ã‚³ãƒžãƒ³ãƒ‰ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ãŒã€ã™ã¹ã¦ç¤ºã•ã‚Œã¦ã„ã¾ã™ã€‚è©³ãã¯ã€ãã®ã‚³ãƒžãƒ³ãƒ‰åã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦ãã ã•ã„ã€‚ ã“ã®ãƒšãƒ¼ã‚¸ã¯ã€ç°¡å˜ã§åˆ†ã‹ã‚Šã‚„ã™ã„SQL ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚’å‚è€ƒã¨ã—ã¦ã€èªè€…ãŸã¡ã«æä¾›ã™ã‚‹ã‚‚ã®ã€‚ä»Šã™ãã€ Control-D ã‚’æŠ¼ã—ã¦ã€ã“ã®ãƒšãƒ¼ã‚¸ã‚’ [ç§ã®ãŠæ°—ã«å…¥ã‚Š]ã«åŠ å…¥ã—ã¾ã—ã‚‡ã†ã€‚ Select SELECT "ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å" FROM "ãƒ†ãƒ¼ãƒ–ãƒ«å"; Distinct SELECT DISTINCT "ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å" FROM "ãƒ†ãƒ¼ãƒ–ãƒ«å"; Where SELECT "ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å" FROM "ãƒ†ãƒ¼ãƒ–ãƒ«å" WHERE "æ¡ä»¶"; And/Or SELECT "ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å" FROM "ãƒ†ãƒ¼ãƒ–ãƒ«å" WHERE "ç°¡å˜æ¡ä»¶" {[AND|OR] "ç°¡å˜æ¡ä»¶"}+; In SELECT "ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰å"
titan22 2009/11/16
sql

ã¾ã¨ã‚

DB
ãƒªãƒ³ã‚¯
https://www.dbsj.org/index.html
titan22 2009/11/12
å¦ä¼š

DB

è«–æ–‡
ãƒªãƒ³ã‚¯
PostgreSQLæ—¥æœ¬èªžãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ
PostgreSQLæ—¥æœ¬èªžãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ æœ€æ–°ç‰ˆã®ä»˜å±žãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆ ç¿»è¨³ä½œæ¥ä¸ã®æœ€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³/PostgreSQL 17.x æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« ãƒãƒ¼ã‚¸ãƒ§ãƒ³16 PostgreSQL16æœ€æ–°ç‰ˆ æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« PostgreSQL16.4 æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« PostgreSQL16.3 æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« PostgreSQL16.0 æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« ãƒãƒ¼ã‚¸ãƒ§ãƒ³15 PostgreSQL15æœ€æ–°ç‰ˆ æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« PostgreSQL15.4 æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« PostgreSQL15.3 æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« PostgreSQL15.0 æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« ãƒãƒ¼ã‚¸ãƒ§ãƒ³14 PostgreSQL14æœ€æ–°ç‰ˆ æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« PostgreSQL14.5 æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« PostgreSQL14.0 æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« ãƒãƒ¼ã‚¸ãƒ§ãƒ³13 PostgreSQL13æœ€æ–°ç‰ˆ æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ« Post
titan22 2009/11/12
postgresql

document

ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹

æ—¥æœ¬èªž

DB

sql
ãƒªãƒ³ã‚¯
SQLã‚¢ã‚¿ãƒžã‚¢ã‚«ãƒ‡ãƒŸãƒ¼ è¨˜äº‹ä¸€è¦§ | gihyo.jp
æœ€çµ‚å›žã€€OLAPé–¢æ•°ã§å¼·åŠ›ãªçµ±è¨ˆå‡¦ç†ã‚’å®Ÿç¾ï¼â€•æ‰‹ç¶šãåž‹ã‹ã‚‰ç†è§£ã™ã‚‹SQLã€€ï¼ˆ5ï¼‰é›†åˆæŒ‡å‘ã¨æ‰‹ç¶šãåž‹ ãƒŸãƒƒã‚¯ 2010-05-28 æœ€çµ‚å›žã€€OLAPé–¢æ•°ã§å¼·åŠ›ãªçµ±è¨ˆå‡¦ç†ã‚’å®Ÿç¾ï¼â€•æ‰‹ç¶šãåž‹ã‹ã‚‰ç†è§£ã™ã‚‹SQLã€€ï¼ˆ4ï¼‰OLAPé–¢æ•°ã¨é›†ç´„é–¢æ•°ã‚’çµ„ã¿åˆã‚ã›ã‚‹ ãƒŸãƒƒã‚¯ 2010-05-27
titan22 2009/11/11
sql

db

Programming

é€£è¼‰

tips
ãƒªãƒ³ã‚¯
è¿½è£œ: SQLãƒ‡ãƒ¼ã‚¿åž‹ã®ä¸€è¦§ | Netsphere Laboratories
åŸºæœ¬çš„ãªãƒ‡ãƒ¼ã‚¿åž‹ã¨ãã®ä½¿ã„æ–¹ã«ã¤ã„ã¦ã¯ã€p.45ã‹ã‚‰p.48ã‚’ã”è¦§ãã ã•ã„ã€‚ *1 ã¯SQL99ã§æ¨™æº–åŒ–ã•ã‚ŒãŸã‚‚ã®ã§ã™ã€‚[ ] ã¯çœç•¥å¯èƒ½ã§ã™ã€‚ (2017.8.24) æ›´æ–°ã€‚ æœ€æ–°ã®æ¨™æº–SQL ã¯ ISO/IEC 9075-2:2011 SQL/Foundation (JIS X 3005-2:2015). ä¸€ã¤å‰ãŒ ISO/IEC 9075-2:2008 (JIS X 3005-2:2010). äº‹å‰å®šç¾©ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿åž‹ (çµ„è¾¼ã¿ãƒ‡ãƒ¼ã‚¿åž‹) æ–‡å—åˆ—åž‹ (character string type), é•·å¤§ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãƒ‡ãƒ¼ã‚¿åˆ—åž‹ã‚ã‚Š. 2é€²ã‚ªã‚¯ãƒ†ãƒƒãƒˆåˆ— (binary string) åž‹, é•·å¤§ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãƒ‡ãƒ¼ã‚¿åˆ—åž‹ã‚ã‚Š. æ•°åž‹ çœŸæ•°åž‹ æ¦‚æ•°åž‹ - FLOAT, REAL, DOUBLE PRECISION ãƒ–ãƒ¼ãƒ«åž‹ æ—¥æ™‚åž‹ãŠã‚ˆã³æ™‚é–“éš”åž‹ æ™‚åˆ»åž‹ DATE æ™‚é–“éš”åž‹ æ§‹æˆåž‹ (constr
titan22 2009/11/10
sql

mysql

postgresql

ãƒ‡ãƒ¼ã‚¿åž‹

ã¾ã¨ã‚

db
ãƒªãƒ³ã‚¯
ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
titan22 2009/11/02
sql

db

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
é–¢ä¿‚ä»£æ•° - Wikipedia
é–¢ä¿‚ä»£æ•° (ã‹ã‚“ã‘ã„ã ã„ã™ã†) é–¢ä¿‚ä»£æ•° (é–¢ä¿‚ãƒ¢ãƒ‡ãƒ«) (relational algebra, ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ä»£æ•°) - é–¢ä¿‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ (ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹) ã«ãŠã‘ã‚‹é–¢ä¿‚ãƒ¢ãƒ‡ãƒ« (ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«) ã®ä»£æ•°çš„æ¼”ç®—ã®ä½“ç³» é–¢ä¿‚ä»£æ•° (æ•°å¦) (relation algebra) - äºŒé …é–¢ä¿‚ã©ã†ã—ã®æ¼”ç®—ã‚’ãƒ¢ãƒ‡ãƒ«ã¨ã™ã‚‹ä»£æ•°æ§‹é€ ã“ã®ãƒšãƒ¼ã‚¸ã¯æ›–æ˜§ã•å›žé¿ã®ãŸã‚ã®ãƒšãƒ¼ã‚¸ã§ã™ã€‚ä¸€ã¤ã®èªžå¥ãŒè¤‡æ•°ã®æ„å‘³ãƒ»è·èƒ½ã‚’æœ‰ã™ã‚‹å ´åˆã®æ°´å…ˆæ¡ˆå†…ã®ãŸã‚ã«ã€ç•°ãªã‚‹ç”¨æ³•ã‚’ä¸€è¦§ã«ã—ã¦ã‚ã‚Šã¾ã™ã€‚ãŠæŽ¢ã—ã®ç”¨èªžã«ä¸€ç•ªè¿‘ã„è¨˜äº‹ã‚’é¸ã‚“ã§ä¸‹ã•ã„ã€‚ã“ã®ãƒšãƒ¼ã‚¸ã¸ãƒªãƒ³ã‚¯ã—ã¦ã„ã‚‹ãƒšãƒ¼ã‚¸ã‚’è¦‹ã¤ã‘ãŸã‚‰ã€ãƒªãƒ³ã‚¯ã‚’é©åˆ‡ãªé …ç›®ã«å¼µã‚Šæ›¿ãˆã¦ä¸‹ã•ã„ã€‚
titan22 2009/10/23
db

wikipedia
ãƒªãƒ³ã‚¯
MySQLã®å°æŠ€
This domain may be for sale!
titan22 2009/06/03
mysql

db

Programming
ãƒªãƒ³ã‚¯
1