JP2011070556A - Data management device and backup data reference method - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To easily refer to data stored in a backup medium. <P>SOLUTION: A restore job 34 acquires a medium number of a backup medium 14 storing data to be referred, and a file name from a backup file management information table 33 when obtaining a date and a serial number of the data to be referred (S42). The backup medium 14 of the corresponding medium number is selected, and a file of a desired date is read from the backup medium 14 (S43). The read file is stored in a restore data area 32 of a database 12 (S44). In this way, image data associated with text data of a designated date can be displayed. <P>COPYRIGHT: (C)2011,JPO&INPIT

Description

  The present invention relates to a data management apparatus and a backup data reference method.

  In a system in which a server device manages transaction data of a plurality of automatic teller machines and the like, data with low usage frequency is set to a short storage period and deleted from the database. In such a case, data with a long storage period can be accessed, but data with a short storage period is stored in another medium as backup data, so it is necessary to retrieve the data by searching for a backup destination medium.

  As a prior art, when backing up a document file in a file management apparatus such as an electronic library, it is known to generate a file for storing a history of backup processing and restore the data using the history file. (For example, Patent Document 1).

  It is also known to provide a management master that registers backup date and time, backup medium identification symbol, recovery date and time, etc. for the backed up data as a management device that can retrieve desired data from a plurality of backed up external media. (For example, Patent Document 2).

  In the backup data management device, data storage state information indicating whether the data backup destination is only the magnetic tape device or both the magnetic tape device and the hard disk device is registered in the management table. When data to be backed up is backed up to a hard disk device, it is known to reduce the time required for recovery by recovering the hard disk device with priority (for example, Patent Document 3).

  Further, in the method of creating a backup magnetic tape for a work file, a management table for storing information such as a file number and a magnetic tape number is created, and the contents of the management table are stored in the system file magnetic tape. In the case of recovering data, a technique is known in which a magnetic tape number or the like in which a file is stored is obtained from information on a magnetic tape for system files, and data recovery is performed (for example, Patent Document 4).

  Further, it is known that in a magnetic disk device or the like, the access time is shortened by rearranging in the order of data access when rearranging data (for example, Patent Document 5).

JP 2002-82821 A JP-A-5-73388 JP-A-11-212845 Japanese Patent Laid-Open No. 7-56791 JP-A-3-30014

  An object of the present invention is to make it easy to refer to data stored in a backup medium.

  The data management apparatus according to the present invention includes a receiving unit that receives data from another device, a data storage unit that associates text data and image data received by the receiving unit and stores them in a database, and a storage period shorter than the text data. When the image data is backed up to a backup medium, backup management information creating means for creating backup management information for specifying the backup medium and the image data, backup management information storage means for storing the backup management information, When the text data or date to be referred is specified, it is determined whether or not the image data associated with the text data to be referred to or the text data on the specified date exists in the database. The image data is When not existing in the database, the backup management information is referred to, backup data acquisition means for acquiring the image data from the backup medium in which the image data is stored, and the acquired image data is restored to the database A data management apparatus comprising restore means for performing.

  According to this data management apparatus, the image data associated with the text data to be referenced can be acquired from the backup medium and restored to the database. Thereby, the image data deleted from the database can be referred to in association with the text data.

  According to the present invention, image data deleted from a database can be referred to in association with text data.

It is a figure which shows the structure of the data management system of embodiment. It is a flowchart of a data storage process. It is a flowchart of a backup process. It is explanatory drawing of a backup process. It is a figure which shows the structure of a database. It is a flowchart of the reference process of backed up data. It is explanatory drawing of a restore process. It is a figure which shows the data of the database after a restore process. It is explanatory drawing of the reference process of backed-up data. It is explanatory drawing of a restore data deletion process. It is a figure (1) which shows the display screen of a search terminal device. It is a figure (2) which shows the display screen of a search terminal device. It is a figure (3) which shows the display screen of a search terminal device. It is a flowchart of a daily data deletion process. It is explanatory drawing of a daily data deletion process. It is a flowchart of a monthly data deletion process. It is explanatory drawing of a monthly data deletion process.

