Step-by-Step UML modeling Series 7. Data Model digraphs)

Source: Internet
Author: User

Overview

The data model profile is a UML extension of Enterprise impact ect to support relational database modeling. It includes some custom extensions, such as tables, database charts, table keys, triggers and constraints. It is a technology used to model relational databases in UML.

Data Modeling not only supports object attribute modeling (such as E-R diagram), but also modeling data behavior (such as trigger, stored procedure ). the following concepts are designed during Database Design:

Schema, primary key primary, foreign key, relational relationship, constraints constraint, Index, trigger, stored procedure, view.

Table)

A table is the most basic model structure of a relational database.

Table Index)

Indicates the logical sequence of records created by a keyword segment or expression in a table file. It is a list composed of a series of record numbers, providing quick access to data. The index does not change the physical sequence of records in the table.

 

Table trigger)

When performing operations such as update, insert, and delete on a table, SQL Server automatically runs the SQL statement defined by the trigger, this ensures that data processing must comply with the rules defined by these SQL statements.
The trigger is mainly used to achieve complex integrity of reference and data consistency that cannot be guaranteed by the primary key and foreign key.

Table Constraints)

Column constraints ensure data validity.

View)

A view is a table exported from one or more tables or views. Its structure and data are based on table queries.

 

 

Let's look at another example.

 

You are welcome to participate in the discussion. If you find it helpful, please clickRecommended. Thank you very much.

Author: Spring Yang

Source: http://www.cnblogs.com/springyangwc/

The copyright of this article is shared by the author and the blog. You are welcome to repost this article, but you must keep this statement without the author's consent andArticleThe original text connection is clearly displayed on the page. Otherwise, the legal liability is retained.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.