+

WO2018150639A1 - Dispositif d'acquisition de données, procédé d'acquisition de données et programme d'acquisition de données - Google Patents

Dispositif d'acquisition de données, procédé d'acquisition de données et programme d'acquisition de données Download PDF

Info

Publication number
WO2018150639A1
WO2018150639A1 PCT/JP2017/038685 JP2017038685W WO2018150639A1 WO 2018150639 A1 WO2018150639 A1 WO 2018150639A1 JP 2017038685 W JP2017038685 W JP 2017038685W WO 2018150639 A1 WO2018150639 A1 WO 2018150639A1
Authority
WO
WIPO (PCT)
Prior art keywords
data acquisition
data
request
acquisition
acquisition request
Prior art date
Application number
PCT/JP2017/038685
Other languages
English (en)
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 JP2018537684A priority Critical patent/JP6591080B2/ja
Publication of WO2018150639A1 publication Critical patent/WO2018150639A1/fr

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • 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 a data acquisition device, a data acquisition method, and a data acquisition program for acquiring data.
  • Common Information Model is a standard information model and in-system / application data in a system that operates power facilities (power stations, substations, power transmission lines, etc. that constitute the power system) in the backbone energy management system (EMS).
  • This model specifies exchange.
  • power system information By sharing power system information with CIM, data exchange between power system monitoring, control, and analysis applications is facilitated. Thereby, the connectivity between applications and the expandability of the system can be improved.
  • a power NW model DB for example, there is a power network model database (hereinafter referred to as a power NW model DB) managed in a relational database format (Relational Database (RDB) format).
  • the power NW model DB stores information on power facilities in the backbone system EMS. For example, in a user operation or business process, information satisfying a set of attributes whose position information is “point A” and whose other attribute is “high voltage equipment” is acquired from the power NW model DB.
  • RDB Relational Database
  • XML Extensible Markup Language
  • Patent Document 1 As a technique for quickly responding to a data acquisition request, for example, there is Patent Document 1 below.
  • the master database when the search request data from the client does not exist in the cache database, the master database returns the search result record to the distributed cache database, and turns on the corresponding bit on the reference bitmap table. Thereafter, when there is a search request for the same record, the cache method of Patent Document 1 returns data on the distributed cache database.
  • the cache method of Patent Document 1 updates data only to the distributed cache database whose reference bit is ON.
  • the data cached by the cache method of Patent Document 1 is not necessarily the data required at that time for user operation or business processing in a system that operates power equipment in the power system. Therefore, the cache method disclosed in Patent Document 1 does not necessarily improve the data response.
  • the object of the present invention is to suppress response delay of data acquired in response to a request.
  • a data acquisition device, a data acquisition method, and a data acquisition program that are one aspect of the invention disclosed in this application are accessible to a database that stores a data group, and respond to a data acquisition request from a request source for the database
  • FIG. 1 is an explanatory diagram of an example of data pre-acquisition according to the first embodiment.
  • FIG. 2 is an explanatory diagram illustrating a system configuration example of the data acquisition system.
  • FIG. 3 is a block diagram illustrating a hardware configuration example of a computer.
  • FIG. 4 is an explanatory diagram showing an example of the contents stored in the power NW model DB.
  • FIG. 5 is an explanatory diagram illustrating an example of an acquisition pattern.
  • FIG. 6 is an explanatory diagram showing an example of the stored contents of the data acquisition history accumulation table.
  • FIG. 7 is an explanatory diagram of an example of the contents stored in the data acquisition estimation table.
  • FIG. 8 is an explanatory diagram of an example of stored contents of the step information management table.
  • FIG. 9 is an explanatory diagram of an example of stored contents of the pre-acquired information management table.
  • FIG. 10 is an explanatory diagram of an example of stored contents of the activation timing management table.
  • FIG. 11 is a block diagram illustrating a functional configuration example of the data acquisition apparatus.
  • FIG. 12 is an explanatory diagram illustrating an example of a learning result table.
  • FIG. 13 is a flowchart illustrating an example of a learning process procedure by the learning unit.
  • FIG. 14 is a flowchart showing a detailed processing procedure example of the learning processing (step S1303) shown in FIG.
  • FIG. 15 is a flowchart illustrating a detailed processing procedure example of the aggregation processing (step S1409) illustrated in FIG.
  • FIG. 16 is a flowchart showing a detailed processing procedure example of the selection probability calculation process (step S1510) shown in FIG.
  • FIG. 17 is a flowchart showing a detailed processing procedure example of the representative value calculation processing (step S1410) shown in FIG.
  • FIG. 18 is a flowchart showing a detailed processing procedure example of the data acquisition estimation table update processing (step S1304) shown in FIG.
  • FIG. 19 is a flowchart illustrating a detailed processing procedure example 1 of the data acquisition processing by the data acquisition device.
  • FIG. 20 is a flowchart illustrating a detailed processing procedure example 2 of the data acquisition processing by the data acquisition device.
  • FIG. 21 is an explanatory diagram of an example of transfer of the acquired pattern sequence.
  • FIG. 22 is a flowchart illustrating a detailed processing procedure example of the data acquisition / history accumulation processing (steps S1906 and S2006) illustrated in FIGS. 19 and 20.
  • FIG. 23 is a flowchart illustrating a detailed processing procedure example of the data pre-acquisition processing.
  • FIG. 24 is an explanatory diagram of an example of stored contents of the data acquisition history accumulation table according to the second embodiment.
  • FIG. 25 is an explanatory diagram of an example of stored contents of the second data acquisition estimation table.
  • FIG. 26 is a flowchart of a detailed process procedure example 1 of the data acquisition process performed by the data acquisition apparatus according to the second embodiment.
  • FIG. 27 is an explanatory diagram of an example of preliminary data acquisition according to the third embodiment.
  • FIG. 28 is a flowchart of a detailed process procedure example of the data pre-acquisition process according to the third embodiment.
  • FIG. 29 is an explanatory diagram of an example of starting timing adjustment according to the fourth embodiment.
  • FIG. 30 is a flowchart illustrating an example of a startup timing adjustment processing procedure.
  • FIG. 1 is an explanatory diagram of an example of data pre-acquisition according to the first embodiment.
  • the data acquisition system 100 includes a terminal 101, an application 102, a data acquisition function 103, and a power NW model DB 104.
  • the terminal 101 transmits a data acquisition request to the data acquisition function 103 via the application 102, and acquires data corresponding to the data acquisition request from the power NW model DB 104 via the application 102 and the data acquisition function 103.
  • the terminal 101 is provided in a power facility (a power plant or a substation constituting a power system) and is communicably connected to a server (data acquisition device) having a data acquisition function 103 via a communication network.
  • Application 102 is an interface between terminal 101 and data acquisition function 103.
  • the application 102 is mounted on the terminal 101 or the data acquisition device.
  • the application 102 is software that acquires data from the power NW model DB 104, although the application 102 differs depending on the corresponding power facility.
  • the data acquisition function 103 has a data access function 131, a pattern learning function 132, and a pre-acquisition function 133.
  • the data access function 131 acquires data corresponding to the data acquisition request from the terminal 101 from the power NW model DB 104 and returns it to the request source application 102.
  • the data access function 131 acquires, from the power NW model DB 104, entries of a plurality of attribute tables corresponding to the data acquisition request, converts them into one XML data, and converts the converted XML data to Return to the requesting application 102.
  • the pattern learning function 132 learns a series of data acquisition request patterns input from the terminal 101. For example, the worker A transmits a series of data acquisition requests including a data acquisition range of “circle (3 km)”, “cone”, and “cylinder” from the terminal 101. Therefore, in the case of the worker A, the pattern learning function 132 learns to select the data acquisition range in the order of “circle (3 km)” ⁇ “cone” ⁇ “cylinder”.
  • the pre-acquisition function 133 specifies the data acquisition range that the user of the terminal 101 will select next from the learning result of the pattern learning function 132, and the data access function 131 To acquire data within the specified data acquisition range before the data acquisition request.
  • the power NW model DB 104 is a database that stores a CIM that is a power NW model.
  • the power NW model is a network model in which nodes of power equipment are used and electric wires are links.
  • the power NW model is, for example, a three-dimensional model expressed by two-dimensional position information and a voltage of a node.
  • the power NW model DB 104 has a table for each attribute such as system (high voltage or low voltage), facility type (power plant, substation, etc.), area, and position.
  • the data access function 131 acquires a corresponding entry from the table for each attribute included in the data acquisition request and converts the entry into one XML data. Note that this conversion processing to XML data takes time and causes a reduction in response performance.
  • worker A inputs a pattern. Specifically, for example, the worker A transmits a first data acquisition request from the terminal 101 in which the data acquisition range is a circle having a diameter of 3 km, and then the second data acquisition in which the data acquisition range is a cone. Assume that a request is transmitted from the terminal 101 and then a third data acquisition request is transmitted from the terminal 101 whose data acquisition range is a cylinder.
  • the data access function 131 (1) accesses the power NW model DB 104 each time a data acquisition request is received, acquires entries in a plurality of attribute tables, and merges them into one XML data. The data access function 131 returns the XML data to the terminal 101.
  • the pattern learning function 132 learns the data acquisition range in the order of “circle (3 km)” ⁇ “cone” ⁇ “column” selected by the worker A.
  • the data access function 131 can acquire the data included in the specified data acquisition range “cone” from the power NW model DB 104 and convert it into XML data before the arrival of the second data acquisition request. .
  • the worker A can obtain an immediate response without waiting for the time required for the data acquisition process from when the second data acquisition request is made until the response is received.
  • the data acquisition system 100 predicts what data acquisition request will arrive and prefetches the corresponding data, the response performance can be improved.
  • the data acquisition system 100 predicts what data acquisition request will arrive and prefetches the corresponding data, the response performance can be improved.
  • the processing load due to prefetching it is possible to reduce the processing load due to prefetching.
  • FIG. 2 is an explanatory diagram showing a system configuration example of the data acquisition system 100.
  • the data acquisition system 100 has a configuration in which a data acquisition device 200 that is a server and a terminal 101 are communicably connected via a communication network 201.
  • the data acquisition device 200 has a power NW model DB 104.
  • the power NW model DB 104 may be included in another server accessible from the data acquisition apparatus 200 via the communication network 201.
  • FIG. 3 is a block diagram illustrating a hardware configuration example of a computer.
  • the computer is, for example, the data acquisition device 200 and the terminal 101 shown in FIG.
  • the computer 300 includes a processor 301, a storage device 302, an input device 303, an output device 304, and a communication interface (communication IF 305).
  • the processor 301, the storage device 302, the input device 303, the output device 304, and the communication IF 305 are connected by a bus 306.
  • the processor 301 controls the computer 300.
  • the storage device 302 serves as a work area for the processor 301.
  • the storage device 302 is a non-temporary or temporary recording medium that stores various programs and data.
  • Examples of the storage device 302 include a ROM (Read Only Memory), a RAM (Random Access Memory), an HDD (Hard Disk Drive), and a flash memory.
  • the input device 303 inputs data. Examples of the input device 303 include a keyboard, a mouse, a touch panel, a numeric keypad, and a scanner.
  • the output device 304 outputs data. Examples of the output device 304 include a display and a printer.
  • the communication IF 305 is connected to the communication network 201 and transmits / receives data.
  • FIG. 4 is an explanatory diagram showing an example of the contents stored in the power NW model DB 104.
  • the power NW model DB 104 is a database that stores a CIM that is a power NW model
  • the power NW model is a network model that uses nodes of power equipment and links electric wires.
  • the power NW model DB 104 is realized by the storage device 302 described above.
  • the power NW model DB 104 is, for example, a set of tables in which node IDs are associated with each attribute (system, facility type, area, position information,). Description will be made by paying attention to information held by the node N and the link L constituting the model.
  • the node N is identified by the node ID 401 and has a system 402, an equipment type 403, an area 404, position information 405, electrical characteristic information 406, and a connection link ID 407.
  • the node ID 401 is identification information that uniquely identifies the node N indicating the power equipment.
  • the system 402 is identification information indicating the system of the node N.
  • strain 402 is the information which shows a high voltage
  • the equipment type 403 is information indicating the type of equipment of the node N.
  • the equipment type 403 includes, for example, a transformer and a steel tower.
  • Area 404 is information indicating an area to which node N belongs.
  • the area 404 is defined, for example, by a municipality range.
  • the position information 405 is information indicating the position of the node N stretched on the XY plane.
  • the position information 405 is defined by, for example, latitude (value in the Y-axis direction) and longitude (value in the X-axis direction).
  • the electrical characteristic information 406 is used as a value of the node N in the Z-axis direction.
  • the electrical characteristic information 406 is, for example, a voltage value at the node N.
  • the connection link ID 407 is identification information that uniquely identifies the connection link L.
  • the connection link L is a link L connected to the node N.
  • the link L is an electric wire connected to the power facility that is the node N.
  • the link L is specified by the link ID 411 and the link length 412.
  • the link ID 411 is identification information that uniquely identifies the link L.
  • the link length 412 is information indicating the length of the electric wire that is the link L.
  • FIG. 5 is an explanatory diagram illustrating an example of an acquisition pattern.
  • the acquisition pattern indicates the acquisition range of the power NW model.
  • the operator operates the terminal 101 to select an acquisition pattern, and transmits a data acquisition request including the selected acquisition pattern to the data acquisition device 200.
  • five types of acquisition patterns will be described as an example.
  • the acquisition pattern P1 is a circular acquisition pattern.
  • the acquisition pattern P1 is, for example, an acquisition pattern for acquiring data related to a node group included in a system within a circle having a diameter D [km] with the point A as the center. For example, when the user gives the terminal 101 position information of the point A that is the node N, designation of a circle, diameter D, electrical characteristic information (voltage value), and equipment type, the terminal 101 generates the acquisition pattern P1. Then, a data acquisition request is transmitted.
  • the acquisition pattern P2 is a conical acquisition pattern.
  • the acquisition pattern P2 relates to, for example, a node group included in a system in a cone whose height is a voltage (B1-B2) and whose bottom circle is a circle having a diameter D [km] with the point A as the center.
  • This is an acquisition pattern for acquiring data.
  • the terminal 101 when the user gives the terminal 101 position information of the point A, designation of the cone, diameter D, electrical characteristic information (voltage value range), and equipment type, the terminal 101 generates the acquisition pattern P2.
  • a data acquisition request is transmitted.
  • the acquisition pattern P3 is a cylindrical acquisition pattern.
  • the acquisition pattern P3 acquires data related to a node group included in a system in a cylinder having a height of voltage B and a bottom circle having a diameter D [km] range centered on the point A. It is an acquisition pattern for.
  • the terminal 101 when the user gives the terminal 101 position information of the point A, designation of a cylinder, diameter D, electrical characteristic information (voltage value range), and equipment type, the terminal 101 generates an acquisition pattern P3.
  • a data acquisition request is transmitted.
  • the acquisition pattern P4 is a frustoconical acquisition pattern.
  • the acquisition pattern P4 is, for example, an acquisition pattern for acquiring data related to a node group included in the system in the truncated cone that is in the range of n hops from the point A. For example, when the user gives the terminal 101 position information of the point A, designation of the truncated cone, the number of hops, electrical characteristic information (voltage value), and the equipment type, the terminal 101 generates the acquisition pattern P2, A data acquisition request will be sent.
  • the number of hops is the number of nodes that can be traced from the link L with the point A as the departure point.
  • the acquisition pattern P5 is a spherical acquisition pattern.
  • the acquisition pattern P5 is, for example, an acquisition pattern for acquiring data related to a node group included in a system in a sphere that is n hops from the point A where the voltage value is B.
  • the terminal 101 when the user gives the terminal 101 position information of the point A, designation of the truncated cone, the number of hops, electrical characteristic information (voltage value), and the equipment type, the terminal 101 generates the acquisition pattern P2, A data acquisition request will be sent.
  • the number of hops is the number of nodes that can be traced from the link starting from the point A.
  • the acquisition patterns P1 to P5 are examples.
  • the range designation from the point A may be either a distance or the number of hops.
  • the shape of the acquisition pattern is not limited to the shapes of the acquisition patterns P1 to P5.
  • the acquisition pattern may be generated by the terminal 101 or may be generated by the application 102.
  • FIG. 6 is an explanatory diagram showing an example of the contents stored in the data acquisition history accumulation table 600.
  • the value of the AA field bbb (AA is a field name and bbb is a code) may be expressed as AAbbb.
  • the value of the log ID field 601 is expressed as a log ID 601.
  • the data acquisition history accumulation table 600 is a table updated by the data acquisition device 200.
  • the data acquisition history storage table 600 is a table in which the data acquisition device 200 stores a history regarding data acquisition from the power NW model DB 104 in response to a data acquisition request from an operator.
  • the data acquisition history accumulation table 600 includes a log ID field 601, a user ID field 602, a session ID field 603, a data acquisition request time field 604, a data processing time field 605, a pattern shape field 606, and an attribute value field. 607.
  • An entry indicating data acquisition history information is configured by the values of the fields 601 to 607 in the same row.
  • the log ID field 601 is a storage area for storing a log ID.
  • the log ID 601 is identification information that uniquely identifies an entry indicating data acquisition history information.
  • the data acquisition history information corresponds to one data acquisition of a certain worker.
  • the user ID field 602 is an area for storing a user ID.
  • the user ID 602 is identification information that uniquely identifies a worker who is a user.
  • a user ID (which may include a password) 602 is given to the worker by pre-registration.
  • the session ID field 603 is a storage area for storing a session ID.
  • the session ID 603 is identification information that uniquely identifies a session.
  • the session refers to a state from when an operator logs in to the data acquisition apparatus 200 until logout. That is, during the session, the worker can transmit a data acquisition request from the terminal 101 many times.
  • the data acquisition request time field 604 is a storage area for storing the data acquisition request time.
  • the data acquisition request time 604 is the time when the data acquisition request is made. Specifically, for example, it may be a transmission time of a data acquisition request from the terminal 101 or a reception time of a data acquisition request in the data acquisition device 200.
  • the time t1 in the time chart of FIG. 6 is the data acquisition request time 604 in the first data acquisition request R1 after a certain user logs in, and the time t2 is the data acquisition request in the second data acquisition request R2 of a certain user. It is time 604.
  • the data processing time field 605 is a storage area for storing the data processing time.
  • the data processing time 605 is the time from when the data access function 131 accesses the power NW model DB 104 by a data acquisition request until the corresponding data is read out, converted into XML data, and output (data conversion Time).
  • the time TP1 in the time chart of FIG. 6 is the data processing time 605 from the data acquisition request time 604 (t1) in the first data acquisition request R1 after login of a certain user to the output of XML data
  • the time TP2 is This is the data processing time 605 from the data acquisition request time 604 (t2) in the second data acquisition request R2 of a user to the output of XML data.
  • the pattern shape field 606 is a storage area for storing the pattern shape.
  • the pattern shape 606 is identification information indicating, for example, the graphic shown in FIG.
  • the attribute value field 607 is a storage area for storing attribute values.
  • the attribute value 607 includes a voltage that is the electrical characteristic information 406, a point serving as a reference for the pattern shape 606 (point A in FIG. 5), and an acquisition range.
  • the acquisition range is the range of the XY plane encompassed by the pattern shape 606. For example, if the pattern shape 606 is a circle, it is the diameter D of the circle. That is, the pattern shape 606 determines the shape of the acquired pattern, and the attribute value 607 determines the range of the acquired pattern.
  • FIG. 7 is an explanatory diagram of an example of the contents stored in the data acquisition estimation table.
  • the data acquisition estimation table 700 is a table updated by the data acquisition device 200.
  • the data acquisition history accumulation table 600 is used to estimate data acquisition by the next data acquisition request before the next data acquisition request when the data acquisition device 200 receives a data acquisition request from an operator. It is a table.
  • the data acquisition estimation table 700 includes a step number field 701, a user ID field 602, a pattern shape field 606, a representative attribute value field 702, and a next acquisition timing array field 703.
  • An entry indicating data acquisition estimation information for estimating the next acquisition pattern is configured by the value of each field in the same row.
  • the step number field 701 is a storage area for storing a step number. Step number 701 is identification information for uniquely identifying a data acquisition request.
  • the representative attribute value field 702 is a storage area for storing the representative attribute value 702.
  • the representative attribute value 702 is a value that represents the attribute value 607, and is, for example, a statistical attribute value.
  • the statistical attribute value is an average value, a minimum value, a maximum value, or a median value of the attribute values 607.
  • the representative attribute value 702 includes a representative voltage and a representative acquisition range.
  • the representative voltage is a statistical voltage value, for example, an average value, a minimum value, a maximum value, or a median value of the voltage values.
  • the representative acquisition range is a statistical acquisition range, for example, an average value, minimum value, maximum value, or median value of the acquisition range (for example, if the pattern shape 606 is a circle, the diameter D of the circle). .
  • the attribute value 607 in the data acquisition history accumulation table 600 of FIG. 6 includes a voltage, a point, and an acquisition range, but the representative attribute value 702 does not include a point.
  • position information included in the latest acquisition history of the target user stored in the data acquisition history storage table is used.
  • the position information specified in the immediately preceding data acquisition request is used.
  • the next acquisition timing array field 703 is a storage area for storing zero or more next acquisition timing arrays.
  • the next acquisition timing array 703 includes a step number 701 indicating a next estimated data acquisition request that is a data acquisition request estimated to arrive next, and a representative acquisition time (unit: minutes, for example) by the next estimated data acquisition request. , Selection probability, and array data. For example, when the next acquisition timing array 703 is [U003] [1] [70], the top [U003] is the step number 701, the central [1] is the representative acquisition time, and the last [70]. Is the selection probability. In the next acquisition timing array field 703, one or more next acquisition timing arrays 703 are stored, but the last data acquisition request is “NULL” because there is no next estimated data acquisition request.
  • the representative acquisition time is a representative value of acquisition time.
  • the acquisition time is from the data acquisition request time 604 (for example, t1) in a certain acquisition request until the next estimated data acquisition request is received, that is, until the data acquisition request time 604 (for example, t2) in the next estimated data acquisition request. (E.g., Ta2).
  • the time from the login time t0 to the first data acquisition request time 604 (t1) is defined as an acquisition time Ta1.
  • there is no next data acquisition request for the last data acquisition request there is no acquisition time.
  • the acquisition time Ta3 does not exist, and therefore the acquisition time Ta3 does not exist.
  • the representative value of the acquisition time is a statistical acquisition time, for example, an average value, a minimum value, a maximum value, or a median value of the acquisition times.
  • the selection probability is a probability that an acquisition pattern (a combination of the pattern shape 606 and the representative attribute value 702) that will be specified in the next estimation data acquisition request is selected next time by the user. For example, there are two next acquisition timing arrays 703 in the entry whose step number 701 is “U001”: ⁇ [U003] [1] [70], [U004] [1] [30] ⁇ . In the first next acquisition timing array 703 ⁇ [U003] [1] [70] ⁇ , the data acquisition request of [U003] having the step number 701 is logged in (the pattern shape 606 and the representative attribute value 702 are “NULL”). 1] means that it is selected with a probability of [70]% when the time elapses.
  • the data acquisition request of [U004] having the step number 701 is logged in (the pattern shape 606 and the representative attribute value 702 are “NULL”). Means that it is selected with a probability of [30]% when the time of [1] elapses.
  • next acquisition timing arrays 703 there are two next acquisition timing arrays 703 in the entry whose step number 701 is “U003”, ⁇ [U008] [5] [90], [U010] [7] [10] ⁇ .
  • the data acquisition request of [U008] with step number 701 is [5] from the data acquisition request of “U003” with step number 701. Means that it is selected with a probability of [90]%.
  • next acquisition timing array 703 ⁇ [U010] [7] [10] ⁇ at the end indicates that the data acquisition request of [U010] with the step number 701 is changed from the data acquisition request of “U003” with the step number 701 [ 7] means that it is selected with a probability of [10]% when the time elapses.
  • an entry whose pattern shape 606 and representative attribute value 607 is “NULL” is an entry that the user refers to for the first time when starting a session with the data acquisition apparatus 200.
  • the entry whose next acquisition timing array 703 is “NULL” is an entry indicating that there is no next data acquisition request (step number 701).
  • FIG. 8 is an explanatory diagram of an example of stored contents of the step information management table.
  • the step information management table 800 is a table that is updated by the data acquisition device 200.
  • the step information management table 800 is a table for managing a step number 701 indicating a data acquisition request for each user.
  • the step information management table 800 has a user ID field 602, a step number field 701, and a previous step number field 801. An entry indicating step management information is configured by the value of each field in the same row.
  • the previous step number field 801 is a storage area for storing the previous step number 801.
  • the previous step number 801 is a step number 701 indicating a data acquisition request immediately before the data acquisition request corresponding to the step number 701.
  • FIG. 9 is an explanatory diagram of an example of stored contents of the pre-acquired information management table.
  • the pre-acquisition information management table 900 is a table that is updated by the data acquisition apparatus 200 through a pre-acquisition process (described later in FIG. 22).
  • the prior acquisition information management table 900 is a table for managing data acquired in advance for each user.
  • the prior acquisition information management table 900 includes a user ID field 602, a pattern shape field 606, an attribute value field 607, and a preliminary acquisition data field 901.
  • An entry indicating pre-acquired information is configured by the value of each field in the same row.
  • the advance acquisition data field 901 is a storage area for storing advance acquisition data.
  • the pre-acquisition data 901 is data acquired in advance by the data access function 131 accessing the power NW model DB 104, and an acquisition pattern (pattern shape 606 and the same entry of the same entry) specified by the user ID 602 is specified. Data included in the attribute value 607 combination).
  • FIG. 10 is an explanatory diagram of an example of stored contents of the activation timing management table.
  • the activation timing management table 1000 is a table that is updated by the data acquisition device 200.
  • the activation timing management table 1000 is a table for managing activation timing for each user.
  • the activation timing management table 1000 has a user ID field 602 and an activation timing field 1001. An entry indicating activation timing information is configured by the value of each field in the same row.
  • the activation timing field 1001 is a storage area for storing activation timing. When the session ends, the value of the activation timing field 1001 of the user ID 602 is deleted.
  • the activation timing 1001 is a timing at which the pre-acquisition function 133 is activated to cause the data access function 131 to acquire data from the power NW model DB 104.
  • the representative acquisition time of the next acquisition timing array 703 having the highest selection probability among the next acquisition timing arrays 703 of the entry of the corresponding step number 701 is the start timing 1001. Applied.
  • an entry whose step number 701 is “U001” includes two next acquisition timing arrays 703 ⁇ [U003] [1] [70], [U004] [1] [1] [ 30] ⁇ . Since the highest selection probability is [70] in the next next acquisition timing array 703 ⁇ [U003] [1] [70] ⁇ , the highest next selection probability array 703 ⁇ [U003] [1] [70] ⁇ The representative acquisition time [1] is applied to the activation timing 1001.
  • the point of time 701 is the time point that is the same user ID 602 and the average value of the data processing time 605 in the same pattern shape 606 from the time when the representative acquisition time [1] has elapsed since the login. This is the start timing 1001 of the advance acquisition process by the data acquisition request corresponding to U003.
  • the entry whose step number 701 is “U003” has two next acquisition timing arrays 703 ⁇ [U008] [5] [90], [U010] [7] [10] ⁇ . Since the highest selection probability is [90] of the next next acquisition timing array 703 ⁇ [U008] [5] [90] ⁇ , the highest next selection probability array 703 ⁇ [U008] [5] [90] ⁇ The representative acquisition time [5] is applied to the activation timing 1001.
  • the point in time of the average value of the data processing time 605 in 606 is the start timing 1001 of the pre-acquisition processing by the data acquisition request corresponding to U008 which is step number 701.
  • the tables 600, 700, 800, and 900 shown in FIGS. 6 to 9 are realized by the storage device 302 shown in FIG. 3, for example.
  • FIG. 11 is a block diagram illustrating a functional configuration example of the data acquisition device 200.
  • the data acquisition device 200 includes a reception unit 1101, a conversion unit 1102, a transmission unit 1103, a learning unit 1104, a specifying unit 1105, a pre-acquisition unit 1106, and a setting unit 1107.
  • the reception unit 1101 to the setting unit 1107 are functions realized by causing the processor 301 to execute the program stored in the storage device 302 illustrated in FIG. 3 or by the communication IF 305, for example. .
  • the receiving unit 1101 receives a data acquisition request from the terminal 101.
  • the conversion unit 1102 accesses the power NW model DB 104, acquires data corresponding to the data acquisition request received by the reception unit 1101 (a plurality of data having different attributes) from the power NW model DB 104, and stores data in different formats. Convert to (XML data).
  • the conversion unit 1102 corresponds to the data access function 131 described above.
  • the transmission unit 1103 transmits the XML data obtained by the conversion unit 1102 to the request source, that is, the terminal 101 that is the transmission source of the data acquisition request.
  • the learning unit 1104 learns the type of data acquisition request and the acquisition timing that defines the time series order of the data acquisition request for each data acquisition request of the series of data acquisition requests received from the request source.
  • the learning unit 1104 corresponds to the pattern learning function 132 described above.
  • the request source is the terminal 101 used by the operator to log in to the data acquisition device 200.
  • the type of data acquisition request is, for example, an acquisition pattern (a combination of pattern shape 606 and attribute value 607).
  • the acquisition timing is, for example, the data acquisition request time 604.
  • the learning unit 1104 identifies the user ID 602 and the session ID 603 included in the data acquisition request. Further, the learning unit 1104 measures the data processing time 605 in response to the notification of the completion of the output of the XML data from the conversion unit 1102. Thereby, the learning unit 1104 registers an entry in the data acquisition history accumulation table 600 for each data acquisition request.
  • the learning unit 1104 uses the entry registered in the data acquisition history accumulation table 600 to generate and register an entry in the data acquisition estimation table 700. Specifically, the learning unit 1104 generates a learning result using a learning result table.
  • FIG. 12 is an explanatory diagram showing an example of a learning result table.
  • a learning result table 1200 is generated for each user ID 602.
  • the learning result table 1200 includes an acquisition pattern ID column field 1201, a selection count field 1202, a selection probability field 1203, a representative acquisition time field 1204, and a representative attribute value field 702.
  • the acquisition pattern ID column field 1201 is a storage area for storing the acquisition pattern ID column.
  • the acquisition pattern ID string 1201 is an ID string that identifies a time-series acquisition pattern.
  • “P1” is an acquisition pattern ID column 1201 indicating that the acquisition pattern P1 is selected in one data acquisition request and the session is ended.
  • “P1-P1-P2” is an acquisition pattern P1 for the first data acquisition request, an acquisition pattern P1 for the second data acquisition request, and an acquisition pattern P2 for the third data acquisition request. It is an acquisition pattern ID column 1201 indicating that the processing has ended.
  • the selection number field 1202 is a storage area for storing the number of selections.
  • the number of selections 1202 is the number of times that the session has ended in the acquisition pattern ID column 1201, that is, the number of times the acquisition pattern ID column 1201 has been selected.
  • the selection probability field 1203 is a storage area for storing the selection probability.
  • the selection probability 1203 is a probability that the acquired pattern ID string 1201 is selected.
  • the learning unit 1104 calculates a selection probability 1203 using an acquisition pattern ID string 1201 in which a series of acquisition pattern IDs from the head to the previous one are common. However, when the acquisition pattern ID string 1201 includes only one acquisition pattern ID, there is no series of acquisition pattern IDs from the head to the previous one, so the denominator of the selection probability 1203 is the acquisition pattern ID string 1201 “P1 ”To“ P5 ”, and the numerator is the number of selections 1202 of the target acquisition pattern ID column 1201 among the acquisition pattern ID columns 1201“ P1 ”to“ P5 ”.
  • the selection probability 1203 of the acquisition pattern ID string 1201 “P1” is 7/10 (70%)
  • the selection probability 1203 of the acquisition pattern ID string 1201 “P2” is 3/10 (30%)
  • the acquisition pattern ID string The selection probabilities 1203 of 1201 “P3” to “P5” are 0/10 (0%), respectively.
  • the learning unit 1104 groups the acquired pattern IDs 1201 having the same acquired pattern ID from the first (first) to the previous (second), and calculates a selection probability 1203 within each group. For example, “P1-P1-P1”, “P1-P1-P2”, “P1-P1-P3”, “P1-P1-P4”, “P1-P1-P5” are 1 from the top (first time). The acquisition pattern ID up to the previous (second) is common to “P1-P1”.
  • the denominator of the selection probability 1203 is the sum of the selection times 1202 of the acquisition pattern ID column 1201 “P1-P1-P1” to “P1-P1-P5”, and the numerator is the acquisition pattern ID column 1201 “P1-P1”. This is the number of selections 1202 of the acquisition pattern ID column 1201 that is the target among “-P1” to “P1-P1-P5”.
  • the selection probability 1203 of the acquisition pattern ID column 1201 “P1-P1-P1” is 4/10 (40%), and the selection probability 1203 of the acquisition pattern ID column 1201 “P1-P1-P2” is 6/10 ( 60%), the selection probabilities 1203 of the acquired pattern ID columns 1201 “P1-P1-P3” to “P1-P1-P5” are 0/10 (0%), respectively.
  • the representative acquisition time field 1204 is a storage area for storing the representative acquisition time.
  • the learning unit 1104 refers to the data acquisition history accumulation table 600, and for each acquisition pattern ID column 1201, from the data acquisition request time 604 of the data acquisition request corresponding to the last acquisition pattern ID, The time obtained by subtracting the data acquisition request time 604 of the data acquisition request corresponding to the previous acquisition pattern ID is calculated as the acquisition time. Then, the learning unit 1104 calculates, for example, the average value of the calculated acquisition times as the representative acquisition time 1204.
  • the learning unit 1104 sets the pattern shape 606 of the acquired pattern to “P1” ⁇ “P2” ⁇ “P3” for each session ID 603 of the user.
  • the entry ending in is identified from the data acquisition history accumulation table 600.
  • the learning unit 1104 registers the data acquisition request time 604 of the entry in which the last acquisition pattern ID “P3” is registered as the pattern shape 606 and the previous acquisition pattern ID “P2” as the pattern shape 606.
  • the data acquisition request time 604 of the registered entry is acquired, and the acquisition time is calculated.
  • the learning unit 1104 executes this acquisition time calculation process for each session whose acquisition pattern ID column 1201 is “P1-P2-P3”, obtains the average value of the calculated acquisition times, and acquires the acquisition pattern ID column 1201.
  • the representative acquisition time 1204 of “P1-P2-P3” is assumed.
  • the acquisition pattern ID column 1201 with one ID there is no previous acquisition pattern ID, so instead of the data acquisition request time 604 of the data acquisition request corresponding to the previous acquisition pattern ID.
  • the login time is applied.
  • the representative attribute value 702 is a combination of a representative voltage and a representative acquisition range.
  • the representative attribute value 702 is, for example, the average value of the voltage value and the acquisition range when the acquisition pattern indicated by the acquisition pattern ID at the end is selected in each acquisition pattern ID column 1201.
  • the learning unit 1104 sets the pattern shape 606 of the acquired pattern to “P1” ⁇ “P2” ⁇ “P3” for each session ID 603 of the user.
  • the entry ending in is identified from the data acquisition history accumulation table 600.
  • the learning unit 1104 acquires the attribute value 607 (excluding the point) of the entry in which the acquisition pattern ID “P3” at the end is registered as the pattern shape 606.
  • the learning unit 1104 executes the acquisition processing of the attribute value 607 (excluding the point) for each session whose acquisition pattern ID string 1201 is “P1-P2-P3”, and acquires the acquired attribute value 607 (excluding the point). Is obtained as the representative attribute value 702 of the acquired pattern ID column 1201 “P1-P2-P3”.
  • the selection probability 1203, the representative acquisition time 1204, and the representative attribute value 702 are used for entry registration of the data acquisition estimation table 700.
  • the specifying unit 1105 displays the learning result by the learning process of the learning unit 1104. Based on the first data acquisition request, the type of the next estimated data acquisition request that can be acquired from the request source and the acquisition timing are specified.
  • the specifying unit 1105 corresponds to the advance acquisition function 133 described above.
  • the identifying unit 1105 identifies the step number 701 of the next estimated data acquisition request with the selection probability 1203 from the learning result, specifically, the next acquisition timing array 703 of the data acquisition estimation table 700. Then, the specifying unit 1105 specifies the pattern shape 606 and the representative attribute value 702 corresponding to the entry of the step number 701 of the next estimated data acquisition request from the data acquisition estimation table 700 as the next estimated data acquisition request type. Further, the specifying unit 1105 specifies the next estimated data acquisition request time 604 that is the time when the representative acquisition time 1204 has elapsed from the data acquisition request time 604 of the first data acquisition request as the acquisition timing of the next estimated data acquisition request.
  • the prior acquisition unit 1106 acquires data corresponding to the next estimated data acquisition request whose type is specified by the specifying process of the specifying unit 1105 from the power NW model DB 104 before the acquisition timing of the next estimated data acquisition request.
  • the advance acquisition unit 1106 corresponds to the advance acquisition function 133 described above. Specifically, for example, the advance acquisition unit 1106 controls the conversion unit 1102 to acquire data from the power NW model DB 104 before the acquisition timing of the second data acquisition request.
  • the setting unit 1107 starts the advance acquisition process so that the next estimated data acquisition request acquisition timing is after the elapse of the data processing time 605 required to convert the data into a predetermined format (for example, XML format).
  • Timing 1001 is set.
  • the setting unit 1107 includes the average value of the data processing time 605 for the same user ID 602 and the same pattern shape 606 from the time when the representative acquisition time 1204 has elapsed.
  • the retroactive time is set as the activation timing 1001. Thereby, the advance acquisition unit 1106 can execute the advance acquisition process at the activation timing 1001.
  • the determination unit 1108 When the second data acquisition request is actually received after the first data acquisition request, the determination unit 1108 includes the type included in the second data acquisition request and the type of the next estimated data acquisition request specified by the specifying process. And whether they match. If they match, the pre-acquisition unit 1106 sends the pre-acquisition result to the transmission unit 1103.
  • the conversion unit 1102 acquires data corresponding to the second data acquisition request received by the reception unit 1101 from the power NW model DB 104, converts the data into XML data, and sends the XML data to the transmission unit 1103.
  • the identifying unit 1105 identifies the step number 701 of the next estimated data acquisition request that was not selected last time from the next acquisition timing array 703 of the data acquisition estimation table 700 with the selection probability 1203.
  • FIG. 13 is a flowchart illustrating an example of a learning process procedure performed by the learning unit 1104.
  • the learning unit 1104 waits for learning timing (step S1301: No).
  • the learning timing is, for example, irregular timing designated by the user, or regular timing such as daily, weekly, monthly or the like. If it is the learning timing (step S1301: Yes), the learning unit 1104 acquires the target entry group from the data acquisition history accumulation table 600 (step S1302).
  • the target entry group is an entry group to be learned and may be all entries in the data acquisition history accumulation table 600, and is limited in advance within a range of values of a certain field in the data acquisition history accumulation table 600. It may be a group of entries.
  • step S1303 the learning unit 1104 executes a learning process. Details of the learning process (step S1303) will be described later with reference to FIG. Thereafter, the learning unit 1104 executes a data acquisition estimation table update process (step S1304). Details of the data acquisition estimation table update process (step S1304) will be described later with reference to FIG. Thereby, the learning unit 1104 ends the series of processes.
  • FIG. 14 is a flowchart showing a detailed processing procedure example of the learning processing (step S1303) shown in FIG.
  • the learning unit 1104 determines whether there is an unselected user ID 602 for the learning target entry group acquired from the data acquisition history accumulation table 600 (step S1401). When there is an unselected user ID 602 (step S1401: Yes), the learning unit 1104 selects an unselected user ID 602 and selects an entry group of the selected user ID 602 from the learning target entry group (step S1402). The learning unit 1104 determines whether there is an unselected session ID 603 for the entry group of the selected user ID 602 (step S1403).
  • the learning unit 1104 selects an unselected session ID 603 from the entry group of the selected user ID 602, and selects the entry group of the selected session ID 603 (step S1403). S1404).
  • the learning unit 1104 determines whether there is an unselected entry among the entry group of the selected session ID 603 selected in step S1404 (step S1405). When there is an unselected entry (step S1405: Yes), the learning unit 1104 selects an entry that is not selected and has the oldest data acquisition request time 604 from the entry group of the selected session ID 603 (step S1406). Then, the learning unit 1104 identifies the acquisition pattern ID (pattern shape 606), the data acquisition request time 604, and the attribute value 607 from the selection entry in step S1406, and adds them to the end of the acquisition pattern array (step S1407). . Then, the process returns to step S1405. An acquisition pattern array is generated for each entry of the selected session ID 603 through the loop of steps S1405 to S1407.
  • step S1405 If there is no unselected entry in step S1405 (step S1405: No), the learning unit 1104 stores the acquired pattern array of the selected user ID 602 and the selected session ID 603, which is finally generated, in the storage device 302. (Step S1408), the process returns to Step S1403.
  • step S1403 when there is no unselected session ID 603 for the selected user ID 602 (step S1403: No), the learning unit 1104 executes the aggregation process (step S1409) and the representative value calculation process (step S1410). Details of the aggregation process (step S1409) and the representative value calculation process (step S1410) will be described later with reference to FIGS. 16 and 17, respectively. After the representative value calculation process (step S1410), the process returns to step S1401.
  • step S1401 when there is no unselected user ID 602 (step S1401: No), the learning unit 1104 ends the learning process (step S1303) and proceeds to the data acquisition estimation table update process (step S1304).
  • FIG. 15 is a flowchart illustrating a detailed processing procedure example of the aggregation processing (step S1409) illustrated in FIG.
  • the tabulation process is a process of counting the number of selections 1202 in the learning result table 1200 and calculating an acquisition time that is a calculation source of the representative acquisition time 1204.
  • the learning unit 1104 determines whether or not there is an unselected session ID 603 for the acquired pattern array group generated in step S1407 (step S1501). When there is an unselected session ID 603 (step S1501: Yes), the learning unit 1104 selects an unselected session ID 603 and selects an acquisition pattern array (step S1502). Then, the learning unit 1104 identifies a series of acquisition pattern IDs (hereinafter referred to as an acquisition pattern ID string 1201) included in the selection acquisition pattern array (step S1503).
  • an acquisition pattern ID string 1201 a series of acquisition pattern IDs
  • the learning unit 1104 adds 1 to the selection count 1202 of the specified acquisition pattern ID string 1201 in the learning result table 1200 (step S1504).
  • the learning unit 1104 determines whether or not the first to i-th acquisition pattern ID strings 1201 exist in the selection acquisition pattern array (step S1506). If it exists (step S1506: Yes), the learning unit 1104 subtracts the (i-1) -th data acquisition request time 604 from the i-th data acquisition request time 604 of the selected acquisition pattern array to obtain (i-1 ) The acquisition time from the first data acquisition to the i-th data acquisition is calculated (step S1507).
  • the learning unit 1104 stores the acquisition time calculated in step S1507 at the i-th data acquisition request time 604 of the selected acquisition pattern array (step S1508). Then, the learning unit 1104 increments i (step S1509) and returns to step S1506.
  • step S1506 when there is no i-th acquisition pattern ID string 1201 from the top in the selected acquisition pattern array (step S1506: No), the process returns to step S1501.
  • step S1501 when there is no unselected session ID 603 for the acquired pattern array group (step S1501: No), the learning unit 1104 executes a selection probability calculation process (step S1510) and a representative value calculation process (step S1410).
  • FIG. 16 is a flowchart showing a detailed processing procedure example of the selection probability calculation process (step S1510) shown in FIG.
  • i is a variable indicating the number of IDs included in the acquisition pattern ID string 1201 defined in the learning result table 1200.
  • the learning unit 1104 determines whether there is an acquisition pattern ID string 1201 with i IDs (step S1602).
  • the case where there are i acquisition pattern ID columns 1201 means a case where there are i acquisition pattern ID columns 1201 having a selection count 1202 of 1 or more.
  • the acquisition pattern ID columns 1201 “P1-P1-P1” and “P1-P3-P2” have the acquisition pattern IDs “P1-P1” and “P1-P3” from the top to the second (i ⁇ 1) th.
  • i 1, since there are no (i ⁇ 1) th acquired pattern IDs from the top, “P1” to “P5” are grouped into the same group.
  • the learning unit 1104 determines whether there is an unselected group (step S1604). When there is an unselected group (step S1604: Yes), the learning unit 1104 selects one unselected group (step S1605). Then, the learning unit 1104 calculates the selection probability 1203 of each acquired pattern ID string 1201 with the number of IDs i in the selected group, and stores it in the learning result table 1200 (step S1606). Then, the process returns to step S1604.
  • step S1604 when there is no unselected group (step S1604: No), the learning unit 1104 increments i (step S1607) and returns to step S1602.
  • step S1602 when there is no acquisition pattern ID string 1201 with i IDs (step S1602: No), the learning unit 1104 ends the selection probability calculation process (step S1510) and the representative value calculation process (step S1410). ).
  • FIG. 17 is a flowchart showing a detailed processing procedure example of the representative value calculation processing (step S1410) shown in FIG.
  • the learning unit 1104 calculates a representative acquisition time 1204 and a representative attribute value 702.
  • the learning unit 1104 performs grouping using the same selection / acquisition pattern ID string 1201 (step S1704). Then, the learning unit 1104 determines whether there is an unselected group (step S1705). When there is an unselected group (step S: Yes), the learning unit 1104 selects one unselected group (step S1706).
  • the learning unit 1104 specifies each acquisition time from the (i-1) th data acquisition to the i-th data acquisition from the selection acquisition pattern ID string 1201 in the selection group, and from the specified acquisition time, the representative An acquisition time 1204 is calculated (step S1707). Similarly, the learning unit 1104 identifies each i-th attribute value 607 from the selection acquisition pattern ID string 1201 in the selected group, and calculates a representative attribute value 607 from each identified attribute value 607 (step S1708). . Then, the process returns to step S1705.
  • FIG. 18 is a flowchart showing a detailed processing procedure example of the data acquisition estimation table update processing (step S1304) shown in FIG.
  • the data acquisition estimation table update process (step S1304) is a process for updating the data acquisition estimation table 700 shown in FIG.
  • the variable i indicates the time series order of the acquisition pattern ID and also corresponds to the time series order of the step number 701.
  • the learning unit 1104 numbers the initial step number 701 and sets it as the registration target step number 701 (step S1804). For example, as shown in FIG. 7, when the selected user ID 602 is “A0001”, “U001” is assigned as the initial step number 701.
  • the learning unit 1104 determines whether or not there is an acquired pattern ID string 1201 in which the number of selections 1202 is 1 or more and the number of IDs is (i + 1) in the learning result table 1200 selected in step S1802 (step S1802). S1805). If it exists (step S1805: No), the learning unit 1104 takes the next step number 701 for each of the acquired pattern ID strings 1201 having the selection count 1202 of 1 or more and the number of IDs (i + 1). The next acquisition timing array 703 is generated (step S1806).
  • the acquired pattern ID string 1201 having one ID corresponding to step S1805 is “P1” (the selection count 1202 is seven, the selection probability 1203 is 70%, representative The acquisition time 1204 is “1”) and “P2” (the number of selections 1202 is 3, the selection probability 1203 is 30%, and the representative acquisition time 1204 is “1”).
  • the learning unit 1104 assigns the next step number 701 ⁇ U003, U004 ⁇ to each of “P1” and “P2”, and uses ⁇ [U003] [1] [70], [[ U004] [1] [30] ⁇ .
  • the learning unit 1104 the initial step number 701 (registration target step number 701) numbered in step S1804, the selected user ID 602, the acquisition pattern ID (NULL), and the representative attribute
  • An entry including the value 702 (NULL) and the next acquisition timing array 703 generated in step S1806 is registered in the data acquisition estimation table 700 (step S1808). Then, control goes to a step S1810.
  • step S1807 determines whether i is 0 in step S1807 (step S1807: No) or not 0 in step S1807 (step S1807: No).
  • step S1807: No the registration target step number 701, the selected user ID 602 set in step S1810 of the previous loop, and the acquisition pattern confirmed to exist in step S1805.
  • An entry consisting of the i-th acquisition pattern ID in the ID column 1201, the i-th representative attribute value 702 in the acquisition pattern ID column 1201 whose existence has been confirmed in step S1805, and the next acquisition timing array 703 generated in step S1806 is stored as data.
  • Register in the acquisition estimation table 700 step S1809). Then, the process proceeds to step S1810.
  • the i-th acquisition pattern ID in the acquisition pattern ID column 1201 is the acquisition pattern ID at the end of the acquisition pattern ID column 1201.
  • the learning unit 1104 acquires the i-th representative attribute value 702 in the acquisition pattern ID string 1201 whose existence is confirmed in step S 1805 from the acquisition pattern array including the acquisition pattern ID string 1201.
  • step S1810 the learning unit 1104 sets the next step number 701 numbered in step S1806 as the registration target step number 701 (step S1810). Then, the learning unit 1104 increments i (step S1811) and returns to step S1805.
  • step S1805 in the learning result table 1200 selected in step S1802, when the number of selections 1202 is 1 or more and the acquired pattern ID string 1201 with the number of IDs (i + 1) does not exist (step S1805: No), step The process moves to S1812.
  • step S1812 the learning unit 1104 has the registration target step number 701, the selected user ID 602 set in step S1810 of the previous loop, the acquired pattern ID string 1201 whose existence has been confirmed in step S1805 of the previous loop.
  • step S1801 when there is no unselected user ID 602, the learning unit 1104 ends the data acquisition estimation table update process (step S1304).
  • FIG. 19 is a flowchart illustrating a detailed processing procedure example 1 of the data acquisition processing by the data acquisition device 200.
  • the data acquisition apparatus 200 waits for login detection of the terminal 101 (step S1901: No).
  • the data acquisition device 200 acquires the user ID 602 from the terminal 101 and newly issues a session ID 603 (step S1902).
  • the data acquisition device 200 determines whether or not the entry of the acquisition user ID 602 in step S1902 exists in the data acquisition estimation table 700 (step S1903).
  • step S1903 when the entry of the acquisition user ID 602 in step S1902 exists in the data acquisition estimation table 700 (step S1903: Yes), data can be acquired in advance.
  • the data acquisition apparatus 200 acquires an entry whose acquisition pattern ID and representative attribute value 607 are NULL and matches the acquisition user ID 602 from the data acquisition estimation table 700 (step S1904). Then, the data acquisition apparatus 200 sets the activation timing 1001 of the advance acquisition process (FIG. 23) (step S1905).
  • the data acquisition device 200 specifies the step number 701 of the next acquisition timing array 703 including the highest selection probability from the next acquisition timing array field 703 in the entry acquired in step S1904, and the specified step
  • the acquisition pattern (pattern shape 606 and representative attribute value 702) corresponding to the entry of the number 701 is specified from the data acquisition estimation table 700.
  • the data acquisition device 200 sets the activation timing 1001 for the specified acquisition pattern.
  • the set activation timing 1001 is managed for each user ID 602 in the activation timing management table 1000 of FIG. Details of the setting of the activation timing 1001 of the pre-acquisition process (FIG. 23) have been described with reference to the timing chart of FIG.
  • the data acquisition apparatus 200 stores the step information in the step information management table 800 shown in FIG. 8 (step S1906).
  • the step information includes the acquisition user ID 602, the step number 701 (the step number 701 of the highest selection probability in the next acquisition timing array 703 of the acquisition entry in step S1904), and the previous step number 801 (in step S1904). Step number 701) of the acquisition entry.
  • the data acquisition apparatus 200 determines whether a data acquisition request has been received from the login terminal 101 (step S1907). When a data acquisition request is received from the login terminal 101 (step S1907: Yes), the process proceeds to step S2001 in FIG.
  • step S1907: No when the data acquisition request is not received from the login terminal 101 (step S1907: No), the data acquisition apparatus 200 determines whether or not the logout of the login terminal 101 is detected (step S1908). When logout of the login terminal 101 is not detected (step S1908: No), the process returns to step S1907. On the other hand, when logout of the login terminal 101 is detected (step S1908: Yes), the data acquisition device 200 ends the data acquisition process.
  • the data acquisition device 200 checks the entry of the prior acquisition information management table 900. (FIG. 20).
  • step S1903 if the entry of the acquisition user ID 602 in step S1902 does not exist in the data acquisition estimation table 700 (step S1903: No), the data acquisition apparatus 200 has received a data acquisition request from the login terminal 101. It is determined whether or not (step S1909). If received (step S1909: Yes), the data acquisition device 200 executes data acquisition / history accumulation processing (step S1910), and proceeds to step S1911. Details of the data acquisition / history accumulation processing (step S1910) will be described later with reference to FIG. If not received (step S1909: NO), the process proceeds to step S1911.
  • step S1911 the data acquisition apparatus 200 determines whether logout of the login terminal 101 has been detected (step S1911). When logout is not detected (step S1911: No), the process returns to step S1909. When logout is detected (step S1911: Yes), the data acquisition device 200 ends the data acquisition process.
  • Step S1910 the data acquisition device 200 performs the data acquisition / history accumulation process ( Step S1910) can be executed (FIG. 22).
  • FIG. 20 is a flowchart showing a detailed processing procedure example 2 of the data acquisition processing by the data acquisition device 200.
  • the data acquisition apparatus 200 stores the user ID 602 and the acquisition pattern (pattern shape 606 and attribute value included in the data acquisition request received in step S1907 in the pre-acquisition information management table 900 illustrated in FIG. 9. It is determined whether there is an entry corresponding to (607) (step S2001). In other words, the data acquisition device 200 determines whether or not the acquisition pattern in which the activation timing 1001 is set in steps S1905 and S1906 matches the acquisition pattern included in the data acquisition request received in step S1907. become.
  • step S2001 Yes
  • the data acquisition device 200 acquires the corresponding pre-acquisition data 901 from the pre-acquisition information management table 900 and transmits it to the login terminal 101 (step S2002).
  • the data acquisition device 200 registers data acquisition history information (user ID 602, session ID 603, data acquisition request time 604, data processing time 605, pattern shape 606, attribute value 607) in the data acquisition history accumulation table 600 (step S2003). ).
  • the user ID 602 is the user ID 602 acquired in step S1902 and included in the data acquisition request in step S1907.
  • the session ID 603 is the session ID 603 issued in step S1902.
  • the data acquisition request time 604 is the time of the data acquisition request in step S1907.
  • the data processing time 605 is the time from the data acquisition request time 604 to the completion of data acquisition, that is, output of XML data.
  • the pattern shape 606 and the attribute value 607 are the pattern shape 606 and the attribute value 607 included in the data acquisition request in step S1907.
  • the data acquisition device 200 sets the next activation timing 1001 of the pre-acquisition process (FIG. 23) (step S2004) and stores the step information in the step information management table 800 (step S2005), as in steps S1905 and S1906.
  • the set activation timing 1001 is managed for each user ID 602 in the activation timing management table 1000 of FIG.
  • the data acquisition apparatus 200 updates the step number 701 in the entry of the acquisition user ID 602 to the step number 701 of the highest selection probability in the next acquisition timing array 703 of the acquisition entry of the step number 701.
  • the previous step number 801 is updated to the previous step number 701.
  • the process returns to step S1907 in FIG.
  • step S2001: No when there is no entry in the pre-acquisition information management table 900 in step S2001 (step S2001: No), other acquisition patterns that are not acquisition patterns of the highest selection probability 1203 in the data acquisition request received in step S1907. Means that is selected.
  • step S2001: No the data acquisition device 200 executes data acquisition / history accumulation processing (step S2006).
  • step S2006 Data acquisition / history storage processing (step S2006) is the same processing as step S1910.
  • the data acquisition device 200 acquires the previous step number 801 in the entry of the acquisition user ID 602 from the step information management table 800 (step S2007). Then, the data acquisition apparatus 200 determines whether or not the next acquisition timing array 703 corresponding to the previous step number 801 acquired in step S2007 exists in the entry acquired in S1904 (step S2008).
  • step S2008: No If it does not exist (step S2008: No), the process returns to step S1907 in FIG. 19, and the data acquisition device 200 waits for a data acquisition request.
  • step S2008: Yes the data acquisition device 200 acquires one next acquisition timing array 703 corresponding to the previous step number 801 acquired in step S2007 (step S2009). Then, the data acquisition device 200 determines whether there is an acquisition pattern requested for acquisition in the entry of the transfer destination step number 701 in the next acquisition timing array 703 acquired in step S2009 in the data acquisition estimation table 700. (Step S2010).
  • step S2010: No If there is no acquisition pattern (step S2010: No), the process returns to step S1907 in FIG. 19, and the data acquisition apparatus 200 waits for a data acquisition request.
  • step S2010: Yes the acquisition pattern corresponds to the entry registered in the data acquisition / history accumulation process (step S2006). Therefore, the data acquisition apparatus 200 updates the step number 701 in the step information management table 800 to the transfer destination step number 701 in step S2010 to acquire in advance the data acquired next to the pattern shape 606 (step S2011). ), The next activation timing 1001 of the advance acquisition process (FIG. 23) is set using the updated transfer destination step number 701 (step S2012). Then, control goes to a step S1907. As a result, the next activation timing 1001 of the pre-acquisition process is set for another acquisition pattern that is not the acquisition pattern of the highest selection probability.
  • FIG. 21 is an explanatory diagram of an example of transfer of the acquired pattern sequence.
  • FIG. 21 is a tree structure of step number 701 in the next acquisition timing array 703 of the user ID: A001 shown in FIG. 7 (step number 701 is a node, and transition of step field 701 is a link). The number associated with the link is the selection probability.
  • the step number [U001] which is the highest node is the step number 701 when the user with the user ID: A001 logs in.
  • the user selects the acquisition pattern of step [U003] with a probability of 70%, and selects the acquisition pattern of step [U004] with a probability of 30%.
  • the data acquisition apparatus 200 acquires the entry in the first row of FIG. 7 from the data acquisition estimation table 700 in step S1904 of FIG. 19, and acquires the step number [U003] that is the highest selection probability (70%) in step S1905.
  • the start timing 1001 of the advance acquisition process is set for the pattern.
  • the data acquisition apparatus 200 stores the selected step number [U003] as the step number 701 in the step information management table 800, and the previous step number 801 as the step number [U001] before the selection. Is stored.
  • step S2001 the data acquisition device 200 determines whether or not the acquisition pattern in the actually received data acquisition request matches the acquisition pattern in step [U003]. If they match (step S2001: Yes), the data acquisition apparatus 200 transmits data corresponding to the acquisition pattern of step [U003] acquired in advance at the start timing 1001 in step S1905 to the terminal 101 of the user with the user ID: A001. (Step S2002).
  • step S2001 determines that there is a mismatch in step S2001 (step S2001: No)
  • the data requested by the user is not data corresponding to the acquisition pattern of step [U003] acquired in advance at activation timing 1001 in step S1905. Means. Therefore, the data acquisition device 200 acquires data corresponding to the actual data acquisition request from the power NW model DB 104 and accumulates the history (step S2006). As a result, even when the prediction is lost, the subsequent prediction accuracy (selection probability 1203) can be improved by accumulating and learning as past data.
  • the data acquisition device 200 acquires [U001] as the previous step number 801 of the acquisition user ID 602 from the step information management table 800 in step S2007.
  • the data acquisition apparatus 200 determines whether the next acquisition timing array 703 corresponding to the acquired previous step number [U001] is in the data acquisition estimation table 700.
  • Step S2008: Yes since the next acquisition timing array 703 of the step number [U003] with a selection probability of 30% that has not been selected last time exists (step S2008: Yes), the data acquisition device 200 has the next acquisition timing array 703 ⁇ Step number [U004] is selected from [U004] [1] [30] ⁇ (step S2009). The selected step number [U004] is the “migration destination step number 701”.
  • step S1907 the data acquisition apparatus 200 sets the entry of the transfer destination step number [U004] in ⁇ [U004] [1] [30] ⁇ that is the next acquisition timing array 703 in the data acquisition estimation table 700 in step S1907. It is determined whether there is an acquisition pattern for which a data acquisition request has been made (step S2010). If it exists (step S2010: Yes), it means that the acquisition pattern requested for data acquisition in step S2005 matches the acquisition pattern of step number [U004]. Therefore, the data acquisition apparatus 200 updates the step number 701 from the step number [U003] to the transfer destination step number [U004] in the entry of the user ID: A001 in the step information management table 800.
  • the data acquisition apparatus 200 performs an advance acquisition process for the acquisition pattern for the entry corresponding to the step number 701 ([U011]) of the highest selection probability (65%) in the next acquisition timing array 703 of the step number [U004].
  • the activation timing 1001 is set (step S2012).
  • the data acquisition apparatus 200 can switch from the route [U001] ⁇ [U003] to be acquired in advance to the route [U001] ⁇ [U004] in accordance with the data acquisition request actually received. In this way, in order to execute the pre-acquisition process following the user's actual data acquisition request, it is possible to continue the pre-acquisition by the transfer in the case where the acquisition pattern to be acquired in advance is not predicted. it can.
  • FIG. 22 is a flowchart illustrating a detailed processing procedure example of the data acquisition / history accumulation processing (steps S1910, S2006, and S2611) illustrated in FIGS. 19 and 20.
  • the data acquisition / history accumulation processing (steps S1910, S2006, S2611) acquires data corresponding to the acquisition pattern (a combination of the pattern shape 606 and the attribute value 607) selected in the data acquisition request, and the history is stored as data. This is a process of accumulating in the acquisition history accumulation table 600.
  • the data acquisition device 200 transmits a data acquisition request to the power NW model DB 104 and acquires the data acquisition request time 604 (step S2201).
  • the data acquisition device 200 acquires data corresponding to the acquisition pattern (pattern shape 606 and attribute value 607) of the data acquisition request from the power NW model DB 104 (step S2202), and converts it into XML data (step S2203).
  • the data acquisition device 200 calculates the time from the data acquisition request time 604 to the output of the XML data in step S2203 as the data processing time 605 (step S2204).
  • the data acquisition device 200 transmits the converted XML data to the login terminal 101 (step S2205). Then, the data acquisition device 200 registers data acquisition history information (user ID 602, session ID 603, data acquisition request time 604, data processing time 605, pattern shape 606, attribute value 607) in the data acquisition history accumulation table 600 (step S2206). As a result, a series of processing ends.
  • data acquisition history information user ID 602, session ID 603, data acquisition request time 604, data processing time 605, pattern shape 606, attribute value 607
  • FIG. 23 is a flowchart illustrating a detailed processing procedure example of the data pre-acquisition processing.
  • the data pre-acquisition process is started at the start timing 1001 set in steps S1905, S2004, and S2012, and starts the process.
  • the data acquisition device 200 waits until the start timing 1001 is reached (step S2301: No).
  • the data acquisition apparatus 200 acquires the step number 701 in the entry of the acquisition user ID 602 in step S1902 from the step information management table 800 (step S2302).
  • the data acquisition device 200 acquires the pattern shape 606 and the representative attribute value 702 in the entry of the acquisition step number 701 from the data acquisition estimation table 700 (step S2303).
  • the data acquisition device 200 acquires data satisfying the pattern shape 606 and the representative attribute value 702 from the power NW model DB 104 (step S2304). Then, the data acquisition device 200 converts the acquired data into XML data and sets it as pre-acquisition data 901 (step S2305). The data acquisition apparatus 200 registers the pre-acquisition information (user ID 602, pattern shape 606, attribute value 607, pre-acquisition data 901) in the prior acquisition information management table 900 (step S2306).
  • the data acquisition device 200 waits for the pre-acquisition data 901 to be processed, that is, read from the pre-acquisition information management table 900 in step S2002 and transmitted to the login terminal 101 (step S2307: No). ).
  • the data acquisition device 200 deletes the entry from the pre-acquisition information management table 900 (step S2308).
  • the data acquisition device 200 may delete the entry of the user ID 602 from the pre-acquisition information management table 900.
  • the data required at that time is prefetched, it is possible to immediately respond to the request source terminal 101 when a data acquisition request is made. In particular, it is useful when it takes time to acquire data such as conversion to XML data.
  • Embodiment 2 is an example in which data required by a new user who has not accumulated data acquisition history information is estimated, and data is acquired in advance at a necessary timing.
  • the data acquisition device 200 learns for each application ID. Data required by a new user is estimated based on the result, and data is acquired in advance at the necessary timing. That is, since the tendency of a new user is not known, the data acquisition apparatus 200 estimates the tendency by the application 102 to be used and acquires in advance. This speeds up the data response to the new user.
  • it since it demonstrates based on the process of Example 1 here, it demonstrates paying attention to a different location.
  • FIG. 24 is an explanatory diagram of an example of stored contents of the data acquisition history accumulation table 600 according to the second embodiment.
  • the data acquisition history accumulation table 600 is a table in which an application ID field 2401 is added to the data acquisition history accumulation table 600 of the first embodiment.
  • An application ID field 2401 is a storage area for storing an application ID.
  • the application ID 2401 is identification information that uniquely identifies the application 102.
  • FIG. 25 is an explanatory diagram of an example of stored contents of the second data acquisition estimation table.
  • the data acquisition estimation table 700 of the first embodiment is referred to as a “first data acquisition estimation table 700”.
  • the second data acquisition estimation table 2500 is a table in which the user ID field 602 of the first data acquisition estimation table 700 is replaced with an application ID field 2401.
  • FIG. 26 is a flowchart of a detailed process procedure example 1 of the data acquisition process performed by the data acquisition apparatus 200 according to the second embodiment.
  • the data acquisition device 200 waits for login detection of the terminal 101 (step S2601: No).
  • the data acquisition apparatus 200 acquires the user ID 602 and the application ID 2401 being used from the terminal 101, and newly issues a session ID 603 (step S2602).
  • step S2603 determines whether the entry of the acquisition user ID 602 in step S2602 exists in the first data acquisition estimation table 700 (step S2603). If it does not exist (step S2603: NO), data cannot be acquired in advance for the acquired user ID 602, and the process proceeds to step S2604. When it exists (step S2603: Yes), the process proceeds to step S2605.
  • step S2604 the data acquisition device 200 determines whether an entry of the acquisition application ID 2401 exists in the second data acquisition estimation table 2500 (step S2604).
  • step S2603 or S2604 when the entry of the acquisition user ID 602 or application ID 2401 in step S2602 exists in the first data acquisition estimation table 700 or the second data acquisition estimation table 2500 (step S2603: Yes, S2604: Yes), Data can be acquired in advance.
  • the data acquisition apparatus 200 includes an entry whose acquisition pattern ID and representative attribute value 702 are NULL and matches the acquisition ID (step S2603: user ID 602 if Yes, step S2604: application ID 2401 if Yes). Obtained from the data acquisition estimation table 700 (first data acquisition estimation table 700 for user ID 602, second data acquisition estimation table 2500 for application ID 2401) (step S2605).
  • the data acquisition device 200 sets the start timing 1001 of the pre-acquisition process (FIG. 23) (step S2606).
  • the set activation timing 1001 is managed for each user ID 602 in the activation timing management table 1000 of FIG. Details of the setting of the activation timing 1001 of the pre-acquisition process (FIG. 23) have been described with reference to the timing chart of FIG.
  • the data acquisition device 200 stores the step information in the step information management table 800 shown in FIG. 8 (step S2607).
  • the step information includes the acquisition user ID 602, the step number 701 (the step number 701 of the highest selection probability in the next acquisition timing array 703 of the acquisition entry in step S2605), and the previous step number 801 (in step S2605). Step number 701) of the acquisition entry.
  • the data acquisition apparatus 200 determines whether a data acquisition request is received from the login terminal 101 (step S2608). When a data acquisition request is received from the login terminal 101 (step S2608: Yes), the process proceeds to step S2001 in FIG.
  • step S2608 determines whether or not the logout of the login terminal 101 is detected (step S2609).
  • step S2609: No the process returns to step S2608.
  • step S2609: Yes the data acquisition device 200 ends the data acquisition process.
  • the acquisition user ID 602 exists in the first data acquisition estimation table 700 or the acquisition application ID 2401 exists in the second data acquisition estimation table 2500, data acquisition is performed when a data acquisition request is received from the login terminal 101.
  • the apparatus 200 can confirm the entry of the pre-acquired information management table 900 (FIG. 20).
  • step S2604 if there is no entry for the acquisition application ID 2401 (step S2604: No), the data acquisition device 200 determines whether a data acquisition request is received from the login terminal 101 (step S2610). If not received (step S2610: NO), the process proceeds to step S2612. If it is received (step S2610: Yes), the data acquisition device 200 executes data acquisition / history accumulation processing (step S2611), and proceeds to step S2612.
  • the data acquisition / history storage process is the same as the data acquisition / history storage process (step S1910) shown in FIG. 22, except that the application ID 2401 is also registered as data acquisition history information. .
  • the data acquisition device 200 determines whether or not logout of the login terminal 101 has been detected (step S2612). When logout is not detected (step S2612: No), the process returns to step S2610. When logout is detected (step S2612: Yes), the data acquisition device 200 ends the data acquisition process.
  • the data acquisition device 200 can execute the data acquisition / history accumulation process (step S2611) (FIG. 22).
  • the data acquisition apparatus 200 estimates the tendency using the application 102 to be used and acquires in advance, thereby speeding up the data response to the new user. be able to.
  • the application ID 2401 and the application ID field 2401 have been described.
  • the function ID and function ID field of the application 102, or the organization ID and organization ID field to which the user belongs may be replaced.
  • Embodiment 3 is an example (difference acquisition) in which data excluding duplicate portions is acquired in advance when there is already acquired data in the data acquired in advance in Embodiment 1. If there is already acquired data in the data acquired in advance in the next step, the data conversion processing acquired from the power NW model DB 104 can be reduced if the data is acquired in advance excluding the overlapping part with the data in the previous step. The response can be speeded up. In addition, since it demonstrates based on the process of Example 1 here, it demonstrates paying attention to a different location.
  • FIG. 27 is an explanatory diagram of an example of preliminary data acquisition according to the third embodiment.
  • the user acquires data by selecting an acquisition pattern of a circle having a diameter of 3 km in the first data acquisition request.
  • the data acquisition device 200 changes the acquisition pattern of a circle with a diameter of 5 km from the acquisition pattern of a circle with a diameter of 5 km.
  • Data is acquired from the power NW model DB 104 for the excluded range (in this case, a donut shape). Then, the data acquisition device 200 merges the first acquired data (XML data) and the current (second) XML data and returns the merged data to the terminal 101.
  • the data acquisition device 200 acquires a second circle with a diameter of 5 km from the acquisition pattern of a circle with a diameter of 7 km.
  • Data is acquired from the power NW model DB 104 for a range excluding the pattern (in this case, a donut shape is also obtained).
  • the data acquisition device 200 merges the acquired data (XML data) after the second merge and the current (third) XML data and returns the merged data to the terminal 101.
  • FIG. 28 is a flowchart of a detailed process procedure example of the data pre-acquisition process according to the third embodiment.
  • the data pre-acquisition process is started at the start timing 1001 set in steps S1905, S2004, and S2012, and starts the process.
  • the data acquisition device 200 waits until the start timing 1001 (step S2801: No).
  • the data acquisition device 200 acquires the step number 701 and the previous step number 801 in the entry of the acquisition user ID 602 in step S1902 from the step information management table 800 (step S2802).
  • the data acquisition apparatus 200 includes the pattern shape 606 and the representative attribute value 702 (acquisition pattern) in the entry of the acquisition step number 701, and the pattern shape 606 and the representative attribute value 702 (previous acquisition pattern) in the acquired entry of the previous step number 801. Is acquired from the data acquisition estimation table 700 (step S2803).
  • the data acquisition apparatus 200 determines whether the acquisition pattern and the previous acquisition pattern overlap (step S2804). When not overlapping (step S2804: No), the data acquisition device 200 acquires data satisfying the pattern shape 606 and the representative attribute value 702 from the power NW model DB 104 (step S2805). Then, the data acquisition device 200 converts the acquired data into XML data and sets it as pre-acquisition data 901 (step S2806). The data acquisition apparatus 200 registers the pre-acquisition information (user ID 602, pattern shape 606, attribute value 607, pre-acquisition data 901) in the pre-acquisition information management table 900 (step S2807).
  • pre-acquisition information user ID 602, pattern shape 606, attribute value 607, pre-acquisition data 901
  • step S2804 determines whether they overlap (step S2804: Yes) or not overlap (step S2804: Yes).
  • the data acquisition device 200 acquires data satisfying the difference conditional expression from the power NW model DB 104 (step S2809).
  • the data acquisition device 200 converts the acquired data into XML data, and merges it with the previously acquired XML data to obtain the pre-acquired data 901 (step S2810).
  • the data acquisition device 200 registers the pre-acquisition information (user ID 602, pattern shape 606, attribute value 607, pre-acquisition data 901) in the prior acquisition information management table 900 (step S2811).
  • the data acquisition device 200 may delete the entry of the user ID 602 from the pre-acquisition information management table 900.
  • the third embodiment it is not necessary to convert the data in the overlapping portion, and an immediate response can be made to the request source terminal 101.
  • Example 4 is an example of adjusting the start timing 1001 when the data processing times 605 of a plurality of users overlap.
  • the data acquisition apparatus 200 determines that the plurality of start timings 1001 (start of the data processing time 605) so that the duplication number of the data processing time 605 is less than the duplication number before adjustment. Time). Thereby, the load of the prior acquisition process can be reduced as compared with before adjustment.
  • FIG. 29 is an explanatory diagram of an example of adjusting the start timing 1001 according to the fourth embodiment.
  • (A) shows the state before adjustment
  • (B) shows the state after adjustment.
  • the multiplicity (an integer of 1 or more) is set to 2.
  • the multiplicity is the maximum number of average data processing times that allow duplication, and is equal to or less than the user duplication number ⁇ 1, in other words, equal to or less than the duplication number ⁇ 1 of the average data processing time.
  • dpa to dpd are average data processing times of the four users (see the time chart in FIG. 10)
  • ta to td are the activation timings 1001. It should be noted that ta and tb that are the start timing 1001 are the same time (for example, 10:21) (may be different times).
  • the average data processing times dpa to dpd overlap in the period alt.
  • the data acquisition apparatus 200 adjusts each average data processing time so that the average data processing time overlap number is 2 or less. As shown in (B), the data acquisition device 200 keeps the average data processing times dpa and dpb fixed, and shifts the average data processing times dpc and dpd so as not to overlap with the average data processing times dpa and dpb. .
  • this shift amount may be adjusted so that the difference from the start timing 1001 before the shift becomes small.
  • the time next to the end time of the average data processing time to be shifted may be the start timing 1001 of the average data processing time that is not to be shifted.
  • the time next to the end time of the average data processing time may be the start timing 1001 of the average data processing time to be shifted.
  • the data acquisition apparatus 200 determines that the multiplicity is 1 (that is, does not overlap) unless the average data processing time of other users other than the four users overlaps. You may adjust so that it may become. As described above, when the data acquisition device 200 is set so that the processing load of the data acquisition device 200 is more important than the deviation of the activation timing 1001, the multiplicity may be adjusted to be lower.
  • the activation timing 1001 is adjusted by detecting the overlap of the average data processing time.
  • the activation timing 1001 is adjusted by detecting the overlap of the activation timing 1001. Also good.
  • the adjustment process can be simplified.
  • FIG. 30 is a flowchart illustrating an example of the adjustment processing procedure of the activation timing 1001. The flowchart is executed, for example, at the timing when the latest activation timing 1001 is set.
  • the data acquisition device 200 acquires the pattern shape 606 from the data acquisition estimation table 700 for each of the user IDs 602 corresponding to the plurality of activation timings 1001 that have been set and have not arrived (step S3001).
  • the data acquisition apparatus 200 refers to the data acquisition history accumulation table 600, acquires the data processing time 605 in the pattern shape 606 acquired in step S3001, and average data processing in the acquired pattern shape 606 for the user. The time is calculated for each user ID 602 (step S3002).
  • the data acquisition apparatus 200 determines whether or not the average data processing time from the activation timing 1001 of each user ID 602 overlaps (step S3003).
  • the data acquisition device 200 determines that there is no overlap (step S3003: No), and if the multiplicity is exceeded, the data acquisition device 200 It is determined that they overlap (step S3003: Yes).
  • step S3003: No If there is no overlap (step S3003: No), the data acquisition device 200 ends the adjustment process of the activation timing 1001. On the other hand, if they overlap (step S3003: Yes), the data acquisition device 200 adjusts each activation timing 1001 based on the multiplicity, and updates the activation timing management table 1000 for the adjusted activation timing 1001 (step S3004). . Thereby, the data acquisition device 200 ends the adjustment process of the activation timing 1001.
  • a data acquisition request is made by estimating a data acquisition request that the user will request and acquiring data corresponding to the data acquisition request in advance. Data can be provided to the user immediately. Therefore, it is possible to suppress response delay of data acquired in response to a request.
  • the data acquisition device 200 performs data acquisition in advance by changing the acquisition pattern sequence. Can be run continuously. Further, by learning the different data acquisition requests, it is possible to improve the estimation accuracy of data prior acquisition thereafter.
  • the request source is a terminal that identifies the user (worker), it is possible to learn an acquisition pattern unique to the user.
  • the request source may be the application 102 used by a plurality of users. Thereby, an acquisition pattern unique to the application 102 can be learned. As a result, even for a new user, data can be acquired in advance by specifying the application 102 to be used.
  • the advance acquisition process can be speeded up by acquiring in advance excluding the overlapping part.
  • the load on the data acquisition device 200 can be reduced by adjusting the number of overlaps so as to be less than the number of users according to the multiplicity.
  • the power NW model using power equipment as a node has been described as an example, but the present invention can also be applied to other data.
  • the node is a store, and the attributes are sales per month, number of customers per month, age group of customers with the highest sales, and store location. That's fine.
  • the classified data data of stores having the largest number of customers in their 60s, sales of 10 million yen or more, and the number of customers of 1,000 or less are acquired and analyzed. Usage is possible.
  • the acquisition pattern step can be estimated.
  • the present invention is not limited to the above-described embodiments, and includes various modifications and equivalent configurations within the scope of the appended claims.
  • the above-described embodiments have been described in detail for easy understanding of the present invention, and the present invention is not necessarily limited to those having all the configurations described.
  • a part of the configuration of one embodiment may be replaced with the configuration of another embodiment.
  • each of the above-described configurations, functions, processing units, processing means, etc. may be realized in hardware by designing a part or all of them, for example, with an integrated circuit, and the processor realizes each function. It may be realized by software by interpreting and executing the program to be executed.
  • Information such as programs, tables, and files for realizing each function is recorded on a memory, a hard disk, a storage device such as SSD (Solid State Drive), or an IC (Integrated Circuit) card, SD card, DVD (Digital Versatile Disc). It can be stored on a medium.
  • SSD Solid State Drive
  • IC Integrated Circuit
  • SD card Digital Card
  • DVD Digital Versatile Disc
  • control lines and information lines indicate what is considered necessary for the explanation, and do not necessarily indicate all control lines and information lines necessary for mounting. In practice, it can be considered that almost all the components are connected to each other.

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

