KR20200068641A - Method for archiving file automatically - Google Patents

Abstract

According to the present invention, provided is an automatic archiving method which comprises an archiving dictionary information input step, an archiving management information input step, an archiving operation execution step, an undecided case number inquiry step, an index construction step for an archived file, and an archiving work result output step. The automatic archiving is performed based on a predefined archiving sequence. The archived file is inquired by an index constructed in the index construction step.

Description

Automatic archiving method{METHOD FOR ARCHIVING FILE AUTOMATICALLY}

The present invention relates to an automatic archiving method.

With the widespread use of data production and consumption methods such as PCs, notebooks, and smartphones, along with the expansion of the Internet and the development of data communication technology, the amount of data produced and consumed is increasing exponentially.

To effectively classify and utilize these data, a method of managing data using a database is widely used in companies, organizations, and schools.

However, as the amount of data to be increased is exponential, the capacity of the database soon reaches its limit, and the continuous expansion of the capacity of the database is also limited in terms of cost and management. Therefore, there is a need for a technique that can efficiently archive a database to save capacity.

However, in the conventional archiving method, since an archiving person has to write an archiving command every time to execute an archiving operation, a lot of time and money is consumed, and human error may occur.

As an example, the conventional archiving method illustrated in FIG. 1 includes schedule confirmation, dependency confirmation, number of object targets (archiving targets), writing variable creation, writing execution, writing result confirmation and organization, storage execution, deletion execution, It consists of confirming the deletion result and writing the result report, and it is repeated for each object by dependency. Therefore, it is difficult to reduce the time and cost of archiving with the conventional archiving method. In addition, it is difficult to quickly inquire once archived data.

Published Patent (10-2014-0072929)

An object of the present invention is to provide an automatic archiving method capable of solving the above-mentioned problems.

Automatic archiving method for achieving the above object,

Archiving dictionary information input step;

Archiving management information input step;

Archiving operation execution phase;

Inquiries about outstanding information;

Index construction for archived files; And

Includes the output step of archiving results,

It is characterized in that automatic archiving is performed based on a predefined archiving sequence, and the archived file is searched by an index configured in the index configuration step.

The present invention performs automatic archiving based on a predefined archiving sequence by minimizing the archiving procedure and steps. Therefore, it is possible to minimize the number of personnel for each person in charge of archiving, and to reduce the time and cost of performing and monitoring archiving.

Using the index of the present invention, it is possible to search a large amount of archived data (more than 60,000) that was impossible to search using a conventional archiving method.

Using the index of the present invention, once archived data can be retrieved at a rate similar to that of retrieving data from the database currently being used.

According to the present invention, “integrated management related to archiving related settings (archive target object, storage cycle, etc.), no need for existing archiving sub-tasks (find the number of targets, check the results for each object, check the writing result, etc.), automatically and manually execute archiving functions, many Company archiving support and concurrent performance, archiving progress monitoring (standard & CBO division monitoring), archiving job log backup (automatic archiving job log periodically), index management function to improve archiving data inquiry speed, via email/text It has the convenience of the progress monitoring function (supports sending by e-mail or text of archiving work status).

The present invention has the efficiency of "archiving result analysis function, standard & CBO classification analysis function, archiving result download function, table analysis function, open data analysis for each object and archiving expected size confirmation function".

According to the present invention, “When an error occurs and the work is completed, email or text is sent to a designated person, preventing human error (through automatic archiving variant generation), and performing the assigned archiving sequence (pre-archiving by company -> write -> delete -> post-archiving) ), and has the stability of stopping execution (Schedule Lock function) for settlement and system work.

The present invention extends the scalability of “CBO Table automatic archiving object creation (write, deletion, automatic reload program creation), archiving execution completion period re-execution function (re-execution for added archiving object), referencing archiving target table, extraction of CBO Report”. Have.

The present invention can reduce the amount of data increase by using a data management & archiving (DMA) method. Here, the DMA (Data management & Archiving) method is (Archiving: applies to the SAP Core module's transaction data, Aggregation: applies FI/CO's Document Summarization, Deletion: secures performance through Deletion in the case of data without information utilization ).

The server in which the present invention is implemented is a simple file storage server that does not require a separate archive server (OS/DBMS, etc.) and an ECM solution for archiving data, so the archived file is utilized by utilizing the file storage server used by existing customers You can save and query.

1 is a flow chart showing a conventional archiving method.
2 is a flow chart showing an automatic archiving method according to the present invention.
3 is a flowchart illustrating in detail the execution steps of the archiving operation illustrated in FIG. 2.
4 is a diagram illustrating an AS index constituting the index shown in FIG. 2.
FIG. 5 is a diagram showing a TABLE1 index constituting the index shown in FIG. 2.
FIG. 6 is a diagram illustrating a TABLE2 index constituting the index shown in FIG. 2.
7 is a table comparing the time taken to query the archived data, according to the conventional archiving method and the archiving method according to the present invention.

As shown in Figure 1, the automatic archiving method according to an embodiment of the present invention, archiving dictionary information input step (S11), archiving management information input step (S12), archiving operation execution step (S13), outstanding number information It consists of inquiry step (14), index configuration step (S15), and archiving operation result output step (S16), automatic archiving is performed based on a predefined archiving sequence, and the archived file is indexed. Is queried. Here, the predefined archiving order may be “a specified order for each company code”.

An archiving system for executing an automatic archiving method according to an embodiment of the present invention is composed of a plurality of person in charge terminals, and a server connected to the terminals wired or wirelessly. The type of terminal may be various, such as a smart phone, a computer, a smart phone, and a tablet. The server is a file storage server. There may be multiple servers.

Hereinafter, the archiving dictionary information input step (S11) will be described.

