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

hassylin id:hassylin

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

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

scale out ã®æŠ€è¡“ (in UNIX magazine, April 2009)
scale outã®æŠ€è¡“ é¦–è—¤ ä¸€å¹¸ Last-updated: January 5, 2010 æ³¨: ã“ã®ãƒšãƒ¼ã‚¸ã®æ–‡ç« ã¯ä»¥ä¸‹ã®è¨˜äº‹ã®å…ƒåŽŸç¨¿ã§ã™ã€‚ é¦–è—¤ä¸€å¹¸, "ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®æŠ€è¡“", ã‚¯ãƒ©ã‚¦ãƒ‰ã®æŠ€è¡“, pp.88-101, (æ ª)ã‚¢ã‚¹ã‚ãƒ¼ãƒ»ãƒ¡ãƒ‡ã‚£ã‚¢ãƒ¯ãƒ¼ã‚¯ã‚¹, ISBN978-4-04-868064-6, 2009å¹´ 11æœˆ 6æ—¥ ã‚¢ã‚¹ã‚ãƒ¼ãƒ»ãƒ¡ãƒ‡ã‚£ã‚¢ãƒ¯ãƒ¼ã‚¯ã‚¹ç¤¾ã® æ›¸ç±ç´¹ä»‹ãƒšãƒ¼ã‚¸ Amazon.co.jp ã® ãƒšãƒ¼ã‚¸ é¦–è—¤ä¸€å¹¸, "ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã®æŠ€è¡“", UNIX magazine 2009å¹´ 4æœˆå·, pp.78-91, (æ ª)ã‚¢ã‚¹ã‚ãƒ¼ãƒ»ãƒ¡ãƒ‡ã‚£ã‚¢ãƒ¯ãƒ¼ã‚¯ã‚¹, 2009å¹´ 3æœˆ 18æ—¥ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«æ±‚ã‚ã‚‰ã‚Œã‚‹æ€§èƒ½ã‚’è©¦ç®—ã—ãŸã¨ã“ã‚ã€ åå°ã€ç™¾å°â€¦æ•°ä¸‡å°ã®ã‚µãƒ¼ãƒãŒå¿…è¦ã«ãªã£ãŸã€‚ ã‚¯ãƒ©ã‚¦ãƒ‰ã‚’æ§‹ç¯‰ã™ã‚‹å´ã¯ã“ã†ã„ã†å•é¡Œã«ç›´é¢ã—ã€è§£æ±ºã—ã‚ˆã†ã¨ã—ã¦ããŸã€‚ å°æ•°ã«æ¯”ä¾‹ã—ãŸæ€§èƒ½ã‚’å¼•ãå‡ºã™ã“ã¨ã€ã¤ã¾ã‚Šsca
hassylin 2010/01/19
database
ãƒªãƒ³ã‚¯
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ã®
hassylin 2010/01/19
database
ãƒªãƒ³ã‚¯
DBè¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Š - ã‚ˆãã®ã¯ã¦ãª
ã“ã“ã®ã¨ã“ã‚ã€javaccã¨awsã«é…äº†ã•ã‚Œã¦ã„ã‚‹ç±³æž—ã§ã™ã€‚ ã‚ˆãä½¿ã†DB(Oracle/MySQL/PostgreSQL/SQLServer)ã«ãŠã‘ã‚‹è¨è¨ˆæ™‚ã®ã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Šã§ä½¿ã†ã‚µã‚¤ãƒˆã®å‚™å¿˜éŒ²ã€‚ ã‚ã¨ã¯ã€Oracleã‹ã‚‰ã®Pythonæƒ…å ±ã€‚ Oracle Oracle ç‰©ç†è¨è¨ˆ http://www.oracle.com/techno logy/global/jp/columns/skillup/oracle9i/index.html é ˜åŸŸã‚µã‚¤ã‚ºè¦‹ç©ã‚‚ã‚Š http://otn.oracle.co.jp/document/estimate/index.html OTNã«ãƒã‚°ã‚¤ãƒ³ã™ã‚‹å¿…è¦ã‚ã‚Šã¾ã™ãŒã‚ªãƒ³ãƒ©ã‚¤ãƒ³ã§è¦‹ç©ã‚‚ã‚ŠãŒå‡ºæ¥ã¾ã™ã€‚ ã‚¢ã‚«ã‚¦ãƒ³ãƒˆæŒã£ã¦ã„ãªã„äººã¯ã€ã“ã®è¦‹ç©ã‚‚ã‚Šãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã†ç›®çš„ã§ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’ä½œã£ã¦ã¿ã¦ã¯ã„ã‹ãŒã§ã—ã‚‡ã†ã‹ã€‚ OLTPç³»ã¨DWHç³»ã«ãŠã„ã¦ãƒ–ãƒãƒƒã‚¯ã‚µã‚¤ã‚ºã‚’è€ƒæ…®ã—ã€DWHç³»ã¯ãƒ–
hassylin 2009/05/13
database

