What are difference between file server and database server?

Answer 1

A database can be consider as a group of file which allow us the multiple ways of accessing the data stored while for a particular file system there is a fixed path of accessing data. Simply put, a file is a collection of bytes stored together. An example of a file could be a Text File (a collection of alphanumeric characters that, when put together, form a readable document) or a Bitmap Image File (a collection of bytes that software would then interpret as elements of an image). A database is a special type of file that holds many tables. Each table can hold many fields as well as records. Think of a table as a spreadsheet. Each column represents different fields, such as "UserID", "LastName", and "CityOfResidence". Each row represents a record, or an entry, in the table, such as an entry for John Smith who lives in Albuquerque. An example of a database would be one that has three tables: Books, Instructors, and Courses. Different fields in the "Books" table would be "Author", "Publisher", "Title", and "ISBN". Different records within "Books" would be, for example, an entry for "Learning Java in 20 Days" (Title) by John C. Doe (Author), published by ABC Publishing Co. (Publisher). Each table in a database requires one field to be designated as the Primary Key. This means that, in order to uniquely identify a record in a table, one field needs to be used. In a "Students" table, the "StudentID" could be used as the Primary Key, since no two records (students) can have the same Student ID. For "Books" it could be "ISBN", since that is unique per book title. Visually, a table would look something like this: "Books" Table {| ! ISBN ! Title ! Author ! Publisher ! 1234567 | "Learning Java" Bob Smith ABC Publishing ! 8675309 | "Plumbing Basics" Joe Public XYZ Inc. ! 6762786 | "American Literature" William Jones LMNOP Corp. Finally, keep the following in mind: a database is a type of file. Therefore, all databases are files, '''but''' not all files are databases. Any chunk of data you save is a file. Ten words of text in notepad, or a dozen images in a folder. Those are both files. A database is both a program to store and organize data, and make it searchable, and the data contained in it. I guess you could call a database a file as well, but they are typically large, and referred to as databases. You might search a product database for widgets of wool, orange in color, made in New Zealand. The result of that search you could also call a file. When database managment systems (DBMS) first were developed, they used multiple files per database, typically one file per table. Now days, most of the common DBMS systems use one file per database. A database is a type of file (or a group of files.) |}

Answer 2

A file is any kind of computer document.

Every picture, sound or document - including this webpage - that you use or work with on a computer is stored digitally on the computer's drive in its own individual picture file, sound file or document file. All the pictures on this webpage are stored as individual picture files, and the webpage itself is a special type of document file that your internet browser knows how to display on the screen with the pictures and links in the right places.

A directory is a computer document folder or filing cabinet.

If we could only organize the files on a computer in a long list, this would run into several thousands, and while the computer would have no trouble with such a huge list, it would be extremely difficult for a human to work with. In order to organize files in a practical and useful way, we create computer directories - more commonly called 'folders' - to group together files in whatever way we find helpful, whether by date, type, or any other way that is helpful. So a directory is an organizational tool for files. The usual way for a computer to show a directory (as an icon, or picture symbol) is as a folder, because as far as the user is concerned, that is the way a directory works.

Directories can, and very often do, have further sub-directories inside them, in order to keep the numbers of files to a manageable level.

AnswerFiles are the actual programs, documents, pictures, whatever and the directory is where they are located. It is like a tree. The directory is the trunk and all the branches and the files are the leaves at the end. To expand on the tree.... The trunk of the tree is your ROOT drive ( c:\ ) The branches are directories (folders) (C:\My Documents) Branches can have little branches off of them as well (C:\My Documents\My Pictures) Then within these little branches you have leaves (files) (C:\My Documents\My Pictures\PictureOfMe.jpg)
The difference between a file and a directory is pretty simple. A file is a document, whether that be text or an image while a directory is the location in which a file is stored on a computer.

Answer 3

A directory is optimized for read operations, while a database is optimized for write and change operations. Therefore, any data that is read many more times than it is written or modified is a good candidate for storage in a directory.

Answer 4

File is a collection of records whereas database is a collection of data in a file

Answer 5

A file server only transfers all the data requested by all its client and the client processes the data while a database server runs the query and sends only the query output.