The main updates to the DATAUML Design1.5 version include the following:
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 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 | TD class= "Xl70" width= ">fileno
fileno |
VARCHAR2 |
50 |
|
No |
|
is |
Yes |
|
{file number}{}{} |
file_ FILEINFO |
fileno |
file cataloging relationship table |
file_cataloguefile | TD class= "Xl70" width= ">catano
catano |
VARCHAR2 |
50 |
|
No |
|
is |
Yes |
|
{catalog number}{}{} |
file_ Catalogue |
id |
file cataloging relationship table |
file_cataloguefile | TD class= "Xl70" width= ">edit_tag_time
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-Support for Oracle-free client connectivity, UML modeling