There are two Approaches or Design Strategies in Distributed Database Management System for developing any database, the top-down method and the bottom-up method.
While these approaches appear radically different, they share the common goal of utilizing a system by describing all of the interaction between the processes.
Design Strategies in Distributed Database Management System
- Top-down design method
- Bottom – up design method
1. Top Down Design Method
The top-down design method starts from the general and moves to the specific.
In other words, you start with a general idea of what is needed for the system and then work your way down to the more specific details of how the system will interact.
This process involves the identification of different entity types and the definition of each entity’s attributes.
2. Bottom Up Design Method
The bottom-up approach begins with the specific details and moves up to the general.
This is done by first identifying the data elements (items) and then grouping them together in data sets.
In other words, this method first identifies the attributes, and then groups them to form entities.