SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Some tips for working with big data models


Some tips for working with big data models

Author
Message
MauroPichiliani
MauroPichiliani
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 73
Comments posted to this topic are about the item Some tips for working with big data models
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (178K reputation)SSC Guru (178K reputation)SSC Guru (178K reputation)SSC Guru (178K reputation)SSC Guru (178K reputation)SSC Guru (178K reputation)SSC Guru (178K reputation)SSC Guru (178K reputation)

Group: General Forum Members
Points: 178404 Visits: 13357
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?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
tskelley
tskelley
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1132 Visits: 1236
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



Thomas LeBlanc
Thomas LeBlanc
SSCertifiable
SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)SSCertifiable (6.2K reputation)

Group: General Forum Members
Points: 6159 Visits: 944
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/
TheSQLGuru
TheSQLGuru
SSC Guru
SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)SSC Guru (93K reputation)

Group: General Forum Members
Points: 93313 Visits: 8946
ERStudio from Embarcadero is your friend when you have complex data models!

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
SQLRNNR
SQLRNNR
SSC Guru
SSC Guru (173K reputation)SSC Guru (173K reputation)SSC Guru (173K reputation)SSC Guru (173K reputation)SSC Guru (173K reputation)SSC Guru (173K reputation)SSC Guru (173K reputation)SSC Guru (173K reputation)

Group: General Forum Members
Points: 173970 Visits: 18670
Thank you, these are good tips.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw
Learn Extended Events

Zielyn
Zielyn
SSC Rookie
SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)SSC Rookie (25 reputation)

Group: General Forum Members
Points: 25 Visits: 206
Just curious, who came up with article first?

http://eralokpandey.wordpress.com/2011/03/
Toby White
Toby White
Hall of Fame
Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)

Group: General Forum Members
Points: 3841 Visits: 639
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.
MauroPichiliani
MauroPichiliani
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 73
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
wagner crivelini
wagner crivelini
SSChasing Mays
SSChasing Mays (606 reputation)SSChasing Mays (606 reputation)SSChasing Mays (606 reputation)SSChasing Mays (606 reputation)SSChasing Mays (606 reputation)SSChasing Mays (606 reputation)SSChasing Mays (606 reputation)SSChasing Mays (606 reputation)

Group: General Forum Members
Points: 606 Visits: 285
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!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search