KR20060018781A - Mediating manage database system without kinds of dbms(database management system) connection - Google Patents

Abstract

The present invention relates to a database brokerage program that can create, access, and manage all databases in an integrated aspect regardless of the type of DBMS constituting the database. Any user can easily develop a database without studying the corresponding DBMS language. It is about a device that can be built, managed, and that supports a database's integrated interface.

The present invention overcomes developer confusion and program configuration complexity due to various DBMS interface differences that can be caused when a web service provider and a web program developer interoperate with a database, and provide a quick integrated database configuration, interface compatibility, and easy DBMS replacement. To make it possible. The advantage is that users can easily access various DBMSs through database brokers with integrated interface to handle database management tasks. In addition, the present invention provides an integrated interface to the user regardless of the type of database and the DBMS language, so that the user does not have to worry about grammatical syntax or errors while focusing on the database design.

In addition, the present invention can perform a relational database structure and interworking operations between different database systems without knowing different DBMSs and database systems.

1. DBMS 2. Database 3. DB 4. Interface 5. MySQL 6. MS-SQL 7. Oracle 8. Integration 9. System 10. Access 11. Deployment 12. Integration 13. Database Language (Query Language) 14. Schema

Description

Mediating manage database system without kinds of Database Management System (DBMS) connection}

1 is a view illustrating a method and procedure of a service provider and a developer accessing a DBMS for interworking with a database in an existing web service and a web program.

2 is a diagram illustrating a new method of integrated DBMS approach and procedure proposed by the present invention.

3 is a database access and processing flow chart of the program in technical terms for the scheme proposed by the present invention.

4 is an example table schema to be used in FIGS.

5 is an example source (PHP) that implements an existing approach to database access in web services and web programs.

6 is a class library source (PHP) of the integrated database access and management mediation system to be included in FIG.

7 is an example source (PHP) for implementing the new scheme proposed by the present invention using the class library of FIG.

The present invention relates to a database brokerage program that can create, access, and manage all databases in an integrated aspect regardless of the type of DBMS constituting the database. Any user can easily develop a database without studying the corresponding DBMS language. It is about a device that can be built, managed, and that supports a database's integrated interface.

1 is a view for explaining a linkage method between a web program and a database according to the prior art.

Hereinafter, referring to FIG. 1, a web program developer will look at a method used for interworking with a database when implementing a web program.

Recently, various DBMSs (database management systems) have been released, and there are many kinds of DBMSs in the domestic web program market. Examples of DBMSs include MySQL, MS-SQL, and Oracle, which support database construction and access in various parts, including databases and tables and fields, database schemas and logical structures, constraints, and security. However, if the existing service provider and developer 101 intends to implement database interworking in a web program (107), it is necessary to acquire an approach and management language (query language: database statement) according to the DBMS of the database when constructing the database. There was a hassle (108). In addition, the web program thus produced is optimized for one type of DBMS (109).

In addition, data preservation is difficult even when new DBMSs and upgraded versions are released, and the difference between the access interface of the existing DBMS and the new DBMS requires rewriting of the DB processing part of the program. Because many parts of the program need to be made), there are a lot of users who use old DBMS because they cannot change it. In other words, the types of DBMS are diversified, and users have to implement database through different DBMS according to program and construction environment.

For example, if you want to transfer the data from the existing DBMS 1 (106) to the new DBMS 2 (105) or DBMS 3 (104), the program configured to communicate with the interface 103 of the existing DBMS 1 , DBMS 2, DBMS 3 will have to be reconfigured to fit the interface 102. This not only causes confusion for developers, but also is the biggest obstacle to the fast processing that can be required due to the characteristics of web services.

The present invention overcomes developer confusion and program configuration complexity due to various DBMS interface differences that can be caused when a web service provider and a web program developer interoperate with a database. Makes it possible.

In other words, if you use the integrated DBMS interface, you do not have to keep in mind the differences between each DBMS, so you can focus more on program design and apply it quickly in the process of implementing it. In addition, even in the DBMS replacement, it is not necessary to greatly modify the database interworking part on the program, and it is possible to maintain the existing method. Of course, the development speed is reduced as the number of modifications is reduced.

In order to achieve the above object, the present invention provides a library source that provides a unified interface between a DBMS that operates a database, a Common Gateway Inteface (CGI) Parser, and a DBMS and a CGI source. On the surface, it consists of CGI sources that are actually loaded and executed in the browser. Here is an example using PHP and MySQL, the world's most widely used script language (Script Language).

4 is an example table to be used in the example, and the table name is " TABLE ".

In the case of Figure 5, it is a database approach in a conventional web program.

As you can see from the source, the traditional approach was to access the database directly from within the source, and the SQL query was also written and sent by the developer. In this type of database approach, if the DBMS changes, the SQL query method changes, or the database connection environment changes, manual modification of the code must be done manually throughout the source. Of course, because it is a manual process, the development speed is slowed down, and the overall structure of the program is distracted.

6 is an external library source that handles database access and allows access to the database through this program.

When creating an object, the DBMS type and the corresponding information are used as arguments. After that, the method can be accessed using the same method regardless of the DBMS type. For example, as shown in FIG. 5, an SQL query statement such as "INSERT INTO 'TABEL'…" is directly added to mysql_query (); Rather than calling and executing a function such as (in this case, changing the DBMS would require modifying the query statement and the function to be called), but $ database-> insert ("TABLE", ...); It is accessed through the method of the loaded class as follows. This method, of course, works in the same way regardless of the DBMS type, and the part that sends the SQL query by classifying the DBMS type is handled by making the class invisible.

7 is a method of processing a database by loading the above library, unlike in FIG. 5, it is possible to see a clean source configuration that is easy to see at a glance. In addition, the length of the program source code has been greatly reduced, and the only place for developers to change DBMS on these sources is the argument of the class constructor ("mysql: // root: pass @ localhost / example"). The changed settings are applied immediately, allowing for very quick replacement.

According to the present invention, a user can easily access a variety of DBMSs through a database brokerage program of an integrated interface, thereby easily handling database management tasks.

In addition, the present invention provides a single unified interface to the user regardless of the database type and DBMS language, so that the user does not have to worry about grammatical syntax or errors while focusing on the database design.

In addition, the present invention can perform a relational database structure and interworking operations between different database systems without knowing different DBMSs and database systems.

Workers' time savings, technological improvements and economic aspects cannot be said.

Claims (4)

Create a single database access library against multiple DBMSs, and get an integrated approach to it. See FIGS. 2 and 3. Interface that automatically generates and executes the appropriate SQL query statements for each DBMS to execute the database access commands received by the method. See FIGS. 3 and 6. Class based interface designed to use SQL based DBMS without SQL query. See FIGS. 6 and 7. A database data type juggling technique designed to overcome data type differences between each of the various DBMSs. By checking the value, it automatically analyzes which data type is appropriate for the DBMS type, and proposes and applies the data type of the solution. See FIGS. 6 and 7.

Images