[B! database] jjzakã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

jjzak id:jjzak

databaseã«é–¢ã™ã‚‹jjzakã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (97)

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

Clojure Programming/Examples/JDBC Examples - Wikibooks, open books for an open world
This page is intended to be a reference for using JDBC with Clojure. We'll create a simple blog database to see the basic functions in clojure.java.jdbc. For the latest, most up-to-date community-managed documentation for the clojure.java.jdbc library, consult Using java.jdbc on Clojure Documentation. This WikiBooks page is written around a very old version of the library and most of the examples
jjzak 2011/02/20
clojure

database

programming

jdbc

sql

sample
ãƒªãƒ³ã‚¯
sqlæŽ¥ç¶š - sileã®ãƒ–ãƒã‚°
ä»Šæ—¥ã¯ã€clojureã‹ã‚‰SQLServerã«æŽ¥ç¶šã™ã‚‹æ©Ÿä¼šãŒã‚ã£ãŸã®ã§ã€ãƒ¡ãƒ¢ã¨ã—ã¦ãã®ã‚³ãƒ¼ãƒ‰ã‚’æ®‹ã—ã¦ãŠãã€‚ ã¾ãšã€èµ·å‹•ç”¨ã®ã‚¹ã‚¯ãƒªãƒ—ãƒˆã‚’æº–å‚™: #! /bin/sh # # ãƒ•ã‚¡ã‚¤ãƒ«å: clojure # clojureèµ·å‹•ã‚¹ã‚¯ãƒªãƒ—ãƒˆ # å¼•æ•°ã«ã¯ã€ã‚¯ãƒ©ã‚¹ãƒ‘ã‚¹ã«è¿½åŠ ã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ãƒªã‚¹ãƒˆã‚’ä¸Žãˆã‚‹ CLASSPATH=$CLOJURE_HOME/clojure.jar:$CLOJURE_LIB/clojure-contrib.jar for cp in $@ do CLASSPATH=$CLASSPATH:$cp done java -cp $LIB clojure.lang.Repl æ¬¡ã«èµ·å‹•: $ clojure sqljdbc.jar æ®‹ã‚Šã¯clojureã‚³ãƒ¼ãƒ‰: (require 'clojure.contrib.sql) (use 'clojure.contrib.sql) ;; DB
jjzak 2011/02/20
clojure

programming

sql

database

tips
ãƒªãƒ³ã‚¯
SQL åŸºç¤Žå®Ÿåœ°ç·¨ (ãã®å…) å•ã„åˆã‚ã›ã€é›†è¨ˆã€é‡è¤‡ãƒ¬ã‚³ãƒ¼ãƒ‰ã€é›†åˆã€è¤‡åˆ - SAK Streets
SQL åŸºç¤Žå®Ÿåœ°ç·¨ (ãã®å…) å•ã„åˆã‚ã›ã€é›†è¨ˆã€é‡è¤‡ãƒ¬ã‚³ãƒ¼ãƒ‰ã€é›†åˆã€è¤‡åˆ åŸºæœ¬çš„ã« Oracleã€SQL-Serverã€MDB ã§å…±é€šã§ã™ã€‚ â– é›†è¨ˆå•ã„åˆã‚ã›(åˆè¨ˆå€¤) ãƒ»é›†è¨ˆå•ã„åˆã‚ã›ã‚’è¡Œã†ã«ã¯ã€group by å¥ã‚’ä½¿ç”¨ã™ã‚‹ã€‚ ã“ã®ä¾‹ã§ã¯ã€å“ç•ªã®å…ˆé ãŒã€Œaã€ã§å§‹ã¾ã‚‹æ˜Žç´°ã‚’å“ç•ªå˜ä½ã«é›†è¨ˆ(ã‚µãƒžãƒªãƒ¼)ã—ã€ å—æ³¨æ•°ã®åˆè¨ˆãŒ 1000 ä»¥ä¸Šã®ã‚‚ã®ã‚’å•ã„åˆã‚ã›ã‚‹ã€‚ having å¥ã¯ã€é›†è¨ˆå¾Œã®çµæžœã«å¯¾ã—ã¦æŠ½å‡ºæ¡ä»¶ãŒæŒ‡å®šã§ãã‚‹ã€‚ select å“ç•ª, sum(å—æ³¨æ•°) from sak.å—æ³¨m where å“ç•ª like 'a%' group by å“ç•ª having sum(å—æ³¨æ•°) >= 1000 order by å“ç•ª ; ãƒ»count() ã‚’ä½¿ç”¨ã™ã‚‹ã¨ã€åˆè¨ˆä»¶æ•°ãŒå•ã„åˆã‚ã›ã‚‰ã‚Œã‚‹ã€‚ (å•ã„åˆã‚ã›ä»¶æ•°è¡¨ç¤ºã€ç…§ä¼šä»¶æ•°è¡¨ç¤ºã€æŠ½å‡ºä»¶æ•°) ã“ã®ä¾‹ã§ã¯ã€å“ç•ªã®å…ˆé ãŒã€Œaã€ã§å§‹ã¾ã‚‹æ˜Žç´°ã‚’å“ç•ªå˜ä½ã«é›†è¨ˆ
jjzak 2011/02/20
database