The terminal inputs dictionary information necessary for performing an archiving operation to a server through a dictionary information registration module (program) for performing archiving.

Hereinafter, the archiving management information input step (S12) will be described.

The terminal inputs management information for monitoring the result of the archiving operation to the server through the management information registration module (program) to be archived.

Hereinafter, the archiving operation execution step (S13) will be described.

The server automatically executes the archiving operation at a predetermined time (weekly, monthly, quarterly, etc.) based on dictionary information and management information. Therefore, there is no need to execute the archiving operation separately, unless the person in charge performs the archiving operation manually.

As shown in Figure 3, the archiving operation execution step (S13), the monthly variable change by company code step (S131), write step (S132), write result check step (S132), delete step (S133), delete It is composed of a result confirmation step (S134) and a next object search step (S135).

When the archiving operation is stopped due to an error or other reason during the archiving operation in the archiving operation execution stage, the server notifies the person in charge via e-mail and text message through the terminal.

The server monitors whether the archiving operation is in progress and monitors whether the archiving operation has been completed normally even after the archiving operation is completed.

Through the terminal connected to the server, the person in charge can query the detailed information of the completion of the execution and the current status of the current progress.

On the other hand, in the archiving operation execution step, a locking function that prevents archiving from being performed on a specified date and time may be added. To this end, a step of determining whether a predefined archiving date and time is locked and a step of automatically performing a work group when the work group is locked are performed.

On the other hand, in the archiving operation execution step, an archiving process is performed until the set period, and when archiving is completed, a trigger step that is automatically stopped due to a trigger may be added.

Hereinafter, the inquired number information inquiry step 14 will be described.

As a result of archiving, if there are items that have not been completed for each object, the server queries them and stores the number of outstanding cases to perform when performing the next archiving.

Hereinafter, the index construction step (S15) will be described.

The server creates an index for each archived data so that the person in charge of archiving can quickly retrieve the archived data through the terminal.

For example, the index created on the archived data is composed of the AS index shown in FIG. 4, the TABLE1 index shown in FIG. 5, and the TABLE2 index shown in FIG.

The AS index shown in FIG. 4 is composed of index names (HK0, KUN, LIF...), positions (10, 20, 30...), and field names (MANDT, HKONT, BUKRS...).

TABLE 1 index shown in Figure 5, index name (BSIS), field name (MANDT, BUKRS, HKONT, BELNR, BUDAT), brief description (Client, Company Code, General Ledger Account, Clearing Date, Accouting Document Number, Posting Date in the Documet), DTyp (CLNT, CHAR, CHAR, DATS, CHAR, DATS), Length (3,4,10,8,10,8).

TABLE 2 index shown in Figure 6, index name (BSAS), field name (MANDT, BUKRS, HKONT, AUGOT, BELNR, BUDAT), brief description (Client, Company Code, General Ledger Account, Clearing Date, Accouting Document Number, Posting Date in the Documet), DTyp (CLNT, CHAR, CHAR, DATS, CHAR, DATS), Length (3,4,10,8,10,8).

As the index is composed of AS index, TABLE 1 index, and TABLE 2 index triple, the archived data is accurately retrieved without error.

As shown in FIG. 7, as a result of comparison test of the present invention and the conventional archiving method, 1402 archived data having an account of 11010400 are searched, but the present invention takes 5 seconds, whereas the conventional takes 37 seconds.

In order to query 1655 archived accounts and 1655 archived data, the present invention takes 6 seconds, while conventionally it takes 1 minute and 47 seconds.

To retrieve 4994 archived data of accounts 11010000 to 11019999, the present invention takes 14 seconds, while conventionally it takes 8 minutes and 18 seconds.

To retrieve 712 archived data of accounts 11010000, 11010001, 11010002, 11010100, 11010101, 11010102, 11010103, 11010104, 11010105, and 11010106, the present invention takes 2 seconds while conventionally takes 10 seconds.

In order to query 82337 archived data of all accounts, the present invention takes 3 minutes and 23 seconds, whereas conventionally, inquiry itself is impossible.

In order to query 69499 archived data of all accounts, the present invention takes 2 minutes and 42 seconds, whereas the inquiry itself is impossible in the past.

While querying 74756 archived data for all accounts, the present invention takes 3 minutes and 1 second, while conventionally it is impossible to query.

Hereinafter, an output step S16 of archiving operation results will be described.

The archiving result is output in various forms, such as the size of the archived file, the number of outstanding cases, and the archiving rate (%). The server delivers the results of the archiving operation to the person in charge via e-mail or text.

In addition, the present invention has the following additional functions.

The server may register an additional object reflecting the object's pre/post relationship when an additional object occurs after registering the initial archiving target.

The server additionally performs management checks and re-executions of the management information of the registered archiving objects by organization, year, and month.

The server functions to check and re-run the archive due to the change in the storage cycle of the archiving object registered in the management information input step.

Claims (1)

An archiving dictionary information input step in which a terminal inputs dictionary information necessary for performing an archiving operation to a server through a dictionary information registration module (program) for performing archiving;
An archiving management information input step in which the terminal inputs management information for monitoring archiving operation performance results to the server through a management information registration module (program) to be archived;
An archiving job execution step in which the server automatically executes an archiving job at a predetermined time (weekly, monthly, quarterly) based on the dictionary information and the management information;
As a result of archiving, if there is an item that has not been completed for each object, the server searches for it and stores the item that has not been completed for each object in order to perform the next archiving;
For the server to complete archiving, the index for each archived data is AS index, TABLE1 index, and TABLE2 index. An index construction step made in the middle; And
Includes the output step of archiving results,
Automatic archiving is performed based on a specified order by company code, and the archived file is searched by an index configured in the index configuration step.

Images