L'invention concerne un dispositif d'acquisition de données pour acquérir des données à partir d'une base de données selon une requête d'acquisition de données provenant d'un demandeur demandant des données à partir de la base de données, qui stocke un groupe de données, et renvoyer lesdites données au demandeur, le dispositif d'acquisition de données étant configuré de façon à: apprendre le type de requête d'acquisition de données et la synchronisation d'acquisition définissant l'ordre chronologique de requête d'acquisition de données pour chacune des requêtes d'acquisition de données parmi une série de requêtes d'acquisition de données reçues en provenance du demandeur; identifier, à l'avance d'une première requête d'acquisition de données suivant la série de requêtes d'acquisition de données, la synchronisation d'acquisition et le type d'une première requête d'acquisition de données estimée ultérieure qui est une requête d'acquisition de données qui pourrait être reçue en provenance du demandeur, sur la base des résultats d'apprentissage obtenus à partir du traitement d'apprentissage; acquérir, à partir de la base de données, des données correspondant à la première demande d'acquisition de données estimée ultérieure pour laquelle le type a été identifié; déterminer, lorsque la première demande d'acquisition de données est reçue, s'il existe ou non une correspondance entre le type inclus dans la première demande d'acquisition de données et le type de la première demande d'acquisition de données estimée ultérieure identifiée par le traitement d'identification; et lorsqu'il est déterminé qu'il existe une correspondance, transmettre les résultats d'acquisition d'avance au demandeur au moment d'acquisition de la première demande d'acquisition de données estimée ultérieure identifiée.
PCT/JP2017/038685 2017-02-17 2017-10-26 Dispositif d'acquisition de données, procédé d'acquisition de données et programme d'acquisition de données WO2018150639A1 (fr)

