什么是基于文件的数据库? [英] What is a file based database?

问题描述

我参加了有关关系数据库的课程.我被要求研究基于文件的方法相对于关系数据库的优势.

I am enrolled in a course about relational databases. I was asked to research the advantage of a file based approach versus relational databases.

我发现比较容易理解关系数据库，但是很难理解基于文件的系统.基于文件的系统是否与在Windows分层系统中存储文件(即文本文件存储在文件夹和目录下)相同?普通的csv文件是基于文件的系统的示例吗?

I find it easier to understand relational databases but having difficulty understanding file based systems. Are file based systems the same as storing files on a windows hierarchical system, meaning text files stored under folders and directories? Are plain csv files an example of file based system?

推荐答案

当我们指的是基于文件的数据库时，是指我们直接与之交互或更新的数据库(通过JDBC驱动程序提供的SQL抽象)，但实际上，我们只需直接读取/写入文件即可.示例将是SQLite

When we refer to file-based databases we mean databases that we interact with/update directly (via an SQL abstraction offered by the JDBC driver) but in essence we just read/write to a file directly. Example would be SQLite

否，CSV是一个用逗号分隔的值文件，该文件允许以表结构格式保存数据.

No, CSV is a comma separated values file which allows data to be saved in a table structured format.

平面文件"数据库允许用户一次为一个表指定数据属性(列，数据类型等)，并独立于应用程序存储这些属性. dBase III和Paradox是CP/M和MS-DOS环境中此类数据库的很好示例，原始FileMaker是Mac O/S很好的示例.

A "flat file" database allows the user to specify data attributes (columns, datatypes, etc) for one table at a time, storing those attributes independantly of an application. dBase III and Paradox were good examples of this kind of database in the CP/M and MS-DOS environments, and the original FileMaker was a good Mac O/S example.

关系数据库将这种平面文件"方法进一步采取了几个逻辑步骤，从而允许用户指定有关多个表以及这些表之间的关系的信息，并且通常允许对这些表中的数据必须遵循的规则进行更多的声明式控制.服从.

A relational database takes this "flat file" approach several logical steps further, allowing the user to specify information about multiple tables and the relationships between those tables, and often allowing much more declarative control over what rules the data in those tables must obey.

数据库系统是在文件系统和基于RDBMS原理的API之间进行中介的机制.在不详细讨论构成RDBMS的特定规则集的情况下，我们可以说这些规则主要提供了一种组织和访问文件中存储的信息的方法. 与原始文件系统相比，数据库最明显的功能是结构和索引.

Database systems are mechanisms that mediate between file systems and an API based on RDBMS principles. Without getting into detail about the specific sets of rules that together make up an RDBMS, we can say that these mostly provide a way to organize and access information stored in files. The most noticeable features of databases compared with raw file-systems are structure and indexing.

这篇关于什么是基于文件的数据库?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！