What Elements Jointly Produce Physical Database Design?
Different components of physical database are as follows; Data volume and usage Analysis: It is used to estimate the size or volume and usage patterns of database. The estimate of database size is used to select the physical storage devices. It is also used to determine the costs of storage. The estimate of usage patterns is used to select file organization and access methods. Data Distribution Strategy: Many organizations are using distribution computer networks now days. These organizations face a significant problem in physical database design. The problem is that they have to decide and select nodes or sites in network at which data will be located physically. These strategies are as follows: Centralized: In this type all data is located at a single site. Partitioned: In this type all database is divided into partitions. Replicated: In this type the full copy database is assigned to more than one site. Hybrid: In this type, database is divided into critical and non-critical fragmen
