OSDN -- Develop and Download Open Source Software

RSS
Download List

Project Description

Reverse Snowflake Joins is a tool that parses SQL
Select statements and generates a diagram. In
addition to joins, the diagram shows parts of the
underlying SQL directly in the diagram. For
example x=30, GROUP BY (year), SUM(profit), HAVING
MIN(age) > 18.

System Requirements

System requirement is not defined
Information regarding Project Releases and Project Resources. Note that the information here is a quote from Freecode.com page, and the downloads themselves may not be hosted on OSDN.

2011-04-13 21:36
0.44

Anonymous subselects were fixed. For example, "select * from (select A.id from A)". Long IN clauses are truncated. For example, "table.field in (1,2,3,4...999)".

2011-04-09 06:25
0.43

This release fixes the missing edge for nested IN (subselect..). For example: select * from (select A.id from A where A.id IN (select B.id from B where v=5)) D1.

2011-04-04 04:03
0.42

This release has an improved simplifier (e.g. not complaining about the column concat, which is a function). Improved subselects, e.g. "select * from (select * from ta A,tb B where A.x=B.y) D1, (select * from ta A,tb B where A.x=B.y) D2".

2011-03-30 23:53
0.41

A fan trap warning was fixed in "SELECT id,sum(val1),sum(val2) from tab group by id". Constants are properly reduced in "select nvl(a111 + 2222, 3333, 4444) from table".

2011-03-22 02:35
0.40

Subselects and their aliases may now be linked.

Project Resources

Project Page Download: Demo Home Page Download: zip