The new CUBRID Manager & Query Browser v2013.05 are here!
The new CUBRID Manager & Query Browser v2013.05 are here!
Join the DZone community and get the full member experience.Join For Free
Download "Why Your MySQL Needs Redis" and discover how to extend your current MySQL or relational database to a Redis database.
Along with the latest CUBRID Migration Toolkit release we are now announcing new 2013.05 versions (build 0120) of CUBRID Manager and CUBRID Query Browser tools which allow users to administer their CUBRID Database Servers and execute queries in a friendly desktop GUI application.
You can download CM and CQB by following these links:
- CM: http://www.cubrid.org/?mid=downloads&item=cubrid_manager&os=detect&cubrid=any
- CQB: http://www.cubrid.org/?mid=downloads&item=cubrid_query_browser&os=detect&cubrid=any
As CQB is a subset of CM tool, the key features of this release is the same for both. They are:
- All versions of CUBRID Server since 8.2.2 are supported.
- Improved Query Tuning Mode feature: allows users to see the results of query tuning and compare the before/after results of query statistics and execution plan.
- Improved results output when concurrently executing queries: allows to compare the output results (data/columns/records) by applying different colors.
- Added search functionality to query results: now users can search within the results set in the Results Tab.
- Improved Import Wizard: added support to export the failed data and display the error message for each failed query.
A number of bugs have also been fixed in this release. For full list of changes, refer to CUBRID Manager Release Notes.
How to upgrade
Users of CM/CQB version 1.2 and above will be automatically notified about the new updates via the built-in update feature. Users of older versions need to manually uninstall the existing version of CM or CQB, then download and install the latest version from the links provided above.
CUBRID Server compatibility
CUBRID Server version 8.2.2+ are supported. When establishing a connection with CUBRID Server, users can indicate the version of a server. CM and CQB usually will automatically detect the Server version.
CM and CQB tools require JRE 1.6 or later.
Feature Walkthrough with Screenshots
Query Tuning Mode
The Tuning Mode is designed to allow users to compare the statistics and execution plan of two queries side by side. Sometimes you want to tweak the query and see how it compares to its original version. You want to see the differences between the number of fetched results, the number of dirty pages created, whether or not I/O reads and writes occur, and finally the total cost of executing the queries. These are the features you can obtain via the Tuning Mode.
To enable the Tuning Mode, toggle on the Tuning Mode button as shown in the Figure 1 below. When the Tuning Mode is enabled, CM/CQB will notify you that the tuning mode has been started. However, nothing else special happens at this moment.
Figure 1: Enable Tuning Mode.
Once you execute a query in tuning mode, a new window will popup (Figure 2 below) which will display the statistics and execution plan cache for this query on the left panel.
Figure 2: Tuning Mode window (click to enlarge).
To run the second query and compare its results on the right panel, you need to check "Display on the right panel (R)" checkbox as shown below in Figure 3.
Figure 3: Change the panel to run the second query.
Once the right side is checked, run the modified version of the original query. The right side of the Tuning Mode window will auto udpate and display the statistics and execution plan (Figure 4).
Figure 4: Compare two queries in Tuning Mode.
This is one of the great features we are very excited about in this new release.
Multple SQL execution on multiple databases in parallel
CM and CQB allow to execute multiple queries at once not only on a single connected database, but also on multiple databases. Image you want to query a master and one or more of the slave nodes to check if the data on the selected nodes are identical, or you want to query the production server and compare it against the stage server, or during the migration you want to query the destination database and compare the results with those of the source database. Concurrent SQL execution on multiple databases is a really useful feature to accomplish all these tasks.
In this release we have improved how results are displayed when executing multiple queries on multiple databases. You can now compare the results of executed queries side by side in a convenient popup window (Figure 5).
Figure 5: Comparison of the results of multiple queries.
Search within the Results Set
Since this new release CM and CQB provide a search functionality in the Results Tab (Figure 6). This allows users to filter the fetched result set in real time while the matched column values get highlighted.
Figure 6: Search within Results Set.
Improved Import Wizard
In CM and CQB users can import data into a database from various sources (SQL/TXT/CSV/XLS). All import operations are logged and kept in the import history so that users can rerun them again if necessary (Figure 7).
Figure 7: Import Wizard.
In this new release we have added a new feature which will export a list of erroneous queries into an external SQL file (Figure 8). If an error occurs while importing the data, you can click on "Browse error log..." button which will navigate you to a file where all problematic queries are logged.
Figure 8: Browse error logs.
Alternatively, you can double click on the import row (highlighted in red upon failure), and a popup window will appear where you can see a list of failed queries along with an error message for each query (Figure 9).
Figure 9: View failed queries.
This is a list of prominent features we wanted to share with you today. There are many more improvements (36 improvements, 66 bug fixes) we have made in this release. Refer to CUBRID Manager Release Notes to see the full list.
If you have any comments or questions, there is a comment form below. We always look forward to receiving a feedback.
Published at DZone with permission of Esen Sagynov , DZone MVB. See the original article here.
Opinions expressed by DZone contributors are their own.