Database Administration Jump-Start Package
Database Administration
All relational database management systems (RDBMS) require administration whether supporting applications, data warehouses, or software products. Database administration is a form of development and should follow the organizations software development lifecycle (SDLC).
The CA ERwin® Data Modeler (ERwin) product is ideal for performing centralized database administration. This is because the software supports the capability to reverse engineer databases into physical models within the software. Changes are then made to the physical model and can be implemented against the target RDBMS. These changes can be tracked if the physical model is stored in the CA ERwin® Model Manager (Model Manager) software. The versioning capability of this product allows for changes to be tracked and backed out if necessary.
Jump-Start Package
The Data Innovations’ database administration jump-start package establishes the environment to support database administration at an enterprise level. The following sections identify what is included in the package:
Requirements:
The database administration package will require the following:
- A minimum purchase of five CA ERwin® Data Modeler licenses.
- A minimum purchase of five CA ERwin® Model Manager licenses.
- A minimum of 80 hours of consulting services.
These requirements allow Data Innovations to provide discounts for both software licenses and professional services.
Product Installation:
The ERwin and Model Manager software will need to be installed. The following bullets identify the components of this service:
- A custom installation plan for ERwin and Model Manager is created.
- Perform the product installations and create detailed installation procedures for both products.
- Install the license files.
- Establish the Model Manager environment:
- Create the security groups.
- Define the libraries to store models.
- Define the security for each library.
- Establish user access for the RDBMS and Model Manager.
- Create the change management policy.
- Establish connectivity to the ERwin client.
- Create step-by-step administration procedures.
Establish Best Practices:
Once the environment is established, best practices are defined to ensure proper utilization and to enforce the change management policy. The following bullets identify the components of this service:
- Establish database administration standards.
- Determine RDBMS standards for database administration.
- Define the physical model requirements.
- Define the change management policy.
- Identify the administrators to add to the user groups.
- Create a document identifying the database administrator’s best practices.
- Populate libraries.
- Identify the databases to be administered using ERwin.
- Reverse engineer the databases into physical models.
- Store the physical models in the libraries.
- Identify mission critical databases and evaluate the level of metadata.
- Apply requirements from DBA best practices to the mission critical physical models.
Deliverables:
The following bullets identify the primary deliverables of this package:
- Change Management Policy. A document is created that identifies the change management policy and how it is integrated into the organization’s existing SDLC.
- Change Management Environment. The Model Manager software is installed and configured to support the SDLC and the change management policy. A document is created that identifies step-by-step installation instructions.
- User Groups. The user groups are defined and populated to support the model SDLC and change management policy. A document is created that identifies the user groups, roles and responsibilities of group members, and examples of typical users.
- Libraries. The libraries are created to support the new model SDLC and change management policy. A document is created that identifies the library structure within the Model Manager repository.
- User Guide. This document identifies the change management policy, environment, users, and a step-by-step user guide.
