SQLServerCentral / Article Discussions / Article Discussions by Author / Discuss content posted by MauroPichiliani / Some tips for working with big data models / Latest Posts

RE: Some tips for working with big data models

mishaluba — Sat, 22 Dec 2012 19:33:02 GMT

Thank you very much for the article! This is a great set of tips. I am currently working on just this kind of scenario -- researching a large database and figuring out functionality. I would like to recommend one more tool -- it's "SQL Dependency Tracker" from Red-Gate, which I found very helpful. I enables you to visualize dependencies between various database objects and perform analysis.

RE: Some tips for working with big data models

Steve Jones - SSC Editor — Fri, 04 Mar 2011 10:55:20 GMT

You can submit DCMAs here:Blogger: http://www.google.com/support/bin/request.py?contact_type=lr_dmca&product=bloggerWordpress: http://automattic.com/dmca/I'll do those.

RE: Some tips for working with big data models

wagner crivelini — Fri, 04 Mar 2011 09:57:29 GMT

[quote][b]Steve Jones - SSC Editor (3/4/2011)[/b][hr]I have submitted a note to Wordpress to remove this.[/quote]SteveI wasn't aware of this kind of problem, but I am surprised to see how frequent it is.I made a quick search on GOOGLE this morning and found 3 "clones" of my articles at [b]blogpost.com[/b]http://softwarekira.blogspot.com/2009/05/modeling-and-diagrams-with-sql-server.htmlhttp://gowdhamanr.blogspot.com/2010/10/do-you-really-need-surrogate-keys-part.html#morehttp://techtipsbysatish.blogspot.com/2010/08/sql-server-joins.htmlAnd the original articles:http://www.sqlservercentral.com/Authors/Articles/Wagner_Crivelini/293928/

RE: Some tips for working with big data models

Steve Jones - SSC Editor — Fri, 04 Mar 2011 09:38:13 GMT

I have submitted a note to Wordpress to remove this.

RE: Some tips for working with big data models

Koen Verbeeck — Fri, 04 Mar 2011 06:02:12 GMT

[quote][b]Brandie Tarvin (3/4/2011)[/b][hr]He has moderation set on his blog comments. I'm betting he won't allow anyone to see it.[/quote]To the law-mobile!

RE: Some tips for working with big data models

Brandie Tarvin — Fri, 04 Mar 2011 05:59:47 GMT

He has moderation set on his blog comments. I'm betting he won't allow anyone to see it.

RE: Some tips for working with big data models

Ian Scarlett — Fri, 04 Mar 2011 05:55:05 GMT

[quote][b]Brandie Tarvin (3/4/2011)[/b][hr]I couldn't help myself. I posted a comment on Alok's blog:[/quote]I can't see your blog comment Brandie, but look at the other articles in his blog... virtually every one of them is a cut and paste job.

RE: Some tips for working with big data models

Brandie Tarvin — Fri, 04 Mar 2011 04:37:44 GMT

[quote][b]Koen Verbeeck (3/4/2011)[/b][hr][quote][b]wagner crivelini (3/4/2011)[/b][hr]Men, I didn't know how common those "reprints" were!!I checked Google and found 3 of my articles shown in some "serious" blogs out there. And 1 one of them has the nerve to write :"To read more: www.sqlservercentral.com/......" The only extra information people can find in SQLServerCentral's link is my name :-D[/quote]The reference to sqlservercentral is so that they can say they were just "quoting" you.[/quote]It's still copyright infringement (if they attributed Wagner) or outright plagiarism (if they didn't attribute Wagner). The only way it's not CI is if they asked Wagner's permission first or if he blatantly gave permission to anyone to use it. I couldn't help myself. I posted a comment on Alok's blog:[quote]Wow. This article is an exact duplicate (except for the first line) of an article posted yesterday on SQLServerCentral.com, by a different author. And since the SSC author had to wait a few weeks to get his article approved, it leads one to the conclusion that this blog post is possibly plagiarized. Care to explain?http://www.sqlservercentral.com/articles/model/72275/[/quote]

