RDBMS Genealogy
Our group includes PostDocs, PhD students, and student assistants, and is headed by Prof. Felix Naumann. If you are interested in joining our team, please contact Felix Naumann. For bachelor students we offer German lectures on database systems in addition to paper- or project-oriented seminars. Within a one-year bachelor project, students finalize their studies in cooperation with external partne
Browse by Tags - Craig Freedman's SQL Server Blog - Site Home - MSDN Blogs
Archived MSDN and TechNet Blogs 2/7/2020 2 minutes to read MSDN and TechNet blog sites have been retired, and blog content has been migrated and archived here. Archived blogs are grouped alphabetically by the initial letter of the blog name. Blogs and blog posts can be searched by their names, using the Search box at the top of the page. Actively updated blogs have been moved to other blog sites,
Exploring the Software Behind Facebook, the World's Largest Social Media Site - Pingdom
At the scale that Facebook operates, several traditional approaches to serving web content break down or simply aren’t practical. The challenge for Facebook’s engineers has been to keep the site up and running smoothly in spite of handling over two billion active users. This article takes a look at some of the software and techniques they use to accomplish that. Facebook’s Scaling Challenge Before
SQL Databases v. NoSQL Databases – Communications of the ACM
The Communications Web site, http://cacm.acm.org, features more than a dozen bloggers in the BLOG@CACM community. In each issue of Communications, we'll publish excerpts from selected posts. twitter Follow us on Twitter at http://twitter.com/blogCACM Michael Stonebraker considers several performance arguments in favor of NoSQL databases�and finds them insufficient. http://cacm.acm.org/blogs/blog-c
PostgreSQLã®æ©Ÿèƒ½ã¨ä»–ã®RDBMSã®æ¯”較 | Let's POSTGRES
å…¨ã¦ã®æ©Ÿèƒ½ã‚’網羅ã—ãŸè¡¨ã§ã¯ã‚ã‚Šã¾ã›ã‚“ãŒã€PostgreSQL㌠Oracle Database ã¨åŒæ§˜ã®æ©Ÿèƒ½ãŒã‚ã‚‹ã“ã¨ãŒãŠåˆ†ã‹ã‚Šã„ãŸã ã‘ã‚‹ã§ã—ょã†ã€‚レプリケーションやクラスタリングãªã©ã¯ã€PostgreSQL本体ã¨ã¯åˆ¥ã«ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã‚‹ã‚µãƒ¼ãƒ‰ãƒ‘ーティーã§ã®æä¾›ã¨ãªã‚Šã¾ã™ãŒã€pgpool-II, Slony-I ã‚’ã¯ã˜ã‚ã¨ã—ãŸå®Ÿç¸¾ã‚‚豊富ãªã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ãŒæä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚ PostgreSQLãŒç‰¹ã«å¼·ã¿ã‚’発æ®ã™ã‚‹åˆ†é‡Žã¨ã—ã¦ã€æœ€å¾Œã®è¡Œã«è¨˜è¼‰ã—ãŸGIS (地ç†æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ ) ãŒã‚ã‚Šã¾ã™ã€‚GISã¯ä½ç½®ã«é–¢ã™ã‚‹æƒ…å ±ã‚’æŒã£ãŸãƒ‡ãƒ¼ã‚¿ (空間データ) を管ç†ã—ã€ä¸»ã«åœ°å›³ã¨çµ„ã¿åˆã‚ã›ã¦ä½ç½®ã‚’表示ã€æ¤œç´¢ã€åˆ†æžã™ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã§ã™ã€‚PostgreSQLã§ã¯ã€PostGIS ã¨ã„ã†ã‚µãƒ¼ãƒ‰ãƒ‘ーティーソフトウェアã§ã€GISオブジェクトをデータベースã«æ ¼ç´ã—空間データã«é©ã—ãŸæ¤œç´¢ã‚’è¡Œã†ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¨ã€GISオブジェクトを解æžã™
ãƒã‚¤ã‚¦ã‚©ãƒ¼ã‚¿ãƒžãƒ¼ã‚¯ - オラクル・Oracleをマスターã™ã‚‹ãŸã‚ã®åŸºæœ¬ã¨ä»•çµ„ã¿
ãƒã‚¤ã‚¦ã‚©ãƒ¼ã‚¿ãƒžãƒ¼ã‚¯ã¨ã¯ ãƒã‚¤ã‚¦ã‚©ãƒ¼ã‚¿ãƒžãƒ¼ã‚¯ã¨ã¯ã€ãƒ†ãƒ¼ãƒ–ルスペースやセグメント (テーブルãªã©ã®ã‚¹ã‚ーマ・オブジェクト) ã”ã¨ã«è¨ç½®ã•ã‚Œã‚‹æŒ‡æ¨™ã§ã‚る。 HWM ã¨ç•¥ã—ã¦æ›¸ã‹ã‚Œã‚‹ã“ã¨ã‚‚ã‚る。 .. High-Water Mark ⇔ (å·ãªã©ã«ã‚る目盛りã®ã‚る白ã„棒)高水ä½æ¨™ 特徴 ç¾åœ¨ã¾ã§ã«æœ€é«˜ã§ã€ã©ã“ã¾ã§ä½¿ç”¨æ¸ˆã«ãªã£ãŸã“ã¨ãŒã‚ã‚‹ã‹ã‚’ã‚らã‚ã™ã€‚ 「使用済ã€ã®æœ€çµ‚ブãƒãƒƒã‚¯ã®ä½ç½®ã‚’指ã™ã€‚ HWM ãŒè¡¨ã®ç²å¾—ã—ã¦ã„ã‚‹é ˜åŸŸã®æœ€å¤§å€¤ã‚’超ãˆã‚‹ã¨æ–°ã—ã„エクステントを調é”ã™ã‚‹ã€‚ SQL ã® DELETE ã§ã¯ HWM ã¯ä¸‹é™ã—ãªã„。 TRUNCATE TABLE(DDL) 㯠HWM をリセットã™ã‚‹ã€‚ データã®å‰Šé™¤ã‚’ã¨ã‚‚ãªã‚ãªã„ HWM ã®ç¸®é€€æ“作㯠ALTER TABLE ã«ã¦è¡Œãªã†ã€‚ ⇒ ãƒã‚¤ã‚¦ã‚©ãƒ¼ã‚¿ãƒžãƒ¼ã‚¯ã®æ“作方法
ã‚ã„ã‚€ã®ç妄想ページ　〜ã®ã®ã‚ューブ　〜Oracle FAQ集
Oracleã¯ã€ã‚»ã‚°ãƒ¡ãƒ³ãƒˆãƒ˜ãƒƒãƒ€ãƒ¼ã«HWM（High Water Mark：高水ä½æ¨™ï¼‰ã¨å‘¼ã°ã‚Œã‚‹ã€ŒéŽåŽ»ã«è¡¨ã®ãƒ–ãƒãƒƒã‚¯ã‚’ã©ã“ã¾ã§ä½¿ç”¨ã—ãŸã‹ã‚’示ã™ãƒã‚¤ãƒ³ã‚¿ã€ã‚’æŒã¤ã€‚データã®æœ‰ç„¡ã«é–¢ã‚らãšã€å…¨è¡¨æ“作時ã«ã¯HWMã¾ã§ã®ã™ã¹ã¦ã®ãƒ–ãƒãƒƒã‚¯ã‚’èªã¿è¾¼ã‚€ã€‚例ãˆã°ã€å¹´åº¦æœ«å‡¦ç†ãªã©ã§ãƒ‡ãƒ¼ã‚¿é‡ãŒä¸€æ™‚çš„ã«å¤§ããå¢—åŠ ã—ã€ãã®å¾Œå°‘ãªã„データé‡ã«æˆ»ã‚‹è¡¨ã‚’考ãˆã‚‹ã€‚ã“ã®ã‚ˆã†ãªè¡¨ã¯ã€ãƒ‡ãƒ¼ã‚¿ãŒå‰Šé™¤ã•ã‚Œä»¶æ•°ãŒå°‘ãªããªã£ãŸå¾Œã‚‚ã€å…¨è¡¨æ“作時ã«ã¯HWMã¾ã§ã®ã™ã¹ã¦ã®ãƒ–ãƒãƒƒã‚¯ãŒèªã¿è¾¼ã¾ã‚Œã¦ã—ã¾ã„ã€å‡¦ç†ãŒé…ããªã‚‹ã€‚HWMã¯ã€è¡¨ã®å†ä½œæˆã€ã‚‚ã—ãã¯TRUNCATE処ç†ã‚’è¡Œã‚ãªã„é™ã‚Šã€å†è¨å®šã•ã‚Œãªã„。
SSD ã¨ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã®å°†æ¥ - kazuhoã®ãƒ¡ãƒ¢ç½®ãå ´
SQL ã«ç—›ç—’æ„Ÿã‚’æ„Ÿã˜ã‚‹æ—¥ã€…ã‚’éŽã”ã—ã¦ã„る身ã¨ã—ã¦ã¯ã€RDBMS ãŒãƒ¬ã‚¬ã‚·ãƒ¼ã ã¨ã„ã†ã®ã¯ã€ã¾ã£ãŸãåŒæ„Ÿã§ã™ãŒã€‚ SSDã‚’å‰æã«ã—ãŸãƒ—ãƒã‚°ãƒ©ãƒ モデルã«ãªã‚Œã°ã€ãã‚‚ãもシーク時間ã¨æˆ¦ã†ã“ã¨ã‚‚ãªãã€ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’æ„è˜ã›ãšã«ãƒ—ãƒã‚°ãƒ©ãƒ ãŒçµ„ã‚ã¾ã™ã€‚ãã†ãªã£ãŸã¨ãã€ã‚¢ãƒ—リケーションã®ãƒ‡ãƒ¼ã‚¿ã‚’永続化ã™ã‚‹ãŸã‚ã«RDBMSã‚’ã‚ã–ã‚ã–使ã†ã“ã¨ã¯ãªã„ã§ã—ょã†ã€‚ 2008-12-12 ãã‚“ãªã“ã¨ãªã„ã¨æ€ã„ã¾ã™ã€‚ç†ç”±ã¯ä»¥ä¸‹ã®ï¼’点。 フラッシュã®æ›¸ãæ›ãˆãƒ–ãƒãƒƒã‚¯ã‚µã‚¤ã‚ºã¯æ•°ã‚ãƒãƒã‚¤ãƒˆä»¥ä¸Š トランザクションã¯æ„è˜ã—ã¦å®Ÿè£…ã›ã–ã‚‹ã‚’å¾—ãªã„ フラッシュメモリã¯ãƒ©ãƒ³ãƒ€ãƒ リードã§ãã¾ã™ãŒã€DRAM ã®ã‚ˆã†ã«ãƒ©ãƒ³ãƒ€ãƒ ライトã§ãã‚‹ã‚ã‘ã§ã¯ã‚ã‚Šã¾ã›ã‚“。書ãè¾¼ã¿ãŒéžå¸¸ã«é…ã„ã®ã«åŠ ãˆã¦æ›¸ãæ›ãˆå›žæ•°ã®åˆ¶é™ã‚‚ã‚ã‚‹ã®ã§ã€ãƒ¡ã‚¤ãƒ³ãƒ¡ãƒ¢ãƒªã¨åŒæ§˜ã®ãƒ—ãƒã‚°ãƒ©ãƒ 手法を使ã†ã®ã¯é›£ã—ã„ã¨æ€ã„ã¾ã™ã€‚ 次ã«ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã«ã¤ã„ã¦ã§ã™ãŒã€çµ„ã¿è¾¼ã¿åž‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦
「RDBMSã®æ™‚代ã®çµ‚ã‚ã‚ŠãŒè¦‹ãˆã¦ããŸã€ã«ã¤ã„ã¦ãã‚ãã‚一言言ã£ã¦ãŠãã‹ - ã²ãŒã‚„ã™ã‚’技術ブãƒã‚°
2008-12-12 ã„ãã¤ã‹èª¤è§£ã‚’生ã¿ãã†ãªè¡¨ç¾ãŒã‚ã‚‹ã®ã§ã€ãれをã¾ãšã¯æŒ‡æ‘˜ã—ã¾ã—ょã†ã€‚ プãƒã‚°ãƒ©ãƒ モデルã¨ã—ã¦ã¯ã€ã™ã§ã«RDBMSã‹ã‚‰ã®è„±å´ã®æº–å‚™ã¯å§‹ã¾ã£ã¦ã„ã¾ã™ã€‚ORマッピングãŒãã‚Œã§ã™ã€‚ ã“ã‚ŒãŒã€æ„図的ã‹ã¯ã‚ã‹ã‚‰ãªã„ã‘ã©ã€ãƒŸã‚¹ãƒªãƒ¼ãƒ‰ã‚’生んã§ã„ã¾ã™ã€‚「RDBMSã®æ™‚代ã®çµ‚ã‚ã‚ŠãŒè¦‹ãˆã¦ããŸã€ã¨ã„ã†ã‚¿ã‚¤ãƒˆãƒ«ã§ã€ã“ã†ã„ã†æ›¸ã方をã™ã‚‹ã¨ã€ã€ŒORマッピングã«ã‚ˆã£ã¦ã€ã™ã§ã«RDBMSã‹ã‚‰ã®è„±å´ã®æº–å‚™ã¯å§‹ã¾ã£ã¦ã„ã‚‹ã€ã¨ã„ã†é¢¨ã«èªã‚ã‚‹ã§ã—ょã†ã€‚ã“ã‚ŒãŒã€ãƒŸã‚¹ãƒªãƒ¼ãƒ‰ã€‚ JPAãŒå¤§åˆ‡ã ã¨æ€ã£ã¦ã„ã‚‹ã®ã¯ã€æ°¸ç¶šãƒ‘ラダイムã®è»¢æ›ã«ã€ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’変ãˆã‚‹ã“ã¨ãªã対応ã§ãã‚‹ã‹ã‚‰ã§ã™ã€‚ã‚‚ã¡ã‚ã‚“JPA+RDBMSã®ã‚·ã‚¹ãƒ†ãƒ ã‚’JPA+éžRDBMSã«åˆ‡ã‚Šæ›¿ãˆã‚Œã‚‹ã¨ã„ã†è©±ã§ã¯ãªãã€ãƒ—ãƒã‚°ãƒ©ãƒžã®ã‚³ãƒ¼ãƒ‰ã®æ›¸ãæ–¹ã®å¯¾å¿œã®è©±ã§ã™ã€‚ ã“れをもã†å°‘ã—ã€å™›ã¿ç •ãã¨ã€JPAã®JPQL(SQLã‚‚ã©ã)を使ãˆã°ã€SQLã¨ã—ã¦ã¯çµ±ä¸€ã•ã‚Œã¦ã„ãªã„複
ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— クãƒãƒ‹ã‚¯ãƒ«
ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— クãƒãƒ‹ã‚¯ãƒ«
RDBMSã®æ™‚代ã®çµ‚ã‚ã‚ŠãŒè¦‹ãˆã¦ã㟠- ãã—ã ã®ã¯ã¦ãª
クラウドã¨ä¸€ç·’ã«ã‚„ã£ã¦ããŸã‚‚㮠最近ã€ã‚¯ãƒ©ã‚¦ãƒ‰ãŒæµè¡Œã£ã¦ã¾ã™ã€‚ Googleã®MapResuceã‹ã‚‰å§‹ã¾ã£ã¦ã€Microsoftã®Azureã¾ã§ã€å¤§æ‰‹ã®ã‚¯ãƒ©ã‚¦ãƒ‰è£½å“ãŒå‡ºæƒã£ãŸæ„Ÿã˜ã€‚ ã§ã€ãã“ã§ã€ã“ã‚“ãªã‚¯ãƒ©ã‚¦ãƒ‰è£½å“ãŒå‡ºã¾ã—ãŸã¨ã„ã†ã¨ãã«ã€å¿…ãšã¨ã„ã£ã¦ã„ã„ã»ã©ãã®ã‚¯ãƒ©ã‚¦ãƒ‰ç”¨ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®èª¬æ˜ŽãŒã‚ã‚Šã¾ã™ã€‚ãã—ã¦ã€ãã‚Œã¯RDBMSã§ã¯ã‚ã‚Šã¾ã›ã‚“。 Googleã ã¨BigTableã€Microsoftã ã¨SQL Data Servicesã€ã‚ã¨ã¯Amazonã®SimpleDB。ã©ã‚Œã‚‚ã€åŸºæœ¬çš„ã«ã¯ã²ã¨ã¤ã®ãƒ†ãƒ¼ãƒ–ルã«ãƒãƒƒã‚·ãƒ¥ã‚³ãƒ¼ãƒ‰ã§ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ ã»ã‹ã®ã‚¯ãƒ©ã‚¦ãƒ‰è£½å“ã‚‚ã€Oracle Coherenceã ã£ãŸã‚Šã€æ¥½å¤©ã®Romaã ã£ãŸã‚Šã€éžRDBMSã®ãƒ‡ãƒ¼ã‚¿ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚’æä¾›ã—ã¾ã™ã€‚ クラウドã¨ã„ã†ã‚ã‘ã§ã¯ãªã„ã‘ã©ã€mixiã®Tokyo Tyrantã‚„Apache CouchDBã‚‚ã€RDB
ウェブリブãƒã‚°ï¼šã‚µãƒ¼ãƒ“スã¯çµ‚了ã—ã¾ã—ãŸã€‚
「ウェブリブãƒã‚°ã€ã¯ 2023å¹´1月31æ—¥ ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“スæ供を終了ã„ãŸã—ã¾ã—ãŸã€‚ 2004å¹´3月ã®ã‚µãƒ¼ãƒ“ス開始より19å¹´è¿‘ãã‚‚ã®é–“ã€æ²¢å±±ã®çš†ã•ã¾ã«ã”愛用ã„ãŸã ãã¾ã—ãŸã“ã¨ã‚’心よりãŠç¤¼ç”³ã—上ã’ã¾ã™ã€‚今後ã¨ã‚‚ã€BIGLOBEã‚’ã”愛顧賜りã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„申ã—上ã’ã¾ã™ã€‚ ※引ã£è¶Šã—先ブãƒã‚°ã¸ã®ãƒªãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆã‚µãƒ¼ãƒ“スã¯2024å¹´1月31æ—¥ã§çµ‚了ã„ãŸã—ã¾ã—ãŸã€‚ BIGLOBEã®ã‚µãƒ¼ãƒ“ス一覧
1
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
VoltDB: Next Generation OLTP Database
http://otndnld.oracle.co.jp/deploy/maintenance/pdf/know_hwm.pdf
Welcome to simpledbm.org
http://qdbm.sourceforge.net/mikio/rbbs.cgi?id=RA11439825461275735795
{{#tags}}- {{label}}
{{/tags}}