EAV
-
Comments posted to this topic are about the item EAV
-
Very easy one, actually it took me 2 sec to read the options and answer. 😀
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant -
Gracias por la más fácil Steve
+1 🙂
-
Nice and easy -thanks Steve
Hope this helps...
Ford Fairlane
Rock and Roll Detective
-
Also known as "Deep Tables". I'll start calling them EAVs now to confuse my boss.
-
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
Good way to start the week. Thanks, Steve.
-
Thanks for the question on EAVs. They are a very controversial topic. I have designed databases that used them for PART of the schema. However, I always use them with some reluctance.
In particular, I used them when I did the data model for LAN Desk for Intel. It was a product that, among other things, had to track the configuration information for systems on the network. Hardware and software had to be modeled, as well as the relationships between components. It got kind of messy when you had to store information about daughter cards mounted on the motherboard that were being used as RAM drives! (Just to name one example.) Plus, the database had to account for all the possible ways that technology would add in new kinds of things to put in a computer, new attributes that you didn't even envision, and new ways for things to be related. It was fun, but it took a lot of time to explain to the developers.
[Fixed typo.]
[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn -
Very, very easy. Thanks, Steve!
-
Good way to start the QOTD week.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
in case you haven't already seen it: Dave's Guide to the EAV
http://weblogs.sqlteam.com/davidm/articles/12117.aspx
highly recommended.
-
EZ PZ. 🙂
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply