Re: Data model design problem

"S Krishnan" <santakris_at_hotmail.com> wrote in message news:3b1eb79a_at_news.microsoft.com...
> Hi:
>
> Am designing a data model for an application that needs to track info on
> customers. However, the nature of information
> that needs to be tracked keeps on changing with time. For instance, today
 we
> don't need to find what cars people drive
> but this may become important tomorrow. All the information that would be
> collected can be classified into some categories
> such as demographic info, professional info, etc. However the specific
> fields within these categories can change. These changes will be done
> through the front-end or scripts.
>
> The primary use of this database is to query for customers with specific
> attributes, say, 30-50 year olds who work as designers, for instance.
> Typical queries are much more complex and performance is a significant
> factor in the design.

Have you considered keeping a table with attribute-type and value?

<Pierre/> Received on Thu Jun 07 2001 - 21:35:50 CDT