KR100303336B1 - System and method of database multi-tasking - Google Patents

Abstract

PURPOSE: A system and method for a multitasking using a database is provided to enable a plurality of clients to process a database promptly regardless of a contract condition using a client-server model based on a TCP/IP(transmission control protocol/Internet protocol) when a plurality of application programs access the database. CONSTITUTION: A database access requesting process(100) requests an access of a database. A connection with a database access interface server(202) is requested through a TCP/IP which is a data communication link. The database access interface server(202) copies itself and creates new database interface server(202). The database interface server is connected to new database interface server and waits a request from another database access process. New created database access interface server transmits a message received from the database access requesting process(100) to an internal IPC. The database access process receives contents with respect to a database access requested from the internal IPC. The database access process processes the corresponding message. The result with respect to the database access is transmitted in the reversed order.

Description

Multitasking system and method using a database {SYSTEM AND METHOD OF DATABASE MULTI-TASKING}

The present invention relates to a multi-tasking system and method using a database. In particular, an application using a modified database resource shares the resources of a database as much as possible and is not limited to the resources of the network and the database. A system and method for making a database accessible to many applications.

1 is a block diagram of a database processing method of a client-server model.

In general, a client is largely composed of an internal client and an external client.

Internal client refers to a database access application process running on a database server computer.

The external client is a database access application processor running on a different computer than the database server computer. In this case, a client-server manager process called SQL * NET is required to connect to the database server computer.

In SQL * NET, the database engine is requested from each application that needs to access the database. After accessing the database, the procedure terminates the connection with the database engine.

The internal client does not need the SQL * NET process for client-server administrators, but it also makes a request to the database engine to access the database and then terminate the connection with the database engine.

In this case, the database connects only limited resources, that is, the number of users, and delivers an error message to the excess users.

For this reason, each application that accesses the database must wait for another user, that is, another application, to terminate. In addition, you must take the time-delay required to connect and disconnect from the engine of the database server computer.

If it is not separated after connecting with the database engine, hardware resources (e.g., the number of users) corresponding to the database application should be used, which causes waste of hardware resources and database resources and decreases the processing speed of the database access application process. In the case of external clients, the SQL * NET package for the database client-server manager is always needed.

Accordingly, the present invention was devised to solve the above-described problems, which minimizes the limited resources of the database, that is, the number of users, and enables a large number of applications to process the database as soon as possible regardless of the resources of the database. By using the client-server model technique based on Transmission Control Protocol / Internet Protocol (TCP / IP), multiple clients immediately process the database without requesting contracts for internal and external clients. It is an object of the present invention to provide a multitasking system and method using a database that makes it possible.

1 is a block diagram of a database processing method of a client-server model according to the present invention.

2 is a block diagram of a database multitasking in accordance with the present invention.

3 illustrates a message format passed from a database access request process to a database interface process.

4 is a diagram illustrating a message format delivered from an database interface server to an IPC.

5 is a diagram illustrating a message format for delivering a result processed by a database access process to an internal IPC.

<Description of the symbols for the main parts of the drawings>

100: database access request process

102: TCP / IP

202: Database Interface Server Process

204: IPC

206: Database Access Process

208: Database Engine

One preferred embodiment of a multi-tasking system using a database according to the present invention created to achieve the above object is,

Database access request process;

A database interface server process; And

This includes the database access process.

In the present invention, the database access request process and the database interface server is preferably connected to TCP / IP 102,

Preferably, the database interface server and the database access process exchange data with each other through an internal IPC 204.

One preferred embodiment of a multitasking method of a database according to the present invention for achieving the above object is, in a multitasking system in which several application processors simultaneously process the same work using the same database resources,

The database access request process requesting access to the database;

Requesting a connection with a database access interface server via TCP / IP, which is a data communication link;

The database access interface server replicating itself to create a new database interface server;

The database interface server connecting with the newly created database interface server and waiting for a request from another database access process;

The newly created database access interface server transferring a message transmitted in a database access request process to an internal IPC;

