Banco de DadosOracle

The Adventures of Ace, DBA

No Comments

  • Alexandru Toth disse:

    Hello,

    (Sorry for the spam)

    You might be interested in using the “snowflake query” diagrams generated with the “Reverse Snowflake Joins” open source tool. You can find a presentation at http://revj.sourceforge.net

    The tool 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 , even though it is not what the user intended to get.

    -Alex
    http://sourceforge.net/projects/revj
    http://sourceforge.net/projects/cubulus/

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.