KR20010082455A - Data Backup make use of Command Unloaddb(in UniSQL) - Google Patents

Abstract

PURPOSE: A data backup using an unload DB command(UniSQL) is provided to offer a program capable of receiving a backup data by connecting to an FTP for checking a status of the program. CONSTITUTION: An important function is achieved in self-developed software. A phantom program programs all processes necessary to a backup. The phantom software inputs initially necessary information as an IP of a server, a log-in account, and a password of a database engine in advance. An increasing/decreasing quantity may be monitored by displaying a file size of data transmitted through an FTP. A status of the program table is checked. If an index value or a schema value is changed, a trouble exists in the program.

Description

Data Backup make use of Command Unloaddb (in UniSQL)}

Existing data backup was backed up by DAT tape or storage server and saved. However, it is pointed out that the method of DAT Tape has a problem of permanent preservation of data, and that storage server is expensive at the time of introduction.

These days, IBM-PC compatible models have a hard disk capacity of 20G to 40G and are becoming more and more large. In addition, the penetration rate of CD-Write is quite popular, so if only the necessary files are extracted from the server and compressed, then the files can be imported to a work PC through FTP and stored as a database and stored on CD. It was developed with the consideration that the cost of introduction is also quite low.

In addition, when the data was backed up, the computer manager initiated the backup of the data after the termination of the server's program after all employees had left the office. Therefore, if an application develops and installs a program that sequentially terminates the server's program, that is, executes all the procedures necessary for backup, and receives the backup (scheduled backup), the work efficiency will be maximized and the market will enter. He thought that there was a lot of response, so he developed this program, Phantom.

One of the features of this program is that it does not back up unnecessary APP programs, but only extracts the necessary data.

In other words, the amount of data is much smaller.

First of all, it was applied to the school affairs support system, which is one of the Ministry of Education and Human Resources Development, and it was explosive to investigate the response after DEMO was conducted to the information managers who are in charge of each school.

Traditional Data Backup Revolution

The configuration of the invention can be seen with reference to the representation and Figure 1.

The important function is done by in-house developed software.

The mode of operation programs all the necessary steps for backup in a program called Phantom.

Universally the backup procedure is the same.

In Phantom S / W, enter the necessary information in advance. For example, Server's IP or Login account and DATABASE ENGINE's Password.

In addition, scheduled backups are available.

And the data size of the data imported by FTP is shown numerically, so you can see the increase and decrease of the data at a glance.

You can also check the status of the program table.

In other words, if the value of the index or schema changes, it means that there is an error in the program.

This is a fairly inexpensive value compared to traditional backup systems.

Since the actual cost of introduction is $ 1,500,000, it can replace the existing backup server, which costs $ 20,000 to $ 30, and the scope of application is all servers.

On the industrial side, it can potentially enjoy 3 to 4 billion alternatives.

Claims (1)

Data backup of server using TELNET and FTP