This may not be the right forum for this question so my appologies in advance. But I turn to this group as a last resort...
To give an example of my problem/question:
Suppose I have a database that stores photos and "tags" (search keywords) associated with each photo. Of course the binary of the photo is not in the database itself.
I want to be able to support searches for one of more key words. This database has a potential of hundreds of thousands of records (of photos) and therefore many more for search tags since each photo can have many tags associated with it.
I know how design a data model using my OLTP data modeling skills. But I haven't a clude what the data model should for OLAP/Data warehousing kinds of jobs.
I'd appreciate it if someone could give me an example of how this data should be denormalized so as to be highly performant for searches. I'm using MS SQL 2000 but could use 2005 if there is something there that will make things faster/better/easier etc.
Thanks.
To give an example of my problem/question:
Suppose I have a database that stores photos and "tags" (search keywords) associated with each photo. Of course the binary of the photo is not in the database itself.
I want to be able to support searches for one of more key words. This database has a potential of hundreds of thousands of records (of photos) and therefore many more for search tags since each photo can have many tags associated with it.
I know how design a data model using my OLTP data modeling skills. But I haven't a clude what the data model should for OLAP/Data warehousing kinds of jobs.
I'd appreciate it if someone could give me an example of how this data should be denormalized so as to be highly performant for searches. I'm using MS SQL 2000 but could use 2005 if there is something there that will make things faster/better/easier etc.
Thanks.