数据库管理系统(DBMS)
来源:互联网 发布:室内设计学习软件 编辑:程序博客网 时间:2024/05/17 00:57
Overview
Database Basics
Data Storage
Hard Disk Basics
Indexing
Entity-Relationship(ER) Data Modelling
The Relational Data Model
Designing a Good Relational Model
Practical
Structured Query Language (SQL)
View
What is a Database
A database is a collection of related data.
Database Management System(DBMS)
A database management system is a set of programs that allow a user to user to create and manipulate a database.
It provides an abstract view of the data in the database and describes, logically, how the data is stored, accessed and modified.
The schema of a database defines the structure of the database in a formal language that is supported the DBMS.
A DBMS catalog contains a complete description of the structure of each database in the DBMS and the constraints on the data in each database.
A DB view is a subset of the DB and data derived from the DB.
program-data independence
we can change data without changing operations.
Information System & DBMS
How DBMS fit into Information System?
Interactive query or host query
Facilitates unambiguous statement
Facilitates precise query
Retrieved data is specifically stored or aggregated
Query if Boolean combination of predicates
Exact matching of condition
Provides a formal schema
A DBMS also provides:
Security
Data independence
Persistence( data can be stored on termination)
Concurrency
recovery and backup
DBMS USERS
Database Administrators (DBA) are the systems managers of the database
DBMS Data Example: Entities and Relationship
some Definitions
view
A user’s perspective of the database that may be a subset of the database or contain virtual data derived from the database but not stored in it.
Entity
Attribute
Relationship
Three level of DBMS
External Level
Users use a language incorporating:
Data Definition Language(DDL)
Data Manipulation Language(DML)
Each view describes the part of the individual user is interested in, hiding the rest of the data.
Conceptual Level
The conceptual level describes the whole database.
It hides the details of the data storage, describes the data stored and the relationships between the data.
Internal Level
It describes the physical storage of the database.
It managed by the Operating System under the direction of the DBMS.
It define the type of the stored records.
It define the using an internal DDL.
Database Administrator
The DBA has an essential role in any DBMS and has overall control of the DBMS.
Data Models
Hierarchical
Network
Relational
finished
- 数据库管理系统(DBMS)
- 数据库管理系统 -DBMS
- 数据库管理系统DBMS
- 数据库管理系统DBMS概论
- 数据库管理系统DBMS之缓存管理
- 数据库(DB)与数据库管理系统(DBMS)
- 数据库管理系统DBMS通用系统构架
- 数据库管理系统DBMS系统构架
- 数据库管理系统(DBMS)的安全现状
- 数据库管理系统(DBMS)理解及实现
- DBMS--数据库管理系统原型开发(C/C++)
- 读书笔记:DBMS数据库管理系统预览
- 数据库管理系统(DBMS)的概述
- 数据库和数据库管理系统(Database and DBMS:Database Management System)
- 用java语言写数据库管理系统(DBMS)
- PowerDesigner中怎样切换PDM的数据库管理系统DBMS?
- 数据库系统概述+相关DBMS
- 集成 Web 应用程序服务器和数据库管理(DBMS)
- (个人)AR电子书系统创新实训第四周(2)
- Selective Search for Object Recoginition
- 机器学习——决策树算法
- mysql 多表联合update
- ubuntu永久关闭ntp服务
- 数据库管理系统(DBMS)
- R语言线性回归之逐步回归
- 我与eclipse的第一次约会
- 剑指offer 面试题44 扑克牌的顺子
- 梯度下降和牛顿法
- (项目)AR电子书系统创新实训第四周(1)
- OpenShot 发布 2.3.2 版本啦!
- 【操作系统】页面置换算法
- 搜索--06