I have been introduced to Anchor Modeling 2 months ago when I started my new project that attributes of my entity are changing. I also need to keep historical data for my entity with in mind this is my warehouse. This entity will go to have 200 to 300 attributes. I plan to use Anchor modeling because it fits very well to my requirement.
Only thing that is in mind for last 2 months is performance with all those attribute.
I would appreciate if someone can help me with that if you think there would be problem with performance.
If you do select * you will not use the benefit of table elimination and your performance will most likely be worse than a 3NF model, but it could still be better if there are many versions of your data and attributes are historized asynchronously with respect to each other, or if you have where-conditions that are very selective and over columns for which the database has collected statistics, or when data is sparse.
AM models are very good when you have sparse data because you will only store data that has been specified. Null values correspond to the absence of rows in Anchor Modeling, resulting in less data to scan during query execution.
If your data is dense, static, and you often need to fetch all attributes at the same time in queries that have few or no conditions (and therefore result in big joins), then performance will suffer.
we have about 200 to 300 attributes that we want to add to our DB model. If we are going to add them through Anchor modeling tool it takes too long. We built a simple application to add these attribute to XML model. it works but generated SQL server svript is not workong properly.
So I was wondering if you have such a tools we can use to add these attributes in one batch.