sql

programming

tips
ãƒªãƒ³ã‚¯
MySQL - Documentation
OLTP MySQL cloud serviceâ€”built on MySQL Enterprise Edition Integrated and automated generative AI with MySQL HeatWave GenAI Accelerate query performance with MySQL HeatWave Query data in object storage and MySQL with MySQL HeatWave Lakehouse Automate the machine learning pipeline with MySQL HeatWave AutoML
jjzak 2011/02/20
database

reference

mysql

document
ãƒªãƒ³ã‚¯
Oracleã®SQLã‚³ãƒžãƒ³ãƒ‰
Oracleã®SQLã‚³ãƒžãƒ³ãƒ‰ 2006.08.01 Oracle ã‚ˆãä½¿ã†Oracle8iã®ã‚³ãƒžãƒ³ãƒ‰ã‚’ãƒ¡ãƒ¢ã€‚Oracle10iã§ã‚‚ã»ã¼åŒã˜ã€‚ Oracle SQL*Plusç·¨ Oracle ç®¡ç†ç·¨ Oracle SQLç·¨ Oracle ã‚¨ãƒ©ãƒ¼ç·¨ ã€SQL*Plusç·¨ã€‘ â– ã‚·ã‚§ãƒ«ã‹ã‚‰SQL/PLUSã‚’ä½¿ã† $ sqlplus /nolog â– ãƒã‚°ã‚¤ãƒ³ã™ã‚‹ ã„ãã¤ã‹ã®æ–¹æ³•ãŒã‚ã‚‹ã€‚ conn sys as sysdba conn / as sysdba conn sys/change_on_install conn system/manager conn scott/tiger conn scott ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†è€…ãƒ¦ãƒ¼ã‚¶ãƒ¼ SYSãƒ¦ãƒ¼ã‚¶ãƒ¼ï¼šç®¡ç†ã«é‡è¦ãªãƒ‡ãƒ¼ã‚¿ãƒ»ãƒ‡ã‚£ã‚¯ã‚·ãƒ§ãƒŠãƒªã‚’æ‰€æœ‰ã—ã¦ã„ã‚‹ã€‚ SYSTEMãƒ¦ãƒ¼ã‚¶ãƒ¼ï¼šç®¡ç†æƒ…å ±ãŒå«ã¾ã‚Œã‚‹è¡¨ã‚„ãƒ“ãƒ¥ãƒ¼ã‚’æ‰€æœ‰ã—ã¦ã„ã‚‹ã€‚ ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®ç†ç”±ã‹ã‚‰SYSãƒ¦ãƒ¼ã‚¶
jjzak 2011/02/20
oracle

sql

database

db

