distributed relational database systems
play

Distributed Relational Database Systems Dr Janusz R. Getta School - PowerPoint PPT Presentation

Mar 09, 2023 •295 likes •618 views

Distributed Relational Database Systems file:///Users/jrg/235-2020-SPRING/SLIDES/WEEK07/15distributeddatbase/15distributeddatabase.html#1 CSCI235 Database Systems Distributed Relational Database Systems Dr Janusz R. Getta School of Computing

  1. Distributed Relational Database Systems file:///Users/jrg/235-2020-SPRING/SLIDES/WEEK07/15distributeddatbase/15distributeddatabase.html#1 CSCI235 Database Systems Distributed Relational Database Systems Dr Janusz R. Getta School of Computing and Information Technology - University of Wollongong 1 of 31 11/9/20, 7:08 pm

  2. Distributed Relational Database Systems file:///Users/jrg/235-2020-SPRING/SLIDES/WEEK07/15distributeddatbase/15distributeddatabase.html#1 Distributed Relational Database Systems Outline Distributed database ? What is it ? Centralized database schema model Mainframe application architecture Client-server architecture Distributed client-server architecture Web based architecture Distributed Web based architecture Distributed database schema architecture Transparency Autonomy Advantages and disadvantages of DDBS Distributed database system Oracle 12c TOP Created by Janusz R. Getta, CSCI235 Database Systems, Spring 2020 2/31 2 of 31 11/9/20, 7:08 pm

  3. Distributed Relational Database Systems file:///Users/jrg/235-2020-SPRING/SLIDES/WEEK07/15distributeddatbase/15distributeddatabase.html#1 Distributed database ? What is it ? Distributed database system (DDBS) is a collection of multiple logically related databases distributed over a computer network Distributed database management system (DDBMS) is a collection of database systems together with software providing a required set of operations on data and management features Homogeneous DDBS is a collection of identical database systems distributed over a computer network, e.g. a collection of Oracle database systems Heterogeneous DDBS is a collection of di ff erent database systems distributed over a computer network, e.g. a collection of Oracle + MySQL + DB/2 + MongoDB + XML native database systems + Excel spreadsheets + ... , systems TOP Created by Janusz R. Getta, CSCI235 Database Systems, Spring 2020 3/31 3 of 31 11/9/20, 7:08 pm

  4. Distributed Relational Database Systems file:///Users/jrg/235-2020-SPRING/SLIDES/WEEK07/15distributeddatbase/15distributeddatabase.html#1 Distributed database ? What is it ? A sample organization of heterogeneous distributed database system TOP Created by Janusz R. Getta, CSCI235 Database Systems, Spring 2020 4/31 4 of 31 11/9/20, 7:08 pm

  5. Distributed Relational Database Systems file:///Users/jrg/235-2020-SPRING/SLIDES/WEEK07/15distributeddatbase/15distributeddatabase.html#1 Distributed Relational Database Systems Outline Distributed database ? What is it ? Centralized database schema model Mainframe application architecture Client-server architecture Distributed client-server architecture Web based architecture Distributed Web based architecture Distributed database schema architecture Transparency Autonomy Advantages and disadvantages of DDBS Distributed database system Oracle 12c TOP Created by Janusz R. Getta, CSCI235 Database Systems, Spring 2020 5/31 5 of 31 11/9/20, 7:08 pm

  6. Distributed Relational Database Systems file:///Users/jrg/235-2020-SPRING/SLIDES/WEEK07/15distributeddatbase/15distributeddatabase.html#1 Centralized database schema model In a centralized database schema model the users are provided their personal external schemas (views) of data The external schemas are integrated into a single conceptual schema later on transformed into a logical schema and implemented as physical schema TOP Created by Janusz R. Getta, CSCI235 Database Systems, Spring 2020 6/31 6 of 31 11/9/20, 7:08 pm

  7. Distributed Relational Database Systems file:///Users/jrg/235-2020-SPRING/SLIDES/WEEK07/15distributeddatbase/15distributeddatabase.html#1 Distributed Relational Database Systems Outline Distributed database ? What is it ? Centralized database schema model Mainframe application architecture Client-server architecture Distributed client-server architecture Web based architecture Distributed Web based architecture Distributed database schema architecture Transparency Autonomy Advantages and disadvantages of DDBS Distributed database system Oracle 12c TOP Created by Janusz R. Getta, CSCI235 Database Systems, Spring 2020 7/31 7 of 31 11/9/20, 7:08 pm

  8. Distributed Relational Database Systems file:///Users/jrg/235-2020-SPRING/SLIDES/WEEK07/15distributeddatbase/15distributeddatabase.html#1 Mainframe application architecture In mainframe application architecture "dumb" terminals are connected to a single database server TOP Created by Janusz R. Getta, CSCI235 Database Systems, Spring 2020 8/31 8 of 31 11/9/20, 7:08 pm

  9. Distributed Relational Database Systems file:///Users/jrg/235-2020-SPRING/SLIDES/WEEK07/15distributeddatbase/15distributeddatabase.html#1 Distributed Relational Database Systems Outline Distributed database ? What is it ? Centralized database schema model Mainframe application architecture Client-server architecture Distributed client-server architecture Web based architecture Distributed Web based architecture Distributed database schema architecture Transparency Autonomy Advantages and disadvantages of DDBS Distributed database system Oracle 12c TOP Created by Janusz R. Getta, CSCI235 Database Systems, Spring 2020 9/31 9 of 31 11/9/20, 7:08 pm

  10. Distributed Relational Database Systems file:///Users/jrg/235-2020-SPRING/SLIDES/WEEK07/15distributeddatbase/15distributeddatabase.html#1 Client-server architecture In client-server architecture personal systems communicate with a single database server TOP Created by Janusz R. Getta, CSCI235 Database Systems, Spring 2020 10/31 10 of 31 11/9/20, 7:08 pm

  11. Distributed Relational Database Systems file:///Users/jrg/235-2020-SPRING/SLIDES/WEEK07/15distributeddatbase/15distributeddatabase.html#1 Distributed Relational Database Systems Outline Distributed database ? What is it ? Centralized database schema model Mainframe application architecture Client-server architecture Distributed client-server architecture Web based architecture Distributed Web based architecture Distributed database schema architecture Transparency Autonomy Advantages and disadvantages of DDBS Distributed database system Oracle 12c TOP Created by Janusz R. Getta, CSCI235 Database Systems, Spring 2020 11/31 11 of 31 11/9/20, 7:08 pm

  12. Distributed Relational Database Systems file:///Users/jrg/235-2020-SPRING/SLIDES/WEEK07/15distributeddatbase/15distributeddatabase.html#1 Distributed client-server architecture In distributed client-server architecture personal systems communicate with many database servers TOP Created by Janusz R. Getta, CSCI235 Database Systems, Spring 2020 12/31 12 of 31 11/9/20, 7:08 pm

  13. Distributed Relational Database Systems file:///Users/jrg/235-2020-SPRING/SLIDES/WEEK07/15distributeddatbase/15distributeddatabase.html#1 Distributed Relational Database Systems Outline Distributed database ? What is it ? Centralized database schema model Mainframe application architecture Client-server architecture Distributed client-server architecture Web based architecture Distributed Web based architecture Distributed database schema architecture Transparency Autonomy Advantages and disadvantages of DDBS Distributed database system Oracle 12c TOP Created by Janusz R. Getta, CSCI235 Database Systems, Spring 2020 13/31 13 of 31 11/9/20, 7:08 pm

  14. Distributed Relational Database Systems file:///Users/jrg/235-2020-SPRING/SLIDES/WEEK07/15distributeddatbase/15distributeddatabase.html#1 Web based architecture In Web based architecture personal systems communicate with the Web servers that communicate with a single database server TOP Created by Janusz R. Getta, CSCI235 Database Systems, Spring 2020 14/31 14 of 31 11/9/20, 7:08 pm

  15. Distributed Relational Database Systems file:///Users/jrg/235-2020-SPRING/SLIDES/WEEK07/15distributeddatbase/15distributeddatabase.html#1 Distributed Relational Database Systems Outline Distributed database ? What is it ? Centralized database schema model Mainframe application architecture Client-server architecture Distributed client-server architecture Web based architecture Distributed Web based architecture Distributed database schema architecture Transparency Autonomy Advantages and disadvantages of DDBS Distributed database system Oracle 12c TOP Created by Janusz R. Getta, CSCI235 Database Systems, Spring 2020 15/31 15 of 31 11/9/20, 7:08 pm

  16. Distributed Relational Database Systems file:///Users/jrg/235-2020-SPRING/SLIDES/WEEK07/15distributeddatbase/15distributeddatabase.html#1 Distributed Web based architecture In Distributed Web based architecture personal systems communicate with the Web servers that communicate with many database servers TOP Created by Janusz R. Getta, CSCI235 Database Systems, Spring 2020 16/31 16 of 31 11/9/20, 7:08 pm

  17. Distributed Relational Database Systems file:///Users/jrg/235-2020-SPRING/SLIDES/WEEK07/15distributeddatbase/15distributeddatabase.html#1 Distributed Relational Database Systems Outline Distributed database ? What is it ? Centralized database schema model Mainframe application architecture Client-server architecture Distributed client-server architecture Web based architecture Distributed Web based architecture Distributed database schema architecture Transparency Autonomy Advantages and disadvantages of DDBS Distributed database system Oracle 12c TOP Created by Janusz R. Getta, CSCI235 Database Systems, Spring 2020 17/31 17 of 31 11/9/20, 7:08 pm

