the morning paper | a random walk through Computer Science research, by Adrian Colyer
TLDR; this is the last edition of The Morning Paper for now. Plus: one strand of research you won’t want to miss! I was listening to a BBC Radio 4 podcast recently (More or Less: Behind the Stats - Ants and Algorithms) in which the host Tim Harford is interviewing David Sumpter about his recent ... Continue Reading An overview of end-to-end entity resolution for big data, Christophides et al., ACM
SQLアンãƒãƒ‘ターン
本書ã¯DBè¨è¨ˆã‚„SQL記述ã®éš›ã«é¿ã‘ã‚‹ã¹ã事柄を1ç« ã§1ã¤ã€25個紹介ã™ã‚‹æ›¸ç±ã§ã™ã€‚リレーショナルデータベースをä¸å¿ƒã«æ®ãˆãŸã‚·ã‚¹ãƒ†ãƒ 開発ã«ã¯ã€æ§˜ã€…ãªå ´é¢ã§é™¥ã‚Šã‚„ã™ã„失敗（アンãƒãƒ‘ターン）ãŒã‚ã‚Šã¾ã™ã€‚本書ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è«–ç†è¨è¨ˆã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç‰©ç†è¨è¨ˆã€ã‚¯ã‚¨ãƒªã®è¨˜è¿°ã€ã‚¢ãƒ—リケーション開発ã¨ã„ã†4ã¤ã®ã‚«ãƒ†ã‚´ãƒªã«åˆ†ã‘ã€ãã‚Œãžã‚Œã®åˆ†é‡Žã«ãŠã‘るアンãƒãƒ‘ターンを紹介ã—ã€å¤±æ•—ã‚’é¿ã‘ã‚‹ãŸã‚ã®ã‚ˆã‚Šè‰¯ã„方法を紹介ã—ã¾ã™ã€‚複数ã®å€¤ã‚’æŒã¤å±žæ€§ã‚„å†å¸°çš„ãªãƒ„ãƒªãƒ¼æ§‹é€ ã®æ ¼ç´ã‹ã‚‰ã€å°æ•°å€¤ã®ä¸¸ã‚ã‚„NULLã®æ‰±ã„ã«èµ·å› ã™ã‚‹å•é¡Œã€å…¨æ–‡æ¤œç´¢ã‚„SQLインジェクションã€MVCアーã‚テクãƒãƒ£ãªã©ã€å®Ÿè·µçš„ã‹ã¤å¹…広ã„トピックを網羅ã—ã¾ã™ã€‚日本語版ã§ã¯ã€MySQLã®ã‚¨ã‚スパートã¨ã—ã¦è‘—åãªå¥¥é‡Žå¹¹ä¹Ÿæ°ã«ã‚ˆã‚‹ã‚¢ãƒ³ãƒãƒ‘ターンをåŽéŒ²ã€‚データベースã«é–¢ã‚ã‚‹ã™ã¹ã¦ã®ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢å¿…æºã®ä¸€å†Šã§ã™ã€‚ 本書ã¸ã®ç§°è³›ã®å£° 監訳者ã¾ãˆãŒã ã¯ã˜ã‚ã« I部 データベース論
SQL vs NoSQLã€ã‚°ãƒ¼ã‚°ãƒ«ã«ãŠã‘る戦ã„（後編）。Google I/O 2012
SQLã¨NoSQLã§ã¯ã©ã¡ã‚‰ãŒå„ªã‚Œã¦ã„ã‚‹ã®ã‹ï¼Ÿ グーグルã®æ‹…当者ãŒãƒ‡ã‚£ãƒ™ãƒ¼ãƒˆï¼ˆã¨ã„ã†ã‚ˆã‚Šå°èŠå±…：-）を行ã£ãŸã‚»ãƒƒã‚·ãƒ§ãƒ³ã€ŒGoogle I/O 2012 - SQL vs NoSQL: Battle of the Backends - YouTubeã€ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ （ã“ã®è¨˜äº‹ã¯ã€ŒSQL vs NoSQLã€ã‚°ãƒ¼ã‚°ãƒ«ã«ãŠã‘る戦ã„（å‰ç·¨ï¼‰ã€‚Google I/O 2012ã€ã®ç¶šãã§ã™ï¼‰ スケーラビリティã«ã¤ã„㦠（NoSQL担当）ã‚らゆるé¢ã§ã€ã“ã¡ã‚‰ãŒé«˜ã„スケーラビリティをæä¾›ã—ã¦ã„る。 （SQL担当）ãã‚“ãªè¨³ãªã„ã ã‚。 （NoSQL担当）ãã‚“ãªè¨³ã‚ã‚‹ã•ã€‚ （SQL担当）ã˜ã‚ƒã‚ã¾ãšã€Cloud SQLãŒã©ã†ä½¿ã‚ã‚Œã¦ã„ã‚‹ã‹ç´¹ä»‹ã—よã†ã€‚例ãˆã°ã€Œã‚°ãƒ¼ã‚°ãƒ«orgãƒãƒ£ãƒ¼ãƒˆã€ã€‚グーグルã®3万人ã®å¾“æ¥å“¡ã«ã¤ã„ã¦ã€çµ„織内ã®ã¤ãªãŒã‚Šã‚„仕事を示ã™ã‚¢ãƒ—リケーションã 。 社内ã§ã¯èª°ã‚‚ãŒã“ã®Webサイトを開ã„ã¦ã„ã¦ã€
SQL vs NoSQLã€ã‚°ãƒ¼ã‚°ãƒ«ã«ãŠã‘る戦ã„（å‰ç·¨ï¼‰ã€‚Google I/O 2012
SQLã¨NoSQLã§ã¯ã©ã¡ã‚‰ãŒå„ªã‚Œã¦ã„ã‚‹ã®ã‹ï¼Ÿ グーグルã®æ‹…当者ãŒãƒ‡ã‚£ãƒ™ãƒ¼ãƒˆï¼ˆã¨ã„ã†ã‚ˆã‚Šå°èŠå±…：-）を行ã£ãŸã‚»ãƒƒã‚·ãƒ§ãƒ³ã€ŒGoogle I/O 2012 - SQL vs NoSQL: Battle of the Backends - YouTubeã€ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã¯ã€å…ˆã€…週開催ã•ã‚ŒãŸGoogle I/O 2012ã§è¡Œã‚ã‚ŒãŸã‚‚ã®ã€‚SQLã¨NoSQLã«ã¯æ©Ÿèƒ½çš„ã«ã©ã®ã‚ˆã†ãªé•ã„ãŒã‚ã‚Šã€ã©ã†ä½¿ã„分ã‘ã‚‹ã¹ããªã®ã‹ã€æ˜Žç¢ºãªèª¬æ˜ŽãŒå‚考ã«ãªã‚Šã¾ã™ã€‚ ãƒã‚¤ãƒ©ã‚¤ãƒˆã‚’紹介ã—ã¾ã—ょã†ã€‚ クラウドã«ãŠã‘るデータベースã®ãƒ¡ãƒªãƒƒãƒˆ グーグルã®Alfred Fulleræ°ï¼ˆNoSQL担当）。 クラウドã¯ãƒ•ã‚©ãƒ«ãƒˆãƒˆãƒ¬ãƒ©ãƒ³ãƒˆã§ãƒ¡ãƒ³ãƒ†ãƒŠãƒ³ã‚¹ä¸è¦ã€ãƒ‘ッãƒã‚‚ç§ãŸã¡ãŒé©ç”¨ã—ã¦ãŠã‚Šã€åˆ©ç”¨è€…ã¯é‹ç”¨ã«ã¤ã„ã¦å¿ƒé…ã™ã‚‹å¿…è¦ãŒãªã„ã€ã¨ã„ã£ãŸãƒ¡ãƒªãƒƒãƒˆãŒã‚る。 データã®ãƒ¬ãƒ—リケーションや地域分散ã§ãƒ‡ãƒ¼ã‚¿ã‚‚ä¿å…¨ã•ã‚Œã€ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒ
SQL.js: SQLite Compiled to JavaScript via...
Badass JavaScriptA showcase of awesome JavaScript that pushes the boundaries of what's possible on the web, by @devongovett. Alon Zakai, the creator of Emscripten is back at it again, this time releasing SQL.js, which is a compilation of SQLite to JavaScript using his own tool.  The demo page shows it in use, and if you view source, just how easy he’s made it to use after it has been compiled. var
SQLã¨JSONã‚’Node.js上ã§çµ„ã¿åˆã‚ã›ãŸæ–°è¨€èªžã€Œql.ioã€ã‚’eBayãŒå…¬é–‹
eBayãŒã€JavaScriptアプリケーションã‹ã‚‰SQLæ–‡ã®ã‚ˆã†ãªå½¢å¼ã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®å•ã„åˆã‚ã›ã‚’記述ã§ãã‚‹DSL（ドメイン固有言語）ã®ql.ioを発表。オープンソースã¨ã—ã¦å…¬é–‹ã—ã¾ã—ãŸã€‚ ç¾åœ¨ã€å¤šãã®WebアプリケーションãŒã€ãƒãƒƒã‚¯ã‚¨ãƒ³ãƒ‰ã¨ã®ãƒ‡ãƒ¼ã‚¿ã®ã‚„ã‚Šã¨ã‚Šã«HTTPをベースã«ã—ãŸAPIを用ã„ã¦ã„ã¾ã™ã€‚ã—ã‹ã—ã€Webベースã®APIã«ã‚ˆã£ã¦ãƒ‡ãƒ¼ã‚¿ã‚’å–り出ã™ã®ã¯ã€ãƒ—ãƒã‚°ãƒ©ãƒžã«ã¨ã£ã¦å®Ÿã¯æ‰‹é–“ã®ã‹ã‹ã‚‹ã“ã¨ã§ã™ã€‚ 例ãˆã°ã€ã‚ーワードを入力ã™ã‚‹ã¨é–¢é€£ã™ã‚‹å•†å“ã®åå‰ã€è©³ç´°ã€è³¼å…¥è€…ã®è©•ä¾¡ã‚’ユーザーã«è¡¨ç¤ºã™ã‚‹ã€ã¨ã„ã†Webアプリケーションã§ã¯ã€ã¾ãšã‚ーワードã§ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’検索ã—ã¦å•†å“IDã‚’å–å¾—ã—ã€ä»Šåº¦ã¯ãã®å•†å“IDã‚’ã‚ーã«ã—ã¦åå‰ã‚„概è¦ã€è©•ä¾¡ã®æƒ…å ±ã‚’å–å¾—ã™ã‚‹ã€ã¨ã„ã£ãŸã‚ˆã†ã«ã€APIã‚’ç¹°ã‚Šè¿”ã—呼ã³å‡ºã™å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ql.ioã¯ã“ã†ã—ãŸå†…容をSQLã®ã‚ˆã†ã«åˆ†ã‹ã‚Šã‚„ã™ã„記述ã§å®Ÿç¾ã™ã‚‹ã ã‘ã§ãªãã€è¤‡æ•°ã®
Mozilla Japan - Firefox 用アドオン
Wired-Marker ページ上ã®è¨˜äº‹ã‚„図表ã«ãƒžãƒ¼ã‚«ãƒ¼ã‚’引ãã“ã¨ãŒã§ãã¾ã™ã€‚マーカーã¯ãƒ–ックマークã¨ã—ã¦ã‚‚機能ã—ã€ç›®çš„ã®æƒ…å ±ã«ã™ã°ã‚„ãアクセスã§ãã¾ã™ã€‚マークã—ãŸæƒ…å ±ã¯ãƒ¡ãƒ¢ã‚’åŠ ãˆã¦æ•´ç†ã—ãŸã‚Šã€ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã™ã‚‹ã“ã¨ã‚‚ã§ãã¾ã™ã€‚ AutoPager Google ã®æ¤œç´¢çµæžœãªã©ã§ã€æ¬¡ã®ãƒšãƒ¼ã‚¸ã‚’自動的ã«èªã¿è¾¼ã‚“ã§ã€ç¾åœ¨è¡¨ç¤ºã—ã¦ã„るページã®æœ«å°¾ã«è¿½åŠ ã—ã¾ã™ã€‚幅広ã„サイトã«å¯¾å¿œã—ãŸè¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã¯è‡ªå‹•çš„ã«ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã€æ›´æ–°ã•ã‚Œã¾ã™ã€‚
Apache Jena - Home
RDF API Interact with the core API to create and read Resource Description Framework (RDF) graphs. Serialise your triples using popular formats such as RDF/XML or Turtle. ARQ (SPARQL) Query your RDF data using ARQ, a SPARQL 1.1 compliant engine. ARQ supports remote federated queries and free text search.
RDF STORE DATABASE DESIGN FOR FASTER ... - Google Patent Search
Application number: 11/945,105 Publication number: US 2009/0138498 A1 Filing date: Nov 26, 2007 RDF store database designs and efficient techniques for converting SPARQL queries to SQL queries are described that provide faster triplet access, and which can reduce the computational overhead and cost associated with storing large volumes of RDF metadata. In various embodiments RDF data can be... W
HTMLã‚’DBã¿ãŸã„ã«ä½¿ãˆã‚‹ã‚¹ã‚´ã‚¤ãƒ©ã‚¤ãƒ–ラリ『htmlSqlã€ã‚’ CakePHPã§ä½¿ã† - h2ospace - builder by ZDNet Japan
APIã‚„RSSãªã©ã‚’æä¾›ã—ã¦ã„るサイトã¯ã€æƒ…å ±ã‚’ç°¡å˜ã«æ‰±ã†ã“ã¨ãŒã§ãã¾ã™ãŒã€ä¾‹ãˆã° Yahoo!ã®æ¤œç´¢çµæžœã¨ã‹ã€mixiã®ãƒ‹ãƒ¥ãƒ¼ã‚¹ã¨ã‹ã€ã‚るサイトã®ä¸€éƒ¨ã‚’å–り出ã—ãŸã„ã“ã¨ã£ã¦ã‚ˆãã‚ã‚Šã¾ã™ã€‚（ã¨ã¯ã„ãˆã€è‘—作権é•åã«ã¯æ³¨æ„ ãã‚“ãªæ™‚ã€PHPã®ãƒ©ã‚¤ãƒ–ラリã§ã‚る「htmlSqlã€ã‚’利用ã™ã‚‹ã¨ä¾¿åˆ©ã€‚ã“ã®ãƒ©ã‚¤ãƒ–ラリã«ã€ãƒ•ã‚¡ã‚¤ãƒ«ã§ã‚‚URLã§ã‚‚æ–‡å—列ã§ã‚‚ã€HTMLã§ä½œã‚‰ã‚ŒãŸã‚‚ã®ãªã‚‰ä½•ã§ã‚‚与ãˆã‚‹ã¨ã€è§£æžã—ã¦å–り出ã—ã‚„ã™ãã—ã¦ãã‚Œã¾ã™ã€‚ã—ã‹ã‚‚ã€ãã®å–り出ã—æ–¹ã¯SQLï¼ ä¾‹ãˆã°ã€ã€Œid属性ãŒâ€™test’㮠pè¦ç´ ã®å†…容をå–り出ã—ãŸã„ã€ã¨ã„ã†å ´åˆã«ã¯ã€æ¬¡ã®ã‚ˆã†ãªSQLを使ã„ã¾ã™ã€‚ SELECT text FROM p WHERE $id=="test" 超パワフル。ã¨ã„ã†ã“ã¨ã§ã€ã“れを CakePHPã§åˆ©ç”¨ã™ã‚‹ãŸã‚ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã€‚ ã¾ãšã¯ã€ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸãƒ•ã‚¡ã‚¤ãƒ«ã®ä¸ã‹ã‚‰æ¬¡ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’「app/vendorsã€ãƒ•ã‚©
Web SQL Database
W3C Working Group Note 18 November 2010 This Version: http://www.w3.org/TR/2010/NOTE-webdatabase-20101118/ Latest Published Version: http://www.w3.org/TR/webdatabase/ Latest Editor's Draft: http://dev.w3.org/html5/webdatabase/ Previous Versions: http://www.w3.org/TR/2009/WD-webdatabase-20091222/ http://www.w3.org/TR/2009/WD-webdatabase-20091029/ http://www.w3.org/TR/2009/WD-webstorage-20090423/ Ed
HTML5 Web Storage and SQL at Vladimir Vukićević
There's been a lot of interest around the Web Storage spec (formerly part of whatwg HTML5), which exposes a SQL database to web applications to use for data storage, both for online and offline use. It presents a simple API designed for executing SQL statements and reading result rows. But there's an interesting problem with this; unlike the rest of the HtML5, this section defines a core piece o
Internet Evolution - Ron Miller - Developers Pile On After Jobs Android Attack
TechTarget and Informa Tech’s Digital Business Combine.TechTarget and Informa TechTarget and Informa Tech’s Digital Business Combine.Together, we power an unparalleled network of 220+ online properties covering 10,000+ granular topics, serving an audience of 50+ million professionals with original, objective content from trusted sources. We help you gain critical insights and make more informed de
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データベース内ã§ã€éšŽå±¤åŒ–ã—ãŸãƒ‡ãƒ¼ã‚¿ã‚’ 扱ã£ãŸã“ã¨ãŒã‚ã‚‹ã¨æ€ã„ã¾ã™ã€‚ãã®ã¨ãã¯ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ« データベースã¯éšŽå±¤åŒ–ã—ãŸãƒ‡ãƒ¼ã‚¿ç”¨ã«é–‹ç™ºã•ã‚Œãªã‹ã£ãŸã¨è€ƒãˆãŸã¨æ€ã„ã¾ã™ã€‚ リレーショナルデータベースã®ãƒ†ãƒ¼ãƒ–ルã¯éšŽå±¤åŒ–ã•ã‚Œã¦ãŠã‚‰ãš
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
EQL: What Happens When SPARQL Meets SQL - DATAVERSITY
FQL - ドã‚ュメンテーション - Facebook for Developers
Amazon.co.jp: アート・オブ・SQL ―パフォーマンスを引ã出ã™SQLプãƒã‚°ãƒ©ãƒŸãƒ³ã‚°æ‰‹æ³• (Theory in practice): Stephane Faroult (è‘—), Peter Robson (è‘—), 木下哲也 (翻訳), 有é™ä¼šç¤¾ç¦é¾èˆˆæ¥ (翻訳): 本
Amazon.co.jp: Joe Celko's Trees and Hierarchies in SQL for Smarties (The Morgan Kaufmann Series in Data Management Systems): Celko, Joe: 本
Amazon.co.jp: Joe Celko's SQL Programming Style: Celko, Joe: 本
Amazon.co.jp: Joe Celko's SQL for Smarties: Advanced SQL Programming (The Morgan Kaufmann Series in Data Management Systems): Celko, Joe: 本
{{#tags}}- {{label}}
{{/tags}}