Priority Applications (1)

Application Number Priority Date Filing Date Title
JP2018537684A JP6591080B2 (ja) 2017-02-17 2017-10-26 データ取得装置、データ取得方法、およびデータ取得プログラム

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
JPPCT/JP2017/005900 2017-02-17
PCT/JP2017/005900 WO2018150539A1 (fr) 2017-02-17 2017-02-17 Dispositif d'acquisition de données, procédé d'acquisition de données et programme d'acquisition de données

Publications (1)

Publication Number Publication Date
WO2018150639A1 true WO2018150639A1 (fr) 2018-08-23

Family

ID=63169237

Family Applications (2)

Application Number Title Priority Date Filing Date
PCT/JP2017/005900 WO2018150539A1 (fr) 2017-02-17 2017-02-17 Dispositif d'acquisition de données, procédé d'acquisition de données et programme d'acquisition de données
PCT/JP2017/038685 WO2018150639A1 (fr) 2017-02-17 2017-10-26 Dispositif d'acquisition de données, procédé d'acquisition de données et programme d'acquisition de données

Family Applications Before (1)

Application Number Title Priority Date Filing Date
PCT/JP2017/005900 WO2018150539A1 (fr) 2017-02-17 2017-02-17 Dispositif d'acquisition de données, procédé d'acquisition de données et programme d'acquisition de données

