Thursday, October 23, 2014
Minimize

LCM Research, Inc. Blog

By Larry Mrazek on 9/1/2014 3:29 PM

Given Microsoft Access's continuing use in small (and occasionally large) businesses, there are many resources out their providing "best practices" and hints for the novice and experienced developer. 

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.