- 다중 데이터 원천을 가지는 데이터웨어하우스 뷰의 자율갱신
- Self Maintainable Data Warehouse Views for Multiple Data Sources
- ㆍ 저자명
- 이우기,Lee. Woo-Key
- ㆍ 간행물명
- 경영정보학연구
- ㆍ 권/호정보
- 2004년|14권 3호|pp.169-187 (19 pages)
- ㆍ 발행정보
- 한국경영정보학회
- ㆍ 파일정보
- 정기간행물| PDF텍스트
- ㆍ 주제분야
- 기타
Self-maintainability of data warehouse(DW) views is an ability to maintain the DW views without requiring an access to (i) any underlying databases or (ii) any information beyond the DW views and the delta of the databases. With our proposed method, DW views can be updated by using only the old views and the differential files such as different files, referential integrity differential files, linked differential files, and backward-linked differential files that keep the truly relevant tuples in the delta. This method avoids accessing the underlying databases in that the method achieves self-maintainability even in preparing auxiliary information. We showed that out method can be applicable to the DW views that contain joins over relations in a star schema, a snowflake schema, or a galaxy schema.