Difference between revisions of "Benchmark Extension Systems"

From Schema Evolution
Jump to: navigation, search
Line 10: Line 10:
 
DB2 Change Management Expert simplifies the process of managing schema changes. You can use DB2 Change Management Expert to visualize your changes before you make them.
 
DB2 Change Management Expert simplifies the process of managing schema changes. You can use DB2 Change Management Expert to visualize your changes before you make them.
 
You can use DB2 Change Management Expert to apply change commands to physical data models, which enables you to see the results of the change commands before you deploy the changes against the actual DB2 database. Applying a change command to a model is similar to issuing a command against DB2.  
 
You can use DB2 Change Management Expert to apply change commands to physical data models, which enables you to see the results of the change commands before you deploy the changes against the actual DB2 database. Applying a change command to a model is similar to issuing a command against DB2.  
 +
{| border="1"
 +
! !! Document !! Predictability !! Transformation !! Reversibility
 +
|-
 +
! Schema
 +
| Creates a historical base model || Displays related schema changes, delta DDL || Graphical || Reverse
 +
|-
 +
! Data
 +
| ? || Aggregates summary || Yes || ?
 +
|-
 +
! Query/Update
 +
| N/A || N/A || N/A || N/A
 +
|-
 +
! Other Objects
 +
| ? || database dependencies || Probably Yes || ?
 +
|}
  
 
==== Oracle Change Management Pack ====
 
==== Oracle Change Management Pack ====
 
