Question

1. Discuss the need for a distributed data base in a typical automotive company from system engineering point of view.

Answer 1

Answer:-

Discuss the need for a distributed data base in a typical automotive company from system engineering point of view.

Distributed databases offer some key advantages over centralized databases. Many companies are switching to distributed databases (in which the database, as its name implies, is distributed throughout an array of servers in various locations), for a variety of reasons. Let’s look at some of the basic advantages of distributed databases, a typical scenario in which they are used, and the different formats in which data is distributed throughout the distributed data system

Here are the basic reasons why the centralized model is being left behind by many organizations in favor of database distribution:

1. Reliability – Building an infrastructure is similar to investing: diversify to reduce your chances of loss. Specifically, if a failure occurs in one area of the distribution, the entire database does not experience a setback.
2. Security – You can give permissions to single sections of the overall database, for better internal and external protection.
3. Cost-effective – Bandwidth prices go down because users are accessing remote data less frequently.
4. Local access – Similarly to #1 above, if there is a failure in the umbrella network, you can still get access to your portion of the database.
5. Growth – If you add a new location to your business, it’s simple to create an additional node within the database, making distribution highly scalable.
6. Speed & resource efficiency – Most requests and other interactivity with the database are performed at a local level, also decreasing remote traffic.
7. Responsibility & containment – Because any glitches or failures occur locally, the issue is contained and can potentially be handled by the IT staff designated to handle that piece of the company.

Often distributed databases are used by organizations that have numerous offices or storefronts in different geographical locations. Typically an individual branch is interacting primarily with the data that pertain to its own operations, with a much less frequent need for general company data.
There is an inconsistent need for any central information from the branches in that case. However, the home office of the company still must have a steady influx of information from every location.
To solve that issue, a distributed database usually operates by allowing each location of the company to interact directly with its own database during work hours. During non-peak times, each day, the whole database receives a batch of data from each branch.