Impact Assessment of database changes

Impact Assessment of database changes

Post by Todd Huseb » Tue, 22 Oct 1996 04:00:00



I'm wondering if anyone has used any tools to reverse engineer
PowerBuilder, C++, SAS, and/or SQR code into a design repository and
then been able to search the repository for instances of a database
column name such that if I were to make a change to the column, I could
determine where in the applications, that column is referenced.

Specifically, I'm wondering if anyone has used tools from LBMS, VCS,
Popkin, Platinum, Protosoft, or Oracle to do this.

 
 
 

Impact Assessment of database changes

Post by Frank Yacan » Tue, 22 Oct 1996 04:00:00


Todd,

You should check out CGEN from Subtle Software.
http://world.std.com/~subtle

It is a very easy to use, flexible tool for creating C++ from database
schema.


> I'm wondering if anyone has used any tools to reverse engineer
> PowerBuilder, C++, SAS, and/or SQR code into a design repository and
> then been able to search the repository for instances of a database
> column name such that if I were to make a change to the column, I could
> determine where in the applications, that column is referenced.

> Specifically, I'm wondering if anyone has used tools from LBMS, VCS,
> Popkin, Platinum, Protosoft, or Oracle to do this.

--

      .__________________________________________________________.
      |                                                          |
      |                     Frank Yacano                         |

      |                 http://www.syware.com                    |
      |                                                          |
      |  SYWARE, Inc. P.O. Box 91 Kendall , Cambridge, MA 02142  (\
    / )           Phone:617-497-1376    Fax:617-497-8729         ( \
   ( (|__________________________________________________________|) )
 (((\ \)  /,)                                               / )  / //))
 (\\\\ \_/ /                                                \ \_/ /////
  \       /                                                  \       /
   \    _/                                                    \_    /

 
 
 

1. Question: Year 2000 bug and impact on databases, database applications, and database management

Hi,

I am currently preparing a graduate paper on the impact of the Year 2000 (Y2K) bug
on databases, database applications, and database management. Specific areas of
interest to me and the group to whom it will be presented are:

Active Databases,
Knowledge Discovery and Data Mining,
Data Warehouses,
Deductive Databases,
Fuzzy Databases/Logic/Queries,
GIS,
Image Databases,
Knowledge-bases,
Online Databases,
OO Databases, and
Text & Document Databases.

If you work with one or more of the above, and have specific examples of how the
Y2K bug is going to affect you, the database(s), or the way you do work, and how
you (or others) are specifically addressing the problem, would you please respond
either on the NG or via e-mail (address below, too)?

If you don't know about Y2K, but can at least give me an idea of how data with date
fields or date information is used in any of the particular specialties above,
whether your particular area of databasing uses primarily two-digit date fields,
and the potential impact of having the year field "roll-over" to "00", that would
be just as good.

Any and all assistance will be most helpful. Thanks,

Matt Bovee
University of Kansas
Lawrence, KS


2. Datacontrol mit Tranaktion

3. Changes to relational DB and impact on history...

4. Changing Config with sybinit

5. impact of table changes

6. SQL 6.5 xp_sendMail leaves mail in outbox

7. Server to change name - what impact to SQL Server

8. Datamart Design Choice Extremes

9. Impact of changing SA password on DTS packages and scheduled tasks

10. impact of changing pwd of NT account ?

11. impact of changing nt sql account pwds

12. AIX change of code page, DB2 impact ?

13. Impact on Performance because of Images in database