Objecteering SQL Designer User Guide

Table of Contents

 

 

Introduction

Overview of Objecteering SQL Designer

Prerequisites

Developing applications

Structure of this user guide

Glossary

 

 

Working with SQL Designer

Before starting

Configuring SQL Designer

Configuring by adding notes predefined by generation

The auxiliary window and SQL Designer

 

 

Quick tour

Overview of this quick tour

Importing the demonstration package

Generating the physical model

Creating an SQL generation work product

Generating SQL files

Building the database schema

 

 

Generation principles

Generating the database schema

Mapping generalization

Attributes

0..1-* associations

Generating triggers

Stored procedures

Compositions

1-1 associations

N-ary associations

Class associations

Generalizations and associations

Structure in packages

Integrity constraints

Standardized logical schema

Additional annotations

 

 

User interface

Interactive interface

The auxiliary window and SQL Designer

Refactoring the logical model

Generating the physical model

Generating the SQL

Visualizing the SQL

Executing the SQL

Executing the alter table file

 

 

Annotating the model

Tagged value types

Note types

Stereotypes

Annotating an association

Annotating an association end

Annotating an attribute

Annotating a class

Annotating a constraint

Annotating a datatype

Annotating a generalization

Annotating a model element

Annotating an operation

Annotating a package

 

 

Calling SQL commands on-line

Calling commands online

 

 

Appendix 1 – Oracle

Overview of the Oracle appendix

Class - Generation specific to Oracle

Class annotations

Association - Generation specific to Oracle

Association annotations

Attribute - Generation specific to Oracle

Attribute annotations

Distributed databases

 

 

Appendix 2 – Sybase

Overview of the Sybase appendix

Package annotations

Class - Generation specific to Sybase

Class annotations

Association - Generation specific to Sybase

Association annotations

Attribute - Generation specific to Sybase

Attribute annotations

Specific SQL errors

Restrictions

 

 

Appendix 3 – SQL Server

Overview of the SQL Server appendix

Package annotations

Class - Generation specific to SQL Server

Class annotations

Association - Generation specific to SQL Server

Association annotations

Attribute - Generation specific to SQL Server

Attribute annotations

Specific SQL errors

Restrictions