[B! RDB] InoHiroã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

InoHiro id:InoHiro

RDBã«é–¢ã™ã‚‹InoHiroã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

Dockerã§ã‚µã‚¯ãƒƒã¨DBã‹ã‚‰ERå›³ã‚’ä½œæˆã™ã‚‹ - Qiita
SchemaSpyã¨ã„ã†DBã®ã‚¹ã‚ãƒ¼ãƒžã‚’è§£æžã—ã¦ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸€è¦§ã‚„ERå›³ã‚’å‡ºåŠ›ã—ã¦ãã‚Œã‚‹ãƒ„ãƒ¼ãƒ«ãŒã‚ã‚Šã¾ã™ã€‚ ã“ã®ãƒ„ãƒ¼ãƒ«ã®å…¬å¼Dockerã‚¤ãƒ¡ãƒ¼ã‚¸ãŒå…¬é–‹ã•ã‚Œã¦ãŠã‚Šã€éžå¸¸ã«ä½¿ã„ã‚„ã™ã„ã®ã§ç´¹ä»‹ã•ã›ã¦é ‚ãã¾ã™ã€‚ https://hub.docker.com/r/schemaspy/schemaspy/ ã‚³ãƒžãƒ³ãƒ‰ docker run -v "$PWD/schema:/output" --net="host" schemaspy/schemaspy:snapshot \ -t <DBç¨®é¡ž> -host <DB ãƒ›ã‚¹ãƒˆå/IP>:<ãƒãƒ¼ãƒˆ> -db <DBå> -u <DBãƒ¦ãƒ¼ã‚¶ãƒ¼å> -p <DBãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰> ã“ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã™ã‚‹ã¨ã‚«ãƒ¬ãƒ³ãƒˆãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã®schemaãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«è§£æžçµæžœã®HTMLãŒå‡ºåŠ›ã•ã‚Œã¾ã™ã€‚ ï¼ˆã‚³ãƒ³ãƒ†ãƒŠã¯è‡ªå‹•çš„ã«çµ‚äº†ã—ã¾ã™ï¼‰ docker run ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ -vã‚ªãƒ—ã‚·ãƒ§ãƒ³ã§æŒ‡
InoHiro 2017/07/30
Docker

RDB
ãƒªãƒ³ã‚¯
State of SQL Antipatterns in 2017
2017/07/10 SQLã‚¢ãƒ³ãƒãƒ‘ã‚¿ãƒ¼ãƒ³Night Part2 https://connpass.com/event/59946/
InoHiro 2017/07/12
sql

