Development Process Management
dbMaestro TeamWork™ is a Database Change Management solution. It brings the benefits of Software Change Management (SCM) methodologies to database development. These benefits include faster development, reducing development and overridden-code errors, and increasing the visibility of the database’s current status and development history to various stakeholders.
dbMaestro TeamWork for Oracle Studio Management
SCM solutions have proved to be very successful in managing native code, document versions, test scenarios and results, and other work items. The one thing these solutions have in common is that everyone (developers, testers, project managers, etc.) works on a local copy of the resource and publishes the changes only via a Check-In procedure. This is not the case when developing database code.
Database code exists in a central resource – the database. It is not pratical to duplicate the database for each developer. Therefore, the entire development team shares the same database and schema. This development configuration is dangerous. Developers and DBAs must be extra careful when making changes to avoid overridden-code errors.
TeamWork™ solves this problem by forcing developers and DBAs to Check-Out the object to be changed before changing it. During the Check-In procedure, TeamWork reads the object’s definition directly from the database’s metadata and stores the definition in a repository. This one-click Check-In procedure reliefes the developer to generate the object’s script and Check-In it manullay in the SCM tool.
TeamWork™ integrates with leading Application Lifecycle Management (ALM) solutions and enables developers and DBAs to associate changes with work items and business requirements. This allows database code changes to be grouped by work items. In addition, TeamWork™ enables DBAs to generate a database migration script for selected work items.
dbMaestro TeamWork provides the following important benefits:
- Reduces risk while developing software
- Reduces risk while performing upgrades, synchronizations and similar tasks
- Reduces the time spent on periodic administrative tasks
- Increases development staff efficiency
- Enhances QA staff capabilities
- Enhances support staff capabilities
Availability is the degree to which an application, service, or function is accessible on demand. The primary characteristics of a highly available database are reliability, recoverability, timely error detection, and continuous operation.
A highly availability database environment has the following characteristics:
- Failure tolerance enables processing to continue with little or no interruption
- System, database and data changes are transparent to the end user
- Failure prevention measures are built-in
- The database is proactively monitored and failures are detected quickly
- In the event of a failure, the system recovers very quickly
- Failure detection and recovery operations are automatic
- There is little or no data loss in the event of a failure
- The environment is managed in accordance with the best operational practices
- Service Level Agreement (SLA) goals are achieved and maintained
dbMaestro TeamWork™ helps keep your database in a state of high availability.
For information about Merge Deployment Automation using dbMaestro TeamWork™, see Merge Deployment Automation
For information about Auditing with dbMaestro TeamWork™, see Auditing
For information about Security with dbMaestro TeamWork™, see Security
