![]() |
Data
Architect Professional database modeling |
![]() |
Data
Architect may look slightly different than pictured above because of
the platform you are using and/or any user interface look + feel you may
be using but the fundementals are the same regardless. Most examples
in this book are from the Linux platform with the Motif window
manager and the CDE look + feel. |
Dock-window |
Description |
Tool-bar |
In the example above - the
tool-bar is found just below the menu. It consists of a number
of dock-windows, each containing buttons for quick access to
commonly used options. |
Browser |
In the example above - the
Browser is found along the left-edge of the main window. The
Browser contains the Workspace, and all of its objects,
organized hierarchiely. This is great for browsing the objects. |
Output |
In the example above - the
output window lies along the bottom of the main window. The
output window contains a wide variety of messages produced by
the application. The messages are categorized using tabs. |
Slider-bar |
In the example above - the
Slider-bar is the top dock-window along the right edge of the
main window. The slider-bar contains a sub-set of tool-bar
options and is often a convenient alternative. |
Property Editor |
In the example above - the
property editor is the middle dock-window along the right edge
of the main window. The property editor contains a sub-set of
the properties for the currently selected document object. |
Panner |
In the example above - the
panner is the bottom dock-window along the right edge of the
main window. The panner provides a complete view of the current
diagram/model with a red box indicating the current area of the
document visible. The red box can be dragged to scroll (pan) the
document. The panner provides a great tool to orient the User and to
quickly navigate large documents. |
Icon |
Description |
SQL Editor |
Diagram |
Logical Model |
Physical Model |
![]() |
create a new file |
![]() |
![]() |
![]() |
![]() |
![]() |
open an existing file |
![]() |
![]() |
![]() |
![]() |
![]() |
save any changes in current editor |
![]() |
![]() |
![]() |
![]() |
![]() |
print from current editor |
![]() |
![]() |
![]() |
![]() |
![]() |
application preferences or
object properties |
![]() |
![]() |
![]() |
![]() |
![]() |
undo last change |
![]() |
|||
![]() |
redo last change |
![]() |
|||
![]() |
cut selection from current editor |
![]() |
![]() |
![]() |
![]() |
![]() |
copy selection from current editor |
![]() |
![]() |
![]() |
![]() |
![]() |
paste into current editor |
![]() |
![]() |
![]() |
![]() |
![]() |
delete selection from current editor |
![]() |
![]() |
![]() |
![]() |
![]() |
indent text in current editor |
![]() |
|||
![]() |
unindent text in current editor |
![]() |
|||
![]() |
move selected diagram objects to front |
![]() |
![]() |
![]() |
|
![]() |
move selected diagram objects to back |
![]() |
![]() |
![]() |
|
![]() |
insert an SQL file comment |
![]() |
|||
![]() |
insert an SQL statement comment |
![]() |
|||
![]() |
zoom in current editor (make objects look larger) |
![]() |
![]() |
![]() |
|
![]() |
zoom out current editor (see more of the diagram) |
![]() |
![]() |
![]() |
|
![]() |
select all in current editor |
![]() |
![]() |
![]() |
![]() |
![]() |
unselect everything in current editor |
![]() |
![]() |
![]() |
![]() |
![]() |
align text to bottom |
![]() |
![]() |
![]() |
|
![]() |
align text to horizontal center |
![]() |
![]() |
![]() |
|
![]() |
align text to left |
![]() |
![]() |
![]() |
|
![]() |
align text to right |
![]() |
![]() |
![]() |
|
![]() |
align text to top |
![]() |
![]() |
![]() |
|
![]() |
align text to vertical center |
![]() |
![]() |
![]() |
|
![]() |
align object bottom | ![]() |
![]() |
![]() |
|
![]() |
align object horizontal center | ![]() |
![]() |
![]() |
|
![]() |
align object left | ![]() |
![]() |
![]() |
|
![]() |
align object right | ![]() |
![]() |
![]() |
|
![]() |
align object top | ![]() |
![]() |
![]() |
|
![]() |
align object vertical center | ![]() |
![]() |
![]() |
|
![]() |
manipulate diagram objects in the current editor |
![]() |
![]() |
![]() |
|
![]() |
add a new Text object to the current editor |
![]() |
![]() |
![]() |
|
![]() |
add a new Line object to the current editor |
![]() |
![]() |
![]() |
|
![]() |
add a new Arc object to the current editor |
![]() |
![]() |
![]() |
|
![]() |
add a new Rectangle object to the current editor |
![]() |
![]() |
![]() |
|
![]() |
add a new Ellipse object to the current editor |
![]() |
![]() |
![]() |
|
![]() |
add a new Image object to the current editor |
![]() |
![]() |
![]() |
|
![]() |
add a new Table object to the current editor |
|
![]() |
||
![]() |
add a new Derived Table object to the current
editor |
![]() |
|||
![]() |
add a new View object to the current editor |
![]() |
|||
![]() |
add a new Reference object to the current editor |
![]() |
|||
![]() |
add a new Inheritance object to the current
editor |
![]() |
|||
![]() |
add a new Business Rule | ![]() |
|||
![]() |
add a new Domain | ![]() |
|||
![]() |
add a new Sequence |
![]() |
|||
![]() |
add a new stored Procedure | ![]() |
|||
![]() |
add a new Entity | ![]() |
|||
![]() |
add a new Relationship | ![]() |
|||
![]() |
add a new Association entity |
![]() |
|||
![]() |
add a new Association Link | ![]() |
|||
![]() |
add a new Inheritance Link | ![]() |
|||
![]() |
add a new Business Rule | ![]() |
|||
![]() |
add a new Domain | ![]() |
|||
![]() |
add a new Data Item | ![]() |
|||
![]() |
edit model properties |
![]() |
![]() |
||
![]() |
show object dependencies |
![]() |
|||
![]() |
validate model |
![]() |
![]() |
||
![]() |
create a Physical Model from
current document |
![]() |
|||
![]() |
create a Logical Model from
current document |
![]() |
|||
![]() |
create an SQL script, from the current model, to
be used to create database objects |
![]() |
|||
![]() |
reverse engineer an existing database using the
capabilities found in the current model |
![]() |
|||
![]() |
submits the entire SQL script to the, connected,
data source for processing |
![]() |
|||
![]() |
submits the selected SQL to the, connected, data
source for processing |
![]() |
|||
![]() |
returns a list of schema from the, connected,
data source |
![]() |
|||
![]() |
returns a list of tables from the, connected,
data source |
![]() |
|||
![]() |
returns a list of views from the, connected,
data source |
![]() |
|||
![]() |
returns a list of columns for the table or view
name selected in the current editor |
![]() |
|||
![]() |
returns a list of indexs for the table name
selected in the current editor |
![]() |
|||
![]() |
returns a list of primary key columns for the
table name selected in the current editor |
![]() |
|||
![]() |
returns a list of foreign key columns for the
table name selected in the current editor |
![]() |
|||
![]() |
returns a list of columns which uniquely
identify a row for the table name selected in the current editor |
![]() |
|||
![]() |
returns a list of procedures from the,
connected, data source |
![]() |
|||
![]() |
returns a list of columns (input and output) for
the procedure name selected in the current editor |
![]() |
|||
![]() |
returns a list of data types supported |
![]() |
|||
![]() |
invokes any installed ODBC Administrator tool |
![]() |
Button |
Name |
Description |
![]() |
New |
Create a new object (if no "New
Plus") or reference to an object (if "New Plus" exists). |
![]() |
Edit |
Edit the object represented on
the currently selected row. |
![]() |
Delete |
Delete the object represented on the currently selected row. |
![]() |
Up |
Move the row up. |
![]() |
Down |
Move the row down. |
![]() |
New Plus |
Create a new object and
reference to the object. |