[Tutor] "Object designer" applications - are there any?
alan.gauld at btinternet.com
Fri Aug 5 15:15:35 CEST 2011
On 05/08/11 12:01, Flynn, Stephen (L & P - IT) wrote:
> Anyway, nearly all of this work, at some point, involves me reading a Data Dictionary
> for the source system and converting it to an Oracle table definition.
> More often than not this DDL is in text form and I convert it to Oracle DDL such as
> Create Table wibble
> ( clientref NUMBER(10) not null,
> bthdte NUMBER(5) not null,
> natinr_no VARCHAR2(16) not null,
> It struck me that if I write a "read in Sybase DDL and spit out Oracle DDL" routine
> and so forth, I'd get a lot of reuse out of it.
> However, I've not done much OOP at all
I'm not sure you need OOP for this. As you say a "routine" ie a function
might be all you need along with some data structures - probably
dictionaries to define the translations needed.
> Perhaps most people just design their objects on paper and let
> the code do the documentation for them...
It depends on the complexity. For a big project (say >25 classes)
I'd use a UML design tool like IBM RSA (Rational Rose as was) or Borland
Together. But for small projects Visio/Power[point and some
documentation in the code would suffice. And for very small
designs (2 or 3 classes) it would just be the code!
Biut for this it seems that a simple function to generte the DDL
based on an input translation table should be feasible, with
no objects required. (You could use objects of course if you really want
but I don't think they're necessary, or even particularly
helpful, in this case.
Author of the Learn to Program web site
More information about the Tutor