1 / 65

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

Statistical databases in theory and practice Part III: Designing statistical databases. Bo Sundgren 2008-02-11. Conceptual data model and relational data model in normalised form. Concept modelling. Define concepts and relations between them Conceptual models and data models

phiala
Download Presentation

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

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 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)

More Related