tips
ãƒªãƒ³ã‚¯
Oracle ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å¾©æ—§æ‰‹é †æ›¸ã¨ãƒ•ãƒ«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚¹ã‚¯ãƒªãƒ—ãƒˆ
æœ€è¿‘ã¯æ¥å‹™ã®é–¢ä¿‚ä¸Šã€Oracle ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å¾©æ—§æ‰‹é †æ›¸ã‚’ä½œæˆã—ã¦ã„ã¾ã—ãŸã€‚ Oracle ã®ã‚¨ãƒ³ã‚¿ãƒ¼ãƒ—ãƒ©ã‚¤ã‚ºåˆ†é‡Žã®ä¸»æµã¯ RAC æ§‹æˆã«ãªã‚Šã¾ã™ãŒã€å°è¦æ¨¡ã‚·ã‚¹ãƒ†ãƒ ã§ã¯ã¾ã ã¾ã ã‚·ãƒ³ã‚°ãƒ«ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹æ§‹æˆã‚‚å¤šã„ã“ã¨ã‹ã¨æ€ã„ã¾ã™ã€‚å®Ÿéš›ã‚·ã‚¹ãƒ†ãƒ æ§‹æˆçš„ã«ã¯ã‚·ãƒ³ã‚°ãƒ«ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã®æ–¹ãŒé™ã‹ã«ã‚·ãƒ³ãƒ—ãƒ«ã§é‹ç”¨ã‚‚æ¥½ã§ã™ã€‚ æ¥å‹™ã§ã¯ RAC æ§‹æˆã®ã‚·ã‚¹ãƒ†ãƒ ã‚’è¦‹ã¦ã„ã¾ã™ãŒã€æ•™è‚²ã¨ã„ã†å´é¢ã‹ã‚‰ã¯ã‚·ãƒ³ã‚°ãƒ«ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚’ã¾ãšã¯æ•™ãˆã‚‹ã®ãŒå‰ã§ã™ã€‚ã¾ãŸéƒ¨ä¸‹ã« DBA ã®ç«‹å ´ã‚’æ‹…ã£ã¦è²°ã†ã“ã¨ã‚’è€ƒãˆã‚‹ã¨ã€æœ€ä½Žé™çŸ¥ã£ã¦ãŠã„ã¦æ¬²ã—ã„ã®ã¯ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ï¼†ãƒªã‚«ãƒãƒªã€‚ã‚·ã‚¹ãƒ†ãƒ ãƒ€ã‚¦ãƒ³æ™‚ã«æ´»èºã™ã‚‹ã‚¹ã‚ãƒ«ã‚’èº«ã«ã¤ã‘ã¦æ¬²ã—ã„ã¨é¡˜ã„ã¾ã™ã€‚ã›ã£ã‹ãã„ã‚ã„ã‚è³‡æ–™ã‚’ä½œã£ã¦ããŸã®ã§æ±Žç”¨åŒ–ã§ãã‚‹éƒ¨åˆ†ã®ã¿å…¬é–‹ã—ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—æ–¹å¼ã«ã¤ã„ã¦è¨€ãˆã°æœ€è¿‘ã®ä¸»æµã¯ã‚‚ã¡ã‚ã‚“ Oracle ãŒæä¾›ã—ã¦ã„ã‚‹ Recovery Manager ã‚’ä½¿ã£ãŸãƒãƒƒã‚¯ã‚¢
jjzak 2011/02/20
Oracle ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ï¼ˆã‚·ãƒ³ã‚°ãƒ«ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ç‰ˆï¼‰å¾©æ—§æ‰‹é †æ›¸ã‚’ãƒ•ãƒãƒ¼ãƒãƒ£ãƒ¼ãƒˆåŒ–ã—ãŸã‚‚ã®ã‚’å…¬é–‹ã—ã¾ã™ã€‚åŸºæœ¬çš„ã«ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ãƒã‚°é‹ç”¨ã‚’è¡Œã£ã¦ã„ã¦ãƒ•ã‚¡ã‚¤ãƒ«ãƒ™ãƒ¼ã‚¹ã®ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ãŒå–å¾—ã§ãã¦ã„ã‚‹å‰æã®æ‰‹é †ã«ãªã‚Šã¾ã™ã€‚åŸº

database

oracle

tutorial
ãƒªãƒ³ã‚¯
NOSQL Patternsã€å’Œè¨³ - @katzchang.contexts
http://horicky.blogspot.com/2009/11/nosql-patterns.html 11/30æ™‚ç‚¹ã§ã€ä¸€é€šã‚Šç¿»è¨³ã®ã†ã¡ã€æ£ç›´ãƒ™ãƒ¼ã‚¹ã®ã–ã£ãã‚Šæ„Ÿè¦šï¼ˆæ¥ç•Œç”¨èªžï¼‰ã§75%å®Œäº†ã§ã™ã€‚ æœ¬äººã‚‚ç†è§£ãŒæ€ªã—ã„ãªãŒã‚‰è¨³ã—ã¦ã„ã‚‹ã®ã§ã€éšæ‰€ã«é–“é•ã„ã‚’ä»•è¾¼ã‚“ã§ã„ã¾ã™ã€‚ã”æŒ‡æ‘˜é ‚ã‘ã‚Œã°å¹¸ã„ã§ã™ã€‚ NOSQL Patterns ã“ã“æ•°å¹´ã€å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸æ©Ÿæ§‹ãŒç™ºå±•ã—ã¦ã„ã‚‹ã€‚ã“ã‚Œã‚‰ã®æ©Ÿæ§‹ã¯å¾“æ¥ã®RDBMSãƒ¢ãƒ‡ãƒ«ã¨ã¯ç•°ãªã£ã¦ãŠã‚Šã€NOSQLã¨ã‚‚å‘¼ã°ã‚Œã¦ã„ã‚‹ã€‚ã‚ãƒ¼ãƒ—ãƒ¬ã‚¤ãƒ¤ãƒ¼ã¨ã—ã¦ã¯ï¼š GoogleBigTable, HBase, Hyperta ble AmazonDynano, Voldemort, Cassendra, Riak Redis CouchDB, Mongo DB ã“ã‚Œã‚‰ã¯ã€æ¬¡ã®å…±é€šç‚¹ã‚’æŒã£ã¦ã„ã‚‹ã€‚ Key-Valueã‚¹ãƒˆã‚¢ å¤šæ•°å°ã®ä¸€èˆ¬çš„ãªPCã§é‹ç”¨å¯èƒ½ è¤‡æ•°ã‚µãƒ¼
jjzak 2010/08/24
sql

nosql

datastore

database

