DBMS vs File System
DBMS(数据库管理系统)和文件系统是可以用于管理,存储,检索和操纵数据的两种方法。文件系统是存储在硬盘驱动器中的原始数据文件的集合,而DBMS是专门用于管理数据库中存储的数据的一组应用程序。它是用于管理数字数据库的集成系统,它允许存储数据库内容,数据的创建/维护,搜索和其他功能。两种系统都可以用来允许用户以类似的方式处理数据。文件系统是管理数据的最早方法之一。但是,由于使用文件系统存储电子数据的缺点,数据库管理系统稍后再使用,因为它们提供了解决这些问题的机制。但是应该注意的是,即使在DBMS中,数据最终也会(物理上)存储在某种文件中。
File System
如上所述,在典型的文件系统中,直接存储了一组文件。如果仅存储一个表格,则称为平面文件。它们在每行中包含与逗号(如逗号)分隔的每行。为了查询一些随机数据,首先需要在运行时将每一行分解并加载到数组。但是对于此文件,应依次读取该文件(因为文件中没有控制机制),因此它效率低下且耗时。查找必要文件的负担,浏览记录(逐行),检查某些数据的存在,记住要编辑的文件/记录在用户上。用户要么必须手动执行每个任务,要么必须在操作系统的文件管理功能的帮助下编写一个脚本。由于这些原因,文件系统很容易受到严重问题的影响,例如不一致,无关,数据隔离,对完整性的威胁和缺乏安全性。
DBMS
DBMS,有时称为数据库管理器,a collection of computer programs that is dedicated for the management (i.e. organization, storage and retrieval) of all databases that are installed in a system (i.e. hard drive or network). There are different types of Database Management Systems existing in the world, and some of them are designed for the proper management of databases configured for specific purposes. Most popular commercial Database Management Systems are Oracle, DB2 and Microsoft Access. All these products provide means of allocation of different levels of privileges for different users, making it possible for a DBMS to be controlled centrally by a single administrator or to be allocated to several different people. There are four important elements in any Database Management System. They are the modeling language, data structures, query language and mechanism for transactions. The modeling language defines the language of each database hosted in the DBMS. Currently several popular approaches like hierarchal, network, relational and object are in practice. Data structures help organize the data such as individual records, files, fields and their definitions and objects such as visual media. Data query language allow for maintaining and the security of the database. It monitors login data, access rights to different users, and protocols to add data to the system. SQL is a popular query language which is used in Relational Database Management Systems. Finally, the mechanism that allows for transactions help concurrency and multiplicity. That mechanism will make sure same record will not be modified by multiple users at the same time, thus keeping the data integrity in tact. Additionally, DBMSs provide backup and other facilities as well. With all these advancements in place, DBMS solves almost all problems of the File System, mentioned above.
DBM和文件系统之间的区别
在文件系统中,文件用于存储数据,而数据库的集合用于DBMS中的数据存储。尽管文件系统和DBM是管理数据的两种方法,但DBMS显然比文件系统具有许多优势。通常,当使用文件系统时,大多数任务(例如存储,检索和搜索)都是手动完成的,并且非常乏味,而DBMS将提供自动化的方法来完成这些任务。因此,使用文件系统将导致数据完整性,数据不一致和数据安全性等问题,但是可以通过使用DBMS来避免这些问题。与文件系统不同,DBM是有效的,因为不需要逐行阅读,并且存在某些控制机制。
Ankitsays
写得很好。
小姐says
很棒的文章!非常有帮助!非常感谢!
asthasays
非常理解