DW 1day
Database/Data Warehouse 2013. 4. 17. 19:31 |* DW(Data Warehouse) 특징
1. time-variant (historical)
2. Subject-Oriented 주제지향적
3.intergrated 통합된
4. non-volitile 비휘발성의
*
|
|
DW |
DATAMART |
|
scope |
enterprise |
department |
|
subjects |
multiple |
single, LOB(line of business 업무영역) |
|
source |
many |
few |
|
구축기간 |
months to years |
months |
* ERD : Entity-relationship diagram
entity : 개체 -> table
attribute : 속성 -> column
relationship : FK(foreign Key)