db
ãƒªãƒ³ã‚¯
http://www.shudo.net/publications/NoSQL-data-model-200912/
jjzak 2010/08/24
database

db

nosql
ãƒªãƒ³ã‚¯
key-valueã‚¹ãƒˆã‚¢ã®åŸºç¤ŽçŸ¥è˜
é¦–è—¤ ä¸€å¹¸ Last-updated: January 5, 2010 æ³¨: ã“ã®ãƒšãƒ¼ã‚¸ã®æ–‡ç« ã¯ Software Design èªŒ 2010å¹´ 2æœˆå·ã«æŽ²è¼‰ã•ã‚ŒãŸä»¥ä¸‹ã®è¨˜äº‹ã®å…ƒåŽŸç¨¿ã§ã™ã€‚ Software Design èªŒç·¨é›†éƒ¨ã®äº†æ‰¿ã®å…ƒã«ã€æœ¬ã‚¦ã‚§ãƒ–ãƒšãƒ¼ã‚¸ã«æŽ²è¼‰ã—ã¦ãŠã‚Šã¾ã™ã€‚ é¦–è—¤ä¸€å¹¸: "key-valueã‚¹ãƒˆã‚¢ã®åŸºç¤ŽçŸ¥è˜", Software Design 2010å¹´ 2æœˆå·, p.14-21, (æ ª)æŠ€è¡“è©•è«–ç¤¾, 2010å¹´ 1æœˆ 18æ—¥ ã‚¯ãƒ©ã‚¦ãƒ‰ã€ç‰¹ã«PaaSå‘ã‘ã®ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢é–‹ç™ºãŒç¾å®Ÿã®ã‚‚ã®ã¨ãªã‚Šã€ ãã“ã§ã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã¯é•ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ãŒ å‹¢ã„ã‚’å¢—ã—ã¦ã„ã¾ã™ã€‚ ãã®ä»£è¡¨ã§ã‚ã‚‹key-valueã‚¹ãƒˆã‚¢ã‚’è§£èª¬ã—ã¾ã™ã€‚ ã‚‚ãã˜ key-valueã‚¹ãƒˆã‚¢ã¨ã¯ ãªãœkey-valueã‚¹ãƒˆã‚¢ã‹ key-valueã‚¹ãƒˆã‚¢ã®ä½¿ã„ã©ã“ã‚ key-valueã‚¹ãƒˆã‚¢ã¨NoSQLã®
jjzak 2010/08/24
tutorial

column

database

key-value

nosql

architecture

research

db
ãƒªãƒ³ã‚¯
ï¿½Linux/DB Tuning (DevSumi2010, Japanese)
MLOps ã«åŸºã¥ã AI/ML å®Ÿé‹ç”¨æœ€å‰ç·š ï½žç”»åƒã€å‹•ç”»ãƒ‡ãƒ¼ã‚¿ã«ãŠã‘ã‚‹ MLOps äº‹ä¾‹ã®ã”ç´¹ä»‹ï½žï¼ˆæ˜ åƒæƒ…å ±ãƒ¡ãƒ‡ã‚£ã‚¢å¦ä¼š2021å¹´å†¬å£å¤§ä¼šä¼ç”»ã‚»ãƒƒã‚·ãƒ§...
jjzak 2010/08/24
é«˜æ€§èƒ½ãƒ»å®‰å®šé‹ç”¨ã®ãŸã‚ã® Linux/DB ã‚·ã‚¹ãƒ†ãƒ æ§‹ç¯‰ / é‹ç”¨æŠ€è¡“ æ¾ä¿¡ å˜‰ç¯„ (MATSUNOBU Yoshinori) ã‚µ

database

db

performance

linux

mysql
ãƒªãƒ³ã‚¯
http://homepage2.nifty.com/yoks/TechNote/H2/H2_MnFrm.htm
jjzak 2010/08/24
database

db

development

java

h2
ãƒªãƒ³ã‚¯
Diplodocs - ç°¡å˜ã«ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‚¬ã‚¤ãƒ‰ãƒ»ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ãƒ»æ“ä½œèª¬æ˜Žæ›¸ãªã©ãŒæŽ¢ã›ã¾ã™ï¼
ãƒ–ãƒ©ãƒ³ãƒ‰ã«é–¢ä¿‚ãªãå–æ‰±èª¬æ˜Žæ›¸ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã€‚ã‚¢ãƒ¼ã‚«ã‚¤ãƒ–ã—ã¦ã€ãã‚Œã‚‰ã‚’å¾Œã§å–æ‰±èª¬æ˜Žæ›¸ã‚’è¡¨ç¤ºã—ã¾ã™ã€‚å„ã‚¸ãƒ£ãƒ³ãƒ«ã®ãƒ–ãƒ©ãƒ³ãƒ‰ A Acer,Â Asus,Â Apple,Â Alcatel,Â Aastra,Â Arthur Martin,Â ... B Blaupunkt,Â Brother,Â Brandt,Â Blackberry,Â BMW,Â Benq,Â ... C Canon,Â Casio,Â Clarion,Â Cisco,Â CitroÃ«n,Â Candy,Â ... D Denon,Â Dell,Â D-Link,Â ... E Electrolux,Â Epson,Â Elna,Â ... F Fujifilm,Â Fujitsu Siemens,Â Fagor,Â Fo
jjzak 2010/08/24
database

