Skip to main content

Compare between centralized and distributed database

 .

Centralized Database

A centralized database in which a single central Database accessed by multiple users. It's easier to organized data, edit query and also can backup easily. They are located on particular location. The controlling mechanism is also centralized and data are deposited in a central location. Files are kept on the base of the location of disk drives and names. It is only suitable for small organization and small scale operations. Advantage of centralized database that it is easy to maintain. Disadvantage is if the server is destroyed by some catastrophic damage like flood, fire whole data is lost.



Distributed Database

Distributed database is dispersed across many geographical locations. There are multiple database storing different types of file and they connected to each other. Its security is very much crucial part because it can be tapped or hacked in between the transmission. Advantage of distributed is the problem in one location will not affect entire  system. Disadvantage is it requires communication system and skilled man power to operate the system.




  

Comments

Popular posts from this blog

Important Questions of Data Structure and Algorithm (DSA)

 . 1. What is Data structure? Explain different operations to be performed on data structure. 2. Define stack as ADT. Convert P+Q-(R*S/T+U) - V*W into infix expression to postfix. 3. Define Queue. Explain its type with example. 4.  Difference between stack and Queue. 5. Difference between Linear Queue and circular Queue. 6. Write an algorithm to enqueue and dequeue data element in a circular queue.                              7. Define Linked List. Explain its type. How does double linked List is different from circular linked   List. 8. What is recursion and recursive function? write a recursive function to compute Fibonacci number. 9. What is an AVL tree ? Create an  AVL tree from the following data:      18, 12, 14, 8, 85, 25, 31, 24, 27 10. Define B-tree? How to insertion and deletions of elements can be done in a B-tree. 11. Create an B-tree from the following Data:  ...

BCA Math II old question model solution

 . BCA Math II question model 2018: BCA Math II question model 2019: BCA Math II question model 2020:

Important questions of C programming (BCA)

 . What is the characteristics of a good program? Explain types of language processor. Explain any two system design tools. Explain Program Development Life Cycle. Define programing techniques. Different between top-down and button - up approach with suitable example. Difference between cohesion and coupling. Define identifiers, constants, variables and keywords. Explain datatypes. Explain different types of  datatypes available in C. Define operator. Explain its types with suitable example. Explain decision making statement. Explain its type with example. Difference between while, do while loop, for loop. Write a program to find the fibonacci  sequence. What is jumping statement. Explain its types with suitable example.    Write a program to display following:               *               **               ***         ...