[B! database] teddy-gã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

teddy-g id:teddy-g

databaseã«é–¢ã™ã‚‹teddy-gã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (32)

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

[DataBase]ã§è¡Œã†æ£è¦åŒ–ã®æ‰‹é †ã«ã¤ã„ã¦ã‚ã‹ã‚Šã‚„ã™ãè§£èª¬ã—ã¾ã™ï¼ - ãƒªã‚¯ãƒã‚¬ãƒ¼
teddy-g 2022/02/28
åˆå¿ƒè€…ã«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ£è¦åŒ–ã‚’æ•™ãˆã‚‹ã¨ãã®å‚è€ƒã«ã€‚ã¾ã‚ã€ä¸€èˆ¬ã®ãƒ“ã‚¸ãƒã‚¹ãƒžãƒ³ãŒã©ã“ã¾ã§çŸ¥ã£ã¦ãŠãå¿…è¦ãŒã‚ã‚‹ã®ã‹ã¨ã„ã†è©±ã¯ã‚ã‚‹ã‘ã©ã€‚å‚™å¿˜ã€‚

database

basic

beginner
ãƒªãƒ³ã‚¯
Consumer Complaint Database | Consumer Financial Protection Bureau
teddy-g 2018/02/18
Consumer Complaint Databaseãªã‚“ã¦ã‚‚ã®ãŒã‚¢ãƒ¡ãƒªã‚«ã§ã¯å…¬é–‹ã•ã‚Œã¦ã‚‹

data

database
ãƒªãƒ³ã‚¯
BBC DatasetsÂ -Â Machine Learning Group (UCD)
Two news article datasets, originating from BBC News, provided for use as benchmarks for machine learning research. These datasets are made available for non-commercial and research purposes only. If you make use of these datasets please consider citing the publication: D. Greene and P. Cunningham. "Practical Solutions to the Probl em of Diagonal Dominance in Kernel Document Clustering", Proc. ICML
teddy-g 2016/02/25
BBCã®ãƒ‹ãƒ¥ãƒ¼ã‚¹è¨˜äº‹ã¨ã‹ç„¡å„Ÿã§æä¾›ã—ã¦ã‚‹ã‚„ã¤ã€‚ã‚µãƒ³ãƒ—ãƒ«åˆ¶ä½œç”¨ã«ã€‚

bigdata

database

opendata
ãƒªãƒ³ã‚¯
Treasure Dataã®ã‚µãƒ¼ãƒ“ã‚¹ã¯ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã§ã©ã†æ§‹ç¯‰ã•ã‚Œã¦ã„ã‚‹ã®ã‹ï¼ˆå¾Œç·¨ï¼‰ï½žJuly Tech Festa 2013
Treasure Dataã®ã‚µãƒ¼ãƒ“ã‚¹ã¯ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã§ã©ã†æ§‹ç¯‰ã•ã‚Œã¦ã„ã‚‹ã®ã‹ï¼ˆå¾Œç·¨ï¼‰ï½žJuly Tech Festa 2013 Treasure Dataã¨ã„ãˆã°ã€æ—¥æœ¬äººãŒã‚·ãƒªã‚³ãƒ³ãƒãƒ¬ãƒ¼ã§å‰µæ¥ã—ãŸãƒ™ãƒ³ãƒãƒ£ãƒ¼ã¨ã—ã¦çŸ¥ã‚‰ã‚Œã¦ã„ã‚‹ä¼æ¥ã€‚ãã®ã‚·ãƒ‹ã‚¢ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ä¸å·çœŸå®æ°ãŒã€7æœˆ14æ—¥ã«è¡Œã‚ã‚ŒãŸJuly Tech Festa 2013ã®åŸºèª¿è¬›æ¼”ã§ã€åŒç¤¾ãŒã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã§æ§‹ç¯‰ã—ãŸã‚µãƒ¼ãƒ“ã‚¹ã«ã¤ã„ã¦ãã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ã‚’ä¸å¿ƒã«è§£èª¬ã‚’è¡Œã£ã¦ã„ã¾ã™ã€‚ ã“ã®è¨˜äº‹ã¯ã€ŒTreasure Dataã®ã‚µãƒ¼ãƒ“ã‚¹ã¯ã‚¯ãƒ©ã‚¦ãƒ‰ä¸Šã§ã©ã†æ§‹ç¯‰ã•ã‚Œã¦ã„ã‚‹ã®ã‹ï¼ˆå‰ç·¨ï¼‰ï½žJapan Tech Festa 2013ã€ã®ç¶šãã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ã‚’è§£æžã™ã‚‹ã€ŒPlazmaã€ã®ä»•çµ„ã¿ ãƒ‡ãƒ¼ã‚¿ã‚’è§£æžã™ã‚‹ã¨ã“ã‚ã§ã¯ã€ŒPlazmaã€ã¨å‘¼ã¶ã€Hadoopã®ã‚¨ã‚³ã‚·ã‚¹ãƒ†ãƒ ã¨ã‚«ãƒ©ãƒ ã‚¹ãƒˆã‚¢ãªã©ã‚’çµ„ã¿åˆã‚ã›ãŸã‚‚ã®ã‚’ç”¨ã„ã¦ã„ã¾ã™ã€‚
teddy-g 2016/01/06
Treasure Dataã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å´ã€Plazmaã®ã‹ã‚‹ãƒ¼ã„èª¬æ˜Žã€‚

