雨果

Before the start
The newest DataStage White papers(IBM)
Data layer & presentation layer
Identify participants
Roles & role models
Data link layer

Structure Considerations
Load balancing
Transportation routes
Transportation costs
Recipient's roles
Anti-encapsulation(abstract)
Simplify
Generalization
Visualize

Demand Analysis
Choose two type of models for sampling. One for a simple example, another for a complicated example.
Understood the level of risk by intuition.
Start with simple examples.
Apply requirements to Excel.
If you can use excel to generate demanded reports quickly, stands for the original all  structures are good.
In most cases, users can apply the requirements to Excel by themselves.
In most cases, system reporting tools can apply this kind of model as above.
Preliminary & premium testing
For analyst’s test (for user/client)
For logic testing.

At last, statement considerations
Collect query conditions, as details as well.
Analyze SQL statements to match the query conditions.
Backup up original ones.
Make a stored procedure in database to restore the original copy.
 Notice! Please do not modify original ones directly.
Make other stored procedures in database for modification.
To mark with clear and conventional.

HUGO CHANG

2022/2/10