ä¾¿åˆ©ãƒ„ãƒ¼ãƒ«

ãƒªãƒ³ã‚¯é›†
ãƒªãƒ³ã‚¯
http://www.k-brand.gr.jp/20010220.html
hassylin 2008/06/25
CREATE VIEW

Rails

database

Tips
ãƒªãƒ³ã‚¯
Index of /docs/modules/DBIx-Class-0.07006/lib/DBIx/Class/Manual
perldoc.jp Here is perldoc.jp, experimental website for perldocjp project. project info (SourceForge) Project Home (SourceForge) mailig list (FreeML) perldocjp announcement @ Shibuya.pm Tech Talks Name Last modified Size Description Parent Directory 19-Jun-2007 10:00 - Component.pod 14-Jul-2007 10:54 9k Cookbook.pod 14-Jul-2007 10:00 49k Glossary.pod 14-Jul-2007 13:30 4k Intro.pod 14-Jul-200
hassylin 2008/05/28
DBIx perldoc æ—¥æœ¬èªž

CPAN

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

database
ãƒªãƒ³ã‚¯
Perl OR Mappers - nekokak.org
Perl OR Mappers - DBIC / DOD / Fey YAPC::Asia 2008 Tokyo 2008-05-16
hassylin 2008/05/21
Perl

database
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
hassylin 2008/02/20
database
ãƒªãƒ³ã‚¯
ã¾ãã¾ãï¼ - èªã¿ãŸã„ãƒ¡ãƒ«ãƒžã‚¬ã€ãã£ã¨è¦‹ã¤ã‹ã‚‹ã€‚
æºå¸¯ã‚¢ãƒ‰ãƒ¬ã‚¹ã€Gmailã€YahooMailã«ãƒ¡ãƒ«ãƒžã‚¬ãŒå±Šã‹ãªã„å ´åˆ ã“ã¡ã‚‰ã‹ã‚‰å—ä¿¡è¨å®šã‚’ãŠè©¦ã—ãã ã•ã„ã€‚ ã¾ãŸã€è³¼èªæœŸé–“å†…ã®ãƒ¡ãƒ«ãƒžã‚¬(æœ‰æ–™ãƒ»ç„¡æ–™)ã¯ãƒžã‚¤ãƒšãƒ¼ã‚¸ã‹ã‚‰å†é€ã§ãã¾ã™ã€‚ ãƒžã‚¤ãƒšãƒ¼ã‚¸ã‚’ãŠæŒã¡ã§ãªã„æ–¹ã¯ã€æ–°è¦ã«ã”ç™»éŒ²ãã ã•ã„ï¼ â†’informationãƒšãƒ¼ã‚¸ã¸
hassylin 2007/08/07
CPAN

Tips

