The development of database application system is a software engineering. Generally can be divided into the following stages:
1. Planning
2. Demand Analysis
3. Conceptual model Design
4. Logical Design
5. Physical Design
6. Programming and debugging
7. Operation and Maintenance.
At present, there is no uniform standard for the division of these phases, and each stage is connected with each other and often needs backtracking correction.
In the development of database application system, the work result of each stage is to write the corresponding document. Each phase is based on the results of the previous phase of work, the whole development project is based, organized, planned and orderly work.
1. Planning
The main task of planning is to make necessity and feasibility analysis.
On the basis of collecting and collating relevant data, it is necessary to make a comprehensive analysis and demonstration of the relationship between the database application system and its surroundings, the size of the application system, the position and the function.
The basic function of the application system is defined and the scope of database support is divided. Analyze the data source, the way and the scope, study the characteristic of data structure, estimate the size of the quantity, establish the basic requirement and the standard of the business.
Planning the deployment of human resources. To be involved in the development and maintenance of the system operation of the management personnel, technical staff requirements, the end user, operator quality assessment.
Develop equipment configuration plan. To demonstrate the processing ability of computer, network and other equipments in time and space, to have enough internal and external storage capacity, the system response speed, network transmission and input and output ability should satisfy the application demand and leave the surplus quantity. To select the appropriate Os,dbms and other software. The device configuration scheme should be weighed comprehensively in terms of usage requirements, system performance, acquisition costs and maintenance costs.
Estimate the cost of the development, operation and maintenance of the system. Predict the expected value of system benefits.
Develop progress plans and make specific arrangements for the transition of the current mode of work to the new system.
The work of the planning phase is to write a detailed feasibility analysis report and a database application system planning book. The content should include: positioning and function of the system, data resource and data processing ability, human resource deployment, equipment configuration plan, development cost estimation, development schedule, etc.
The Feasibility analysis report and the database application System plan book after the examination and approval, becomes the following development work the general layout.