KR101716182B1 - Apparatus and method for management of database - Google Patents

Abstract

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database management apparatus and method for efficiently utilizing a database while reducing excess capacity of hardware. The database management method includes a step of executing a database scheduling application, a step of setting a database scheduling time, a step of checking an activation / deactivation state of a database for database access, a step of inquiring for deletion of data in the database, And deleting some data in the database in response to a query request when the current time is the set database scheduling time.

Description

[0001] Apparatus and method for managing database [0002]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a database management apparatus and method for efficiently utilizing a database while reducing excess capacity of hardware.

A database management system (DBMS) is a system for managing a database in which a large amount of data is stored, and is recognized as an indispensable element in the current era in which a large amount of information is continuously generated.

Such a database management system performs functions such as selecting and updating data in the database according to an inputted query when a specific query is inputted from the outside.

Here, the query refers to any request for data stored in the table of the database, that is, what kind of operation is desired to be performed on the data. The query is expressed using a language such as a structured query language (SQL) do.

The most typical query statement among these SQL statements is a select statement. The selected data can be used to browse the data existing in the table, to analyze the data to modify the contents of the data, or to browse the desired data by cross-referencing the data stored in the plurality of tables.

The database has a SYSJOBSCHEDULES table structure, but it uses jobs to automate certain tasks. You can not use the SQL Agent service to perform these tasks at a specified time. To manage the database periodically, you need to use SQLCMD among the SQL server utilities using Windows Scheduler. Connect to SQL server through SQLCMD command and execute query.

However, when using SQL server using MS's free version product, it takes a lot of development time due to limited use of service broker which is a function of exchanging messages between SQL servers. Also, storing data persistently in the database will cause the system to overload and overload.

SUMMARY OF THE INVENTION It is an object of the present invention to provide a database management apparatus and method for efficiently using a database while reducing excess capacity of hardware.

According to an aspect of the present invention, there is provided a database management method comprising: executing a database scheduling application; Setting the database scheduling time; Checking an activation / deactivation state of the database for the database access; Performing a query request for deleting data in a database when the database is in an active state; And deleting some data in the database by the query request when the current time is the set database scheduling time.

The method may further include setting at least one table to delete data among a plurality of tables constituting the database after executing the database scheduling application.

In the present invention, the step of deleting some data in the database is a step of deleting data in the set at least one table.

In the present invention, the step of deleting some data in the database is characterized by deleting old data in time with priority.

In the present invention, the step of deleting data in the table may further include checking whether the state of the table is updated.

The method may further include performing user authentication before performing the query request.

According to an aspect of the present invention, there is provided a database management apparatus comprising: a setting unit configured to set a database scheduling time; A check unit for checking the activation / deactivation state of the database for the database access; A query request unit for performing a query request for deleting data in the database when the database is in an active state; A timer for counting the set database scheduling time; And a deletion unit deleting some data in the database by the inquiry request when the current time is the set database scheduling time.

In the present invention, the setting unit may set at least one table that desires to delete data among a plurality of tables constituting the database.

In the present invention, the checking unit may check whether the state of the table is updated after deletion of data in the database.

As described above, according to the present invention, a database automation service can be provided to perform smooth data management. Especially for databases that have limited hardware capacity and do not need to store stale data. Also, since the system processes the database data periodically, there is no need for the user to know.

Furthermore, you can use database scheduling on a redundant server. Even if one of the redundant servers is shut down, another server can obtain the date and time of the operating system and schedule the database.

1 is a block diagram showing a configuration of a database management apparatus according to the present invention.
2 is a flow chart illustrating the operation of the database management method according to the present invention.
3 is a view showing a database scheduler configuration screen.

BRIEF DESCRIPTION OF THE DRAWINGS The present invention is capable of various modifications and various embodiments, and specific embodiments are illustrated in the drawings and described in detail in the detailed description. It is to be understood, however, that the invention is not to be limited to the specific embodiments, but includes all modifications, equivalents, and alternatives falling within the spirit and scope of the invention. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS Hereinafter, the present invention will be described in detail with reference to the accompanying drawings.

