![](https://img-blog.csdnimg.cn/20201014180756930.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Database System
Irisssy
这个作者很懒,什么都没留下…
展开
-
Lecture 05. E-R model
keysE-R DiagramRectangles represent entity sets.Diamonds represent relationship sets.Lines link attributes to entity sets and entity sets to relationship sets.Ellipses represent attributes.Dou...原创 2019-06-29 22:56:47 · 316 阅读 · 0 评论 -
Lecture 04.Advanced SQL
Advanced SQLIntegrity Constraintnot null (主码不可为空)uniquecheck ( <predicate> )CREATE table branch2(branch_name varchar(30) primary key, branch_city varchar(30), ...原创 2019-06-29 22:44:32 · 359 阅读 · 0 评论 -
Lecture 03. SQL
Domain Types in SQLchar(n): Fixed length character string, with user-specified length.varchar(n): Variable length character strings, with user-specified maximum length n.int: Integer (a finit...原创 2019-06-29 19:35:11 · 227 阅读 · 0 评论 -
Lecture 11. Query Processing
Meaturing of query costtTt_TtT – time to transfer one block. (≈ 0.1ms)tSt_StS – time for one seek. (≈ 4ms)Cost for b block transfers plus S seeks : b∗tT+S∗tSb* t_T + S* t_Sb∗tT+S∗tSExternal ...原创 2019-06-27 13:32:30 · 638 阅读 · 0 评论 -
Lecture 10. Indexing and Hashing
Indexing and Hashing顺序索引:基于值的顺序排序散列索引:基于将值平均分布到若干散列桶中聚集索引(clustering index)or 主索引(primary index):如果包含记录的文件按照某个搜索码指定的顺序排序,那么该搜索码对应的索引称为聚集索引。聚集索引的搜索码常常是主码,尽管并非必须如此。非聚集索引(nonclustering index)or 辅助索引(...原创 2019-06-10 19:19:25 · 275 阅读 · 0 评论 -
Lecture 09. Storage and File Structure
Storage and File Structure存储器层次结构(向上变快变贵但是易失)基本存储(primary storage): 高速缓冲存储器(cache)、主存储器(main memory)辅助存储(secondary storage)或联机存储(online storage): 基本存储下一层,如磁盘(magnetic disk)三级存储(tertiary storage)或...原创 2019-06-10 16:07:35 · 281 阅读 · 0 评论 -
Lecture 06. Relational database design
First Normal FormatomicFunctional dependenciesThe functional dependency α → β holds on R if and only if for any legal relations r®, whenever any two tuples t1 and t2 of r agree on the attributes α...原创 2019-06-30 08:45:26 · 278 阅读 · 0 评论