SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

slyth
Starting Member

Malta
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,
Person
DBID PersonID PersonName PersonAddress

Client
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.

Jon

namman
Constraint Violating Yak Guru

USA
272 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

USA
1693 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  
 New 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.08 seconds. Powered By: Snitz Forums 2000