1 / 15

Model Data

Panji Wisnu Wirawan. Model Data. Agenda. Model Data Penyusunan Model Data Data Administration. Model Data. Model  pola, rencana, reprenstasi/miniatur, atau deskripsi yang didesain untuk menunjukkan struktur atau kerja dari obyek, sistem dan konsep.

kolton
Download Presentation

Model Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Panji Wisnu Wirawan Model Data

  2. Agenda • Model Data • Penyusunan Model Data • Data Administration

  3. Model Data • Model  pola, rencana, reprenstasi/miniatur, atau deskripsi yang didesain untuk menunjukkan struktur atau kerja dari obyek, sistem dan konsep. • Model data  representasi entitas atau obyek yang menunjukkan struktur kerja sistem informasi.

  4. Model Data • Pemodelan data  fase-2 information engineering (IE). • Hasil  sebuah desain yang mencerminkan data yang diperlukan organisasi. • Macam model data : • Relational • Object Relational • Dimensional

  5. Model Data

  6. Model Data

  7. Model Data

  8. Model Data • Keuntungan model data : • Memberikan gambaran menyeluruh mengenai data yang dibutuhkan dalam organisasi/perusahaan. • Memberikan kemudahan dalam berkomunikasi.

  9. Penyusunan Model Data • Top-down approach • Dibagi menjadi • Conceptual data model • Logical data model • Physical data model

  10. Conceptual Data Model • Conceptual data model  a high-level representation of business information and its sources and endpoints and the events that occur in all steps in between • includes an Entity Relationship Diagram (ERD) • created without consideration of database concepts

  11. Conceptual Data Model

  12. Logical Data Model • Logical data model The logical design of a database involves taking the business information discovered in a CDM and translating it into an empirical layout of the data, usually in a relational style. • Includes entities/tables, attributes / columns /fields and relationships. • Uses business names for attributes. • Is independent of technology (platform, DBMS). • Is normalized to 4th normal form

  13. Physical Data Model • Physical Data Model It describes an absolute design of the database implementation. A data architect, or sometimes a database administrator, completes this stage. • Includes tables, columns, keys, data types, validation rules, database triggers, stored procedures, domains, and access constraints.

  14. Physical Data Model • Uses abbreviated column names limited by the database management system (DBMS) • Includes primary keys and indices for fast data access. • May be de-normalized to meet performance requirements

  15. Data Administration (DA) • Tujuan  meningkatkan pemahaman dan manajemen data. • Bertanggung jawab mengembangkan dan memelihara standar manajemen data dan prosedur, &membuat panduan dan metode untuk berbagi-pakai data. • Data Administrator berhak me-review dan menyetujui desain model data.

More Related