Hereinafter, preferred embodiments of the present invention will be described. FIG. 1 is a diagram illustrating a configuration of a data management system according to an embodiment.
The data management system includes a plurality of automated teller machines (ATMs) 11, a database 12, and a server device (data management device) 13 that manages data in the database 12.

  The server device 13 has an application program that executes data reception processing, serial number acquisition processing, text data storage processing, and the like. The application program executes data reception processing, serial number acquisition processing, text data storage processing, image data storage processing, response processing, and the like. Data exchange between the server device 13 and the database 12 uses, for example, SQL (Structured Query Language).

The database 12 includes a serial number management area 21 for storing the latest serial number, a text data table 22, and an image data table 23.
The serial number management area 21 is an area in which the latest serial number is stored. A unique number (for example, a serial number) is issued for text data that is transaction data, image data of a user's image captured by a camera, and data that is a captured image of a card. The serial number is stored in the serial number management area 21 and used when the next serial number is issued.

  The text data table 22 includes an area 22a for storing a serial number assigned to data, an area 22b for storing an apparatus number (an apparatus number of the automatic teller machine 11), and an area 22c for storing a data reception date and time. , An area 22d for storing the account number and an area 22e for storing the transaction amount.

  The image data table 23 includes an area 23a for storing a serial number, an area 23b for storing a photographed camera or a type indicating the object to be photographed, and an area 23c for storing image data of a user or a card photographed by the camera. Have. The image data stored in the image data table 23 is associated with text data by a serial number.

  Next, a process of storing data received from the automatic teller machine 11 in the database 12 will be described with reference to FIG. The following processing is executed by a calculation unit (CPU) (not shown) of the server device 13, and data of the processing result is stored in a storage unit such as a memory or a hard disk device.

First, transaction data is received from the automatic teller machine (ATM) 11 (FIG. 2, S11).
Next, it is checked whether or not the received data is normal (S12). When the data check is OK, the process proceeds to step S13, where the serial number is acquired from the serial number management area 21 of the database 12, and a value obtained by adding “1” to the acquired serial number is set as the next serial number (S13).

Next, the received text data is written in the text data table 22 of the database 12 together with the serial number, device name, and date / time data (S14).
Next, the received image data is written in the image data table 23 of the database 12 together with the serial number and type (S15).

It is determined whether or not the processing (DB processing) related to the database 12 has been normally completed (S16).
When the processing related to the database 12 is normally completed (S16, normal), the process proceeds to step S17, and a normal response completion command is transmitted to the automatic teller machine 11.

  If the data check result is NG in step S12, or if an error occurs in the processing related to the database 12 in step S16, the process proceeds to step S18, and an error response command is transmitted to the automatic teller machine 11.

FIG. 3 is a flowchart of data backup processing. This backup process is started every day at a fixed time.
First, the date of data to be backed up is received (S21). Next, the text data of the backup target date is searched, and the text data obtained by the search is exported (S22).

