15-445
文章平均质量分 89
RedemptionC
这个作者很懒,什么都没留下…
展开
-
15445 lecture#4 Database Storage 2
1 Data RepresentationA data representation scheme is how a DBMS stores the bytes for a value. There are five high level datatypes that can be stored in tuples: integers, variable-precision numbers, fixedpoint precision numbers, variable length values, a原创 2021-03-27 20:10:43 · 298 阅读 · 1 评论 -
15445 lecture#3 Database Storage 1
1 storage我们主要关注的是disk-oriented DBMS,即DB是存在disk上的Volatile:断电就失去保存的内容 支持高速随机存取,byte-addressable 我们统称为memoryNon-Volatile:不需要通电也能保存数据 block/page addressable 对顺序存取支持更好 统称为disk,一般本课不会去区分SSD和HDD当前还有一种正在研发并流行的存储介质,persistent memory,具有上述两者的优点,快并且p.原创 2021-03-27 18:35:59 · 402 阅读 · 0 评论 -
15445 lecture#2 Intermediate SQL
(本来在想,Intermediate指啥,貌似应该是和advanced相对,中级的意思1Relational LanguagesEdgar Codd published a major paper on relational models in the early 1970s. Originally, he only defined themathematical notation for how a DBMS could execute queries on a relational model.原创 2021-03-26 12:52:40 · 365 阅读 · 1 评论 -
15-445 lecture#1 Relational Model & Relational Algebrae
1 DatabasesA database is an organized collection of inter-related data that models some aspect of the real-world (e.g.,modeling the students in a class or a digital music store). People often confuse “databases” with “databasemanagement systems” (e.g., ...原创 2021-03-25 18:15:33 · 240 阅读 · 0 评论 -
15-445 homework#1 sql
overview主要是对如上结构的db,根据各种要求写sql题目Q1 [0 POINTS] (Q1_SAMPLE):The purpose of this query is to make sure that the formatting of your output matches exactly the formatting of our auto-grading script.Details:List all types of work ordered by type asc.原创 2020-12-20 21:43:19 · 548 阅读 · 0 评论 -
15-445 project#0 cpp primer
overview本lab是作为一个15445的语言入门关(cpp),所以主要是熟悉一下modern cpp的语法和用法,以及本课程做lab时需要注意的一些东西(为了遵守课程要求,代码暂不放出代码内容主要实现三个类:matrix,RowMatrix,RowMatrixOperationsmatrix是个抽象类,定义了矩阵这个类所需要的一些基本成员变量和函数:因为大部分是虚函数,所以不需要我们填写实现需要做的是在构造函数里初始化一些变量:rows,columns,以及初始化一个一原创 2020-12-13 16:04:50 · 2938 阅读 · 8 评论