Database Query analyzer 6.03: How to Operate Domestic DM databases flexibly and quickly, db6.03

Database Query analyzer 6.03: How to Operate Domestic DM databases flexibly and quickly, db6.03
 

Database Query analyzer 6.03: How to Operate Domestic DM databases flexibly and quickly

Magenfeng

(Guangdong Union Electronic Service Co., Ltd., Guangzhou 510300, China)

 

 

SummaryThis article describes in detail how to flexibly and quickly operate domestic DM databases in the "universal database Query Analyzer", the Chinese version of "DB Query Analyzer", and the English version of "DB Query Analyzer" 6.03. In addition to creating ODBC data sources based on different database products, you can use the universal database query analyzer to operate any database, EXCEL, and TXT/CSV files in the same way as described in this document.

Starting from version 6.01, the SQL "Execution Plan" function has been added to the Chinese and English versions of the universal database query analyzer. From version 6.02, you only need to set the option "SQL Execution Plan connection Automatic Recovery" in the "tool-à option" window to "selected" status, even if the database server goes down during the "SQL Execution Plan" period, as long as the database server processes the startup status at the time of the "SQL Execution Plan, the "SQL Execution Plan" will be executed.

The universal database query analyzer in both Chinese and English versions is fully compatible with any Microsoft Windows operating system series, including Windows 10, Windows 8, Windows 7, Vista, Windows XP, Windows 2000, Windows NT, Windows ME, and Windows 98. When running on a Windows operating system, you do not need to change any operating system settings.

KeywordsDB query Analyzer and DBQuery Analyzer

 

 

1 Introduction

Ma genfeng, a local programmer in China (Interview with Ma genfeng in CSDN: A Chinese programmer who is a master of massive data processing and analysis) Released personal work ---- universal database Query Analyzer, Chinese Version DB Query Analyzer and English version DB Query Analyzer. It has powerful functions, friendly operation interface, good operability, spanning a variety of database platforms and even EXCEL and text files.

