Database Concepts - Syracuse University

DISTRIBUTED DATABASES AND DDBMS Learning Objectives Understand the concept of Distributed Data Describe various Distributed Data and DDBMS implementations Explain how database design affects the DDBMS environment Apply DDBMS principles to solve problems

Definitions Distributed Database: A single logical database that is spread physically across computers in multiple locations that are connected by a data communications link Decentralized Database: A collection of independent databases on non-networked computers They are not the same thing! What are we talking about here?

Key Questions: Are components of the application in more than one place? Are the data in more than one place? Does the app use more than one DBMS or system for data management? Which facets, if any, are transparent to users? Why distribute your app or data? Its hard. Its complex.

So why do it? Scalability. Redundancy. Application Complexity Monolithic Everything works / is contained within one computer. Ex. Ms Word Distributed

Various working pieces are in different physical places, working over a computer network. Ex. Google Docs Data Distribution Single Site Data (Simple) All data stored in / retrieved from one place on a network.

Ex. Wordpress Multi-Site Data (Complex) Various parts of the data come from various sites on a network. Ex. My Slice, DNS Data Complexity Homogeneous (Easier)

All data associated with the application is stored in the same DBMS Ex. Wordpress Heterogeneous (More Difficult) Various data components of the application are stored in different DBMSes Ex. SU Blackboard,

Facebook Multisite Data DBMS Options Horizontal Partitioning Vertical Partitioning Distributing data by row Distributing data by table or column. Replication

Copying data either on a schedule or in real-time Summary: The taxonomy App Monolith ic Multi Site Distribut ed Single Site Hetero.

Multi Site Homo. Replicat ed Horiz. Partition ed Vert. Partiton ed Homogeneous == Same DBMS Users View of Db CRM Db

Customers Sales Staff Orders Actual Implementation N. America Europe Customers Sales Staff Orders Oracle Same Oracle

Heterogeneous == Multiple DBMS CRM Db Users View of Db Customers Sales Staff Orders Europe Orders Invoices N. America Actual Implementation File System Europe Customers

Sales Staff Orders Oracle MySQL Example of Replication CRM Db Users View of Db Customers Sales Staff Orders Actual Implementation N. America Europe

All Customers All Sales Staff All Orders All Customers All Sales Staff All Orders Master Replica Example of Horizontal Partitioning CRM Db Users View of Db Customers Sales Staff

Orders Actual Implementation N. America NA Customers NA Sales Staff NA Orders Europe E Customers E Sales Staff E Orders Example of Vertical Partitioning ERP System Users View of Db Financials

Customer Service Prod. Support Human Resources Actual Implementation N. America Financials Human Resources Europe Customer Service Prod Support 5 Typical Distributed Databases

Centralized with Single Site Data Replicated with Snapshots (in real time) Replicated with Synchronization (on demand, or a schedule) Integrated Partitions ( Paritioning in data center) Independent Partitions (Geographically distributed partitioning) 5 Typical Distributed Databases

Transparency Location Transparency Replication Transparency User/application does not need to know about duplication of data Failure Transparency

User/application does not need to know where data resides Either all or none of the actions of a transaction are committed Transparency is difficult but important. The greater the distribution of data the more there Applying The Concepts Via Example: Monolithic or Distributed? Single Site or Multi Site data? If multi-site:

H / V Partitioned or Replicated? Homogeneous or Heterogeneous? Location Transparency? Replication Transparency? Failure Transparency? DISTRIBUTED DATABASE AND DDBMS Questions?

Recently Viewed Presentations

  • Rheo-SANS at the NIST Center for Neutron Research

    Rheo-SANS at the NIST Center for Neutron Research

    As the beam traverses from the outer edge of the cup through the gap into the bob, the transmission changes. By looking at the transmission vs. position (see right) we can determine the proper alignment of the tangential slit. The...
  • Engineering Mathematics - Shades of Blue

    Engineering Mathematics - Shades of Blue

    Algebra - Ancient Babylonians and Egyptians were using algebra by 1,800 B.C. Geometry - Egypt, China, and India by 300 B.C. Trigonometry - by 200 B.C. Calculus and Differential Equations - by the 1,600's
  • A Brief, Personal History of Computer Security Education

    A Brief, Personal History of Computer Security Education

    Xerox PARC developed computer worms. The CHRISTMAS EXEC worm clobbered many systems. ... "Academic education" teaches fundamentals, principles, and their application; "training" applies this to specific environments and contexts.
  • Virus Bulletin 2006 Keynote - Hypponen

    Virus Bulletin 2006 Keynote - Hypponen

    Virus Bulletin 2006 Montreal KEYNOTE Mikko Hypponen Chief Research Officer F-Secure Corporation www.f-secure.com www.hypponen.com Simplified example (a) Computer virus consists of an excitatory (x) and an inhibitory (y) binary neuron.
  • Emotional Speech - Columbia University

    Emotional Speech - Columbia University

    Analog for concept to speech generation. Discrete -> emotions combine to form other emotions Analogous to counting real numbers Evolutionalry Primary emotions fulfill "adaptive role in helping organisms deal w/ key survivial issues posed by the environment All other emotions...
  • Presenting Yourself on the UC Application for Undergraduate

    Presenting Yourself on the UC Application for Undergraduate

    In early to mid-January, each campus the student applied to will email them to create a login username and password for access to the campus' applicant portal. This is the site at which the admission decision will be posted along...
  • The Crucible - Weebly

    The Crucible - Weebly

    Salem Witch Trials. In writing The Crucible, Miller went to the source of the Salem Witch Hunts and read transcripts of the trials.His play is not historically accurate, but does loosely follow the real events. In 1692 nineteen men and...
  • Topology optimization (pages from Bendsoe and Sigmund and

    Topology optimization (pages from Bendsoe and Sigmund and

    The example is based on a famous problem of the design of a floor beam of an MBB civil transport. A simply supported beam is loaded by uniformly distributed load down. The top figure shows what happens if we decide...