RDBMS服务器引擎 - 概述？ [英] RDBMS server engines - an overview?
问题描述
有人见过吗？或者提供（简短）一个？是的，我已经做了一些
搜索档案。任何人在过去的一对夫妇上阅读我的帖子
年（并且必须至少有一两个人！）才能知道我唯一的实际经验使用Access / Jet。但是我越来越清楚，为了这个职业生涯，我必须扩展自己的技能。 MS SQL Server首先在
列表中，不是因为它必然是最好的/最具成本效益的，或者其他什么，
但是因为人们使用它，我喜欢ADP的外观。但如果我是
向客户推荐客户端（prob Access）/服务器解决方案，那么
的意见是什么：
PostGreSQL
MySQL
Oracle
MS SQL Server
DB2
等
这是一个广泛的问题，对不起。我只是在进行一般性比较之后才真正做到了。我尊重这里的人们的意见。
TIA，Mike MacSween
Has anybody seen one? Or care to offer (a brief) one? Yes, I''ve done some
searching of the archives. Anybody who''s read my posts over the past couple
of years (and there must be at least one or two of you!) will know my only
real experience is with Access/Jet. But it''s becoming clear to me that for
career''s sake I''ve got to expand my skill set. MS SQL Server is first on the
list, not because it''s necessarily the best/most cost effective or whatever,
but because people use it, and I like the look of ADPs. But if I''m
reccomending client(prob Access)/server solutions to customers, what are the
opinions on:
PostGreSQL
MySQL
Oracle
MS SQL Server
DB2
etc.
That''s a bit of a broad question, sorry. I''m just after general comparisons
really. And I respect the opinions of the people here.
TIA, Mike MacSween
推荐答案
一个有趣的技术Oracle的特点是，它同时提供了以下四件事的
：
oa每个SELECT返回的数据的一致视图，
o，不管SELECT需要执行多长时间，即使其他进程同时更新所选记录
，也需要
o，并且
o没有持有任何锁!!
这在以下情况下非常重要：
o有一个非常高的数据输入/更新负载，
o对报告等有并发查询，
o这些报告必须在一个时间点提供一致的
数据视图，并且
o使用数据锁是不可接受的（因此减慢了
或暂停其他进程）。
Ora cle还提供全面的重型交易处理和&b; b b&b时间点恢复。 （您无疑知道，Jet交易完全没有交易。他们*不保证
交易中的所有数据都已保存或未保存，&数据库留在其中一个
两个州。）
HTH，
TC
" Mike MacSween" < MI ****************** @ btinternet.com>在消息中写道
新闻：3f ********************* @ pubnews.gradwell.net。 ..
An interesting technical characteristic of Oracle, is that it offers the
following four things simultaneously:
o a consistent view of the data returned by each SELECT,
o regardless of how long the SELECT takes to execute,
o even if other processes are comitting updates to the selected records
at the same time, and
o without holding any locks!!
This can be important when:
o there is a very high data entry/update load,
o there are concurrent queries for reports etc.,
o it is essential for those reports to present a consistent view of the
data at one single point in time, and
o it is not acceptable to achive that using data locks (thereby slowing
or suspending other processes).
Oracle also has the full complement of heavy-duty transaction processing &
point-in-time recovery. (As you are doubtless aware, Jet transactions are
not transactions at all. They *do not* guarantee that all the data in the
transaction is saved, or not saved, & the database is left in one of those
two states.)
HTH,
TC
"Mike MacSween" <mi******************@btinternet.com> wrote in message
news:3f*********************@pubnews.gradwell.net. ..
有人见过吗？或者提供（简短）一个？是的，我已经对档案进行了一些搜索。任何人在过去的
几年内阅读我的帖子（并且必须至少有一两个人！）才会知道我唯一真正的体验是使用Access / Jet。但是我越来越明白，为了职业生涯，我必须扩展自己的技能。 MS SQL Server首先在
列表中，不是因为它必然是最好/最具成本效益的，或者是
无论如何，但是因为人们使用它，我喜欢ADP的外观。但如果我向客户推荐客户端（prob Access）/服务器解决方案，那么对于b $ b的意见是什么：
PostGreSQL
MySQL
Oracle
MS SQL Server
DB2
这是一个广泛的问题，抱歉。我只是在普通的
比较之后。我尊重这里的人们的意见。
TIA，Mike MacSween
Has anybody seen one? Or care to offer (a brief) one? Yes, I''ve done some
searching of the archives. Anybody who''s read my posts over the past couple of years (and there must be at least one or two of you!) will know my only
real experience is with Access/Jet. But it''s becoming clear to me that for
career''s sake I''ve got to expand my skill set. MS SQL Server is first on the list, not because it''s necessarily the best/most cost effective or whatever, but because people use it, and I like the look of ADPs. But if I''m
reccomending client(prob Access)/server solutions to customers, what are the opinions on:
PostGreSQL
MySQL
Oracle
MS SQL Server
DB2
etc.
That''s a bit of a broad question, sorry. I''m just after general comparisons really. And I respect the opinions of the people here.
TIA, Mike MacSween
所以 - Oracle是，迈克！
TC
" Mike MacSween" < MI ****************** @ btinternet.com>在消息中写道
新闻：3f ********************* @ pubnews.gradwell.net。 ..
So - Oracle it is, Mike!
TC
"Mike MacSween" <mi******************@btinternet.com> wrote in message
news:3f*********************@pubnews.gradwell.net. ..
有人见过吗？ （剪辑）
Has anybody seen one? (snip)
" TC" < a@b.c.d>在消息新闻中写道：1064117934.400231@teuthos ...
"TC" <a@b.c.d> wrote in message news:1064117934.400231@teuthos...
所以 - Oracle就是这样，Mike！
So - Oracle it is, Mike!
Yup，看起来像那个。我的20,000英镑支票现在在帖子中< g>
Mike
Yup, looks like the one. My ￡20,000 cheque is in the post now <g>
Mike
这篇关于RDBMS服务器引擎 - 概述？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
