UNION Help

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » UNION Help

12 posts, Page 2 of 2

««1 2

UNION Help

Rate Topic

Display Mode

Topic Options

Author

Message

Eugene Elutin

Posted Tuesday, September 11, 2012 7:55 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 9:40 AM
Points: 2,596, Visits: 4,507

CELKO (9/11/2012)

I have a database that contains a number of individual tables for each sales agents.

This design flaw is called attribute splitting. Would you have “Male_Personnel” and “Female_Personnel” tables or a single “Personnel” table? Pretty obvious, isn't it? ...

That is really bright idea! Actually, taking in count progress of the west civilization in whole, you need at least three tables:
“Male_Personnel”, “Female_Personnel” and "Unknown_Personnel" Hehe

Actually the attribute splitting may not be a flaw, but done on purpose. One of the common places where you can see this kind of picture is data warehouses (non-conformed dimensions).

There are other design patterns where attribute splitting is a feature - not a flow.

_____________________________________________
"The only true wisdom is in knowing you know nothing"
"O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!" BigGrin

(So many miracle inventions provided by MS to us...)

How to post your question to get the best and quick help

Post #1357428

Brandie Tarvin

Posted Tuesday, September 11, 2012 8:09 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 9:57 AM
Points: 6,724, Visits: 5,796

Eugene Elutin (9/11/2012)

Actually the attribute splitting may not be a flaw, but done on purpose. One of the common places where you can see this kind of picture is data warehouses (non-conformed dimensions).

Or companies that vend solutions to multiple customers and can't mix their data for legal reasons. Like health insurance software companies that host the data on site. I actually worked for one of those.

Of course, in that instance, any request to mingle the data via UNION (at least in the U.S.) would be a Bad Idea.

Brandie Tarvin, MCITP Database Administrator, MCDBA, MCSA

Webpage: http://www.BrandieTarvin.net
LiveJournal Blog: http://brandietarvin.livejournal.com/
On LinkedIn!, Google+, and Twitter.

Freelance Writer: Shadowrun
Latchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

Post #1357444

« Prev Topic | Next Topic »

12 posts, Page 2 of 2

««1 2

Permissions