March 9, 2010 at 12:51 pm
Hello,
I was wondering if there was a step by step resource on implementing MDM on SQL Server 2008.
Thanks.
+ive
March 9, 2010 at 1:11 pm
Of course, proper database design will allow proper MDM, known as Normalization. Using constraints and the tools available in SQL Server to properly design the database. None of my transactional databases I have designed have duplicate data. I always make sure the users give me exactly what I expect. I verify and cleanse the data BEFORE it gets into the database. This can be from a website form, or being pumped in thru SSIS.
the human mind is still the very best tool to ensure the database is designed correctly, and to be secure from bad data. The database only stores what it is told, as long as the data is the correct data type. It is up to the human to properly design a database, and a system to ensure just that.
Andrew SQLDBA
March 9, 2010 at 1:12 pm
There is no recipe step-by-step guide. You need to look at the business, and the business rules and apply those rules to the database design. Hire an excellent database architect and a great database developer
Andrew SQLDBA
March 9, 2010 at 1:13 pm
Are you talking about the Master Data Management features of SQL Server 2008 R2?
Do you have an environment complex enough to make use of that (multiple databases with related information, information exchange, authoritative source, etc)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 10, 2010 at 8:01 am
All,
Thanks for your guidance. I am part of a project offering my services as database admin/analyst/architect. But this new database will be followed by 3 other databases and will have (master) data that will be accessed by the other databases. I am specifically looking for Master Data Management features of SQL Server 2008 R2 that could help manage multiple databases with related information.
The material that I could get was white papers on MDM SQL Server 2008 R2 road map but nothing that I could use immediately and implement MDM concepts.
+ive
March 10, 2010 at 8:06 am
I doubt there will be any resources or best practice yet. R2 hasn't even been released yet.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply