Relationally Divided over EAV

Question

Relationally Divided over EAV

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

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

Stephen Hirsch SSCommitted Points: 1822 More actions · Answer 1

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: 10472 More actions · Answer 2

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: 125519 More actions · Answer 3

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: 2228 More actions · Answer 4

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...