Relationally Divided over EAV

  • Stephen Hirsch

    SSCommitted

    Points: 1822

    I remember hearing a surgeon talk about his surgical memoir. It really struck me. He said, the first 10 years, you learn how to cut. The next 10 years, you learn when to cut. The next 10 years, you learn when not to cut.

  • David McKinney

    SSChampion

    Points: 10449

    SwePeso (12/9/2013)


    Here is a link to download the schema of my hybrid solution.

    It can also be found on my web page http://www.sqltopia.com[/quote%5D

    Just starting to try to get my head around your schema...a couple of questions.

    1) Most of the tables have primary keys, except factHeuristic and factPair, however both of these have Unique Clustered Indexes and no nullable columns. Any chance of an explanation as to why you didn't go for a PK? I'm thinking it has got something to do with the Partition Scheme?

    2) I'm interested in using this technique for an Oracle solution, but Oracle doesn't support included columns in indexes. Any thoughts on my chances of success - or is this key? Could I for example create new or extend existing indexes to literally cover these included columns?

    I'm working from the pdf document...I wonder has it been written up in more detail elsewhere?

    It really does look very promising, but not easy for a aging brain like mine to digest.

    Many thanks,

    David McKinney.

  • Eric M Russell

    SSC Guru

    Points: 125089

    Stephen Hirsch wrote:

    I remember hearing a surgeon talk about his surgical memoir. It really struck me. He said, the first 10 years, you learn how to cut. The next 10 years, you learn when to cut. The next 10 years, you learn when not to cut.

    If literally true, then I want a surgeon with gray hair.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • SAinCA

    SSCrazy

    Points: 2101

    Hoping the broken links can be mended... please...

    Thanks for re-posting as an editorial - may just be at the right time for a hell-hole of an "unknown" attributes per customer problem with a horrendously wide table...

Viewing 4 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply