Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««7891011

Database Design and Reference Tables Expand / Collapse
Author
Message
Posted Wednesday, September 27, 2006 3:11 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 03, 2013 10:38 AM
Points: 199, Visits: 55

Sounds like the new Access engine will help the guys out that want a poor design...

http://www.pcw.co.uk/articles/print/2163161




Post #311709
Posted Thursday, September 28, 2006 8:33 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, April 08, 2014 12:31 PM
Points: 50, Visits: 280
If there isn't a policy to stop 'really bad' articles being published on SQLServerCentral, there should at least be one that stops said articles appearing in the "One year ago..." section of the newsletter. Re-promoting these articles gives credence where absolutely none is due!
Post #311901
Posted Thursday, September 28, 2006 8:49 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, March 31, 2014 10:05 AM
Points: 2,553, Visits: 559
For that the articles would have to be flagged in some way and/or the site-owners would have to read the comments & response posts to every single article..kinda monumental..that task...

You could always post this in the "Suggestions" forum...I know for a fact that all suggestions are considered very seriously by Steve etc..








**ASCII stupid question, get a stupid ANSI !!!**
Post #311913
Posted Wednesday, October 11, 2006 8:08 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 27, 2014 8:18 PM
Points: 1, Visits: 17
IMO having one physical table representing multiple logical tables is extremely poor design - I'm surprised a normally reputable/conservative site such as SQL Server Central would promote this idea

Having one physical table per logical lookup table has benefits as follows:

- Easier to reverse-engineer a data model from a physical database
- Improved performance as database page hits are more likely to be on discrete pages for disparate tables (tiny as little tables like these are probably cached but every little bit helps)
- Lends itself to minor divergence e.g. a specific lookup table has an extra column other than code/description pairs
- Allows tables to have names that represent their function

I've seen all 3 variants on this:

1. 1 physical table per logical table
2. 1 physical table for ALL logical tables but named views representing each logical table
3. I physical table for ALL logical tables and you just have to know how to code it

In my opinion these variants are listed above in decreasing order or desirability
Post #314803
Posted Thursday, September 18, 2008 2:40 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 03, 2014 3:49 PM
Points: 1, Visits: 24
Generic lookup tables may seem to be good solutions at first. It leads to complexity, rigidity of design, and lack of referential integrity to name a few. Please read this article http://www.sqlservercentral.com/articles/Advanced/lookuptablemadness/1464/#
Post #572156
Posted Tuesday, July 20, 2010 9:15 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, November 26, 2013 5:49 PM
Points: 56, Visits: 15
Glad to hear that other people thought this idea was horrible.
Post #956050
« Prev Topic | Next Topic »

Add to briefcase «««7891011

Permissions Expand / Collapse