Distributed database development assignment Essay

Distributed database development assignment - Essay Example The client can access information by directly or indirectly connecting to the database server. For example, if a client connects to a server requests access to information from a database contained on that server a direct connection established. To elaborate further, if the client connects to the Head Quarter database and requests access to the data held in warehouse (inventory ) or retail stores (item, color ) tables, he can do so by a simple query – â€Å" select * from inventory;†. This is a direct query as the object, i.e., the inventory table is not located on the remote database. On the other hand if the client connects to a server and accesses information from a database contained in another server, then an indirect connection is established. For example, if the client connects to one the retail server and accesses information from the database contained in the Brisbane Warehouse server or Melbourne Warehouse server, then an indirect connection is established as the object being accessed is not on the server to which the client is directly connected. A Distributed Database System is not just a mere collection of files that can be stored individually at each node of a computer network. In order to for a proper Distributed Database System, all the relevant files need to be stored in a logical manner, i.e., the files should be logically related, with a proper structure that facilitates easy and convenient access to the databases via a common interface. In a distributed database system, the business information of a company is distributed over a network, hence it is practical and preferable to localize the data in such a way that the information relating to the Brisbane Warehouse is stored in Brisbane and those related to the Melbourne Warehouse will be stored in Melbourne. For example, any query related to the order_id, inventory, item_id, inventory_quantity etc related to a specific location is stroed in each partition at a