database

hadoop

cloud

storage
ãƒªãƒ³ã‚¯
Plazma - Treasure Dataâ€™s distributed analytical database -
This document summarizes Plazma, Treasure Data's distributed analytical database that can import 40 billion records per day. It discusses how Plazma reliably imports and processes large volumes of data through its scala ble architecture with real-time and archive storage. Data is imported using Fluentd and processed using its column-oriented, schema-on-read design to enable fast queries. The docume
teddy-g 2015/12/31
Treasure Dataã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã‚ã‚‹Plazmaã®è§£èª¬ã€‚PostgreSQLãŒMySQLã‚ˆã‚Šé€Ÿã„ã¨ã‹ãã†ãªã‚“ã ã€‚

database

fluentd

hadoop
ãƒªãƒ³ã‚¯
æ—¥ä»˜ãƒ»æ™‚åˆ»é–¢æ•°ï½œMySQLå†…éƒ¨é–¢æ•°ï½œMySQLï½œPHP & JavaScript Room
æ—¥ä»˜å½¢å¼ã¾ãŸã¯æ—¥ä»˜æ™‚åˆ»å½¢å¼ã§æŒ‡å®šã—ãŸæ—¥ä»˜dateã®æ›œæ—¥ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ï¼ˆ1=æ—¥ã€2=æœˆã€3=ç«ã€4=æ°´ã€5=æœ¨ã€6=é‡‘ã€7=åœŸï¼‰ã‚’è¿”ã—ã¾ã™ã€‚ å˜åœ¨ã—ãªã„æ—¥ä»˜ã‚„æ—¥ä»˜æ™‚åˆ»ã‚’æŒ‡å®šã—ãŸå ´åˆã¯ã€NULLãŒè¿”ã‚Šã¾ã™ã€‚ mysql> SELECT DAYOFWEEK('2006-12-25'); Enter +-------------------------+ | dayofweek('2006-12-25') | +-------------------------+ | 2 | +-------------------------+ 1 row in set (0.00 sec) mysql> SELECT DAYOFWEEK('2006-12-25 23:50:00'); Enter +----------------------------------+ | dayofweek('2006-12-
teddy-g 2015/12/03
WEEKDAYã¨ã‹HOURã¨ã‹MySQLã®æ—¥ä»˜ãƒ»æ™‚åˆ»é–¢æ•°ä¸€è¦§ã€‚çµæ§‹è‰²ã€…ã‚ã‚‹ã€‚

mysql

database

sql
ãƒªãƒ³ã‚¯
CASEå¼ã®ã‚¹ã‚¹ãƒ¡ / ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
teddy-g 2015/12/02
case selectä½¿ã†ã¨sqlã§çµæ§‹å‡¦ç†ãŒå®Œäº†ã™ã‚‹ã€‚ãƒžã‚¨ã‚·ãƒ§ãƒªã‚¹ãƒˆã«ã¯å¿…é ˆã€‚

database

sql

mysql
ãƒªãƒ³ã‚¯
13.1. csv â€” CSV File Reading and Writing â€” Python 2.7.18 documentation
This document is for an old version of Python that is no longer supported. You should upgrade and read the Python documentation for the current stable release. The so-called CSV (Comma Separated Values) format is the most common import and export format for spreadsheets and databases. There is no â€œCSV standardâ€, so the format is operationally defined by the many applications which read and write i
teddy-g 2015/09/25
Pythonã§CSVãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã„ã˜ã‚‹ã¨ãã¯csvãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã€‚è¶…åŸºæœ¬ã€‚ãã—ã¦ä¾¿åˆ©ã€‚

python

programming

tips

hacks

database

data
ãƒªãƒ³ã‚¯
ã‚‚ã†1ã¤ã®ã€DBã®ã‹ãŸã¡ã€åˆ†æ•£Key-Valueã‚¹ãƒˆã‚¢ã¨ã¯
åˆ†æ•£KVSãŒè‹¦æ‰‹ãªãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®ã€ŒACIDç‰¹æ€§ã€ RDBã®ã‚ˆã†ã«ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã¨ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’çµåˆï¼ˆSQLã§ã„ã†JOINæ–‡ï¼‰ã—ã¦è¤‡é›‘ãªæ¡ä»¶æ¤œç´¢ã‚„é›†è¨ˆå‡¦ç†ã‚’ä¸€ç™ºã§ã“ãªã™ã‚ˆã†ãªèŠ¸å½“ã¯ã§ãã¾ã›ã‚“ã€‚ã¾ãŸã€ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã«ã‚ˆã‚‹ã€ŒACIDç‰¹æ€§ã€ã®ç¢ºä¿ã‚‚åˆ†æ•£KVSãŒè‹¦æ‰‹ãªåˆ†é‡Žã§ã™ã€‚ RDBãŒä¸å¾—æ„ãªåˆ†æ•£ï¼æ‹¡å¼µ ãã®ãŸã‚ã€ã“ã‚Œã‚‰ã®ä¸è¶³ã‚’ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³å´ã§è£œã†ãŸã‚ã®ã•ã¾ã–ã¾ãªå·¥å¤«ã‚„ãƒ•ã‚©ãƒãƒ¼ãŒå¿…è¦ã¨ãªã‚Šã¾ã™ã€‚ãã®ä¸€æ–¹ã§ã€åˆ†æ•£KVSã¯ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆã‚¢å…¨ä½“ã‚’ã„ãã‚‰ã§ã‚‚å¤šãã®ã‚µãƒ¼ãƒã«åˆ†æ•£ï¼ˆã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆï¼‰ã§ãã‚‹ã®ãŒæœ€å¤§ã®ç‰¹å¾´ã§ã™ã€‚ ä¸€æ–¹ã§ã“ã‚Œã¯ã€RDBãŒæœ€ã‚‚ä¸å¾—æ„ã¨ã™ã‚‹ã¨ã“ã‚ã§ã™ã€‚RDBã§ã¯ã€ãã®é•·æ‰€ã§ã‚ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«çµåˆã‚„ACIDã®ç¢ºä¿ãŒãƒœãƒˆãƒ«ãƒãƒƒã‚¯ã¨ãªã‚Šã€è¤‡æ•°ã®ã‚µãƒ¼ãƒã«ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã•ã›ã‚‹ã“ã¨ãŒã€ŒåŽŸç†çš„ã€ã«å®¹æ˜“ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ãã®ãŸã‚ã€è² è·åˆ†æ•£ã‚„é«˜å¯ç”¨æ€§ã‚’ä½Žã‚³ã‚¹ãƒˆã§å®Ÿç¾ã™ã‚‹ã“ã¨ãŒå›°é›£ã§ã™ã€‚ RDBã§è² è·åˆ†æ•£ã•ã›ã‚ˆã†ã¨ã™
teddy-g 2015/07/06
RDBã¯åˆ†æ•£ãŒè‹¦æ‰‹ã¨ã€‚KVSã€æœ€åˆã¯ã„ã„ãªã¨æ€ã£ãŸãŒã€ã‚¯ã‚¨ãƒªã‚’è€ƒãˆã‚‹ã¨ã‚„ã£ã±ã‚ŠRDBâ€¦ã¨ã„ã†æ°—åˆ†ã«ãªã£ã¦ã—ã¾ã†ã€‚

bigdata

database

rdb

kvs
ãƒªãƒ³ã‚¯
Wavelet Tree - naoyaã®ã¯ã¦ãªãƒ€ã‚¤ã‚¢ãƒªãƒ¼
åœ§ç¸®å…¨æ–‡ç´¢å¼•ã®å®Ÿè£…ãªã©ã§ã—ã°ã—ã°åˆ©ç”¨ã•ã‚Œã‚‹ Rank/Select è¾žæ›¸ã¨å‘¼ã°ã‚Œã‚‹ãƒ‡ãƒ¼ã‚¿æ§‹é€ ãŒã‚ã‚Šã¾ã™ã€‚è©³ã—ãã¯å‚è€ƒæ–‡çŒ®ã‚’å‚ç…§ã—ã¦ã„ãŸã ãã¨ã—ã¦ã€ä»Šå›žã¯ä¸€èˆ¬ã®æ–‡å—åˆ—ã«å¯¾ã—ã¦åŠ¹çŽ‡çš„ã« Rank/Select ã‚’å¯èƒ½ã¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã§ã‚ã‚‹ Wavelet Tree (ã‚¦ã‚§ãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆæœ¨) ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ä½œã‚Šã¾ã—ãŸã€‚ http://github.com/naoya/perl-algorithm-wavelettree/tree/master my $wt = Algorithm::WaveletTree->new("abccbbabca"); is $wt->rank(6, 'a'), 2; is $wt->rank(6, 'b'), 3; is $wt->rank(9, 'b'), 4; is $wt->select(0, 'a'), 0; is $wt->select(1, 'a'), 6;
teddy-g 2014/12/15
ã‚¦ã‚§ãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆæœ¨ã®PERLå®Ÿè£…

bigdata

bitvector

data

database
ãƒªãƒ³ã‚¯
é«˜é€Ÿã‹ã¤çœãƒ¡ãƒ¢ãƒªã§æ–‡å—åˆ—ã‚’æ‰±ã†ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã€Œwavelet treeã€
ã¯ã˜ã‚ã« å¤§è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¯ã€é€Ÿåº¦ã¨ã¨ã‚‚ã«ä½œæ¥é ˜åŸŸé‡ã‚‚å¤§ããªå•é¡Œã¨ãªã‚Šã¾ã™ã€‚ä½œæ¥é ˜åŸŸãŒãƒ¡ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªã«åŽã¾ã‚‰ãªã„å ´åˆã€ã‚¹ãƒ¯ãƒƒãƒ”ãƒ³ã‚°ãŒç™ºç”Ÿã—ã€å¤§å¹…ãªé€Ÿåº¦ä½Žä¸‹ã«ã¤ãªãŒã‚Šã¾ã™ã€‚ãã®ãŸã‚è¿‘å¹´ã€ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã¯é«˜é€Ÿãªã ã‘ã§ãªãã€ä½œæ¥é ˜åŸŸé‡ãŒå°ã•ã„ã“ã¨ã‚‚æ±‚ã‚ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚ä»Šå›žç´¹ä»‹ã™ã‚‹ã®ã¯2003å¹´ã«ææ¡ˆã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿æ§‹é€ ã€wavelet treeï¼ˆä»¥ä¸‹ã€ŒWTã€ã¨è¡¨è¨˜ï¼‰ã§ã™ã€‚WTã¯åœ§ç¸®ç´¢å¼•ã‚„Succinct Data Structureãªã©ã€ãƒ‡ãƒ¼ã‚¿ã‚’ã‚³ãƒ³ãƒ‘ã‚¯ãƒˆã«è¡¨ç¾ã™ã‚‹éš›ã«é‡è¦ãªãƒ‡ãƒ¼ã‚¿æ§‹é€ ã§ã™ã€‚WTã¯æ–‡å—åˆ—T[0...n-1]ãŒä¸Žãˆã‚‰ã‚ŒãŸæ™‚ã€æ¬¡ã®2ã¤ã®æ“ä½œã‚’å®šæ•°æ™‚é–“ã§ã‚µãƒãƒ¼ãƒˆã—ã¾ã™ã€‚ rank(p, c)â€•â€•T[0...p]ä¸ã®cã®å‡ºç¾å›žæ•°ã‚’è¿”ã™ select(i, c)â€•â€•(i+1)ç•ªç›®ã®cã®ä½ç½®ã‚’è¿”ã™ WTã®ä½œæ¥é ˜åŸŸé‡ã¯ã€æ–‡å—åˆ—ã‚’ãã®ã¾ã¾ä¿å˜ã—ãŸæ™‚ã®ç´„2å€ç¨‹åº¦ã§ã™ã€‚ å¯¾è±¡èªè€… C++ã®
teddy-g 2014/12/15
ã‚¦ã‚§ãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆæœ¨ã®å®Ÿè£…æ–¹æ³•

bigdata

bitvector

data

database
ãƒªãƒ³ã‚¯
ç°¡æ½”ãƒ‡ãƒ¼ã‚¿æ§‹é€ LOUDS ã®è§£èª¬ï¼ˆå…¨12å›žã€ç·´ç¿’å•é¡Œä»˜ãï¼‰
ã€Œæ—¥æœ¬èªžå…¥åŠ›ã‚’æ”¯ãˆã‚‹æŠ€è¡“ã€ï¼ˆé€šç§°ã€Œå¾³æ°¸æœ¬ã€ï¼‰ã‚„ã€Œé«˜é€Ÿæ–‡å—åˆ—è§£æžã®ä¸–ç•Œã€ï¼ˆé€šç§°ã€Œå²¡é‡ŽåŽŸæœ¬ã€ï¼‰ã§ç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ LOUDS ã¨ã„ã†ãƒ‡ãƒ¼ã‚¿æ§‹é€ ã‚’ã€12å›žã«åˆ†ã‘ã¦è§£èª¬ã—ã¾ã—ãŸã€‚ å‹é”ã«æ•™ãˆã‚‹æ™‚ã«ä½¿ã£ãŸã‚‚ã®ã§ã€ç·´ç¿’å•é¡Œä»˜ãã§ã™ã€‚ å®Ÿéš›ã«ç´™ã«æ›¸ã„ã¦ã‚„ã£ã¦ã¿ã‚‹ã¨ã‚ã‹ã‚Šã‚„ã™ã„ã¨æ€ã„ã¾ã™ã€‚ è©³è§£ LOUDS (1) LOUDS ã¨ã¯ è©³è§£ LOUDS (2) ãƒ“ãƒƒãƒˆåˆ—ã‚’ä½œã£ã¦ã¿ã‚‹ è©³è§£ LOUDS (3) 0ç•ªãƒŽãƒ¼ãƒ‰ è©³è§£ LOUDS (4) ãƒ“ãƒƒãƒˆã®æ„å‘³ è©³è§£ LOUDS (5) æœ¨æ§‹é€ ã®å¾©å…ƒ è©³è§£ LOUDS (6) ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§ãƒŽãƒ¼ãƒ‰ã‚’è¡¨ã™ è©³è§£ LOUDS (7) ãƒŽãƒ¼ãƒ‰ç•ªå·ã‹ã‚‰ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å¾—ã‚‹ è©³è§£ LOUDS (8) ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‹ã‚‰ãƒŽãƒ¼ãƒ‰ç•ªå·ã‚’å¾—ã‚‹ è©³è§£ LOUDS (9) åãƒŽãƒ¼ãƒ‰ã‹ã‚‰è¦ªãƒŽãƒ¼ãƒ‰ è©³è§£ LOUDS (10) è¦ªãƒŽãƒ¼ãƒ‰ã‹ã‚‰åãƒŽãƒ¼ãƒ‰ è©³è§£ LOUDS (11) æœ¨ã®æ¤œç´¢ è©³è§£
teddy-g 2014/12/15
SuccinctãªDataæ§‹é€ ã®LOUDSè§£èª¬ã€‚ã¨ã¦ã‚‚ã‚ã‹ã‚Šã‚„ã™ã„ã€‚

bigdata

bitvector

data

database
ãƒªãƒ³ã‚¯
ä¸å¦ç”Ÿã«ã‚‚ã‚ã‹ã‚‹ã‚¦ã‚§ãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆè¡Œåˆ— - ã‚¢ã‚¹ãƒšæ—¥è¨˜
id:echizen_tm ã•ã‚“ã®è¨˜äº‹ã€Œã‚¦ã‚§ãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆæœ¨ã®åŠ¹çŽ‡çš„ã§ç°¡å˜ãªå®Ÿè£… "The Wavelet Matrix"ã€ã‹ã‚‰å§‹ã¾ã£ãŸã‚¦ã‚§ãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆè¡Œåˆ—ãƒ–ãƒ¼ãƒ ã‹ã‚‰åŠå¹´ä»¥ä¸ŠãŒéŽãŽã€ã™ã§ã«æž¯ã‚ŒãŸæŠ€è¡“ã¨ã—ã¦ç¢ºç«‹ã•ã‚Œã¤ã¤ã‚ã‚‹æ„ŸãŒã‚ã‚Šã¾ã™ã€‚ â€¦å˜˜ã§ã™ã€‚ æ—¥æœ¬ä»¥å¤–ã§ã¯ã‚ã‚“ã¾ã‚Šæ¥ã¦ã„ã¾ã›ã‚“ã€‚ ç†ç”±ã¨ã—ã¦ã¯ã€ã‚„ã¯ã‚Šã‚¢ãƒ«ãƒ•ã‚¡ãƒ™ãƒƒãƒˆåœã§ã¯å˜èªžå¢ƒç•ŒãŒæ˜Žç¢ºã§ã‚ã‚‹ãŸã‚ã€ã“ã¡ã‚‰ã®è¨˜äº‹ã§æ›¸ã‹ã‚Œã¦ã„ã‚‹ã‚ˆã†ãªã€Œã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰åˆ†å‰²ã®é›£æ˜“åº¦ã€ã¨ã„ã£ãŸã“ã¨ãŒã‚ã¾ã‚Šå•é¡Œã«ãªã‚‰ãªã„ã¨ã„ã†ã“ã¨ãŒã‚ã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ã¾ã‚ã€ãã†ã„ã†ã‚ã‘ã§å±€æ‰€çš„ã«æ¥ã¦ã„ã‚‹ã‚¦ã‚§ãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆè¡Œåˆ—ã§ã™ãŒã€æ—¥æœ¬èªžã‚’ã¯ã˜ã‚ã¨ã™ã‚‹å˜èªžå¢ƒç•Œã®ãªã„è¨€èªžåœã«ã¨ã£ã¦ã¯é‡è¦ãªãƒã‚¿ã§ã‚ã‚‹ã¨æ€ã†ãŸã‚ã€è§£èª¬è¨˜äº‹ã‚’æ›¸ãç›´ã—ã¦*1ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ã‚¦ã‚§ãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆè¡Œåˆ—ã§ã§ãã‚‹ã“ã¨ ä¸»ã¨ãªã‚‹æ“ä½œã¯ã€æ–‡å—åˆ—ã«å¯¾ã™ã‚‹ å®šæ•°æ™‚é–“ã® rank() ã¨ select()*2 ã§ã™ã€‚ rank() ã¯ã€ã€Œæ–‡
teddy-g 2014/12/15
ã‚¦ã‚§ãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆè¡Œåˆ—ã«ã¤ã„ã¦ã€‚ã¡ã‚ƒã‚“ã¨èªã‚“ã§ã¿ãªã„ã¨ã„ã‘ãªã„ã€‚

bigdata

bitvector

data

database
ãƒªãƒ³ã‚¯
å®Œå‚™è¾žæ›¸ï¼ˆç°¡æ½”ãƒ“ãƒƒãƒˆãƒ™ã‚¯ãƒˆãƒ«ï¼‰ã®è§£èª¬ - ã‚¢ã‚¹ãƒšæ—¥è¨˜
ä»¥å‰ã€ã€Œç°¡æ½”ãƒ‡ãƒ¼ã‚¿æ§‹é€ LOUDS ã®è§£èª¬ã€ã¨ã„ã†ã‚·ãƒªãƒ¼ã‚ºã®è¨˜äº‹ã‚’æ›¸ã„ãŸã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ LOUDS ã¨ã„ã†ã®ã¯æœ¨æ§‹é€ ã‚„trieã‚’ç°¡æ½”ã«è¡¨ã™ã“ã¨ãŒã§ãã‚‹ãƒ‡ãƒ¼ã‚¿æ§‹é€ ãªã®ã§ã™ãŒã€ã“ã®ä¸ã§ã€Œç°¡æ½”ãƒ“ãƒƒãƒˆãƒ™ã‚¯ãƒˆãƒ«ã€ã¨ã„ã†ã‚‚ã®ã«ã¤ã„ã¦ã¯ãƒ–ãƒ©ãƒƒã‚¯ãƒœãƒƒã‚¯ã‚¹ã¨ã—ã¦æ‰±ã£ã¦ã„ã¾ã—ãŸã€‚ ã¾ãŸã€ä¸å¦ç”Ÿã«ã‚‚ã‚ã‹ã‚‹ã‚¦ã‚§ãƒ¼ãƒ–ãƒ¬ãƒƒãƒˆè¡Œåˆ—ã‚’æ›¸ã„ãŸã¨ãã‚‚ã€ãã®ä¸ã§å‡ºã¦ããŸã€Œå®Œå‚™è¾žæ›¸ã€ã®å®Ÿè£…ã«ã¯è§¦ã‚Œã¾ã›ã‚“ã§ã—ãŸã€‚ ã“ã®ã€Œç°¡æ½”ãƒ“ãƒƒãƒˆãƒ™ã‚¯ãƒˆãƒ«ã€ã€Œå®Œå‚™è¾žæ›¸ã€ã¯ã€åŒã˜ã‚‚ã®ã‚’æŒ‡ã—ã¦ã„ã¾ã™*1ã€‚ ä»Šå›žã¯ã€ã“ã®ãƒ‡ãƒ¼ã‚¿æ§‹é€ *2ã«ã¤ã„ã¦æ›¸ã„ã¦ã¿ã¾ã™ã€‚ å®Œå‚™è¾žæ›¸ã§ã§ãã‚‹ã“ã¨ ãƒ“ãƒƒãƒˆåˆ—ã«å¯¾ã™ã‚‹å®šæ•°æ™‚é–“ã® rank ã¨ selectã§ã™*3ã€‚ rank()ã¯ã€ã€Œãƒ“ãƒƒãƒˆåˆ—ã®å…ˆé ã‹ã‚‰ä½ç½® k ã¾ã§ã«ã€1 ã®ãƒ“ãƒƒãƒˆãŒã„ãã¤ã‚ã‚‹ã‹ã€*4ã€‚ select()ã¯ã€ã€Œãƒ“ãƒƒãƒˆåˆ—ã®å…ˆé ã‹ã‚‰è¦‹ã¦ã€n å€‹ç›®ã® 1 ã®ãƒ“ãƒƒãƒˆã®æ¬¡ã®ä½ç½®ã¯ã©ã“ã‹ã€*5ã€‚ ãã‚Œãžã‚Œä¾‹ã‚’æŒ™ã’ã¾ã™ã€‚
teddy-g 2014/12/15
Succinct Bit Vectorã®èª¬æ˜Žã€‚ã¡ã‚ƒã‚“ã¨ã²ã¨ã¤ã²ã¨ã¤ç¢ºèªã—ãªãŒã‚‰èªã¿ãŸã„ã¨æ€ã†ã€‚

bitvector

database

bigdata
ãƒªãƒ³ã‚¯
ï¼»é€Ÿå ±ï¼½Amazon Auroraç™ºè¡¨ã€‚MySQLäº’æ›ã§æ€§èƒ½5å€ã€å•†ç”¨ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨åŒç‰ã®æ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹ãƒžãƒãƒ¼ã‚¸ãƒ‰ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ“ã‚¹ã€‚AWS re:Invent 2014
ï¼»é€Ÿå ±ï¼½Amazon Auroraç™ºè¡¨ã€‚MySQLäº’æ›ã§æ€§èƒ½5å€ã€å•†ç”¨ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨åŒç‰ã®æ©Ÿèƒ½ã‚’æä¾›ã™ã‚‹ãƒžãƒãƒ¼ã‚¸ãƒ‰ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒ“ã‚¹ã€‚AWS re:Invent 2014 Amazonã‚¯ãƒ©ã‚¦ãƒ‰ã‚’æä¾›ã™ã‚‹Amazon Web Servicesã¯ã€åŒç¤¾ã®å¹´æ¬¡ã‚¤ãƒ™ãƒ³ãƒˆã€ŒAWS re:Inventã€ã‚’ç±³ãƒ©ã‚¹ãƒ™ã‚¬ã‚¹ã§é–‹å‚¬ã—ã¦ã„ã¾ã™ã€‚ åˆæ—¥ã®åŸºèª¿è¬›æ¼”ã§ã¯ã€ã‚¯ãƒ©ã‚¦ãƒ‰ãŒã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºITã«ãŠã‘ã‚‹ãƒ‹ãƒ¥ãƒ¼ãƒŽãƒ¼ãƒžãƒ«ï¼ˆæ–°ã—ã„æ™®é€šï¼‰ã§ã‚ã‚‹ã“ã¨ã‚’å¼·èª¿ã€‚æ–°ã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦ã€MySQLäº’æ›ã§ã‚ã‚Šã¤ã¤å•†ç”¨ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸¦ã®æ€§èƒ½ã¨æ©Ÿèƒ½ã‚’å®Ÿç¾ã—ãŸã¨ã„ã†ã€ŒAmazon Auroraã€ã‚’ç™ºè¡¨ã—ã¾ã—ãŸã€‚ MySQLã¨ãƒ•ãƒ«äº’æ›ã§ã‚ã‚ŠãªãŒã‚‰5å€ã®æ€§èƒ½ Amazon Web Servicesã‚·ãƒ‹ã‚¢ãƒã‚¤ã‚¹ãƒ—ãƒ¬ã‚¸ãƒ‡ãƒ³ãƒˆ Andy Jassyæ°ã€‚ æ—¢å˜ã®ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã„ã†ã®ã¯é«˜ä¾¡ã§ã€ãƒ—ãƒãƒ—ãƒ©ã‚¤ã‚¨ã‚¿ãƒªã§
teddy-g 2014/11/16
é€šå¸¸ã®MySQLã®3å€ã©ã“ã‚ã‹5å€ã ã¨ã€‚ã“ã®ã‚¦ã‚§ãƒ¼ãƒ–ã€ä¹—ã‚‹ã—ã‹ãªã„

aws

amazon

database

mysql

aurora
ãƒªãƒ³ã‚¯
HTML5 - Web SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ - ã¨ã»ã»ã®WWWå…¥é–€
ã‚µãƒ³ãƒ—ãƒ«ã¯ã“ã¡ã‚‰ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹(testDB)ã®ä¸ã«ãƒ†ãƒ¼ãƒ–ãƒ«(test)ã‚’ä½œæˆã—ã€2ä»¶ã®ãƒ‡ãƒ¼ã‚¿ã‚’ INSERT ã—ã€ãã®ãƒ‡ãƒ¼ã‚¿ã‚’ SELECT ã§èªã¿å‡ºã—ã¦è¡¨ç¤ºã—ã¦ã„ã¾ã™ã€‚ Web SQL Database Sample <!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Web SQL Database Sample</title> <style> #message { margin:1em; width:500px; border:1px solid gray; padding:1em; } </style> <script> function print(msg) { document.getElementById("message").innerHTML += msg + "<br>"; } function te
teddy-g 2014/09/08
Web SQLã®è§£èª¬ã€‚SQLiteã¯æ¨™æº–ã˜ã‚ƒãªããªã£ãŸã‚“ã ãªã€‚

html5

websql

database

web

sql
ãƒªãƒ³ã‚¯
IndexedDB | Can I use... Support tables for HTML5, CSS3, etc
Method of storing data client-side, allows indexed database queries. âŒ 4 - 9: Not supported (but has polyfill available)âŒ 10: Not supportedâ— 11 - 22: Partial supportâœ… 23: Supportedâœ… 24 - 128: Supportedâœ… 129: Supportedâœ… 130 - 132: Supported
teddy-g 2014/08/18
indexedDBã®ã‚µãƒãƒ¼ãƒˆçŠ¶æ³ã€‚ã¾ã ã¾ã ã ãã€‚

javascript

html5

database

localstorage

webstorage

jquery.js

indexedDB
ãƒªãƒ³ã‚¯
TECH PROjin
ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³äº‹æ¥éƒ¨ã‹ã‚‰ã®ãŠçŸ¥ã‚‰ã› ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³äº‹æ¥éƒ¨ã®ãƒ–ãƒã‚°ã‚µã‚¤ãƒˆã‚’æ–°ãŸã«é–‹è¨ã„ãŸã—ã¾ã—ãŸã€‚ https://blog.sie-security.com/ ä»Šå¾Œã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ‹ãƒ¥ãƒ¼ã‚¹ã®æŠ•ç¨¿ã¯ä¸Šè¨˜URLã®ã‚µã‚¤ãƒˆã‹ã‚‰ã¨ãªã‚Šã¾ã™ã€‚ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ æ‹…å½“ï¼šTY â€¦More Read
teddy-g 2014/08/18
ï½ŠQueryã‚’ä½¿ã£ãŸindexedDBã®ã‚µãƒ³ãƒ—ãƒ«ã€‚

javascript

html5

database

localstorage

webstorage

jquery.js

indexedDB
ãƒªãƒ³ã‚¯
TECH PROjin
ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³äº‹æ¥éƒ¨ã‹ã‚‰ã®ãŠçŸ¥ã‚‰ã› ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³äº‹æ¥éƒ¨ã®ãƒ–ãƒã‚°ã‚µã‚¤ãƒˆã‚’æ–°ãŸã«é–‹è¨ã„ãŸã—ã¾ã—ãŸã€‚ https://blog.sie-security.com/ ä»Šå¾Œã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ‹ãƒ¥ãƒ¼ã‚¹ã®æŠ•ç¨¿ã¯ä¸Šè¨˜URLã®ã‚µã‚¤ãƒˆã‹ã‚‰ã¨ãªã‚Šã¾ã™ã€‚ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ æ‹…å½“ï¼šTY â€¦More Read
teddy-g 2014/08/18
indexedDBã®ã‚µãƒ³ãƒ—ãƒ«ã€‚localStorageã¯æ¤œç´¢ãŒå¼±ãã†ãªã‚“ã§indexedDBã§è€ƒãˆãŸã„ã¨ã“ã‚ã ã‘ã©

javascript

html5

database

localstorage

webstorage

jquery.js

indexedDB
ãƒªãƒ³ã‚¯
TECH PROjin
ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³äº‹æ¥éƒ¨ã‹ã‚‰ã®ãŠçŸ¥ã‚‰ã› ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã‚½ãƒªãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³äº‹æ¥éƒ¨ã®ãƒ–ãƒã‚°ã‚µã‚¤ãƒˆã‚’æ–°ãŸã«é–‹è¨ã„ãŸã—ã¾ã—ãŸã€‚ https://blog.sie-security.com/ ä»Šå¾Œã®ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ãƒ‹ãƒ¥ãƒ¼ã‚¹ã®æŠ•ç¨¿ã¯ä¸Šè¨˜URLã®ã‚µã‚¤ãƒˆã‹ã‚‰ã¨ãªã‚Šã¾ã™ã€‚ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚ æ‹…å½“ï¼šTY â€¦More Read
teddy-g 2014/08/18
jQueryã‚’ç”¨ã„ãŸlocalStorageã®èª¬æ˜Ž

javascript

html5

database

localstorage

webstorage

jquery.js
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