Subject | SQL Statement Depandance Mapping |
---|---|
Author | Daniel_Work@nemmco.com.au |
Post date | 2000-06-27T15:01:28Z |
SQL Statement Dependency Mapping
I had an idea for a tool / API extension for obtaining the schema
dependencies of a DML statement.
My theory goes like this, Interbase's SQL query engine would already be
able to determine tables, columns, etc that a statement requires for
execution.
If these requirements could some how be extracted and dumped into a file
together with the requirements of other SQL statements an overall schema
dependency map for an application could be built.
For example I could see a Delphi expert scanning through the forms in a
project extracting the SQL from queries for dependency mapping.
Does this sound like a feasible/usefully idea?
Would it be a new tool or an extra set of API calls?
PS I haven't been following the list too closely so if this isn't a new
idea please be kind ;-)
I had an idea for a tool / API extension for obtaining the schema
dependencies of a DML statement.
My theory goes like this, Interbase's SQL query engine would already be
able to determine tables, columns, etc that a statement requires for
execution.
If these requirements could some how be extracted and dumped into a file
together with the requirements of other SQL statements an overall schema
dependency map for an application could be built.
For example I could see a Delphi expert scanning through the forms in a
project extracting the SQL from queries for dependency mapping.
Does this sound like a feasible/usefully idea?
Would it be a new tool or an extra set of API calls?
PS I haven't been following the list too closely so if this isn't a new
idea please be kind ;-)