What is Staged Database Design Approach
- 1260
Staged Database Design Approach
Another way to design an information system is known as the staged database design approach. It is a top-down approach. It begins by analyzing the general requirements of the organization. As the process continues, these problems are analyzed in more detail. The steps in this approach are as follows:
1. Analyze User Environment
The first step in designing a database is to understand and analyze the current user environment. The designer should closely study the current system and its outputs. He should also interview different users to know their current and future requirements.
2. Develop Logical Data Model
The designer develops a logical data model for the organization after analyzing the user environment. This data model consists of all entities, attributes, and relationships. The designer also determines the following things:
Types of applications and transactions
- Types of databases access
- Volume of transactions
- Volume of data
- Frequency of databases access
- Budgetary restrictions
- Performance requirements
3. Choose a DBMS
The designer chooses a particular database management system on the basis of the logical data model. The selected DBMS should satisfy all requirements and constraints identified in the logical data model.
4. Map Logical Model to DBMS
The designer maps the logical data model to the available data structure of the selected database management system.
5. Develop Physical Model
The designer creates the exact layout of data according to the facilities of selected DBMS
and available resources of software and hardware.
6. Evaluate Physical Model
The designer evaluates the physical model by checking the performance of applications and transactions. The designer may implement a particular portion of the database to validate the user views and performance effectively.
7. Perform Tuning
Tuning is performed to improve the performance of the database. Different modifications are made to the physical model if required.
8. Implement Physical Model
The designer implements the physical model if the evaluation is satisfying. The database becomes functional.
The different steps can be repeated at different stages of the development process. For example, the database designer can review the user environment during the development of the logical model. While mapping the logical model to the physical model, he can change the selection of DBMS. Similarly, if an error occurs and he has to tune the system, he may need to change DBMS or remap the logical model. Even at the last step, he may review all steps from the very beginning.
