integration

integration - InformationIntegration Mediators Warehousing

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
1 Information Integration Mediators Warehousing Answering Queries Using Views
Background image of page 1

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

View Full DocumentRight Arrow Icon
2 Example Applications 1. Enterprise Information Integration: making separate DB’s, all owned by one company, work together. 2. ScientiFc DB’s, e.g., genome DB’s. 3. Catalog integration: combining product information from all your suppliers.
Background image of page 2
3 Challenges 1. Legacy databases : DB’s get used for many applications. You can’t change its structure for the sake of one application, because it will cause others to break. 2. Incompatibilities : Two, supposedly similar databases, will mismatch in many ways.
Background image of page 3

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

View Full DocumentRight Arrow Icon
4 Examples : Incompatibilities Lexical : addr in one DB is address in another. Value mismatches : is a “red” car the same color in each DB? Is 20 degrees Fahrenheit or Centigrade? Semantic : are “employees” in each database the same? What about consultants? Retirees? Contractors?
Background image of page 4
5 What Do You Do About It? Grubby, handwritten translation at each interface.
Background image of page 5

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

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 19

integration - InformationIntegration Mediators Warehousing

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online