Download Presentation
Download Policy: The content available on the website is offered to you 'AS IS' for your personal information and use only. It cannot be commercialized, licensed, or distributed on other websites without prior consent from the author. To download a presentation, simply click this link. If you encounter any difficulties during the download process, it's possible that the publisher has removed the file from their server.

Recommend

CS 377 Database Systems Relational Data Model Department of

CS 377 Database Systems Relational Data Model Department of

CS 377 Database Systems Relational Data Model Department of Mathematics and Computer Science Emory University 1 Outline Relational Model Concepts Relational Model Constraints Relational Database and

655 views • 32 slides
CAS CS 460/660 Introduction to Database Systems Relational Algebra 1.1 Relational Query

CAS CS 460/660 Introduction to Database Systems Relational Algebra 1.1 Relational Query

CAS CS 460/660 Introduction to Database Systems Relational Algebra 1.1 Relational Query Languages Query languages: Allow manipulation and retrieval of data from a database. Relational model supports simple, powerful QLs: Strong

577 views • 40 slides
Introduction to Database Systems Formal Relational Languages Textbook Reference Database

Introduction to Database Systems Formal Relational Languages Textbook Reference Database

CPSC 304 Introduction to Database Systems Formal Relational Languages Textbook Reference Database Management Systems: 4 - 4.2 (skip the calculii) Learning Goals Identify the basic operators in Relational Algebra (RA). Use RA to create

