Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Database structure enigma
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 11/24/2012 :  10:37:08  Show Profile  Visit slyth's Homepage  Click to see slyth's MSN Messenger address  Reply with Quote
A vendor of ours has structured the data so that all data entities are grouped within a single entity for all relations, stating that this may provide performance benefits when using SQL Server. I have never seen such a weird way of going about normalization of data, however I might not be experienced in "avante-garde" designs.

For example,
DBID PersonID PersonName PersonAddress

DBID ClientID ClientName ClientAddress ClientTelephone

DBID represents a company database. So logically each DBID refers to a separate database, whilst physically each entity would have its own DBID so that the SQL developer would be able to query each database separately. This might create some duplication of data since the DBID has to be stored as a field in each row of data.

I am not a certified SQL Server administrator, however, from a conceptual point of view I saw the design as logic which does not make any sense to me, however, I would like your opinion about it.


Constraint Violating Yak Guru

285 Posts

Posted - 11/25/2012 :  23:47:52  Show Profile  Reply with Quote
Could you provide example in more detail (with data and sample queries)?
Go to Top of Page

Bustaz Kool
Flowing Fount of Yak Knowledge

1834 Posts

Posted - 11/26/2012 :  14:27:49  Show Profile  Reply with Quote
How many actual databases are there? From your description, it sounds like there is a common database that is used to point to a company specific database. Is this true?

We are far more concerned about the desecration of the flag than we are about the desecration of our land. -Wendell Berry
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000