KR100581687B1 - A unification method of Query Analyzers of database management systems - Google Patents

Abstract

The present invention relates to a method for integrating heterogeneous database management systems, wherein each server of a heterogeneous database management system is registered and processed to be displayed on a screen (S101). Create a database and process it so that it can be displayed on the screen (S102), create a table in the generated database and process it so that it can be displayed on the screen (S103), and select at least one table from the generated tables to query By creating a query or inputting a query statement in the input window to add or delete data to generate a query and output it to the screen (S104), one integrated Windows-based OS and DBMS regardless of DBMS management program enables multiple access and management of multiple heterogeneous databases. The call will be to give to establish compatibility.

Database, Management System, Query, Integration, XML

Description

A method of integrating heterogeneous database management systems and a computer-readable recording medium recording a program for executing the method.

1 is a conceptual diagram showing a heterogeneous database management system integration method according to the present invention;

2 is a block diagram showing a program for integrating heterogeneous database management systems according to the present invention;

Figure 3 is a user interface and menu configuration diagram implementing the heterogeneous database management system integration method according to the present invention,

4 is a flowchart illustrating a method for integrating heterogeneous database management systems according to the present invention;

5-29 are explanatory diagrams of a graphical user interface in accordance with the present invention.

Explanation of symbols on the main parts of the drawings

10: integrated program 20: graphical user interface

20-1: File Module 20-2: Editing Module

20-3: Query Module 20-4: Tool Module

20-5: output module 20-6: window module

20-7: Help Module 30: Database Management System

40: management server

The present invention relates to a method for integrating heterogeneous database management systems. In particular, a method for integrating heterogeneous database management systems capable of integrating data by integrating different query analyzers of heterogeneous database management systems into a single graphical user interface. It is about.

In general, databases have characteristics such as real-time accessibility, continuous evolution, concurrent sharing, content reference, etc. There is a trend to introduce a lot of management system (database management system).

Currently, representative database management systems include Oracle, Ms-SQL, MySQL, etc. In addition, there are many database systems such as DB2, Sybase, Infomix, etc. With the exception of Microsoft's SQL Server family, there are no programs based on Graphical User Interface (GUI).

The database is complete for that purpose and must be perfect in the event of any disaster or error. To this end, each company has established some rules for operating the database system. The two most important ones are the Long Distance and Difference Database.

In other words, in case of natural disasters, each database is installed far away from each other, and each database has different characteristics, so if only one database is operated, a virus or operating system and the database itself may fail. Considered. However, each database is a different OS environment (Windows, Unix, Linux), each data was incompatible with each other.

On the other hand, sgml (standard generalized markup language) is not widely used due to the complicated disadvantages of meta language or function that can define the structure of a document so that a structured electronic document can be created. The markup language was developed to solve the incompatibility of each web browser and the complexity of sgml in terms of grammar usage.However, the markup language has the advantage of simplicity and ease of use. The disadvantage is that it can't be. In other words, the html tag only focuses on the expression method such as the size and color of the text, and it is difficult to express the structure information of the document.

Therefore, the present invention has been devised to solve the above problems, and it is an integrated DBMS management program that is independent of the OS and DBMS on Windows. Its purpose is to provide a heterogeneous database management system integration method that can establish mutual compatibility between DBMSs by backing up data and exporting / importing data.

1 is a conceptual diagram of the present invention, as shown in (a), the integrated program is connected to a plurality of DBMSs to perform a function of converting data to enable direct data compatibility of each DBMS, and an extensible markup language. Data backup and compatibility of multiple DBMSs using (including Schema etc. defined for standard XML and DBMS integration) can be recovered to all other DBMSs. (C) As shown in the figure, indirect connection is possible using Microsoft Database Access Component (MDAC), Oracle Client, Oledb, ODBC, etc. of each DBMS, and it is also possible to connect directly without a component as shown in (d).

2 is a block diagram showing an integrated program for integrating and managing heterogeneous database management systems in accordance with the present invention, wherein the integrated program 10 is installed in a user's computer and includes a plurality of heterogeneous database management systems 30; It is connected to provide a graphical user interface 20 that can import and edit heterogeneous data from each management server 40 or create and export a new database.

As shown in FIG. 2, the graphical user interface 20 includes a file module 20-1, an editing module 20-2, a query module 20-3, a tool module 20-4, and an output module. 20-5, window module 20-6, and help module 20-7, each module functions as a program menu from the user's point of view, and the functions of each module are as follows. .

