请问DATABASE各位大侠 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

请问DATABASE各位大侠

请问DATABASE各位大侠# Database - 数据库

f*g2000-06-28 07:06

1 楼

有很多问题不解，代俺一一问来：
有一网上查询project,
1。现在不知该选什么样数据库， ACCESS or ORACLE,
老板说后者太贵，有多贵？偶挺好奇，没好意思问？
ACCESS就是免费的么？
2。用ACCESS的话，该用什么语言呢？
VB好呢？还是VC++呢？
3。SQL和VB/VC++关系是怎样的？
4。由于初涉本行，问题dump了点，有没有
关于ACCESS和VB/VC++用于ACCESS的online教材，让俺看看先。
谢了。

w*h2000-06-28 07:06

2 楼

Access can't handle transactions.
Use M$ SQL Server, cheap, easy to use.
Oracle is too expensive to use for a small project.

【在 f******g 的大作中提到】

: 有很多问题不解，代俺一一问来：
: 有一网上查询project,
: 1。现在不知该选什么样数据库， ACCESS or ORACLE,
: 老板说后者太贵，有多贵？偶挺好奇，没好意思问？
: ACCESS就是免费的么？
: 2。用ACCESS的话，该用什么语言呢？
: VB好呢？还是VC++呢？
: 3。SQL和VB/VC++关系是怎样的？
: 4。由于初涉本行，问题dump了点，有没有
: 关于ACCESS和VB/VC++用于ACCESS的online教材，让俺看看先。

f*g2000-06-28 07:06

3 楼

waht r u meaning by saying 'transaction'?
The project I am doing is like:
users input some data, and the server will save
all users' data, deriving mean, derivation, and sum etc.
And then let user know these information.
So, it is simple, without money transaction behaviour in it.
In this case, can ACCESS handle all these?
3x anyway!

【在 w*****h 的大作中提到】

: Access can't handle transactions.
: Use M$ SQL Server, cheap, easy to use.
: Oracle is too expensive to use for a small project.

a*a2000-06-28 07:06

4 楼

yes, ACCESS can do this..
transaction is a unit of operations that are done atomicly.
ie. they either all fail or all succeed.

【在 f******g 的大作中提到】

: waht r u meaning by saying 'transaction'?
: The project I am doing is like:
: users input some data, and the server will save
: all users' data, deriving mean, derivation, and sum etc.
: And then let user know these information.
: So, it is simple, without money transaction behaviour in it.
: In this case, can ACCESS handle all these?
: 3x anyway!

f*g2000-06-28 07:06

5 楼

3x lah, although I can not totally understand.
but which language should I choose to do ACCESS?
VB or VC++?
And I heard it was said 'one-user' for ACCESS?
SOunds terrible, does it mean only one user can access my database,
and multiple users can not access it together???
Anybody can help me out?
3x millions!

【在 a*****a 的大作中提到】

: yes, ACCESS can do this..
: transaction is a unit of operations that are done atomicly.
: ie. they either all fail or all succeed.

a*a2000-06-28 07:06

6 楼

Honestly, VB is easier and have more samples flowing around
on the web. but VC is not that hard either..
I am not too sure about whether ACCESS is for singleuser or
not, but I believe ACCESS supports multi users
reading/writing DB at the same time.

【在 f******g 的大作中提到】

: 3x lah, although I can not totally understand.
: but which language should I choose to do ACCESS?
: VB or VC++?
: And I heard it was said 'one-user' for ACCESS?
: SOunds terrible, does it mean only one user can access my database,
: and multiple users can not access it together???
: Anybody can help me out?
: 3x millions!

s*k2000-06-28 07:06

7 楼

Access support multiusers read/write if they are not
operated on the same table same time since 1.x.
In other word, Access has table level lock for concurrency
control.

【在 a*****a 的大作中提到】

: Honestly, VB is easier and have more samples flowing around
: on the web. but VC is not that hard either..
: I am not too sure about whether ACCESS is for singleuser or
: not, but I believe ACCESS supports multi users
: reading/writing DB at the same time.

s*c2000-06-28 07:06

8 楼

Hi, flashing:
I think it's a good solution for your project:
OS: Win NT Server
Web Server: Microsoft Internet Information Server(IIS)
DBMS: SQL Server
Programming: ASP (using vbscript or javascript)
It is one of the most popular solutions for small business.
It's not expensive and easy to implement.

o*b2000-06-28 07:06

9 楼

Another solution:
OS: linux (free), solaris, freeBSD (free), winnt...
web server: apache (free)
db: mySQL for RDBMS (almost free), BerkeleyDB (free)
programming: mod_perl, mod_jserv with tomcat, ... (free)
The advantages are:
1. for both small and large websites, good scalability.
2. portable to most of popular OS's
3. for a non-commercial website, all the software can
be totally free.
3. extensible to use other commercial db's, such as Oracle

【在 s*****c 的大作中提到】

: Hi, flashing:
: I think it's a good solution for your project:
: OS: Win NT Server
: Web Server: Microsoft Internet Information Server(IIS)
: DBMS: SQL Server
: Programming: ASP (using vbscript or javascript)
: It is one of the most popular solutions for small business.
: It's not expensive and easy to implement.

a*a2000-06-28 07:06

10 楼

and if you are completely new hand,
MS solution costs u about 1 month to master all the compoennts,
while the *free* solution might cost you several years.
plus if you are in China, probably you get all MS things free too:)

【在 o*b 的大作中提到】

: Another solution:
: OS: linux (free), solaris, freeBSD (free), winnt...
: web server: apache (free)
: db: mySQL for RDBMS (almost free), BerkeleyDB (free)
: programming: mod_perl, mod_jserv with tomcat, ... (free)
: The advantages are:
: 1. for both small and large websites, good scalability.
: 2. portable to most of popular OS's
: 3. for a non-commercial website, all the software can
: be totally free.

o*b2000-06-28 07:06

11 楼

right, it is not as intuitive as MS stuff. however, it is
not that hard if you find the right books and resources.
For me, it took just a short time to experience almost
all the popular and latest technologies centralized around
apache. Also you would definitely love Apache's speed running
on freeBSD which is the environment Yahoo is running at
(it uses Yahoo-Apache with Yahoo-freeBSD).

【在 a*****a 的大作中提到】

: and if you are completely new hand,
: MS solution costs u about 1 month to master all the compoennts,
: while the *free* solution might cost you several years.
: plus if you are in China, probably you get all MS things free too:)