Download
statistical databases in theory and practice part iii designing statistical databases n.
Skip this Video
Loading SlideShow in 5 Seconds..
Statistical databases in theory and practice Part III: Designing statistical databases PowerPoint Presentation
Download Presentation
Statistical databases in theory and practice Part III: Designing statistical databases

Statistical databases in theory and practice Part III: Designing statistical databases

129 Views Download Presentation
Download Presentation

Statistical databases in theory and practice Part III: Designing statistical databases

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Statistical databases in theory and practicePart III: Designing statistical databases Bo Sundgren 2008-02-11

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

  3. Concept 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. 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

  10. 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

  11. Concept model ---> Data model

  12. Concept model ---> Star/cube model

  13. Star model for Data Warehouse

  14. Multidimensional model (cube model)

  15. Modelling the contents and structure of official statisticsOr: How to design ”correct” and globally consistent SDMX Data Structure DefinitionsOr: Navigating in a space of statistical surveys of societyOr: Reality as a statistical construction Bo Sundgren, Statistics Sweden ICES-III, Montreal, June 18-21, 2007

  16. What can a statistical agency do, in order to help a user - find potentially relevant statistical data? - judge the relevance of data retrieved? • Provide overviews of available data • Provide search tools • Provide informative metadata

  17. Conceptual navigation: contents exploration and searching for statistics • A conceptual model of societyas reflected by official statistics

  18. Statistics Canada: Agents, Events, Things

  19. Contents By Example (based on a simple generic model) Complex objects Utilities Actors

  20. Everything ”clickable” OBJECT VARIABLE Righthand click Lefthand click • Select: • object • variable • Retrieve metadata: • definition • value set, classification • questionnaire • quality declaration • survey documentation

  21. UNESCO model version 1 (to be revised)