1 / 10

EDIT WP5 Internet Platform for Cybertaxonomy

EDIT WP5 Internet Platform for Cybertaxonomy. Data Modelling on UML Basis Gubányi A.-Kiss, V.-Kilián, I. (Hungarian Natural History Museum) Meeting: HNHM Budapest, 7-May-07. Principles of Relational Data Modelling. Entity-Relationship Diagram Normal Forms

melvin-holman
Download Presentation

EDIT WP5 Internet Platform for Cybertaxonomy

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. EDIT WP5 Internet Platform for Cybertaxonomy Data Modelling on UML Basis Gubányi A.-Kiss, V.-Kilián, I. (Hungarian Natural History Museum) Meeting: HNHM Budapest, 7-May-07.

  2. Principles of Relational Data Modelling • Entity-Relationship Diagram • Normal Forms • NF1…3: practically eliminating redundant data storage, and determining dependency relationships among data pieces…

  3. Example: an RDMBS data model

  4. Example: an UML model – (persistent) Entities

  5. An UML model – (transient) attribute types

  6. UML based data modelling • UML entity model (classes, attributes, associations) • Projecting class model to ER diagram • Projection by hand • Projection by a runtime tool (Java Hybernate)

  7. Principles of projecting Class Model to ER Diagrams • UML Modelling principles: • TransientPersistent classes Scalar types • Attribute types: ONLY transients and scalars • Otherwise: associations, aggregations, compositions • ClassesTables • AttributesFields • Associations • 1..n associations to (nullable) foreign keys • N..m associations to tables

  8. Notes for Claus Riede’s ATBI model • Volume/content/complexity • General technical notes • Description of database scheme is necessary • Enumerations  described or stored in tables • Constraints should be set • Concrete notes • support_Experts support_Participants • data_Record.loc_ID: redundant field • data_record.members:

  9. Thank you for your attention!

More Related