RE: Some tips for working with big data models

Koen Verbeeck — Fri, 04 Mar 2011 02:30:31 GMT

[quote][b]wagner crivelini (3/4/2011)[/b][hr]Men, I didn't know how common those "reprints" were!!I checked Google and found 3 of my articles shown in some "serious" blogs out there. And 1 one of them has the nerve to write :"To read more: www.sqlservercentral.com/......" The only extra information people can find in SQLServerCentral's link is my name :-D[/quote]The reference to sqlservercentral is so that they can say they were just "quoting" you.

RE: Some tips for working with big data models

wagner crivelini — Fri, 04 Mar 2011 02:26:26 GMT

Men, I didn't know how common those "reprints" were!!I checked Google and found 3 of my articles shown in some "serious" blogs out there. And 1 one of them has the nerve to write :"To read more: www.sqlservercentral.com/......" The only extra information people can find in SQLServerCentral's link is my name :-D

RE: Some tips for working with big data models

Koen Verbeeck — Thu, 03 Mar 2011 23:22:05 GMT

[quote][b]MauroPichiliani (3/3/2011)[/b][hr]It's very sad that nowadays you can see a complete copy of your work without authorization and even a simple reference.[/quote]You shouldn't put up with this. Contact the guy, explain him that he has committed a copyright infringement and that he should put the article down. If he doesn't, contact Steve, the editor of this site. They have experience with this sort of issues...

RE: Some tips for working with big data models

Zielyn — Thu, 03 Mar 2011 21:47:09 GMT

ya, I was kinda aware that this article was the original. Just pokin fun at someone that basically did a copy past job.Google search is a hell of a thing sometimes :DOh btw, Does anybody know a good database modeling software? I don't know of any off hand besides manual visio or something to that affect. I want to map my databases, but they change every day... and something somewhat automatic and low maintenance would be awesome.

RE: Some tips for working with big data models

wagner crivelini — Thu, 03 Mar 2011 14:15:26 GMT

[quote][b]Zielyn (3/3/2011)[/b][hr]Just curious, who came up with article first?http://eralokpandey.wordpress.com/2011/03/[/quote]Well, I can tell you Mauro showed me his article in January/2011 if that helps you find an answer :-)BTW, nice article, Mauro!

RE: Some tips for working with big data models

MauroPichiliani — Thu, 03 Mar 2011 14:00:07 GMT

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

RE: Some tips for working with big data models

Toby White — Thu, 03 Mar 2011 13:07:20 GMT

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.

RE: Some tips for working with big data models

Zielyn — Thu, 03 Mar 2011 13:02:53 GMT

Just curious, who came up with article first?http://eralokpandey.wordpress.com/2011/03/

RE: Some tips for working with big data models

SQLRNNR — Thu, 03 Mar 2011 09:58:55 GMT

Thank you, these are good tips.

RE: Some tips for working with big data models

TheSQLGuru — Thu, 03 Mar 2011 09:32:16 GMT

ERStudio from Embarcadero is your friend when you have complex data models!

RE: Some tips for working with big data models

Thomas LeBlanc — Thu, 03 Mar 2011 09:12:17 GMT

Excellent summary and I agree with it all.You should do articles on each individual point with examples.Thanks,Thomas LeBlancTheSmilingDBA

RE: Some tips for working with big data models

tskelley — Thu, 03 Mar 2011 07:25:53 GMT

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

RE: Some tips for working with big data models

Koen Verbeeck — Thu, 03 Mar 2011 01:54:40 GMT

How do you mix a star schema with a snowflake schema?

Some tips for working with big data models

MauroPichiliani — Wed, 02 Mar 2011 23:27:52 GMT

Comments posted to this topic are about the item [B]Some tips for working with big data models[/B]