Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Sql > Re: Effective D...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 2 Topic 3459 of 3799
Post > Topic >>

Re: Effective DB Design Question

by jr <jorg.raskowski@[EMAIL PROTECTED] > May 10, 2008 at 01:30 PM

jerryji wrote:
> As a simplified example, the schema products(productid INTEGER, price
> REAL, for_region GEOM, warranty_till DATE, package_byte INTEGER) is
> not efficient for a company that produces both cars and software
> because cars won't need package_byte column while software won't need
> for_region column. In a real life case, the superset could have tens
> 
> Is it possible to design an effective schema for this?

Inheritance?

-- 

regards, jr.  (jr@[EMAIL PROTECTED]
)
 




 2 Posts in Topic:
Effective DB Design Question
jerryji <jerryji1976@[  2008-05-09 14:03:18 
Re: Effective DB Design Question
jr <jorg.raskowski@[EM  2008-05-10 13:30:08 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 21:28:52 CST 2008.