The file module 20-1 performs functions such as registering or deleting heterogeneous servers, modifying server information, and creating a new query.

The editing module 20-2 assists editing by performing functions such as selecting and deleting work in progress, canceling executed work, and copying and pasting an object.

As shown in FIG. 4, the query module 20-3 performs functions such as executing a query, creating / deleting a database, creating / deleting a table, commit, and rollback. To execute a query, enter a command in the query input window and click to execute the query statement and display it in the execution result window. The commit executes the execution result to be reflected in the database so that the updated contents are written to the file, and the ruleback returns to the immediately previous state and continues execution.

The tool module 20-4 can view the properties of the database server, perform a function such as exporting or importing a database, and executing a query builder.

The output module 20-5 outputs a query result in various formats (XML, EXCEL, HTML).

The window module 20-6 performs a function of displaying a tree structure window, a query window, a query result window, a table information window, and a status information window indicating information on a working query.

The help module 20-7 performs a function of providing various kinds of help.

4 is a flowchart illustrating a method for integrating a heterogeneous database management system according to the present invention. A function performed by the query analyzer integration program 10 will be described in detail with reference to the flowchart.

The query analyzer integrated program 10 according to the present invention registers each server of the heterogeneous database management system and processes them to be displayed on the screen (S101), selects one of the registered servers, and selects a database from the selected server. Create and process the output to the screen (S102), create a table in the generated database to process the output to the screen (S103), select at least one or more tables from the generated table to generate a query Input the query statement in the input window to add or delete data to generate the query and process it to be displayed on the screen.

An embodiment of performing the first procedure S101 will be described in detail.

If the user selects "Register Server" from the File menu, or right clicks at the top root of the tree structure window and selects "Register Server", the server information registration screen appears as shown in FIG.

The server information registration screen includes a selection window for selecting a type of database, a host information window for accessing a server managing a selected database, a user information window for which access is allowed, a password input window, a connection test button, and a registration button. It includes.

As shown in FIG. 7, a user may register and modify information of a previously registered database management server through a server information modification screen, and register a previously registered server on a server information deletion screen as shown in FIG. 8. You can delete it.

An embodiment of performing the second procedure S102 will be described in detail with reference to FIG. 9. You can enter the name of the database by selecting "Create Database" from the Query menu or by right clicking on the server in the tree structure pane and selecting "Create Database". Click the Excute button. This allows you to create a database folder in a subfolder of the server.

In addition, as shown in FIG. 10, the database folder can be deleted through the delete database screen.

An embodiment of performing the third procedure S103 will be described in detail with reference to FIGS. 11, 12, and 13.

A user may select "Create Table" from the query menu, and right-click the database folder and select "Create Table". The table creation screen as shown in FIG. 10 appears.

The table creation screen can select a table input screen shown in FIG. 11 and a screen for inputting a command shown in FIG. 12 as text, and the table input screen includes a name of a selected database and a list to be created. It has a window where you can enter the name of the table.

As shown in FIG. 13, a user can check a table created by selecting a name of a specific table in the tree structure window, and delete a table by selecting a specific table and right-clicking.

An embodiment of performing the fourth step S104 will be described in detail with reference to FIGS. 14-26.

In the fourth step of generating a query, one query may be generated, a plurality of queries may be generated, a select query for generating a query by selecting a specific table, and inserting data into the specific table. You can execute an insert query, an update query, and a delete query that deletes data from a specific table.

When the user selects "New Query" from the File menu or selects a server and clicks the right mouse button to select "New Query", the query window appears on the screen. Enter a query statement in the query window and select "Run Query" from the Query menu. "", The execution result window as shown in Fig. 14 appears.

The selection query selects a field from a specific table so that only the data of the field is displayed on the screen, or enters a condition in the field to output only the data that meets the condition. For example, FIG. 15 illustrates a result of executing a query statement after selecting only the country name field 'Brazil' from the 'ORDERS' table of the Oracle server.

As shown in FIG. 16, when the user inputs and inserts an insert command into the query statement input window, the execution result window as shown in FIG. 17 appears. As shown in FIG. 18, the update command is input into the query statement input window. When executed, an execution result window as shown in FIG. 19 appears, and when a delete command is input to the query statement input window as shown in FIG. 20, data in the execution result window is deleted as shown in FIG. 21. .