RDB
ãƒªãƒ³ã‚¯
ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã®å¤å…¸çš„è«–æ–‡ A Critique of ANSI SQL Isolation Levels ã‚’èªã‚€ - Hatena Developer Blog
ã“ã‚“ã«ã¡ã¯ã€ id:alpicola ã§ã™ã€‚ä»Šå¹´4æœˆã«æ–°å’å…¥ç¤¾ã—ã¦ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¨ã—ã¦åƒã„ã¦ã„ã¾ã™ã€‚ ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯ãã®æ€§è³ªä¸Šã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã—ã¦åŒæ™‚ã«å¤§é‡ã®å•ã„åˆã‚ã›ã‚’è¡Œã„ã¾ã™ã€‚ãã†ã—ãŸä¸ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒå€‹ã€…ã®å•ã„åˆã‚ã›ã‚’å‡¦ç†ã—ã¦ã„ãã¨ãã«èµ·ã“ã£ã¦ã„ã‚‹ã“ã¨ã¯ä½•ã‹ã€ã©ã†ã„ã†é †åºã§å‡¦ç†ãŒè¡Œã‚ã‚Œã‚‹ã®ã‹ã€ã¨ã„ã†ã®ã¯èˆˆå‘³æ·±ã„è©±é¡Œã‹ã¨æ€ã„ã¾ã™ã€‚ä¾‹ãˆã°ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã—ã¦è¡Œã£ãŸæ›´æ–°å‡¦ç†ã®çµæžœãŒã€æ›´æ–°ã‚’è¡Œã£ãŸã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆä»¥å¤–ã®ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰ã‚‚ã€Œè¦‹ãˆã‚‹ã€ã‚ˆã†ã«ãªã‚‹ã®ã¯ã„ã¤ã§ã—ã‚‡ã†ã‹ã€‚å…¥ç¤¾é–“ã‚‚ãªã„é ƒã€å…ˆè¼©ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢é”ã«ãã†ã—ãŸç–‘å•ã‚’ã¶ã¤ã‘ã¦ã¿ãŸã¨ã“ã‚ã€ã€Œãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³åˆ†é›¢ãƒ¬ãƒ™ãƒ«ã€ã¨ã„ã†ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã¨ã€ã“ã®åˆ†é‡Žã®å¤å…¸çš„ãªè«–æ–‡ A Critique of ANSI SQL Isolation Levels ã‚’æ•™ãˆã¦ã‚‚ã‚‰ã„ã€è¼ªèªä¼šã‚’ç¤¾å†…ã§é–‹å‚¬ã—ã¾ã—ãŸã€‚ã“ã®è¨˜äº‹ã§ã¯ã“ã®è¼ªèªä¼šã®æ¨¡æ§˜ã‚’ãƒ¬ãƒãƒ¼
InoHiro 2017/06/22
RDB
ãƒªãƒ³ã‚¯
GitHub - rxin/db-readings: Readings in Databases
The Five-Minute Rule Ten Years Later, and Other Computer Storage Rules of Thumb (1997): This paper (and the original one proposed 10 years earlier) illustrates a quantitative formula to calculate whether a data page should be cached in memory or not. It is a delight to read Jim Gray approach to an array of related probl ems, e.g. how big should a page size be. AlphaSort: A Cache-Sensitive Parallel
InoHiro 2016/07/30
RDB

research
ãƒªãƒ³ã‚¯
ã‚¤ãƒ«ã‚«ã•ã‚“ãƒãƒ¼ãƒ ã‹ã‚‰ã‚¾ã‚¦ã•ã‚“ãƒãƒ¼ãƒ ã«æ•™ãˆãŸã„MySQLãƒ¬ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³
7. MySQL 5.7 2013/04 MySQL 5.7.1 DMR11 2015/03 MySQL 5.7.6 DMR16 2015/04 MySQL 5.7.7 RC 2015/08 MySQL 5.7.8 RC 2015/10 MySQL 5.7.9 GA 2015/12 MySQL 5.7.10 GA 2016/02 MySQL 5.7.11 GA 6/133 8. MySQL 5.7 2015/04 MySQL 5.7.7 RC ã“ã“ã¾ã§ã¯ã¾ã‚ã„ã„ 2015/08 MySQL 5.7.8 RC JSONåž‹, virtual generated columnã®æ‹¡å¼µ, InnoDB Page Compression 2015/10 MySQL 5.7.9 GA innodb_default_row_format, JSON -> operator, innodb_numa_int
InoHiro 2016/05/16
mysql

RDB

