Design Forum - Database design problem

Articles |
News |
Weblogs |
Books |
Forums

Artima Forums | Articles | Weblogs | Java Answers | News

Sponsored Link •

Design Forum
Database design problem

1 reply on 1 page. Most recent reply: May 3, 2006 1:34 AM by Vijay Nathani

Welcome Guest
Sign In

Back to Topic List

Reply to this Topic

Search Forum

Threaded View


Previous Topic		Next Topic

Flat View: This topic has 1 reply on 1 page

Ahmad Yousef

Posts: 1
Nickname: ahmadraw
Registered: Mar, 2006

Database design problem

Posted: Mar 9, 2006 1:54 AM

Hi,

I have two questions, I would apprecitae that if anybody could answer anyone of them.

1) does the database size increases as you insert new rows with many null values? I mean what is the most influencing factor in the database size, is it the number of rows or the number of non null-values inserted?

2) Is it a good idea to allow the user to add new columns to my database table?

thanks to all.

Vijay Nathani

Posts: 29
Nickname: vijaynath
Registered: Jan, 2006

Re: Database design problem

Posted: May 3, 2006 1:34 AM

Here are my answers:

> 1) does the database size increases as you insert new rows
> with many null values? I mean what is the most influencing
> factor in the database size, is it the number of rows or
> the number of non null-values inserted?
Yes. The database size will increase as you add new rows, even if the rows contains nulls.
Both the non-null values and number of rows influence the database size.

>
> 2) Is it a good idea to allow the user to add new columns
> to my database table?
It is a bad idea. It indicates database has probably not been designed correctly. Users should add more rows to exisiting tables. They must not create new tables or modify existing tables. Then, it is good database design.

Vijay Nathani,
www.geocities.com/vijay_nathani.

Flat View: This topic has 1 reply on 1 page

Previous Topic

Next Topic


	Web Artima.com