As shown in FIG. 22, when a user continuously inputs a plurality of commands in a query statement input window and executes the plurality of execution result windows, a plurality of execution result windows appear on one screen.

The graphical user interface 20 provides a query builder window in which a user can easily execute a selection, insertion, update, and delete query with a click of a mouse.

As shown in FIG. 23, when the selection query is selected in the query builder, a window for selecting a table and a window for selecting a column from the selected table appears.

As shown in FIGS. 24 and 25, when an insert query is selected in the query builder, a window for selecting a table and a column appears, and a window for inputting data to the selected column appears.

As shown in FIG. 26, when the delete query is selected in the query builder, a window for selecting a table to be deleted is displayed.

Metadata needed to execute the integrated program is composed or XML (extensible markup languag) is used as a query statement command in the fourth step. xml is the next generation Internet standard language proposed by the World Wide Web Consortium (w3c) in 1996 and adopted as a recommended specification for w3c in the spring of 1998. XML is designed to allow users to define their own tags related to the content of the document, to make them available to others, and to deliver structured documents on the Web, so that the independence of the elements that make up a document It ensures the compatibility of documents, independence of contents, and ease of change of elements, and it is compatible even if each application is different when exchanging documents with xml. Therefore, e-commerce, edi ( It is rapidly expanding its power to the next generation of internet languages, mainly through electronic document exchange.

The table created in the third step or the fourth step may be exported to the table information and data to the outside through the "export" menu, or imported again through the "import" menu.

That is, when the user selects the "Export" menu, a screen as shown in FIG. 27 appears, selects a specific table, converts the table information and data into XML, EXCEL, and HTML file formats, and shows the screen shown in FIG. It can be saved and exported as described above. It can be backed up, imported and exported to heterogeneous DBMS regardless of data imported from any DBMS, and can be exchanged directly.

Tables exported to each format can be viewed through a viewer that can open each format, and can be imported to a remote server through the "Import" menu as shown in Figure 29, the data imported from any DBMS It can be backed up, imported and exported to heterogeneous DBMS, and can be exchanged directly.

In particular, when the bulletin board, shopping mall, website built in Linux-based Apache, PHP, MySQL environment to move to the Windows-based IIS, ASP, NET, SQL-Server environment due to the database change, the present invention According to the Export / Import function using XML, Linux-based MySQL database is ported to Windows-based SQL Server without any effort, which means that the database administrator or developer has to deal with the MySQL database on the Linux server manually. It can be solved. In other words, data can be processed regardless of the OS and DBMS.

As described above, according to the heterogeneous database management system integration method according to the present invention,

DBMS can be managed conveniently and variously by multiple access to various databases such as Oracle, MySQL, MS-SQL etc. with a single program, and various queries can be easily executed in a graphical environment. By establishing the compatibility, it is easy to solve the problems of database conversion and backup, and the manpower problem of having a database manager for each DBMS. This can reduce the cost of maintenance, repair and management.

Claims (4)

In the data integration management method of a heterogeneous database management system that manages data by multiple access to heterogeneous database systems, A first step of registering each server of the heterogeneous database management system so that it can be displayed on a screen; A second step of selecting one of the registered servers and processing a database to be generated on the selected server and displayed on a screen; A third step of generating a table in the generated database and outputting the table to a screen; Provides query builder window to execute selection, insert, update, and delete query with the click of mouse. Simultaneously selects at least one or more tables from the created tables, or creates a query by entering a query statement in the input window. And print it to the screen, Select query step to select a field from a specific table so that only the data of the field is displayed on the screen or enter a condition in the field to output only the data that meets the condition; Insert query step of inserting data into a specific table, Update query step by executing update command in the query statement input window Delete query step to delete data in a specific table Consisting of different data types and statements by allowing individual query queries to be used through the query execution step, Inputting a plurality of query statements in the input window to generate a plurality of queries at the same time to output to the screen The fourth step consisting of; heterogeneous database management system integration method comprising a. The method of claim 1, wherein the information and data of the table generated in the third or fourth steps are converted into a plurality of file formats and exported to the outside, or an external table information and data is processed to generate a table. How to integrate heterogeneous database management system, characterized in that. The method of claim 1, comprising using extensible markup language (XML) as a query statement command in the fourth step. A computer-readable recording medium having recorded thereon a computer program for performing each of the steps as claimed in claim 1.

Images