
is a startup cost associated with initiating a single process and the startup-time may overshadow the actual processing time, affecting speedup adversely.Disadvantages of a Parallel Database System In a parallel database system, the throughput (that is, the number of tasks that can be completed in a given time interval) and the response time (that is, the amount of time it takes to complete a single task from the time it is.Parallel database systems are very useful for the applications that have to query extremely large databases (of the order of terabytes, for example, 1012 bytes) or that have to process an extremely large number of transactions per second (of the order of thousands of transactions per second).Parallel database systems are used in the application that have to query extremely large databases or that have to process an extremely large number of transactions per second. Hence, they improve processing and Input/Output (I/O) speeds. Parallel database system architecture consists of a multiple Central Processing Units (CPUs) and data storage disk in parallel. Communication costs from the terminals to the central site can be expensive.When the central site computer or database system goes down, then every one (users) is blocked from using the system until the system comes back.Data can be accessed from the multiple sites with the use of a computer network while the database is maintained at the central site.ĭisadvantages of Centralized Database System It is physically confined to a single location. The centralized database system consists of a single processor together with its associated data storage devices and other peripherals.
