Relational Data Model
来源:互联网 发布:微擎源码 编辑:程序博客网 时间:2024/05/16 14:12
Overview
The goal of a model is to reduce and abstract the real world into something computable.
It is represented as a collection of tables.
Relational Model describe how to operate database with some operations.
A relation is a set, no duplicate tuples.
Tuples are unordered.
Attributes are unordered and are referenced by name and not position.
A super key, SK, is a subset of attributes that uniquely identify a tuple
A super key usually has redundant attributes. A key is a set of attributes with no redundancies that uniquely identifies a tuple.
Relational Model Integrity
Candidate Key-uniquely identify a tuple.
Primary Key - One of the candidate keys.
Alternate Key - other candidate key not primary key.
Foreign Key - in one relation whose value are required to be equal to the primary key of another relation.
Entity
Referential
Relational Algebra
The Relational Algebra is a set of operators that operate on relations, producing other relations.
8 operators:
Selection Operator
used to select a subset of tuples from a single relation that satisfy a selection criterion.
Projection Operator
The projection operator is used to select a subset of attributes(columns) from a single relation.
Hence: projection removes duplicates!
Rename Operator
just a combination of the Projection operator that allows attributes to be renamed.
Product Operator
Union Operator
union compatible relations
Intersection Operator
find the same part of the two tables
Difference Operator
find the difference data of the tables.
Join Operator
a binary operator used to combine tuples from two relations where the tuples are related by some join expression.
Nature join is with the duplicate attributes removed.
Divide Operator
finished
- Relational Data Model
- A Relational Model of Data for Large Shared Data Banks
- A Relational Model of Data for Large Shared Data Banks 1970
- Chapter4 The Relational Model
- Displaying Nested Relational Data
- Entity-Relational Data Modeling
- The Relational View of Data
- Introducing LINQ to Relational Data
- RIA Services and relational data
- Introducing LINQ to Relational Data
- SpringBoot之Access Relational Data
- 关系模型概念整理 (Relational Model)
- 2.1introduction to the relational model
- Qt 之 Relational Table Model Example 解析
- Inserting relational data using DataSet and DataAdapter
- Beginning Relational Data Modeling, Second Edition
- Object Relational Mapping (ORM) data access(Spring)
- Chapter16 Data Models and Relational SQL&Assignment
- Linux进程间通信-匿名管道和与命名管道
- MyFlag Step 9:Flag相关的功能设计
- JDBC主要操作过程及API
- 简单Android应用开发全流程
- opencv直方图对比示例
- Relational Data Model
- JAVA_HOME配置
- Android的第一次课
- 关于JS优化
- eclipse android模拟器
- android应用案例:Tablayout 的使用(仿微信底栏)
- Java实现-排列序号2
- spring的Ioc和AOP
- 粒子滤波在目标跟踪的应用