TWI245202B - Method for obtaining and releasing database access resource in information system - Google Patents

Abstract

The present invention provides a method for obtaining and releasing database access resource in information system, which includes the following steps: providing a connection management object and a database access interface object, in which the database access interface object is able to employ the functions provided in the connection management object for obtaining and releasing the database connection; using the database access interface object for the process of obtaining and releasing the PreparedStatement and the ResultSet; and, executing the application program on the web server to inherit all the functions in the database access interface object for the operations of obtaining and releasing database access resource.

Description

1245202 V. Description of the invention (1) The technical field to which the invention belongs The present invention relates to a method for managing and controlling a database, and in particular, it relates to a method for obtaining and releasing a data library to obtain resources in an information system. Prior art

In the operation process of general information systems, most of them have the action of accessing the database. When accessing the database, you must first obtain the database connection, and use the database connection to create executable database commands. Object (such as PreparedStatement), then execute the database command object to obtain the result (Result Set), and release the related system resources previously used after access (including: connection object, command object, and result set object>. Therefore, when the information system interacts with the database, it must consume a large amount of system resources. This action often causes the bottleneck of the performance of the information system.

The practice of the conventional information system in obtaining data inventory and resources is described as follows: The first type of practice is to write the data inventory access program at the location where the data inventory access is needed. The disadvantage of this approach is that the data inventory access program will be distributed. In the entire information system, there is a lack of overall control and management mechanism. If the information system needs to change different databases, it will need to modify all the data library access programs scattered in the system, causing system maintenance troubles. The second type of approach is to use a separate subsystem to handle the acquisition and release of database connections. However, the independent subsystem can only function for database connection resources, and other resources are not controlled. This approach does not take into consideration in the process of fetching the data inventory, in addition to the connection of the database, you also need to use

Page 5 12452202 V. Description of the invention (2) Use other related system resources, such as instruction objects and data collection objects, to complete database access. The second type of practice often results in incomplete release of system resources. The lightest cause the execution performance to decline, and the worst cause the system to crash. The inventor of the present invention, in view of the lack of the above-mentioned knowledge, is desperately inventing a method for achieving overall control and complete release of access resources of all databases in an information system. SUMMARY OF THE INVENTION The object of the present invention is to provide a method for obtaining and releasing resources required to access a database in an information system. Through the operation of this method, integrated control and management can be obtained, system resources can be completely released, and the operation efficiency of the information system can be improved. The advantage of not having to change the database system and need to modify the program. In order to achieve the above-mentioned object of the present invention, the present invention provides a method for obtaining and releasing data database access resources in an information system, including the following steps: providing a connection management object and a data database access interface object, wherein the data database access interface object is capable of Use the functions provided in the connection management object to obtain and release the connection of the database (Connection), and the database access interface object is used to process the command object (PreparedStatement) and the data collection object (ResultSet) And release; make the application running on the web server use the inheritance of all the functions in the database access interface object to obtain and release the database access resources.

1245202 V. Description of the invention (3) In order to make those skilled in the art understand the purpose, features and effects of the present invention, the following specific embodiments and the accompanying drawings are used to explain the present invention in detail. After: Implementation In general, the access operation to the database in the information system can be roughly divided into data query instructions, such as se 1 ect instructions, and data update instructions, such as update, de 1 ete and other instructions. Taking the data query command as an example, a complete database retrieval operation includes at least the following five phases: Phase 1: Obtain a database connection object (Connection). Phase 2: Obtain the database command object (PreparedStatement) from the connection object ° Phase 3: Run the database command (SQL Command) in the command object and obtain the data set object (Result Set) of the execution result. Phase 4: Fetch the data in the data collection object for processing. Phase 5: Release the database access resources used in the above steps, such as releasing connection objects, command objects, and data collection objects. In an online information system, there may be tens of thousands of users using the database at the same time at the same time. Therefore, the information system must be able to effectively handle a large number of database access operations (at the same time tens of thousands of stage one to one Phase 5 actions ", a little carelessness (incomplete release of resources) can cause system resources to be exhausted, causing the system to crash. It can be seen that the design of the data library access method has a great impact on the operation of the entire information system. The operation of the present invention in cooperation with examples will be described in detail.

1245202 V. Description of the invention (4)

The first diagram shows a flowchart of the method of the present invention, and the second diagram shows a schematic diagram of an information system applying the method of the present invention. The method 10 for obtaining and releasing a data library and resource in an information system according to the present invention mainly includes steps (1 0 1) and (1 0 3), which are described in detail below respectively. Step (1 0 1) is to provide the connection management object 50 and the database access interface object 60, and the database access interface object 60 can use the functions provided in the connection management object 50 and the connection The management object 50 is used to at least obtain and release the connection to the database 30, and the database access interface object 60 is used to handle the acquisition and release of the command object (PreparedStatement) and the data collection object (ResultSet). Specifically, the main purpose of the connection management object 50 and the data library access interface object 60 is to realize the above-mentioned five stages of the data library access operation. Please refer to the connection management object and the data library access shown in the third figure. Diagram of the architecture of interface objects. In the present invention, the acquisition and release of the database 30 connection is mainly controlled by two core objects, namely, the interface object 60 and the connection management object 50 for the database. In the process of obtaining access resources to database 30, the acquisition of connection objects is one of the most important keys, because different databases A and B must use different driver modules to obtain connection objects. Once the connection object is obtained, it can be used to obtain the command object required to execute the database command. Therefore, the database access interface object 60 of the present invention provides a standard set of functions for obtaining connection resources and releasing all resources, such as releasing connection objects, command objects, and data collection objects for use by other objects of the information system. As for how to actually obtain the connection resource, it is completely handled by the connection management object 50, that is, the database

Page 8 1245202

V. Description of the invention (5) The function of obtaining and releasing the connection resources in the access interface object 60 is to call and execute the corresponding function in the connection management object 50. Through the division of labor between the connection management object 50 and the data library access interface object 60, the connection management object 50 of the present invention is responsible for the acquisition and release of the database 30 connection, and the data database access interface object 60 It is the acquisition and release of processing instruction objects and data collection objects. 7 Furthermore, because the methods of obtaining connections for different databases are different, you] As shown in the third figure, database A and database B, so you only need to swap the connection management objects when replacing the database 5 0 Yes, the rest of the information system is unaffected. In addition, other objects in the information system, such as the system application object 70 shown in the third figure, such as the system application object P and the system application object Q, need only inherit the data library to access the database 30 The interface object 60 can have all the functions of obtaining database connection and releasing system resources in the object. 'Step (103) is to make the application 2 running on the web server 20 use the way of inheriting all the functions in the database access interface object 60 to obtain and access the database 30 access resources. freed. Please refer to FIG. 4 for a specific embodiment implemented according to the third figure. In the information system, when the StudentHandler object of the application 201 needs to access the database 30, the getAllStudent () or deleteOneStudent ( ) Function, please note that these functions 'must use the database access interface object 6 〇 and other objects retrieved from the connected object such as the function of PreparedStatement and the function of Resu 1 tSet'. Therefore, [Student] A) Objects are inherited

1245202 \) / 6 / (V indicates that the five ic D (Γ tt θ 6 nt η se η e is dIe G β ud to find the stotu winter girl oo t. For example, come from es, on, can say that the te formula is The source of le is also the source of d. \ ly has C and se releases the ea and el lines. You can get η pieces of 10 in C, ct 6 An, and c η de u G t with s 1 to make I * A. But te, g's middleware energy work or middleware materials o line AD and c can get Γ take ne to Ge x) y, c is _n4T n shoulder r ne ° °; n tc when the release source — ### Pairs with the holders in the middle of the order} C order refers to η 〇 put 10ΡΟ release tn Festival C ο netl real n C oe cln except t η p eobb get things

The use of Sr, the middle piece to ce 6 rf of the middle 11 ο ο ρ η ο • 1 t C e Real, the material should be ηη on the international power set 'interactive energy use 1', eh so that Γ Xi is necessary and the use of Will return work t ο the actual release of the object line 4gc release and can be obtained from the release of the ○ item line can be achieved by the ○ PAO release in D — t ο C Mai ai i &, tt Γ ^ Π ee 6 nmne fe · en G s · plco source im use profit < all the items in the inventory difference and this B is the same as the difference in brown inventory difference in the V library. Due to the fact that the materials will be different and the materials and materials are expected to be exchanged, the standard capital needs to be more necessary to be met. If the incoming funds are to be provided, its middle protection is maintained in Xunyi Asset Management. The piece of the product won 01 full P0 on the Ming tl issue ec this η, the Co ring and change the role of not only are only the pieces, when he ¾ 实 excellent real and physical items on-line release and release and obtain the pick Line-to-face connection, material collection, storage, storage, management, library, material, line, resource, display, display, and display. And to show lines, the applied embodiment of FIG substantially solid section having five bodies. The source of the asset management system has the material information. The material is used to release the piece of the process. The wire is connected to the wire. The wire is connected to the wire. The wire is connected to the wire. ο pieces of Q η 11 · 1 ot 0 c ρ Θ η η ο η 1 ο t CC in e name η,: 0η segment

Page 10 1245202 V. Description of the invention (7) The program will be different due to the use of different databases. The reason is that different databases must use different driver modules to obtain and release the connected objects. In the sixth figure, the program fragment of the GenericDAO object to obtain the connection object and release all the resources of the system. It can be clearly seen that the function of obtaining and releasing the connection object in the GenericDAO object is actually to call C ο η necti ο η Ρ ο ο 1 corresponding function in the object, and all resources in the information system mainly include Connection,

PreparedStatement, ResultSet, etc., all resources are released in the release () function of GenericDAO. In the seventh figure, because the StudentDAO object inherits all the functions in the GenericDAO object, in the getAllStudent () function of the StudentDAO object, you can call getConnection () in the GenericDAO object to obtain the connection object, and use re 1 ease () Function to release other system resources, such as ResultSet and PreparedStatement. A specific example of the foregoing web server 20 of the present invention may be a web server (Web Server), which is connected to at least one or more client computers 40 through a network, such as the Internet. The method of the present invention 10 can be written as code and run on web server 2 0. The client computer 40 can execute the software of Browsing (Browsing) through the web server, and let the web server execute the code implementing / implementing the method 10 of the present invention to access and record at least one or more remote data 30. (Record). According to the above disclosure, the present invention can be understood, and the present invention has the following advantages: 1. Provides information system for overall control and management and complete release of data inventory for resource%

1245202 V. Description of the invention (8) point. 2. Reduce the complexity of database resource management design and production. 3 · Provide a standard access interface in the database access object to isolate the dependencies between the database access program and other objects in the system. When converting different database systems, you can change the other subsystems without changing Flexible swap database driver module. Through the above disclosure of the present invention, those skilled in the art can understand the spirit of the present invention. Generally speaking, the information system usually uses three kinds of objects in the process of accessing the database. These three kinds of objects are: connection object (Connection), command object (Statement), and result collection object (ResultSet). After the data library fetch operation is completed, the resources occupied by these three objects must be released, so that subsequent programs that need to fetch the data library can be used. The spirit of the present invention mainly uses two objects (connection management object 50 and database access interface object 60) to manage the above three resources, and it is expected to achieve a method of integrated control, easy maintenance and complete release of system resources. The present invention emphasizes again that the operation mode of the present invention mainly uses an interface object to provide a set of data library fetching functions, so that the programs that need to perform data fetching in the information system can be used by inheritance. Owns the database access function in the object). All the programs that need to access the database in the information system obtain the consistent database access methods by inheriting the object. These methods are used to access the database, and the code that actually obtains or releases the resources is uniformly distributed by Interface objects to control. Because the method of obtaining and releasing the connected object varies depending on the database used

Page 12 1245202 V. The description of the invention (9) is different. Therefore, the present invention uses another connection management object to take charge of the connection and release of different databases. The connection acquisition and release action in the interface object is actually to call the corresponding function in the connection management object. This architecture only needs to change the connection management object (or modify the connection) when the system needs to change the database. Manage the code in the object), and other programs in the entire information system do not need to be modified, so that you can achieve a method of overall control, easy maintenance, and complete release of system resources. This method can also add the function of a connection pool (Connection Pool) to the connection management object to improve the efficiency of data inventory collection.