database
ãƒªãƒ³ã‚¯
Daniel Westermann-Clark / DBIx-Class - search.cpan.org
abraxxa: Alexander Hartmaier acca: Alexander Kuznetsov acme: Leon Brocard aherzog: Adam Herzog Alexander Keusch alexrj: Alessandro Ranellucci alnewkirk: Al Newkirk Altreus: Alastair McGowan-Douglas amiri: Amiri Barksdale amoore: Andrew Moore Andrew Mehta andrewalker: Andre Walker andyg: Andy Grundman ank: Andres Kievsky arc: Aaron Crane arcanez: Justin Hunter ash: Ash Berlin bert: Norbert CsongrÃ¡d
hassylin 2007/08/07
CPAN

database

ä¾¿åˆ©ãƒ„ãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
MySQL AB :: Managing Hierarchical Data in MySQL
"The Documents contained within this site may include statements about Oracle's product development plans. Many factors can materially affect Oracle's product development plans and the nature and timing of future product releases. Accordingly, this Information is provided to you solely for information only, is not a commitment to deliver any material, code, or functionality, and should not be reli
hassylin 2007/08/07
éšŽå±¤æ§‹é€

mysql

database
ãƒªãƒ³ã‚¯
mysql:12071ã€€éšŽå±¤åŒ–ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’MySQLã§æ‰±ã†
From: zen kishimoto <zen kishimoto <zen@xxxxxxxxxx>> Date: Sat, 03 Sep 2005 09:24:15 -0700 Subject: [mysql 12071] éšŽå±¤åŒ–ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’MySQLã§æ‰±ã†ã€€ï¼ˆManaging Hierarchical Data in MySQLï¼‰ http://dev.mysql.com/tech-resources/articles/hierarchical-data.html ï¼ˆå›³ã¯ã“ã®ã‚µã‚¤ãƒˆã‚’å‚ç…§ã®ã“ã¨ï¼‰ Mike Hillyerè‘— åˆã‚ã« å¤šãã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã¯ä¸€å›žãã‚‰ã„ã¯SQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹å†…ã§ã€éšŽå±¤åŒ–ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’ æ‰±ã£ãŸã“ã¨ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ãã®ã¨ãã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ« ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¯éšŽå±¤åŒ–ã—ãŸãƒ‡ãƒ¼ã‚¿ç”¨ã«é–‹ç™ºã•ã‚Œãªã‹ã£ãŸã¨è€ƒãˆãŸã¨æ€ã„ã¾ã™ã€‚ ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ†ãƒ¼ãƒ–ãƒ«ã¯éšŽå±¤åŒ–ã•ã‚Œã¦ãŠã‚‰ãš
hassylin 2007/08/07
éšŽå±¤åŒ–ãƒ„ãƒªãƒ¼

database

mysql
ãƒªãƒ³ã‚¯
http://blog.rapidred.com/articles/2006/06/08/ruby-working-with-trees
hassylin 2007/08/06
DBã§ã®éšŽå±¤æ§‹é€ ã«é–¢ã™ã‚‹è€ƒå¯Ÿ

Rails

ã‚ã¨ã§èª¿ã¹ã‚‹

database
ãƒªãƒ³ã‚¯
actsã€€asã‚’ä½¿ã£ã¦ã¿ã‚ˆã†
acts asã‚’ ä½¿ã£ã¦ã¿ã‚ˆã† è—¤å²¡å²³ä¹‹â€ƒ(xibbar) ã‚¢ã‚¸ã‚§ãƒ³ãƒ€ â€¢ acts as list â€¢ acts as tree â€¢ acts as nested set â€¢ better nested set acts as listã¨ã¯ â€¢ Railsã«æ¨™æº–ã§ã¤ã„ã¦ã„ã‚‹ â€¢ é †åˆ—ã‚’æ‰±ã†ã¨ãã«ä¾¿åˆ© ã©ã†ã‚„ã£ã¦ä½¿ã†ï¼Ÿ â€¢ positionã¨ã„ã†integeråž‹ã®ã‚«ãƒ©ãƒ ã‚’è¿½åŠ â€¢ modelã«acts_as_listã‚’è¿½åŠ class CreateUsers < ActiveRecord::Migration def self.up create_table :users do |t| t.column :name, :string t.column :position, :integer end end def self.down drop_table :users end end c
hassylin 2007/08/06
acts as éšŽå±¤æ§‹é€ ã«é–¢ã—ã¦