Country Status (2)

Country Link
JP (1) JP6591080B2 (fr)
WO (2) WO2018150539A1 (fr)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109688121B (zh) * 2018-12-17 2022-11-04 中国平安财产保险股份有限公司 资源数据获取方法、装置、计算机设备和存储介质

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH1173425A (ja) * 1997-08-29 1999-03-16 Oki Electric Ind Co Ltd 電子ファイルシステム
JPH11120069A (ja) * 1997-10-17 1999-04-30 Hitachi Ltd データ先読み方法
JP2001256099A (ja) * 2000-03-09 2001-09-21 Seiko Epson Corp アクセス制御装置
JP2003150419A (ja) * 2001-11-14 2003-05-23 Hitachi Ltd データベース管理システムの実行情報を取得する手段を有する記憶装置
JP2006260067A (ja) * 2005-03-16 2006-09-28 Internatl Business Mach Corp <Ibm> 先読み装置、先読み方法、および先読みプログラム
WO2013175625A1 (fr) * 2012-05-25 2013-11-28 株式会社日立製作所 Procédé de gestion de base de données, dispositif de gestion de base de données, et support de stockage

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JPH1173425A (ja) * 1997-08-29 1999-03-16 Oki Electric Ind Co Ltd 電子ファイルシステム
JPH11120069A (ja) * 1997-10-17 1999-04-30 Hitachi Ltd データ先読み方法
JP2001256099A (ja) * 2000-03-09 2001-09-21 Seiko Epson Corp アクセス制御装置
JP2003150419A (ja) * 2001-11-14 2003-05-23 Hitachi Ltd データベース管理システムの実行情報を取得する手段を有する記憶装置
JP2006260067A (ja) * 2005-03-16 2006-09-28 Internatl Business Mach Corp <Ibm> 先読み装置、先読み方法、および先読みプログラム
WO2013175625A1 (fr) * 2012-05-25 2013-11-28 株式会社日立製作所 Procédé de gestion de base de données, dispositif de gestion de base de données, et support de stockage

