Centralized and Distributed Database System

The goal of most business information systems, a plant database to find a very large and powerful. The database program is regularly used as engine database files and records and indexes seen in tables and manages the relationships between tables. Other functions such as data entry forms, queries and reports are part of the database of the hull and are often seen as tools to deal with secondary data. Information held by the Company can easily be found by querying the central database. Typically, a multi-user system or network is used, which means that each user accessing the database system. It can be configured in the rule that different operators are different, but the opinions about the information (sales screens, monitors, stock accounts, etc.).

The advantage of the database is centralized, it is much easier to organize, update, modify and save data.

The communication is easier if the data is not held at a central computer to multiple distributed and there is no real difficulty, have a central database. A central database contains all data of a company to a central computer or a mainframe or a server. Dumb terminals with access to a central computer and a network system. These terminals and PCs can be at a distance from the central database available, however, is the fact that all data and at the same place.

The main advantage of a centralized database is that it is much easier to manage and validate that all data is in one place. For example, in a control order, a customer can call and explain that his address has changed, and if the operator to change the address was changed by the system. If the department accounts to the client wants an explanation, they send the customer a new address. Another advantage is that the database is much easier to get when they centralized, as if it works on different computers, a proper backup strategy to reach.

A distributed database is a database that is collected in two or more files from different location on a computer network, it is. Since the distributed database, various users, without interfering with each other results. The DBMS must periodically synchronize the scattered databases to make sure they all have consistent data. Traditionally, a distributed database, a collection of data and files that are physically in a real system, but was in a number of computers that were distributed were connected by a communications network. Today it is more likely to be independent-minded systems databases of mobile data services.