Objecteering SQL Designer User Guide

Table of Contents

 

 

Chapter 1 – Introduction to SQL Designer

              Overview of Objecteering SQL Designer

              Prerequisites

              Developing applications

              Structure of this user guide

              Glossary

             

    

Chapter 2 – Working with SQL Designer

              Before starting

              Configuring SQL Designer

              Configuring by adding notes predefined by generation

              The auxiliary window and SQL Designer

 

 

Chapter 3 – 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

             

 

Chapter 4 – 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

             

 

Chapter 5 – 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

             

 

Chapter 6 – 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

             

             

Chapter 7 – Calling SQL Designer commands on-line

              Calling commands on-line

 

 

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