Metadata Analysis
eprentise is a knowledge-based system that incorporates hundreds of thousands of rules about relational databases. eprentise gathers these rules through a process called Metadata Analysis. During Metadata Analysis, eprentise software uses a proprietary technique to “mine” information about your database installation by examining the data dictionaries, applying patterns and algorithms of relational databases, and comparing your actual instance(s) against the standard “Gold” versions of E-Business Suite it already knows.
eprentise Metadata Analysis mines these database rules from the application, and stores the valid rules in an active knowledge base. Metadata Analysis discovers all database objects (e.g., tables and columns, primary and unique keys, rows and objects, foreign keys, other constraints, triggers). When it finds information about your environment, it confirms the information by checking every row of data to see if the information is consistent within the database, and then validates the information against the eprentise Knowledge Repository. After all the rules about the metadata are confirmed and validated, Metadata Analysis populates the eprentise Knowledge Repository with information specifically about your database, your schemas, all the constraints, and other database objects.
Along with user-created rules, the knowledge from Metadata Analysis allows eprentise to perform the functions of copy, merge, filter, and change to any data or data object in the database. The rules serve as selection criteria to allow eprentise to manipulate the data and maintain the relational integrity of the database. The sequence of rules and the objects that the rules act upon can be re-used or modified to repeat the process with different nuances and twists until the data is changed to meet a customer’s business requirements. Once rules are created, eprentise uses what it has learned from Metadata Analysis to generate code to transform the data everywhere in the E-Business Suite.
Each software product in the eprentise hd_Suite includes Metadata Analysis at the core of its functionality. These include:
 |
Consolidation | Learn More |
 |
Reorganization | Learn More |
 |
Divestiture | Learn More |
 |
Data Quality | Learn More |
 |
Data Archive and Subset | Learn More |
Frequently Asked Questions
Main Menu
EBS Problems We Solve
Have a Question?
The MDA Process
The analysis process is:
- Include or exclude schemas from the instance you will analyze.
- Analyze the instance data and rules.
- Analyze configurations.
- Use the Dashboard to verify that the analysis procedure is in progress.
- Generate reports of analysis results.
Once you execute Analyze Instance, the eprentise software will automatically do the following:
Gather Metadata collects all the database and application object information (i.e. tables and columns, primary and unique keys, rows and objects, foreign keys, other constraints, triggers) for the instance, which is used later to Validate Instance.
Validate Instance confirms that the database objects are consistent with other known database objects for that type of database or the installed version of the E-Business Suite.
Validate Database Rules analyzes the rules and constraints found in the database by checking each row of data to determine if the constraint is valid. eprentise Metadata Analysis validates four types of constraints: primary key, unique key, check constraints, and foreign key constraints.
Build Rules and Knowledge Repository Adds entries to the eprentise Knowledge Repository. A Dashboard screen is available to watch progress while the Metadata Analysis is being performed, and Metadata Analysis Reports are available once the Metadata Analysis steps have all completed.
