Tagged value types

 

Introduction

The tagged values provided by Objecteering are used to adapt Objecteering SQL Designer semantics to a specific UML model, in order to generate Objecteering SQL Designer notions accurately.

 

 

Tagged values on an artifact

 

Tagged value

SQL

{dbName(database_path)} 

  

 

 

Tagged values on an association

 

Tagged value

SQL

RDBMS

{external}

 

 

{cluster(cluster_name)}

CLUSTER

Oracle

{tablespace(tablespace_name)}

TABLESPACE (Oracle)

SEGMENT (Sybase)

 

{partition(partition_name)}

 

Sybase only

{pctfree(value)}

PCTFREE

Oracle

{pctused(value)}

PCTUSED

Oracle

{initrans(value)}

INITRANS

Oracle

{maxtrans(value)}

MAXTRANS

Oracle

{storage(value)}

STORAGE

Oracle

{maxRowsPerPage(value)}

 

Sybase

{fillfactor(value)}

 

 

 

 

Tagged values on an association end

 

Tagged value

SQL

{sqlOptimized}

 

{onDeleteCascade}

 

{primaryKey}

 

 

 

Tagged values on an attribute

 

Tagged value

SQL

{sqlDefault(default_value}

Default

{globalTable(table_name)}

 

{indexKey(index_name,rank)}

 

{primaryKey(rank)}

 

{foreignKey(table_name,column_name [constraint_name])}

 

{compositeKey(key_name,rank)}

 

{persistence(type_persistence)}

 

{sqlType(specific_type)}

 

{alterTable}

 

{sqlDoNotGenerate}

 

 

 

Tagged values on a class

 

Tagged value

SQL

{fillfactor(value)}

WITH FILLFACTOR (Sybase)

{maxRowsPerPage(value)}

WITH MAX_ROWS_PER_PAGE (Sybase)

cluster_name : {cluster(cluster_columns,...)}

CLUSTER (Oracle)

{initrans(value)}

INITRANS (Oracle)

{maxtrans(value)}

MAXTRANS (Oracle)

{pctfree(value)}

PCTFREE (Oracle)

{pctused(value)}

PCTUSED (Oracle)

{storage(clause)}

STORAGE (Oracle)

{indexSpace(tablespace_name)}

TABLESPACE (Oracle)

{indexStorage(clause)}

STORAGE (Oracle)

{classAttributesTableName(table_name)}

 

{oneTablePerConcreteClass} 

 

{oneTablePerClass} 

 

{oneTable} 

 

{noDDL} 

 

{oid} 

 

{tablespace(tablespace_name)}

TABLESPACE (Oracle), ON (Sybase)

{partition(number)}

PARTITION (Sybase)

{keyName(key_name)}

 

{indexName(index_name)}

 

{persistence(type_persistence)}

 

{tableOwner(table_owner_name)}

 

{indexOwner(index_owner_name)}

 

 

 

Tagged values on a generalization

 

Tagged value

SQL

{persistence(the_persistence)}

  

 

 

Tagged values on a model element

 

Tagged value

SQL

{sqlName(SQL_Name)}  

  

 

 

Tagged values on an operation

 

Tagged value

SQL

{tgInsert} 

  

{tgUpdate} 

  

{tgDelete} 

  

{tgBefore} 

  

{tgAfter} 

  

 

Note:      The tagged values presented in the table above must only be used on operations stereotyped <<trigger>>.