document

æ¤œç´¢

manual

ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰

download

webservice

reference
ãƒªãƒ³ã‚¯
ç¤¾ä¼šå®Ÿæƒ…ãƒ‡ãƒ¼ã‚¿å›³éŒ² Honkawa Data Tribune
ä¾¿ç§˜æ¯”çŽ‡ãƒˆãƒƒãƒ—5ã¯ã€äº¬éƒ½ã€å¯Œå±±ã€å¾³å³¶ã€ç¦äº•ã€ç†Šæœ¬ã§ã‚ã‚Šã€é–¢è¥¿ã€åŒé–¢é€£åœ°åŸŸãŒå¤šããªã£ã¦ã„ã‚‹ã€‚ã„ã‘ãšã®äº¬éƒ½äººã¯ã‚„ã¯ã‚Šã²ã¨ã«æ°—ã‚’ä½¿ã„ã™ãŽã‹ã€‚ä¸‹ä½3ä½ã¯åŸ¼çŽ‰ã€å²é˜œã€ç¦å³¶ã€‚
jjzak 2010/08/24
çµ±è¨ˆ

è³‡æ–™

database

business

finance

ãƒã‚¿

search

research

statistics
ãƒªãƒ³ã‚¯
æœªæ¥å¹´è¡¨ | ç”Ÿæ´»ç·ç ”ONLINE
æœªæ¥äºˆæ¸¬é–¢é€£ã®è¨˜äº‹ã‚„ãƒ¬ãƒãƒ¼ãƒˆã‹ã‚‰ã€Œâ—‹â—‹å¹´ã«ã€â—‹â—‹ã«ãªã‚‹ã€ã¨ã„ã£ãŸæƒ…å ±ã®ã¿ã‚’ åŽ³é¸ã—ã€è¥¿æš¦å¹´ã‚„åˆ†é‡Žã”ã¨ã«æ•´ç†ã—ãŸæœªæ¥äºˆæ¸¬ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ã€‚ å„æœªæ¥äºˆæ¸¬ãƒ‡ãƒ¼ã‚¿ã«ã¯ã€Œé¡žåž‹ã€ï¼ˆäºˆæ¸¬ã€æŽ¨è¨ˆã€è¨ˆç”»ã€æ”¿ç–ç›®æ¨™ã€æ±ºå®š ãªã©ï¼‰ã€Œå‡ºå…¸ã€ã€Œè³‡æ–™åã€ã€Œç™ºè¡¨æ™‚æœŸã€ãŒä»˜è¨˜ã•ã‚Œã¦ã„ã¾ã™ã€‚ ãªãŠãƒˆãƒƒãƒ—ãƒšãƒ¼ã‚¸ã®ã€ŒTOTAL FUTUREã€ã¯æœªæ¥å¹´è¡¨ã«åŽéŒ²ã•ã‚Œã¦ã„ã‚‹æœªæ¥äºˆæ¸¬ãƒ‡ãƒ¼ ã‚¿æ•°ã®ç´¯è¨ˆã§ã™ã€‚æ¯Žæœˆ20æ—¥ã«æ›´æ–°ã—ã¦ã„ã¾ã™ã€‚ 2026.02.20ã€€æœªæ¥å¹´è¡¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ›´æ–°ã€€ç¬¬12å›žãƒ‡ãƒ«ãƒ•ã‚¡ã‚¤èª¿æŸ»ã«å¯¾å¿œ 2026.01.20ã€€æœªæ¥å¹´è¡¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ›´æ–° 2025.12.20ã€€æœªæ¥å¹´è¡¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ›´æ–° 2025.11.20ã€€æœªæ¥å¹´è¡¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ›´æ–° 2025.10.20ã€€æœªæ¥å¹´è¡¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ›´æ–° æœªæ¥å¹´è¡¨ ï¼š æ›´æ–°æƒ…å ±
jjzak 2010/08/24
research

database

column

