I would like to start discussion or find your opinion around "if sharepoint 2007 is a good platform to store relational data"? I found that quite often bussness doesn't feel that and push dev to create solution for relation data on top of sharepoint infrastructe.
On the end we get huge customization with make everybody frustrated and those poor dev gays are blame for that.
I believe that needs for relation data in particular solution draws clear line between apps build on top of Sharepoint or apps build with use of good old SQL database. Can I get your opinion around that ? I have three years expieriance with SharePoint and
this is my personal opinion. If you could share your thoughts then for sure this would be helpfull for me and for other dev to show to the bussness why we somethimes suggesting them to go diffrent way.
To build this discussion on some example let say that we need to build solution where:
we have product table (with details around products) with contain two relation fields : user by country, owner by country
we have country table (dictionary for countries), which contain field pointing to the region
we have region table (dictionary for regions) we have few diffrents tables describing diffrent types of docs associated to products (like specyfication, safty documents, test documents)
and let say there there goanna be a lot
View Complete Post