Database Design for Multiple function site

[ky_loh]

Hi

I am working on one project which involve multiple function site, such as
Company Product Catelog, Customer Support Forum, Document Exchange Engine and
etc...

Normally we will combine ALL TABLEs into one DATABASE.

My question are:
1) Is my break them to individual DATABASE, will it perform better?
Means Product Catelog and Forum will have different DATABASE, but they
will using the same DOMAIN NAME.

2) I am worried about the break down and corruption of DATABASE, so I have the
idea to separate them out. Are my idea correct or wrong?

3) I am seeking for better DATABASE DESIGN, because I know the database will
become huge in future. I request for your idea and opinion.

Thank you very much.

[forumnotifier]

Hi

I am working on one project which involve multiple function site, such as
Company Product Catelog, Customer Support Forum, Document Exchange Engine and
etc...

Normally we will combine ALL TABLEs into one DATABASE.

My question are:
1) Is my break them to individual DATABASE, will it perform better?
Means Product Catelog and Forum will have different DATABASE, but they
will using the same DOMAIN NAME.

2) I am worried about the break down and corruption of DATABASE, so I have the
idea to separate them out. Are my idea correct or wrong?

3) I am seeking for better DATABASE DESIGN, because I know the database will
become huge in future. I request for your idea and opinion.

Thank you very much.

[forumnotifier]

Hi

I am working on one project which involve multiple function site, such as
Company Product Catelog, Customer Support Forum, Document Exchange Engine and
etc...

Normally we will combine ALL TABLEs into one DATABASE.

My question are:
1) Is my break them to individual DATABASE, will it perform better?
Means Product Catelog and Forum will have different DATABASE, but they
will using the same DOMAIN NAME.

2) I am worried about the break down and corruption of DATABASE, so I have the
idea to separate them out. Are my idea correct or wrong?

3) I am seeking for better DATABASE DESIGN, because I know the database will
become huge in future. I request for your idea and opinion.

Thank you very much.

[ky_loh]

Hi

I am working on one project which involve multiple function site, such as
Company Product Catelog, Customer Support Forum, Document Exchange Engine and
etc...

Normally we will combine ALL TABLEs into one DATABASE.

My question are:
1) Is my break them to individual DATABASE, will it perform better?
Means Product Catelog and Forum will have different DATABASE, but they
will using the same DOMAIN NAME.

2) I am worried about the break down and corruption of DATABASE, so I have the
idea to separate them out. Are my idea correct or wrong?

3) I am seeking for better DATABASE DESIGN, because I know the database will
become huge in future. I request for your idea and opinion.

Thank you very much.

[Dan Bracuk]

You have to look at the potential relationships to answer your question.

If, for example, Company Products are completely separate from Document
Exchange, then 2 dbs might be better. However, if they share the same
users/customers, then one db is probably better.

[ky_loh]

i was thinking about ALL Users in one DB
Company Product Cateloge in one DB
Document Exchange in one DB
Forum in one DB

what are the disadvantage if I do that?

I understand that the server will open 3 connections in order to execute one
multiple tasks.......will it slow down the speed or it will waste my hardware
resource?

[Dan Bracuk]

If you need a user id in your forum, how are you going to set up your foreign key if the user table is another db?