KR20010082455A - Data Backup make use of Command Unloaddb(in UniSQL) - Google Patents
Data Backup make use of Command Unloaddb(in UniSQL) Download PDFInfo
- Publication number
- KR20010082455A KR20010082455A KR1020010043923A KR20010043923A KR20010082455A KR 20010082455 A KR20010082455 A KR 20010082455A KR 1020010043923 A KR1020010043923 A KR 1020010043923A KR 20010043923 A KR20010043923 A KR 20010043923A KR 20010082455 A KR20010082455 A KR 20010082455A
- Authority
- KR
- South Korea
- Prior art keywords
- program
- backup
- data
- unisql
- command
- Prior art date
Links
- 238000000034 method Methods 0.000 abstract description 4
- 230000003247 decreasing effect Effects 0.000 abstract 1
- 239000002360 explosive Substances 0.000 description 1
- 239000000284 extract Substances 0.000 description 1
- 230000035515 penetration Effects 0.000 description 1
- 238000004321 preservation Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/07—Responding to the occurrence of a fault, e.g. fault tolerance
- G06F11/14—Error detection or correction of the data by redundancy in operation
- G06F11/1402—Saving, restoring, recovering or retrying
- G06F11/1446—Point-in-time backing up or restoration of persistent data
- G06F11/1458—Management of the backup or restore process
- G06F11/1464—Management of the backup or restore process for networked environments
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/10—Services
- G06Q50/20—Education
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Tourism & Hospitality (AREA)
- General Physics & Mathematics (AREA)
- Primary Health Care (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Marketing (AREA)
- Economics (AREA)
- Strategic Management (AREA)
- Educational Technology (AREA)
- General Business, Economics & Management (AREA)
- Health & Medical Sciences (AREA)
- Educational Administration (AREA)
- Quality & Reliability (AREA)
- General Engineering & Computer Science (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
기존의 데이터 백업은 DAT Tape또는 스토레이지 써버로 자료를 Backup 받아 저장하였다. 그러나 DAT Tape의 방식은 자료의 영구 보존에 문제점이 제기되었고 스토레이지 써버는 도입 시 고가의 가격이라는 점이 문제점으로 지적되고 있다.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.
요즘 IBM-PC호환기종은 그 하드의 용량이 20G ∼ 40G 이며 더욱 더 대용량화 되어지는 추세이다. 또한 CD-Write의 보급율은 상당히 대중화 되어있어 만약에 Server에서 필요한 File만 축출하여 압축한 후 FTP를 통하여 파일을 업무용 PC에 가져와 이를 데이터베이스화 하여 CD로 저장할 수 있다면 그 자료의 보전은 반 영구적이며 그 도입 비용 또한 상당히 저렴하다는 점에 착안하여 개발하였다.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.
또한 자료의 Backup 시 전산 담당자는 다른 직원들의 업무가 파 한 즉, 모든 직원이 퇴근한 후에 써버의 프로그램을 종료 한 후, 자료의 백업에 착수하였다. 이에 어떤 응용 프로그램에서 써버의 프로그램을 순차적으로 종료하는 즉 백업에 필요한 모든 절차를 순차적으로 실행하는 프로그램을 개발, 설치하여 백업을 받는다면(예약백업), 업무의 효율성은 극대화 되어질 것과 시장의 진입 시 많은 호응이 있음을 착안하여 본 프로그램인 팬텀을 개발 한 것이다.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.
이 프로그램의 특장점중의 하나는 불필요한 APP Program 까지의 백업이 아닌 필요한 data만을 축출하여 Backup하는 것이다.One of the features of this program is that it does not back up unnecessary APP programs, but only extracts the necessary data.
즉 Data의 양이 훨씬 적다는 것이다.In other words, the amount of data is much smaller.
일차적으로 교육인적자원부의 사업의 하나인 교무업무지원 시스템에 적용을시켰다.각 학교의 담당자인 정보부장님들에게 프로그램을 DEMO한 후 호응도를 조사하니 과연 폭발적이었다.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.
기존 Data Backup의 혁명Traditional Data Backup Revolution
발명의 구성은 대표도와 도면도 1을 참조하면 알 수 있다.The configuration of the invention can be seen with reference to the representation and Figure 1.
중요한 기능은 자체 개발한 S/W에서 이루어진다.The important function is done by in-house developed software.
동작의 방식은 팬텀이라는 프로그램에서 Backup시 필요한 모든 절차를 프로그램화 한다.The mode of operation programs all the necessary steps for backup in a program called Phantom.
보편적으로 백업의 절차는 동일하다.Universally the backup procedure is the same.
팬텀 S/W에서 처음에 필요한 정보를 사전에 입력한다. 예를 들면 Server의 IP나 Login 계정 그리고 DATABASE ENGINE의 Password등이다.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.
그리고 FTP로 가져온 DATA의 파일 크기를 수치로 보여주기에 데이터의 증감량을 한 눈에 볼 수 있다.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.
실제 도입비용이 ₩1,500,000원이기에 기존의 2∼3천만원 하는 백업 써버의대체효과를 거둘 수 있으며 적용범위는 모든 써버이다.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.
산업적인 측면에서는 잠정적으로 30∼40 억의 대체 보급 효과를 누릴 수 있다.On the industrial side, it can potentially enjoy 3 to 4 billion alternatives.
Claims (1)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
KR1020010043923A KR20010082455A (en) | 2001-07-20 | 2001-07-20 | Data Backup make use of Command Unloaddb(in UniSQL) |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
KR1020010043923A KR20010082455A (en) | 2001-07-20 | 2001-07-20 | Data Backup make use of Command Unloaddb(in UniSQL) |
Publications (1)
Publication Number | Publication Date |
---|---|
KR20010082455A true KR20010082455A (en) | 2001-08-30 |
Family
ID=19712377
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
KR1020010043923A KR20010082455A (en) | 2001-07-20 | 2001-07-20 | Data Backup make use of Command Unloaddb(in UniSQL) |
Country Status (1)
Country | Link |
---|---|
KR (1) | KR20010082455A (en) |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH10124468A (en) * | 1996-10-01 | 1998-05-15 | Internatl Business Mach Corp <Ibm> | Resource managing method and computer |
JPH11265300A (en) * | 1998-03-17 | 1999-09-28 | Fujitsu Ltd | Client/server system, computer and storage medium |
JP2000105711A (en) * | 1998-09-29 | 2000-04-11 | Yokogawa Electric Corp | Computer system |
KR20010001954A (en) * | 1999-06-10 | 2001-01-05 | 김장중 | Centralized File System On Internet |
-
2001
- 2001-07-20 KR KR1020010043923A patent/KR20010082455A/en not_active Application Discontinuation
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH10124468A (en) * | 1996-10-01 | 1998-05-15 | Internatl Business Mach Corp <Ibm> | Resource managing method and computer |
JPH11265300A (en) * | 1998-03-17 | 1999-09-28 | Fujitsu Ltd | Client/server system, computer and storage medium |
JP2000105711A (en) * | 1998-09-29 | 2000-04-11 | Yokogawa Electric Corp | Computer system |
KR20010001954A (en) * | 1999-06-10 | 2001-01-05 | 김장중 | Centralized File System On Internet |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CA2674319C (en) | Methods and systems for solving problems with hard-coded credentials | |
US9037555B2 (en) | Asynchronous collection and correlation of trace and communications event data | |
US20120151488A1 (en) | Measuring Transaction Performance Across Application Asynchronous Flows | |
CN109614203B (en) | Android application cloud data evidence obtaining and analyzing system and method based on application data simulation | |
CN108268364A (en) | Anomalous event back method, device and equipment | |
JP2005235055A (en) | Information processor and security securing method in information processor | |
US20060248541A1 (en) | Universal driver server | |
CN112231654B (en) | Operation and data isolation method and device, electronic equipment and storage medium | |
CN104461380A (en) | Data storage method and device | |
US20060052999A1 (en) | System and method for portable emulation of operating environment | |
US7031999B1 (en) | Method of interconnecting computers and computer network | |
CN112463557A (en) | Recording method, device and medium for user space operation | |
KR20010082455A (en) | Data Backup make use of Command Unloaddb(in UniSQL) | |
Cisco | CIPM Release Notes 1.0.10(c) | |
CN109241180B (en) | Data synchronization method and device based on log | |
Cisco | Database Administration | |
Cisco | Database Administration | |
Cisco | Preparing to Install the CiscoWorks NetView Interface | |
Cisco | Preparing to Install the CiscoWorks NetView Interface | |
CN106354588A (en) | Database automatic backup method and device | |
Varsalone | Mac OS X, iPod, and iPhone forensic analysis DVD toolkit | |
Freeman et al. | Developing secure systems: issues and solutions | |
CN110109781A (en) | A kind of data back up method for s3 cloud service | |
CN111611107A (en) | Method and device for acquiring database logs | |
CN114049193B (en) | Invoice authentication deduction method and system based on tax control cabinet |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
A201 | Request for examination | ||
E902 | Notification of reason for refusal | ||
E601 | Decision to refuse application |