| One of major things in two of this approach | | | | Oracle, Informix, Microsoft Sql Server are |
| is of working with data but both of these | | | | the best suit example of client server |
| works in different manner. | | | | databases. Single user desktop just like |
| | | | Microsoft access. |
| In File Server Database approach the data is | | | | |
| stored in the file and user have to take data | | | | There are lots of advantages of client server |
| directly from the file. When any change is to | | | | databases. |
| be made it is directly on the file | | | | |
| application that is open .The file and data | | | | 1) Single program reading and writing data |
| writes to these files. If 10 users are online | | | | the less chance of accidental changes or |
| on data then 10 are working and writing on | | | | crashes of data. 2) Only single program play |
| the file. | | | | good role of security so enforcement of |
| | | | security is easy. 3) Client server databases |
| In a client server approach data is still | | | | use network bandwidth more efficiently then |
| stored in a file but controlled by a server | | | | file server databases. 4) All things are |
| all the access in the hand of server. When | | | | handling by single computes so performance is |
| any of application wants to make use of | | | | good and quite impressive. 5) Client-servers |
| existing data then application request is | | | | databases use some good features that protect |
| send to server. After that server reads the | | | | our data just like logging transactions and |
| request and send feedback. When any of | | | | recovery from disk and network errors. |
| application wants to writes something on file | | | | |
| the request is send to server the server | | | | Some of these features are also available in |
| writes on the file. One single person reads | | | | file server approach but these need more |
| and writes from this data files. | | | | expensive client server market. You can also |
| | | | learn more on dot net interview questions. |