business
ãƒªãƒ³ã‚¯
Oracle ã® B*Tree ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®å†…éƒ¨æ§‹é€ ã«ã¤ã„ã¦ãŠå‹‰å¼·ä¸ï¼ˆãã®ï¼‘ï¼‰
ãŠä»•äº‹ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ä¸€å¼ã®ãƒªãƒ¼ã‚¹åˆ‡ã‚Œé–“è¿‘ã¨ã„ã†ã“ã¨ã§ã€ãƒªãƒ¼ã‚¹å»¶é•·ã§è€ãˆã‚‹ã“ã¨ãŒã§ãã‚‹ã®ã‹ã€ãã‚Œã¨ã‚‚ã‚·ã‚¹ãƒ†ãƒ æ›´æ”¹ãŒå¿…è¦ãªã®ã‹ã‚’è¦‹æ¥µã‚ã‚‹ãŸã‚ã€æœ€è¿‘ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å‘¨ã‚Šã®ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã°ã‹ã‚Šã‚„ã£ã¦ã¾ã™ã€‚ å½“åˆè¨è¨ˆæ™‚ã«ã€ï¼•å¹´é–“æŒã¤è¨è¨ˆã‚’ã—ãŸã®ã§ã™ãŒã€æµçŸ³ã«ï¼•å¹´ç›®ã«ã‚‚ãªã‚‹ã¨äºˆå®šã¨ã¯ãã‚Œãªã‚Šã«ä¹–é›¢ãŒç™ºç”Ÿã™ã‚‹ã‚‚ã®ã§ã™ã€‚ãƒ†ãƒ¼ãƒ–ãƒ«ï¼†ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹è¨è¨ˆã‚’ãƒ¦ãƒ¼ã‚¶å‘ã‘ã®å‡¦ç†ã‚’ã¨ã«ã‹ãé«˜é€Ÿã«å‡¦ç†ã§ãã‚‹ã‚ˆã†ã«è¨è¨ˆã—ãŸã®ã§ã€ãƒ¦ãƒ¼ã‚¶å‘ã‘ã®å‡¦ç†ã¯é€Ÿåº¦çš„ã«å…¨ç„¶å¤§ä¸ˆå¤«ãªã®ã§ã™ãŒã€ãƒ‡ãƒ¼ã‚¿ã®è‚¥å¤§åŒ–ã«ã‚ˆã‚‹ãƒãƒƒãƒå‡¦ç†ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹åŠ£åŒ–ãŒé¡•è‘—ã§ã™ã€‚å˜ç´”ã«ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¨ CPU ãƒ‘ãƒ¯ãƒ¼ãŒè¶³ã‚Šã¦ã„ãªã„ã®ã§ã—ã‚‡ã†ã€‚ ã—ã‹ã—ãªãŒã‚‰ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ä½™åœ°ã¯ã¾ã ã¾ã ååˆ†ã«ã‚ã‚Šãã†ã§ã™ã€‚ãƒãƒƒãƒå‘ã‘ã®æœ€é©åŒ–ã‚’å›³ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ã†ã¾ãã„ã‘ã°æ¥å¹´åº¦ã©ã“ã‚ã‹ã€å¾Œæ•°å¹´ã¯ãƒªãƒ¼ã‚¹å»¶é•·ã§å»¶å‘½ã§ãã‚‹ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ã€‚ ä»Šå›žå®Ÿæ–½ã—ãŸãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°ã®ï¼‘ã¤ã®ãƒã‚¤ãƒ³ãƒˆã¨ã—ã¦ã€ãƒãƒƒãƒå‡¦ç†å‘
jjzak 2009/11/14
database

development

db

