130 likes | 275 Views
Outline. Introduction Background Distributed DBMS Architecture Distributed Database Design Distributed Query Processing Distributed Transaction Management Building Distributed Database Systems (RAID) Mobile Database Systems Privacy, Trust, and Authentication Peer to Peer Systems.
E N D
Outline • Introduction • Background • Distributed DBMS Architecture • Distributed Database Design • Distributed Query Processing • Distributed Transaction Management • Building Distributed Database Systems (RAID) • Mobile Database Systems • Privacy, Trust, and Authentication • Peer to Peer Systems
Useful References • B. Bhargava and John Riedl, The Raid Distributed Database System, IEEE Trans on Software Engineering, 15(6), June 1989. • B. Bhargava and John Riedl, A Model for Adaptable Systems for Transaction Processing, IEEE Transactions on Knowledge and Data Engineering, 1(4), Dec 1989. • B. Bhargava, Building Distributed Database Systems. • Y. Zhang and B. Bhargava, WANCE: Wide area network communication emulation systems, IEEE workshop on Parallel and Distributed Systems, 1993. • E. Mafla, and B. Bhargava, Communication Facilities for Distributed Transaction Processing Systems, IEEE Computer, 24(8), 1991. • B. Bhargava, Y. Zhang, and E. Mafla, Evolution of a communication system for distributed transaction processing in RAID, Computing Systems, 4(3), 1991.
Implementations • LOCUS (UCLA) File system OS • TABS (Camelot) (CMU) Data servers OS • RAID (Purdue) Database level (server) • SDD-1 (Computer Corp. of America) Transaction manager Data manager • System – R* (IBM) Database level • ARGUS (MIT) Guardian (server)
site j, k, l,… User Transaction . . . . . . . . . . Database after commit log//diff file Parser read only compiled transactions updates Action Driver (interpret transactions) Action Driver (interpret transactions) compiled transactions Action Driver (ensure transaction atomicity across sites) Atomic Controller abort or commit compiled transactions Concurrency Controler Action Driver (ensure serializability) Architecture of RAID System
Query Language DBMS completed transactions Atomicity Controller Atomicity Controller Atomicity Controller Concurrency Controller RAID Transactions
RAID Distributed System DBMS other applications DBOS other applications RAID OS OS • RAID supports reliability • transactions • stable storage • buffer pool management
Local Database User Process (UI and AD) (2 messages) TM Process (AM, AC, CC, RC) (2 messages) Remote RAID Sites Transaction Management in one Server
Experiences with RAID Distributed Database • Unix influences must be factored out. • Communications software costs dominate everything else. • Server based systems can provide modularity and efficiency. • Concurrent execution in several server types is hard to achieve. • Need very tuned system to conduct experiments. • Data is not available from others for validation. • Expensive research direction, but is respected and rewarded.