Chapter 4 Database System
In this chapter,a brief introduction of Database
System is given first.In the second section,you'll
learn the basic database softwares.
The last section is an example of database
system,SQL Server,which may help you understand
database system.
Section one: A Brief Introduction Of Database
System
You're required to learn about the concept of
database,such as a table,column,row ,field, and
record,its structrure and concept of database
system and its brief history.
new words:
individual:个体
record:记录
relational:关系的
accurate:准确的,精确的
upgrade:升级
client:客户
server:服务器
database:数据库
database table:数据表
one set of:一系列
table record:数据表
database system:数据库系统
relational database:关系型数据库
client server:客户端与服务器
Reading Material A:Database Basics
Learn about basic information about how data is
installed and organized in the database and all
the data is related.
representation:代表
unique:唯一的
illegal:违法的
primary key:主键
index:索引
uncertainty:不确定
keep straight:行为正常的
lie in:取决于
foreign key:外键
Reading Material B:Database Security
security:安全
overlook:忽略
baseline:基线
component:组件
WAN:广域网(Wide Area Network)
manufacturer:制造商;厂商
vender:供应商
phase:阶段
licence:许可证
performance:性能
offset:抵销
tamper with:对...有损害
DBA:数据库管理员(Database Administrator)
right:权利
remove:移动;删除
Section Two:Types of Database
Learn about types of different database,advantage
and disadvantage.
flat file database:平面文件数据库
relational database:关系型数据库
generate:产生
detach:分开
delimiter:分隔符
tap:标签
ideal:理想的
costly:昂贵的, 贵重的
unreadable:无法阅读的
comma:逗点, 逗号
logical:逻辑的
replicate:复制
duplication:副本;复制
integrity:完整性的
query:查询
flat file:平面文件
data type:数据类型
data structure:数据结构
relational model:关系模型
build-in:内置的
readonly:只读的
be made up of:由...构成
more to mention:不必说;更不用说
Reading Material A:Types of Database Access From
Web
direct access:直接访问
protocol:协议
web server:网路服务器
encrypt:加密
interface:界面
gateway:网关
browser:浏览器
Reading Material B:Database Types
How to use types of database,library
category,article index?
plus:加上
journal:期刊;刊物
periodical index:期刊索引
citation index:引文索引
abstract:摘要
subject:学科
social science:社会科学
key words:关键字
According to alphabetical order:按照字母表顺序
Section Three:Introduction to Sql Server
Learn about basic information about Sql Server and
having a further understanding on RDBMS(Relational
Database Manager System)
Sql Server is a RDBMS made by Microsoft.Sql Server
is designed to allow thousands of people to
access to the database at the same time.
dimentional:空间的;维度的
catalog:目录
installation:安装
whatever:无论什么
insert:插入
default:缺省直
folder:文件夹
length:长度
SQL(Structure Query Language):结构化查询语言
RDBMS(Relational Database Manager System)
Two dimensional:二维的
enterprise manager:企业管理器
left hand side :左边
data file:数据文件
open up:打开
design window:设计窗口
type in:(用键盘)输入
right click:右键单击
hard drive:硬盘驱动器
As if it was on your computer
Clicking in on the data file tab will show you
where actual database is going to be installed in
your hard drive.
Reading Material A:Sql Server Administration
data center:数据中心
achieve:达到,完成
efficiency:效率
automatic:自动化的
monitory:监督
solution:解决方案
reboot:重启
writing code:写入的代码
accidently:偶然地
back up:备份
restall:恢复
track uses:追踪使用情况
enduse:终端用户
rapid:急剧的
slow down:减慢
conclude:作结论
Reading Material B:Sql Server back up and restall
in case of 万一
failure:失败
simple recovery:简单恢复
full recovery:完全恢复
injunction:指令
transaction:交易;事务
log:日志
file group:文件组
differencial backups:差异备份
make sense:有意义的
snashot backups:快照备份