Friday, August 29, 2014
Minimize

LCM Research, Inc. Blog

By Larry Mrazek on 8/23/2014 7:14 AM

A quick discussion on options for small businesses needing a database solution ... discussing cloud, desktop and hybrid approaches to data management, including Microsoft Access, Excel, SQL Server and custom.

By Larry Mrazek on 8/18/2014 8:09 PM

More on EAV and Dynamic Data with SQL and ASP.NET

The first link outlines some of the problems with the EAV model ... querying and reporting. 

By Larry Mrazek on 8/17/2014 7:40 PM
Read some interesting posts this weekend ... EAV (pros and cons), and other DB models: 

Extensible Data Modeling -  http://www.slideshare.net/billkarwin/extensible-data-modeling Dave's Guide to the EAV -  http://weblogs.sqlteam.com/davidm/articles/12117.aspx Custom Fields in a Database - http://social.msdn.microsoft.com/Forums/sqlserver/en-US/a87e55c9-0760-4071-b222-354272d8541b/custom-fields-in-database EAV (Wikipedia entry) - http://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model I'm looking for different solutions for an old client of mine ... he tends to want to change things a lot, thus my interest in EAV ... which would work, since it is a smaller DB, and won't ever grow to a million plus rows.  Still thinking ...

...
Home|News|Who We Are|Blog|Contact Us | Terms Of Use | Privacy Statement
Copyright 2013 by LCM Research, Inc.