- The UML Data Modeling Profile ...1. - The power of the Unified Modeling Language is not limited to object oriented software development.. - More and more, the UML is being applied to other areas of software development, such as data modeling, enhancing practitioners’ ability to communicate their needs and assessments to the rest of the team.. - The database itself traditionally has been described by notations called entity relationship diagrams, using graphic representation that is similar but not identical to that of the UML.. - The UML can be used to describe the complete development of relational and object relational databases 1 from business requirements through the physical data model. - However, modeling of the physical data model must express a detailed description of the database. - This is done using Rational’s Data Modeling Profile for the UML 2. - The UML Data Modeling Profile. - This white paper describes in detail the Data Modeling profile for the UML as implemented by Rational Rose Data Modeler, including descriptions and examples for each concept including database, schema, table, key, index, relationship, column, constraint and trigger. - It is written for those who have experience in traditional data modeling as well as some familiarity with the UML.. - The relational database is the standard database supported by the Data Modeling UML profile. - An object relational database, an extension of the relational database, is also supported by the UML profile.. - 2 Data Modeling Profile for UML is not yet approved by OMG.. - The UML and Data Modeling. - The full description of the data model to be used for retrieval and storage of data is stored in a schema inside of a database. - The schema is the biggest unit that can be worked with at any given time . - It represents a set of records of the same structure, also called rows. - A primary key uses a PK tag in front of the column as shown. - In a diagram, the PK tag represents the primary key, and the PK stereotyped operation is the primary key constraint. - A foreign key represents a column, which is a part of a relationship to another table.. - An FK tag represents the foreign key. - It generates the foreign key constraint, which is represented by a stereotype FK on an operation.. - The diagram representation uses the Index stereotype in front of the operation. - The index constraint specifies the columns included and optionally the uniqueness of the index.. - The child table creates a foreign key column and foreign key constraint to address the parent table.. - The foreign key of the child table does not contain all of the primary key columns. - All of the primary keys of the parent table (Person, in this example) become both primary and foreign key columns in the child table (Account). - The column can be either persistent or computed.. - Persistent columns can be tagged as primary key columns, nullable columns, and unique columns.. - Constraints can be checked for any column.. - A constraint is a rule applied to the structure of the database. - Primary key. - The primary key constraint defines the primary key as a rule on the table.. - Foreign key. - The foreign key constraint defines the foreign key as a rule on the table.. - Figure 16 An example of the check constraint is BALANCE >. - With the data modeling for UML profile, the UML fully supports data modeling needs. - It allows the support of software development and data modeling with one unified language. - Using the UML data modeling profile, Rational Rose Data Modeler unifies software development teams with a single, shared tool.
Xem thử không khả dụng, vui lòng xem tại trang nguồn hoặc xem
Tóm tắt