Lattix LDM for Oracle
Understand your Oracle Software Architecture
Architectural Governance for Oracle Databases
Large database implementations can consist of thousands of tables, views, stored procedures and a variety of other elements. To add to the complexity, all of these elements depend on each other in a variety of ways. None of the approaches in use today provide a way for database administrators and developers to visualize or understand these relationships effectively.
The DSM approach is the first which allows you to understand the architecture of your database system by taking all the elements of the database and their relationship into account. You can now get a precise big picture of how your database is structured.
This is the DSM of the default Oracle 10g database
Only with Lattix LDM for Oracle can you can formalize, communicate and control
the architecture of your Oracle database so that it remains robust and modular.
How to Evaluate
-
Evaluate Lattix LDM
for Oracle - a free 14 day evaluation licence is available
on request.
Key Features
Lattix LDM for Oracle has these unique features:
Discover and Analyse your Database System Architecture Create a Dependency Model by examining the dependencies between all objects of the database including schemas, tables, constraints, indexes, sequences, stored procedures, packages, types, java classes, synonyms etc. Create what-if and should be architectures to improve modularity and increase coupling. You can:
- Identify and group schemas for specific applications and those which provide common services.
- Identify schemas which are independent of each other.
- Layer schemas so that modularity of schemas is preserved.
- Refactor schemas which have become intertwined as a result of evolution.
- Determine how to move stored procedures and packages to enhance modularity and reduce unnecessary coupling.
Control your Architecture
Specify design rules to prevent undesirable couplings. Here are just a few things that you can do
with design rules:
- Minimise or prevent the coupling between schemas for different applications.
- Maintain the layering of schemas to prevent application schemas from mixing with schemas which provide platform data and services.
- If desired, allow data in schemas to be accessed through well defined synonyms and stored procedures.
Understand the Impact of Change
Understanding the dependencies between various elements of the database will improve your ability
to understand how change affects the rest of the system. For example, you can:
- Get a list of what is affected when you change an element of the database such as a table or stored procedure
- Determine what needs to be tested when a change is made.
- Estimate the risk and difficulty associated with a change request.
Specifications
| Lattix LDM for Oracle | |
|
Platforms
|
Windows 2000 and later, Linux, Unix |
| Input Sources | 9i or 10g database catalog |
| System Requirements |
256 MB of RAM required
1 GB of RAM for best performance working with large systems Java 1.5 or later Java Heap Size of 1GB is also recommended |
-
Evaluate Lattix LDM
for Oracle - a free 14 day evaluation licence is available
on request.