Next, the image data of the backup target date is searched, and the image data obtained by the search is exported (S23).
Next, the file in which the text data and the image data are exported is moved to the backup medium 14 (S24). In the process of step S24, when the data is moved to the backup medium 14, a backup file management information table 33 (see FIG. 7) indicating which backup medium 14 the file is stored in is created and the storage unit (see FIG. For example, it is stored in a non-volatile memory, a hard disk or the like. This management information creation function corresponds to backup management information creation means, for example. A storage unit for storing backup file management information corresponds to backup management information storage means.

When reading the reference target data, the backup management information 33 can be referenced to identify the backup medium 14 in which the data is stored.
FIG. 4 is an explanatory diagram of the backup process 30. As shown in FIG. 4, since the serial number of data and the reception date / time are recorded in the text data table 22, data for which a predetermined period has elapsed with respect to the date / time when the backup process 30 was executed is extracted. Can do.

  Furthermore, by searching the image data table 23 using the extracted data sequence number as a key, it is possible to extract image data that has passed a fixed period (a storage period different from text data) based on the backup date and time.

  The storage period of image data is set shorter than the storage period of text data (transaction data). The data whose storage period has elapsed is stored in the backup medium 14 and then deleted from the database 12 by data deletion processing.

FIG. 5 is a diagram showing the configuration of the database 12. The database 12 has a real-time data area 31 and a restore data area 32.
The real-time data area 31 is an area for recording data received from the automatic teller machine 11 and includes the text data table 22 and the image data table 23 described above.

  The restore data area 32 is an area for storing data read from the backup medium 14 and includes a text data table 24 and an image data table 25. The restore data area 32 is normally in an unused state in which no data is recorded.

FIG. 6 is a flowchart of processing for referring to backed up data.
When a reference request for backed up data is generated, first, the date of data to be referred to is received (S31). In the process of step S31, for example, when it is desired to refer to the video taken by the automatic teller machine 11, the transaction date is input. Note that the method for specifying the data to be referred to is not limited to the date, but a device number, an account number, or the like may be specified, or the data and date may be specified.

  When the date (or other information) of the reference target data is designated, the server device 13 executes a restore process (S32). In the restore process in step S32, the backup medium 14 storing the data of the date specified with reference to the backup management information table 33 is specified. Then, the file stored in the identified backup medium 14 is read and stored in the restored data area 32 of the read file (for example, image data including a serial number) database 12.

Next, a data reference process is executed (S33). In the data reference process in step S33, the data is displayed on the terminal device that has instructed to search for data in the restore data area 32.
When the end of data reference is notified from the terminal device, the server device 13 executes logout processing (S34). In the logout process in step S34, the data stored in the restore data area 32 of the database 12 is deleted.

FIG. 7 is an explanatory diagram of the restore process, and FIG. 8 is a diagram showing data in the database 12 after the restore process.
When the application program of the server device 13 detects that the confirmation button 41e (see FIG. 11) is operated on the data details screen described later, the serial number and the reception date / time of the specified text data are acquired and the data to be displayed is displayed. The restore job 34 is activated by specifying the date and time (S41).

  When the restore job 34 acquires the date and sequence number of the reference target data from the application program, the restore job 34 acquires the media number and file name for identifying the backup medium 14 storing the reference target data from the backup file management information table 33. (S42).

  The backup file management information table 33 stores backup file management information (backup management information) including data serial numbers, file names, data attributes such as dates, media numbers, and the like. By referring to the backup file management information table 33, it is possible to know in which backup medium 14 the data of the designated date and time is stored.

  Next, the backup medium 14 having the corresponding media number is specified from the plurality of backup media 14 set in the media drive 15, and a file having a date and time to be referred to is acquired from the backup medium 14 (S43). Then, the acquired file is stored in the restore data area 32 of the database 12 (S44). In the process of step 44, for example, the image data acquired from the backup medium 14 is restored to the image data table 25 in the restore data area 32 together with the serial number.

  The function of acquiring data from the backup medium 14 corresponds to, for example, backup data acquisition means. The function of restoring the image data acquired from the backup medium 14 to the restore data area 32 together with the serial number corresponds to, for example, restore means for restoring the image data to the database 12.

  Through the above processing, as shown in FIG. 8, the text data table 24 in the restore data area 32 stores the text data of the designated date and time yyyy / mm / dd hh: mm in association with the serial number. Similarly, the image data stored in the backup medium 14 in association with the serial number is restored in the image data table 25 in the restore data area 32.

When the restore job 34 is completed, the process moves to the application program (S45).
The application program of the server device 13 searches the data in the restore data area 32 using the serial number of the reference target data as a key, and displays the corresponding image data on the terminal device (S46).

  FIG. 9 is an explanatory diagram of the backup data reference process. When referring to the backed up data, the date of the data to be referred to is designated from the search terminal device 16 and the restore job 34 of the server device 13 is called (S51).

  The restore job 34 refers to the backup management information table 33 to identify the backup medium 14 on which data is backed up, and reads the data from the backup medium 14. Then, the read data (for example, image data) is stored in the restore data area 32 of the database 12 and then notified to the search terminal device 16.

  When notified from the restore job 34 that the data restoration has been completed, the search terminal device 16 refers to the image data in the restore data area 32 of the database 12 (S52). As a result, when the date of the data is known, the image data moved to the backup medium 14 can be referred to using the search terminal device 16.

  When the data reference is completed, the search terminal device 16 executes logout processing and deletes the restored data from the restore data area 32 (S53). The server device 13 may execute logout processing for deleting the restored data from the database 12.

  FIG. 10 is an explanatory diagram of the restore data deletion process. When the application program of the server device 13 executes logout processing (S61), the restore data deletion job 35 is executed. The restore data deletion job 35 deletes all backup data restored in the restore data area 32 of the database 12. As a result, the restore data area 32 becomes unused as shown in FIG.

11 to 13 are diagrams showing display screens of the search terminal device 16.
(1) in FIG. 11 shows a display state during data search. At this time, a search condition input screen 41 a and a search result list 41 b are displayed on the display unit 41 of the search terminal device 16.

The search condition input screen 41a displays an input field for inputting data such as a device number for designating an automatic teller machine, a date and time when a transaction is performed, and an account number.
When a search condition is input and the search button 41c is operated, transaction data satisfying the search condition is extracted from the real-time data area 31 of the database 12, and a list of the extracted transaction data is displayed as a search result list 41b. Further, a detail display button 41d is displayed on the right side of the search result list 41b. When the detail display button 41d is operated, the transaction data is switched to the detailed display state.

  (2) of FIG. 11 shows a detailed display state (detailed display screen) of data. When image data associated with transaction data (an image of a user, an image of a card, etc.) is stored in the real-time data area 31 of the database 12, the image data is displayed.

  When the image data has been deleted from the database 12, a message “Some data has been backed up. Press the confirmation button to view it” is displayed. When the user operates the confirmation button 41e according to the displayed message, the restoration process of the image data stored in the backup medium 14 is started.

(3) in FIG. 12 shows a display state during the restoration process. During the restore process, the message “Preparing to display data. Please wait” is displayed.
When the restore process ends, the display is switched to the restore data display state shown in (4) of FIG. In the restored data display state, transaction data, a camera image (image taken by the user) 41f read from the backup medium 14, and an embossed image (image taken by the card) 41g are displayed. Thereby, the face and card | curd of the person who performed the transaction with the automatic teller machine 11 can be confirmed.

  When the end button 41h is operated in a state where the restore data is displayed, the display state is switched to the display state at the time of restore data search of (5) in FIG. In this data search screen, data in the real-time data area 31 and the restore data area 32 can be selected as search targets. (5) of FIG. 13 is an example when data in the restore data area 32 is selected as search target data.

  On the data search screen, a search condition input screen and a search result list are displayed. When the logout operation is performed after the restore data is displayed, the display state is switched to the logout display state shown in (6) of FIG. When the logout operation is performed, the restore data temporarily stored in the restore data area 32 of the database 12 is deleted.

FIG. 14 is a flowchart of daily data deletion processing. The daily data deletion process is started every day at a fixed time.
The date of data to be deleted is calculated based on the date and time when it was activated (S71). For example, when the storage period of transaction data is one year and the storage period of image data is one month, a date one year before the current date and a date one month before are calculated.

Next, text data (transaction data) before the date one year ago is deleted from the database 12 (S72).
Similarly, the image data before the date one month ago is deleted from the database 12 (S73).

FIG. 15A is an explanatory diagram of daily data deletion processing, and FIG. 15B is a diagram illustrating an example of data to be deleted.
The data deletion job 36 is started every day at the same time. The date / time data in the text data table 22 is checked, and the data one year before the date when the job was started is deleted. Further, the serial number of data one month before the date of activation is acquired, and the image data with the same serial number in the image data table 23 is deleted.

  As a result of the above processing, the text data before one year ago is deleted from the text data table 22 of the database 12, and the image data before one month is deleted from the image data table 23.

  As shown in FIG. 15B, for example, if the current date is March 15, the text data of March 14 of the previous year is deleted. Similarly, image data before February 14 one month ago is deleted.

FIG. 16 is a flowchart of monthly data deletion processing.
The date of data to be deleted is calculated based on the date and time when it was activated (S81). For example, when the storage period of transaction data is one year and the storage period of image data is one month, the date one year before the current date and the date one month before are calculated.

Next, the monthly text data (transaction data) before the date one year ago is deleted from the database 12 (S82).
Similarly, the monthly image data before the date one month ago is deleted from the database 12 (S83).

FIG. 17A is an explanatory diagram of monthly data deletion processing, and FIG. 17B is a diagram illustrating an example of data to be deleted.
The data deletion job 36 is activated every month. The date / time data in the text data table 22 is checked, and the data one year before the date when the job was started is deleted. Further, the serial number of data one month before the date of activation is acquired, and the image data with the same serial number in the image data table 23 is deleted.

  As a result of the above processing, the text data for one month before the current one year ago is deleted from the text data table 22 of the database 12, and the image data for one month before one month before is deleted from the image data table 23. Is done.

  As shown in FIG. 17B, for example, if the current date is March, the storage period for text data is one year, so data from March of the previous year is saved, and the data for February The text data is deleted. Since image data has a storage period of one month, the image data for January, which is the month before February of the previous month, is deleted.

  According to the above-described embodiment, the text data and the image data are stored in association with each other, and even when the storage period of the image data is shorter than the storage period of the text data and the image data is deleted, it is stored in the backup medium 14. The corresponding image data can be read out and displayed on the display unit of the search terminal device 16 (or the server device 13). Thereby, for example, it is possible to easily refer to the user's image taken at the time of the transaction of the automatic teller machine 11 or the like by specifying the creation date and time of the reference target data. Further, by deleting image data that is not frequently used from the database 12, the capacity of the storage device can be reduced, and the cost of the system can be reduced.

  Although embodiment mentioned above demonstrated the case where this invention was applied to the automatic teller machine 11 and the system which manages the data, it is not restricted to this. The present invention can be applied to any data management apparatus that manages text data and image data.

DESCRIPTION OF SYMBOLS 11 Automatic teller machine 12 Database 13 Server apparatus 14 Backup media 16 Search terminal apparatus 22 Text data table 23 Image data table 31 Real-time data area 32 Restore data area 33 Backup file management information table

Claims (5)

Receiving means for receiving data from another device;
Data storage means for associating and storing text data and image data received by the receiving means in a database;
Backup management information creating means for creating backup management information for identifying the backup medium and the image data when the image data is backed up to a backup medium with a shorter storage period than the text data;
Backup management information storage means for storing the backup management information;
When the text data or date to be referred is specified, it is determined whether or not the image data associated with the text data to be referred to or the text data on the specified date exists in the database. Backup data acquisition means for acquiring the image data from the backup medium in which the image data is stored with reference to the backup management information when the image data does not exist in the database;
A data management apparatus comprising restore means for restoring the acquired image data to the database. The receiving means receives the transaction data of the automatic teller machine and the image data of the user photographed by the camera as the text data and the image data, respectively.
The data management apparatus according to claim 1, wherein the data storage unit stores the transaction data and the user image in the database in association with each other.   3. The data management apparatus according to claim 1, wherein the text data and the image data are stored in a text data area and an image data area of the database in association with a management number assigned in common.   4. The received text data and the image data are stored in a real-time data storage area of the database, and the image data restored from the backup medium is stored in a restore data area of the database. Data management device. Store text data and image data received from other devices in a database,
When backing up the image data to a backup medium with a storage period shorter than the text data, create backup management information for specifying the backup medium and the image data and store it in a storage means;
When the text data or date to be referred is specified, it is determined whether or not the image data associated with the text data to be referred to or the text data on the specified date exists in the database. When the image data does not exist in the database, referring to the backup management information, obtaining the image data from the backup medium in which the image data is stored,
A backup data reference method for restoring the acquired image data to the database so that the image data can be referenced from a terminal device.