859 views • 49 slides
The Relational Model and Relational Algebra Cs386, Introduction to Database Systems Jay Urbain

The Relational Model and Relational Algebra Cs386, Introduction to Database Systems Jay Urbain

The Relational Model and Relational Algebra Cs386, Introduction to Database Systems Jay Urbain Credits: Database Management Systems, Raghu Ramkrishnan and Johannes Gehrke Data Management, Richard Watson The relational model Overcomes

295 views • 29 slides
Database Management Limitations of Relational Database Designs Systems Provides a set of

Database Management Limitations of Relational Database Designs Systems Provides a set of

Lecture 2 Database Management Limitations of Relational Database Designs Systems Provides a set of guidelines, does not result in a unique database schema Winter 2004 Does not provide a way of evaluating alternative schemas CMPUT

387 views • 17 slides
CS4224/CS5424 Lecture 1 Introduction Distributed Database Systems A distributed database is a

CS4224/CS5424 Lecture 1 Introduction Distributed Database Systems A distributed database is a

CS4224/CS5424 Lecture 1 Introduction Distributed Database Systems A distributed database is a collection of multiple, logically interrelated databases distributed over a computer network A distributed database management system (DDBMS)

1.3k views • 37 slides
CS 61: Database Systems Introduction to the relational model Adapted from Silberschatz, Korth,

