WO2016203613A1 - Information system and database management method - Google Patents

Information system and database management method Download PDF

Info

Publication number
WO2016203613A1
WO2016203613A1 PCT/JP2015/067606 JP2015067606W WO2016203613A1 WO 2016203613 A1 WO2016203613 A1 WO 2016203613A1 JP 2015067606 W JP2015067606 W JP 2015067606W WO 2016203613 A1 WO2016203613 A1 WO 2016203613A1
Authority
WO
WIPO (PCT)
Prior art keywords
update
information
exclusion
database
load
Prior art date
Application number
PCT/JP2015/067606
Other languages
French (fr)
Japanese (ja)
Inventor
正和 深谷
昌大 熊谷
聖平 松浦
憲宏 原
Original Assignee
株式会社日立製作所
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 株式会社日立製作所 filed Critical 株式会社日立製作所
Priority to PCT/JP2015/067606 priority Critical patent/WO2016203613A1/en
Publication of WO2016203613A1 publication Critical patent/WO2016203613A1/en

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F12/00—Accessing, addressing or allocating within memory systems or architectures

Definitions

  • the present invention relates to an information system and a database management method for processing data and information from a backbone system.
  • An example of big data utilization is fraud detection. This is because anyone can use it at Internet banks and online shops, and damages such as unauthorized bank interruptions and unauthorized use of credit cards have increased.
  • fraud detection work it is required that information necessary for fraud detection be reflected in a timely manner to detect a problem. Therefore, it is important to construct a system capable of performing fraud detection work by using the latest business information of the mission critical system and past business information accumulated in the information system.
  • Patent Document 1 a specific type of column data is compressed alone, and continuous column data other than the specific type is collectively compressed, thereby reducing the amount of data.
  • the amount of data reduction varies depending on the data content and there is a case where the amount of data cannot be reduced almost completely, when processing a large amount of data, the update processing of the database of the information system is not in time, and the data of the core system Cannot be reflected in an information system in a timely manner, and it becomes difficult to maintain the service level of fraud detection work.
  • An object of the present invention is to control the amount of information in accordance with the update load in the detection work when reflecting information from the backbone system.
  • the present invention includes at least a storage device that stores a database, and an information processing device that processes data and information from a backbone system, and the information processing device Among them, when reflecting the target data to be detected in the database, the update load for reflecting the update information of the target data to the database is detected, and the update information is based on the detection result.
  • a control unit that performs control to reflect the information in the database, and the control unit controls the amount of information to be reflected in the database according to the detected update load.
  • the amount of information can be controlled in accordance with the update load in the detection work when reflecting information from the backbone system.
  • FIG. 1 is an overall configuration diagram of a computer system according to the present invention.
  • the computer system stores, for example, a core system 10 that performs business processing such as a financial institution, and processing results of the core system 10 as business information accompanying the business processing, and uses the stored business information.
  • an information system 50 that executes processing of fraud detection work for detecting fraud business such as analysis work and detection work, for example, fraudulent transfer.
  • the backbone system 10 and the information system 50 are connected via the network 100. Connected.
  • the backbone system 10 is a computer system having a CPU (Central Processing Unit) 12, a network interface (I / F) 14, a memory 16, and a disk 18, and each unit is connected via an internal bus 20. .
  • CPU Central Processing Unit
  • I / F network interface
  • the CPU 12 is configured as a control unit that performs overall control of the entire backbone system 10 according to various programs stored in the memory 22.
  • the network interface 14 is configured as a network interface that connects the backbone system 10 and the network 100.
  • the memory 16 includes a business processing unit 22, a data management unit 24, and a replication unit 26 as a plurality of programs activated by the CPU 12.
  • the business processing unit 22 executes business processing that requires real-time performance.
  • the data management unit 24 manages data in the disk 18 based on an instruction from the business processing unit 22.
  • the replication unit 26 executes processing for transferring (replicating) data and update information in the disk 18 to the information system 50 based on an instruction from the CPU 12.
  • the disk 18 is configured as a storage device, and a plurality of storage areas 28 and 30 are formed on the disk 18.
  • a database (DB) is stored in the storage area 28, and update information of data processed by the business processing unit 22 is stored in the storage area 30.
  • the information system 50 is a computer system having a CPU 52, a network interface 54, a memory 56, and a disk 58, and each unit is connected via an internal bus 60.
  • the CPU 52 is configured as a control unit that controls the entire information system 50 according to various programs stored in the memory 56.
  • the network interface 54 is configured as a network interface that connects the information system 50 and the network 100.
  • the memory 56 includes a business processing unit 62, a data management unit 64, a replication unit 66, a business SQL (Structured Query Language) analysis unit 68, an update time monitoring unit 70, as a plurality of programs activated by the CPU 52.
  • the update information processing unit 72 includes a load detection unit 74, an update information exclusion unit 76, and an exclusion information reflection unit 78.
  • the CPU 52, the network interface 54, the memory 56, and the internal bus 60 function as an information processing apparatus that processes data and information from the backbone system 10.
  • the business processing unit 62 performs, as business processing in the information system 50, for example, analysis business processing for analyzing data in a database (DB) stored in the disk 58, data in the database (DB) stored in the disk 58. Execute detection work (fraud detection work) processing to detect fraudulent transfer etc.
  • the data management unit 64 Based on the instruction from the business processing unit 62, the data management unit 64 reflects the data transferred from the backbone system 10 to the database (DB) in the disk 58, and updates the data and the update information. A process for reflecting the information belonging to the database (DB) in the disk 58 is executed.
  • the replication unit 66 receives the data transferred from the backbone system 10 and the update information of this data by the processing of the replication unit 24 of the backbone system 10, transfers the received data to the data management unit 64, and receives it A process for transferring the update information to the update information processing unit 70 is executed.
  • the business SQL analysis unit 68 analyzes the input SQL, for example, when SQL is input from the business processing unit 62 as information used in the detection business, and as analysis results, information necessary for the detection business (information excluded from exclusion) Is stored in the disk 58.
  • the update time monitoring unit 70 monitors the update time for the data management unit 64 to update the update information (the time for reflecting the update information in the database).
  • the update information processing unit 72 processes the update information transferred from the backbone system 10.
  • the load detection unit 74 detects whether the update load when the data management unit 64 updates the update information is high load or low load.
  • the update information excluding unit 76 performs processing for excluding unnecessary information (exclusion execution information) in the detection work (fraud detection work) from the update information transferred from the backbone system 10.
  • the exclusion information reflection unit 78 performs a process of reflecting the information excluded by the update information exclusion unit 76 on the disk 58 as exclusion implementation information.
  • the disk 58 is configured as a storage device for storing data and information, and a plurality of storage areas 80, 82, 84, 86, 88, 90 are formed on the disk 58.
  • the storage area 80 stores a database (DB) that stores data to be managed by the data management unit 64 and data to be processed by the business processing unit 62.
  • the storage area 82 stores data update information transferred from the backbone system 10 and information related to the number of update information updates.
  • the storage area 86 stores information that has been processed by the update information excluding unit 76 and that is unnecessary for detection work.
  • the storage area 88 stores information related to an average update time that is a predicted time required for the data management unit 64 to update the update information.
  • the storage area 90 stores information related to the update deadline that is a time limit when the data management unit 64 updates the update information.
  • the update deadline is designated by the user as a determination value (setting value) for maintaining the service level of the detection job.
  • the CPU 52 updates the target data when reflecting the target data of the business process among the data transferred from the backbone system 10, for example, the target data to be the target of the detected business, in the database (DB) of the disk 58.
  • Detects an update load for reflecting information in the database (DB) of the disk 58 and functions as a control unit that performs control for reflecting update information in the database (DB) based on the detection result.
  • the amount of information to be reflected in the database (DB) is controlled according to the load. For example, when the update load is high, a part of the update information is updated to reduce the amount of information to be updated.
  • the CPU 52 determines that the detected update load is high, the CPU 52 excludes information unnecessary for the detection work belonging to the business process from the update information, and after the information unnecessary for the detection work is excluded.
  • Estimated update time required to reflect update information (non-exclusion information) in the database (DB), and post-exclusion update information (exclusion-excluded information) on the condition that the predicted update time is within the update deadline Is reflected in the database (DB).
  • the CPU 52 predicts the update time required to reflect the update information of the target data in the database (DB), and determines that the detected update load is high when the predicted update time exceeds the update deadline. .
  • FIG. 2 is an exclusion pattern configuration diagram of information that is not excluded.
  • column / row update information 200 is composed of a plurality of rows for column A 201, column B 202, column C 203, and column D 204, respectively. If it is determined that the information belonging to the information is not used in the detection job, the information belonging to the D column 204 is managed as the exclusion execution information not used in the detection job, and the information belonging to the A column 201, the B column 202, and the C column 203 Are managed as non-exclusion information (update information after exclusion) used in detection work. That is, the information that does not belong to the exclusion is configured by information belonging to the A column 201, the B column 202, and the C column 203.
  • column / row update information 300 includes a plurality of rows for column A 301, column B 302, column C 303, and column D 304, and the job processing unit 62 belongs to column C 303.
  • the information belonging to the row whose information is 1000 or less is information that is not used in the detection operation
  • the information in the row of each column in which the C column 303 is 1000 or less in the update information 300 is excluded as the excluded execution information.
  • the row information of each column in which the C column 303 is 1000 or less is thinned out.
  • the update information 300 the information of the row of each column in which the C column 303 is 1000 or less is managed as the exclusion execution information, and other information (information of the information of each column in which the C column 303 exceeds 1000) is stored. It is managed as non-exclusion information (update information after exclusion).
  • the column / row update information 400 is composed of a plurality of rows for the A column 401, the B column 402, the C column 403, and the D column 404, and the business processing unit 62 belongs to the same group. If it is determined that the information is to be aggregated, the information before aggregation is excluded from the update information 400 as the exclusion execution information. For example, if December 1, 2014 is used as the same group of information, the information on the first and second rows of each column is aggregated, and the aggregated information is added to the ⁇ 1 row. In this case, for the information in each column, the information from the 3rd row to the 10th row is managed as non-exclusion information (update information after exclusion). The information added to the -1 line is deleted when the exclusion execution information recorded in the 1st and 2nd lines is reflected on the disc 58.
  • FIG. 3 is a flowchart for explaining the processing of the business SQL analysis unit. This process is started when the CPU 52 activates the business SQL analysis unit 68.
  • the business SQL analysis unit 68 reads the business SQL of the detected business from the business processing unit 62 (S10). Thereafter, the business SQL analysis unit 68 acquires the table name, column name, and condition in the business SQL (S11), and acquires the acquired table name, column name, and condition information necessary for the detection business (fraud detection business), That is, it is recorded in the storage area 84 as information not to be excluded (S12), and the processing in this routine is terminated.
  • FIG. 4 is a flowchart for explaining the processing of the update information processing unit. This process is started when the CPU 52 activates the update information processing unit 72.
  • the update information processing unit 72 executes the process on the condition that the processes of the monitoring time monitoring unit 70 and the business SQL analysis unit 68 have been executed.
  • exclusion execution information that is unnecessary information for detection work, which is an analysis result of the work SQL analysis unit 68, is excluded from the update information.
  • the information is transmitted to the data management unit 64 as post-exclusion update information.
  • the update information after the exclusion implementation information is excluded is stored in the storage area 82 by the data management unit 64 and then reflected in the database (DB) of the recording area 80.
  • the exclusion execution information is transmitted to the data management unit 64 by the exclusion information reflecting unit 78 and then stored in the storage area 86. After that, when the update load calculated by the load detection unit 74 is low, the recording area 80 Are reflected in the database (DB).
  • the update information processing unit 72 first activates the load detection unit 74 and causes the load detection unit 74 to perform load detection (S20). As a result of the load detection by the load detection unit 74, it is determined whether or not the update can be performed within the update time limit without excluding the update information (S21). For example, it is determined whether or not the update information can be updated within the update deadline without excluding information unnecessary for detection work (exclusion execution information) from the update information. That is, the update information processing unit 72 determines whether or not the update load is a low load from the detection result of the load detection unit 74.
  • step S21 When an affirmative determination result is obtained in step S21, that is, the update load is low and the update information can be updated within the update deadline without excluding the exclusion execution information from the update information. If so, the update information processing unit 72 determines whether there is information already excluded by the update information exclusion unit 76 in the exclusion implementation information belonging to the update information (S22). When an affirmative determination result is obtained in step S22, the update information processing unit 72 uses, for example, already excluded column information (information recorded as exclusion implementation information) in the update information. (S23), and the process proceeds to step S30. If a negative determination result is obtained in step S22, the process proceeds to step S30.
  • step S21 if a negative determination result is obtained in step S21, that is, if the update load is high and the exclusion execution information is not excluded from the update information, the update information cannot be updated within the update deadline. If it is determined that it is possible, the update information processing unit 72 reads the table name, column name, and condition from the non-exclusion information that is information necessary for the detection work (S24), and only the non-exclusion information is included in the update information. Whether or not exists is determined (S25).
  • step S25 When a negative determination result is obtained in step S25, that is, when the update information is composed only of information not to be excluded, the update information processing unit 72 displays a display device (not shown) connected to the internal bus 60. ) Is executed to display a warning message on the screen, and the process proceeds to step S30.
  • step S25 When an affirmative determination result is obtained in step S25, that is, when information other than the excluded information is present in the update information, the update information processing unit 72 determines that the information that does not match the excluded information from the updated information. Are excluded / aggregated (S27), and it is determined whether update information (update information after exclusion) after excluding / aggregating information that does not match information that is not excluded can be updated within the update deadline (S28). ).
  • step S28 determines whether the update information (excluded update information) after exclusion / aggregation of information that does not match the non-exclusion information cannot be updated within the update deadline.
  • step S28 When an affirmative determination result is obtained in step S28, that is, when update information after exclusion / aggregation of information that does not match the exclusion target information (update information after exclusion) can be updated within the update deadline,
  • the update information processing unit 72 manages the information excluded / aggregated as information that does not match the information not to be excluded from the update information as the exclusion execution information. 58, and the process proceeds to step S30.
  • step S30 when the processes of steps S22 and S23 are executed, the update information processing unit 72 transmits all information including the exclusion target information and the exclusion implementation information to the data management unit 64 as update information, and step S29.
  • update information (excluded update information) after exclusion / aggregation of information that does not match the information excluded from exclusion is transmitted to the data management unit 64
  • Update information including non-target information is transmitted to the data management unit 64.
  • the update information transmitted to the data management unit 64 or information belonging to the update information is then reflected in the database (DB) of the storage area 80.
  • FIG. 5 is a flowchart for explaining the processing of the update time monitoring unit. This process is started when the CPU 52 activates the update time monitoring unit 70.
  • the update time monitoring unit 72 calculates an update time per item from the update information reflection time when the data management unit 64 reflects the update information in the database (DB) of the storage area 80.
  • the update time monitoring unit 70 detects the database reflection start time when the data management unit 64 reflects the update information in the database (DB) of the storage area 80 (S40), and then the data management unit 64. Detects the database reflection end time when the update information is reflected in the database (DB) of the storage area 80 (S41), calculates the database reflection monitoring time from the database reflection start time to the database reflection end time, An average update time per case is calculated from the calculated database reflection time and the number of database reflections (S42).
  • the update time monitoring unit 70 determines whether or not the data management unit 64 reflects the database (DB) of only the excluded information (update information after exclusion) necessary for the detection work (S43).
  • step S43 When a negative determination result is obtained in step S43, that is, when update information including exclusion exclusion information and exclusion implementation information is reflected in the database (DB), the update time monitoring unit 70 determines exclusion exclusion information and exclusion
  • the update time of the update information including the implementation information is set as the average update time before exclusion, the average update time before exclusion is recorded as the average update time (S44), and the processing in this routine is ended.
  • step S43 when an affirmative determination result is obtained in step S43, that is, when the data management unit 64 reflects only non-exclusion information (update information after exclusion) that is information necessary for detection work in the database (DB).
  • the update time monitoring unit 70 excludes the exclusion execution information from the update information, sets the update time of the update information (excluded update information) of only the excluded information as the average update time after exclusion, and sets the average update time after exclusion as the average update time after exclusion.
  • the average update time is recorded (S45), and the processing in this routine is terminated.
  • FIG. 6 is a flowchart for explaining the processing of the load detection unit. This process is started when the CPU 52 activates the load detection unit 74.
  • the load detection unit 74 calculates whether the update is completed within the update deadline from the number of pieces of update information to be updated and the average update time. When the update is completed within the update deadline, the load is low, and when the update is not completed within the update deadline, the load is high.
  • the load detection unit 74 reads the average update time before exclusion and the average update time after exclusion from the update time monitoring unit 70 (S50).
  • the load detection unit 74 reads the number of update information updates from the storage area 82 and reads the update deadline from the storage area 90 (S51).
  • the load detection unit 74 informs the caller, for example, the update information processing unit, the value of update deadline ⁇ (number of updates ⁇ average update time before exclusion) and (update deadline ⁇ (number of updates ⁇ average update time before exclusion)).
  • the value of the average update time before exclusion, the average update time after exclusion and the number of updates are notified (S52), and the processing in this routine is terminated.
  • the value of update deadline-(number of updates x average update time before exclusion) is a value for determining whether or not the update is completed within the update deadline even if the exclusion execution information is not excluded from the update information.
  • this value is positive, the update is completed within the update deadline even if the update information includes non-exclusion information and exclusion implementation information.
  • this value is negative, the exclusion implementation information is excluded from the update information, and the update information of only the non-exclusion information (update information after exclusion) is updated within the update deadline with the average update time after exclusion. It is determined whether or not to complete.
  • Renewal deadline-(Number of updates x average renewal time before exclusion) / average renewal time before exclusion is the number of exclusion implementation information that can be added within the renewal deadline. This value is used when the exclusion implementation information is reflected in the database after the exclusion implementation information is excluded from the update information.
  • the update time monitoring unit 70 reflects the update information of the target data to be detected in the data from the backbone system 10 in the database (DB).
  • the update time required for the update is predicted as the update time before exclusion, and the update time required for reflecting the update information after exclusion from which unnecessary information is excluded from the update information to the database (DB) is excluded Predict as update time.
  • the load detection unit 74 compares the prediction result of the update time monitoring unit 70 with the update deadline, and determines that the update load is high when the update time before exclusion or the update time after exclusion exceeds the update deadline, When the update time before exclusion or the update time after exclusion is within the update deadline, it is determined that the update load is low.
  • the update information processing unit 72 excludes information unnecessary for detection work from the update information, and updates the update information.
  • the post-exclusion update information is extracted from the list as information required for detection work. Thereby, update information and post-exclusion update information can be separated.
  • the data management unit 64 reflects at least update information or post-exclusion update information in the database (DB) based on the determination result of the load detection unit 74. At this time, the data management unit 64 reflects the post-exclusion update information in the database (DB) on the condition that the post-exclusion update time is within the update deadline and the determination result of the load detection unit 74 is low load. can do.
  • the update time monitoring unit 70 predicts the update time before exclusion for each update information as the average update time before exclusion indicating the average, and sets the update time after exclusion as the average update time after exclusion indicating the average for each update information. Predict. Thereby, the update time for updating the update information can be predicted.
  • the load detection unit 74 uses, as the prediction result of the update time monitoring unit 70, a multiplication value of the number of update information updates and the average update time before exclusion or a multiplication value of the update information update number and the average update time after exclusion. become.
  • the data management unit 64 is information excluded from the update information on the condition that the update time before exclusion is within the update deadline and the determination result of the load detection unit 74 is low load. Information unnecessary for detection work can be reflected in the database (DB). Thereby, all the information belonging to the update information can be reflected in the database (DB) within the update deadline.
  • the amount of information can be controlled according to the update load in the detection work, that is, according to the level of the update load. it can. For this reason, when the update load is high, only a part of the update information (update information after exclusion) is updated within the update deadline, so that the detection work is not affected without affecting the performance of the work other than the detection work. Service levels can be maintained.
  • the update load when the update load is high, the information unnecessary for the detection work belonging to the business process is excluded from the update information, and the information unnecessary for the detection work is excluded and the update is performed after the exclusion. Since the update time required to reflect the information in the database (DB) is predicted and the post-exclusion update information is reflected in the database (DB) on the condition that the predicted update time is within the update deadline. The update process for the database (DB) can be completed without delay. Further, the exclusion execution information that is excluded as information unnecessary for detection work can be reflected in the database (DB) when the update load is low.
  • this invention is not limited to the above-mentioned Example, Various modifications are included.
  • the above-described embodiments have been described in detail for easy understanding of the present invention, and are not necessarily limited to those having all the configurations described. Further, it is possible to replace a part of the configuration of the embodiment with another configuration, and it is possible to add, delete, and replace another configuration with respect to a part of the configuration of the embodiment.
  • each of the above-described configurations, functions, etc. may be realized by hardware by designing a part or all of them, for example, by an integrated circuit.
  • Each of the above-described configurations, functions, and the like may be realized by software by interpreting and executing a program that realizes each function by the processor.
  • Information such as programs, tables, and files that realize each function must be recorded on a recording device such as a memory, hard disk, SSD (Solid State Drive), or a recording medium such as an IC card, SD card, or DVD. Can do.

