Line 14: Line 14:
 
* sometimes called "virtual data integration"
 
* sometimes called "virtual data integration"
 
* better for the Web - there are many DBs, and we would like to find something, no matter what DB provides it
 
* better for the Web - there are many DBs, and we would like to find something, no matter what DB provides it
** so it can be a preferred approach for [[OBDA|Ontology Based Data Access]]
+
** so it can be a preferred approach for [[Ontology Based Data Access]]
 
* also better if you want to access "fresh" data
 
* also better if you want to access "fresh" data
 
* but way harder to implement - need to transform data during the query time  
 
* but way harder to implement - need to transform data during the query time  
Line 30: Line 30:
  
 
== Source ==
 
== Source ==
* Web Data Management book [http://webdam.inria.fr/Jorge]
+
* [[Web Data Management (book)]]
  
 +
[[Category:Semantic Web]]
 
[[Category:Data Integration]]
 
[[Category:Data Integration]]

Latest revision as of 15:44, 23 November 2015

Data Integration

Goal of Data Integration - provide uniform access to heterogeneous data sources in some domain.


Main approaches

Data Warehousing

  • data from all data sources are federated into one main warehouse (using ETLs)
  • the queries are issued to this federated storage
  • architecture-dwh.png


Mediator

  • data remains in the data sources
  • sometimes called "virtual data integration"
  • better for the Web - there are many DBs, and we would like to find something, no matter what DB provides it
  • also better if you want to access "fresh" data
  • but way harder to implement - need to transform data during the query time
  • architecture-mediator.png


See Also

Links

Source