The database access process may include receiving contents of a requested database access from an internal IPC;

The database access process processing the message; And

This involves passing the results of database access in reverse order.

In the present invention, the database access interface server in the process of requesting a connection with the database access interface server through the TCP / IP, it is preferable to check whether the range of the system, that is, not limited to the TCP / IP connection resources,

In the process of replicating itself to create a new database interface server, hundreds or more database interface servers may be used to simultaneously process database processing requests from hundreds or more database access request processes. Tuning-enabled parameters), preferably

Preferably, the database access process includes all processing methods for all databases required by the database access request process.

Preferably, the database access process consists of two or more,

It is preferable that the database access process always monitors whether there is a request for a database request in the internal IPC, so that the database access process, which has received the database access request message first among several database access processes, processes the message.

A preferred embodiment of the message format method for a multitasking method using a database according to the present invention for achieving the above object is a multitasking system in which several application processors simultaneously process the same work using the same database resources. In the message format passed from the database access request process to the database interface process,

Generating an opcode byte including information about a block size and information about types of operations to be processed in a database access process; And

Opcodes Next includes generating data bytes for processing in the database access process.

Another preferred embodiment of a message formatting method for a multitasking method using a database according to the present invention for achieving the above object is a multitasking system in which several application processors simultaneously perform the same work using the same database resources. In the message format delivered from the database interface server to the IPC,

Generating a destination byte fixed to a value of 1 because there is no need to select a particular process among a plurality of database access processes;

Generating a source byte indicating a PID for the database interface server process and the address to which the database access process should deliver the result after database access;

Generating an opcode byte that bypasses the opcode received from the database access request process; And

Generating the data bytes received by the database access request process.

Another preferred embodiment of the message format method for a multitasking method using a database according to the present invention for achieving the above object,

In a multitasking system where multiple application processors use the same database resources to do the same thing at the same time, the message format that delivers the results of the database access process to the internal IPC is

Generating a destination byte in which the PID of the database interface server requesting database access is recorded;

Generating an opcode byte containing information such as a length of a message, a result of a database access, and a frame type (connection, end); And

Generating the data bytes.

Hereinafter, the configuration and operation principle of the present invention with reference to the accompanying drawings in detail as follows.

2 is a block diagram of database multitasking according to the present invention.

Database multitasking includes a database access request process 100, a database interface server process 202, and a database access process 206.

The database access request process and the database interface server are connected by TCP / IP 102, which is a data communication link, and the database interface server and the database access process exchange data with each other through an internal inter process communication (IPC) 204.

When the database access request process makes an access request for a database, it requests a connection with the database access interface server through 102, which is a data communication link. At this time, the database access interface server checks whether it is not limited to the system resources, that is, the TCP / IP connection resource.

Then, he creates a new database interface server by duplicating himself, which is one of the main parts of the present invention, and generates hundreds or more (System Tunning-Able Parameter). This is possible. This means that database processing requests from hundreds or more database access request processes can be processed simultaneously.

This database interface server connects to the newly created database interface server and waits for requests from another database access process.

The newly created database access interface server will forward the message sent in the database access request to the internal IPC.

The database access process receives the contents of the requested database access from the internal IPC and delivers the results of the database access in reverse order.

The database access process is the most important part of the present invention, and includes all the database processing methods required by the database access request process, and this database access process is composed of two or more.

The database access process always monitors whether there is a request for a database request in an internal IPC, and a database access process that receives a database access request message among the plurality of database access processes processes the message.

The following is a detailed description of each part of the present invention.

When querying the contents of the database in the database access request process, the database access request process sends the range, condition, etc. of the contents to be queried, and obtains the result.

3 illustrates a message format delivered from a database access request process to a database interface process.

The first byte defined in block 300 is Opcode Byte 302.

This opcode contains information about the size of the block and the types of work to be done in the database access process.

The following are the data bytes for processing in the database access process.

