dbTalk Databases Forums  

English help: name a boolean value that means "if it makes senseto calculate the sum of the field"

comp.databases.postgresql comp.databases.postgresql


Discuss English help: name a boolean value that means "if it makes senseto calculate the sum of the field" in the comp.databases.postgresql forum.



Reply
 
Thread Tools Display Modes
  #91  
Old   
Zhang Weiwu
 
Posts: n/a

Default Re: [SOLVED] Re: English help: name a boolean value that means "ifit makes sense to calculate the sum of the field" - 06-16-2008 , 01:50 AM






Lew wrote:

Quote:
This is a business-logic question, not a data question. The database
should not be storing how to use a column in another column. That is
not data modeling.

(All generalizations disclaimed with "usually".)
I understand what you mean. But our contract with our customer says we
must make a database application that allows user to add new type of
data without changing database structure (a.k.a. no ALTER TABLE). This is
the bidding requirement and other competitors all say they can do that.
In the end we got the contract and we have to follow what we promised.

We have a vertical table where all data are like this:

id|data|type
01|0033|03
01|0344|06
....




Reply With Quote
  #92  
Old   
Zhang Weiwu
 
Posts: n/a

Default Re: [SOLVED] Re: English help: name a boolean value that means "ifit makes sense to calculate the sum of the field" - 06-16-2008 , 01:50 AM






Lew wrote:

Quote:
This is a business-logic question, not a data question. The database
should not be storing how to use a column in another column. That is
not data modeling.

(All generalizations disclaimed with "usually".)
I understand what you mean. But our contract with our customer says we
must make a database application that allows user to add new type of
data without changing database structure (a.k.a. no ALTER TABLE). This is
the bidding requirement and other competitors all say they can do that.
In the end we got the contract and we have to follow what we promised.

We have a vertical table where all data are like this:

id|data|type
01|0033|03
01|0344|06
....




Reply With Quote
  #93  
Old   
Zhang Weiwu
 
Posts: n/a

Default Re: [SOLVED] Re: English help: name a boolean value that means "ifit makes sense to calculate the sum of the field" - 06-16-2008 , 01:50 AM



Lew wrote:

Quote:
This is a business-logic question, not a data question. The database
should not be storing how to use a column in another column. That is
not data modeling.

(All generalizations disclaimed with "usually".)
I understand what you mean. But our contract with our customer says we
must make a database application that allows user to add new type of
data without changing database structure (a.k.a. no ALTER TABLE). This is
the bidding requirement and other competitors all say they can do that.
In the end we got the contract and we have to follow what we promised.

We have a vertical table where all data are like this:

id|data|type
01|0033|03
01|0344|06
....




Reply With Quote
  #94  
Old   
Zhang Weiwu
 
Posts: n/a

Default Re: [SOLVED] Re: English help: name a boolean value that means "ifit makes sense to calculate the sum of the field" - 06-16-2008 , 01:50 AM



Lew wrote:

Quote:
This is a business-logic question, not a data question. The database
should not be storing how to use a column in another column. That is
not data modeling.

(All generalizations disclaimed with "usually".)
I understand what you mean. But our contract with our customer says we
must make a database application that allows user to add new type of
data without changing database structure (a.k.a. no ALTER TABLE). This is
the bidding requirement and other competitors all say they can do that.
In the end we got the contract and we have to follow what we promised.

We have a vertical table where all data are like this:

id|data|type
01|0033|03
01|0344|06
....




Reply With Quote
  #95  
Old   
Zhang Weiwu
 
Posts: n/a

Default Re: [SOLVED] Re: English help: name a boolean value that means "ifit makes sense to calculate the sum of the field" - 06-16-2008 , 01:50 AM



Lew wrote:

Quote:
This is a business-logic question, not a data question. The database
should not be storing how to use a column in another column. That is
not data modeling.

(All generalizations disclaimed with "usually".)
I understand what you mean. But our contract with our customer says we
must make a database application that allows user to add new type of
data without changing database structure (a.k.a. no ALTER TABLE). This is
the bidding requirement and other competitors all say they can do that.
In the end we got the contract and we have to follow what we promised.

We have a vertical table where all data are like this:

id|data|type
01|0033|03
01|0344|06
....




Reply With Quote
  #96  
Old   
Zhang Weiwu
 
Posts: n/a

Default Re: [SOLVED] Re: English help: name a boolean value that means "ifit makes sense to calculate the sum of the field" - 06-16-2008 , 01:50 AM



Lew wrote:

Quote:
This is a business-logic question, not a data question. The database
should not be storing how to use a column in another column. That is
not data modeling.

(All generalizations disclaimed with "usually".)
I understand what you mean. But our contract with our customer says we
must make a database application that allows user to add new type of
data without changing database structure (a.k.a. no ALTER TABLE). This is
the bidding requirement and other competitors all say they can do that.
In the end we got the contract and we have to follow what we promised.

We have a vertical table where all data are like this:

id|data|type
01|0033|03
01|0344|06
....




Reply With Quote
  #97  
Old   
Zhang Weiwu
 
Posts: n/a

Default Re: [SOLVED] Re: English help: name a boolean value that means "ifit makes sense to calculate the sum of the field" - 06-16-2008 , 01:50 AM



Lew wrote:

Quote:
This is a business-logic question, not a data question. The database
should not be storing how to use a column in another column. That is
not data modeling.

(All generalizations disclaimed with "usually".)
I understand what you mean. But our contract with our customer says we
must make a database application that allows user to add new type of
data without changing database structure (a.k.a. no ALTER TABLE). This is
the bidding requirement and other competitors all say they can do that.
In the end we got the contract and we have to follow what we promised.

We have a vertical table where all data are like this:

id|data|type
01|0033|03
01|0344|06
....




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.