Susanto 20 sistem basis data ti ukdw sistem basis

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: nto 19 sistem basis data – ti ukdw sistem basis data – ti ukdw Denormalisasi 3NF ● Derived Value 04/11/11 budi susanto 20 sistem basis data – ti ukdw sistem basis data – ti ukdw Trik Denormalisasi ● Pisahkan antara data aktif dan nonaktif. ● Copy field antar tabel. ● ● Field-field ringkasan diletakkan pada tabel induk. Pisahkan field yang jarang dan sering diakses. ● 04/11/11 Efek dari pemisahan data aktif dan nonaktif. budi susanto 21 sistem basis data – ti ukdw sistem basis data – ti ukdw Contoh Copy field antar tabel 04/11/11 budi susanto 22 sistem basis data – ti ukdw sistem basis data – ti ukdw Field-field ringkasan 04/11/11 budi susanto 23 sistem basis data – ti ukdw sistem basis data – ti ukdw Surrogate Key dan Constraint di DW ● ● Surrogate key pada DW model mungkin akan semakin banyak digunakan. Referential integrity masih tetap dibutuhkan dalam pemodelan DW. 04/11/11 budi susanto 24 sistem basis data – ti ukdw sistem basis data – ti ukdw Skema Star 04/11/11 budi susanto 25 sistem basis data – ti ukdw sistem basis data – ti ukdw Skema Snowflake 04/11/11 budi su...
View Full Document

Ask a homework question - tutors are online