Apesar dos meus incansáveis esforços, ainda não temos um “Dia do DBA”. Mas ao menos já temos quadrinhos! Não percam os quadrinhos sobre as aventuras de um DBA Oracle Jr. A dica veio do Sr. Robert Treat no Planet PostgreSQL.
Tags: DBA, Oracle|
Um comentário para “The Adventures of Ace, DBA”
Comentar
|
|
Posts (RSS)
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/