Need for distributed databases
Large business organization has increasing need of distributed database. These organization need distributed database because of its
1- Reliability
2- Accessibility
3- Scalability
Distributed database provides an improvement for data processing and communication due to data distribution in different sites. Each database on different site may have different architectures and different management systems that distribute execution of transactions. In distributed database systems not only data access quicker, but failure of single-point occur less likely and users have local control over data.
Implementation of distributed database
Distributed database systems should be implemented by the process of multiple database servers at multiple location have same network all database servers should be synchronized.
Components of distributed database system
The main components of distributed database system is Database Manager. Database Manager is a software which is responsible for segment processing of distributed database. Request Interface is another main component of distributed database systems it is a client program which acts as interface to Distributed Transaction Manager. While Distributed Transaction Manager takes requests from users and convert these request into actionable form for database manager. Database manager and distributed transaction manager are essential for any Distributed database system. Hardware components of distributed database includes servers, routers and network.
Distributed Data Placement
Distributed functionality and performance lies in process of good data placement. To perform good data placement we should understand the process in which each data piece is accessed. We need to understand and analyze the access process from every location of the network. Data placement normally circulate around single subsystem. In data placement process access patterns of applications and programs are recorded and data is placed in distributed database system on the bases of information and portions of the data placed. There is also a need of analyzing location access patterns. Based on access patterns, data is placed at appropriate locations in distributed network.
Query Execution Techniques
Following techniques are used for query execution in distributed database systems.
- Row Blocking is an issue in distributed database systems and it could be solve by making changes in query for optimizing send and receive functions to model communication this technique is Implemented by TCP/IP and UDP.
- Multi-cast optimization is needed in distributed database system because location of sending or receiving can affect communication cost.
- Multi-threaded execution is required in distributed data base systems as several threads are used. This is useful to make concurrent reads. Joins with horizontal partitioning with the help of Hash-based partitioning which helps to conduct joins by independent partitions.
- Semi joins helps in Reducing the communication costs
- Isolate top n tuples quickly can help in distributed database and only perform other costly operations.
Programmatic access to Internet
An organization can give programmatic access to a database through the Internet with the help of using proxy server for security so that any malicious object should not directly access to data base and proxy server should work as a protection to database server.
Solution for restaurant chain
Distributed database is best solution of restaurant chain. Restaurant should deploy its database at multiple location say at 4 different location in states. now it should connect each data base with proxy server for data security and proxy server should be connected to internet. internet will be as a network between these database servers.
Works Cited
Özsu, M. T., & Valduriez, P. (2011). Principles of Distributed Database Systems. Springer.
Rahimi, K., & Haug, S. F. (2010). Distributed Database Management Systems: A Practical Approach. John Wiley & Sons.
Ray. (2009). Distributed Database Systems. Pearson Education India.