[http://www.oracle.com/technology/products/oem/pdf/ds_change_pack.pdf Oracle Change Management Pack] introduces integrated, Web-based tools for capturing and comparing metadata definitions. These tools provide a powerful system for tracking both metadata dictionary changes within a single database and differences between databases. Existing Oracle Change Management Pack components let users carry out schema upgrades and other complex database changes effortlessly, safely, and without loss of data.
 
[http://www.oracle.com/technology/products/oem/pdf/ds_change_pack.pdf Oracle Change Management Pack] introduces integrated, Web-based tools for capturing and comparing metadata definitions. These tools provide a powerful system for tracking both metadata dictionary changes within a single database and differences between databases. Existing Oracle Change Management Pack components let users carry out schema upgrades and other complex database changes effortlessly, safely, and without loss of data.
 +
{| border="1"
 +
! !! Document !! Predictability !! Transformation !! Reversibility
 +
|-
 +
! Schema
 +
| Backing out || Yes || Graphical || Reverse
 +
|-
 +
! Data
 +
| Probably Yes || Yes || Yes || Reverse
 +
|-
 +
! Query/Update
 +
| N/A || Probably--Impact Report || N/A || N/A
 +
|-
 +
! Other Objects
 +
| ? || Probably Yes || Yes || Reverse
 +
|}
  
 
==== MySQL Workbench - Change Management ====
 
==== MySQL Workbench - Change Management ====
 
[http://www.mysql.com/products/workbench/ MySQL Workbench] enables a DBA, developer, or data architect to visually design, generate, and manage all types of databases including Web, OLTP, and data warehouse databases. It includes everything a data modeler needs for creating complex ER models, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort.
 
[http://www.mysql.com/products/workbench/ MySQL Workbench] enables a DBA, developer, or data architect to visually design, generate, and manage all types of databases including Web, OLTP, and data warehouse databases. It includes everything a data modeler needs for creating complex ER models, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort.
 
Database change management is a difficult and complex process, which involves maintaining different versions of database schemas and manually modifying existing databases. To help DBAs and developers with change management, MySQL Workbench includes Schema Synchronization and Comparison utilities. A DBA can compare two live databases or a model and a live database and visually see the differences, and also perform a synchronization between a model and a live database or vice versa.
 
Database change management is a difficult and complex process, which involves maintaining different versions of database schemas and manually modifying existing databases. To help DBAs and developers with change management, MySQL Workbench includes Schema Synchronization and Comparison utilities. A DBA can compare two live databases or a model and a live database and visually see the differences, and also perform a synchronization between a model and a live database or vice versa.
 +
{| border="1"
 +
! !! Document !! Predictability !! Transformation !! Reversibility
 +
|-
 +
! Schema
 +
| DBDoc*  || Yes || Graphical || Reverse
 +
|-
 +
! Data
 +
| DBDoc*  || Yes || Yes || Reverse
 +
|-
 +
! Query/Update
 +
| N/A || N/A || N/A || N/A
 +
|-
 +
! Other Objects
 +
| Probably DBDoc*  || Yes || Yes || Reverse
 +
|}
 +
* DBDoc is available only on commercial version.
 +
 +
==== IDERA SQL Change Manager ====
 +
[http://www.idera.com/products/sqlchange/ IDERA SQL Change Manager] is a powerful solution for simplifying and automating change management for Microsoft SQL Server databases. SQL change manager streamlines database change management procedures by capturing periodic database schema snapshots, highlighting changes from a baseline, and enabling easy roll-back, roll-out and recovery of lost or damaged database objects. Designed to meet the needs of enterprise-scale SQL Server implementations, SQL change manager easily scales to monitor and automate schema changes in environments of any size.
 +
{| border="1"
 +
! !! Document !! Predictability !! Transformation !! Reversibility
 +
|-
 +
! Schema
 +
| Version Control || Yes || Graphical || Rollback
 +
|-
 +
! Data
 +
| Version Control || Yes || Yes || Rollback
 +
|-
 +
! Query/Update
 +
| N/A || N/A || N/A || N/A
 +
|-
 +
! Other Objects
 +
| Version Control || Yes || Yes || Rollback
 +
|}
 +
 +
==== Embarcardero Change Manager ====
 +
[http://www.embarcadero.com/products/changemanager/ Embarcardero Change Manager] offers database administrators and developers a powerful set of tools to simplify and automate the database change management lifecycle. Change Manager's schema compare and alter, data compare and synchronization, and configuration auditing capabilities report on database changes, roll out new releases, and pinpoint database performance problems that result from both planned and unplanned changes.
 +
{| border="1"
 +
! !! Document !! Predictability !! Transformation !! Reversibility
 +
|-
 +
! Schema
 +
| record of database schema || Yes || Yes || ?
 +
|-
 +
! Data
 +
| ? || Probably Yes || Probably Yes || ?
 +
|-
 +
! Query/Update
 +
| N/A || N/A || N/A || N/A
 +
|-
 +
! Other Objects
 +
| ? || Probably Yes || Probably Yes || ?
 +
|}
  
 
==== SwisSQL ====
 
==== SwisSQL ====
 +
 +
==== ====
 +
  
 
=== Academic ===
 
=== Academic ===
 
{| border="1"
 
{| border="1"
−
|+ Evaluate System
+
! !! Document !! Predictability !! Transformation !! Reversibility
−
! !! Document !! Predictability !! Transformation !! Reversability
+
 
|-
 
|-
 
! Schema
 
! Schema
−
| Cell 1 || Cell 2 || Cell 3 || Cell 4
+
| || || ||  
 
|-
 
|-
 
! Data
 
! Data
−
| Cell A || Cell B || Cell C || Cell D
+
| || || ||  
−
|-
+
−
! Query
+
−
| Cell A || Cell B || Cell C || Cell D
+
 
|-
 
|-
−
! Update
+
! Query/Update
−
| Cell A || Cell B || Cell C || Cell D
+
| || || ||  
 
|-
 
|-
 
! Other Objects
 
! Other Objects
−
| Cell A || Cell B || Cell C || Cell D
+
| || || ||  
 
|}
 
|}

Revision as of 08:53, 23 October 2008

This page shows several Schema Evolution Systems. If you are looking for real schema evolving data, then click Benchmark Extension Datasets.

Contents

Schema Evolution Systems

Open Source

Industrial

DB2® Change Management Expert

DB2 Change Management Expert is a powerful and flexible tool that simplifies the process of identifying, analyzing, and implementing database schema changes for DB2 UDB for Linux®, UNIX, and Windows®. DB2 Change Management Expert simplifies the process of managing schema changes. You can use DB2 Change Management Expert to visualize your changes before you make them. You can use DB2 Change Management Expert to apply change commands to physical data models, which enables you to see the results of the change commands before you deploy the changes against the actual DB2 database. Applying a change command to a model is similar to issuing a command against DB2.

Document Predictability Transformation Reversibility
Schema Creates a historical base model Displays related schema changes, delta DDL Graphical Reverse
Data  ? Aggregates summary Yes  ?
Query/Update N/A N/A N/A N/A
Other Objects  ? database dependencies Probably Yes  ?

Oracle Change Management Pack

Oracle Change Management Pack introduces integrated, Web-based tools for capturing and comparing metadata definitions. These tools provide a powerful system for tracking both metadata dictionary changes within a single database and differences between databases. Existing Oracle Change Management Pack components let users carry out schema upgrades and other complex database changes effortlessly, safely, and without loss of data.

Document Predictability Transformation Reversibility
Schema Backing out Yes Graphical Reverse
Data Probably Yes Yes Yes Reverse
Query/Update N/A Probably--Impact Report N/A N/A
Other Objects  ? Probably Yes Yes Reverse

MySQL Workbench - Change Management

MySQL Workbench enables a DBA, developer, or data architect to visually design, generate, and manage all types of databases including Web, OLTP, and data warehouse databases. It includes everything a data modeler needs for creating complex ER models, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort. Database change management is a difficult and complex process, which involves maintaining different versions of database schemas and manually modifying existing databases. To help DBAs and developers with change management, MySQL Workbench includes Schema Synchronization and Comparison utilities. A DBA can compare two live databases or a model and a live database and visually see the differences, and also perform a synchronization between a model and a live database or vice versa.

Document Predictability Transformation Reversibility
Schema DBDoc* Yes Graphical Reverse
Data DBDoc* Yes Yes Reverse
Query/Update N/A N/A N/A N/A
Other Objects Probably DBDoc* Yes Yes Reverse
  • DBDoc is available only on commercial version.

IDERA SQL Change Manager

IDERA SQL Change Manager is a powerful solution for simplifying and automating change management for Microsoft SQL Server databases. SQL change manager streamlines database change management procedures by capturing periodic database schema snapshots, highlighting changes from a baseline, and enabling easy roll-back, roll-out and recovery of lost or damaged database objects. Designed to meet the needs of enterprise-scale SQL Server implementations, SQL change manager easily scales to monitor and automate schema changes in environments of any size.

Document Predictability Transformation Reversibility
Schema Version Control Yes Graphical Rollback
Data Version Control Yes Yes Rollback
Query/Update N/A N/A N/A N/A
Other Objects Version Control Yes Yes Rollback

Embarcardero Change Manager

Embarcardero Change Manager offers database administrators and developers a powerful set of tools to simplify and automate the database change management lifecycle. Change Manager's schema compare and alter, data compare and synchronization, and configuration auditing capabilities report on database changes, roll out new releases, and pinpoint database performance problems that result from both planned and unplanned changes.

Document Predictability Transformation Reversibility
Schema record of database schema Yes Yes  ?
Data  ? Probably Yes Probably Yes  ?
Query/Update N/A N/A N/A N/A
Other Objects  ? Probably Yes Probably Yes  ?

SwisSQL

Academic

Document Predictability Transformation Reversibility
Schema
Data
Query/Update
Other Objects
Retrieved from "http://yellowstone.cs.ucla.edu/schema-evolution/index.php?title=Benchmark_Extension_Systems&oldid=450"
Personal tools