Back to XTG Data Modeller
User defined fonts and colors
Our applications are always coloured, because we do not like "gray windows".
You can define your own colors and fonts for each model, for each object.
User defined fonts and colors
 
6 Levels of View
6 Levels of View
 
Text objects
- You can place a text object anywhere on the workspace.
- You can define background color and text-alignment.
Text objects
 
EXPLORE DATABASE
- Global Connect/Disconnect
- Count(*) on selected entities
- Browse Data: Run SELECT * FROM... from Entity or from Relationship control point (automatic join)
- Compose and run queries (where, having)
- Sort Asc/Desc by any attribute (right click on column title)
- Run   select ATR, count(*) from TABLES where ACTUAL_CONDITION group by ATR   on any column by one click.
- Show SQL command
- Auto-Form
- Data export from grid (CSV, HTML, TXT, and "insert-into" formats)
- Execute query by button Execute or by Ctrl+Enter in search field
Count(*) on selected entities
Count(*) on selected entities
Browse data
Browse data
GROUP BY
GROUP BY
Operators
Operators
  Auto-Form
Auto-Form
EXPORT settings
EXPORT settings
  Toolbar buttons
Toolbar buttons

Sorting
Sorting

 
User-defined datatypes (UDD)
User-defined datatypes (UDD) 
- Main menu - Repository - User-defined datatypes

- You can define user-defined datatypes.
- You can define template for UDD generation,
  e.g. "create domain %NAME% as %DEF%"
- The new reengineering engine recognizes UDDs now (Inb,Ora,Mic).
 
HTML REPORT
HTML REPORT 
- Main menu - Report - Save HTML report

- You can check off what to generate
- You can define your own CSS style (there are 2 predefined styles)

SAMPLE1
SAMPLE2
HTML report styles (CSS)
 
SQL SCRIPT
SQL SCRIPT 
- Main menu - Report - Save SQL script

- You can check off what to generate (script appendix, drop index, drop table, UDD, create table, primary key, table appendix, foreign key, on delete, create index)
- You can select entites in the workspace
- You can define script appendix (beginning of the script, end of the script)
- You can define Table appendix to script for each table (e.g. create generator, insert into table, additional constraints, ...)
 
ATTRIBUTE REPOSITORY
- a derivation of attributes with different datatypes is enabled, e.g. COUNTER --> INTEGER
- a checking of physical names syntax is turned off, because some users want to use strange symbols in identifiers (it will be user defined in next version)
- support for default value and other constraints
- special datatype EMPTY - completely user defined attribute definition
- datatype extension (e.g. in InterBase: use it with COMPUTED or for CHARACTER SET)
 
RELATIONSHIPS
RELATIONSHIPS  - Logical name added.
- CARDINALITY - XTG Notation: the most understandable combination of CASE Method Notation and IDEF1X Notation
- global setting: "Display Cardinality Symbols"
- Delete relationship options: "Delete relationship and attributes" or "Delete only relationship"
- Text position for each relationship (left,right,up,down,none)
- Model settings: checkbox "Show relationship name" - you can turn it off for all relationships in a model.
- Run select * from Table1, Table2 where automatic_join

Relationship menu
 
MISCELLANEOUS
- Mouse wheel support (+Shift = horizontal scrolling)
- Selecting a group of entities on the workspace by mouse rectangle (+Shift = add another group)
- 3 redraw type: Real (small model, fast computer), Medium, NoLines (large model, slow computer)
- EDIT: Select all entities, Delete selected entities, Delete NOT selected entities
- InterBase (INB): Flag Desc for index (instead of Asc/Desc at attributes)
- Microsoft SQL Server (MIC): IDENTITY - checkbox "idty" on Entity dialog.
Only IDENTITY = IDENTITY(1,1) is supported now. Full support for IDENTITY(seed, increment) will be in some next version.
- New file format: old models are converted into the new structure and the backup file *.22x is created.
- Last level of view is saved in XER
- Last used SQL, HTM, CSS filename is saved in XER
- No more irritating automatic indexes on PK (except Centura SQLBase)
- ENTITY: alias definition. Options: unique alias checking, display alias on entity.
 
 
 
Back to XTG Data Modeller

Last modification: 2001-05-21