SSDM - Sibilo Software Development Model

Search 
(by Google)
     

Developer's Corner - Database (UML-DB Mapping)
  1. Introduction
    1. Overview (N-tier Architecture)
    2. Downloads
  2. Requirements Capture
    1. Natural Language Text to UML
  3. UML Static Data Model
    1. Object / Class
    2. Relationships
    3. Data Type / Enumeration
    4. Supported Data Types
  4. Application Design
    1. Database (UML-DB Mapping)
    2. Business Objects (UML-Class Mapping)
    3. User Interface (UML-User Control Mapping)
  5. Sibilo Software Development Environment (Sibilo.SDE)
    1. Sibilo.SDE User Guide
  6. Sibilo.DBL Programming
    1. Introduction
      1. Background Information
      2. The Clist Class
    2. Core Objects
      1. Common Constructors
      2. Common Destructors
      3. Common Properties
      4. Common Methods
        • Add
        • Update
        • Remove
        • GetDetails
        • Load
        • Equals
      5. Shared Methods
        • GetAll
        • Remove
        • RemoveAll
        • Exists
        • Search
        • ObjectCount
        • CreateInstance
      6. User Defined Attributes
        • AddAttribute
        • RemoveAttribute
        • GetAttributeList
        • GetClassList
        • GetAttribute
        • SetAttribute
    3. Relationships
      1. Overview
      2. One-to-One Relationships
      3. One-to-Many and Many-to-Many Relationships
        • Add
        • Remove
        • RemoveAll
        • Exists
      4. Default Object of a Relationship
        • SetDefault
        • GetDefault

4.1 Database (UML-DB Mapping)

Although Sibilo.SDE generates and updated the database automatically, it is useful to know the mapping it uses.

i. Object to Table

The C prefix is removed from the object name and saved to the database with a tbl_ prefix. For each attribute a database field is created with a fld_ prefix.

ii. 1-n as Foreign Key

A foreign key field is created in the table with the primary key (ID) of the n object

iii. n-n as Link Table

A link table is created with the tbl_link_ prefix and the two table names it links. (e.g. tbl_link_user_photo) This table has the primary keys (IDs) of the 2 tables as foreign keys.

iv. 1-1 & Inheritance tables

A foreign key field is created in the main table. For example when CPhoto inherits CFile, a fld_fileID foreign key is created in tbl_photo.