Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.
Database Objects
The basic unit of structure of a database is the database Table. Tables can be supported by other objects that improve the facilities and use of the database, such as:
| · | Database Views - these define subsets of the database, each aggregated into a dynamic 'virtual' Table; the information presented by a Database View is not physically replicated, but is automatically derived based on the query that defines the View |
| · | Database Procedures - a feature of some DBMSs, these are subroutines that can contain one or more SQL statements to perform a specific task such as data validation, access control, or to reduce network traffic between clients and the DBMS servers |
| · | Database Functions - a feature that some DBMS products implement to provide a mechanism to extend the functionality of the database server; each is a routine that accepts parameters, performs an action (such as a complex calculation) and returns the result of that action as a value |
| · | Database Sequences - a feature that some DBMS products implement to provide a mechanism to generate unique values - the Sequence ensures that each call to it returns a unique value |
You can quickly create and configure all of these objects in your database modeling with Enterprise Architect.
Learn more
The material ("material" includes all pages, documents and on-line graphics) on this web site is protected by copyright law. (C) 1998-2015 Sparx Systems Pty Ltd.
