A database profile provides foundational data for a database evaluation. It helps you better understand your source database and quickly retrieve information to guide your migration and modernization efforts.
Create a profile
-
Log on to Data Management (DMS) 5.0.
-
In the top menu bar, select .
-
Click the Source Database Profile Analysis tab. In the upper-left corner of the page, click Create Profile.
-
In the Create Profile panel, enter a Profile Name, select a data Type and Report Language, click Upload to upload the data file, and then click Create.
Note-
Creating a source database profile can take 1 to 30 minutes, depending on the amount of data collected from the source database.
-
When the profile status changes to Complete, the profile has been created successfully.
-
View profile analysis details
On the Source Database Profile Analysis tab, find the target profile and click Details in the Actions column to view its analysis details.
Source database profile summary
Click the Summary tab to view the source database profile analysis summary.
-
Basic information statistics
-
Session: Measures the database connection status. A higher score indicates more concurrent sessions.
-
Complexity: ADAM calculates the profile complexity by evaluating factors such as scenario characteristics from the information collected from the source database. A higher score indicates a more complex database.
-
Risk: Measures potential performance risks from SQL statements or objects. A higher score indicates a higher risk level in the database.
-
Hotspot: Measures the access concentration on specific objects. A higher score indicates that some data objects are heavily accessed.
-
Scale: Measures the resource scale of the database. A higher score indicates a larger database.
-
Load: Measures the runtime performance of the database. A higher score indicates a high load.
-
-
Distribution of major objects
Shows the distribution of object types within the source database.
You can also click Download Report to download the ADAM source database profile analysis report.
Detailed profile analysis
Click the Details tab to view the analysis results for the source database profile from multiple dimensions.
Currently, only Oracle databases support viewing detailed profile analysis.
-
Performance
Provides statistics on QPS, TPS, CPU utilization, and load information.
-
Capacity
Provides schema capacity rankings and capacity distribution by object type, such as tables, indexes, and LOB fields.
-
Oracle features
Provides a detailed view of Level-1 and Level-2 database syntax features to help you fully understand which features your source database uses. Features are displayed in a tree on the left and a table on the right. When you click a feature in the tree, the table displays the database objects that use it. The search box supports queries on any field.
-
External dependencies
Provides a list of DBLinks and their details. For databases with external dependencies, you must consider cross-database query issues during modernization.
-
Other Dimensions
ADAM identifies and analyzes special types of tables and SQL, such as tables without a primary key, fast-growing tables, and SQL statements with aggregate functions. Click View to see the object's details.
-
Object Details
Provides multi-dimensional information about objects, including object characteristic tags, relationships (such as dependent objects and tables with foreign key associations), and the features an object contains. Click Panoramic View for a given object to view its details without querying the source database.
The Panoramic View consists of two parts. The upper part displays the object's basic information and detailed DDL. The lower part displays data analyzed by ADAM, such as the object's characteristics, dependencies, and features.
-
Panoramic Search
The Panoramic Search feature helps you quickly find target objects during database application modernization. This function supports multiple search types, such as exact match, fuzzy match, and match by type. You can combine these types to find object information in the profile. You can search for objects by schema, DDL, type, and tags, and also view their various relationships and tags.
Related operations
|
Actions |
Description |
Procedure |
|
Append to profile |
Source database profiles support multi-version management. If the data in your database changes after a profile is created, you can add new collection files to the original profile. |
The system automatically generates a new profile version based on all the data files. |
|
Authorize profile |
Important
Use the authorization feature with caution. The authorizer is responsible for any information leakage caused by the authorization. |
Note
To view your Alibaba Cloud account ID, hover over the |
|
Delete a profile |
You can delete profiles that you no longer need. After you delete a profile, the system automatically deletes all evaluation projects generated from it. |
|
icon in the upper-right corner of the console.Next steps
Select the target profile and click Next: View Target Database Suggestions to navigate to the Destination Database Selection Suggestions tab. For more information, see Destination database selection suggestions.