The terms first, second, etc. may be used to describe various elements, but the elements should not be limited by terms. Terms are used only for the purpose of distinguishing one component from another.

The terminology used in this application is used only to describe a specific embodiment and is not intended to limit the invention. The singular expressions include plural expressions unless the context clearly dictates otherwise. In the present application, the terms "comprises" or "having" and the like are used to specify that there is a feature, a number, a step, an operation, an element, a component or a combination thereof described in the specification, But do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, or combinations thereof.

The present invention may be represented by functional block configurations and various processing steps. These functional blocks may be implemented in a wide variety of hardware and / or software configurations that perform particular functions. For example, the present invention may include integrated circuit configurations, such as memory, processing, logic, look-up tables, etc., that may perform various functions by control of one or more microprocessors or other control devices Can be adopted. Similar to the components of the present invention that may be implemented with software programming or software components, the present invention may be implemented as a combination of C, C ++, and C ++, including various algorithms implemented with data structures, processes, routines, , Java (Java), assembler, and the like. Functional aspects may be implemented with algorithms running on one or more processors. Further, the present invention can employ conventional techniques for electronic environment setting, signal processing, and / or data processing. Terms such as mechanisms, elements, means, and configurations are widely used and are not limited to mechanical and physical configurations. The term may include the meaning of a series of routines of software in conjunction with a processor or the like.

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENT Hereinafter, embodiments of the present invention will be described in detail with reference to the accompanying drawings. Referring to the accompanying drawings, the same or corresponding components are denoted by the same reference numerals, do.

1 is a block diagram showing a configuration of a database management apparatus according to the present invention.

1, the database management apparatus includes a setting unit 110, a check unit 120, an authentication unit 130, a query request unit 140, a timer 150, a deletion unit 160, .

By executing the database scheduling application as an application capable of deleting data stored in the database at a set time, database management is started.

When the database scheduling application is executed, the setting unit 110 obtains the current time from the current OS and sets the database scheduling time. That is, the current time is set to a periodic scheduling time in milliseconds. For example, the database scheduling time can be set to 24 hours.

