EAV Model

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Noel McKinney » EAV Model

EAV Model

Rate Topic

Display Mode

Topic Options

Author

Message

Noel McKinney

Posted Monday, October 12, 2009 11:36 PM

SSCrazy

Group: General Forum Members
Last Login: Thursday, April 05, 2012 2:35 PM
Points: 2,007, Visits: 767

Comments posted to this topic are about the item EAV Model

Post #801943

SuperDBA-207096

Posted Tuesday, October 13, 2009 4:53 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, January 02, 2013 12:15 PM
Points: 1,443, Visits: 711

Good Question!

Never heard it referred to as open schema, but it make sense, mostly EAV or name-value pairs.

Mark

Post #802059

Dan Guzman - Not the MVP

Posted Tuesday, October 13, 2009 9:09 AM

Say Hey Kid

Group: General Forum Members
Last Login: Friday, April 26, 2013 11:57 AM
Points: 708, Visits: 660

I was pretty sure one of the options was going to be 'A phase' Smile

Post #802214

dcawvive

Posted Tuesday, October 13, 2009 10:11 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, April 08, 2011 8:55 AM
Points: 274, Visits: 149

It's also known as a "Stuff" table. All the company's stuff is thrown into 1 table. It ensures that performance is dismal and is a great method to ensure that a contract data architect makes a big fee when you have to bring them in to redesign the entire system the right way.

Post #802267

BudaCli

Posted Thursday, October 15, 2009 4:03 AM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:16 AM
Points: 1,046, Visits: 575

Learned something new today.

What you don't know won't hurt you but what you know will make you plan to know better

Post #803311

Mark D Powell

Posted Friday, October 16, 2009 2:11 PM

Ten Centuries

Group: General Forum Members
Last Login: Monday, June 10, 2013 12:39 PM
Points: 1,266, Visits: 343

What EAV should really be called is "unscalable".

While having a table or two in your application that are in EAV format should be fine the programmers who try to build an entire application using 1 to 4 EAV tables holding all the application tables are a riot.

I do not know how many times over the last decade I have seen threads where the OP finally laid out the design of their application after trying to get help on a query. For some reason the developer thought that their was the first shop to ever try this idea. The developers were usually not happy when presented with links to articles on why the design will usually not work in the real world.

I have never heard of Open Schema for this.

-- Mark D Powell --

Post #804529

The Dixie Flatline

Posted Tuesday, October 20, 2009 8:09 PM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 2:35 PM
Points: 3,840, Visits: 5,641

I was looking for "MUCK" to be an option.

"Open Schema" makes it sound like a legitimate approach to database design.

__________________________________________________

Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? -- Stephen Stills

Post #806217

« Prev Topic | Next Topic »

Permissions