r*****s
发帖数: 985 | 1 A topic for discussion:
我了解NoSQL主要用在Key/Val Pairs in large scales,
比如for storing JSON，
可是一般数据库的功能还有模型也能解决吗？
特别是做报表就不可能了，
肯定有一条线between NoSQL and DB,
有些适合NoSQL，
有些还是要Hibernate/JDBC去relational db的，
实际做过project的牛牛们说说看
这条线怎么定的？ |
g*****g
发帖数: 34805 | 2 You trade performance/scalability for transaction support/integrity.
【在 r*****s 的大作中提到】
: A topic for discussion:
: 我了解NoSQL主要用在Key/Val Pairs in large scales,
: 比如for storing JSON，
: 可是一般数据库的功能还有模型也能解决吗？
: 特别是做报表就不可能了，
: 肯定有一条线between NoSQL and DB,
: 有些适合NoSQL，
: 有些还是要Hibernate/JDBC去relational db的，
: 实际做过project的牛牛们说说看
: 这条线怎么定的？
|
r*****s
发帖数: 985 | 3 这个是data model/structure很简单
而且不需要persistence或要求不高?
一般企业级的软件能用在什么地方？
【在 g*****g 的大作中提到】
: You trade performance/scalability for transaction support/integrity.
|
g*****g
发帖数: 34805 | 4 Transient data, data that can be rebuilt, data that can afford
a little inconsistency, cache replacement etc.
Using it for financial transaction is calling trouble.
A hybrid SQL/NoSQL application is very common. You have to be
very careful on what you are doing.
If you have an existing application, be conservative and try
table by table.
【在 r*****s 的大作中提到】
: 这个是data model/structure很简单
: 而且不需要persistence或要求不高?
: 一般企业级的软件能用在什么地方？
|
r*****s
发帖数: 985 | 5 这Data直接从JSON到NoSQL，
没有security concern?
传统db还有dto <-> entity呢
【在 g*****g 的大作中提到】
: Transient data, data that can be rebuilt, data that can afford
: a little inconsistency, cache replacement etc.
: Using it for financial transaction is calling trouble.
: A hybrid SQL/NoSQL application is very common. You have to be
: very careful on what you are doing.
: If you have an existing application, be conservative and try
: table by table.
|
g*****g
发帖数: 34805 | 6 ? I think you should have entity and DAO regardless of
SQL/NoSQL
【在 r*****s 的大作中提到】
: 这Data直接从JSON到NoSQL，
: 没有security concern?
: 传统db还有dto <-> entity呢
|
r*****s
发帖数: 985 | 7 所以在DAO后面的？
比如MongoDB那简直就是为JSON设计的，
再把JSON转成Java Entity再转成JSON/BSON
mapping也很花时间啊，
难道实际project是这么做的？
【在 g*****g 的大作中提到】
: ? I think you should have entity and DAO regardless of
: SQL/NoSQL
|
g*****g
发帖数: 34805 | 8 I never try MongoDB, we do this for Cassandra. And I
can replace the DB by simply rewriting DAOs.
I think a flexibile architecture can save you
lots of trouble in the long run. 3 layer architecture
is for decoupling, not for simplicity.
【在 r*****s 的大作中提到】
: 所以在DAO后面的？
: 比如MongoDB那简直就是为JSON设计的，
: 再把JSON转成Java Entity再转成JSON/BSON
: mapping也很花时间啊，
: 难道实际project是这么做的？
|
r*****s
发帖数: 985 | 9 thanks for sharing your exprience.
hmmmm ...
cassandra is a key/val store
while MongoDB is a "document database".
cassandra itself is like a L2 cache,
backed by hardoop?
【在 g*****g 的大作中提到】
: I never try MongoDB, we do this for Cassandra. And I
: can replace the DB by simply rewriting DAOs.
: I think a flexibile architecture can save you
: lots of trouble in the long run. 3 layer architecture
: is for decoupling, not for simplicity.
|
r*****s
发帖数: 985 | 10 再看看您的comments好像对NoSQL评价也不高啊，
我也很怕NoSQL下去遇到Dead end，
table by table哪有这个时间？
反而RDB大不了就cluster/L2 cache好了
【在 g*****g 的大作中提到】
: Transient data, data that can be rebuilt, data that can afford
: a little inconsistency, cache replacement etc.
: Using it for financial transaction is calling trouble.
: A hybrid SQL/NoSQL application is very common. You have to be
: very careful on what you are doing.
: If you have an existing application, be conservative and try
: table by table.
|
|
|
g*****g
发帖数: 34805 | 11 不是不高，而是说使用要谨慎，不是什么场合都合适的。
如果你需要支持大量用户，而对integrity要求不高，就可以考虑。
【在 r*****s 的大作中提到】
: 再看看您的comments好像对NoSQL评价也不高啊，
: 我也很怕NoSQL下去遇到Dead end，
: table by table哪有这个时间？
: 反而RDB大不了就cluster/L2 cache好了
|
r*****l
发帖数: 2859 | 12 NoSQL != NO SQL
NoSQL == Not Only SQL
Amazon check out can use NoSQL. It's ok if you put something in cart and it
became unavailable when checking out. It's ok that some users check out OOS
item. However, the throughput under load of the website is important.
With banking application, NoSQL is tricky. If a user withdraw his only $10,
000 from ATM and within 5 minutes, he is able to withdraw another $10,000
from the counter ...
【在 r*****s 的大作中提到】
: A topic for discussion:
: 我了解NoSQL主要用在Key/Val Pairs in large scales,
: 比如for storing JSON，
: 可是一般数据库的功能还有模型也能解决吗？
: 特别是做报表就不可能了，
: 肯定有一条线between NoSQL and DB,
: 有些适合NoSQL，
: 有些还是要Hibernate/JDBC去relational db的，
: 实际做过project的牛牛们说说看
: 这条线怎么定的？
|
B*****g
发帖数: 34098 | 13 NoSQL里能用SQL吗？
it
OOS
【在 r*****l 的大作中提到】
: NoSQL != NO SQL
: NoSQL == Not Only SQL
: Amazon check out can use NoSQL. It's ok if you put something in cart and it
: became unavailable when checking out. It's ok that some users check out OOS
: item. However, the throughput under load of the website is important.
: With banking application, NoSQL is tricky. If a user withdraw his only $10,
: 000 from ATM and within 5 minutes, he is able to withdraw another $10,000
: from the counter ...
|
g*****g
发帖数: 34805 | 14 NoSQL is not a standard. Many implementations do have SQL
like query syntax.
【在 B*****g 的大作中提到】
: NoSQL里能用SQL吗？
:
: it
: OOS
|
c******n
发帖数: 4965 | 15 basically if u don't do a lot of JOINs , noSQL is good,
otherwise
impossible
【在 r*****s 的大作中提到】
: A topic for discussion:
: 我了解NoSQL主要用在Key/Val Pairs in large scales,
: 比如for storing JSON，
: 可是一般数据库的功能还有模型也能解决吗？
: 特别是做报表就不可能了，
: 肯定有一条线between NoSQL and DB,
: 有些适合NoSQL，
: 有些还是要Hibernate/JDBC去relational db的，
: 实际做过project的牛牛们说说看
: 这条线怎么定的？
|
b******y
发帖数: 9224 | 16 我的感觉是，NoSQL用在做search, large data processing等方面不错。要高
performance的那种。 |
