清华大学分布式数据库课件资源-CSDN文库

共8个文件

pdf：8个

清华大学，分布式数据库

5星 · 超过95%的资源需积分: 15 137 浏览量 2011-12-26 00:19:56 上传评论收藏 1.4MB ZIP 举报

资源推荐

资源详情

资源评论

收起资源包目录

package

清华大学分布式数据库.zip （8个子文件）

folder

清华大学分布式数据库

Transaction.pdf 410KB

Design.pdf 246KB

Architecture.pdf 148KB

Parallel.pdf 177KB

Begin.pdf 82KB

Semantic.pdf 132KB

Query.pdf 332KB

Introduction.pdf 160KB

Distributed DBMS Page 10-12. 1© 1998 M. Tamer Özsu & Patrick Valduriez

Outline

■ Introduction

■ Background

■ Distributed DBMS Architecture

■ Distributed Database Design

■ Semantic Data Control

■ Distributed Query Processing

❏ Distributed Transaction Management

➠ Transaction Concepts and Models

➠ Distributed Concurrency Control

➠ Distributed Reliability

❏ Parallel Database Systems

❏ Distributed Object DBMS

❏ Database Interoperability

❏ Concluding Remarks

Distributed DBMS Page 10-12. 2© 1998 M. Tamer Özsu & Patrick Valduriez

Transaction

A transaction is a collection of actions that make

consistent transformations of system states while

preserving system consistency.

➠concurrency transparency

➠failure transparency

Database in a

consistent

state

Database may be

temporarily in an

inconsistent state

during execution

Begin

Transaction

End

Transaction

Execution of

Transaction

Database in a

consistent

state

Distributed DBMS Page 10-12. 3© 1998 M. Tamer Özsu & Patrick Valduriez

Transaction Example –

A Simple SQL Query

Transaction BUDGET_UPDATE

begin

EXEC SQL UPDATE PROJ

SET BUDGET = BUDGET∗1.1

WHERE PNAME = “CAD/CAM”

end.

Distributed DBMS Page 10-12. 4© 1998 M. Tamer Özsu & Patrick Valduriez

Example Database

Consider an airline reservation example with the

relations:

FLIGHT(FNO, DATE, SRC, DEST, STSOLD, CAP)

CUST(CNAME

, ADDR, BAL)

FC(FNO, DATE, CNAME

,SPECIAL)

Distributed DBMS Page 10-12. 5© 1998 M. Tamer Özsu & Patrick Valduriez

Example Transaction – SQL Version

Begin_transaction Reservation

begin

input(flight_no, date, customer_name);

EXEC SQL UPDATE FLIGHT

SET STSOLD = STSOLD + 1

WHERE FNO = flight_no AND DATE = date;

EXEC SQL INSERT

INTO FC(FNO, DATE, CNAME, SPECIAL);

VALUES (flight_no, date, customer_name, null);

output(“reservation completed”)

end . {Reservation}

内容反馈

lijiaxun

2013-02-05

distributed database of qinghua
wtveyes

2013-05-16

分布式不是太懂，不错，看看。

wawlian

粉丝: 12
资源: 10

最新资源

资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！点击此处反馈

feedback-tip