The ORM Foundation

Ken and Victor, thank you both for your thoughts. There is certainly a potential here for the scope of the discussion to quickly explode into numerous topics that are each comprehensive, so I will make an attempt at responding to both with a few more steps to explain some of my thoughts on where "SchemaCop" may arrive as a first build. ...

 Sorry.. not on subject.. but I've been eyeing the kindle for a little while. How do you like it? The price seems just above what I think it should be but I am strongly considering purchasing one.

 Ken, I appreciate the thoughtful reply. I don't think the core question is knowing what is meant by a correct conceptual model. I apologize if somehow I called that into question. Let me back up and try to describe just the function of what I imagine SchemaCop to do.. it is helpful if you have used FxCop, as that is a parallel concept as ...

Ken, thanks for your reply. I did manage a couple reverse engineerings of physical dbs using VEA, and it seemed to do an OK job at it. The issue comes in the fact that often the physical model is far removed from the original intent conceptually. This happens usually because there is a lack of a conceptual model, poor data modeling skills, changes ...

I've been working a little on the idea of an application called SchemaCop.. which is to be for physical database models what the .NET application FxCop is for the .NET framework. I think anyone who has experienced working with an existing data model in the majority of cases will face models that lack normalization, referential integrity, and ...