Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

Is there a tool which given a bunch of data extraction SQL scripts will produce a dependency graph? Basically given scripts which take input tables, create a bunch of interdependent intermediary tables and then create output tables and I would like to get some analysis done on it to know which tables depend on which.

share|improve this question
1  
Is there any chance you could turn the SQL scripts into stored procedures so that you (or a tool) can use Oracle's dependency tracking data dictionary views? Do you really need to create intermediate tables-- in Oracle, it's almost certainly better to create the tables once when you deploy your application and then to use them in your process-- if the table data is temporary, perhaps they should be global temporary tables. – Justin Cave May 6 '12 at 18:08
@JustinCave this is an ETL process which is ran periodically. Pretty much everything is read only after the process is done, but intermediary tables are useful for all kinds of things – MK01 May 8 '12 at 0:28
@MK01 - But why do the objects need to be created dynamically? Why can't you populate existing objects? Could the SQL scripts be converted into stored procedures? – Justin Cave May 8 '12 at 0:31
Well, it could be populating existing objects. But I need to know which tables feed which tables. I suppose this could be converted into stored procedures, how does that help? What I want to know is that somewhere there is a statement "SELECT * FROM table1 INTO table2" then table2 depends on table1. – MK01 May 8 '12 at 1:28
@MK01 you don't accept to keep an accept rate high. You accept to let everyone know you've found a solution to your questions. If your questions need to be deleted, feel free to let me know, and I can delete them. However, that carries negative connotations (such as you lose the ability to post new questions for up to 30 days). It's much more polite to the community to click the accept checkmark and be a contributing member of our community. – jcolebrand♦ May 10 '12 at 18:06
show 2 more comments

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.