All Products
Search
Document Center

Manage a database profile

Last Updated: Nov 04, 2021

A database profile is used to evaluate a source database. It helps you monitor the status of your source database. When you migrate or transform a source database, you can search for the database based on the database profile.

Create a profile

  1. Log on to the Advanced Database & Application Migration (ADAM) console.

  2. In the left-side navigation pane, click Evaluate DB.

  3. In the upper-left corner of the Create Source DB Profile step, click Create Profile.

  4. In the Create Profile panel, specify Profile Name, Type, and Report Language Type, and then click Upload to upload a data file. Click Create. The database profile is expected to be created in 1 to 30 minutes. The time depends on the collected data of the source database.

View the profile

After the status of the source database profile changes to Complete, click Details in the Actions column to view the profile.

On the Overview tab, you can view the overview of the database profile.

  • Basic Information

    The basic information of the database profile is displayed by scale, session, risk, hotspot, complexity, and load.

    • Session: indicates the connection status of the database. The higher the value is, the more sessions are established to connect to the database.

    • Complexity: indicates the complexity of the database profile based on the scenarios and features of the source database.

    • Risk: indicates the risk level of the database. The higher the value is, the more likely the database is exposed to performance risks related to SQL statements or objects.

    • Hotspot: indicates whether the database contains objects that are frequently accessed. The higher the value is, the more objects are frequently accessed.

    • Scale: indicates the scale of database resources. The higher the value, the larger the database scale.

    • Load: indicates the running performance of the database. The higher the value, the larger the running load of the database.

  • Main Objects

    The section shows the distribution of object types in the source database.

On the Details tab, you can view the performance, capacity, features, external dependencies, other dimensions, and object details of the source database. You can also search for objects by schema, DDL, object type, or tag on the Object Search tab.

  • Performance

    The metric shows the transactions per second (TPS), queries per second (QPS), CPU utilization, and load of the database.

  • Capacity

    The metric shows the capacity ranking of database schemas and the capacity proportion of different object types such as table, index, and large object (LOB).

  • Features

    The metric shows features used by your source database in a tree diagram and a table. The tree diagram provides two levels to list all the features collected from the database. If you click a feature, the objects that have the feature are listed on the table. You can search for features by entering a condition in the search box.

  • External Dependency

    This metric shows database links and link details. You must revise schemas when you transform databases that contain external dependencies.

  • Other Dimensions

    The metric shows special tables and SQL statements, such as tables without primary keys, high growth tables, and SQL statements with aggregate functions. You can click View in the Actions column to view details.

  • Object Details

    This metric shows object information from different dimensions, such as object feature tags, relationships such as association and dependency, and features contained in objects. You can click View Object Details in the Actions column to view details.

    In the Basic Information section of the View Object Details dialog box, you can view the basic information and DDL statements of the object. In the Details section, you can view the analysis data provided by ADAM, such as the features, referenced objects, dependent objects, and features of the object.

  • Object Search

    The Object Search feature allows you to search for objects when you transform databases and applications. Exact matches, fuzzy matches, and type-based matches are supported. You can combine different filter conditions to search for objects in the profile. You can search for objects by schema, DDL, object type, or tag. You can also view the dependencies and tags of objects.

Update the profile

You can create multiple versions for a database profile. If the data in a source database is changed after a profile is created, you can append a new data file to the profile.

In the Source DB Profile step, select a database profile, and click Append in the Actions column. In the Append Profile panel, click Upload to upload a data file, and then click Create. ADAM then generates a new version of the profile based on all the data files.

Grant permissions on the profile

You can click Authorize in the Actions column to authorize other users to access the profile. The validity period of the access permissions is one month. Authorized users can view the profile and create new projects based on the profile.

Notice

Use the authorization feature with caution. You are liable for data disclosures caused by improper authorization.

You can revoke permissions on the profile from other users.

Delete the profile

If you delete a profile, all analysis data of the profile is deleted.

Move the pointer over the More icon in the Actions column and click Delete.

What to do next

Select a profile and click Next: Select Destination Database to view the suggestions on how to select a destination database.