Abstract

A storage device that stores a database and an information processing device that processes data and information from a backbone system are provided. The information processing device includes a control unit that exercises control to detect an updating load for reflecting update information for target data of detection work in the database and to reflect the update information in the database on the basis of the result of detection. The control unit controls the amount of information that is to be reflected on the database on the basis of the detected updating load.

Description

情報系システム及びデータベース管理方法Information system and database management method
　本発明は、基幹系システムからのデータ及び情報を処理するための情報系システム及びデータベース管理方法に関する。 The present invention relates to an information system and a database management method for processing data and information from a backbone system.
　ビッグデータ活用の例として、不正検知業務が挙げられる。ネットバンクやネットショップで誰でも利用できるようになり、銀行の不正割り込みやクレジットカード不正利用などといった被害が増えたためである。不正検知業務では、不正検知に必要な情報をタイムリーに反映し、問題を検知できることが求められている。そのために、基幹系システムの最新の業務情報と、情報系システムで蓄積した過去の業務情報を利用して、不正検知業務ができるシステムの構築が重要になっている。 An example of big data utilization is fraud detection. This is because anyone can use it at Internet banks and online shops, and damages such as unauthorized bank interruptions and unauthorized use of credit cards have increased. In fraud detection work, it is required that information necessary for fraud detection be reflected in a timely manner to detect a problem. Therefore, it is important to construct a system capable of performing fraud detection work by using the latest business information of the mission critical system and past business information accumulated in the information system.
　基幹系システムのデータを利用して、情報系システムで不正検知業務を行う場合、基幹系システムのデータを情報系システムへ反映する場合、ユーザが指定する更新期間内に完了する必要がある。一方、情報系システムでは、不正検知業務以外の業務もデータベースを利用しているので、不正検知業務が、不正検知業務以外の業務の性能に影響を与えないことが必要とされる。 When performing fraud detection work on the information system using the data on the core system, and when reflecting the data on the core system to the information system, it must be completed within the update period specified by the user. On the other hand, in the information system, since the work other than the fraud detection work also uses the database, it is necessary that the fraud detection work does not affect the performance of the work other than the fraud detection work.
　基幹系システムのデータ量が増え、基幹系システムで大量のデータを扱う場合、大量のデータをそのまま基幹系システムから情報系システムにレプリケーションしたのでは、情報系システムのデータベースの更新処理が間に合わず、基幹系システムのデータを情報系システムにタイムリーに反映できないことが想定される。この場合、特許文献１に記載されているように、データを圧縮する方法を採用することができる。 When the amount of data in the backbone system increases and a large amount of data is handled in the backbone system, if a large amount of data is replicated from the backbone system to the information system as it is, the update processing of the information system database will not be in time, It is assumed that data of the mission critical system cannot be reflected in the information system in a timely manner. In this case, as described in Patent Document 1, a method of compressing data can be employed.
特開２００４－１６９８３２号公報JP 2004-169832 A
　特許文献１では、特定型のカラムデータを単独で圧縮し、特定型以外の連続するカラムデータを一括して圧縮することで、データ量を削減している。しかし、圧縮はデータの内容によってデータの削減量が変わり、データ量をほとんど削減できないケースもあるため、大量のデータを扱う場合、情報系システムのデータベースの更新処理が間に合わず、基幹系システムのデータを情報系システムにタイムリーに反映できなくなり、不正検知業務のサービスレベルを維持することが困難となる。 In Patent Document 1, a specific type of column data is compressed alone, and continuous column data other than the specific type is collectively compressed, thereby reducing the amount of data. However, because the amount of data reduction varies depending on the data content and there is a case where the amount of data cannot be reduced almost completely, when processing a large amount of data, the update processing of the database of the information system is not in time, and the data of the core system Cannot be reflected in an information system in a timely manner, and it becomes difficult to maintain the service level of fraud detection work.
　本発明の目的は、基幹系システムからの情報を反映する際に、検知業務における更新負荷に合わせて情報量を制御することにある。 An object of the present invention is to control the amount of information in accordance with the update load in the detection work when reflecting information from the backbone system.
　前記課題を解決するために、本発明は、少なくともデータベースを記憶する記憶装置と、基幹系システムからのデータ及び情報を処理する情報処理装置と、を有し、前記情報処理装置は、前記データのうち検知業務の対象となる対象データを前記データベースに反映する際に、当該対象データの更新情報を前記データベースに反映するための更新負荷を検知し、この検知結果を基に前記更新情報を前記データベースに反映するための制御を行う制御部、を有し、前記制御部は、前記検知した更新負荷に応じて前記データベースに反映すべき情報量を制御することを特徴とする。 In order to solve the above problems, the present invention includes at least a storage device that stores a database, and an information processing device that processes data and information from a backbone system, and the information processing device Among them, when reflecting the target data to be detected in the database, the update load for reflecting the update information of the target data to the database is detected, and the update information is based on the detection result. A control unit that performs control to reflect the information in the database, and the control unit controls the amount of information to be reflected in the database according to the detected update load.
　本発明によれば、基幹系システムからの情報を反映する際に、検知業務における更新負荷に合わせて情報量を制御することができる。 According to the present invention, the amount of information can be controlled in accordance with the update load in the detection work when reflecting information from the backbone system.
計算機システムの構成図である。It is a block diagram of a computer system. 除外対象外情報の除外パターン構成図である。It is an exclusion pattern block diagram of information excluding exclusion. 業務ＳＱＬ解析部の処理を説明するためのフローチャートである。It is a flowchart for demonstrating the process of the business SQL analysis part. 更新情報処理部の処理を説明するためのフローチャートである。It is a flowchart for demonstrating the process of an update information processing part. 更新時間監視部の処理を説明するためのフローチャートである。It is a flowchart for demonstrating the process of an update time monitoring part. 負荷検知部の処理を説明するためのフローチャートである。It is a flowchart for demonstrating the process of a load detection part.
　以下、本発明に係る計算機システムの実施例を図面に基づいて説明する。 Hereinafter, an embodiment of a computer system according to the present invention will be described with reference to the drawings.
　図１は、本発明に係る計算機システムの全体構成図である。図１において、計算機システムは、例えば、金融機関などの業務処理を行う基幹系システム１０と、基幹系システム１０の処理結果を業務処理に伴う業務情報として蓄積し、蓄積した業務情報を利用して、分析業務や検知業務、例えば、不正振込等の不正業務を検知するための不正検知業務の処理を実行する情報系システム５０を有し、基幹系システム１０と情報系システム５０がネットワーク１００を介して接続される。 FIG. 1 is an overall configuration diagram of a computer system according to the present invention. In FIG. 1, the computer system stores, for example, a core system 10 that performs business processing such as a financial institution, and processing results of the core system 10 as business information accompanying the business processing, and uses the stored business information. And an information system 50 that executes processing of fraud detection work for detecting fraud business such as analysis work and detection work, for example, fraudulent transfer. The backbone system 10 and the information system 50 are connected via the network 100. Connected.
　基幹系システム１０は、ＣＰＵ（Central　Processing　Unit）１２と、ネットワークインタフェース（Ｉ／Ｆ）１４と、メモリ１６と、ディスク１８を有するコンピュータシステムであって、各部が内部バス２０を介して接続される。 The backbone system 10 is a computer system having a CPU (Central Processing Unit) 12, a network interface (I / F) 14, a memory 16, and a disk 18, and each unit is connected via an internal bus 20. .
　ＣＰＵ１２は、メモリ２２に格納された各種プログラムに従って基幹系システム１０全体を統括制御する制御部として構成される。ネットワークインタフェース１４は、基幹系システム１０とネットワーク１００とを結ぶネットワークインタフェースとして構成される。 The CPU 12 is configured as a control unit that performs overall control of the entire backbone system 10 according to various programs stored in the memory 22. The network interface 14 is configured as a network interface that connects the backbone system 10 and the network 100.
　メモリ１６は、ＣＰＵ１２によって起動される複数のプログラムとして、業務処理部２２と、データ管理部２４と、レプリケーション部２６を有する。業務処理部２２は、リアルタイム性が要求される業務処理を実行する。データ管理部２４は、業務処理部２２からの指示を基にディスク１８内のデータを管理する。レプリケーション部２６は、ＣＰＵ１２からの指示を基に、ディスク１８内のデータや更新情報を情報系システム５０へ移行（レプリケーション）するための処理を実行する。 The memory 16 includes a business processing unit 22, a data management unit 24, and a replication unit 26 as a plurality of programs activated by the CPU 12. The business processing unit 22 executes business processing that requires real-time performance. The data management unit 24 manages data in the disk 18 based on an instruction from the business processing unit 22. The replication unit 26 executes processing for transferring (replicating) data and update information in the disk 18 to the information system 50 based on an instruction from the CPU 12.
　ディスク１８は、記憶装置として構成され、ディスク１８には、複数の記憶領域２８、３０が形成される。記憶領域２８にはデータベース（ＤＢ）が記憶され、記憶領域３０には業務処理部２２によって処理されたデータの更新情報が格納される。 The disk 18 is configured as a storage device, and a plurality of storage areas 28 and 30 are formed on the disk 18. A database (DB) is stored in the storage area 28, and update information of data processed by the business processing unit 22 is stored in the storage area 30.
　情報系システム５０は、ＣＰＵ５２と、ネットワークインタフェース５４と、メモリ５６と、ディスク５８を有するコンピュータシステムであって、各部が内部バス６０を介して接続される。 The information system 50 is a computer system having a CPU 52, a network interface 54, a memory 56, and a disk 58, and each unit is connected via an internal bus 60.
　ＣＰＵ５２は、メモリ５６に格納された各種プログラムに従って情報系システム５０全体を統括制御する制御部として構成される。ネットワークインタフェース５４は、情報系システム５０とネットワーク１００とを結ぶネットワークインタフェースとして構成される。 The CPU 52 is configured as a control unit that controls the entire information system 50 according to various programs stored in the memory 56. The network interface 54 is configured as a network interface that connects the information system 50 and the network 100.
　メモリ５６は、ＣＰＵ５２によって起動される複数のプログラムとして、業務処理部６２と、データ管理部６４と、レプリケーション部６６と、業務ＳＱＬ（Structured　Query　Language）解析部６８と、更新時間監視部７０と、更新情報処理部７２を有し、更新情報処理部７０は、負荷検知部７４と、更新情報除外部７６と、除外情報反映部７８から構成される。なお、ＣＰＵ５２と、ネットワークインタフェース５４と、メモリ５６と、内部バス６０は、基幹系システム１０からのデータ及び情報を処理する情報処理装置として機能する。 The memory 56 includes a business processing unit 62, a data management unit 64, a replication unit 66, a business SQL (Structured Query Language) analysis unit 68, an update time monitoring unit 70, as a plurality of programs activated by the CPU 52. The update information processing unit 72 includes a load detection unit 74, an update information exclusion unit 76, and an exclusion information reflection unit 78. The CPU 52, the network interface 54, the memory 56, and the internal bus 60 function as an information processing apparatus that processes data and information from the backbone system 10.
　業務処理部６２は、情報系システム５０における業務処理として、例えば、ディスク５８に格納されたデータベース（ＤＢ）のデータを分析するための分析業務処理、ディスク５８に格納されたデータベース（ＤＢ）のデータに関する不正振込等を検知するための検知業務（不正検知業務）処理を実行する。データ管理部６４は、業務処理部６２からの指示を基に、基幹系システム１０から転送されてデータをディスク５８内のデータベース（ＤＢ）に反映すると共に、このデータの更新情報及びこの更新情報に属する情報をディスク５８内のデータベース（ＤＢ）に反映するための処理を実行する。 The business processing unit 62 performs, as business processing in the information system 50, for example, analysis business processing for analyzing data in a database (DB) stored in the disk 58, data in the database (DB) stored in the disk 58. Execute detection work (fraud detection work) processing to detect fraudulent transfer etc. Based on the instruction from the business processing unit 62, the data management unit 64 reflects the data transferred from the backbone system 10 to the database (DB) in the disk 58, and updates the data and the update information. A process for reflecting the information belonging to the database (DB) in the disk 58 is executed.
　レプリケーション部６６は、基幹系システム１０のレプリケーション部２４の処理により、基幹系システム１０から転送されたデータ及びこのデータの更新情報を受信し、受信したデータをデータ管理部６４に転送し、受信した更新情報を更新情報処理部７０に転送するための処理を実行する。業務ＳＱＬ解析部６８は、業務処理部６２から検知業務で使用する情報として、例えばＳＱＬを入力した場合、入力したＳＱＬを解析し、解析結果として、検知業務で必要な情報（除外対象外情報）をディスク５８に格納する処理を実行する。更新時間監視部７０は、データ管理部６４が、更新情報を更新するための更新時間（更新情報をデータベースに反映するための時間）を監視する。更新情報処理部７２は、基幹系システム１０から転送された更新情報を処理する。負荷検知部７４は、データ管理部６４が、更新情報を更新する際の更新負荷が高負荷かあるいは低負荷かを検知する。更新情報除外部７６は、基幹系システム１０から転送された更新情報から、検知業務（不正検知業務）で不要な情報（除外実施情報）を除外する処理を行う。除外情報反映部７８は、更新情報除外部７６で除外された情報を除外実施情報としてディスク５８に反映する処理を行う。 The replication unit 66 receives the data transferred from the backbone system 10 and the update information of this data by the processing of the replication unit 24 of the backbone system 10, transfers the received data to the data management unit 64, and receives it A process for transferring the update information to the update information processing unit 70 is executed. The business SQL analysis unit 68 analyzes the input SQL, for example, when SQL is input from the business processing unit 62 as information used in the detection business, and as analysis results, information necessary for the detection business (information excluded from exclusion) Is stored in the disk 58. The update time monitoring unit 70 monitors the update time for the data management unit 64 to update the update information (the time for reflecting the update information in the database). The update information processing unit 72 processes the update information transferred from the backbone system 10. The load detection unit 74 detects whether the update load when the data management unit 64 updates the update information is high load or low load. The update information excluding unit 76 performs processing for excluding unnecessary information (exclusion execution information) in the detection work (fraud detection work) from the update information transferred from the backbone system 10. The exclusion information reflection unit 78 performs a process of reflecting the information excluded by the update information exclusion unit 76 on the disk 58 as exclusion implementation information.
　ディスク５８は、データ及び情報を記憶する記憶装置として構成され、ディスク５８には、複数の記憶領域８０、８２、８４、８６、８８、９０が形成される。記憶領域８０には、データ管理部６４の管理対象となるデータや業務処理部６２の処理対象となるデータを保存するデータベース（ＤＢ）が格納される。記憶領域８２には、基幹系システム１０から転送されたデータの更新情報や更新情報の更新件数に関する情報が格納される。記憶領域８４には、業務ＳＱＬ解析部６８の解析結果による、検知業務で必要な情報であって、更新情報の中から検知業務で不要な情報（除外実施情報）が除外された後の除外対象外情報（除外後更新情報）が格納される。記憶領域８６には、更新情報除外部７６で処理された情報であって、検知業務で不要な除外実施情報が格納される。記憶領域８８には、データ管理部６４が、更新情報を更新するのに要する予測時間となる平均更新時間に関する情報が格納される。記憶領域９０には、データ管理部６４が、更新情報を更新する際の制限時間となる更新期限に関する情報が格納される。この更新期限は、検知業務のサービスレベルを維持するための判定値（設定値）として、ユーザによって指定される。 The disk 58 is configured as a storage device for storing data and information, and a plurality of storage areas 80, 82, 84, 86, 88, 90 are formed on the disk 58. The storage area 80 stores a database (DB) that stores data to be managed by the data management unit 64 and data to be processed by the business processing unit 62. The storage area 82 stores data update information transferred from the backbone system 10 and information related to the number of update information updates. In the storage area 84, information that is necessary for the detection work based on the analysis result of the work SQL analysis unit 68, and is excluded after unnecessary information (exclusion execution information) is excluded from the update information. External information (update information after exclusion) is stored. The storage area 86 stores information that has been processed by the update information excluding unit 76 and that is unnecessary for detection work. The storage area 88 stores information related to an average update time that is a predicted time required for the data management unit 64 to update the update information. The storage area 90 stores information related to the update deadline that is a time limit when the data management unit 64 updates the update information. The update deadline is designated by the user as a determination value (setting value) for maintaining the service level of the detection job.
　この際、ＣＰＵ５２は、基幹系システム１０から転送されたデータのうち業務処理の対象、例えば、検知業務の対象となる対象データをディスク５８のデータベース（ＤＢ）に反映する際に、対象データの更新情報をディスク５８のデータベース（ＤＢ）に反映するための更新負荷を検知し、この検知結果を基に更新情報をデータベース（ＤＢ）に反映するための制御を行う制御部として機能し、検知した更新負荷に応じてデータベース（ＤＢ）に反映すべき情報量を制御する。例えば、更新負荷が高負荷の場合、更新情報の一部を更新し、更新すべき情報量を少なくする。また、ＣＰＵ５２は、検知した更新負荷が高負荷であると判定した場合、更新情報の中から業務処理に属する検知業務に不要な情報を除外し、検知業務に不要な情報が除外された除外後更新情報（除外対象外情報）をデータベース（ＤＢ）に反映するのに要する更新時間を予測し、予測した更新時間が更新期限内であることを条件に、除外後更新情報（除外対象外情報）をデータベース(ＤＢ)に反映する。これにより、検知業務に不要な情報はデータベース（ＤＢ）に反映されないので、検知業務に必要な除外後更新情報（除外対象外情報）のデータベース(ＤＢ)への反映を早くすることができる。なお、ＣＰＵ５２は、対象データの更新情報をデータベース（ＤＢ）に反映するのに要する更新時間を予測し、予測した更新時間が更新期限を超える場合、検知した更新負荷が高負荷であると判定する。 At this time, the CPU 52 updates the target data when reflecting the target data of the business process among the data transferred from the backbone system 10, for example, the target data to be the target of the detected business, in the database (DB) of the disk 58. Detects an update load for reflecting information in the database (DB) of the disk 58, and functions as a control unit that performs control for reflecting update information in the database (DB) based on the detection result. The amount of information to be reflected in the database (DB) is controlled according to the load. For example, when the update load is high, a part of the update information is updated to reduce the amount of information to be updated. In addition, when the CPU 52 determines that the detected update load is high, the CPU 52 excludes information unnecessary for the detection work belonging to the business process from the update information, and after the information unnecessary for the detection work is excluded. Estimated update time required to reflect update information (non-exclusion information) in the database (DB), and post-exclusion update information (exclusion-excluded information) on the condition that the predicted update time is within the update deadline Is reflected in the database (DB). Thereby, since information unnecessary for detection work is not reflected in the database (DB), post-exclusion update information (non-exclusion information) necessary for detection work can be quickly reflected in the database (DB). Note that the CPU 52 predicts the update time required to reflect the update information of the target data in the database (DB), and determines that the detected update load is high when the predicted update time exceeds the update deadline. .
　図２は、除外対象外情報の除外パターン構成図である。図２（Ａ）において、列・行の更新情報２００が、Ａ列２０１、Ｂ列２０２、Ｃ列２０３、Ｄ列２０４について、それぞれ複数行で構成され、業務処理部６２で、Ｄ列２０４に属する情報を検知業務で使用しない情報であると判断した場合、Ｄ列２０４に属する情報が、検知業務で使用しない除外実施情報として管理され、Ａ列２０１、Ｂ列２０２、Ｃ列２０３に属する情報が、検知業務で使用する除外対象外情報（除外後更新情報）として管理される。すなわち、Ａ列２０１、Ｂ列２０２、Ｃ列２０３に属する情報によって除外対象外情報が構成される。 FIG. 2 is an exclusion pattern configuration diagram of information that is not excluded. In FIG. 2A, column / row update information 200 is composed of a plurality of rows for column A 201, column B 202, column C 203, and column D 204, respectively. If it is determined that the information belonging to the information is not used in the detection job, the information belonging to the D column 204 is managed as the exclusion execution information not used in the detection job, and the information belonging to the A column 201, the B column 202, and the C column 203 Are managed as non-exclusion information (update information after exclusion) used in detection work. That is, the information that does not belong to the exclusion is configured by information belonging to the A column 201, the B column 202, and the C column 203.
　図２（Ｂ）において、列・行の更新情報３００が、Ａ列３０１、Ｂ列３０２、Ｃ列３０３、Ｄ列３０４についてそれぞれ複数行で構成され、業務処理部６２が、Ｃ列３０３に属する情報が１０００以下の行に属する情報を、検知業務で使用しない情報であると判断した場合、更新情報３００のうち、Ｃ列３０３が１０００以下となる各列の行の情報が除外実施情報として除外され、更新情報３００から、Ｃ列３０３が１０００以下となる各列の行の情報が間引かれる。すなわち、更新情報３００のうち、Ｃ列３０３が１０００以下となる各列の行の情報が除外実施情報として管理され、それ以外の情報（Ｃ列３０３が１０００を超える各列の情報の情報）が除外対象外情報（除外後更新情報）として管理される。 In FIG. 2B, column / row update information 300 includes a plurality of rows for column A 301, column B 302, column C 303, and column D 304, and the job processing unit 62 belongs to column C 303. When it is determined that the information belonging to the row whose information is 1000 or less is information that is not used in the detection operation, the information in the row of each column in which the C column 303 is 1000 or less in the update information 300 is excluded as the excluded execution information. Then, from the update information 300, the row information of each column in which the C column 303 is 1000 or less is thinned out. That is, in the update information 300, the information of the row of each column in which the C column 303 is 1000 or less is managed as the exclusion execution information, and other information (information of the information of each column in which the C column 303 exceeds 1000) is stored. It is managed as non-exclusion information (update information after exclusion).
　図２（Ｃ）において、列・行の更新情報４００が、Ａ列４０１、Ｂ列４０２、Ｃ列４０３、Ｄ列４０４についてそれぞれ複数行で構成され、業務処理部６２が、同一群に属する情報を変更して集約すると判断した場合、更新情報４００の中から集約前の情報が除外実施情報として除外される。例えば、同一群の情報として、２０１４年１２月１日が用いられた場合、各列の１行と２行の情報が集約され、集約された情報が、－１行に追加される。この場合、各列の情報について、３行から１０行の情報が除外対象外情報（除外後更新情報）として管理される。なお、－１行に追加された情報は、１行と２行に記録された除外実施情報をディスク５８に反映する際に削除される。 In FIG. 2C, the column / row update information 400 is composed of a plurality of rows for the A column 401, the B column 402, the C column 403, and the D column 404, and the business processing unit 62 belongs to the same group. If it is determined that the information is to be aggregated, the information before aggregation is excluded from the update information 400 as the exclusion execution information. For example, if December 1, 2014 is used as the same group of information, the information on the first and second rows of each column is aggregated, and the aggregated information is added to the −1 row. In this case, for the information in each column, the information from the 3rd row to the 10th row is managed as non-exclusion information (update information after exclusion). The information added to the -1 line is deleted when the exclusion execution information recorded in the 1st and 2nd lines is reflected on the disc 58.
　図３は、業務ＳＱＬ解析部の処理を説明するためのフローチャートである。この処理は、ＣＰＵ５２が、業務ＳＱＬ解析部６８を起動することによって開始される。 FIG. 3 is a flowchart for explaining the processing of the business SQL analysis unit. This process is started when the CPU 52 activates the business SQL analysis unit 68.
　業務ＳＱＬ解析部６８は、業務処理部６２から検知業務の業務ＳＱＬを読み込む（Ｓ１０）。この後、業務ＳＱＬ解析部６８は、業務ＳＱＬ中の表名、列名、条件を取得し（Ｓ１１）、取得した表名、列名、条件を検知業務（不正検知業務）に必要な情報、すなわち、除外対象外情報として記憶領域８４に記録し（Ｓ１２）、このルーチンでの処理を終了する。 The business SQL analysis unit 68 reads the business SQL of the detected business from the business processing unit 62 (S10). Thereafter, the business SQL analysis unit 68 acquires the table name, column name, and condition in the business SQL (S11), and acquires the acquired table name, column name, and condition information necessary for the detection business (fraud detection business), That is, it is recorded in the storage area 84 as information not to be excluded (S12), and the processing in this routine is terminated.
　図４は、更新情報処理部の処理を説明するためのフローチャートである。この処理は、ＣＰＵ５２が、更新情報処理部７２を起動することによって開始される。更新情報処理部７２は、監視時間監視部７０と業務ＳＱＬ解析部６８の処理がそれぞれ実行済みであることを条件に処理を実行する。この際、負荷検知部７４によって計算される更新負荷に合わせ、更新情報から、業務ＳＱＬ解析部６８の解析結果である、検知業務に不要な情報である除外実施情報が除外され、除外後の更新情報が除外後更新情報としてデータ管理部６４に送信される。除外実施情報が除外された後の更新情報（除外後更新情報）は、データ管理部６４によって記憶領域８２に格納され、その後、記録領域８０のデータベース（ＤＢ）に反映される。また、除外実施情報は、除外情報反映部７８によって、データ管理部６４に送信された後、記憶領域８６に格納され、その後、負荷検知部７４によって計算される更新負荷が低い場合、記録領域８０のデータベース（ＤＢ）に反映される。 FIG. 4 is a flowchart for explaining the processing of the update information processing unit. This process is started when the CPU 52 activates the update information processing unit 72. The update information processing unit 72 executes the process on the condition that the processes of the monitoring time monitoring unit 70 and the business SQL analysis unit 68 have been executed. At this time, in accordance with the update load calculated by the load detection unit 74, exclusion execution information that is unnecessary information for detection work, which is an analysis result of the work SQL analysis unit 68, is excluded from the update information. The information is transmitted to the data management unit 64 as post-exclusion update information. The update information after the exclusion implementation information is excluded (update information after exclusion) is stored in the storage area 82 by the data management unit 64 and then reflected in the database (DB) of the recording area 80. Further, the exclusion execution information is transmitted to the data management unit 64 by the exclusion information reflecting unit 78 and then stored in the storage area 86. After that, when the update load calculated by the load detection unit 74 is low, the recording area 80 Are reflected in the database (DB).
　具体的には、更新情報処理部７２は、まず負荷検知部７４を起動して、負荷検知部７４による負荷検知を実行させる（Ｓ２０）。負荷検知部７４による負荷検知の結果、更新情報を除外しないでも更新期限内に更新が可能か否かを判定する（Ｓ２１）。例えば、更新情報の中から検知業務に不要な情報（除外実施情報）を除外しなくても、更新情報を更新期限内に更新することが可能か否かを判定する。すなわち、更新情報処理部７２は、負荷検知部７４の検知結果から、更新負荷が低負荷か否かを判定する。 Specifically, the update information processing unit 72 first activates the load detection unit 74 and causes the load detection unit 74 to perform load detection (S20). As a result of the load detection by the load detection unit 74, it is determined whether or not the update can be performed within the update time limit without excluding the update information (S21). For example, it is determined whether or not the update information can be updated within the update deadline without excluding information unnecessary for detection work (exclusion execution information) from the update information. That is, the update information processing unit 72 determines whether or not the update load is a low load from the detection result of the load detection unit 74.
　ステップＳ２１で肯定の判定結果を得た場合、すなわち、更新負荷が低負荷であって、更新情報の中から除外実施情報を除外しなくても、更新情報を更新期限内に更新することが可能である場合、更新情報処理部７２は、更新情報に属する除外実施情報の中に、既に更新情報除外部７６によって除外された情報があるか否かを判定する（Ｓ２２）。ステップＳ２２で肯定の判定結果を得た場合、更新情報処理部７２は、更新情報に、例えば、既に除外された列情報（除外実施情報として記録された情報）を、負荷検知部７４の負荷検知で算出した列数分追加し（Ｓ２３）、ステップＳ３０の処理に移行する。なお、ステップＳ２２で否定の判定結果を得た場合、ステップＳ３０の処理に移行する。 When an affirmative determination result is obtained in step S21, that is, the update load is low and the update information can be updated within the update deadline without excluding the exclusion execution information from the update information. If so, the update information processing unit 72 determines whether there is information already excluded by the update information exclusion unit 76 in the exclusion implementation information belonging to the update information (S22). When an affirmative determination result is obtained in step S22, the update information processing unit 72 uses, for example, already excluded column information (information recorded as exclusion implementation information) in the update information. (S23), and the process proceeds to step S30. If a negative determination result is obtained in step S22, the process proceeds to step S30.
　一方、ステップＳ２１で否定の判定結果を得た場合、すなわち、更新負荷が高負荷であって、更新情報の中から除外実施情報を除外しないと、更新情報を更新期限内に更新することが不可能と判定した場合、更新情報処理部７２は、検知業務に必要な情報となる除外対象外情報から、表名、列名、条件を読み込み（Ｓ２４）、更新情報の中に除外対象外情報だけが存在するか否かを判定する（Ｓ２５）。 On the other hand, if a negative determination result is obtained in step S21, that is, if the update load is high and the exclusion execution information is not excluded from the update information, the update information cannot be updated within the update deadline. If it is determined that it is possible, the update information processing unit 72 reads the table name, column name, and condition from the non-exclusion information that is information necessary for the detection work (S24), and only the non-exclusion information is included in the update information. Whether or not exists is determined (S25).
　ステップＳ２５で否定の判定結果を得た場合、すなわち、更新情報が、除外対象外情報のみで構成されている場合、更新情報処理部７２は、内部バス６０に接続された表示装置（図示せず）の画面上に警告メッセージを表示するための処理を実行し、ステップＳ３０の処理に移行する。 When a negative determination result is obtained in step S25, that is, when the update information is composed only of information not to be excluded, the update information processing unit 72 displays a display device (not shown) connected to the internal bus 60. ) Is executed to display a warning message on the screen, and the process proceeds to step S30.
　ステップＳ２５で肯定の判定結果を得た場合、すなわち、更新情報の中に除外対象外情報以外の情報が存在する場合、更新情報処理部７２は、更新情報から、除外対象外情報に一致しない情報を除外・集約し（Ｓ２７）、除外対象外情報に一致しない情報を除外・集約した後の更新情報（除外後更新情報）を更新期限内に更新することが可能か否かを判定する（Ｓ２８）。 When an affirmative determination result is obtained in step S25, that is, when information other than the excluded information is present in the update information, the update information processing unit 72 determines that the information that does not match the excluded information from the updated information. Are excluded / aggregated (S27), and it is determined whether update information (update information after exclusion) after excluding / aggregating information that does not match information that is not excluded can be updated within the update deadline (S28). ).
　ステップＳ２８で否定の判定結果を得た場合、すわわち、除外対象外情報に一致しない情報を除外・集約した後の更新情報（除外後更新情報）を更新期限内に更新できない場合、更新情報処理部７２は、表示装置（図示せず）の画面上に警告メッセージを表示するための処理を実行し、ステップＳ３０の処理に移行する。 If a negative determination result is obtained in step S28, that is, if the update information (excluded update information) after exclusion / aggregation of information that does not match the non-exclusion information cannot be updated within the update deadline, the update information The processing unit 72 executes a process for displaying a warning message on the screen of a display device (not shown), and proceeds to the process of step S30.
　ステップＳ２８で肯定の判定結果を得た場合、すなわち、除外対象外情報に一致しない情報を除外・集約した後の更新情報（除外後更新情報）を更新期限内に更新可能である場合、すなわち、更新負荷が低負荷となった場合、更新情報処理部７２は、更新情報から、除外対象外情報に一致しない情報として除外・集約された情報を除外実施情報として管理し、この除外実施情報をディスク５８の記憶領域８６に記録し、ステップＳ３０の処理に移行する。 When an affirmative determination result is obtained in step S28, that is, when update information after exclusion / aggregation of information that does not match the exclusion target information (update information after exclusion) can be updated within the update deadline, When the update load becomes low, the update information processing unit 72 manages the information excluded / aggregated as information that does not match the information not to be excluded from the update information as the exclusion execution information. 58, and the process proceeds to step S30.
　ステップＳ３０において、更新情報処理部７２は、ステップＳ２２、Ｓ２３の処理が実行された場合、除外対象外情報と除外実施情報を含む全ての情報を更新情報としてデータ管理部６４に送信し、ステップＳ２９の処理が実行された場合、除外対象外情報に一致しない情報を除外・集約した後の更新情報（除外後更新情報）をデータ管理部６４に送信し、Ｓ２６の処理が実行された場合、除外対象外情報を含む更新情報をデータ管理部６４に送信する。データ管理部６４に送信された更新情報または更新情報に属する情報は、その後、記憶領域８０のデータベース（ＤＢ）に反映される。 In step S30, when the processes of steps S22 and S23 are executed, the update information processing unit 72 transmits all information including the exclusion target information and the exclusion implementation information to the data management unit 64 as update information, and step S29. When the process is executed, update information (excluded update information) after exclusion / aggregation of information that does not match the information excluded from exclusion is transmitted to the data management unit 64, and when the process of S26 is executed, Update information including non-target information is transmitted to the data management unit 64. The update information transmitted to the data management unit 64 or information belonging to the update information is then reflected in the database (DB) of the storage area 80.
　図５は、更新時間監視部の処理を説明するためのフローチャートである。この処理は、ＣＰＵ５２が、更新時間監視部７０を起動することによって開始される。 FIG. 5 is a flowchart for explaining the processing of the update time monitoring unit. This process is started when the CPU 52 activates the update time monitoring unit 70.
　更新時間監視部７２は、データ管理部６４が、更新情報を記憶領域８０のデータベース（ＤＢ）に反映する更新情報反映時間から、１件当たりの更新時間を算出する。 The update time monitoring unit 72 calculates an update time per item from the update information reflection time when the data management unit 64 reflects the update information in the database (DB) of the storage area 80.
　具体的には、更新時間監視部７０は、データ管理部６４が、更新情報を記憶領域８０のデータベース（ＤＢ）に反映するデータベース反映開始時間を検知し（Ｓ４０）、次に、データ管理部６４が、更新情報を記憶領域８０のデータベース（ＤＢ）に反映するのを終了するデータベース反映終了時間を検知し（Ｓ４１）、データベース反映開始時間からデータベース反映終了時間までのデータベース反映監視時間を算出し、算出したデータベース反映時間とデータベース反映件数とから、１件当たりの平均更新時間を算出する（Ｓ４２）。 Specifically, the update time monitoring unit 70 detects the database reflection start time when the data management unit 64 reflects the update information in the database (DB) of the storage area 80 (S40), and then the data management unit 64. Detects the database reflection end time when the update information is reflected in the database (DB) of the storage area 80 (S41), calculates the database reflection monitoring time from the database reflection start time to the database reflection end time, An average update time per case is calculated from the calculated database reflection time and the number of database reflections (S42).
　この後、更新時間監視部７０は、データ管理部６４では、検知業務で必要な除外対象外情報（除外後更新情報）のみのデータベース（ＤＢ）反映であったか否かを判定する（Ｓ４３）。 After that, the update time monitoring unit 70 determines whether or not the data management unit 64 reflects the database (DB) of only the excluded information (update information after exclusion) necessary for the detection work (S43).
　ステップＳ４３で否定の判定結果を得た場合、すなわち、除外対象外情報と除外実施情報を含む更新情報がデータベース（ＤＢ）に反映された場合、更新時間監視部７０は、除外対象外情報と除外実施情報を含む更新情報の更新時間を除外前平均更新時間とし、この除外前平均更新時間を平均更新時間として記録し（Ｓ４４）、このルーチンでの処理を終了する。 When a negative determination result is obtained in step S43, that is, when update information including exclusion exclusion information and exclusion implementation information is reflected in the database (DB), the update time monitoring unit 70 determines exclusion exclusion information and exclusion The update time of the update information including the implementation information is set as the average update time before exclusion, the average update time before exclusion is recorded as the average update time (S44), and the processing in this routine is ended.
　一方、ステップＳ４３で肯定の判定結果を得た場合、すなわち、データ管理部６４が、検知業務に必要な情報である除外対象外情報（除外後更新情報）のみをデータベース（ＤＢ）に反映した場合、更新時間監視部７０は、更新情報から除外実施情報が除外され、除外対象外情報のみの更新情報（除外後更新情報）の更新時間を除外後平均更新時間とし、この除外後平均更新時間を平均更新時間として記録し（Ｓ４５）、このルーチンでの処理を終了する。 On the other hand, when an affirmative determination result is obtained in step S43, that is, when the data management unit 64 reflects only non-exclusion information (update information after exclusion) that is information necessary for detection work in the database (DB). The update time monitoring unit 70 excludes the exclusion execution information from the update information, sets the update time of the update information (excluded update information) of only the excluded information as the average update time after exclusion, and sets the average update time after exclusion as the average update time after exclusion. The average update time is recorded (S45), and the processing in this routine is terminated.
　図６は、負荷検知部の処理を説明するためのフローチャートである。この処理は、ＣＰＵ５２が、負荷検知部７４を起動することによって開始される。 FIG. 6 is a flowchart for explaining the processing of the load detection unit. This process is started when the CPU 52 activates the load detection unit 74.
　負荷検知部７４は、更新すべき更新情報の件数と平均更新時間から、更新期限内に更新が完了するか否かの計算を行う。更新期限内に更新が完了する場合、低負荷となり、更新期限内に更新が完了しない場合、高負荷となる。 The load detection unit 74 calculates whether the update is completed within the update deadline from the number of pieces of update information to be updated and the average update time. When the update is completed within the update deadline, the load is low, and when the update is not completed within the update deadline, the load is high.
　まず、負荷検知部７４は、更新時間監視部７０から、除外前平均更新時間と除外後平均更新時間を読み込む（Ｓ５０）。 First, the load detection unit 74 reads the average update time before exclusion and the average update time after exclusion from the update time monitoring unit 70 (S50).
　次に、負荷検知部７４は、記憶領域８２から更新情報の更新件数を読み込み、記憶領域９０から更新期限を読み込む（Ｓ５１）。 Next, the load detection unit 74 reads the number of update information updates from the storage area 82 and reads the update deadline from the storage area 90 (S51).
　次に、負荷検知部７４は、呼び出し元、例えば更新情報処理部に、更新期限－（更新件数×除外前平均更新時間）の値と、（更新期限－（更新件数×除外前平均更新時間）/除外前平均更新時間の値と、除外後平均更新時間と更新件数を通知し（Ｓ５２）、このルーチンでの処理を終了する。 Next, the load detection unit 74 informs the caller, for example, the update information processing unit, the value of update deadline− (number of updates × average update time before exclusion) and (update deadline− (number of updates × average update time before exclusion)). The value of the average update time before exclusion, the average update time after exclusion and the number of updates are notified (S52), and the processing in this routine is terminated.
　更新期限－（更新件数×除外前平均更新時間）の値は、更新情報の中から除外実施情報を除外しない場合でも更新期限内に更新が完了するか否かを判定するための値となる。この値が正の場合には、更新情報として除外対象外情報と除外実施情報を含む場合であっても、更新期限内に更新が完了することになる。またこの値が負となる場合には、更新情報から除外実施情報が除外され、除外対象外情報（除外後更新情報）のみの更新情報が、除外後平均更新時間で、更新期限内に更新が完了するか否かが判定される。 The value of update deadline-(number of updates x average update time before exclusion) is a value for determining whether or not the update is completed within the update deadline even if the exclusion execution information is not excluded from the update information. When this value is positive, the update is completed within the update deadline even if the update information includes non-exclusion information and exclusion implementation information. In addition, when this value is negative, the exclusion implementation information is excluded from the update information, and the update information of only the non-exclusion information (update information after exclusion) is updated within the update deadline with the average update time after exclusion. It is determined whether or not to complete.
　更新期限－（更新件数×除外前平均更新時間）/除外前平均更新時間の値は、更新期限内に追加できる、除外実施情報の数である。この値は、更新情報の中から除外実施情報を除外した後、除外実施情報をデータベースに反映する場合に用いられる。 Renewal deadline-(Number of updates x average renewal time before exclusion) / average renewal time before exclusion is the number of exclusion implementation information that can be added within the renewal deadline. This value is used when the exclusion implementation information is reflected in the database after the exclusion implementation information is excluded from the update information.
　上述したように、制御部に属するプログラム（ソフトウェア）のうち、更新時間監視部７０は、基幹系システム１０からのデータのうち検知業務の対象となる対象データの更新情報をデータベース（ＤＢ）に反映するのに要する更新時間を除外前更新時間として予測し、更新情報の中から検知業務に不要な情報が除外された除外後更新情報をデータベース（ＤＢ）に反映するのに要する更新時間を除外後更新時間として予測する。負荷検知部７４は、更新時間監視部７０の予測結果と更新期限とを比較して、除外前更新時間又は除外後更新時間が更新期限を超える場合、更新負荷が高負荷であると判定し、除外前更新時間又は除外後更新時間が更新期限内である場合、更新負荷が低負荷であると判定する。更新情報処理部７２は、除外前更新時間が更新期限を超えて、負荷検知部７４の判定結果が、高負荷である場合、更新情報の中から検知業務に不要な情報を除外し、更新情報の中から検知業務に必要な情報として除外後更新情報を抽出する。これにより、更新情報と除外後更新情報とを切り分けることができる。データ管理部６４は、負荷検知部７４の判定結果を基に少なくとも更新情報又は除外後更新情報をデータベース（ＤＢ）に反映する。この際、データ管理部６４は、除外後更新時間が更新期限内であって、負荷検知部７４の判定結果が、低負荷であることを条件に、除外後更新情報をデータベース（ＤＢ）に反映することができる。 As described above, among the programs (software) belonging to the control unit, the update time monitoring unit 70 reflects the update information of the target data to be detected in the data from the backbone system 10 in the database (DB). The update time required for the update is predicted as the update time before exclusion, and the update time required for reflecting the update information after exclusion from which unnecessary information is excluded from the update information to the database (DB) is excluded Predict as update time. The load detection unit 74 compares the prediction result of the update time monitoring unit 70 with the update deadline, and determines that the update load is high when the update time before exclusion or the update time after exclusion exceeds the update deadline, When the update time before exclusion or the update time after exclusion is within the update deadline, it is determined that the update load is low. If the update time before exclusion exceeds the update deadline and the determination result of the load detection unit 74 is a high load, the update information processing unit 72 excludes information unnecessary for detection work from the update information, and updates the update information. The post-exclusion update information is extracted from the list as information required for detection work. Thereby, update information and post-exclusion update information can be separated. The data management unit 64 reflects at least update information or post-exclusion update information in the database (DB) based on the determination result of the load detection unit 74. At this time, the data management unit 64 reflects the post-exclusion update information in the database (DB) on the condition that the post-exclusion update time is within the update deadline and the determination result of the load detection unit 74 is low load. can do.
　また、更新時間監視部７０は、更新情報毎に除外前更新時間をその平均を示す除外前平均更新時間として予測し、更新情報毎に除外後更新時間をその平均を示す除外後平均更新時間として予測する。これにより、更新情報を更新するための更新時間を予測することができる。負荷検知部７４は、更新時間監視部７０の予測結果として、更新情報の更新件数と除外前平均更新時間との乗算値又は更新情報の更新件数と除外後平均更新時間との乗算値を用いることになる。さらに、データ管理部６４は、除外前更新時間が更新期限内であって、負荷検知部７４の判定結果が、低負荷であることを条件に、更新情報の中から除外された情報であって、検知業務に不要な情報をデータベース（ＤＢ）に反映することができる。これにより、更新情報に属する全ての情報を更新期限内にデータベース（ＤＢ）に反映することができる。 Further, the update time monitoring unit 70 predicts the update time before exclusion for each update information as the average update time before exclusion indicating the average, and sets the update time after exclusion as the average update time after exclusion indicating the average for each update information. Predict. Thereby, the update time for updating the update information can be predicted. The load detection unit 74 uses, as the prediction result of the update time monitoring unit 70, a multiplication value of the number of update information updates and the average update time before exclusion or a multiplication value of the update information update number and the average update time after exclusion. become. Furthermore, the data management unit 64 is information excluded from the update information on the condition that the update time before exclusion is within the update deadline and the determination result of the load detection unit 74 is low load. Information unnecessary for detection work can be reflected in the database (DB). Thereby, all the information belonging to the update information can be reflected in the database (DB) within the update deadline.
　本実施例によれば、基幹系システム１０からの情報を情報系システム５０に反映する際に、検知業務における更新負荷に合わせて、即ち、更新負荷の高低に合わせて情報量を制御することができる。このため、更新負荷の高負荷時に、更新情報の一部の情報（除外後更新情報）のみを更新期限内に更新することで、検知業務以外の業務の性能に影響を与えることなく、検知業務のサービスレベルを維持することができる。 According to the present embodiment, when the information from the backbone system 10 is reflected in the information system 50, the amount of information can be controlled according to the update load in the detection work, that is, according to the level of the update load. it can. For this reason, when the update load is high, only a part of the update information (update information after exclusion) is updated within the update deadline, so that the detection work is not affected without affecting the performance of the work other than the detection work. Service levels can be maintained.
　また、本実施例によれば、更新負荷が高負荷である場合、更新情報の中から業務処理に属する検知業務に不要な情報を除外し、検知業務に不要な情報が除外された除外後更新情報をデータベース（ＤＢ）に反映するのに要する更新時間を予測し、予測した更新時間が更新期限内であることを条件に、除外後更新情報をデータベース（ＤＢ）に反映するようにしたので、データベース（ＤＢ）に対する更新処理を遅れることなく完了させることができる。また、検知業務に不要な情報として除外され除外実施情報を更新負荷の低負荷時にデータベース（ＤＢ）に反映することができる。 Also, according to the present embodiment, when the update load is high, the information unnecessary for the detection work belonging to the business process is excluded from the update information, and the information unnecessary for the detection work is excluded and the update is performed after the exclusion. Since the update time required to reflect the information in the database (DB) is predicted and the post-exclusion update information is reflected in the database (DB) on the condition that the predicted update time is within the update deadline. The update process for the database (DB) can be completed without delay. Further, the exclusion execution information that is excluded as information unnecessary for detection work can be reflected in the database (DB) when the update load is low.
　なお、本発明は上記した実施例に限定されるものではなく、様々な変形例が含まれる。例えば、上記した実施例は本発明を分かりやすく説明するために詳細に説明したものであり、必ずしも説明した全ての構成を備えるものに限定されるものではない。また、実施例の構成の一部を他の構成に置き換えることが可能であり、また、実施例の構成の一部について、他の構成の追加・削除・置換をすることが可能である。 In addition, this invention is not limited to the above-mentioned Example, Various modifications are included. For example, the above-described embodiments have been described in detail for easy understanding of the present invention, and are not necessarily limited to those having all the configurations described. Further, it is possible to replace a part of the configuration of the embodiment with another configuration, and it is possible to add, delete, and replace another configuration with respect to a part of the configuration of the embodiment.
　また、上記の各構成、機能等は、それらの一部又は全部を、例えば、集積回路で設計する等によりハードウェアで実現してもよい。また、上記の各構成、機能等は、プロセッサがそれぞれの機能を実現するプログラムを解釈し、実行することによりソフトウェアで実現してもよい。各機能を実現するプログラム、テーブル、ファイル等の情報は、メモリや、ハードディスク、ＳＳＤ（Solid　State　Drive）等の記録装置、または、ＩＣカード、ＳＤカード、ＤＶＤ等の記録媒体に記録して置くことができる。 Also, each of the above-described configurations, functions, etc. may be realized by hardware by designing a part or all of them, for example, by an integrated circuit. Each of the above-described configurations, functions, and the like may be realized by software by interpreting and executing a program that realizes each function by the processor. Information such as programs, tables, and files that realize each function must be recorded on a recording device such as a memory, hard disk, SSD (Solid State Drive), or a recording medium such as an IC card, SD card, or DVD. Can do.
　１０　基幹系システム、１２　ＣＰＵ、１６　メモリ、１８　ディスク、５０　情報系システム、５２　ＣＰＵ、５６　メモリ、５８　ディスク、６２　業務処理部、６４　データ管理部、６６　レプリケーション部、６８　業務ＳＱＬ解析部、７０　更新時間監視部、７２　更新情報処理部、７４　負荷検知部、７６　更新情報除外部、７８　除外情報反映部、８０～９０　記憶領域。 10 core system, 12 CPU, 16 memory, 18 disk, 50 information system, 52 CPU, 56 memory, 58 disk, 62 business processing unit, 64 data management unit, 66 replication unit, 68 business SQL analysis unit, 70 update Time monitoring unit, 72 update information processing unit, 74 load detection unit, 76 update information exclusion unit, 78 exclusion information reflection unit, 80-90 storage area.

