Re: Deploying a fully integrated system

On 22 Jul 2004 10:00:55 -0700, gabo22003_at_yahoo.com (Gabo) wrote:

>Hello,
>
>This is a general question, we are getting ready for a major overhall
>of all of our systems into an integrated system. We have backends in
>Access,Excel and Oracle, different client-based front ends, tables
>that need to be denormalized and nothing currently talks with
>anything. The departments affected are numerous.
>
>My question is how do I begin to tackle this problem. Are there any
>books or articles that would help me? Which issues do I tackle first?
>Do I need a DataFlow chart of old and new system? We will be using
>Oracle as our backend and we have a JAVA front-end program that we
>will be using for most of this integration which hasn't been totally
>designed yet.
>
>What steps should I follow to help ensure success of the project.
>
>Thank you for any suggestions

The *normal* method to develop a system is to come up with a model of business functions and entities (which doesn't imply any choice of platform or programming language), to develop a datamodel from the functional model, and then start developing/generating your code.

Other more informal methods usually end up in hell. As you already seem to have started from the wrong end (you don't seem to have any datamodel, and you are already designing a Java program) the changes this project will end in disaster are high.

--
Sybrand Bakker, Senior Oracle DBA