Database management in centralized database architecture: In centralized database architecture, data, application programs and DBMS is located in a mainframe system. An application program is used for taking inputs from users and displaying it to the screen. It also communicates with DBMS using SQL. It is used in DB2 and SQL/DS databases.
Working: When a user sends a SQL query from computer system, it is received by DBMS (database management system). Then the request is processed by the DBMS. It also communicates with the database to generate a result. After that it communicates with the application program and the result is displayed in the screen of the user.
Disadvantage of database management in centralized database architecture: When more users are added to the system, the load to the system increases and it decreases the performance of the overall system.
Database management in file server architecture: A file server is used to share files in a server. In file server architecture, data can be accessed by computer systems. This data is located in file server. To access data networking software is used by file server. In this architecture a copy of DBMS is created for each user. This architecture works well if users have to retrieve simple data comprising of few rows and columns from the database. It is used in dBASE and Microsoft Access database.
Disadvantage of database management in file server architecture: Since every time a database scan is made, network traffic is increased and performance is decreased.