TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Fifty Years of Databases (2012)

45 pointsby yorpover 10 years ago

3 comments

platzover 10 years ago
&quot;the origins of the standard architecture for OLTP, which is row-based, and says it’s no longer optimal for any of the use cases that it is applied to. He proceeds to describe some research he has done, showing that row-based databases spend about 90 percent of their time acquiring and releasing locks, buffer management, and other activities that could be characterized as overhead in comparison to main task of reading and writing data. These results, which in Stonebraker’s view are intrinsic to the row-based architecture, require a new architecture to overcome. The discussion proceeds to a new database architecture, known as “NewSQL” or “NewOLTP,” which is single-threaded, lock-free, doesn’t require disk I&#x2F;O in the critical path, and can scale out to a large multiple node cluster. Stonebraker criticizes the eventual consistency model that some NoSQL distributed systems employ and he defends the ACID guarantees as a superior model.&quot;<p><a href="http://www.se-radio.net/2013/12/episode-199-michael-stonebraker/" rel="nofollow">http:&#x2F;&#x2F;www.se-radio.net&#x2F;2013&#x2F;12&#x2F;episode-199-michael-stonebra...</a>
评论 #8272755 未加载
maxdemarziover 10 years ago
&gt;&gt; In addition, IDS and other network systems encoded what we now think of as the “joins” between different kinds of records as part of the database structure rather than specifying them in each query. --<p>This is basically Neo4j and other graph databases.<p>See: <a href="http://maxdemarzidotcom.files.wordpress.com/2012/08/screen-shot-2012-08-13-at-7-40-20-pm.png" rel="nofollow">http:&#x2F;&#x2F;maxdemarzidotcom.files.wordpress.com&#x2F;2012&#x2F;08&#x2F;screen-s...</a><p>Those &quot;R1&quot;, &quot;R2&quot;s in the picture... those are your &quot;joins&quot;.
taspeotisover 10 years ago
<p><pre><code> IDS: The first NoSQL data store? In 1962 (sigmod.org) 1 point by yorp 3 minutes ago | flag | cached | share | discuss </code></pre> NoSQL doesn&#x27;t appear anywhere on that page. The title should be<p><pre><code> Fifty Years of Databases (2012)</code></pre>
评论 #8272343 未加载
评论 #8272719 未加载