Stories
Slash Boxes
Comments
typodupeerror delete not in
  • Preferences

+-   Snowflake query diagramming tool-> on Sunday August 03 2008, @12:15PM alxtoth

Submitted by alxtoth on Sunday August 03 2008, @12:15PM
database
alxtoth writes "There is a new open source tool that parses SQL Select statements and generates a diagram. It shows parts of the underlying SQL directly in the diagram. For example x=30 , GROUP BY (year), SUM(sales), HAVING MIN(age) > 18. The primary reason for the tool was to avoid cartesian joins and loops in SQL written by hand, with many joined tables. The database will execute such a syntactically correct statement, resulting in runaway queries that can bring the database down. If you sit close to the DBA's, you can hear them screaming .. License is BSD, and link: http://sourceforge.net/projects/revj/"
Link to Original Source
submission
This discussion was created for logged-in users only, but now has been archived. No new comments can be posted.
The Fine Print: The following comments are owned by whoever posted them. We are not responsible for them in any way.

Snowflake query diagramming tool 0 Comments More /

 Full
 Abbreviated
 Hidden
More
Loading... please wait.
Search
Vail's Second Axiom: The amount of work to be done increases in proportion to the amount of work already completed.

All trademarks and copyrights on this page are owned by their respective owners. Comments are owned by the Poster. The Rest © 1997-2009 Geeknet, Inc.