Also Published As

Publication number Publication date
WO2018150539A1 (fr) 2018-08-23
JP6591080B2 (ja) 2019-10-16
JPWO2018150639A1 (ja) 2019-02-21

Similar Documents

Publication Publication Date Title
CN104903894B (zh) 用于分布式数据库查询引擎的系统和方法
JP6162781B2 (ja) 新しい興味のある地点の位置を決定する方法及び装置
CN105243169B (zh) 一种数据查询方法及系统
CN109376971B (zh) 一种面向电力用户的负荷曲线预测方法及系统
CN107679192A (zh) 多集群协同数据处理方法、系统、存储介质及设备
WO2013183115A1 (fr) Système et programme de gestion de journaux
CN104871154A (zh) 系统级查询优化
CN110609844A (zh) 一种数据更新方法，装置及系统
JP7119630B2 (ja) 情報処理装置、情報交換システム、情報処理方法および情報処理プログラム
CN103299267A (zh) 用于执行多租户存储中的交叉存储连接的方法和系统
US20180173767A1 (en) System and method for facilitating queries via request-prediction-based temporary storage of query results
US10055459B2 (en) Query hint management for a database management system
JP2019125283A (ja) クエリ生成支援方法及びクエリ生成支援装置
CN102761602A (zh) 一种基于Hadoop的海量数据实时分析处理方法
CN104615734B (zh) 一种社区管理服务大数据处理系统及其处理方法
WO2018006023A1 (fr) Module de requête de données de séries chronologiques
JP6591080B2 (ja) データ取得装置、データ取得方法、およびデータ取得プログラム
CN107491463A (zh) 数据查询的优化方法和系统
JP2015194797A (ja) 監視漏れ特定処理プログラム，監視漏れ特定処理方法及び監視漏れ特定処理装置
JP2014146123A (ja) サーバシステム、及びデータ処理方法
CN104113590B (zh) 一种基于副本响应时间预测的副本选择方法
JP2024541021A (ja) 商品購入のキーベースの取扱い
CN103401715B (zh) 跨网络应急资源的管理方法和系统
Borzemski et al. Using data mining algorithms in web performance prediction
JP2015149024A (ja) 検索システムおよびその制御方法、並びにプログラム

Legal Events

Date Code Title Description
ENP Entry into the national phase

Ref document number: 2018537684

Country of ref document: JP

Kind code of ref document: A

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

Ref document number: 17896977

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: 17896977

Country of ref document: EP

Kind code of ref document: A1

点击 这是indexloc提供的php浏览器服务，不要输入任何密码和下载