[B! olap] mogwaingã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

mogwaing id:mogwaing

olapã«é–¢ã™ã‚‹mogwaingã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ãªãƒ‡ãƒ¼ã‚¿åˆ†æžã‚’ã™ã‚‹åˆ†æ•£OLAPã€ŒPinotã€ã‚’LinkedInãŒã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹
LinkedInã¯ã€åŒç¤¾ãŒé–‹ç™ºã—ãŸãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ ãƒ‡ãƒ¼ã‚¿åˆ†æžã‚’å®Ÿç¾ã™ã‚‹åˆ†æ•£OLAPãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢ã€ŒPinotã€ã‚’ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã§å…¬é–‹ã—ãŸã“ã¨ã‚’æ˜Žã‚‰ã‹ã«ã—ã¾ã—ãŸã€‚ Open Sourcing Pinot: Scaling the Wall of Real-Time Analytics | LinkedIn Engineering LinkedInã¯ãƒ“ã‚¸ãƒã‚¹ã«ç‰¹åŒ–ã—ãŸã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ¡ãƒ‡ã‚£ã‚¢ã‚µãƒ¼ãƒ“ã‚¹ã€‚ åŒç¤¾ã¯ã“ã®ã‚µãƒ¼ãƒ“ã‚¹ã§ç™ºç”Ÿã™ã‚‹å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’åˆ†æžã™ã‚‹ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã¨ã—ã¦ã€ã™ã§ã«2å¹´ä»¥ä¸ŠPinotã‚’é‹ç”¨ã—ã¦ãã¦ãŠã‚Šã€æ—¥ã€…æ•°åå„„ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã‚’æŠ•å…¥ã—ã€æ•°åƒå„„ä»¶ã‚‚ã®ãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã€‚æ¯Žæ—¥1å„„ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã—ã€10ãƒŸãƒªç§’ç¨‹åº¦ã®ãƒ¬ã‚¤ãƒ†ãƒ³ã‚·ã§ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ åˆ†æžã—ã¦ã„ã‚‹ã¨ã®ã“ã¨ã€‚ ä¾‹ãˆã°ã€LinedInã®ã‚µãƒ¼ãƒ“ã‚¹ã§ã‚ã‚‹ã€ŒWho's Viewed Your Profileã€ï¼ˆã‚ãªãŸã®ãƒ—ãƒãƒ•ã‚£ãƒ¼ãƒ«ã‚’èª°ãŒè¦‹ãŸã‹ã€ã‚„ã€A/Bãƒ†ã‚¹ãƒˆãƒ•ãƒ¬
mogwaing 2015/06/18
database

distributed system

olap

parallel db
ãƒªãƒ³ã‚¯
3.3.3ã€€ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹
1960å¹´ä»¥é™ï¼Œæƒ…å ±å‡¦ç†ã‚·ã‚¹ãƒ†ãƒ ãŒä¼æ¥ã‚„çµ„ç¹”ã§æ´»ç”¨ã•ã‚Œå§‹ã‚ã¦ä»¥æ¥ï¼Œãã‚Œã‚‰ã®ä¼æ¥ã‚„çµ„ç¹”ã«ã¯è†¨å¤§ãªãƒ‡ãƒ¼ã‚¿ãŒè“„ç©ã•ã‚Œã¦ãŠã‚Šï¼Œãã®ãƒ‡ãƒ¼ã‚¿ã¯ç¾åœ¨ã‚‚å¢—ãˆç¶šã‘ã¦ã„ã‚‹ã€‚ã—ã‹ã—ï¼Œã‚¨ãƒ³ãƒ‰ãƒ¦ãƒ¼ã‚¶ã¯ï¼Œã“ã‚Œã‚‰ã®ãƒ‡ãƒ¼ã‚¿ã®ã†ã¡ã»ã‚“ã®ã‚ãšã‹ãªãƒ‡ãƒ¼ã‚¿ã—ã‹ï¼Œã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã„ãªã„ã—æ´»ç”¨ã‚‚ã—ã¦ã„ãªã„ã€‚æ—§å¼ãªãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§ä½œã‚‰ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã¯ï¼Œãã®ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãŸã‚ã®å°‚ç”¨ã®ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’æ›¸ã‹ãã°ãªã‚‰ãªã„ã—ï¼Œã¾ãŸï¼Œãƒ‡ãƒ¼ã‚¿ã®å˜åœ¨ã™ã‚‹å ´æ‰€ã¨ãã®å†…å®¹ã™ã‚‰çŸ¥ã‚‹ã“ã¨ãŒé›£ã—ã„ã€‚ ã€€æœ€è¿‘ï¼Œæƒ…å ±å‡¦ç†ã‚·ã‚¹ãƒ†ãƒ ã®æŠ€è¡“ã®é€²æ©ã¯ï¼Œãƒ‡ãƒ¼ã‚¿ã¨ãã‚Œã‚’å–ã‚Šæ‰±ã†ãƒ„ãƒ¼ãƒ«ã¨ã„ã†2ã¤ã®åˆ†é›¢ã•ã‚ŒãŸç’°å¢ƒã®å®Ÿç¾ã‚’å¯èƒ½ã«ã™ã‚‹ã‚ˆã†ã«ãªã£ã¦ããŸã€‚ã™ãªã‚ã¡ï¼Œã‚·ã‚¹ãƒ†ãƒ ã®ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã¨ã—ã¦ã‚ªãƒ¼ãƒ—ãƒ³ãªã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã‚’å‚™ãˆãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã¨ï¼Œã‚¨ãƒ³ãƒ‰ãƒ¦ãƒ¼ã‚¶ãŒç°¡å˜ã«ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¢ã‚¯ã‚»ã‚¹ã—ãŸã‚Šãƒ‡ãƒ¼ã‚¿ã‚’åŠ å·¥ã—ãŸã‚Šã™ã‚‹ã“ã¨ãŒã§ãã‚‹ãƒ•ãƒãƒ³ãƒˆãƒ„ãƒ¼ãƒ«ãŒæ•´å‚™ã•ã‚Œï¼Œã¾ãŸï¼Œãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã¨ãƒ•ãƒãƒ³ãƒˆãƒ„ãƒ¼ãƒ«ã®ä»²ä»‹ã®å½¹
mogwaing 2014/01/29
dwh

database

olap
ãƒªãƒ³ã‚¯
OctopusDB: Towards a One Size Fits All Database Architecture
mogwaing 2013/09/23
database

oltp

olap
ãƒªãƒ³ã‚¯
Apache MADlib
Apache MADlib: Big Data Machine Learning in SQL Open source, commercially friendly Apache license For PostgreSQL and Greenplum DatabaseÂ® Powerful machine learning, graph, statistics and analytics for data scientists Getting Started with Apache MADlib using Jupyter Notebooks We have created a library of Jupyter Notebooks to help you get started quickly with MADlib. It includes many commonly used al
mogwaing 2011/04/26
database

analysis

olap

greenplum

library
ãƒªãƒ³ã‚¯
Craig Utley - CIOBriefings
mogwaing 2009/04/20
database

olap

data warehouse

star schema
ãƒªãƒ³ã‚¯
http://www.databasecolumn.com/2008/07/understanding-the-difference-b.html
mogwaing 2009/03/24
database

column-store

olap
ãƒªãƒ³ã‚¯
1