Although the present invention has been disclosed as above with preferred embodiments, it is not intended to limit the present invention. Anyone skilled in the art can make some modifications and retouches without departing from the spirit and scope of the present invention. Retouching is still within the scope of the patent application attached to the present invention.

Page 13124520 Brief description of the diagram The first diagram shows the flowchart of the method of the present invention 0 The second diagram shows the schematic diagram of the information system applying the method of the present invention Fig. 0 The fourth diagram is a specific embodiment implemented according to the third diagram. The fifth diagram shows a specific embodiment of obtaining and releasing the connection management object. The sixth diagram shows the obtaining interface of the data library access interface object. Object and specific embodiment of releasing all resources of the information system 0 The seventh figure shows the specific embodiment of the system application object 0 Figure No. Number Description 10 Method 20 Web Server 30 Database 40 Client Computer 50 Connect 60 resources management member was taken dielectric surface material inventory system was member 70 should step 103 to step 201 with application process 101 steps formula was member

Page 14

Claims (1)

1245202 VI. Scope of Patent Application 1 · A method for obtaining and releasing data library and resource acquisition in information system, including the following steps: • Provide a connection management object and a data library access interface object, wherein the data library access interface object It can use the connection acquisition and release functions provided in the connection management object. The database access interface object is used to process the acquisition and release of the command object (PreparedStatement) and data collection object (ResultSet). The access interface object includes a set of standard database access functions, so that programs in the information system that need to access the database can use it by inheritance; • Make the application running on the web server access the database by inheriting all the functions in the database access interface object. 2. The method described in item 1 of the scope of patent application, wherein the connection management object is implemented according to the different acquisition and release of different databases. (3) As described in item 1 of the scope of patent application Method, wherein the data library takes interface objects, which are independent of the implementation instructions of the database 0 4. The method as described in item 1 of the scope of patent application, wherein the database is connected to the database via the network Web server network connection. 5. The method according to item 1 of the scope of patent application, wherein the web server is a web server (W e b Se r v e r). 6. The method according to item 1 of the scope of patent application, wherein the web server is connected to at least one client computer via a network. Page 15 1245202 6. Scope of patent application 7 · The method described in item 1 of the scope of patent application, wherein the connection management object includes at least a function of obtaining a connection object and a function of releasing a connection object. 8 · The method as described in item 1 of the scope of the patent application, wherein the inventory inventory interface object includes at least a connection object, a command object, a data collection object, a release connection object function, and a release all object Features. IH · Page 16