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