1 / 16

Statistical databases in theory and practice Part II: Data models

Statistical databases in theory and practice Part II: Data models. Bo Sundgren, 2011 bo.sundgren@gmail.com https://sites.google.com/site/bosundgren/ https://sites.google.com/site/bosundgren/my-life/Statisticaldatabases-anintroduction.pdf?attredirects=0.

linus-vasquez
Download Presentation

Statistical databases in theory and practice Part II: Data models

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. Statistical databases in theory and practicePart II: Data models Bo Sundgren, 2011 bo.sundgren@gmail.com https://sites.google.com/site/bosundgren/ https://sites.google.com/site/bosundgren/my-life/Statisticaldatabases-anintroduction.pdf?attredirects=0

  2. Conceptual data model and relational data model in normalised form

  3. Conceptual modelling • Define concepts and relations between them • Conceptual models and data models • Visualise models graphically

  4. Rent-A-Video: first object graph

  5. Rent-A-Video: elaborated object graph

  6. Rent-A-Video: further aspects

  7. one-to-one, symbolised by “arrow-to-arrow” one-to-many, symbolised by “arrow-to-fork” many-to-one, symbolised by “fork-to-arrow” many-to-many, symbolised by “fork-to-fork” Relations between two object types Note: The relation is usually not a flow relation! (But you should tell what kind of relation it is.)

  8. Object graphs: another example

  9. Different roles of concept modelling • Clarifying a small number of related concepts • Information model for an application • defining meaning • basis for data design • Corporate information model • for more efficient communication between people • basis for system integration

  10. Concept model ---> Data model

  11. Conceptual model ---> Star/cube model

  12. Star model for Data Warehouse

  13. Multidimensional model (cube model)

  14. Part II: Extra material Bo Sundgren 2010

  15. Concept modelling: Exercises • B2B • The customers of companies are companies • Companies have employees (persons) • B2C • The customers of companies are consumers (persons) • Companies have employees (persons) • B2B+B2C • The customers of companies are companies or consumers (persons) • Companies have employees (persons) • Hint: There are two basic object types, COMPANY and PERSON in all three examples

More Related