XTG Data Modeller - News in 2.3.0

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.

6 Levels of View

Text objects

- You can place a text object anywhere on the workspace.
- You can define background color and text-alignment.

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

Browse data

GROUP BY

Operators

Auto-Form

EXPORT settings

Toolbar buttons

Sorting
Sorting

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

- 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

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

- 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

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