Rails

Tips

database
ãƒªãƒ³ã‚¯
Plugins - BetterNestedSet - Agile Web Development
Better nested set This plugin provides an ehanced acts_as_nested_set mixin for ActiveRecord, the object-db mapping layer of the framework RubyOnRails. The original nested set feature seems to be quite old and missed some necessary functionalities. Details This acts provides Nested Set functionality. Nested Set is a smart way to implement an ordered tree, with the added feature that you can select
hassylin 2007/08/06
éšŽå±¤æ§‹é€

Rails

database

plugin
ãƒªãƒ³ã‚¯
Better nested set - ç¦å³¶é¤ƒåRubyè¦ªæ–¹
http://agilewebdevelopment.com/plugins/betternestedset ã“ã“ã«ã‚ã‚Šã¾ã™ã€‚ã©ã†ã„ã†ã‚‚ã®ã‹ã¨ã„ã†ã¨ã€acts_as_nested_setã‚’æ‹¡å¼µã—ã¦ ä¾¿åˆ©ã«ã—ãŸã‚‚ã®ã§ã™ã€‚ acts_as_nested_set + acts_as_tree + ä¾¿åˆ©= better_nested_set ã¨ã„ã£ãŸæ„Ÿã˜ã§ã™ã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³• ./script/plugin install http://opensource.symetrie.com/svn/better_nested_set/trunkãŸã ã€trunkã¨ã„ã†åå‰ã«ãªã‚‹ã®ã§ã€ãƒªãƒãƒ¼ãƒ ã—ãŸæ–¹ãŒã„ã„æ°—ãŒã—ã¾ã™ã€‚ ä½¿ãˆã‚‹ãƒ¡ã‚½ãƒƒãƒ‰ä¸€è¦§ move_to_child_of åˆ¥ã®å ´æ‰€ã«ã¶ã‚‰ä¸‹ã’ã‚‹ move_to_right_ofåˆ¥ã®å ´æ‰€ã«ã¶ã‚‰ä¸‹ã’ã‚‹ move_to_left_ofåˆ¥ã®å ´æ‰€ã«ã¶ã‚‰ä¸‹ã’ã‚‹ root
hassylin 2007/08/06
éšŽå±¤æ§‹é€

Rails

ä¾¿åˆ©ãƒ„ãƒ¼ãƒ«

database
ãƒªãƒ³ã‚¯
Firebirdæ—¥æœ¬ãƒ¦ãƒ¼ã‚¶ãƒ¼ä¼š
Firebirdæ—¥æœ¬ãƒ¦ãƒ¼ã‚¶ãƒ¼ä¼šä¼šå“¡(Mailing Listå‚åŠ è€…)ã¯ã€å”è³›å›£ä½“ä¼šå“¡ã¨ã—ã¦ç”³ã—è¾¼ã‚ã¾ã™ã€‚ ============================================== WebDB Forum 2018 ï¼ˆç¬¬11å›žWebã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹ãƒ•ã‚©ãƒ¼ãƒ©ãƒ ï¼‰ http://db-event.jpn.org/webdbf2018/ æ—¥æ™‚ï¼š2018å¹´9æœˆ12æ—¥ï¼ˆæ°´ï¼‰ã€œ9æœˆ14æ—¥ï¼ˆé‡‘ï¼‰ ä¼šå ´ï¼šæ±äº¬å·¥æ¥å¤§å¦ å¤§å²¡å±±ã‚ãƒ£ãƒ³ãƒ‘ã‚¹ äº‹å‰å‚åŠ ç™»éŒ²ãƒšãƒ¼ã‚¸ï¼š http://db-event.jpn.org/webdbf2018/registration.html äº‹å‰å‚åŠ ç™»éŒ²æœŸé™ï¼š2018å¹´9æœˆ4æ—¥ï¼ˆç«ï¼‰23:59 JST
hassylin 2007/07/31
database
ãƒªãƒ³ã‚¯
1