哪个数据库？ [英] Which database?
问题描述
我正在寻找一些关于为新的
申请选择合适数据库的建议。它将用VB编写。我有很多经验使用
VB6，但我现在有一份VB2005 Express，打算将它用于
新项目。我也非常熟悉SQL，并且曾经使用过Oracle，
SQL Server和Access过去的各种项目，但我不确定
这将是什么最适合此应用。目前数据库设计在很早的阶段就是
，但它看起来好像架构不太好b
b太复杂了（约12个表）到目前为止已确定）但它将需要存储相当多的数据，数百甚至数千条记录
可能每天生成（尽管大多数这些记录将b / b很小）并且很多数据需要保存很长时间
一段时间（可能是几个月）。将有一个主系统生成数据，但是少数其他用户需要查询数据库，主要是生成报告。 />
我正在考虑Access或SQL Server，但我很少担心成本问题。我们（希望）将这个系统放在
a大量不同的站点上，所以不希望在完整版本的Office或SQL Server上安装
。
我非常喜欢使用Access的想法，因为它允许多个用户，并且
我相信可以自由分发运行时版本，所以它会
没有必要安装Office来运行它。我很担心它是否可以处理所涉及的数据量。
我相信我也有SQL Server Express可用作新VB的一部分
系统，但我对此并不了解。这是最好的事情吗？或者我可能会更好地查看完整版的SQL Server吗？ （
的成本可能令人望而却步）。还有其他选择吗？
提前致谢。
菲尔。
如何很多网站都有数据库服务器？一个？
一次需要多少用户访问数据库？
JerryM
"菲尔" < N / Awrote in
news：46 ********************** @ ptn-nntp-reader02.plus.net：
我非常喜欢使用Access的想法，因为它允许多个
用户，我相信可以自由分发运行时
版本，因此没有必要安装Office来运行它。
如果系统是多用户，请使用SQL Server Express或SQL Server。
I
我担心它是否能够应付所涉及的数据量b / b $ b。
嗯，有些人说它可以，但我不会用它超过几百MB的b $ b。我只会将它用于简单的单用户
应用程序。我可能会因为这个评论而受到抨击:-)
我相信我也有SQL Server Express可用部分
新的VB系统，但我不太了解这一点。这是最好的事情吗？或者我可能更好地看一下完整的
版本的SQL Server？ （这可能是令人望而却步的成本）。
还有其他选择吗？提前致谢。
SQL Server Express是SQL Server的精简版本。这是所有SQL Server数据库的
功能比较：
http://www.microsoft.com/sql/prodinf...-features.mspx
如您所见，Express具有付费版本SQL的大部分功能
Server。虽然它有4GB的目录大小限制 - 对于大多数数据库来说，这是一个巨大的b $ b。如果您的客户需要更大的数据库或者拥有一台SQL Server，那么他们只需更改您应用程序的连接
字符串即可指向新数据库。
否则你可以看看MySQL。伟大的数据库:)
" JerryWEC" < Je ****** @ newsgroups.nospamwrote in message
news：up ************* @ TK2MSFTNGP05.phx.gbl ...
有多少个站点拥有数据库服务器？一？
多个独立网站。多个
网站之间无需通信。我在想局域网上的一个共享mdb文件。
>
一个用户需要访问数据库的人数时间？
大部分时间可能只有1，但其他人需要能够不时地从
查询，所以对允许一些并发连接。
典型的用法是生成数据的一个用户，然后是一小部分其他用户不时查询数据库的
。应用程序将b / b $ b也从数据中做一些复杂的计算，结果将b / b $ b $反馈给生成数据的用户，并存储在数据库中
供其他偶尔用户查询。
I''m looking for some advice on choosing a suitable database for a new
application. It''s going to be written in VB. I have a lot of experience with
VB6, but I now have a copy of VB2005 Express, and intend to use this for the
new project. I am also quite familiar with SQL and have worked with Oracle,
SQL Server and Access in the past on various projects, but I''m not sure
which will be most appropriate for this application. The database design is
in very early stages at the moment, but it''s looking like the schema isn''t
going to be too complicated (about 12 tables identified so far) but it will
need to store quite a lot of data, hundreds, possibly thousands of records
could potentially be generated per day (although most of these records will
be quite small) and a lot of the data will need to be kept live for long
periods of time (months probably). There will be one main system generating
the data, but it will be necessary for a small number of other users to
query the database, mainly to generate reports.
I''m currently thinking about Access or SQL Server, but I''m a little
concerned about the costs. We will (hopefully) be putting this system in at
a large number of different sites, so would prefer not to have to install
the full version of Office or SQL Server.
I quite like the idea of using Access, as it does allow multiple users, and
I believe it is possible to freely distribute a runtime version, so it would
not be necessary to install Office to run it. I am worried though whether it
could cope with the amount of data involved.
I believe I also have SQL Server Express available as part of the new VB
system, but I don''t know much about this. Would this be the best thing to go
with, or might I be better looking at a full version of SQL Server? (the
cost of this may be prohibitive). Are there any other options?
Thanks in advance.
Phil.
How many sites will have the database server? One?
How many users will need to access the db at one time?
JerryM
"Phil" <N/Awrote in
news:46**********************@ptn-nntp-reader02.plus.net:
I quite like the idea of using Access, as it does allow multiple
users, and I believe it is possible to freely distribute a runtime
version, so it would not be necessary to install Office to run it.If the system is multi-user, use SQL Server Express or SQL Server.
I
am worried though whether it could cope with the amount of data
involved.Well, some people say it can, but I wouldn''t use it for more than a
couple hundred MBs. I would only use it for simple single user
applications. I''m probably going to get flamed for this comment :-)
I believe I also have SQL Server Express available as part
of the new VB system, but I don''t know much about this. Would this be
the best thing to go with, or might I be better looking at a full
version of SQL Server? (the cost of this may be prohibitive). Are
there any other options? Thanks in advance.SQL Server Express is a slimmed down version of SQL Server. Here is a
feature comparison of all the SQL Server database:
http://www.microsoft.com/sql/prodinf...-features.mspx
As you see, Express has most of the features of the paid versions of SQL
Server. Although it has a 4GB catalog size limit - for most databases
that''s huge. If your customers need a larger database or have an in-
house SQL Server, they can merely change your applications''s connection
string to point to the new database.
Otherwise you could look at MySQL. Great database :)
"JerryWEC" <Je******@newsgroups.nospamwrote in message
news:up*************@TK2MSFTNGP05.phx.gbl...How many sites will have the database server? One?Multiple independant sites. No communications required between multiple
sites. I was thinking of a single shared mdb file on a LAN.
>
How many users will need to access the db at one time?Most of the time probably just 1, but others need to be able to query from
time to time, so would be useful to allow for a few concurrent connections.
Typical usage would be one user generating the data, and then a small number
of other users querying the database from time to time. The application will
also be doing some complex calculations from the data, the results of which
will be fed back to the user generating the data, and stored in the database
for the other occasional users to query.
这篇关于哪个数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
