locked
Recursive Relationships RRS feed

  • Question

  • Hello everyone,

    Can any one explain me how to avoid recursive relationships in data modeling or how to eliminate recursive relationships.I searched in google but I didnt find any.

    Thanks

    Sunday, October 30, 2011 2:43 PM

Answers

  • >Can any one explain me how to avoid recursive relationships in data modeling or how to eliminate recursive relationships.I searched in google but I didnt find any.

    You don't. If the UoD (Universe of Discourse) is such that a correct
    model is recursive, then your model should be recursive.


    Hugo Kornelis, SQL Server MVP
    My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
    • Proposed as answer by Peja TaoEditor Tuesday, November 1, 2011 2:21 AM
    • Marked as answer by Peja TaoEditor Friday, November 4, 2011 1:22 PM
    Sunday, October 30, 2011 2:47 PM
  • Why would you want to?

    People who think they know about datawarehouse design often flatten into repeated columns/keys but that's restrictive and asking for trouble.

    • Proposed as answer by Peja TaoEditor Tuesday, November 1, 2011 2:21 AM
    • Marked as answer by Peja TaoEditor Friday, November 4, 2011 1:22 PM
    Monday, October 31, 2011 4:10 PM

All replies

  • >Can any one explain me how to avoid recursive relationships in data modeling or how to eliminate recursive relationships.I searched in google but I didnt find any.

    You don't. If the UoD (Universe of Discourse) is such that a correct
    model is recursive, then your model should be recursive.


    Hugo Kornelis, SQL Server MVP
    My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
    • Proposed as answer by Peja TaoEditor Tuesday, November 1, 2011 2:21 AM
    • Marked as answer by Peja TaoEditor Friday, November 4, 2011 1:22 PM
    Sunday, October 30, 2011 2:47 PM
  • Why would you want to?

    People who think they know about datawarehouse design often flatten into repeated columns/keys but that's restrictive and asking for trouble.

    • Proposed as answer by Peja TaoEditor Tuesday, November 1, 2011 2:21 AM
    • Marked as answer by Peja TaoEditor Friday, November 4, 2011 1:22 PM
    Monday, October 31, 2011 4:10 PM