DB PowerStudio DBA Edition - Multiplatform 关于

数据库管理专业人员的多数据库工具集。

DB PowerStudio is an intuitive toolset that includes visual SQL optimization and tuning. It comes complete with support for all popular DBMS's, including Oracle, SQL Server, Sybase ASE and DB2. DB PowerStudio is the latest suite in a line of award-winning database tools for DBAs and database developers. DB PowerStudio simplifies daily administration, manages changes, tunes queries, and develops schemas for multiple relational database platforms.

DB PowerStudio Features

  • Connect to multiple, heterogeneous databases with no client required.
  • Automated SQL rewrites to quickly optimize queries.
  • Full-featured visual SQL tuning capabilities from inside the SQL editor.

Fast, Accurate, SQL Code with Rapid SQL
The rich visual environment found in Rapid SQL streamlines the task of creating SQL code. Rapid SQL includes visual tools for ad-hoc data editing and simple-to-complex query building. Prevent errors with scripting support features such as syntax checking and auto-complete. Quickly produce code with built-in hot keys, column lookup and code templates.

  • Support for all seven database platforms included in a single, affordable license.
  • Go global with full Unicode character and enhanced currency support.
  • Object filtering capabilities.
  • On-the-fly SQL syntax alerts, semantic validation, and SQL parsing.
  • Full object look-up through-out the SQL statement.
  • Code complete with dynamic walk-throughs.
  • Quick export and import of registered data source information.

Fast, Visual SQL Tuning with DB Optimizer
DB Optimizer takes SQL tuning beyond standard hint injections and SQL rewrites and offers innovative features for faster and more advanced SQL tuning and analysis. Graphical tools, like the Index Analysis feature, let DBAs and developers fully examine SQL execution paths to better understand which indexes are used, not used, or missing

  • Stream profiling data into a central repository.
  • Determine resource usage for stored procedures with visibility into underlying SQL usage for SQL Server and Sybase.
  • Visual SQL tuning diagram displaying indexes and constraints, now enhanced with table statistics.

Database Change Management Made Simple
DB Change Manager compare, synchronization and auditing capabilities let you track and report on changes, roll out new releases and pinpoint performance problems resulting from changes in data, schema and database configuration. By comparing a live database to a schema or configuration snapshot administrators can quickly identify changes and correct problems.

  • Work with multiple database brands and versions from a single toolset.
  • Compare your development and test servers to quickly identify changes and generate the synch scripts to correct any problems.
  • Mask test data in order to comply with privacy laws.

DB PowerStudio Product Editions

Developer Edition - Designed for Database Developers or Project DBAs in need of capabilities to monitor and manage database processes and to set up database work environments. The Developer Edition includes:

  • DB Optimizer - Visually profile key metrics inside the database and optimize SQL using the Visual SQL Tuner.
  • DB Change Manager - Simplify, automate, and report on database changes.
  • Rapid SQL - Quickly write quality SQL

DBA Edition - Designed for Production or Operational DBAs for robust management of their database environments. The DBA Edition includes:

  • DBArtisan Workbench - Database administration tool with advanced Performance, Space and Capacity Analysts.
  • DB Optimizer - Visually profile key metrics inside the database and optimize SQL using the Visual SQL Tuner.
  • DB Change Manager - Simplify, automate, and report on database changes.
  • Rapid SQL - Quickly write quality SQL

The Analyst Pack provides insight into current database health, and also where each database is heading in the future:

  • The Space Analyst provides analysis of database space information to pinpoint space-related exceptions and provides assistance in diagnosing and reorganizing storage inefficiencies using an intelligent reorganization wizard.
  • The Performance Analyst provides intelligent analysis of real-time database and OS performance diagnostic information to troubleshoot and remedy performance problems.
  • The Capacity Analyst collects and stores key database metadata and performance metrics and performs trend analysis to forecast database growth and usage.