You can use it①Query ODBC data sources (including all databases, TXT/CSV files, and EXCEL files in the world.② You can execute multiple DML statements and even the storage process at the same time, and the results will be returned in the table, text box, and file you set;③When exporting tens of millions of data records from a database, the efficiency is no different from that of DBMS;④With the powerful SQL "Execution Plan" function, you only need to set the option "SQL Execution Plan connection Automatic Recovery" in the "tool-à option" window to "selected" status, even if the database server goes down during the "SQL Execution Plan" period, as long as the database server processes the startup status at the time of the "SQL Execution Plan, the "SQL Execution Plan" will be executed;⑤Version 6.03 is fully compatible with any Microsoft Windows operating system series, including Windows 10, Windows 8, Windows 7, Windows Vista, Windows 2003, Windows XP, Windows 2000, Windows NT, Windows ME, and Windows 9X, which can be run directly on Windows OS, you do not need to change any settings or configurations of any operating system.

DB query analyzer is online in Zhongguancun (Http://xiazai.zol.com.cn/detail/27/264455.shtml) Downloads exceed 0.1 million times, ranking first 10 in the entire database category ranking.

 

In the "New Product & tool comments" section of "programmer" 2007, "Special Recommendation" was edited and the "universal database query analyzer" was released.

I also wrote about the related technologies of "universal database query analyzer ".78Article, published on "computer programming skills and maintenance", "software", "Computer Age", "computer programming skills and maintenance", Baidu Library, CSDN resources, and my blog (CSDN blog, Sina Blog, QQ space, and Sohu blog ).

This document takes the Chinese version DB query analyzer 6.03 as an example to describe how to operate Chinese DM databases flexibly and quickly.

 


 

 

2 6.03 Chinese Version DB query analyzer as an Example

Next we will take the Chinese version of the "universal database query analyzer" database query analyzer 6.03 as an example to demonstrate how it operates domestic DM databases flexibly and quickly.

Operating System: Windows XP operating system

Foreground program: DB query analyzer 6.03

Background Database: Domestic DM Database)

 

Figure 1 DM database installed on windows xp 7

 

Figure 2 DM Database Service enabled on WINDOWS XP

 

 

 

 

3. Create an ODBC Data Source Based on DM Database

Figure 3 ODBC data source for creating DM databases on Windows XP (1)

 

Figure 4 ODBC data source for creating DM databases on Windows XP (2)

 

Figure 5 ODBC Data Source established on the login system pointing to DM Database

 

 

How to obtain the Chinese version of "universal database Query Analyzer" DB Query Analyzer "and the English version of" DB Query Analyzer "in" Zhongguancun online"Source installation packageFor details, see How to use the ZOL one-click installer to download the Zhongguancun online source installation package and How to downloadthe installation package by ZOL Downer.)

 

 


 

4 DB query analyzer flexible and quick operation of domestic DM database demo

4.1Quick GenerationSQLStatement

Expand the "Object Browser" of the DB query analyzer in the data table "PERSON. right-click the ADDRESS and select the type of the SQL statement to be generated from the shortcut menu to automatically generate the SQL statement in SQL editing.

 

Figure 6 use the shortcut menu on "Object Browser" to quickly generate SQL statements

 

4.2 Execute SQL statements in batches

DB query analyzer supports executing Multiple SQL statements in batches. Click "query-> Run" (you can also use the shortcut key F5) to execute the SQL script in the SQL editing box, supports the execution of Multiple SQL statements, but the SQL statements must be separated by the "separator between SQL statements" in the status bar. Shows the execution result:

 

Figure 7 Press F5 to execute multiple SQL statements in the SQL editor in batches. execution results

 

"Result N" corresponds to the record set opened for the n SQL statements. Click different Tabsheet to view the record set opened by different SQL statements.

When "result N" is selected, the "number of returned results rows" in the status bar indicates the number of records opened in the nth SQL statement. When the message is selected, the "Total number of returned results rows" in the status bar indicates the total number of records in all records in the SQL statements executed in this batch.

 

 

4.3 sort query results by specified fields

DB query analyzer allows you to sort the field in ascending order when you click a field name in the GRID result of SQL Execution. If you click the field name again, this field is sorted in descending order.

Figure 8 in result 2, click "ADDRESS1" to sort the query results.

 

However, the more records, the longer the sorting time is.

 

 

4.4 Save the execution result to a file

Before executing the command, you can click "query-> display result-> Save result to file ". Then, the "Save query result" dialog box is displayed, as shown in:

Figure 9 select Save execution result to file. After execution, enter the file name in the pop-up "Save query result"

 

Figure 10 Save the execution result to a file

 

4.5 export the query result to a file,

When outputting results in a GRID, if multiple records are generated in a batch of SQL statements, select the TabSheet to export the results, click "Save result" under "query" or click "Export result" in the toolbar to display the "Save query result" dialog box, select the path, enter the file name, and click "save" to export the query results.

 

Figure 11 click the shortcut button "Export result" to export the query results in the selected GRID

 

 

Figure 12 enter the file name in "Save query result"

 

 

Figure 13. CSV files saved in EXCEL

 

4.6 add an execution plan"

Starting from version 6.01, the SQL "Execution Plan" function has been added to the Chinese and English versions of the universal database query analyzer. From version 6.02, you only need to set the option "SQL Execution Plan connection Automatic Recovery" in the "tool-à option" window to "selected" status, even if the database server goes down during the "SQL Execution Plan" period, as long as the database server processes the startup status at the time of the "SQL Execution Plan, the "SQL Execution Plan" will be executed.

Note that if you choose to save the record set of the execution plan to a file, you must select the saved file name when adding or modifying the execution plan; if the results are displayed in tables or text, you do not need to select the saved file name when adding or modifying the execution plan.

In this example, you can choose "query"> "display result"> "Save result to file" to save the query result to a file. Then, click "query-> Execution Plan" to set the execution plan.

 

Figure 14 click "query-> Execution Plan" to open the "Execution Plan" window and set the execution time and saved files

 

Figure 15 in figure 10, click "add" to see the "Execution Plan" added in this form"

 

As long as the execution plan time is the past time, the SQL script will be executed immediately. When the "Automatic Recovery of SQL Execution Plan connections" option is selected, when the database connection is interrupted, the universal database query analyzer will restore the database connection.

Figure 16 Save the result to the specified file after the execution plan is executed at the specified time

 

Note:

The scheduling interval of the "Execution Plan" scheduler is 5 seconds, so the scheduled time is xx:Xx:01, but the execution start time is xx:Xx:01 and xx:Xx:Between 04.

 

 

 

5. I wrote 78 technical articles on "universal database query analyzer ".

 

Currently, the following six articles are published in several Chinese computer publications:

[1] Ma genfeng-DB QueryAnalyzer interrupted SQL statement execution · Hangzhou: computer age, Issue 1, 12th

[2] Ma genfeng-DB query analyzer executes DML statements in batches and returns more detailed information. · Beijing: computer programming skills and maintenance, Issue 1, 24th

[3] Application of Transaction Management in margenfeng DBQuery Analyzer in DB2 · Beijing: computer programming skills and maintenance, Issue 1, 22nd

[4] Ma genfeng-DB query analyzer interrupted SQL statement execution · Tianjin: software, Issue 1, 6th

[5] Ma genfeng · Application of Transaction Management in Oracle in universal database query analyzer · Shanghai: "micro-computer application", Issue 1, 11th

[6] margenfeng New Product & tool comments Special Recommendation: "universal database query analyzer" released · programmer, Issue 2 in 2007

 

The following 72 articles are published on Baidu Library, CSDN resources, and my blog:

Tips for using the universal database query analyzer (1) until the use of the universal database query analyzer (16) 16 articles

The 1st tip ofDB Query Analyze until 16 articles in The 16th skills of DB Query Analyzer

How to configure ODBC on the client to access a remote DB2 for Windows Server

How to configure odbc dsn in Client toaccess remote DB2 for Windows

How to configure ODBC on the server to access the local DB2 forWindows Server

How to configure odbc dsn to access localDB2 for Windows

Top software developer killer SQL statements

Which SQL statement is the trump card tothe senior software developer

DB query analyzer executes DML statements in batches and returns more detailed information

Using the universal database query analyzer to test SQLite's support for the four SQL statements

Use the Object Browser of the "DB query analyzer" to display the database data dictionary

Universal database query analyzer users have basically covered all current Database Systems

The DBMS that DB Query Analyzer Users oftenuse cover all kinds of DBMS

Functions required by the query analyzer-interrupted query execution

EXE file shelling Technology for universal database query Analyzer

Exe packer prevent DB Query Analyzer frombeging debugged

The self-developed "universal database query analyzer" has finally achieved great results.

DB Query Analyzer interrupt SQL statement execution

DB query analyzer executes DML statements in batches and returns more detailed information

Application of Transaction Management in DB Query Analyzer in DB2

DB query analyzer interrupts SQL statement execution

Application of Transaction Management in universal database query analyzer in Oracle

Special Recommendation: universal database query analyzer release

Four SQL statements that must be mastered by software developers (I)

Four SQL statements that must be mastered by software developers (II)

Four SQL statements that must be mastered by software developers (III)

Four SQL statements that must be mastered by software developers (4)

Four SQL statements that must be mastered by software developers (Comprehensive)

Summit ---- "universal database query analyzer" 5.01 released

Universal database query analyzer and EXCEL powerful combination for data analysis

DB query analyzer executes Multiple SQL statements in batches and views their respective execution times

When DB query analyzer accesses EXCEL, you must add brackets or double quotation marks before and after the table name.

The table name must be enclosed in double quotation marks or squarebracket while accessing EXCEL by DB Query Analyzer

How to Use ZOL one-click installer to download the Zhongguancun online source installation package

How to download the installation package byZOL Downer

DB query analyzer 6.03, the best database client tool on any Windows Operating System

DB Query Analyzer, the mostexcellent Universal database Access tools on any Microsoft Windows OS

DB query analyzer 6.03 installation and running demonstration on Windows 8.1

Demonstration of DB QueryAnalyzer 6.03 Installation and Running on Microsoft Windows 8

Database Query analyzer 6.03 how to operate Chinese Dream database flexibly and quickly

Database Query analyzer user manual, 56 pages in total

DB Query Analyzer specification, which has 58 pages.

 

 

 

 

 

 

DB query analyzer 6.03 Zhongguancun online:

Http://xiazai.zol.com.cn/detail/27/264455.shtml

 

 

DBQuery Analyzer 6.03 Zhongguancun online:

Http://xiazai.zol.com.cn/detail/43/420901.shtml

 

 

 

Note:

If your computer is installed with a version earlier than "universal database query analyzer", Uninstall the old version before installing the new version. Thank you!

 

 

 

Author profile:

Ma genfeng, Master, research direction: database application.

I have developed a universal database Query Analyzer. The Chinese version is DB Query Analyzer and the English version is DB Query Analyzer. It has powerful functions, friendly operation interface, good operability, spanning a variety of database platforms and even EXCEL and text files.

I have also developed a File Delete Absolutely to permanently Delete files in Windows without being recovered by other software.

These two software are free to use. They are downloaded from several major software download websites, such as Zhongguancun online, skysoftware station, huajun Software Park, Pacific computer, extraordinary software station, and green alliance.

 

 

Author's blog:

CSDN blog: http://blog.csdn.net/magenfeng

Sina Blog: http://blog.sina.com.cn/magenfeng

QQ space: http://user.qzone.qq.com/630414817