DB and CSV formats are commonly used for database related files. While CSV is a more primitive and simple format, DB is a popularly used extension for database files.
A Comma Separated Variables or CSV is usually a database which is exported to a format in which records are separated by delimiters like comma or semi colon. They have the file extension CSV. Each record is stored in a single line and every new line shows a new record. CSV is commonly used to transfer data between various databases. DB stands for database and denotes database files which carry the DB extension. These types of files store data in a regularized, standard format in which data is stored in the form of tables and table fields. DB is also used by Windows to store data related to thumbnails of files. They can be exported to CSV format.
Files with the extension DB can be created by applications such as Oracle, Paradox, XoftSpy XE and MS Works. They can be opened with applications like Microsoft Access 2010, Corel Paradox, Synopsys Design Compiler Graphical, Notepad and Wordpad. On the other hand, CSV can be opened with applications like MS Excel 2010, Microsoft Works 9, Corel Word Perfect Office X5, Notepad and any text editor. In Linux operating systems, CSV files are supported by Planamesa Neo Office and Microsoft Excel 2008.
The advantage associated with CSV is that it is compatible with a number of applications. The format is however very simple making it a major disadvantage. Files in the DB format are a lot more advanced. They allow data to be stored in an ordered structure which makes it easy to access. Also, the data stored is safe and cannot be lost that easily. Other advantages associated with DB include multiple user access to data stored in a database.
