KR20010063059A - Method for optimizing database search operation - Google Patents

Abstract

PURPOSE: The method for optimizing the DB search is provided to run the fast and efficient DB search about a log message stored in the DB and to minimize the overuse of a resource of the DB by optimizing the type of the data. CONSTITUTION: Among the search data of a log browser, the date data is the "date-time year to second" type, and the management module and action-form are the integer type, and the action and user data are the character type. On a screen structure of the log browser, the "User ID" part selects and checks the desired user, and the "Module" part checks every management modules(for example, AM, SM, MM), and the "Action" part checks every management operation(for example, TRANSMIT, ADD). Additionally, the "year", "month", "day", "hour", "min", and "sec" check as the desired time.

Description

How to optimize database search {METHOD FOR OPTIMIZING DATABASE SEARCH OPERATION}

The present invention relates to a system for database services, and more particularly to a method for optimizing database search.

Today's society continues to move forward with the development of information technology to make a better future society. This is a common phenomenon in the world, which means that major revolutions are occurring in all areas. As the economic structure changes, technology development becomes important, which has led to the development and expansion of computer technology, the utilization of DBMS, and the rapid development of information and communication network. These three fields continue to develop as a complex relationship, and thanks to these technological trends, the importance of information management has begun to emerge from companies, and important databases using various DBMSs (Data Base Management System) are being built and operated. . In-house (in-house) databases for Korean companies are making significant progress, such as building and operating a database using a DBMS suitable for the company's characteristics, from personal computers to large computers.

In such a database management system, an example of a table structure for retrieving log data of a conventional network management system is as follows, and the screen configuration of the log browser is as shown in FIG.

Column name Type Nulls logdate char (15) no loguser char (10) no mgmttype char (3) yes actype char (9) yes action char (128) yes

As shown in FIG. 1, the search type of the log browser includes a date, a management type (Mgmt Type), an action, a user, and the like. The data of the search type is stored in a text form in a database. . That is, date data is stored in an array of 15 bytes. For example, "1999-12-25 22:10:23". The management type data is stored in the form of characters such as "AM" and "SM", and the action data is also stored in the form of characters such as "TRANSMIT" and "ADD".

As described above, the prior art consumes a lot of system resources and requires a lot of time for access because the search type information stored in the database is stored and fetched in text form.

Accordingly, an object of the present invention is to provide a method for performing a fast and efficient database search for log messages stored in a database.

Another object of the present invention is to provide a method for minimizing the excessive use of resources by the database by optimizing the type of data stored in the database.

In accordance with the above object, the present invention is a database search optimization method in a database management system, the date data of the search type data of the log browser to the "datetime year to second" type, the management module and the action type data is integer As a type, the action and user data are configured to be a character type, and the database is searched using the configured log browser.

1 is a log browser screen configuration according to the prior art,

2 shows a log browser and a database;

3 is a log browser screen configuration according to an embodiment of the present invention.

Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings.

Traditional log browsers required a lot of resources for database processing by storing all messages in text form in the database. Even when fetching to retrieve such database data, all of them searched and displayed the character data, which required a lot of time and required a lot of system resources. Therefore, in order to solve this problem, the embodiment of the present invention optimizes the type of data stored in the database to minimize the excessive use of resources by the database.

2 shows a log browser 10 and a database 20. In an embodiment of the present invention, the log browser 10 is searched to optimize the type of data stored in the database 20. In FIG. Change the type as follows.

First, change the date to the "datetime year to second" type. The management module changes to an integer type, for example, a "smallint" type. The actiontype is also changed to an integer type, for example the "smallint" type.

An example of a table structure for searching a database according to an embodiment of the present invention is as follows, and the screen configuration of the log browser 10 is as shown in FIG.

Column name Type Nulls logdate datatime year to second no loguser char (10) yes mgmttype smallint no actype smallint no action char (128) yes

Referring first to the above table structure, the date data (logdate) of the search type data of the log browser 10 according to an embodiment of the present invention is a "datetime year to second" type, and management module data (mgttype) and action. The type data (actype) is an integer type, and the action data (action) and user data (loguser) are configured to be character types, that is, char (128) and char (10).

By changing the date data (logdate) of the search type data of the log browser 10 to the "datetime year to second" type, the efficiency of the search and the DB space usage of the log browser 10 is increased. In addition, as the management module data (mgttype) and action type data (actype) are stored in the database 20 as an integer type according to an embodiment of the present invention, a log browser may be used to fetch data from the database 20. (10) interprets, classifies and displays the management module data (mgttype) and action type data (actype).

The screen configuration of the log browser 10 according to an exemplary embodiment of the present invention including the search type data as described above is the same as that of FIG. 3. Referring to FIG. 3, the "User ID" portion can be searched by selecting a desired user. The "Module" part enables searching by management module (e.g., denoted by AM, SM, MM, etc.), and the "Action" part enables searching by management operation (e.g., by TRANSMIT, ADD, etc.). Display). In addition, dates, ie, "year", "month", "day", "hour", "min", and "sec", enable searching of a desired time zone.

As described above, the present invention has the following effects.

(1) reduce database search time

The time required to fetch database data can be significantly reduced. Searching for integers takes much less time than searching for data of conventional character types. The most commonly used date-based search can be done efficiently by using the new type "datetime year to second".

(2) saving system resources

-DB space occupancy rate of character array and DB space occupancy rate of integer show big difference. Each module occupies 3 bytes, but in the present invention occupies 1 byte of "smallint", and in the action (action), the existing 9 bytes occupies 1 byte of "smallint" in the present invention, so that the log data stored in the database The more, the shorter the search time.

In summary, the present invention significantly reduces the search time of the log browser and saves a lot of system resources.

Claims (2)

In the database search optimization method in the database management system, Among the search type data of the log browser, a process of configuring date data as "datetime year to second" type, management module and action type data as integer type, and action and user data as character type, And searching the database using the configured log browser. The method of claim 1 wherein the integer type is a "smallint" type.