A*n
2 楼
数据从一个数据库1到另一个数据库2，有什么办法能作到当数据库1有新的数据进来(或是更新）的时候，自动的把进来或是更新的数据也加到数据库2里面或是更新数据库2里面的数据。用的是SQL Server.
v*e
3 楼
最近就没好过
w*g
4 楼
If there are a lot of different types of A,B .... molecules in the system,
and I want to quickly get all the molecules of type A,do anyone know how can
I realize that ??
This is a kind of pattern matching problem ?
My thought is:
1. First transfer all molecule structures into a string and store them.
2. Then search for the strings for the desired string.
Any body has a better idea? or where can I find such an algorithm ?
Any clues are highly appreciated.
and I want to quickly get all the molecules of type A,do anyone know how can
I realize that ??
This is a kind of pattern matching problem ?
My thought is:
1. First transfer all molecule structures into a string and store them.
2. Then search for the strings for the desired string.
Any body has a better idea? or where can I find such an algorithm ?
Any clues are highly appreciated.
B*g
5 楼
http://msdn.microsoft.com/en-us/library/ms151198.aspx
或是更新）的时候，自动的把进来或是更新的数据也加到数据库2里面或是更新数据库2
里面的数据。用的是SQL Server.
【在 A*******n 的大作中提到】
: 数据从一个数据库1到另一个数据库2，有什么办法能作到当数据库1有新的数据进来(或是更新）的时候，自动的把进来或是更新的数据也加到数据库2里面或是更新数据库2里面的数据。用的是SQL Server.
或是更新）的时候，自动的把进来或是更新的数据也加到数据库2里面或是更新数据库2
里面的数据。用的是SQL Server.
【在 A*******n 的大作中提到】
: 数据从一个数据库1到另一个数据库2，有什么办法能作到当数据库1有新的数据进来(或是更新）的时候，自动的把进来或是更新的数据也加到数据库2里面或是更新数据库2里面的数据。用的是SQL Server.
o*o
6 楼
use DB
can
【在 w****g 的大作中提到】
: If there are a lot of different types of A,B .... molecules in the system,
: and I want to quickly get all the molecules of type A,do anyone know how can
: I realize that ??
: This is a kind of pattern matching problem ?
: My thought is:
: 1. First transfer all molecule structures into a string and store them.
: 2. Then search for the strings for the desired string.
: Any body has a better idea? or where can I find such an algorithm ?
: Any clues are highly appreciated.
can
【在 w****g 的大作中提到】
: If there are a lot of different types of A,B .... molecules in the system,
: and I want to quickly get all the molecules of type A,do anyone know how can
: I realize that ??
: This is a kind of pattern matching problem ?
: My thought is:
: 1. First transfer all molecule structures into a string and store them.
: 2. Then search for the strings for the desired string.
: Any body has a better idea? or where can I find such an algorithm ?
: Any clues are highly appreciated.
A*n
7 楼
I am studying right now. I just hope someone can give me link, like step by
step.
Thanks Beijing.
you are a man.
step.
Thanks Beijing.
you are a man.
w*g
8 楼
Thanks for your help.
What's DB ? how to use it to solve the problem ? Can you provide more
details?
【在 o*o 的大作中提到】
: use DB
:
: can
What's DB ? how to use it to solve the problem ? Can you provide more
details?
【在 o*o 的大作中提到】
: use DB
:
: can
s*o
9 楼
no, me think Beijing is a woman!
by
【在 A*******n 的大作中提到】
: I am studying right now. I just hope someone can give me link, like step by
: step.
: Thanks Beijing.
: you are a man.
by
【在 A*******n 的大作中提到】
: I am studying right now. I just hope someone can give me link, like step by
: step.
: Thanks Beijing.
: you are a man.
l*c
10 楼
Hash ! If there are too much information in the molecule, plain string
matching is too expensive, better to hash them. And the hash could be stored
in quite a lot of different data structures, depending on your requirement.
can
【在 w****g 的大作中提到】
: If there are a lot of different types of A,B .... molecules in the system,
: and I want to quickly get all the molecules of type A,do anyone know how can
: I realize that ??
: This is a kind of pattern matching problem ?
: My thought is:
: 1. First transfer all molecule structures into a string and store them.
: 2. Then search for the strings for the desired string.
: Any body has a better idea? or where can I find such an algorithm ?
: Any clues are highly appreciated.
matching is too expensive, better to hash them. And the hash could be stored
in quite a lot of different data structures, depending on your requirement.
can
【在 w****g 的大作中提到】
: If there are a lot of different types of A,B .... molecules in the system,
: and I want to quickly get all the molecules of type A,do anyone know how can
: I realize that ??
: This is a kind of pattern matching problem ?
: My thought is:
: 1. First transfer all molecule structures into a string and store them.
: 2. Then search for the strings for the desired string.
: Any body has a better idea? or where can I find such an algorithm ?
: Any clues are highly appreciated.
S*0
11 楼
Change Data capture, replication. Both read from transaction log, so be
cautious if the data volum is big.
或是更新）的时候，自动的把进来或是更新的数据也加到数据库2里面或是更新数据库2
里面的数据。用的是SQL Server.
【在 A*******n 的大作中提到】
: 数据从一个数据库1到另一个数据库2，有什么办法能作到当数据库1有新的数据进来(或是更新）的时候，自动的把进来或是更新的数据也加到数据库2里面或是更新数据库2里面的数据。用的是SQL Server.
cautious if the data volum is big.
或是更新）的时候，自动的把进来或是更新的数据也加到数据库2里面或是更新数据库2
里面的数据。用的是SQL Server.
【在 A*******n 的大作中提到】
: 数据从一个数据库1到另一个数据库2，有什么办法能作到当数据库1有新的数据进来(或是更新）的时候，自动的把进来或是更新的数据也加到数据库2里面或是更新数据库2里面的数据。用的是SQL Server.
A*n
12 楼
Beijing is a lady??
A*n
13 楼
I think the data is huge. Thanks Stone
g*l
14 楼
REPLICATION和TRIGGER都可以，数据源就一个，传输的多个的话就用REPLICATION，你
还是把SQL SERVER的书好好看看，就不会问这种初级的问题了
还是把SQL SERVER的书好好看看，就不会问这种初级的问题了
A*n
15 楼
都是高人啊，让你见笑了， trigger要怎么用，2个完全不同的server,有的时候可能一
个server上table都不一定有。 如果在一个数据库或是一个server往table上加数据简单。
看来我是很初级，呵呵。
gejkl给我一点意见啊。
谢谢
个server上table都不一定有。 如果在一个数据库或是一个server往table上加数据简单。
看来我是很初级，呵呵。
gejkl给我一点意见啊。
谢谢
g*l
16 楼
你这个就是用TRANSACTIONAL REPLICATION,你这个问题问的都不清楚，到底想做什么。
简单。
【在 A*******n 的大作中提到】
: 都是高人啊，让你见笑了， trigger要怎么用，2个完全不同的server,有的时候可能一
: 个server上table都不一定有。 如果在一个数据库或是一个server往table上加数据简单。
: 看来我是很初级，呵呵。
: gejkl给我一点意见啊。
: 谢谢
简单。
【在 A*******n 的大作中提到】
: 都是高人啊，让你见笑了， trigger要怎么用，2个完全不同的server,有的时候可能一
: 个server上table都不一定有。 如果在一个数据库或是一个server往table上加数据简单。
: 看来我是很初级，呵呵。
: gejkl给我一点意见啊。
: 谢谢
相关阅读
请教：关于gtk编程，建立一个GUI我来出个赛马题谁提示一下Excel 的Autocorrect问题请教请教Fortran编程高手并问一下OpenMP的问题江湖救急再问一个free()的问题请问如何才能对binary tree的题大小通吃?A moment of C++ hate (zz)interview question: make all class member functions virtual (转载)并行程序能做到不用专门写么？问个javascript的问题how to do profiling with Xcode?A question about Boost/lambdadoes this line get executed after exception caught问个Python问题一个qt3在Windows上的问题code swarm (video)thread, smp, 和grid computinganyone use thruDB before