A First Course in Database Systems - notes ch1

最新推荐文章于 2022-01-16 20:13:05 发布

seAn_7

最新推荐文章于 2022-01-16 20:13:05 发布

阅读量1k

点赞数

分类专栏： Database 文章标签： database 数据库

本文链接：https://blog.csdn.net/seand7/article/details/20945795

版权

2 篇文章 0 订阅

订阅专栏

I heard of it that it is a book for novices to learn DBMS.

Strongly recommend this book -A First Course in Database Systems, by Jeffrey D. Ullman, Jennifer Widom.

DBMS = database management system
DBMS = DDL(data design language) + DML(data manipulation language)
One critical factor a DBMS should meet is the capability to ensure the atomicity (dealing with the read/write operations from multiple users).
SQL = structured query language
Since the trend to use documents, XML(extensible model language) is used to tag documents. And collections of documents can also be taken as database.
In normal database system, the component storage manager is responsible of storing the data in secondary memory. In most cases, the storage manager would directly control the disk rather than interact with underlying operating system.
A transaction is an atomical operation which means no parallel operation is allowed.
To avoid query conflicts, data is often associated with locks, the lock table resides in main memory takes control of them. There exits the deadlock problem.
Functional dependency = a kind of data uniquely determined by another.

关注