Database application System Engineering process

Database application System Engineering process

Data dictionaries include items, data structures, data streams, data storage and processing

Planning Phase

Systematic investigation, found the main problems of application system units, and draw the organization level diagram, understand the organizational structure of system units

Feasibility analysis

Determine overall database design objectives, optimize unit processes and develop project development plans

Requirements Analysis Phase

Analyze user activity, generate business flowchart

Determine system scope, generate system correlation diagram

Analyze the data involved in user activity and generate a flow chart

Analyze system data, generate data dictionary

Conceptual design Phase

Abstract the data and design a local conceptual model

Synthesis of a local conceptual model into a global conceptual model

Review, user Review, DBA and Developer review

Logic design phase

Transform a conceptual model into a logical model

Design outside model

Designing an interface between an application and a database

Evaluation model

Remediation model (ER model generation)

Physical design Phase

Storage record structure design (record composition, data type length, etc.)

Determine where data is stored

Access method Design (index design)

Integrity and Security

Programming

Implementation of the database

DDL definition Data structure

Organize data warehousing

Compiling and debugging applications

Database trial Run

Database operation and Maintenance

Storage and recovery of databases

Database Security and Integrity control

Improvement of monitoring and analysis of database performance

Database re-organization and re-improvement

Database application System Engineering process