随笔分类 -  CS3402 Database Systems

CS3402 Query Optimization
摘要：Query Optimization 阅读全文
posted @ 2018-05-09 11:29 Charonnnnn 阅读(155) 评论(0) 推荐(0)
CS3402 Integrity Constraints
摘要：Integrity Constraints Motivation To ensure that changes (made by authorized users) to the database do not cause a loss of consistency Constraints are  阅读全文
posted @ 2018-05-09 11:28 Charonnnnn 阅读(356) 评论(0) 推荐(0)
CS3402 File Organization and Indexing
摘要：File Organization and Indexing Disk Storage Devices Secondary storage device for high storage capacity and low cost. Data stored as magnetized areas o 阅读全文
posted @ 2018-05-09 11:28 Charonnnnn 阅读(270) 评论(0) 推荐(0)
CS3402 Transactions and Concurrency Control
摘要：Transactions and Concurrency Control 事务(Transactions) 根据维基百科的定义，一个数据库事务通常包含了一个序列的对数据库的读/写操作。它的存在包含有以下两个目的：1）为数据库操作序列提供了一个从失败中恢复到正常状态的方法，同时提供了数据库即使在异常状 阅读全文
posted @ 2018-05-09 11:24 Charonnnnn 阅读(177) 评论(0) 推荐(0)
CS3402 Relational Design
摘要：Relational Design Motivation Student(StudentID, StudentName, CourseID, CourseName, Grade) Design “anomalies” Redundancy: StudentID => StudentName (cap 阅读全文
posted @ 2018-03-07 21:04 Charonnnnn 阅读(285) 评论(0) 推荐(0)
CS3402 ER
摘要：ER Explain the difference between an entity and a relationship ● An entity is an object or concept about which you want to store information. ● Relati 阅读全文
posted @ 2018-03-07 19:13 Charonnnnn 阅读(357) 评论(0) 推荐(0)
CS3402 JSON
摘要：JSON JavaScript Object Notation (JSON) Serializing data objects Human-readable Data Interchange Representing and storing semistructured data Base Valu 阅读全文
posted @ 2018-02-04 20:50 Charonnnnn 阅读(128) 评论(0) 推荐(0)
CS3402 Introduction to SQL
摘要：SQL DDL: Create Table, Drop Table DML: Select, Insert, Delete, Update Select Col_1,Col_2,...,Col_n - what to return From Rel_1,Rel_2,...,Rel_m - relat 阅读全文
posted @ 2018-01-30 23:35 Charonnnnn 阅读(152) 评论(0) 推荐(0)
CS3402 Introduction
摘要：Introduction File Systems permanent records stored in various files application programs are written to extract & add records Disadvantages of traditi 阅读全文
posted @ 2018-01-20 15:26 Charonnnnn 阅读(198) 评论(0) 推荐(0)