{"topic":{"id":1466,"title":"COMP201553-数据库基础及应用","slug":"topic","categoryId":13,"createdAt":"2023-06-25 12:24:42.126786","bumpedAt":"2023-06-25 12:33:38.946893","views":523,"postsCount":2,"highestPostNumber":2,"likeCount":4,"closed":false,"pinned":false,"pinnedGlobally":false,"pinnedAt":null,"pinnedUntil":null,"isBanner":false,"excerpt":"课程：COMP201553-数据库基础及应用 01(2022，2023 春 DB) 教材：姚普选。数据库系统——基础、设计及应用 [M].西安：西安电子科技大学出版社，2013. 教师：赵英良学分：2.0 授课学时：20.0 上机学时：12.0 开课单位：电子与信息学部本课程基于华为云 OpenGauss DB，采用 PostgreSQL 语言。笔者于大一下学习此课程。鉴于所用教材有所过时，故将笔者所学整理上传。如有错讹，敬请斧…","deletedAt":null,"isAnonymous":false,"category":{"id":13,"name":"学习资料","slug":"res","color":"FFBB00"},"author":{"id":79,"username":"Charles_Xavier","name":null,"avatarUrl":"/uploads/image/92/0e/920e57ed0af596c8489d44a4097d5aa8e158b4000fde6014a2d20ebeaa1aa97c.avif"},"tags":["resources","study","review","course"]},"posts":[{"id":3447,"postNumber":1,"raw":"> 课程：COMP201553-数据库基础及应用 01(2022，2023 春 DB)\n教材：姚普选。数据库系统——基础、设计及应用 [M].西安：西安电子科技大学出版社，2013.\n教师：赵英良\n学分：2.0\n授课学时：20.0\n上机学时：12.0\n开课单位：电子与信息学部\n\n本课程基于华为云 OpenGauss DB，采用 PostgreSQL 语言。\n笔者于大一下学习此课程。\n鉴于所用教材有所过时，故将笔者所学整理上传。如有错讹，敬请斧正。\n\n> **hint：**\n赵老师教学要求比较严格，但是讲解很清晰。如有特殊情况，反馈时应有理有据。\n实验 6 内容考试不涉及。\n\n**实验：**\n[实验 1 DBMS 的安装和基本使用方法.pdf|attachment](/uploads/pdf/ea/0d/ea0d63c62144a138b89b84d7558c2cb930f2534c899b2c559f3c91ef4c2636aa.pdf) (2.5 MB)\n[实验 2 SQL 数据查询.pdf|attachment](/uploads/pdf/ce/bf/cebfa171b99b8d8b33cc9ca09c3b269e23daff483efa16e6f64b42c2b72accb4.pdf) (1.3 MB)\n[实验 3 数据的完整性.pdf|attachment](/uploads/pdf/ca/01/ca010817779d2f72d05fa5c07cb002292af04bd2b588fefb90e6ac56d49be31c.pdf) (658.2 KB)\n[实验 4 存储过程和函数.pdf|attachment](/uploads/pdf/c5/be/c5bee59ecf60cb6d313362eb303d832519539cd56019dc9ad2358293d395dc69.pdf) (377.5 KB)\n[实验 5 数据库安全性.pdf|attachment](/uploads/pdf/05/e6/05e6829a860373e3d9b4766381eee19c633ff754d1b7b50b87de897003442b8f.pdf) (801.8 KB)\n[实验 6 Python 编写 openGauss 数据库应用程序.pdf|attachment](/uploads/pdf/e5/ec/e5ecd8e4bd6732273f69023502bb8b7821c64fb6454e00328714b5214ff5a119.pdf) (1.5 MB)\n**课程笔记：**\n[数据库基础设计及应用.pdf|attachment](/uploads/pdf/9f/e1/9fe145af8f3f0f035ac365b2854426dc486ba93bc10d88275478b24e4fc174ca.pdf) (703.0 KB)\n**题库：**\n[数据库基础及应用题库.docx|attachment](/uploads/blob/c2/96/c296aac633c721731e36ebaec73dd408ba682e330d0433b9fa8766b216193530.docx) (349.9 KB)","cooked":"

\n
课程：COMP201553-数据库基础及应用 01(2022，2023 春 DB)
\n教材：姚普选。数据库系统——基础、设计及应用 [M].西安：西安电子科技大学出版社，2013.
\n教师：赵英良
\n学分：2.0
\n授课学时：20.0
\n上机学时：12.0
\n开课单位：电子与信息学部
\n

本课程基于华为云 OpenGauss DB，采用 PostgreSQL 语言。
\n笔者于大一下学习此课程。
\n鉴于所用教材有所过时，故将笔者所学整理上传。如有错讹，敬请斧正。

\n
hint：
\n赵老师教学要求比较严格，但是讲解很清晰。如有特殊情况，反馈时应有理有据。
\n实验 6 内容考试不涉及。
\n

\n","createdAt":"2023-06-25 12:24:42.351492","updatedAt":"2023-06-25 12:27:33.855327","replyToPostNumber":null,"replyCount":0,"likeCount":3,"wordCount":322,"liked":false,"bookmarked":false,"polls":[],"reactions":[{"reaction":"❤️","count":3,"users":[{"id":31,"username":"TsuinoSora","name":null},{"id":387,"username":"Simon","name":null},{"id":1077,"username":"Ru1Z2e","name":null}],"hasReacted":false}],"wiki":false,"version":3,"publicVersion":3,"deletedAt":null,"isAnonymous":false,"user":{"id":79,"username":"Charles_Xavier","name":null,"avatarUrl":"/uploads/image/92/0e/920e57ed0af596c8489d44a4097d5aa8e158b4000fde6014a2d20ebeaa1aa97c.avif","admin":false,"moderator":false,"signatureRaw":null,"signatureCooked":null}},{"id":3449,"postNumber":2,"raw":"[quote=\"Charles_Xavier, post:1, topic:1466\"]\nGauss DB\n[/quote]\n\nHuawei Cloud GaussDB 包含很多种数据库，如 PG、MySQL，几年前还把 Gemini DB 品牌给合并了，后者包含多种非关系型数据库，如 Mongo、Cassandra。","cooked":"

\n\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\t\tCharles_Xavier:\n\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t

\n
Gauss DB
\n

\n\t\t\t\t\t\t

Huawei Cloud GaussDB 包含很多种数据库，如 PG、MySQL，几年前还把 Gemini DB 品牌给合并了，后者包含多种非关系型数据库，如 Mongo、Cassandra。

\n","createdAt":"2023-06-25 12:33:38.946893","updatedAt":"2024-03-17 13:04:44.461266","replyToPostNumber":null,"replyCount":0,"likeCount":1,"wordCount":50,"liked":false,"bookmarked":false,"polls":[],"reactions":[{"reaction":"❤️","count":1,"users":[{"id":79,"username":"Charles_Xavier","name":null}],"hasReacted":false}],"wiki":false,"version":1,"publicVersion":1,"deletedAt":null,"isAnonymous":false,"user":{"id":1047,"username":"anonymous_coward_old","name":"Anonymous Coward Old","avatarUrl":"/uploads/image/43/32/4332638c11248b8ff07033c11de0759a55205facfbec85e14458245a91991faf.avif","admin":false,"moderator":false,"signatureRaw":null,"signatureCooked":null}}],"hasMore":false,"lastReadPostNumber":1,"hasUrlPostNumber":false}