Claims (14)

  1. 　少なくともデータベースを記憶する記憶装置と、
    　基幹系システムからのデータ及び情報を処理する情報処理装置と、を有し、
    　前記情報処理装置は、
    　前記データのうち検知業務の対象となる対象データを前記データベースに反映する際に、当該対象データの更新情報を前記データベースに反映するための更新負荷を検知し、この検知結果を基に前記更新情報を前記データベースに反映するための制御を行う制御部、を有し、
    　前記制御部は、
    　前記検知した更新負荷に応じて前記データベースに反映すべき情報量を制御することを特徴とする情報系システム。     A storage device for storing at least a database;
    An information processing device that processes data and information from the backbone system,
    The information processing apparatus includes:
    When reflecting the target data to be detected in the data among the data to the database, an update load for reflecting the update information of the target data to the database is detected, and the update information is based on the detection result. A control unit that performs control for reflecting the data in the database,
    The controller is
    An information system that controls an amount of information to be reflected in the database according to the detected update load.
  2. 　請求項１に記載の情報系システムであって、
    　前記制御部は、
    　前記検知した更新負荷が高負荷であると判定した場合、前記更新情報の中から前記検知業務に不要な情報を除外し、前記検知業務に不要な情報が除外された除外後更新情報を前記データベースに反映するのに要する更新時間を予測し、当該予測した更新時間が更新期限内であることを条件に、前記除外後更新情報を前記データベースに反映することを特徴とする情報系システム。     The information system according to claim 1,
    The controller is
    When it is determined that the detected update load is high, information unnecessary for the detection job is excluded from the update information, and the post-exclusion update information from which the information unnecessary for the detection job is excluded is stored in the database. An information system that predicts an update time required for reflection in the database and reflects the post-exclusion update information in the database on condition that the predicted update time is within an update deadline.
  3. 　請求項２に記載の情報系システムであって、
    　前記制御部は、
    　前記対象データの更新情報を前記データベースに反映するのに要する更新時間を予測し、当該予測した更新時間が前記更新期限を超える場合、前記検知した更新負荷が高負荷であると判定することを特徴とする情報系システム。     The information system according to claim 2,
    The controller is
    An update time required to reflect the update information of the target data in the database is predicted, and when the predicted update time exceeds the update deadline, it is determined that the detected update load is a high load. Information system.
  4. 　請求項１に記載の情報系システムであって、
    　前記制御部は、
    　前記対象データの更新情報を前記データベースに反映するのに要する更新時間を除外前更新時間として予測し、前記更新情報の中から検知業務に不要な情報が除外された除外後更新情報を前記データベースに反映するのに要する更新時間を除外後更新時間として予測する更新時間監視部と、
    　前記更新時間監視部の予測結果と更新期限とを比較して、前記除外前更新時間又は前記除外後更新時間が前記更新期限を超える場合、前記更新負荷が高負荷であると判定し、前記除外前更新時間又は前記除外後更新時間が前記更新期限内である場合、前記更新負荷が低負荷であると判定する負荷検知部と、
    　前記除外前更新時間が前記更新期限を超えて、前記負荷検知部の判定結果が、高負荷である場合、前記更新情報の中から検知業務に不要な情報を除外し、前記更新情報の中から前記検知業務に必要な情報として前記除外後更新情報を抽出する更新情報処理部と、
    　前記負荷検知部の判定結果を基に少なくとも前記更新情報又は前記除外後更新情報を前記データベースに反映するデータ管理部と、を有し、
    　前記データ管理部は、
    　前記除外後更新時間が前記更新期限内であって、前記負荷検知部の判定結果が、低負荷であることを条件に、前記除外後更新情報を前記データベースに反映することを特徴とする情報系システム。     The information system according to claim 1,
    The controller is
    An update time required to reflect the update information of the target data in the database is predicted as an update time before exclusion, and post-exclusion update information in which unnecessary information for detection work is excluded from the update information in the database. An update time monitoring unit that predicts an update time required for reflection as an update time after exclusion;
    Compare the prediction result of the update time monitoring unit and the update deadline, and if the update time before exclusion or the update time after exclusion exceeds the update deadline, the update load is determined to be high, and the exclusion A load detector that determines that the update load is low when the update time before update or the update time after exclusion is within the update deadline;
    When the pre-exclusion update time exceeds the update deadline, and the determination result of the load detection unit is a high load, information unnecessary for detection work is excluded from the update information, and from the update information An update information processing unit that extracts the post-exclusion update information as information necessary for the detection operation;
    A data management unit that reflects at least the update information or the post-exclusion update information in the database based on the determination result of the load detection unit,
    The data management unit
    An information system characterized in that the post-exclusion update information is reflected in the database on the condition that the post-exclusion update time is within the update deadline and the determination result of the load detection unit is a low load. system.
  5. 　請求項４に記載の情報系システムであって、
    　前記更新時間監視部は、
    　前記更新情報毎に前記除外前更新時間をその平均を示す除外前平均更新時間として予測し、前記更新情報毎に前記除外後更新時間をその平均を示す除外後平均更新時間として予測し、
    　前記負荷検知部は、
    　前記更新時間監視部の予測結果として、前記更新情報の更新件数と前記除外前平均更新時間との乗算値又は前記更新情報の更新件数と前記除外後平均更新時間との乗算値を用いることを特徴とする情報系システム。     The information system according to claim 4,
    The update time monitoring unit
    Predicting the update time before exclusion for each update information as an average update time before exclusion indicating the average, predicting the update time after exclusion as an average update time after exclusion indicating the average for each update information,
    The load detector is
    As the prediction result of the update time monitoring unit, a multiplication value of the number of updates of the update information and the average update time before exclusion or a multiplication value of the number of updates of the update information and the average update time after exclusion is used. Information system.
  6. 　請求項４に記載の情報系システムであって、
    　前記更新情報処理部は、
    　前記更新情報の中から前記検知業務に必要な情報として前記除外後更新情報を抽出する際に、業務ＳＱＬ中の列・行の情報を用いることを特徴とする情報系システム。     The information system according to claim 4,
    The update information processing unit
    An information system characterized by using column / row information in business SQL when extracting post-exclusion update information as information necessary for the detection business from the update information.
  7. 　請求項４に記載の情報系システムであって、
    　前記データ管理部は、
    　前記除外前更新時間が前記更新期限内であって、前記負荷検知部の判定結果が、低負荷であることを条件に、前記更新情報の中から除外された情報であって、前記検知業務に不要な情報を前記データベースに反映することを特徴とする情報系システム。     The information system according to claim 4,
    The data management unit
    On the condition that the pre-exclusion update time is within the update deadline and the determination result of the load detection unit is a low load, the information is excluded from the update information, and An information system characterized in that unnecessary information is reflected in the database.
  8. 　少なくともデータベースを記憶する記憶装置と、
    　基幹系システムからのデータ及び情報を処理する情報処理装置と、を有する情報系システムにおけるデータベース管理方法であって、
    　前記情報処理装置は、
    　前記データのうち検知業務の対象となる対象データを前記データベースに反映する際に、当該対象データの更新情報を前記データベースに反映するための更新負荷を検知し、この検知結果を基に前記更新情報を前記データベースに反映するための制御を行う制御部、を有し、
    　前記制御部が、前記検知した更新負荷に応じて前記データベースに反映すべき情報量を制御するステップを有することを特徴とするデータベース管理方法。     A storage device for storing at least a database;
    A database management method in an information system having an information processing device that processes data and information from a backbone system,
    The information processing apparatus includes:
    When reflecting the target data to be detected in the data among the data to the database, an update load for reflecting the update information of the target data to the database is detected, and the update information is based on the detection result. A control unit that performs control for reflecting the data in the database,
    The database management method comprising: a step of controlling the amount of information to be reflected in the database according to the detected update load.
  9. 　請求項８に記載のデータベース管理方法であって、
    　前記制御部は、
    　前記ステップで前記検知した更新負荷が高負荷であると判定した場合、前記更新情報の中から前記検知業務に不要な情報を除外し、前記検知業務に不要な情報が除外された除外後更新情報を前記データベースに反映するのに要する更新時間を予測し、当該予測した更新時間が更新期限内であることを条件に、前記除外後更新情報を前記データベースに反映することを特徴とするデータベース管理方法。     The database management method according to claim 8, comprising:
    The controller is
    When it is determined that the detected update load is a high load in the step, information unnecessary for the detection job is excluded from the update information, and post-exclusion update information in which the information unnecessary for the detection job is excluded A database management method for predicting an update time required for reflecting the information in the database and reflecting the post-exclusion update information in the database on the condition that the predicted update time is within an update time limit. .
  10. 　請求項９に記載のデータベース管理方法であって、
    　前記制御部は、
    　前記対象データの更新情報を前記データベースに反映するのに要する更新時間を予測し、当該予測した更新時間が前記更新期限を超える場合、前記検知した更新負荷が高負荷であると判定することを特徴とするデータベース管理方法。     The database management method according to claim 9, comprising:
    The controller is
    An update time required to reflect the update information of the target data in the database is predicted, and when the predicted update time exceeds the update deadline, it is determined that the detected update load is a high load. Database management method.
  11. 　請求項８に記載のデータベース管理方法であって、
    　前記制御部は、
    　前記対象データの更新情報を前記データベースに反映するのに要する更新時間を除外前更新時間として予測し、前記更新情報の中から検知業務に不要な情報が除外された除外後更新情報を前記データベースに反映するのに要する更新時間を除外後更新時間として予測する更新時間監視ステップと、
    　前記更新時間監視ステップの予測結果と更新期限とを比較して、前記除外前更新時間又は前記除外後更新時間が前記更新期限を超える場合、前記更新負荷が高負荷であると判定し、前記除外前更新時間又は前記除外後更新時間が前記更新期限内である場合、前記更新負荷が低負荷であると判定する負荷検知ステップと、
    　前記除外前更新時間が前記更新期限を超えて、前記負荷検知ステップの判定結果が、高負荷である場合、前記更新情報の中から検知業務に不要な情報を除外し、前記更新情報の中から前記検知業務に必要な情報として前記除外後更新情報を抽出する更新情報処理ステップと、
    　前記負荷検知ステップの判定結果を基に少なくとも前記更新情報又は前記除外後更新情報を前記データベースに反映するデータ管理ステップと、を実行し、
    　前記データ管理ステップでは、
    　前記除外後更新時間が前記更新期限内であって、前記負荷検知ステップの判定結果が、低負荷であることを条件に、前記除外後更新情報を前記データベースに反映することを特徴とするデータベース管理方法。     The database management method according to claim 8, comprising:
    The controller is
    An update time required to reflect the update information of the target data in the database is predicted as an update time before exclusion, and post-exclusion update information in which unnecessary information for detection work is excluded from the update information in the database. An update time monitoring step for predicting an update time required for reflection as an update time after exclusion,
    Comparing the prediction result of the update time monitoring step with the update deadline, if the update time before exclusion or the update time after exclusion exceeds the update deadline, the update load is determined to be high, and the exclusion A load detection step for determining that the update load is low when the update time before update or the update time after exclusion is within the update deadline;
    When the pre-exclusion update time exceeds the update deadline and the determination result of the load detection step is a high load, information unnecessary for detection work is excluded from the update information, and the update information is An update information processing step for extracting the post-exclusion update information as information necessary for the detection operation;
    A data management step of reflecting at least the update information or the post-exclusion update information in the database based on the determination result of the load detection step;
    In the data management step,
    The database management characterized in that the post-exclusion update information is reflected in the database on condition that the post-exclusion update time is within the update deadline and the determination result of the load detection step is low load. Method.
  12. 　請求項１１に記載のデータベース管理方法であって、
    　前記更新時間監視ステップでは、
    　前記更新情報毎に前記除外前更新時間をその平均を示す除外前平均更新時間として予測し、前記更新情報毎に前記除外後更新時間をその平均を示す除外後平均更新時間として予測し、
    　前記負荷検知ステップでは、
    　前記更新時間監視ステップの予測結果として、前記更新情報の更新件数と前記除外前平均更新時間との乗算値又は前記更新情報の更新件数と前記除外後平均更新時間との乗算値を用いることを特徴とするデータベース管理方法。     The database management method according to claim 11, comprising:
    In the update time monitoring step,
    Predicting the update time before exclusion for each update information as an average update time before exclusion indicating the average, predicting the update time after exclusion as an average update time after exclusion indicating the average for each update information,
    In the load detection step,
    As a prediction result of the update time monitoring step, a multiplication value of the number of updates of the update information and the average update time before exclusion or a multiplication value of the number of updates of the update information and the average update time after exclusion is used. Database management method.
  13. 　請求項１１に記載のデータベース管理方法であって、
    　前記更新情報処理ステップでは、
    　前記更新情報の中から前記検知業務に必要な情報として前記除外後更新情報を抽出する際に、業務ＳＱＬ中の列・行の情報を用いることを特徴とするデータベース管理方法。     The database management method according to claim 11, comprising:
    In the update information processing step,
    A database management method characterized by using column / row information in business SQL when extracting post-exclusion update information as information necessary for the detection business from the update information.
  14. 　請求項１１に記載のデータベース管理方法であって、
    　前記データ管理ステップでは、
    　前記除外前更新時間が前記更新期限内であって、前記負荷検知ステップの判定結果が、低負荷であることを条件に、前記更新情報の中から除外された情報であって、前記検知業務に不要な情報を前記データベースに反映することを特徴とするデータベース管理方法。     The database management method according to claim 11, comprising:
    In the data management step,
    On the condition that the update time before exclusion is within the update deadline and the determination result of the load detection step is a low load, the information is excluded from the update information, and A database management method characterized in that unnecessary information is reflected in the database.
