Architecture and design of Distributed database Systems WAMDM Cloud Computing Group Haiping Wang 2010-05-08 2021/2/1 WAMDM Cloud Group
Architecture and Design of Distributed Database Systems WAMDM Cloud Computing Group Haiping Wang 2010-05-08 2021/2/11 WAMDM Cloud Group 1
Outline Architecture Client/Server, P2P DDBMS MDBS Design Strategies Issues Fragmentation A| ocatⅰon Conclusion 2021/2/1 WAMDM Cloud Group
Outline • Architecture – Client/Server, P2P – DDBMS,MDBS • Design – Strategies – Issues – Fragmentation – Allocation • Conclusion 2021/2/11 WAMDM Cloud Group 2
Client/Server Reference Architecture User Application Begin at 1990s aELInterface Program Communication at the level of sQl Client DBMS statement Communication Software Client SQL Result Application, user interface, DBMS Client queries relation responsible for cache management( cached data and cached transaction locks) Communication software Possible for consistency checking of user p Semantic Data Controller queries(not common Query Optimizer · Server Transaction Manager Query processing, optimization Recovery Manager transaction and storage management g L Runtime Support Processor One server system Comparison with centralized DB Multiple server client manages its own connection(heavy client Client only know it "home server"(light client Database 2021/2/1 WAMDM Cloud Group
Client/Server Reference Architecture • Begin at 1990’s • Communication at the level of SQL statement • Client – Application , user interface, DBMS Client responsible for cache management( cached data and cached transaction locks) – Possible for consistency checking of user queries(not common) • Server – Query processing, optimization, transaction and storage management – One server • Comparison with centralized DB – Multiple Server • client manages its own connection(heavy client) • Client only know it “home server”(light client) 2021/2/11 WAMDM Cloud Group 3
Physical data Organization in P2P Distributed Systems Data usually fragmented and replicated Three layer organization ES LiS (local internal schema) GCS LCS(local conceptual schema gCs( global conceptual LCS schema ESs external schema), for user LIS applications and access 2021/2/1 WAMDM Cloud Group
Physical Data Organization in P2P Distributed Systems • Data usually fragmented and replicated • Three layer organization – LIS (local internal schema) – LCS(local conceptual schema) – GCS ( global conceptual schema) – ESs (external schema), for user applications and access 2021/2/11 WAMDM Cloud Group 4
Functional Schematic of an Integrated DDBMS Administrator Global Administrator database schema Administrator For data independence database schema >Extended the anSi/sparc processo GD/D for global mapping Local Data Management Locai Data Management >LD/D for local mapping Database Administrator processor-1 processor-1 Administrator schema processor processor Int storage/ intemal transtormation transformation Mem cloud Group
Functional Schematic of an Integrated DDBMS ➢For data independence ➢Extended the ANSI/SPARC ➢GD/D for global mapping ➢LD/D for local mapping 2021/2/11 WAMDM Cloud Group 5