replication
ãƒªãƒ³ã‚¯
åˆ—æŒ‡å‘ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ - Wikipedia
é€šå¸¸ã®DBMSã‚·ã‚¹ãƒ†ãƒ ã¯ã²ã¨ã¤ã®è¡Œã‚’æ§‹æˆã™ã‚‹åˆ—ãƒ‡ãƒ¼ã‚¿ã‚’ã²ã¨ã¾ã¨ã¾ã‚Šã¨ã—ã¦æ ¼ç´ã™ã‚‹ã€‚ã“ã‚Œã«å¯¾ã—åˆ—æŒ‡å‘DBMSã§ã¯ã€åˆ—ã®å€¤ã‚’ã¾ã¨ã‚ã¦ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ä¸Šã®è¿‘ã„å ´æ‰€ã«ï¼ˆã‚ã‚‹ã„ã¯ã²ã¨ã¾ã¨ã¾ã‚Šã®è«–ç†æ§‹é€ ã¨ã—ã¦ï¼‰ç½®ãã¨ã„ã†ã‚¢ãƒ—ãƒãƒ¼ãƒãŒã‚ã‚‹ã€‚ è¡ŒæŒ‡å‘ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨åˆ—æŒ‡å‘ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ¯”è¼ƒã™ã‚‹éš›ã«ã¯ã€ä¸Žãˆã‚‰ã‚ŒãŸå‡¦ç†ã‚’è¡Œã†ãŸã‚ã®ãƒãƒ¼ãƒ‰ãƒ‡ã‚£ã‚¹ã‚¯ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã®åŠ¹çŽ‡æ€§ã«ç€ç›®ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚å‡¦ç†æ™‚é–“ã®ä¸ã§ãƒ‡ã‚£ã‚¹ã‚¯ã®ã‚·ãƒ¼ã‚¯æ™‚é–“ã¯å¤§ããªå‰²åˆã‚’å ã‚ã‚‹ä¸Šã€CPUã®è¨ˆç®—åŠ›ã®å‘ä¸Šã«å¯¾ã—ã¦ã€ã‚·ãƒ¼ã‚¯æ™‚é–“ã¯ç·©ã‚„ã‹ãªãƒšãƒ¼ã‚¹ã§ã—ã‹æ”¹å–„ã•ã‚Œãªã„ã€‚ä»¥ä¸‹ã«ã€ãƒ‡ãƒ¼ã‚¿ã‚’è¡ŒæŒ‡å‘ã¾ãŸã¯åˆ—æŒ‡å‘ã§é…ç½®ã™ã‚‹å ´åˆã®ãƒˆãƒ¬ãƒ¼ãƒ‰ã‚ªãƒ•ã‚’æŒ™ã’ã‚‹ã€‚ åˆ—æŒ‡å‘ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€å¤§é‡ã®è¡Œã«å¯¾ã™ã‚‹å°‘æ•°ã®åˆ—ã®é›†ç´„å‡¦ç†ãŒåŠ¹çŽ‡çš„ã§ã‚ã‚‹ã€‚åˆ—æ•°ãŒå°‘ãªã„ã»ã©ã€èªã¿è¾¼ã‚€ãƒ‡ãƒ¼ã‚¿é‡ã‚’æ¸›ã‚‰ã™ã“ã¨ãŒã§ãã‚‹ã€‚ åˆ—æŒ‡å‘ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯ã€å…¨è¡Œã«å¯¾ã™ã‚‹å°‘æ•°ã®åˆ—ã®ä¸€æ‹¬æ›´æ–°ãŒåŠ¹çŽ‡çš„ã§ã‚ã‚‹ã€‚æ–°è¦ã«åˆ—ãƒ‡ãƒ¼ã‚¿ã‚’ä½œæˆã—ã€ä»¥å‰
InoHiro 2016/04/24
wikipedia

RDB

columnar
ãƒªãƒ³ã‚¯
DataGrip: The Cross-Platform IDE for Databases & SQL by JetBrains
A powerful IDE from JetBrains for SQL on macOS, Windows, and Linux.
InoHiro 2015/11/17
IDE

