DATAUML Design Introduction 11-DATAUML version 1.5 features-No Oracle client Support

　 major updates to the DATAUML Design1.5 version include:：

1, optimize the database login interface;

2, Query Analyzer smart tips;

3, optimize the database browsing plug-in, database login components, support history cache;

4, Support no Oracle client connection;

5, Support browsing database view, stored procedures, functions and triggers;

6, support from Excel file import data generation model;

7. The interface of the new combination software function;

First, the interface of the new function

Integrated into the new feature plug-in, similar to the VS compiler, all plug-ins to create a unified portal. Such as

Second, database connection interface, support no Oracle Client connection

1, optimize the database login interface, using multi-threaded way to log into the database.

2. There is no need to install Oracle Client for connecting Oracle database, for example, connect with managed mode.

3, support the history cache, record the previous login information.

4. SQL Server supports Windows Authentication logon, such as:

Third, Query Analyzer Smart tips

1, support keyword tips;

2, support database table name and table field hints, such as:

Iv. support for browsing database views, stored procedures, functions, and triggers

1, support to browse all views of the database, as well as view fields;

2, support browsing database stored procedures, as well as the contents of stored procedures;

3, support browsing database functions, as well as function content;

4, support browsing database triggers, and trigger content, such as:

V. Support for importing data generation models from Excel files

Import from Excel file to software, generate model, Excel format as shown below

Table Chinese Name

Table name

Field name

Field Chinese name

Type

Length

Decimal digits

Allow empty

Identity

Primary key

FOREIGN key

Default value

Description

FOREIGN key table

Associated Fields

Data manipulation Permission Definitions

Rt_data_right

Id

Id

Number

Whether

Is

{File permission point number} {}{}

Data manipulation Permission Definitions

Rt_data_right

Rightname

Rightname

Nvarchar2

40

Is

{Permission name} {}{}

Data manipulation Permission Definitions

Rt_data_right

Edit_tag_time

Edit_tag_time

Date

Is

Sysdate

{Data record creation date} {}{}

File Cataloging Relationship Table

File_cataloguefile

Fileno

Fileno

Varchar2

50

Whether

Is

Is

{File Number} {}{}

File_fileinfo

Fileno

File Cataloging Relationship Table

File_cataloguefile

Catano

Catano

Varchar2

50

Whether

Is

Is

{Catalog number} {}{}

File_catalogue

Id

File Cataloging Relationship Table

File_cataloguefile

Edit_tag_time

Edit_tag_time

Date

Is

Sysdate

{Data record creation date} {}{}

Catalog Meta Data

File_cataloguemetadata

Catalogueid

Catalog number

Varchar2

50

Whether

Is

Is

{Catalog number} {}{}

File_catalogue

Id

Catalog Meta Data

File_cataloguemetadata

Metadataid

Meta Data number

Nvarchar2

50

Whether

Is

Is

{meta-data number} {}{}

File_metadata

Metadatano

Catalog Meta Data

File_cataloguemetadata

Allownone

Allow to empty

Number

Is

{Allowed to be empty} {}{}

1. Select the Excel file you want to import, such as:

2, the data column in Excel and the data column of the system to set the corresponding settings, such as:

3. After the data column is successful, click Finish to generate the data model, such as:

Next stage Notice

will provide an open source model with the database mapping engine "Netuml.dataengine". 　

DATAUML Design Introduction 11-DATAUML version 1.5 features-No Oracle client Support