Embarcadero DB PowerStudio

The Embarcadero company released two powerful products of the Embarcadero DB PowerStudio series for integrated management of database servers under control of the systems of Oracle and the MS SQL Server. Both new products represent set of popular utilities of Embarcadero for work with a DB. Difference of packets of Embarcadero DB PowerStudio for Oracle and SQL Server is the price – upon purchase of the DB PowerStudio set the customer significantly saves in comparison with acquisition of the applications entering them separately.

Packets of DB PowerStudio are issued in two editions: Developer Edition (for developers) and DBA Edition (for database administrators). A basis of packets of DB PowerStudio is set of three main utilities: Rapid SQL, Change Manager and DB Optimizer. Editions DBA Edition differ from editions for developers in the fact that the DB Optimizer utility in them is replaced with the corporate DB Artisan program.

The Rapid SQL utility represents integrated development environment which helps to write SQL scripts, to build SQL queries, to manage objects of a DB and to control versions of the code in working DB and autonomous code repositories.

The module Change Manager is a powerful utility for change tracking in databases which also helps to upgrade DBMS to new versions and to reveal the prime causes of problems with performance arising because of changes in contents, the scheme and the DB configuration. Also the module Change Manager allows to test data which need to be masked for observance of a normative access mode to information.

The module DB Optimizer is a graphic utility for optimization of SQL queries; it helps users to detect, diagnose and correct quickly badly working SQL code using the interactive master of Visual SQL Tuner.

The module DBArtisan offered in editions DBA Edition is the utility focused on professional database administrators. Using this utility the administrator can work from several DB at once, including with different versions of the same DB, from the single interface. The packet of DBArtisan contains at once several graphics editors and masters who automate routine transactions and reduce number of errors because of a human factor. Also the packet of DB Artisan helps to reveal problems with performance, capacity and information storage before they influence work of the enterprise.

DB PowerStudio packet for Oracle serves as useful addition to opportunities of the corporate console of the administrator of Oracle Enterprise Manager, offering own utilities. All components of this packet can work with different versions of Oracle DBMS from the single interface.

DB PowerStudio packet for SQL Server supplements functions of the corporate Microsoft SQL Server Management Studio (SSMS) tools, but, unlike SSMS and many other tools, the DB PowerStudio components work with several versions of SQL Server DBMS from one window at once that facilitates work in large-scale environments. Besides, the structure of a packet of DB PowerStudio for SQL Server includes unique Embarcadero ToolCloud technology. The ToolCloud technology provides instant access for users to the DB PowerStudio interface from any Windows machine without installation of a packet on a local system. Also DB PowerStudio for SQL Server helps the large organizations to monitor use of licenses to minimize licensing costs and to achieve the maximum productivity of users.

Embarcadero DB PowerStudio XE3.5

The Embarcadero Technologies company, the supplier of software solutions for application development and databases, announced in March, 2013 release of Embarcadero DB PowerStudio XE3.5 — the newest version of the platform for management and development of databases. DB PowerStudio XE3.5 is a key component of the new Embarcadero platform for management of metadata (Metadata Govenance) which allows the organizations to use different data in process of management of information and at all development stages of the software that, in turn, promotes successful implementation of initiatives of corporate management by data.

So, DB PowerStudio XE3.5 allows administrators and developers of databases to work according to corporate politicians and initiatives of data management. The solution includes the following components: DBArtisan — ensures smooth operation and availability of the database and also increases its performance; Rapid SQ — provides access to all data, is platform-independent and also optimizes the SQL code and performance of databases and applications; DB Optimizer — provides performance, smooth operation and availability of databases and applications; DB Change Manager — helps to audit and make reports on compliance to politicians, protects confidentiality of private data, reduces organizational risks and automatically synchronizes data schemes.

"When developing strategy of management of corporate data the opinion of database managers very often is not considered, but in reality they play an important role, as well as everyone who directly interacts with data — Michael Swindell, the senior vice president of Embarcadero company for products noted. — DB PowerStudio XE3.5 gives additional opportunities for database managers and specialists with data, providing efficiency of workflows and also coordination and integrity of data in systems with difficult politicians in the field of data, working 'from one window'".

