DATAUML Design Introduction 11-DATAUML 1.5 version features (support for no Oracle client connection, there is a picture of the truth)

　 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

TD class= "Xl70" width= ">fileno TD class= "Xl70" width= ">catano TD class= "Xl70" width= ">edit_tag_time

table Chinese name

table name

Field name

field Chinese name

type

length

decimal place

allow null

identify

primary key

foreign key

description

foreign key table

Association field

data operation permission definition

rt_data_right

id

number

no

Yes

{file permission point number}{}{}

data operation permission definition

rt_data_right

rightname

NVARCHAR2

40

{permission name}{}{}

data operation permission definition

rt_data_right

date

Yes

sysdate

{data record creation date}{}{}

file cataloging relationship table

file_cataloguefile

fileno

VARCHAR2

50

No

is

Yes

{file number}{}{}

file_ FILEINFO

fileno

file cataloging relationship table

file_cataloguefile

catano

VARCHAR2

50

No

is

Yes

{catalog number}{}{}

file_ Catalogue

id

file cataloging relationship table

file_cataloguefile

edit_tag_time

{data record creation date}{}{}

catalog metadata

file_cataloguemetadata

catalogueid

catalog number

varchar2

50

no

Yes

{catalog number}{}{}

file_catalogue

id

catalog metadata

file_cataloguemetadata

metadataid

meta Data number

nvarchar2

50

no

Yes

{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 1.5 version features (support for no Oracle client connection, there is a picture of the truth)