{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

DataIntegration - Outline Introduction Distributed DBMS...

Info icon This preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
Distributed & Parallel DBMS M. Tamer Özsu Page 8.1 Outline Introduction Distributed DBMS Architecture Distributed Database Design Distributed Query Processing Distributed Transaction Management Data Replication Parallel Database Systems Data Integration Systems Schema Matching Schema Integration Schema Mapping Web Search/Querying Peer-to-Peer Data Management Data Stream Management
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Distributed & Parallel DBMS M. Tamer Özsu Page 8.2 Problem Definition Given existing databases with their Local Conceptual Schemas (LCSs), how to integrate the LCSs into a Global Conceptual Schema (GCS) z GCS is also called mediated schema Bottom-up design process
Image of page 2
Distributed & Parallel DBMS M. Tamer Özsu Page 8.3 Integration Alternatives Physical integration z Source databases integrated and the integrated database is materialized z Data warehouses, Enterprise Application Integration (EAI) Logical integration z Global conceptual schema is virtual and not materialized z Enterprise Information Integration (EII)
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Distributed & Parallel DBMS M. Tamer Özsu Page 8.4 Methodology
Image of page 4
Distributed & Parallel DBMS M. Tamer Özsu Page 8.5 GCS/LCS Relationship Local-as-view z The GCS definition is assumed to exist, and each LCS is treated as a view definition over it Global-as-view z The GCS is defined as a set of views over the LCSs
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Distributed & Parallel DBMS M. Tamer Özsu Page 8.6 Database Integration Issues Schema translation z Component database schemas translated to a common intermediate canonical representation Schema creation z Intermediate schemas are used to create a global conceptual schema
Image of page 6
Distributed & Parallel DBMS M. Tamer Özsu Page 8.7 Schema Translation What is the canonical data model? z Relational z Entity-relationship DIKE z Object-oriented ARTEMIS z Graph-oriented DIPE, TranScm, COMA, Cupid Preferable with emergence of XML No common graph formalism Mapping algorithms z These are well-known
Image of page 7

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Distributed & Parallel DBMS M. Tamer Özsu Page 8.8 Schema Creation Schema matching z Finding the correspondences between multiple schemas Schema integration z Creation of the GCS (or mediated schema) using the correspondences Schema mapping z How to map data from local databases to the GCS Important: sometimes the GCS is defined first and schema matching and schema mapping is done against this target GCS
Image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern