manasn's blog

Key Value Pair Data Model

articles: 

I have just joined an in flight project and find the lead data modeler has created a name value pair data model.

The reason given was flexibility of data model considering some records can have as many as 900 attributes. The .Net application team seem to be loving it, as they can code everything with very few tables in mind.

I feel the model is difficult to query, difficult to load and difficult to syndicate and in all likelyhood will suffer from poor performance. Also the data model can't be considered as a rich metadata repository and difficult to understand.

Subscribe to RSS - manasn's blog