According to developers, the platform for management of metadata of Embarcadero has key value for successful interaction with data for IT specialists and business users as allows to see all picture of the data assets which are both on servers of divisions and in "cloud" or a central mass storage of a system. Still this process was for the companies extremely difficult, fragmented and expensive, specified in Embarcadero.

All solutions Embarcadero are directed to support of management and provide shared access to metadata and also control and enhanced capabilities both at a business planning stage, and at all development stages of the software, underlined in the company. In particular, the solution DB PowerStudio XE3.5 is intended for work with several platforms of databases and allows to unify tasks of data management, supporting high performance and, at the same time, remaining in the range of low costs. This set of means supplements the management tools which are built in different DBMS and allows to unify processes of administration, development, diagnostics and debugging of performance in interaction of several platforms that increases efficiency and improves availability of databases, claim in the company.

The solutions Embarcadero Metadata Governance are now proposed as a part of current versions of products of the company. DB PowerStudio XE3.5 can be purchased through partners of Embarcadero.

2015: DB PowerStudio 2016

On September 22, 2015 Embarcadero Technologies provided DB PowerStudio 2016 – a complex product from the tools for work with databases intended for database administrators (DBA) and specialists in the field of data.

The product gives the exhausting opportunities for administration, development, optimization and monitoring of databases on the DBMS different platforms that allows to improve productivity of work, to raise performance of databases and to provide the best data availability. DB PowerStudio 2016 gives new opportunities of 24/7 performance review and is completely integrated with DB Team Server - professional solution for team work of specialists in databases, having the general repositories, statistics of a status, a handshaking and cooperation between employees or roles.

Are a part of DB PowerStudio 2016:

• DBArtisan 2016 is the cross-platform solution for administration, monitoring and optimization of databases;
• Rapid SQL 2016 is the "smart" environment for work with SQL which facilitates to developers and database administrators creation of the effective SQL code for any supported platforms of DBMS, using the single interface. The new Performance IQ expansion adds for an ability to manage performance as for DBArtisan 2016, and Rapid SQL 2016.

Specialists have opportunities of active management and fast detection of "bottlenecks" on the basis of the deep analysis of indicators now.

Technology of optimization of SQL for management of high-performance databases

Available as addition to DBArtisan 2016 and Rapid SQL 2016, Performance IQ monitors each copy of a 24/7 DB, defines the reasons of falling of performance and visually displays the initial reason for all major components of performance DBMS. As a part of opportunities:

• Deeper analysis of a DB: Influence of the main SQL queries on the general I/O, chronology of growth of tables and indexes and influence of surrounding loading allows users to reveal the built-in metrics of performance and the analyst quickly, saving huge amount of time.

• Analysis of SQL: The editor of SQL shows how this SQL was expedited in different options and why there was a difference in speed; continuously provides the tooltip balloons SQL (Performance IQ is supported), warning users as the power of a column or distribution of data can affect high-speed performance of the SQL query; offers new indexes if high-speed performance of this SQL improves thanks to their adding.

• 24/7 monitoring of waiting times and notification: New, based on monitoring of 24/7 waiting times, analysts help database administrators to understand quickly and to manage actively the environment of work of DBMS. The chronological analysis ("Time travel") allows users to open quickly last cases and it is better to understand deviations from standard indicators. The notifications configured by users provide protection against surprises.

The centralized administration of a DB, cooperation and notifications

As a part of DB PowerStudio 2016 the platform of interaction for DBA - DB Team Server, it provides real idea of corporate environment of databases for management and the analysis of corporate data assets.

DB Team Server provides base for monitoring and notifications about events which improve response of a system using direct availability analysis, performance and resources. The simplified interaction and access to different general repositories, such as general descriptions of data sources, the main metrics of a status and passwords, improves dissemination of information, including, about specialized scripts, notes and discussion of subjects in the company.

DB Optimizer 2016 is the instrument of profiling and optimization of SQL for performance improvement and also DB Change Manager 2016 is the complex instrument of synchronization of schemes and data, also enter this release of DB PowerStudio 2016.

Availability

DBArtisan 2016 Rapid SQL 2016, DB Optimizer 2016, and Change Manager 2016 are available to acquisition at Embarcadero. Performance IQ is available as addition to DBArtisan 2016 or Rapid SQL 2016. Free trial versions can be loaded on the website of vendor.