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 123»»»

Some tips for working with big data models Expand / Collapse
Author
Message
Posted Wednesday, March 2, 2011 11:27 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 19, 2014 11:59 AM
Points: 2, Visits: 72
Comments posted to this topic are about the item Some tips for working with big data models
Post #1072353
Posted Thursday, March 3, 2011 1:54 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:18 AM
Points: 13,553, Visits: 10,429
How do you mix a star schema with a snowflake schema?



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1072386
Posted Thursday, March 3, 2011 7:25 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 10:37 AM
Points: 39, Visits: 897
Thank you, that is a nice overview to reference when coming up against a daunting task like this. I did want to throw one tool into the mix that has been a great addition to my arsenal. The Case/ERD tool Toad Data Modeler handles the nicest mix of features without breaking the bank. It was originally named Case Studio and then purchased by Quest, albeit with a price increase to boot. It now costs about $479 (~$450 at Programmers Paradise), but far less expensive than most other tools with similar capabilities like ER/Win. Data Modeler handles the majority of tasks in your article, while also providing other nice features like column, table and object notes and comments that can be printed as part of your data dictionary, which also show when hovering over the object diagram.

Also, I like the idea about colored rectangles to group related tables. Using Data Modeler, I color the tables by group and group them visually in a similar area, as much as possible, while also providing a legend in each area to denote what each color represents.

Once again, thank you for you contribution,
Tom



Post #1072544
Posted Thursday, March 3, 2011 9:12 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Thursday, August 7, 2014 8:32 PM
Points: 3,076, Visits: 782
Excellent summary and I agree with it all.

You should do articles on each individual point with examples.

Thanks,
Thomas LeBlanc
TheSmilingDBA


Thomas LeBlanc, MCITP DBA 2005, 2008 & MCDBA 2000
http://thesmilingdba.blogspot.com/
Post #1072629
Posted Thursday, March 3, 2011 9:32 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 12:11 PM
Points: 4,343, Visits: 6,150
ERStudio from Embarcadero is your friend when you have complex data models!

Best,

Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru at GMail
Post #1072647
Posted Thursday, March 3, 2011 9:58 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 10:24 AM
Points: 21,620, Visits: 15,279
Thank you, these are good tips.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #1072677
Posted Thursday, March 3, 2011 1:02 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 30, 2012 3:03 PM
Points: 15, Visits: 206
Just curious, who came up with article first?

http://eralokpandey.wordpress.com/2011/03/

Post #1072866
Posted Thursday, March 3, 2011 1:07 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, November 9, 2012 2:48 PM
Points: 493, Visits: 636
I agree with theSQLGuru - ERStudio can be very helpful in larger models. I am curious why you focus on the big table(s) and the one(s) that are most frequently used. I could see this as being important for space and archiving concerns, but for business logic I would walk the foreign keys and study the procedures. It would be interesting to hear from you in a future article about what kinds of problems your methodology has solved.
Post #1072872
Posted Thursday, March 3, 2011 2:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, May 19, 2014 11:59 AM
Points: 2, Visits: 72
Hello,

I can assure you that my article came first, since I did a lot of research before posting it here and found nothing similar. You can check that by the data of the post, since to publish articles here in SQLServercentral.com you have to wait the approval of the administration. It's very sad that nowadays you can see a complete copy of your work without authorization and even a simple reference.

Mauro Pichiliani
Post #1072911
Posted Thursday, March 3, 2011 2:15 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, August 13, 2014 4:00 AM
Points: 29, Visits: 226
Zielyn (3/3/2011)
Just curious, who came up with article first?

http://eralokpandey.wordpress.com/2011/03/



Well, I can tell you Mauro showed me his article in January/2011 if that helps you find an answer

BTW, nice article, Mauro!
Post #1072920
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse