No. 45 - Entity Attribute Value (EAV) SQL anti-patterns

Food, Drinks will be provided!

SQL Social brings together Database & BI professionals, industry experts and those with an appetite for learning more about data & information management, in a relaxed atmosphere to network, share ideas, impart knowledge, and have a great time whilst doing so.

We will provide you with plenty of food and drinks for the evening, all thanks to our fantastic sponsors (see below). Networking

At SQL Social, our aim is to give YOU the opportunity to meet with MVPs, well-known speakers, experienced professionals & industry experts and ask them about the data-related topics that matter to you. It is an opportunity to meet new people, make new friendships and find out what is going on in the data industry in Melbourne.

This Month's Speaker and Topic

Igor Rozenberg

Igor is a Senior Consultant at UXC. He graduated in Robotics and Computing in Moscow USSR before arriving in Australia in 1992. His first experience with relational databases was with Microsoft Access and has worked with Microsoft SQL Server (since version 6.5 to Azure SQLDB). He does toy with other RDBMS such as DB/2, Oracle and Sybase. His hobbies include Space exploration, and he is a member of the Space Association of Australia.

This session is dedicated to revealing "The god, the bad and the ugly" sides of EAV (Entity Attribute Values) modelling that is based on the mathematical notion of a sparse matrix.

First we'll show what could be wrong with a brute force approach to implementing EAV and compare side-by-side traditional row-based entity implementation with EAV implementation.

Then we will show a pragmatic implementation of and EAV model build on top of a RDBMS (like SQL Server) based on experience with two-way synchronization challenges between a centralized server database and local databases on occasionally connected tablet devices.

Our Sponsors:

As always, we are very fortunate to our core sponsors on board who will ensure that we are suitably fed and watered. A big thank you to Lobsterpot Solutions and Pluralsight for their ongoing support of this great community event!

LobsterPot Solutions is a specialist SQL Server consultancy. Founded in 2008 we specialise in Data Platform and Business Intelligence including Data Warehousing and Reporting technologies. LobsterPot Solutions also has a strong focus on training with most of our consultants being Microsoft Certified Trainers who regularly present at local and international events. This combination allows us to offer advice, mentoring and customised training as part of our standard service offering.

Pluralsight is the global leader in high-quality online training for hardcore developers. The revolutionary Pluralsight training library provides developers with instant access to a rich collection of online training courses delivered by industry authorities. See what you can learn at pluralsight.com and join the @pluralsight community on Twitter.

See you there!