TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

F1: A Distributed SQL Database That Scales

131 点作者 alec超过 11 年前

4 条评论

jacques_chester超过 11 年前
Impressive, as one might expect. Some reactions:<p>-- Secret sauce<p>A lot of the magic of F1 comes from Spanner, the distributed storage system. The name &quot;F1&quot; itself is an allusion to &quot;inheriting&quot; some of the properties of Spanner.<p>-- Hierarchical tables<p>What they call hierarchical tables, I would think best be viewed as one-to-many relationships. In guess they&#x27;ve privileged this model in their storage because that&#x27;s what a lot of their AdWords schema looks like.<p>-- Change History<p>I like the observation that keeping full histories is relatively straightforward with atomic, granular timestamping and indeed that it should be baked in. Every database schema I&#x27;ve ever worked with always goes through a similar evolutionary cycle:<p>1. We only need to capture the current state of the model.<p>2. Wait, we do need to capture historical states of the model.<p>3. Wait, the model is changed, we need to capture historical states and the models that were current.<p>(You can think of this as taking progressive differentials of incoming transactions).<p>The F1 designers have baked that right into the database, where it belongs. Weak temporal support has long been the sore point in SQL.<p>-- Remote data<p>I was struck by their observation that most database storage engines are built around the concept of seeks and reads, whereas theirs is necessarily built around batching and pipelining over a network. If I am reading them correctly, their engine takes advantage of having multiple copies of data by sending reads to multiple disk nodes and then working from the first copy that is returned.
评论 #6287921 未加载
评论 #6287933 未加载
评论 #6287984 未加载
fintler超过 11 年前
I posted this question on StackOverflow regarding TrueTime (used by Spanner) a few days ago and haven&#x27;t received any responses:<p>&lt;<a href="http://stackoverflow.com/questions/18384883/why-is-googles-truetime-api-hard-to-duplicate&gt;" rel="nofollow">http:&#x2F;&#x2F;stackoverflow.com&#x2F;questions&#x2F;18384883&#x2F;why-is-googles-t...</a><p>However, I think this HN thread seems like it might be a good place to get comments on why my line of reasoning may be incorrect. Does anyone have any thoughts on why building something like Spanner on top of basic Paxos quorums and NTP would be a bad idea?
评论 #6287739 未加载
capkutay超过 11 年前
Can someone enlighten me as to why google doesn&#x27;t want to make an enterprise play? Many companies tout that they are offering data infrastructures similar to those used at google..why wouldn&#x27;t google commercialize that technology themselves? It should be pretty obvious as to how that could be of huge financial benefit to the company.
评论 #6290057 未加载
dvliman超过 11 年前
This is not new by any mean...
评论 #6287073 未加载
评论 #6287554 未加载