Rietveld Code Review Tool
Help | Bug tracker | Discussion group | Source code | Sign in
(4)

Issue 331000043: sql scripts for 1.1

Can't Edit
Can't Publish+Mail
Start Review
Created:
1 week, 4 days ago by zhubiwen509
Modified:
6 days, 6 hours ago
Visibility:
Public.

Description

sql scripts for 1.1 Demonstrate that the number of network paths between any two datacenters is finite. The finite number of network paths can be demonstrated via analysis of the frequency of observing new paths between any 2 sampled endpoints (i.e., source and destination datacenters). This study expected to confirm existing work that demonstrates that path popularity is heavily skewed towards a few paths that are used predominantly and extend this earlier work by demonstrating that the same holds true for the private network of a cloud provider. Answer the following questions: For a given pair of source and destination datacenters, how often do we observe a new path that was not seen previously? What can we say about the probability of observing a new path, after considering measurements over 1 hour, 1 day, and 1 week? Are newly encountered paths used frequently? BUG=

Patch Set 1 #

Patch Set 2 : draft solution of task1.2 #

Total comments: 4
Unified diffs Side-by-side diffs Delta from patch set Stats (+27 lines, -0 lines) Patch
A task1_1.sql View 1 chunk +26 lines, -0 lines 2 comments Download
M task1_2.sql View 1 1 chunk +1 line, -0 lines 2 comments Download

Messages

Total messages: 3
zhubiwen509
1 week, 4 days ago (2017-10-10 18:43:09 UTC) #1
Wei Wang
https://codereview.appspot.com/331000043/diff/20001/task1_2.sql File task1_2.sql (right): https://codereview.appspot.com/331000043/diff/20001/task1_2.sql#newcode16 task1_2.sql:16: create table t12 as select e1.id, e1.idPath, e1.idPath src, ...
6 days, 6 hours ago (2017-10-15 22:24:45 UTC) #2
manu_chaud
6 days, 6 hours ago (2017-10-15 22:31:42 UTC) #3
https://codereview.appspot.com/331000043/diff/20001/task1_1.sql
File task1_1.sql (right):

https://codereview.appspot.com/331000043/diff/20001/task1_1.sql#newcode14
task1_1.sql:14: drop procedure if exists wk;
afaik, no need to indent the last two lines?

https://codereview.appspot.com/331000043/diff/20001/task1_1.sql#newcode23
task1_1.sql:23: end $$
indentation doesn't seem even -- this corresponds to the begin statement, I
guess

https://codereview.appspot.com/331000043/diff/20001/task1_2.sql
File task1_2.sql (right):

https://codereview.appspot.com/331000043/diff/20001/task1_2.sql#newcode16
task1_2.sql:16: create table t12 as select e1.id, e1.idPath, e1.idPath src,
e2.idPath dst, e1.time from_time, e2.time to_time, (e2.time -e1.time) as
duration from Table12 e1 INNER JOIN Table12 e2 on e2.id =e1.id +1;
On 2017/10/15 22:24:44, Wei Wang wrote:
> What does "e1" means here? Another table?

This is just an alias for the table named Table12
Sign in to reply to this message.

Powered by Google App Engine
RSS Feeds Recent Issues | This issue
This is Rietveld 80a51fa-tainted