algorithm
ãƒªãƒ³ã‚¯
ç±³å¤§çµ±é ˜é¸ã§MySQLã¯ã©ã®ã‚ˆã†ã«ä½¿ã‚ã‚ŒãŸã®ã‹
æ—¥æœ¬ã®è¡†è°é™¢é¸æŒ™ãŒé–“è¿‘ã«è¿«ã£ã¦ã„ã¾ã™ãŒã€æ˜¨å¹´ç±³å›½ã§è¡Œã‚ã‚ŒãŸå¤§çµ±é ˜é¸ã«ãŠã„ã¦ã€ã‚ªãƒãƒžé™£å–¶ãŒIT æŠ€è¡“ã‚’é§†ä½¿ã—ãŸã¨ã„ã†è©±ã¯ã‚ˆãçŸ¥ã‚‰ã‚Œã¦ã„ã¾ã™ã€‚MySQLã‚‚ã‚‚ã¡ã‚ã‚“ä½¿ã‚ã‚Œã¦ã„ã¾ã—ãŸã€‚ä»Šå¹´4æœˆã«ã‚µãƒ³ã‚¿ã‚¯ãƒ©ãƒ©ã§é–‹å‚¬ã•ã‚ŒãŸMySQL Conference & Expo 2009ã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã§ã¯ã€æœ€çµ‚æ—¥ã®ã‚ãƒ¼ãƒŽãƒ¼ãƒˆã«ãŠã„ã¦ã€Obama Tech Teamã®æ–¹ã€…ã‚ˆã‚Šã€å¤§çµ±é ˜é¸ã«ãŠã„ã¦MySQLãŒã„ã‹ã«ä½¿ã‚ã‚ŒãŸã‹ã¨ã„ã†ç™ºè¡¨ãŒè¡Œã‚ã‚Œã¾ã—ãŸã€‚ æœ¬å½“ã¯ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹çµ‚äº†å¾Œã«ã™ãã¡ã‚ƒã‚“ã¨ã—ãŸãƒ¬ãƒãƒ¼ãƒˆã‚’æ›¸ã„ã¦å…¬é–‹ã™ã‚‹äºˆå®šã ã£ãŸã®ã§ã™ãŒã€ãã®é€±ã«èµ·ã“ã£ãŸè‰ãªãŽå‰›é€®æ•ã¨ã‹ã€ãã®ã»ã‹ã®å‡ºæ¥äº‹ã«ã™ã£ã‹ã‚Šæ°—ã‚’å–ã‚‰ã‚Œã¦æ”¾ç½®ã—ã¦ã„ã¾ã—ãŸã€‚Blogã‚’å§‹ã‚ãŸå¥‘æ©Ÿã«Twitterã®ä¸ã§èˆˆå‘³ã‚’æŒã£ã¦ã„ã‚‹æ–¹ãŒã„ã‚‹ã‹ã©ã†ã‹èžã„ãŸã¨ã“ã‚ã€ãã“ãã“ã®æ–¹ãŒèˆˆå‘³ã‚’ç¤ºã—ãŸã®ã§ã€ã“ã“ã§ç°¡å˜ã«ã¾ã¨ã‚ãŸãƒ¡ãƒ¢ã‚’å…¬é–‹ã™ã‚‹ã“ã¨ã«ã—ã¾ã™ã€‚ â—ãƒãƒ¼ãƒ ãƒ¡ãƒ³ãƒãƒ¼ ç™ºè¡¨è€…ã¯
jjzak 2009/09/19
howto

database

db

mysql

architecture
ãƒªãƒ³ã‚¯
blog.katsuma.tv
å‰å›žã€JavaScriptã§Map Reduceã®ã‚³ãƒ¼ãƒ‰ãŒæ›¸ã‘ã‚‹Hadoop Streamingã«ã¤ã„ã¦ç´¹ä»‹ã—ã¾ã—ãŸã€‚ æ¨™æº–å…¥å‡ºåŠ›ã•ãˆã‚µãƒãƒ¼ãƒˆã•ã‚Œã¦ã‚ã‚Œã°ã€ä»»æ„ã®ã‚³ãƒ¼ãƒ‰ã§Map Reduuceã®å‡¦ç†ãŒæ›¸ã‘ã‚‹ã€ã¨ã„ã†ã‚‚ã®ã§ã—ãŸãŒã€ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã¯ãã‚‚ãã‚‚é¢å€’ãã•ãŒã‚Šã€‚ã‚³ãƒ¼ãƒ‰ã‚‚æ›¸ãã®ã‚‚é¢å€’ã§ã™ã€‚ ã¨ã€ã„ã†ã‚ã‘ã§ã€ä»Šå›žã¯ã‚‚ã†ã‚³ãƒ¼ãƒ‰ã™ã‚‰æ›¸ã‹ãšã«SQLãƒ©ã‚¤ã‚¯ã§Map Reduceã§ãã‚‹Hiveã¨ã„ã†ãƒ—ãƒãƒ€ã‚¯ãƒˆã«ã¤ã„ã¦ã€ã¾ã¨ã‚ãŸã„ã¨æ€ã„ã¾ã™ã€‚ Hive Hiveã¨ã¯ã€ç°¡å˜ã«è¨€ã†ã¨Hadoopä¸Šã§å‹•ä½œã™ã‚‹RDBã®ã‚ˆã†ãªã‚‚ã®ã§ã™ã€‚ HDFSãªã©ã®åˆ†æ•£ãƒ•ã‚¡ã‚¤ãƒ«ã‚·ã‚¹ãƒ†ãƒ ä¸Šã«å˜åœ¨ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã«å¯¾ã—ã¦ã€HiveQLã¨ã„ã†SQLãƒ©ã‚¤ã‚¯ãªè¨€èªžã§æ“ä½œã§ãã¾ã™ã€‚ ã§ã€é¢ç™½ã„ã®ãŒHiveQLã®æ“ä½œã¯åŸºæœ¬çš„ã«Map Reduceã®ãƒ©ãƒƒãƒ‘ãƒ¼ã«ãªã£ã¦ã„ã‚‹ã“ã¨ã€‚ è¦ã™ã‚‹ã«ã€SELECTæ–‡å®Ÿè¡Œã™ã‚‹ã¨è£ã§Map&Reduceã®ã‚¿ã‚¹ã‚¯ãŒèµ°ã‚Šå‡º
jjzak 2009/09/19
database

hadoop

hive

programming

ruby

