FYI: DB2 for LUW Best Practices

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Serge Rielau

    FYI: DB2 for LUW Best Practices

    The DB2 development team has compiled a set of best practices for DB2
    for LUW which can be found here:


    Feedback (completeness, too much, too little, consumability, ...) much
    appreciated.

    Enjoy
    Serge

    --
    Serge Rielau
    DB2 Solutions Development
    IBM Toronto Lab
  • Philipp Post

    #2
    Re: FYI: DB2 for LUW Best Practices

    Serge,

    thanks for your message. First I think, it is good to have a set of
    best practices easily accessible as offered here.

    However I am surprised to see in "Physical database design", p. 9 the
    one-true-lookup-table advocated. There has just been a nice thread in
    comp.databases on this and there are a lot of good arguments to be
    made against.



    Indeed it is not much fun for a front-end coder to issue edit forms
    for all those lookup tables, however if one form pattern is created,
    it could be easily copied and pasted and slightly amended to match the
    respective lookup table.

    Personally, the cons against the OTLT design convince me more than the
    pros.

    brgds

    Philipp Post

    Comment

    • Serge Rielau

      #3
      Re: FYI: DB2 for LUW Best Practices

      Philipp Post wrote:
      Serge,
      >
      thanks for your message. First I think, it is good to have a set of
      best practices easily accessible as offered here.
      >
      However I am surprised to see in "Physical database design", p. 9 the
      one-true-lookup-table advocated. There has just been a nice thread in
      comp.databases on this and there are a lot of good arguments to be
      made against.
      >

      >
      Indeed it is not much fun for a front-end coder to issue edit forms
      for all those lookup tables, however if one form pattern is created,
      it could be easily copied and pasted and slightly amended to match the
      respective lookup table.
      >
      Personally, the cons against the OTLT design convince me more than the
      pros.
      Interesting. I think the truth is neither black nor white.
      Presumably the intent of the authors was not to merge "dimension tables"
      at large. I have passed your information on and we'll see what the
      authors have to say in their defense :-)

      Cheers
      Serge

      --
      Serge Rielau
      DB2 Solutions Development
      IBM Toronto Lab

      Comment

      • Lennart

        #4
        Re: FYI: DB2 for LUW Best Practices

        On Jun 25, 3:58 pm, Serge Rielau <srie...@ca.ibm .comwrote:
        Philipp Post wrote:
        Serge,
        >
        thanks for your message. First I think, it is good to have a set of
        best practices easily accessible as offered here.
        >
        However I am surprised to see in "Physical database design", p. 9 the
        one-true-lookup-table advocated. There has just been a nice thread in
        comp.databases on this and there are a lot of good arguments to be
        made against.
        >>
        Indeed it is not much fun for a front-end coder to issue edit forms
        for all those lookup tables, however if one form pattern is created,
        it could be easily copied and pasted and slightly amended to match the
        respective lookup table.
        >
        Personally, the cons against the OTLT design convince me more than the
        pros.
        >
        Interesting. I think the truth is neither black nor white.
        Presumably the intent of the authors was not to merge "dimension tables"
        at large. I have passed your information on and we'll see what the
        authors have to say in their defense :-)
        >
        Can anyone repost the link from Serges first post, the first msg in
        this thread is not visible in google news :-(



        Cheers
        Serge
        >
        --
        Serge Rielau
        DB2 Solutions Development
        IBM Toronto Lab

        Comment

        • Lennart

          #5
          Re: FYI: DB2 for LUW Best Practices

          On Jun 25, 6:07 pm, Lennart <Erik.Lennart.J ons...@gmail.co mwrote:
          On Jun 25, 3:58 pm, Serge Rielau <srie...@ca.ibm .comwrote:
          >
          >
          >
          Philipp Post wrote:
          Serge,
          >
          thanks for your message. First I think, it is good to have a set of
          best practices easily accessible as offered here.
          >
          However I am surprised to see in "Physical database design", p. 9 the
          one-true-lookup-table advocated. There has just been a nice thread in
          comp.databases on this and there are a lot of good arguments to be
          made against.
          >>
          Indeed it is not much fun for a front-end coder to issue edit forms
          for all those lookup tables, however if one form pattern is created,
          it could be easily copied and pasted and slightly amended to match the
          respective lookup table.
          >
          Personally, the cons against the OTLT design convince me more than the
          pros.
          >
          Interesting. I think the truth is neither black nor white.
          Presumably the intent of the authors was not to merge "dimension tables"
          at large. I have passed your information on and we'll see what the
          authors have to say in their defense :-)
          >
          Can anyone repost the link from Serges first post, the first msg in
          this thread is not visible in google news :-(
          >
          Never mind, now it is


          /Lennart

          Comment

          • Christopher Keller

            #6
            Re: FYI: DB2 for LUW Best Practices

            Serge Rielau wrote:
            The DB2 development team has compiled a set of best practices for DB2
            for LUW which can be found here:

            >
            Feedback (completeness, too much, too little, consumability, ...) much
            appreciated.
            >
            Enjoy
            Serge
            >
            Have only read the Storage best practice, but found this to be an excellent
            introduction and have urged my colleagues to bookmark the site. Thanks, Chris

            Comment

            Working...