In the database management apparatus, all the data is stored in a database 170 in the form of a table, which is a basic structure for storing data in the database 170. [

The setting unit 110 sets at least one table capable of deleting data at the set database scheduling time. There are a plurality of tables in the database 170, and at least one table for which data deletion is desired can be set.

The check unit 120 checks the state of the database 170 to access the database 170 in the database scheduling application. If the state of the database 170 is Running, the database 170 can be accessed. If the state of the database 170 is Stop or Pause, the database 170 can not be accessed. Here, the access to the database 170 indicates that the data input / output to the database 170 is possible, and the access to the database 170 indicates that the data input / output to the database 170 is impossible.

If it is determined that the database 170 can be accessed as a result of checking the database 170 of the check unit 120, the authentication unit 130 receives the ID and the password as the user identification information and authenticates the user.

The query request unit 140 performs a query request for data deletion in the database 170, and calls the SQL Store Procedure to access the SQL Query File. That is, a query request to perform data deletion is performed on at least one table set by the setting unit 110.

The timer 150 counts the database scheduling time set from the current time acquired by the OS.

The deletion unit 160 deletes the data of the table set in the database 170 by the inquiry request when the current time is the database scheduling time set by the time count of the timer 150. [ The data deleted here can be deleted with the old data as a priority in time. The data deletion of the deletion unit 150 is performed periodically at every predetermined database scheduling time.

When the data of the set table in the database 170 is deleted, the check unit 120 checks the data update status of the table and sends a message to the user that the data in the table has been deleted.

FIG. 3 shows a database scheduler configuration screen including a database scheduling start time, a database scheduling workflow, and a database scheduling reservation time.

When you create a database and create a table, you need the ability to manage it. When a large amount of data is recorded in the table, the system load can be reduced because the old data is automatically checked and deleted through the database scheduling. You can also develop and use additional backups and restores automatically in many areas that use the database.

2 is a flow chart illustrating the operation of the database management method according to the present invention.

Referring to FIG. 2, a step of executing a database scheduling application is performed as an application capable of deleting data stored in a database at a set time (S201).

When the database scheduling application is executed, a step (S203) of setting at least one table among the plurality of tables existing in the database 170 to delete data is performed.

When at least one table setting for desiring to delete data is completed, a step of obtaining a current time from the OS (S205) is performed.

When the current time is obtained from the OS, step (S207) of setting a regular scheduling time in units of milliseconds is performed for the current time. Here, the scheduling time indicates the data deletion time of the set table.

Then, in order to access the database 170 in the database scheduling application, a step of checking the status of the database 170 (S209) is performed. If the state of the database 170 is Running, the database 170 can be accessed. If the state of the database 170 is Stop or Pause, the database 170 can not be accessed.

In a case where the database 170 is in the active state via the step S211 of determining whether the database 170 is in the activated state, the step S213 of receiving the ID and the password as the user identification information and authenticating the user is performed.

When the user authentication is completed, a step S215 of performing a query request to perform data deletion for the set at least one table is performed.

Thereafter, in step S217, it is determined whether the current time is a set database scheduling time. If the current time is not the set database scheduling time, a step S219 is performed.

However, if the current time is the set database scheduling time, a step S221 of deleting data of a table set in the database 170 by a query request is performed. The data deletion is performed periodically at a predetermined database scheduling time, and data to be deleted can be deleted in time with old data as a priority.

After the data of the table is deleted, step S223 is performed to confirm that the data update state of the table, that is, the data in the table has been deleted.

Meanwhile, the present invention can be embodied in computer readable code on a computer readable recording medium. A computer-readable recording medium includes all kinds of recording apparatuses in which data that can be read by a computer system is stored.

Examples of the computer-readable recording medium include ROM, RAM, CD-ROM, magnetic tape, floppy disk, optical data storage, and the like. In addition, the computer-readable recording medium may be distributed over network-connected computer systems so that computer readable codes can be stored and executed in a distributed manner. In addition, functional programs, codes, and code segments for implementing the present invention can be easily deduced by programmers skilled in the art to which the present invention belongs.

The present invention has been described above with reference to preferred embodiments. It will be understood by those skilled in the art that the present invention may be embodied in various other forms without departing from the spirit or essential characteristics thereof. Therefore, the above-described embodiments should be considered in an illustrative rather than a restrictive sense. The scope of the present invention is indicated by the appended claims rather than by the foregoing description, and all differences within the scope of equivalents thereof should be construed as being included in the present invention.

All documents, including publications, patent applications, patents, etc., cited in the present invention may be incorporated into the present invention in the same manner as each cited document is shown individually and specifically in conjunction with one another, .

110: Setting section
120:
130:
140:
150: Timer
160:
170: Database

Claims (9)

A database management method performed in a computing device,
Executing a database scheduling application as an application capable of deleting data stored in the database at predetermined time intervals;
Setting at least one table for which data deletion is desired among a plurality of tables existing in the database when the database scheduling application is executed;
Acquiring a current time from the OS when at least one table setting for the data deletion is completed;
Setting a periodic scheduling time when a current time is obtained from the OS;
Checking an activation / deactivation state of the database to access the database in the database scheduling application;
Performing a query request for deleting data in the database when the database is in an active state;
If the current time is the preset database scheduling time, deleting data of a table set in the database by the inquiry request; And
And periodically performing data of a table set in the database at each scheduling time. delete delete delete The method according to claim 1,
After the step of deleting data in the table,
Further comprising: checking whether the state of the table is updated. delete delete delete delete

Images