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

Source: Internet
Author: User

  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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.