SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
05-10-2008, 02:06 PM
| ||||
| ||||
 Effective DB Design Question Hi DB Gurus, Excuse me for raising this question not strictly on pgsql. 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 of thousands of products with tens of hundreds of different attributes that any product will only be applicable to a small fraction of them. Is it possible to design an effective schema for this? Many thanks in advance! Jerry      |
|
05-10-2008, 02:06 PM
| ||||
| ||||
| Re: Effective DB Design Question 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@tailorware.org.uk) |
Linear Mode
