g***l
发帖数: 18555 | 1 sys.sp_replmonitorrefreshagentdata老在RECOMPILE，REPLICATION是从2005到2008
PUSH。现在RECOMPILE是25RECOMPILES/SEC PROCEDURE HIT RATE只有60% |
|
z***y
发帖数: 7151 | 2 这个不奇怪啊。
你可以看一看那个procedure, 你看里面有几个对temp table 的改变， 这些数据的改
变都会触发
recompilation。
我这个版本是2008 SP2的。
create procedure sys.sp_replmonitorrefreshagentdata
as
begin
set nocount on
declare @retcode int
,@agent_id int
,@agent_id2 int
,@publisher_id int
,@xact_seqno varbinary(16)
,@logreader_latency int
,@publisher_db sysname
,@publication sysname
-- security check
-- Has to b... 阅读全帖 |
|
|
m******y
发帖数: 588 | 4 我要replicate到两个server, 一个做redundancy on another data center, 一个作为
data warehouse 的data source, 这样用单独的distributor好吧？ 现在我放在
publisher server上，觉得在加一个subsciber的话还是放在单独的好。 |
|
m******y
发帖数: 588 | 5 谢谢建议。 就打算这么做了。重新build一个distributor, reset up replication. |
|
s**********o
发帖数: 14359 | 6 都需要在SAME DOMAIN里，DATA走INTERNET，还REALTIME不可能吧，
看个MOVIE还一愣一愣的呢，再说就是没有数据变化你也要有
DEDICATED带宽才行，否则员工看了个电影，数据就DELAY了。
我看你这个得用个LOG SHIPPING+FTP，不能保证REALTIME，
其实最简单的办法弄个VPN弄到一个DOMAIN里不就行了，
REPLICATION，但是INTERNET一断，DATA OUT OF SYNC，
需要重新初始化。想省钱不弄自己的DOMAIN总是付出代价的。 |
|
i****a
发帖数: 36252 | 7 am I reading it right that you need to be able to update both sides? so are
you
you can cross mirroring off the list because the mirrored DB is read-only.
you'll need to replicate data both ways, from satellite servers to centeral,
and from central to satellite.
http://msdn.microsoft.com/en-us/library/ms152761(v=sql.105).asp
’t |
|
c******n
发帖数: 7263 | 8 假设一个table，有多个users可以修改这个table。有没有办法只replicate其中一个
user的change？ |
|
m******u
发帖数: 12400 | 9 merge replication， set different priority.But probably difficult to ensure
just one update is allowed. |
|
s**********o
发帖数: 14359 | 10 还可以选择INDEX KEY，这些FILTER都是固定的，你的USER LIST在哪里，明天添加了几
个USER怎么处理啊？删除了DISABLE了呢？其实仔细看看REPLICATION就是些TRIGGER
你可以自己写，自己搞容易出错
自己 |
|
c******n
发帖数: 7263 | 11 假设一个table，有多个users可以修改这个table。有没有办法只replicate其中一个
user的change？ |
|
m******u
发帖数: 12400 | 12 merge replication， set different priority.But probably difficult to ensure
just one update is allowed. |
|
s**********o
发帖数: 14359 | 13 还可以选择INDEX KEY，这些FILTER都是固定的，你的USER LIST在哪里，明天添加了几
个USER怎么处理啊？删除了DISABLE了呢？其实仔细看看REPLICATION就是些TRIGGER
你可以自己写，自己搞容易出错
自己 |
|
w***g
发帖数: 5958 | 14 在一个datacenter写，在另一个读，要1秒钟之内读出来，还要跨center consistent的，
如果再加上点吞退量要求，我觉得可能没有系统能做到。
replicate |
|
w**z
发帖数: 8232 | 15 唯一可能是写等到所有replicates都得到数据再返回。这样写就会很慢。
的， |
|
m**i
发帖数: 724 | 16 想replicate的东西必须在domain controller的那台机器上吗？
在网络里其他机器上行不行？ |
|
w*******e
发帖数: 1622 | 17 Must be on the DC.
(BTW, what kind stuff do you want to replicate? AD/DNS/DHCP database, right?) |
|
w*******e
发帖数: 1622 | 18 Must be on the DC.
(BTW, what kind stuff do you want to replicate? AD/DNS/DHCP database, right?) |
|
m*****7
发帖数: 366 | 19 RT，手头上有个study用了2个Caucasian population Type 2 diabetes的GWAS data，
发现了3个variants，现在需要一个independent的dataset来replicate,希望有
available data和有兴趣的可以站内联系我。当然如果结果是publishable,any co-
author as required都很方便协商。
谢谢！ |
|
发帖数: 1 | 20 个人觉得，不管nucleofection还是lipofectamine的实验，应该都是先用很多细胞在比
如6-well plate里做转染，等到做luciferase的时候，用500ul 裂解液裂解，这时候分
成3-5个孔（每个孔100ul裂解液）进行luciferase assay，那么这里的3-5个孔也可叫
做technical replicate？
或许我的做法搞复杂了？
5
孔。 |
|
B****e
发帖数: 124 | 21 thanks for reply:)
but my boss told me: they are very robust results. many people can replicate:(
郁闷ing~ |
|
w********i
发帖数: 30 | 22 To calculate t-stat, you should estimate variance first. If you use NeweyWest
method to estimate variance, you should choose time lag. Different time lags
give different results. Nobody knows how many lags you should choose.
considering
this
replicate:( |
|
a***n
发帖数: 5665 | 23 what r u trying to replicate? |
|
s****l
发帖数: 137 | 24 这个option定义为：S_0=100, K=1000, if S_t>=K, payoff = 1; otherwise payoff =
0. 如何用类似binomial option pricing的方法replicate? |
|
m****s
发帖数: 1481 | 25 比如forward这种，既然可以用买asset然后loan risk free 来replicate一个forward
，那为啥还要有forward这个东西。如果underlying 是commodity还好理解，为了满足
未来某种需求比如生产加工。但是stock,interest rate,exchange rate这些，为啥不
能直接用underlying和risk free来组合就好了，而要有forward这个东西呢 |
|
f**x
发帖数: 4325 | 26 世上先有的forward，然后才有人发现可以replicate一个forward。所以，“为啥”要
有foward这个问题没什么意义，因为有人想要。
forward |
|
|
x********9
发帖数: 31 | 28 People replicating these derivatives are usually large institutions which
have better financing cost than individuals. For individulas, first of all,
borrowing money is hard, and borrowing securities is harder. That's why
although theoretically equivalent, for individuals, it is always better to
trade via futures than via underlying.
To be more precise, if the 3M Liobr rate is 5%, then the future price for a
liquid asset trading at 100 spot would be 100 exp(0.05/4).
But LIBOR is the interbank lo... 阅读全帖 |
|
m*****7
发帖数: 366 | 29 RT，手头上有个study用了2个Caucasian population Type 2 diabetes的GWAS data，
发现了3个variants，现在需要一个independent的dataset来replicate,希望有
available data和有兴趣的可以站内联系我。当然如果结果是publishable,any co-
author as required都很方便协商。
谢谢！ |
|
l**********n
发帖数: 201 | 30 已经有discussion了，至少在某些领域。去Science上留comments吧：
http://www.sciencemag.org/content/335/6076/1558.full
Science 30 March 2012:
Vol. 335 no. 6076 pp. 1558-1561
DOI: 10.1126/science.335.6076.1558
News Focus
Psychology Research
Psychology's Bold Initiative
Siri Carpenter*
In an unusual attempt at scientific self-examination, psychology researchers
are scrutinizing the reproducibility of work in their field.
Pick up the January 2008 issue of Psychological Science, turn to page 49,
and you'll find a... 阅读全帖 |
|
t*****y
发帖数: 445 | 31 Summary of the Amazon EC2 and Amazon RDS Service Disruption in the US East
Region
Now that we have fully restored functionality to all affected services, we
would like to share more details with our customers about the events that
occurred with the Amazon Elastic Compute Cloud (揈C2 last week, our
efforts to restore the services, and what we are doing to prevent this sort
of issue from happening again. We are very aware that many of our customers
were significantly impacted by this event, and as ... 阅读全帖 |
|
C*I
发帖数: 4736 | 32 一直在误导，现在还在误导。 说说明corona virus 不可以从蝙蝠直接传染给人，必须
经过一个中间宿体性的其它动物才能传染给人。所以，病毒发生后，就故意误导全国人
民去海鲜市场找证据，找其它野生动物的麻烦。 而且还是病毒所去找的，找完了还装
模做样化验呀，分离呀什么的。最后把责任全部推给了海鲜市场的动物。可是那种动物
，一直不敢说，说了其它相关已经在人就会去早那种动物监测。 所以压根不说，打马
虎眼。
事实上，早在2013 年，就是这个武汉病毒研究所，已经从来自云南的蝙蝠身上所携带
的corona virus中分离出第一株蝙蝠SARS类似样的冠状病毒的活病毒，其中就包含了类
似于S类型的基因。从而证实这株病毒能够使其接受和SARS病毒相同的受体，并能够感
染人的细胞。对此新发现，武汉病毒所还把它以武汉病毒研究所的英文简称命名“WIV1
”，以彰显这一发现的重要价值和属于自己第一个发现的巨大研究成果。这个成果刊载
于2013年11月的《自然》杂志。
就是说，从云南弄回来的这种蝙蝠所携带的类似于sars的 corona virus， 可以不经过
其它受体/宿体，而直接传染给人。 他们... 阅读全帖 |
|
C*I
发帖数: 4736 | 33 一直在误导，现在还在误导。 说说明corona virus 不可以从蝙蝠直接传染给人，必须
经过一个中间宿体性的其它动物才能传染给人。所以，病毒发生后，就故意误导全国人
民去海鲜市场找证据，找其它野生动物的麻烦。 而且还是病毒所去找的，找完了还装
模做样化验呀，分离呀什么的。最后把责任全部推给了海鲜市场的动物。可是那种动物
，一直不敢说，说了其它相关已经在人就会去早那种动物监测。 所以压根不说，打马
虎眼。
事实上，早在2013 年，就是这个武汉病毒研究所，已经从来自云南的蝙蝠身上所携带
的corona virus中分离出第一株蝙蝠SARS类似样的冠状病毒的活病毒，其中就包含了类
似于S类型的基因。从而证实这株病毒能够使其接受和SARS病毒相同的受体，并能够感
染人的细胞。对此新发现，武汉病毒所还把它以武汉病毒研究所的英文简称命名“WIV1
”，以彰显这一发现的重要价值和属于自己第一个发现的巨大研究成果。这个成果刊载
于2013年11月的《自然》杂志。
就是说，从云南弄回来的这种蝙蝠所携带的类似于sars的 corona virus， 可以不经过
其它受体/宿体，而直接传染给人。 他们... 阅读全帖 |
|
C*I
发帖数: 4736 | 34 Published: 30 October 2013
Isolation and characterization of a bat SARS-like coronavirus that uses the
ACE2 receptor
Xing-Yi Ge, Jia-Lu Li, Xing-Lou Yang, Aleksei A. Chmura, Guangjian Zhu,
Jonathan H. Epstein, Jonna K. Mazet, Ben Hu, Wei Zhang, Cheng Peng, Yu-Ji
Zhang, Chu-Ming Luo, Bing Tan, Ning Wang, Yan Zhu, Gary Crameri, Shu-Yi
Zhang, Lin-Fa Wang, Peter Daszak & Zheng-Li Shi
Nature volume 503, pages535–538(2013)Cite this article
Abstract
The 2002–3 pandemic caused by severe acute respirator... 阅读全帖 |
|
q******g
发帖数: 3858 | 35 谢谢各位。我看到有人用nested ANOVA来分析。不知道大家觉得这个方法怎么样？
"It's a problem called pseudoreplication - when you have multiple data
points for the same trait taken from the same biological replicate (at the
same time point). Although technical reps have an important role telling you
how much variation arises from lab analysis, its important that you
distinguish the two types in your statistical analysis (if technical
variation is important). I agree with Christopher, if the variability in
your technical replicat... 阅读全帖 |
|
E*****m
发帖数: 25615 | 36 要反進化論好歹要反人家相信的東西，自己樹立個稻草人打得不亦樂乎
做什麼?
拜託讀點書，讓別人有理由尊重你。
http://www.pbs.org/wgbh/evolution/library/faq/cat01.html
7. Is evolution a random process?
Evolution is not a random process. The genetic variation on which
natural selection acts may occur randomly, but natural selection itself is
not random at all. The survival and reproductive success of an individual is
directly related to the ways its inherited traits function in the context
of its local environment. Whether or not an individu... 阅读全帖 |
|
i*********5
发帖数: 62 | 37 请教：
input individual treatment replication y1 y2;
(y1, Y2 are response variables, individual means patient, replication means
replicate each treatment 3 times, thus get 3 times y1 data )
I want to use the next model:
if no replication
proc mixed;
class treatment individual;
model y1 =treatment;
random individual;
run;
If add replication
proc mixed;
class trt individual replication;
model y1 =trt;
random individual replication, replicastion*treatment;
run;
Is this right?
我不太清楚 replication 如何处理？ ... 阅读全帖 |
|
s***m
发帖数: 6197 | 38 【 以下文字转载自 Quant 讨论区 】
发信人: throwaway (专门注册), 信区: Quant
标 题: 答谢文，谈谈VIX 和 VIX future
关键字: VIX
发信站: BBS 未名空间站 (Sun May 11 18:02:53 2014, 美东)
上次发文求建议，收到很多真诚的帮助。想了想可以写篇我对 VIX index 的学习心得
，算是表达感谢吧。
说明一下，我毕竟是个菜鸟新人，这篇也只是综合公开资料再加上我自己对 VIX 的理
解，也就希望对准备学习这个领域的人有所帮助，熟悉volatility trading的内行看了
肯定觉得简单，有不对的地方请多多指正。
废话完毕。
1. Rationale behind VIX
想了解 VIX index 计算方法的依据，必读的文章是
“More than you wanted to know about variance swap".
http://elis.sigmath.es.osaka-u.ac.jp/research/gs-volatility_swa
具体的证明比较繁琐，我总结就是:
In a n... 阅读全帖 |
|
M*****n
发帖数: 2301 | 39 吵了半天终于有个可以看的link了
好虫的方案就是典型的NoSQL DB的东西，star replication， commit after
quorum writes，failover to new master after election, 这些没什么可以说的。
貌似魏老师的方案属于chain replication， 这种replication用的比较少，但是也有。
相对于star replication，chain replication也有自己的优势，就是master
负载小一些。
不过我没有看明白魏老师的设计里面，何时给client这个commit，看魏老师的意思
三段DC之间的replication是async的，这样如何保证不丢数据 if master fail？
如果replication是sync的，write只有到commit到backend server，txn才
算commit to client，这类似于NoSQL里面consistency model = ack from all nodes，
在NoSQL里面这种write latency是蛮大的，在魏... 阅读全帖 |
|
c****1
发帖数: 1095 | 40 欢迎讨论，多谢你意见。
关于样品的数目，其实最好是把 biological replicates都input。你说的把
replicates merge，其实是针对technical replicates。你可以在phenotype labels这
一栏，不同一组的replicates分到一组。网站有这段说明：
Samples. Each sample must have a unique identifier. If you have technical
replicates, you generally want to remove them by averaging or some other
data reduction technique. For example, assume you have five tumor samples
and five control samples each run three times (three replicate columns) for
a total of 30 data columns. You would average ... 阅读全帖 |
|
t*******y
发帖数: 18 | 41 上次发文求建议，收到很多真诚的帮助。想了想可以写篇我对 VIX index 的学习心得
，算是表达感谢吧。
说明一下，我毕竟是个菜鸟新人，这篇也只是综合公开资料再加上我自己对 VIX 的理
解，也就希望对准备学习这个领域的人有所帮助，熟悉volatility trading的内行看了
肯定觉得简单，有不对的地方请多多指正。
废话完毕。
1. Rationale behind VIX
想了解 VIX index 计算方法的依据，必读的文章是
“More than you wanted to know about variance swap".
http://elis.sigmath.es.osaka-u.ac.jp/research/gs-volatility_swa
具体的证明比较繁琐，我总结就是:
In a nut shell, if we can ignore friction, an out-of-money option portfolio
with certain weights could replicate a variance swap, whose payoff = ... 阅读全帖 |
|
l******t
发帖数: 660 | 42 完全没有down time不太可能， 以前我们做过几次
1. 有钱的话， 用third party replication tool, 比如sysbase, golden gate， 都
支持oraclt to sql server replication, replication到一定时间， take oracle
offline, 保证data 全部replicate到sql server, stop replication, bring sql
server online
2. 没钱， 但是不缺人的话， 自己写code, 用log miner cdc 自己读oracle redo log
, 先做一次 one time full load, 什么tool 都可以， bcp, ssms, ms也有个工具，
然后用log miner 把delta change dump到一个table, 然后把replication 以后change
一个一个merge sql server table, 到一定时候， bring oracle offline,把delta
table全部merg... 阅读全帖 |
|
D*a
发帖数: 6830 | 43 我理解他说得是如果一只老鼠和一只KO搞的测量，就是n = 1, 如果增大n，要增大老鼠
数量。因此如果一次测量10只老鼠的血液某指标，那么n = 10
We could choose one mutant mouse and one wild type, and perform 20 replicate
measurements of each of their tails. We could calculate the means, SDs, and
SEs of the replicate mea- surements, but these would not permit us to
answer the central question of whether gene deletion affects tail length,
because n would equal 1 for each genotype, no matter how often each tail was
measured. To address the question successfully we ... 阅读全帖 |
|
p*****c
发帖数: 20445 | 44 Michael Rape, Ph.D.
University of California, Berkeley
Michael Rape’s love of science began in the basement of his parent’s house
, where he used to conduct rudimentary biochemistry experiments. Today, he
uses far more sophisticated methods to understand a complex process critical
to nearly all organisms: ubiquitylation. The term describes the attachment
of a regulatory protein called ubiquitin—named for its ubiquity—onto other
proteins. Ubiquitin tags communicate a wealth of information to the ... 阅读全帖 |
|
c********n
发帖数: 225 | 45 2016年8月24日
业界大规模重复验证NgAgo基因编辑功能，而不得其果的经历，
可能会带来对于“重复” （replication）实验数据发表方式的革新：
《自然》杂志 2016年8月24日 Editorial
http://www.nature.com/news/go-forth-and-replicate-1.20473
Go forth and replicate!
“To make replication studies more useful, researchers must make more of
them, funders must encourage them and journals must publish them.”
“To foster better behaviour, replication attempts must become more common.
We urge researchers to open their file drawers. We urge authors to cooperate
with reasonable req... 阅读全帖 |
|
c********n
发帖数: 225 | 46 2016年8月24日
业界大规模重复验证NgAgo基因编辑功能，而不得其果的经历，
可能会带来对于“重复” （replication）实验数据发表方式的革新：
《自然》杂志 2016年8月24日 Editorial
http://www.nature.com/news/go-forth-and-replicate-1.20473
Go forth and replicate!
“To make replication studies more useful, researchers must make more of
them, funders must encourage them and journals must publish them.”
“To foster better behaviour, replication attempts must become more common.
We urge researchers to open their file drawers. We urge authors to cooperate
with reasonable req... 阅读全帖 |
|
|
c********n
发帖数: 225 | 48 2016年8月24日
业界大规模重复验证NgAgo基因编辑功能，而不得其果的经历，
可能会带来对于“重复” （replication）实验数据发表方式的革新：
《自然》杂志 2016年8月24日 Editorial
http://www.nature.com/news/go-forth-and-replicate-1.20473
Go forth and replicate!
“To make replication studies more useful, researchers must make more of
them, funders must encourage them and journals must publish them.”
“To foster better behaviour, replication attempts must become more common.
We urge researchers to open their file drawers. We urge authors to cooperate
with reasonable req... 阅读全帖 |
|
A****7
发帖数: 902 | 49 https://www.med.unc.edu/microimm/directory/ralph-baric-phd-1/
Ralph Baric, PhD
Professor
Department of Epidemiology
3304 MHRC, School of Public Health
919-966-3895
Research
Most of the research in our laboratory has used coronaviruses as models to
study the genetics of RNA virus transcription, replication, persistence, and
cross species transmission. We have also been using alphavirus vaccine
vectors to develop novel candidate vaccines against caliciviruses. Specific
areas of interest include:
1... 阅读全帖 |
|
