What are the six elements of UML data modeling

This article mainly introduces the six elements of UML data modeling is what the relevant knowledge, content detailed and easy to understand, simple and fast operation, with a certain reference value, I believe that we read this UML data modeling six elements is what the article will gain, let's take a look at it.

UML Data Model Diagram

Introduction to UML Data Modeling

Data modeling can be used not only to model attributes of objects (e.g. E-R diagrams), but also to model behaviors of data (e.g. Trigger, StoredProcedure). When designing a database, several concepts are designed as follows:

Schema, Primary, Foreignkey, Relationship, Constraint, Index, Trigger, StoredProcedure, View.

UML Data Modeling Elements

1. Table

Table is the most basic model structure of relational database. as shown below

Primary key of table: InventoryID

Foreign key of table: WarehouseId, associated to the primary key of table Warehouse

You can set the database type of Table, or you can set the table space.

2. TableIndex

The logical order in which records are established by a key field or expression in a table file. It is a list of a series of record numbers that provide quick access to data. An index does not change the physical order of records in a table

3. TableTrigger

SQL Server automatically executes the SQL statements defined by the triggers when operations such as UPDATE, INSERT, or Delete are performed on a table, ensuring that the processing of the data must conform to the rules defined by the SQL statements.

The main function of triggers in UML data modeling is to achieve complex referential integrity and data consistency that cannot be guaranteed by primary keys and foreign keys

4. TableConstraint

The validity of the data is guaranteed by constraints on columns.

5. View

A view is a table derived from one or more tables or views whose structure and data are based on queries against the table.

6. Stored Procedure

Common or very complex work, written in advance with SQL statements and stored with a specified name, then later to ask the database to provide the same function as the defined stored procedure, just call execute, you can automatically complete the command.

The content of this article on "What are the six elements of UML data modeling" is introduced here, thank you for reading! I believe everyone has a certain understanding of "what are the six elements of UML data modeling" knowledge. If you still want to learn more knowledge, please pay attention to the industry information channel.