数据库与文件系统存储 [英] Database vs File system storage

问题描述

数据库最终将数据存储在文件中，而文件系统也将数据存储在文件中。在这种情况下，数据库和文件系统之间有什么区别。

Database ultimately stores the data in files, whereas File system also stores the data in files. In this case what is the difference between DB and File System. Is it in the way it is retrieved or anything else?

推荐答案

数据库通常用于以有效的方式存储相关的结构化数据，并以定义良好的数据格式进行插入，更新和/或检索（取决于应用程序）。

A database is generally used for storing related, structured data, with well defined data formats, in an efficient manner for insert, update and/or retrieval (depending on application).

另一方面，文件系统是非结构化的数据存储区，用于存储任意的，可能不相关的数据。文件系统更通用，数据库建立在文件系统提供的常规数据存储服务之上。 ^[Quora]

On the other hand, a file system is a more unstructured data store for storing arbitrary, probably unrelated data. The file system is more general, and databases are built on top of the general data storage services provided by file systems. ^[Quora]

文件系统在您要查找特定文件时非常有用系统维护一种索引。但是，txt文件的内容不会被索引，这是数据库的主要优点之一。

The file system is useful if you are looking for a particular file, as operating systems maintain a sort of index. However, the contents of a txt file won't be indexed, which is one of the main advantages of a database.

对于非常复杂的操作，文件系统可能非常慢。

For very complex operations, the filesystem is likely to be very slow.

RDBMS的主要优点：

• 表相互关联

• Tables are related to each other

SQL查询/数据处理语言

SQL query/data processing language

事务SQL（Transact-SQL）的处理功能

Transaction processing addition to SQL (Transact-SQL)

具有服务器端对象（例如存储过程，函数，触发器，视图，

Server-client implementation with server-side objects like stored procedures, functions, triggers, views, etc.

文件系统优于数据库管理系统的优点是：

在处理带有任意数据（可能无关）的小型数据集时，文件比数据库更有效。
对于简单的操作，读，写，文件操作更快，更简单。

When handling small data sets with arbitrary, probably unrelated data, file is more efficient than database. For simple operations, read, write, file operations are faster and simple.

在Internet上可以找到n个差异。

You can find n number of difference over internet.

这篇关于数据库与文件系统存储的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！