The message received from the database access request process is converted into a format for communicating with the database access process in the database interface server process.

4 shows a message format delivered from the database interface server to the IPC.

The first byte defined in block 400 is the destination byte 402. This value is fixed to 1 because you do not need to select a particular process among multiple database access processes.

The following is the source byte. This is the Process Identy (PID) for the database interface server process, and represents the address to which the database access process should deliver the result after accessing the database.

The following is an opcode byte. This bypasses the opcode received from the database access request process.

The following data is received from the database access request process. Send the message to the internal IPC with the message defined as block 400 and wait to get the result.

In the database access process, as previously described, many database access processes always wait for a database connection request from this internal IPC for database access requests, and when a database access request message is obtained, the first database access process reads it. Done.

5 illustrates a message format for delivering a result processed by a database access process to an internal IPC.

The first byte defined in block 500 is the destination byte 502, which contains the PID of the database interface server that requested database access.

Next is the opcode byte 504, which contains information such as the length of the message, the result of the database access, the continuation of the frame type, and the end. The following are the data bytes.

When passed to the internal IPC in the above data format, the database interface server with the corresponding destination byte reads this message and passes it to the database access request process.

When the transfer is complete, the database interface server process terminates.

In the present invention operating as described above, the external client does not need a database SQL * NET that performs a connection role with the database server, the database can be accessed as much as the number of database interface server regardless of database resources Done.

In addition, multi-task processing allows for faster database processing and more database processing.

Claims (9)

In a multitasking system where multiple application processors use the same database resources to do the same thing at the same time, The database access request process requesting access to the database; Requesting a connection with a database access interface server via TCP / IP, which is a data communication link; The database access interface server replicating itself to create a new database interface server; The database interface server connecting with the newly created database interface server and waiting for a request from another database access process; The newly created database access interface server transferring a message transmitted in a database access request process to an internal IPC; The database access process may include receiving contents of a requested database access from an internal IPC; The database access process processing the message; And A method of multitasking using a database, the method comprising passing the results of database access in reverse order. The database access interface server of claim 1, wherein in the process of requesting a connection with the database access interface server through the TCP / IP, the database access interface server checks whether the database is not limited to resources of the system, that is, TCP / IP connection resources. Multitasking method used. The database interface server of claim 1, wherein the database interface server is capable of simultaneously processing database processing requests from hundreds or more database access request processes in the process of replicating itself to create a new database interface server. A multitasking method using a database that can be created by two or more (system tuning-enabled parameters). The multitasking method of claim 1, wherein the database access process includes all processing methods for all databases required by a database access request process. 5. The method of claim 4 wherein the database access process consists of two or more. 5. The database access process of claim 4, wherein the database access process always monitors whether there is a request for a database request in an internal IPC, so that a database access process, which has received a database access request message first among several database access processes, handles processing of the message. Multitasking method using a database. In a multitasking system where multiple application processors use the same database resources to do the same thing at the same time, the message format passed from the database access request process to the database interface process is: Generating an opcode byte including information about a block size and information about types of operations to be processed in a database access process; And Opcodes Next, a method of formatting a message for multitasking with a database, comprising generating data bytes for processing in a database access process. In a multitasking system where multiple application processors use the same database resources to do the same thing at the same time, the message format delivered by the database interface server to the IPC is: Generating a destination byte fixed to a value of 1 because there is no need to select a particular process among a plurality of database access processes; Generating a source byte indicating a PID for the database interface server process and the address to which the database access process should deliver the result after database access; Generating an opcode byte that bypasses the opcode received from the database access request process; And A method of multitasking a database, the method comprising generating data bytes received in a database access request process. In a multitasking system where multiple application processors use the same database resources to do the same thing at the same time, the message format that delivers the results of the database access process to the internal IPC is Generating a destination byte in which the PID of the database interface server requesting database access is recorded; Generating an opcode byte containing information such as a length of a message, a result of a database access, and a frame type (connection, end); And A method of multitasking a database, the method comprising generating data bytes.

Images