CS 61: Database Systems Introduction to the relational model Adapted from Silberschatz, Korth,

CS 61: Database Systems Introduction to the relational model Adapted from Silberschatz, Korth, and Sundarshan unless otherwise noted Agenda 1. Big picture of relational database design 2. Relational algebra 3. Intro to SQL SELECT statement

963 views • 34 slides
INTRODUCTION TO RELATIONAL DATABASE SYSTEMS DATENBANKSYSTEME 1 (INF 3131) Torsten Grust

INTRODUCTION TO RELATIONAL DATABASE SYSTEMS DATENBANKSYSTEME 1 (INF 3131) Torsten Grust

INTRODUCTION TO RELATIONAL DATABASE SYSTEMS DATENBANKSYSTEME 1 (INF 3131) Torsten Grust Universitt Tbingen Winter 2019/120 1 WELCOME! This course will introduce you to the world of Relational Database Systems , the dominating database

532 views • 10 slides
INTRODUCTION TO RELATIONAL DATABASE SYSTEMS DATENBANKSYSTEME 1 (INF 3131) Torsten Grust

INTRODUCTION TO RELATIONAL DATABASE SYSTEMS DATENBANKSYSTEME 1 (INF 3131) Torsten Grust

INTRODUCTION TO RELATIONAL DATABASE SYSTEMS DATENBANKSYSTEME 1 (INF 3131) Torsten Grust Universitt Tbingen Winter 2015/16 1 WELCOME! This course will introduce you to the world of Relational Database Systems , the dominating database

425 views • 11 slides
Distributed Databases 1 19.1 Distributed Database System A distributed database system

Distributed Databases 1 19.1 Distributed Database System A distributed database system

Distributed Databases 1 19.1 Distributed Database System A distributed database system consists of loosely coupled sites that share no physical component Database systems that run on each site are independent of each other

761 views • 42 slides
INTRODUCTION TO RELATIONAL DATABASE SYSTEMS DATENBANKSYSTEME 1 (INF 3131) Torsten Grust

INTRODUCTION TO RELATIONAL DATABASE SYSTEMS DATENBANKSYSTEME 1 (INF 3131) Torsten Grust

INTRODUCTION TO RELATIONAL DATABASE SYSTEMS DATENBANKSYSTEME 1 (INF 3131) Torsten Grust Universitt Tbingen Winter 2019/20 1 SQL: GROUPING AND AGGREGATION In relational database design, a single table like turtles will typically hold

535 views • 18 slides
Fast and Scalable Relational Division on Fast and Scalable Relational Division on Database

Fast and Scalable Relational Division on Fast and Scalable Relational Division on Database

Fast and Scalable Relational Division on Fast and Scalable Relational Division on Database Systems Database Systems Andr S. Gonzaga , Robson L. F. Cordeiro 1. Introduction 2. Contributions 3. Background a. Genetic Data b. Diviso

710 views • 55 slides
Relational Database Design Theory Part II CPS 196.3 Introduction to Database Systems 2

Relational Database Design Theory Part II CPS 196.3 Introduction to Database Systems 2

Relational Database Design Theory Part II CPS 196.3 Introduction to Database Systems 2 Announcement ! Project proposal/progress report due today ! Midterm next Thursday in class " Everything up to todays lecture, with a focus on the

301 views • 7 slides
Outline Introduction Background Distributed DBMS Architecture Distributed Database Design

Outline Introduction Background Distributed DBMS Architecture Distributed Database Design

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,

620 views • 20 slides
Relational Algebra Module 3, Lecture 1 Database Management Systems, R. Ramakrishnan 1

Relational Algebra Module 3, Lecture 1 Database Management Systems, R. Ramakrishnan 1

Relational Algebra Module 3, Lecture 1 Database Management Systems, R. Ramakrishnan 1 Relational Query Languages Query languages: Allow manipulation and retrieval of data from a database. Relational model supports simple, powerful QLs:

236 views • 20 slides
Transaction Processing in Distributed Database Systems Dr Janusz R. Getta School of Computing

Transaction Processing in Distributed Database Systems Dr Janusz R. Getta School of Computing

Transaction Processing in Distributed Database Systems file:///Users/jrg/235-2020-SPRING/SLIDES/WEEK07/16transactiondistributed/16transactiondistributed... CSCI235 Database Systems Transaction Processing in Distributed Database Systems Dr

998 views • 24 slides
BlazeDS by John Mason mason@fusionlink.com Flex Meetup - we meet once a month - all

BlazeDS by John Mason mason@fusionlink.com Flex Meetup - we meet once a month - all

BlazeDS by John Mason mason@fusionlink.com Flex Meetup - we meet once a month - all meetings are held over Adobe Connect sessions - all meetings will be recorded and posted to Charlie Arehart's UGTV - www.carehart.org/ugtv Next

400 views • 18 slides
Distributed Query Processing Advanced Topics in Database Management (INFSCI 2711) Some materials

Distributed Query Processing Advanced Topics in Database Management (INFSCI 2711) Some materials

Distributed Query Processing Advanced Topics in Database Management (INFSCI 2711) Some materials are from Database System Concepts, Siberschatz, Korth and Sudarshan Vladimir Zadorozhny, DINS, University of Pittsburgh 1 1 Banking Example

277 views • 25 slides
Distributed Systems What can we do now that we could not do before? Introduction Paul

Distributed Systems What can we do now that we could not do before? Introduction Paul

Distributed Systems What can we do now that we could not do before? Introduction Paul Krzyzanowski pxk@cs.rutgers.edu Except as otherwise noted, the content of this presentation is licensed under the Creative Commons Attribution 2.5 License.

218 views • 9 slides
Intergovernmental Fiscal Relations in the US Sally Wallace, Dean AYSPS and University of Pretoria

Intergovernmental Fiscal Relations in the US Sally Wallace, Dean AYSPS and University of Pretoria

Intergovernmental Fiscal Relations in the US Sally Wallace, Dean AYSPS and University of Pretoria Scope of government in the US Federal republic 50 States plus the District of Columbia 89,004 local governments 3,031 counties

260 views • 9 slides
Building an Eco-System of Trusted Services through user Transparency, Control and Awareness on

Building an Eco-System of Trusted Services through user Transparency, Control and Awareness on

Building an Eco-System of Trusted Services through user Transparency, Control and Awareness on Personal Data Privacy Michele Vescovi, Telecom Italia - SKIL Corrado Moiso, Telecom Italia - Future Center Fabrizio Antonelli, Telecom Italia -

453 views • 19 slides
Programming Distributed Systems 12 Programming Models for Distributed Systems Annette Bieniusa

Programming Distributed Systems 12 Programming Models for Distributed Systems Annette Bieniusa

Programming Distributed Systems 12 Programming Models for Distributed Systems Annette Bieniusa AG Softech FB Informatik TU Kaiserslautern Summer Term 2019 Annette Bieniusa Programming Distributed Systems Summer Term 2019 1/ 27 What is a

568 views • 27 slides
Non-Functional Properties Reid Holmes How the analyst designed it How the business consultant

Non-Functional Properties Reid Holmes How the analyst designed it How the business consultant

Home Gallery Create Shop About Title Drag-and drop cells to Description rearrange the cells. Click on the captions to Home Gallery Create Shop About edit them. Save Cancel To remove a cell, just Title leave the caption empty.

170 views • 14 slides
DyMRA: Dynamic Market Deployment for Decentralized Resource Allocation Daniel Lzaro, Xavier

DyMRA: Dynamic Market Deployment for Decentralized Resource Allocation Daniel Lzaro, Xavier

DyMRA: Dynamic Market Deployment for Decentralized Resource Allocation Daniel Lzaro, Xavier Vilajosana and Joan Manuel Marqus Universitat Oberta de Catalunya Introduction Virtual communities: Formed by users with common goals that

428 views • 22 slides

More recommend