mapreduce
ãƒªãƒ³ã‚¯
BrewersCapTheorem - ãƒ–ãƒªãƒ¥ãƒ¯ãƒ¼ã® CAP å®šç†
BrewersCapTheorem - ãƒ–ãƒªãƒ¥ãƒ¯ãƒ¼ã® CAP å®šç† ç›®æ¬¡ ã“ã®æ–‡æ›¸ã«ã¤ã„ã¦ ãƒ–ãƒªãƒ¥ãƒ¯ãƒ¼ã® CAP å®šç† - Amazon ã¨ eBay ã®ã‚¯ãƒ¼ãƒ«ã‚¨ã‚¤ãƒ‰ ãƒ–ãƒªãƒ¥ãƒ¯ãƒ¼ã®(CAP)å®šç† ä¸€è²«æ€§ (Consistency) å¯ç”¨æ€§ (Availability) åˆ†å‰²è€æ€§(Partition Tolerance) å®šç†ã®é‡è¦æ€§ å›³è§£ã§è¨¼æ˜Ž CAP ã¨æŠ˜ã‚Šåˆã† 1. åˆ†å‰²è€æ€§ã‚’è«¦ã‚ã‚‹ 2. å¯ç”¨æ€§ã‚’è«¦ã‚ã‚‹ 3. ä¸€è²«æ€§ã‚’è«¦ã‚ã‚‹ 4. BASE ã«è·³ã¶ 5. å•é¡Œã‚’ã‹ã‚ã—ã¦è¨è¨ˆã™ã‚‹ ã¾ã¨ã‚ å‚è€ƒæ–‡çŒ® ãƒ–ãƒªãƒ¥ãƒ¯ãƒ¼ã® CAP å®šç† ã“ã®æ–‡æ›¸ã«ã¤ã„ã¦ "Brewer's CAP Theorem - The kool aid Amazon and Ebay have been drinking" ã®æ—¥æœ¬èªžè¨³ã§ã™. http://www.julianbrowne.com/article/view
jjzak 2009/09/19
database

cap

algorithm
ãƒªãƒ³ã‚¯
MyNA Web Site
Home è³‡æ–™ç½®ãå ´ ä½œè€…ãƒ—ãƒãƒ•ã‚£ãƒ¼ãƒ« â€ æ°åï¼šæ¾ä¿¡ å˜‰ç¯„ (MATSUNOBU Yoshinori) æ‰€å±žï¼šã‚µãƒ³ãƒ»ãƒžã‚¤ã‚¯ãƒã‚·ã‚¹ãƒ†ãƒ ã‚ºæ ªå¼ä¼šç¤¾ å½¹å‰²ï¼šMySQLã®ã‚³ãƒ³ã‚µãƒ«ãƒ†ã‚£ãƒ³ã‚° Blogï¼šhttp://opendatabaselife.blogspot.com/ Twitterï¼šhttp://twitter.com/matsunobu â†‘
jjzak 2009/08/16
tips

reference

database

db

mysql
ãƒªãƒ³ã‚¯
perlã«ã‚ˆã‚‹å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã®å–æ‰±ã„
æœ¬ãƒšãƒ¼ã‚¸ã§ã¯ï¼Œperlã§ã©ã®ã‚ˆã†ã«ã—ã¦å¤§è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿ã‚’ä¿å˜ã™ã‚‹ã‹ã¤ã„ã¦ èª¬æ˜Žã—ã¾ã™ï¼Žä¸»ã«ã‚¹ã‚¿ãƒ³ãƒ‰ã‚¢ãƒãƒ³ã§å‹•ãã‚‚ã® (ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆ<->ã‚µãƒ¼ãƒåž‹ ã§ãªã„ï¼Œã„ã‚ã‚†ã‚‹çµ„è¾¼ã¿åž‹) ã«ã¤ã„ã¦ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ï¼Ž Menu Berkeley DB BerkeleyDB DB_File SDBM SDBM_File GDBM GDBM_File CDB CDB_File QDBM Depot Curia Villa TDB TDB_File SQLight DBD::SQLite SUFFIX ARRAY SUFARY SARY è¤‡é›‘ãªãƒ‡ãƒ¼ã‚¿æ§‹é€ Data::Dumper Storable MLDBM ã„ã‚ã„ã‚ãªæ¯”è¼ƒ ãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚º Benchmark Link ã‚µãƒ³ãƒ—ãƒ«ãƒ‡ãƒ¼ã‚¿ã«ã¤ã„ã¦ Berkeley DB Berkeley DBã¯ï¼Œçµ„ã¿è¾¼ã¿å‘ã‘ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã™ï¼Žé€šå¸¸ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã„ã† ã¨Oracl
jjzak 2009/08/02
programming

tips

software

database

perl

suffixarray

text

search

algorithm
ãƒªãƒ³ã‚¯
1 2 3 4 5 æ¬¡ã®ãƒšãƒ¼ã‚¸