PCT/JP2015/067606 2015-06-18 2015-06-18 Information system and database management method WO2016203613A1 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
PCT/JP2015/067606 WO2016203613A1 (en) 2015-06-18 2015-06-18 Information system and database management method

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
PCT/JP2015/067606 WO2016203613A1 (en) 2015-06-18 2015-06-18 Information system and database management method

Publications (1)

Publication Number Publication Date
WO2016203613A1 true WO2016203613A1 (en) 2016-12-22

Family

ID=57545138

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/JP2015/067606 WO2016203613A1 (en) 2015-06-18 2015-06-18 Information system and database management method

Country Status (1)

Country Link
WO (1) WO2016203613A1 (en)

Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2012222080A (en) * 2011-04-06 2012-11-12 Hitachi Kokusai Electric Inc Substrate processing system

Patent Citations (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2012222080A (en) * 2011-04-06 2012-11-12 Hitachi Kokusai Electric Inc Substrate processing system

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
"Credit Card Business no Shikumi", CARDWAVE, vol. 19, no. 8, 20 July 2006 (2006-07-20), pages 24 - 25 *

Similar Documents

Publication Publication Date Title
US9424157B2 (en) Early detection of failing computers
US7840517B2 (en) Performance evaluating apparatus, method, and computer-readable medium
CN106886485B (en) System capacity analysis and prediction method and device
US7480719B2 (en) Information system, load control method, load control program and recording medium
US8516499B2 (en) Assistance in performing action responsive to detected event
JP6260130B2 (en) Job delay detection method, information processing apparatus, and program
JP2008009842A (en) Control method of computer system, and computer system
US9886195B2 (en) Performance-based migration among data storage devices
JP5942509B2 (en) Batch processing system
CN107592345A (en) Transaction current-limiting apparatus, method and transaction system
US10838798B2 (en) Processing system for performing predictive error resolution and dynamic system configuration control
US8555290B2 (en) Apparatus and method for dynamic control of the number of simultaneously executing tasks based on throughput
JP2011103030A (en) Incident management method and operation management server
CN115373835A (en) Task resource adjusting method and device for Flink cluster and electronic equipment
JP2005099973A (en) Operation management system
JP2014078160A (en) Device and method for assisting decision of virtual resource combination
US11461186B2 (en) Automatic backup strategy selection
US20110072305A1 (en) Recovery method management device and recovery method management method
JP2022011579A (en) Operation management apparatus and operation management method
WO2016203613A1 (en) Information system and database management method
CN110795276A (en) Storage medium repairing method, computer equipment and storage medium
JP2004164344A (en) Evaluation supporting method and system capable of using the same method
JP2008191849A (en) Operation management device, information processor, control method for operation management device, control method for information processor and program
CN111325450A (en) Processing method and system for automatic customer service borrowing, electronic equipment and storage medium
US11513862B2 (en) System and method for state management of devices

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 15895633

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 15895633

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: JP