SQL
ãƒªãƒ³ã‚¯
ãƒ“ãƒ¥ãƒ¼ - ã‚†ã¨ã‚Šä¸–ä»£ã®DBè€ƒå¯Ÿ
ã‚†ã¨ã‚Šä¸–ä»£ã®DBè€ƒå¯Ÿ ãƒˆãƒƒãƒ—ãƒšãƒ¼ã‚¸ãƒšãƒ¼ã‚¸ä¸€è¦§ãƒ¡ãƒ³ãƒãƒ¼ç·¨é›† ãƒ“ãƒ¥ãƒ¼ æœ€çµ‚æ›´æ–°ï¼š yutoritaroÂ 2012å¹´02æœˆ21æ—¥(ç«) 16:03:10å±¥æ´ Tweet ã¨ã‚Šã‚ãˆãšå‰ç½®ã ã‚¯ã‚¨ãƒªãƒ¼(SELECTæ–‡)ã®çµæžœã¯å¸¸ã«è¡¨(ã®ã‚¤ãƒ¡ãƒ¼ã‚¸)ã§ã‚ã‚‹ã€ã¨ã„ã†ã“ã¨ã€‚ã“ã‚Œã¯è¤‡æ•°è¡Œã‚’è¿”ã™å ´åˆã ã‘ã§ãªãã€ 1è¡Œã ã‘ãŒè¿”ã‚‹ã‚¯ã‚¨ãƒªãƒ¼ã§ã¯ã€1è¡Œã ã‘ã‚ã‚‹è¡¨ãŒè¿”ã£ã¦æ¥ã¦ã„ã‚‹ 1ã¤ã®å€¤ã ã‘ãŒè¿”ã‚‹ã‚¯ã‚¨ãƒªãƒ¼ã§ã¯ã€1åˆ—Ã—1è¡Œã®è¡¨ãŒè¿”ã£ã¦æ¥ã¦ã„ã‚‹ ã¨è€ƒãˆã‚‹ ãŸã¨ãˆã°ã€ã‚µãƒ–ã‚¯ã‚¨ãƒªã®çµæžœã‚‚ã€Œè¡¨ã€ãªã®ã§ã€è¡¨ã¨è¡¨ã¨ã®JOINåŒæ§˜ã®selectæ–‡ã‚’æ›¸ãã“ã¨ãŒã§ãã‚‹ã€‚ â‰ªã‚µãƒ³ãƒ—ãƒ«ã‚¯ã‚¨ãƒªãƒ¼ï¼š ã‚µãƒ–ã‚¯ã‚¨ãƒªãƒ¼ã«MEM_JPNã¨ã„ã†åå‰ã‚’ã¤ã‘PREF_MSTã¨JOINã—ã¦ã„ã‚‹â‰« select * from (select * from MEMBER_MST where COUNTRY_CD = 'JPN') MEM_JPN left join
InoHiro 2015/08/28
RDB
ãƒªãƒ³ã‚¯
GitHub - ridgepole/ridgepole: Ridgepole is a tool to manage DB schema. It defines DB schema using Rails DSL, and updates DB schema according to DSL. (like Chef/Puppet)
Note ridgepole v3.0.0 Support Rails 8.0 (cf. #504) ridgepole v2.0.0 Support Trilogy (cf. #447) Support Rails 7.1 (cf. #441) Drop support AcriveRecord 6.0 (cf. #440) Drop support ActiveRecord 5.x in ridgepole v1.2.0. Partitioning is no longer supported in ridgepole v1.1.0. ActiveRecord 7.x has some incompatible changes. If you get unintended differences in datetime columns consider changing precisi
InoHiro 2015/08/03
RDB

ruby
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ã‚²ãƒ¼ãƒ DBã®ï¿½å±æ©Ÿå›žé¿
MySQL Casual Talks vol.7
InoHiro 2015/06/07
RDB
ãƒªãƒ³ã‚¯
æ–°è‘—ãŒå‡ºã¾ã™ï¼šã€ŽSQLå®Ÿè·µå…¥é–€ã€ - ãƒŸãƒƒã‚¯ã®ãƒ–ãƒã‚°
4æœˆä¸æ—¬ã“ã‚ã«ãªã‚Šã¾ã™ãŒã€æ–°è‘—ãŒå‡ºã¾ã™ã€‚SQLã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’ä¸»é¡Œã«ã—ãŸæœ¬ã§ã€å®Ÿè¡Œè¨ˆç”»ã‚’èªã‚€ã“ã¨ã§ã€ãªãœã“ã®SQLã¯é…ã„ã®ã‹ã€ã‚ã‚‹ã„ã¯é€Ÿã„ã®ã‹ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å†…éƒ¨å‹•ä½œã¾ã§æŠŠæ¡ã—ã¦ç†è§£ã—ã‚ˆã†ã€ã¨ã„ã†è¶£æ—¨ã§ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã„ã†ã®ã¯ã€SQLã¨ã„ã†è‡ªç„¶è¨€èªžã‚’æ¨¡ã—ãŸã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã«ã‚ˆã£ã¦ã€ä½Žæ¬¡ã®ãƒ¬ã‚¤ãƒ¤ãƒ¼ã‚’éš è”½ã™ã‚‹æ„å›³ã§ä½œã‚‰ã‚ŒãŸãƒŸãƒ‰ãƒ«ã‚¦ã‚§ã‚¢ãªã®ã§ã€æœ¬å½“ã¯å®Ÿè¡Œè¨ˆç”»ãªã©ã¨ã„ã†æ‰‹ç¶šãƒ¬ãƒ™ãƒ«ã®ä¸–ç•Œã‚’ãƒ¦ãƒ¼ã‚¶ãŒè¦—ãè¦‹ã‚‹ã®ã¯ã€æœ¬æœ«è»¢å€’ãªã¨ã“ã‚ã‚‚ã‚ã‚Šã¾ã™ã€‚ãŸã ãã†ã¯ã„ã£ã¦ã‚‚ã€ç¾å®Ÿã«SQLãŒé…ã‹ã£ãŸã‚‰åŽŸå› ã‚’è§£æžã›ã–ã‚‹ã‚’ãˆãªã„ã‚ã‘ã ã—ã€å¤§ä½“æœ¬å½“ã«ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã«ã—ãŸã„ãªã‚‰ã€ãªã‚“ã§ã©ã®DBMSã‚‚å®Ÿè¡Œè¨ˆç”»ã‚’è¦‹ã‚‰ã‚Œã‚‹æ‰‹æ®µãªã‚“ã‹ç”¨æ„ã—ã¦ã‚‹ã‚“ã§ã—ã‚‡ã†ãä¸æ€è°ã§ã™ãã€ã¨ã„ã†ç†æƒ³ã¨ç¾å®Ÿã®ç‹é–“ã§æ‚©ã‚€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®æ–¹ã€…ã«å°‘ã—ã§ã‚‚ãƒ™ã‚¿ãƒ¼ãªè§£ã«è¾¿ã‚Šã¤ã‘ã‚‹ã‚¢ãƒ—ãƒãƒ¼ãƒã‚’æç¤ºã§ãã‚Œã°ã€ã¨è€ƒãˆã¦ãŠã‚Šã¾ã™ã€‚ ä»¥ä¸‹ã¾ãˆãŒãã¨ç« ç«‹ã¦ã§ã™ã€‚
InoHiro 2015/03/29
è²·ã‚ãªãã‚ƒ

RDB

sql
ãƒªãƒ³ã‚¯
ï¼»é€Ÿå ±ï¼½ã€ŒGreenplum Databaseã€ãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã«ã€‚DWHå‘ã‘MPPãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€‚PivotalãŒç™ºè¡¨
Pivotalã¯2æœˆ17æ—¥ï¼ˆæ—¥æœ¬æ™‚é–“2æœˆ18æ—¥åˆå‰4æ™‚ï¼‰ã«ã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã‚¤ãƒ™ãƒ³ãƒˆã‚’é–‹å‚¬ã€‚åŒç¤¾ãŒæä¾›ã™ã‚‹ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿é–¢é€£ã®3ã¤ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€ŒGemFireã€ã€ŒHAWQã€ã€ŒGreenplum Databaseã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã«ã™ã‚‹ã¨ç™ºè¡¨ã—ã¾ã—ãŸã€‚ GemFireã¯ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€HAWQã¯Hadoopä¸Šã§SQLã®ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã§ãã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€‚ ã‚‚ã£ã¨ã‚‚æ³¨ç›®ã•ã‚Œã‚‹ã®ãŒGreenplum Databaseã§ã™ã€‚ã“ã‚Œã¯ã‚‚ã¨ã‚‚ã¨EMCãŒè²·åŽã—ãŸãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹å‘ã‘ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã€ãã®å¾ŒVMwareã‹ã‚‰ã‚¹ãƒ”ãƒ³ã‚¢ã‚¦ãƒˆã—ãŸPivotalã®ãƒ©ã‚¤ãƒ³ãƒŠãƒƒãƒ—ã«ç§»ç®¡ã•ã‚Œã¾ã—ãŸã€‚ Greenplum Databaseã¯å¤šæ•°ã®ãƒžã‚·ãƒ³ã«åˆ†æ•£ã•ã›ãŸãƒ‡ãƒ¼ã‚¿ã‚’ã‚·ã‚§ã‚¢ãƒ‰ãƒŠãƒƒã‚·ãƒ³ã‚°ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã«ã‚ˆã‚Šå¤§è¦æ¨¡ä¸¦åˆ—åˆ†æ•£å‡¦ç†ã™ã‚‹ã“ã¨ã§ã€ãƒšã‚¿ãƒã‚¤ãƒˆã‚¯ãƒ©ã‚¹ã«ã¾ã§ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆå¯èƒ½ãªé«˜æ€§èƒ½ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ Pivot
InoHiro 2015/02/18
RDB

Greenplum
ãƒªãƒ³ã‚¯
ãã®é¸æŠžã€ã¡ã‚‡ã£ã¨å¾…ã£ãŸï¼NoSQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ä¹—ã‚Šæ›ãˆã‚‹å‰ã«æ¤œè¨Žã™ã¹ã3ã¤ã®ãƒã‚¤ãƒ³ãƒˆ
æœ€è¿‘ã€ã©ã†ã‚‚å®‰æ˜“ã«ã€ŒNoSQLã«ã™ã‚Œã°åŽ„ä»‹ãªDBè¨è¨ˆã‹ã‚‰é–‹æ”¾ã•ã‚Œã‚‹ã€ã¨è€ƒãˆã¦ã„ã‚‹äººãŒå¤šã„ã‚ˆã†ã«æ€ãˆã¦ä»•æ–¹ãŒãªã„ã€‚ã ãŒå¾…ã£ã¦æ¬²ã—ã„ã€‚æœ¬å½“ã«NoSQLã¨å‘¼ã°ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ãˆã°ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é–‹ç™ºãƒ»é‹ç”¨ã®è‹¦ã—ã¿ã‹ã‚‰é€ƒã‚Œã‚‰ã‚Œã‚‹ã®ã ã‚ã†ã‹ã€‚ã‚‚ã¡ã‚ã‚“ã€Œãã‚“ãªã“ã¨ã¯ç„¡ã„ï¼ï¼çµ¶å¯¾ã«ã ï¼ï¼ã€ã¨ç§ã¯è€ƒãˆã‚‹ã€‚ä»Šæ—¥ã¯ãã®ç†ç”±ã«ã¤ã„ã¦èªžã‚ã†ã¨æ€ã†ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³å…ˆæ—¥ã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãŠã‘ã‚‹DBè¨è¨ˆã«ã¤ã„ã¦ã‚»ãƒŸãƒŠãƒ¼ã§è§£èª¬ã—ãŸã°ã‹ã‚Šã ãŒã€ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãŠã‘ã‚‹ãƒ‡ãƒ¼ã‚¿ã®æ•´åˆæ€§ã¯ä½•ã‚‚DBè¨è¨ˆã ã‘ãŒæ‹…ä¿ã—ã¦ã„ã‚‹ã‚ã‘ã§ã¯ãªã„ã€‚ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ¢ãƒ‡ãƒ«ã¨åŒã˜ã‹ãã‚Œä»¥ä¸Šã«æ¬ ã‹ã›ãªã„ã®ãŒãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã ã€‚ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ãŒã‚ã‚‹ãŠã‹ã’ã§ã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³çµ‚äº†å¾Œã®ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹ã¯ã€ŒæˆåŠŸã€ã‹ã€Œå¤±æ•—ã€ã®2ã¤ã—ã‹ãªã„ã¨ã„ã†ã“ã¨ãŒä¿è¨¼ã•ã‚Œã‚‹ã€‚ã™ãªã‚ã¡ã‚ªãƒ¼ãƒ«ãƒ»ã‚ªã‚¢ãƒ»ãƒŠãƒƒã‚·ãƒ³ã‚°ã ã€‚ã‚‚ã—ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®é€”ä¸ã§ä½•ã‚‰ã‹ã®
InoHiro 2013/12/01
nosql

RDB
ãƒªãƒ³ã‚¯
1