![](https://img-blog.csdnimg.cn/20190918140145169.png?x-oss-process=image/resize,m_fixed,h_224,w_224)
Database
文章平均质量分 84
A database is an organized collection of structured information, or data, typically stored electronically in a computer system.
Rusty well began
做笔记记录用的
展开
-
【Database-04】使用DBeaver连接到达梦数据库(DM8)
使用DBeaver连接到达梦数据库(DM8)原创 2023-02-23 16:06:10 · 844 阅读 · 0 评论 -
【Database-03】从 MySQL 迁移到 达梦数据库(DM 8)
从 MySQL 迁移到 达梦数据库(DM 8)原创 2023-02-23 15:18:14 · 2171 阅读 · 2 评论 -
【Database-02】达梦数据库 - DM Manager管理工具安装
达梦数据库 - DM Manager管理工具安装原创 2023-02-23 13:51:58 · 5565 阅读 · 0 评论 -
【Database-01】达梦数据库Docker版下载安装
达梦数据库Docker版下载安装原创 2023-02-23 13:23:20 · 1161 阅读 · 0 评论 -
DatabaseSystemConcepts(SixthEdition) - Chapter 3 - Introduction to SQL
ContentsIntroduction to SQL3.1 Overview of the SQL Query Language3.2 SQL Data Definition3.2.1 Basic Types3.2.2 Basic Schema Definition3.3 Basic Structure of SQL QueriesIntroduction to SQLThere are a number of database query languages in use, either comme原创 2022-03-20 14:42:39 · 382 阅读 · 0 评论 -
DatabaseSystemConcepts(SixthEdition) - Chapter 2 - Introduction to the Relational Model
ContentsIntroduction to the Relational Model2.1 Structure of Relational Databases2.2 Database Schema2.3 KeysIntroduction to the Relational ModelThe relational model is today the primary data model for commercial dataprocessingapplications. It attained i原创 2022-03-18 15:40:46 · 614 阅读 · 0 评论 -
DatabaseSystemConcepts(SixthEdition) - chapter1 - Introduction
IntroductionA database-management system (DBMS) is a collection of interrelated data and a set of programs to access those data. The collection of data, usually referred to as the database, contains information relevant to an enterprise. The primary goal原创 2022-03-17 11:14:02 · 1089 阅读 · 0 评论 -
CS 425 – Database Organization - 4 - Chapter 4: Introduction to SQL (2)
41、Null Values and Aggregates① Total all salaries select sum (salary ) from instructorAbove statement ignores null amountsResult is null if there is no non-null amount② All aggregate operations except count(*) ignore tuples with null values on the原创 2022-03-16 12:12:41 · 297 阅读 · 0 评论 -
CS 425 – Database Organization - 4 - Chapter 4: Introduction to SQL (1)
1、Chapter 4: Introduction to SQL① Overview of the SQL Query Language② Data Definition③ Basic Query Structure④ Additional Basic Operations⑤ Set Operations⑥ Null Values⑦ Aggregate Functions⑧ Nested Subqueries⑨ Modification of the Database2、History原创 2022-03-16 11:50:45 · 239 阅读 · 0 评论 -
CS 425 – Database Organization - 3 - Chapter 3 :Formal Relational Query Language (2)
31、Tuple Relational Calculus① A nonprocedural query language, where each query is of the form{t | P (t ) }② It is the set of all tuples t such that predicate P is true for t③ is a tuple variable , t [A ] denotes the value of tuple t on attribute A④ t原创 2022-03-15 15:40:54 · 1163 阅读 · 0 评论 -
CS 425 – Database Organization - 3 - Chapter 3 :Formal Relational Query Language (1)
1、Relational Query Language① Expressive power of a query languageWhat queries can be expressed in this language?② Procedural versus non-procedural, or declarative③ “Pure” languages:Relational algebraTuple relational calculusDomain relational calc原创 2022-03-14 08:47:03 · 454 阅读 · 0 评论 -
CS 425 – Database Organization - 2- Chapter 7: Entity-Relationship Model(3)
76、UML① UML: Unified Modeling Language② UML has many components to graphically model different aspects of an entire software system③ UML Class Diagrams correspond to E-R Diagram, but several differences77、ER vs. UML Class DiagramsNote reversal of pos原创 2022-03-06 22:21:01 · 350 阅读 · 0 评论 -
CS 425 – Database Organization - 2- Chapter 7: Entity-Relationship Model(2)
41、ReviewIdentify EntitiesIdentify RelationshipDetermine AttributesDetermine CardinalityConstraints42、Chapter 7: Entity-Relationship ModelDesign ProcessModelingConstraintsE-R DiagramDesign IssuesWeak Entity SetsExtended E-R FeaturesReducti原创 2022-03-03 23:04:45 · 661 阅读 · 0 评论 -
CS 425 – Database Organization - 2- Chapter 7: Entity-Relationship Model(1)
1、Chapter 7: Entity-Relationship ModelDesign ProcessModelingConstraintsE-R DiagramDesign IssuesWeak Entity SetsExtended E-R FeaturesDesign of the Bank DatabaseReduction to Relation SchemasDatabase DesignUML2、Database Design3、Database Design原创 2022-02-28 22:58:12 · 436 阅读 · 0 评论 -
CS 425 – Database Organization - 1-chapter 1
charter原创 2022-01-17 19:57:20 · 149 阅读 · 0 评论