JP2009230675A - Information provision device, information provision method and information provision system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a technique for accelerating information provision service. <P>SOLUTION: A database device 100 includes a plurality of master tables prepared for each business attribute. A cache device 200 includes a table for display in which display object data used for an information provision screen has been stored among pieces of master data stored in the plurality of master tables. A customer support device 300 obtains the display object data from the table for display of the cache device 200 when accepting a request of the information provision screen from a customer terminal 600, sets the display object data to data of the information provision screen to provide it to the customer terminal 600. <P>COPYRIGHT: (C)2010,JPO&INPIT

Description

  The present invention relates to a data processing technique, and more particularly to an information providing apparatus, an information providing method, and an information providing system that provide information to a user.

Along with the development of IT, securities companies provide online information provision services to customers. The present applicant has proposed a technique for causing a web server to cache a copy of master data serving as original information in a company in order to realize prompt information provision (see, for example, Patent Document 1).
JP 2006-164075 A

  The number of requests from customers requesting information provision is expected to increase in the future. If the response time of the information providing service increases as the number of requests increases, the convenience for the user is impaired. In view of this background, the present inventor considered that further speeding up of the information providing service is necessary.

  The present invention has been completed based on the above-mentioned attention of the present inventor, and its main object is to provide a technique for speeding up the information providing service.

  In order to solve the above problems, an information providing apparatus according to an aspect of the present invention includes a plurality of master tables prepared for each business attribute in which master data is stored, and master data stored in the plurality of master tables. Among them, the display table that retrieves and stores the display target data used on the specific screen provided to the user, and the display target data stored in the display table when the user requests reference to the specific screen And a reference processing unit that provides the user with data of a specific screen.

  Another aspect of the present invention is an information providing method. This method is an information providing method using a computer having a processor and a storage device, and a specific screen provided to a user among master data stored in a plurality of master tables prepared for each business attribute. To retrieve the display target data used in the database and store it in the display table, and set the display target data stored in the display table as the data for the specific screen when the user requests a specific screen reference And providing the user with a step.

  Yet another embodiment of the present invention is an information providing system. The information providing system includes a database device that manages data updated from an external device, and a user support device that manages data referenced by a user. When the master data stored in each master attribute stored in the master table and the master data stored in the plurality of master tables are updated, the database device stores the updated master data in the user support device. An update notification unit for notifying. The user support device includes a plurality of copy tables prepared for each business attribute in which copy data that is a copy of the master data is stored, an update processing unit that updates the copy data with the master data notified from the database device, Among the copy data stored in multiple copy tables, when the display table that retrieves and stores the display target data used on the specific screen provided to the user, and when the user is requested to refer to the specific screen A reference processing unit that sets display target data stored in the display table as data of a specific screen and provides the data to the user.

  Yet another embodiment of the present invention is also an information providing system. This information providing system manages a database device that manages data updated from an external device, and data that is associated with a part of a plurality of users and that is referred to by the part of users. A plurality of cache devices, and a plurality of user support devices that respectively correspond to some users among the plurality of users and receive reference requests from the some users. The database device includes a plurality of master tables prepared for each business attribute storing master data of each of a plurality of users, and updated master data when master data stored in the plurality of master tables is updated. And an update notification unit that notifies each of the plurality of cache devices. Each of the plurality of cache devices includes a plurality of copy tables prepared for each business attribute in which copy data that is a copy of the master data is stored, and an update process for updating the copy data with the master data notified from the database device And a display table for extracting and storing display target data used on a specific screen provided to a user associated with the user apparatus among copy data stored in a plurality of copy tables. . Each of the plurality of user support devices receives the display target data of the user from the display table of the cache device associated with the user when the user associated with the device is requested to refer to a specific screen. A screen setting unit that acquires and sets specific screen data; and a screen transmission unit that provides the user with specific screen data.

  It should be noted that any combination of the above-described constituent elements and the expression of the present invention converted between the apparatus, method, system, program, recording medium storing the program, etc. are also effective as an aspect of the present invention.

  According to the present invention, the information providing service can be speeded up.

  In a company that provides an information providing service, it is important to maintain a response time for an information providing request from a customer within a certain time in order not to reduce customer convenience. In order to cope with the increasing number of information provision requests, conventionally, it has been common to load balance information provision requests by a plurality of information provision devices.

  The present specification proposes a technique for responding to an increasing information provision request by improving the efficiency of the information provision processing generated in the information provision system in response to the information provision request. Specifically, data used on the information provision screen provided to the customer by the information provision system (hereinafter referred to as “display target data”) is created in advance, and this information is received when an information provision request is received. Display target data is set on the information provision screen and provided to the customer. As a result, the load generated in each information providing process is reduced, and a large number of information providing requests can be handled.

FIG. 1 is a configuration diagram of a securities information providing system according to an embodiment of the present invention.
The securities information providing system 10 is a system of a securities company and provides various information to customers. The securities information providing system 10 is connected to a customer terminal 600 via an external network 500. The customer terminal 600 is a general web client terminal equipped with a web browser, and is typically a PC or a mobile phone. The customer operates the customer terminal 600 to access the securities information providing system 10 and refers to the information providing screen.

  In the securities information providing system 10, a database device 100, a cash device 200, and a customer support device 300 are connected via an in-house network 400. The database device 100 is data updated from an external device, and manages original information (hereinafter referred to as “master data”) at a securities company for securities brands held by a user.

  The cache device 200 is data referred to by the user, and manages master data copy data (hereinafter referred to as “copy data”) and display target data on a specific information provision screen extracted from the copy data. . The customer support device 300 receives an information provision request from the customer terminal 600, acquires display target data from the cache device 200, and provides the customer terminal 600 with data of an information provision screen in which the display target data is set.

  There is a portfolio screen as one of the screens that the securities information providing system 10 provides to the customer terminal 600 and in which the display target data is held in the cash device 200 in advance. FIG. 2 is a screen view of the portfolio screen. The portfolio screen 602 displays information on securities brands held by customers identified by branch numbers and account numbers, such as stock brands, bond brands, and investment trust brands.

  FIG. 3 is a block diagram showing a functional configuration of the database apparatus 100 of FIG. Each block shown in the block diagram of the present specification can be realized in terms of hardware by an element such as a CPU of a computer or a mechanical device, and in terms of software, it can be realized by a computer program or the like. The functional block realized by those cooperation is drawn. Therefore, it is understood by those skilled in the art that these functional blocks can be realized in various forms by a combination of hardware and software, and is not limited to any of these.

  Further, in each device in the present specification, an operation system (hereinafter referred to as “OS”) that provides a function and environment for efficiently using the device and controls the entire device in an integrated manner. It is running. A plurality of software is executed by operating each functional block in the block diagram by the OS.

  The database device 100 includes a stock master table 102, a bond master table 104, an investment trust master table 106, an update request receiving unit 108, and an update notification unit 110.

  The stock master table 102 is a storage area in which master data (hereinafter referred to as “stock master data”) regarding stock brands held by customers is stored. The bond master table 104 is a storage area in which master data (hereinafter referred to as “bond master data”) regarding bond brands held by customers is stored. The investment trust master table 106 is a storage area in which master data (hereinafter referred to as “investment trust master data”) regarding an investment trust held by a customer is stored.

  The stock master table 102, the bond master table 104, and the investment trust master table 106 are tables prepared for each business attribute according to business circumstances in the securities company. Further, it may be further divided into a plurality of tables according to the normalization of the database. The stock master table 102, bond master table 104, and investment trust master table 106 are non-volatile and highly reliable external storage devices, typically a hard disk device having a RAID configuration, as recording media.

  FIG. 4A shows the data structure of stock master data. FIG. 4B shows the data structure of bond master data. FIG. 4C shows the data structure of investment trust master data. In any of the figures, the custody ID column is key data for uniquely specifying a record of each master table. The customer ID column is data for uniquely identifying a customer who holds the stock name of each record. Returning to FIG.

  The update request receiving unit 108 receives update request data for the stock master table 102, bond master table 104, and investment trust master table 106 from an external device, and updates each table according to the update request data. All the master tables may be updated according to one update request data, or only a part of the master tables may be updated. Further, the external device that is the transmission source of the update request data may be the customer support device 300, or another device (not shown) inside or outside the securities company.

  The update notification unit 110 detects the update of the master data stored in the stock master table 102, the bond master table 104, and the investment trust master table 106. Specifically, the update notification unit 110 detects the update of the master data by receiving a database trigger provided by the database management system installed in the database device 100, for example, a notification by a preset INSERT trigger or UPDATE trigger. . The update notification unit 110 transmits to the cache device 200 the data notified from the database trigger, here the master table name storing the updated master data and the update data of the master data.

  FIG. 5 is a block diagram showing a functional configuration of the cache device of FIG. The cash apparatus 200 includes a stock copy table 202, a bond copy table 204, an investment trust copy table 206, a display table 208, an update processing unit 210, a first data setting unit 212, and a first data providing unit. 214, a second data setting unit 216, and a second data providing unit 218.

  The stock copy table 202 is a storage area in which copy data of stock master data stored in the stock master table 102 (hereinafter referred to as “stock copy data”) is stored. The bond copy table 204 is a storage area in which copy data of bond master data stored in the bond master table 104 (hereinafter referred to as “bond bond data”) is stored. The investment trust copy table 206 is a storage area in which copy data of investment trust master data stored in the investment trust master table 106 (hereinafter referred to as “investment copy data”) is stored. Accordingly, each copy table is also prepared for each business attribute according to business circumstances in the securities company.

  The data structure of stock copy data, bond copy data, and investment trust copy data includes stock master data shown in FIG. 4 (a), bond master data shown in FIG. 4 (b), and investment trust shown in FIG. 4 (c). It has the same data structure as the master data. The stock copy table 202, the bond copy table 204, and the investment trust copy table 206 use a main memory that can be accessed faster than an external storage device as a recording medium.

  The display table 208 includes display target data on a specific information providing screen (hereinafter referred to as “specific screen”) among the copy data stored in the stock copy table 202, the bond copy table 204, and the investment trust copy table 206. This is a stored storage area. There may be a plurality of specific screens. In this case, the display table 208 is prepared for each specific screen. The display table 208 also uses the main memory as a recording medium.

  FIG. 6 shows the data structure of display target data. This figure shows display target data on the portfolio screen described in FIG. As is clear from comparison with FIG. 2, the data to be displayed on the portfolio screen is aggregated in the display target data in FIG. That is, information on securities held by customers is distributed in the master table and copy table for business or normalization purposes, while in the display table 208, it is stored together with the portfolio screen. ing. Returning to FIG.

  Further, the specific screen in which the display target data is stored in the display table 208 in advance may be determined according to the reference frequency, that is, the number of reference requests per unit time, among the plurality of information providing screens provided to the customer. Good. For example, an information provision screen whose reference frequency is a predetermined number of times or an information provision screen whose reference frequency is within a predetermined rank may be determined as the specific screen. As the threshold used for this determination, an appropriate threshold may be set based on the experience and experiment of a securities company.

  Furthermore, the specific screen is a processing load when the display target data is extracted from the copy data stored in each copy table out of a plurality of information provision screens provided to the customer and set in the data of each information provision screen. It may be determined accordingly. For example, an information provision screen in which the CPU usage rate continues for a predetermined time or more and becomes a predetermined value or an information provision screen in which the memory usage amount becomes a predetermined value or more may be determined as the specific screen. As a result, in the case of an information provision screen that needs to retrieve a large amount of display target data or that needs to calculate display target data based on a large amount of copy data, the processing load increases and is determined as a specific screen. It becomes easy to be done.

  The update processing unit 210 receives the updated master data from the database apparatus 100 and reflects the update on the stock copy table 202, the bond copy table 204, and the investment trust copy table 206. Thereby, the master data stored in each master table and the copy data stored in each copy table are synchronized. Specifically, the copy table corresponding to the master table storing the updated master data is specified, and the copy data stored in the copy table is updated from the update data of the master data.

  The first data setting unit 212 extracts the display target data on the specific screen from each copy table and sets it in the display table 208. As a result, the copy data stored in each copy table is synchronized with the display target data stored in the display table. The first data setting unit 212 executes an update handling process for setting the display table 208 when the copy data stored in each copy table is updated. In addition, the first data setting unit 212 executes a reference handling process for setting the display table 208 when the setting request data from the first data providing unit 214 is received.

  The update handling process in the first data setting unit 212 will be specifically described. The first data setting unit 212 includes information indicating the correspondence between each data item included in the display target data used on the specific screen and each data item included in the copy data (hereinafter referred to as “first mapping information”). Hold). In other words, the first mapping information is information specifying the position of copy data to be stored in each column of the display table 208, that is, the copy table and column. The first data setting unit 212 receives a notification of a customer ID from the update processing unit 210 that has updated each copy table, and acquires copy data associated with this customer ID from each copy table. The first data setting unit 212 refers to the first mapping information, extracts display target data from the copy data, adds it to the display table 208, or updates existing display target data.

  For example, in the first mapping information, each of the “customer ID” to “quantity” columns of the stock copy table 202 shown in FIG. 4A includes “customer ID” of the display table 208 shown in FIG. Corresponding to each of the “quantity” column from the “column”. The first data setting unit 212 sets the data of each column of the stock copy table 202 to the data of each column of the display table 208 based on the first mapping information. Note that the first data setting unit 212 sets the type field of the display table 208 according to the acquired copy table. In FIG. 6, “stock”, “bond”, and “investment trust” are set in the data acquired from the stock copy table 202, the bond copy table 204, and the investment trust copy table 206, respectively.

  In addition, when the display target data is added to the display table 208 or the existing display target data is updated in the update handling process, the first data setting unit 212 further passes through the first data providing unit 214. The customer ID of the updated display target data is transmitted to the customer support apparatus 300. At this time, processing in the customer support apparatus 300 that has received the customer ID will be described later.

  Next, the reference handling process in the first data setting unit 212 will be specifically described. The first data setting unit 212 receives the setting request data for the display target data from the first data providing unit 214, and copies the copy data associated with the customer ID specified by the acquisition request data from each copy table. get. The first data setting unit 212 refers to the first mapping information, extracts the display target data of the specific screen from the copy data, adds it to the display table 208, or updates the existing display target data. Finally, the first data setting unit 212 transmits setting completion notification data to the first data providing unit 214.

  The first data setting unit 212 further deletes the display target data satisfying a predetermined condition for limiting the display target data stored in the display table 208 from the display table 208. For example, the first data setting unit 212 may delete the display target data having the longest elapsed time since being stored in the display table 208 based on a first-in first-out (FIFO) algorithm. Further, for example, based on an LRU (Least Recently Used) algorithm, display target data having the longest time since the last reference may be deleted.

  The first data providing unit 214 receives the acquisition request data for the display target data on the specific screen from the customer support apparatus 300, and searches the display table 208 based on the customer ID specified in the acquisition request data. When the display target data associated with the customer ID is stored in the display table 208, the first data providing unit 214 acquires the display target data and transmits it to the customer support apparatus 300.

  On the other hand, if the display target data associated with the customer ID is not stored in the display table 208, the first data providing unit 214 sets the display target data to the first data setting unit 212. Notify the request data. When receiving the setting completion notification data from the first data setting unit 212, the first data providing unit 214 acquires display target data from the display table 208 and transmits it to the customer support apparatus 300.

  The second data setting unit 216 includes each data item included in the display target data used in the information providing screen (hereinafter, simply referred to as “another screen”) different from the specific screen and each included in the copy data. Information indicating the correspondence with the data item (hereinafter referred to as “second mapping information”) is held. The second data setting unit 216 receives the acquisition request data from the second data providing unit 218, and acquires the copy data associated with the customer ID specified by the acquisition request data from each copy table. To do. The second data setting unit 216 refers to the second mapping information, extracts display target data for another screen from the copy data, and notifies the second data providing unit 218 of the data.

  The second data providing unit 218 receives display target data acquisition request data on another screen from the customer support apparatus 300. The second data providing unit 218 notifies the second data setting unit 216 of the display target data acquisition request data, acquires the display target data from the second data setting unit 216, and sends it to the customer support apparatus 300. Send.

  FIG. 7 is a block diagram showing a functional configuration of the customer support apparatus 300 of FIG. The customer support apparatus 300 includes a screen ID table 302, a market price table 304, a local table 306, a reference request reception unit 308, a screen determination unit 310, a first screen setting unit 312, and a first data acquisition unit. 314, a second screen setting unit 316, a second data acquisition unit 318, and a screen transmission unit 320.

  The screen ID table 302 is a storage area in which IDs of specific screens provided to customers are stored. As described above, this specific screen is determined from a plurality of information providing screens according to the reference frequency, the load required for the display target data extraction process, and the like. The ID of the specific screen may be data that uniquely specifies the specific screen in the securities information providing system 10, and may be, for example, a URL (Uniform Resource Locator) of the specific screen.

  The market price table 304 is a storage area in which the market price data of each security brand provided from an external device (not shown) is stored. The local table 306 is a storage area in which display target data on a specific screen is stored. The data structure of the display target data (hereinafter referred to as “local data”) stored in the local table 306 is the same as the data structure of the display target data stored in the display table 208. The local table 306 also uses the main memory as a recording medium.

  The reference request receiving unit 308 receives the reference request data for the information providing screen from the customer terminal 600. The screen determination unit 310 refers to the screen ID table 302 and determines whether the ID of the information provision screen specified in the reference request data matches the ID of the specific screen stored in the screen ID table 302. That is, the screen determination unit 310 determines whether the information provision screen requested by the customer is a specific screen or another screen.

  The first screen setting unit 312 sets the data for the specific screen according to the customer who requested the specific screen. Specifically, the first screen setting unit 312 notifies the first data acquisition unit 314 of the acquisition request data for the display target data used on the specific screen, which is data including the ID of the requesting customer. To obtain the display target data of the requesting customer. The first screen setting unit 312 sets display target data of the requesting customer in HTML data common to the customer on the specific screen. When setting the evaluation value on the portfolio screen, the first screen setting unit 312 acquires the market price of each securities issue from the market price table 304, and integrates the quantity and the market price of each securities issue held by the customer. To calculate the evaluation amount.

  The first data acquisition unit 314 receives the acquisition request data for the display target data used on the specific screen from the first screen setting unit 312 and first searches the local table 306 based on the ID of the requesting customer. To do. When the local data associated with the requesting customer ID is stored in the local table 306, the first data acquisition unit 314 acquires the local data and uses the first screen setting unit as display target data. 312 is notified.

  On the other hand, when the local data associated with the requesting customer ID is not stored in the local table 306, the first data acquisition unit 314 is data including the requesting customer ID, Data acquisition request data is transmitted to the cache device 200. The first data acquisition unit 314 receives the display target data of the requesting customer from the cache device 200 and notifies the first screen setting unit 312 of the data. The first data acquisition unit 314 further stores the display target data received from the cache device 200 in the local table 306.

  Further, the first data acquisition unit 314 receives the customer ID for the display target data updated on the cache device 200 side from the cache device 200. The first data acquisition unit 314 deletes the local data associated with the customer ID from the local table 306. Thereafter, when updated display target data is requested on the cache device 200 side, the first data acquisition unit 314 acquires the updated display target data from the cache device 200 and stores it in the local table 306. Thus, local data in the customer support device 300 is deleted in accordance with the update of the display target data in the cache device 200, and data inconsistency between the display target data and the local data is prevented.

  The second screen setting unit 316 sets data for another screen according to a customer who has requested another screen. Specifically, the second screen setting unit 316 notifies the second data acquisition unit 318 of acquisition request data for display target data that is data including the ID of the requesting customer and is used on another screen. Then, display target data of the requesting customer is acquired. The second screen setting unit 316 sets display target data of the requesting customer in HTML data common to customers on another screen. The method for setting the evaluation amount on the portfolio screen is the same as that of the first screen setting unit 312 described above.

  The second data acquisition unit 318 receives display target data acquisition request data to be used on another screen from the second screen setting unit 316 and includes the requesting customer ID, and the display target data The acquisition request data is transmitted to the cache device 200. The second data acquisition unit 318 receives the display target data of the requesting customer from the cache device 200 and notifies the second screen setting unit 316 of it.

  The screen transmission unit 320 transmits the data of the specific screen set by the first screen setting unit 312 or the data of another screen set by the second screen setting unit 316 to the customer terminal 600. As a result, the screen requested by the customer for reference is displayed on the customer terminal 600.

The operation of the above configuration will be described below.
FIG. 8 is a flowchart showing a flow of information providing processing in the securities information providing system 10.
The reference request receiving unit 308 in the customer support apparatus 300 receives the reference request data for the information providing screen from the customer terminal 600 (S10). When the screen determination unit 310 determines that the screen requested by the customer is a specific screen (Y in S12), the first screen setting unit 312 sends the display target data acquisition request data to the first data acquisition unit. 314 is notified. When the local data of the requesting customer is stored in the local table 306 (Y in S14), the first data acquisition unit 314 acquires the local data from the local table 306 (S16), and the local data is 1 screen setting unit 312 is notified. The first screen setting unit 312 sets local data in the data on the specific screen (S18), and the screen transmission unit 320 transmits the data on the specific screen to the customer terminal 600 (S20).

  When the local data of the requesting customer is not stored in the local table 306 (N in S14), the first data acquisition unit 314 transmits display target data acquisition request data to the cache device 200. When the display target data of the request source customer is stored in the display table 208 in the cache device 200 (Y in S22), the first data providing unit 214 acquires the display target data from the display table 208 and acquires the customer. It transmits to the support apparatus 300. In this way, the first data acquisition unit 314 acquires display target data from the cache device 200 (S24), notifies the display target data to the first screen setting unit 312 and stores it in the local table 306. (S26). Thereafter, the process of S18 is performed.

  When the display target data of the requesting customer is not stored in the display table 208 in the cache device 200 (N in S22), the first data providing unit 214 displays the display target data to the first data setting unit 212. Notify the setting request data. The first data setting unit 212 acquires copy data from each copy table based on the requesting customer ID (S28), extracts display target data from the copy data, and sets it in the display table 208 ( S30). The first data providing unit 214 acquires display target data from the display table 208 and transmits the display target data to the customer support apparatus 300, and the processing thereafter is S24.

  When the screen determination unit 310 in the customer support apparatus 300 determines that the screen requested by the customer is a different screen (N in S12), the second screen setting unit 316 obtains display target data acquisition request data. The second data acquisition unit 318 is notified. The second data acquisition unit 318 transmits display target data acquisition request data to the cache device 200. The second data providing unit 218 in the cache device 200 notifies the second data setting unit 216 of display target data acquisition request data.

  Subsequently, the second data setting unit 216 obtains copy data from each copy table based on the ID of the requesting customer (S32), extracts the display target data from the copy data, and provides the second data Notification to the unit 218. The second data providing unit 218 transmits the display target data acquired from the second data setting unit 216 to the customer support apparatus 300. In this way, the second data acquisition unit 318 acquires display target data from the cache device 200 (S34), and notifies the second data setting unit 216 of the display target data. The second data setting unit 216 sets display target data in the data of another screen (S36), and thereafter, the process of S20 is performed.

FIG. 9 is a flowchart showing the flow of data update processing in the securities information providing system 10.
The update request receiving unit 108 in the database device 100 updates the master data stored in each master table in accordance with the update request data from the external device (S40). The update notification unit 110 detects the update of the master data and transmits the update data to the cache device 200. The update processing unit 210 in the cache device 200 updates the copy data stored in each copy table with the update data of the master data (S42), and notifies the first data setting unit 212 of it.

  Subsequently, the first data setting unit 212 extracts display target data from the updated copy data in each copy table, and updates the display target data stored in the display table 208 (S44). The first data setting unit 212 notifies the customer support apparatus 300 of the update of the display target data. In response to this notification, the first data acquisition unit 314 in the customer support device 300 deletes the local data corresponding to the display target data updated on the cache device 200 side from the local table 306 (S46).

  In the securities information providing system 10 described above, the database device 100 that manages data updated from an external device and the cache device 200 that manages data referenced from the external device are separated. As a result, the processing load accompanying the update request traffic and data update and the processing load accompanying the reference request traffic and data reference can be distributed, and the information providing service can be speeded up.

  Further, in the cache device 200, display target data used in the information providing screen is stored in the display table 208 in advance. This eliminates the need to acquire copy data when receiving a reference request from a customer, process it, and extract the display target data, thereby reducing the processing load on the cache device 200 and providing the display target data quickly. become. In other words, it is possible to speed up the information providing service by pre-aggregating data distributed according to the convenience of business and normalization according to the convenience of the information providing screen.

  Further, in the securities information providing system 10, the customer support device 300 that accepts access from the customer terminal 600 is separated from the cash device 200. Since local data is arranged in the customer support apparatus 300, even if the number of reference requests to the customer support apparatus 300 increases, the influence on the number of reference requests to the cache apparatus 200 can be reduced. As a result, an increase in reference requests can be handled by increasing the number of customer support devices 300. In other words, the functional arrangement and data arrangement of the securities information providing system 10 enables efficient load distribution for the reference request, and speeds up the information providing service.

  Furthermore, in the securities information providing system 10, copy data, display target data, and local data to be referenced are stored in the main memory. Thereby, the CPU can access the data to be referred to at high speed, and the information providing service can be speeded up.

  Furthermore, in the securities information providing system 10, display target data for a specific screen among a plurality of information providing screens provided to the customer is stored in the display table 208. By limiting to the specific screen, the amount of data stored in the display table 208 and the maintenance cost of the system administrator are also suppressed. Further, by determining the specific screen according to the reference frequency and the processing load for extracting the display target data, an information providing screen that has a relatively large influence on the response performance of the information providing service can be determined as the specific screen.

  Furthermore, in the securities information providing system 10, the master data held by the database device 100 is synchronized with the copy data and display target data held by the cache device 200. In addition, the local data held by the customer support device 300 is deleted when the display target data is updated. As a result, inconsistencies between the data are prevented, and a decrease in convenience for the customer is prevented. Further, since each data is associated with a customer ID as a key, not only a common screen for customers but also a screen with different display contents for each customer, for example, a portfolio screen, can be provided to each customer at high speed.

  Furthermore, the display target data stored in the display table 208 of the cache device 200 is deleted based on a predetermined condition for limiting the display target data. As a result, the storage amount of the display table 208 is prevented from becoming infinitely large, and display target data that is highly likely to be referenced again can be stored continuously. Note that if the display target data is deleted at the time of reference, the display target data is generated again from the copy data, so that it is possible to continue providing information to the customer through the processing in the cache device 200.

  The present inventor has recognized that there is a difference between the number of times the data is referred to and updated for the data referred and updated by the same customer. Specifically, according to the rule of thumb of the present inventor, the number of updates is about 1 with respect to the reference count of 20. As described above, according to the securities information providing system 10, the reference process and the update process are separated and the reference process is further speeded up, so that the entire information providing service can be speeded up.

  The present invention has been described based on the embodiments. This embodiment is an exemplification, and it will be understood by those skilled in the art that various modifications can be made to combinations of the respective constituent elements and processing processes, and such modifications are also within the scope of the present invention. is there.

  It should also be understood by those skilled in the art that the functions to be fulfilled by the constituent elements described in the claims are realized by a single function block or a combination of the functional blocks shown in the embodiment and the modification.

  A modification will be described. In the embodiment, each copy data has a deposit ID as a record key for ensuring the uniqueness of the record in the copy table, and on the other hand, a customer ID serving as a search key from the first data setting unit 212 or the like Had. However, there may be a case where only one copy data key, that is, only a custody ID can be set due to limitations of database software or the like. In this case, the first data setting unit 212 or the like cannot acquire a plurality of copy data using the customer ID as a key. In order to cope with this restriction, the cache device 200 of the present modification further includes a key table and a key table setting unit (not shown).

  The key table is a storage area in which the storage ID and the customer ID of each of a plurality of pieces of copy data in the copy table are stored in a one-to-one correspondence. The key table setting unit acquires the copy data updated by the update processing unit 210 by the database trigger described above, and stores the custody ID and customer ID included in the copy data in the key table in association with each other. When acquiring the copy data, the first data setting unit 212 or the second data setting unit 216 first acquires a plurality of deposit IDs from the key table using the customer ID as a key. Then, a plurality of copy data is acquired from each copy table using each deposit ID as a key. The key table setting unit may further store a table ID for specifying the table in the key table.

  According to this modification, even when there is a restriction that only one key can be set in the copy table, it is possible to acquire a plurality of copy data associated with each customer and extract display target data. That is, the application range of the technology of the present invention can be expanded.

  Another modification will be described. In the embodiment, when the display target data is updated, the first data setting unit 212 transmits the customer ID of the updated display target data to the customer support apparatus 300. As a modification, the first data setting unit 212 may transmit the updated display target data itself to the customer support apparatus 300. At this time, the first data acquisition unit 314 that has received the updated display target data updates the local data with the received display target data.

  According to this modification, the display target data in the cache device 200 and the local data in the customer support device 300 can be synchronized. When the display target data is requested from the first screen setting unit 312, the first data acquisition unit 314 can acquire and provide local data in the same manner as before the display target data is updated. The provided service can be further accelerated.

  Still another modification will be described. The securities information providing system 10 according to the embodiment includes one database device 100, one cache device 200, and one customer support device 300, but the technical idea of the present invention does not depend on the number of devices. The information providing service can be speeded up by applying the technical idea of the present invention to various types of information providing systems including only one device or a plurality of devices.

  As an exemplary configuration, the information providing system may include one database device, two or more cache devices, and two or more user support devices. That is, it may be a securities information providing system in which a plurality of cash devices 200 and customer support devices 300 in FIG. This database device manages the master data of all customers in a master table. Each user support device is associated with a part of all customers, and each user support device provides an information providing service to the associated customer. Moreover, it has a database (not shown), for example, a customer information table, for recognizing some of these customers.

  Each cache device is associated with a part of all customers, and manages copy data of all customers in a copy table. In addition, display target data regarding specific screens of some customers is managed by a display table. That is, the contents of the copy table are common to each cache device, but since the customers with which each cache device is associated are different, the contents of the display table are different for each cache device. Each cache device has a database (not shown), for example, a customer information table, for recognizing some of these customers. The database that each user support device and each cache device is supposed to hold may be held centrally by a common database server (not shown), for example, a customer information management device.

  In this configuration example, when the master data is updated, the database device notifies the updated master data to each cache device. Each cache device holds customer ID information indicating a customer ID associated with the own device. Each cache device updates the copy data according to the notified master data, and refers to the customer information table to determine whether or not the customer ID of the updated copy data is included in the customer ID information. When the copy data of the customer associated with the own device is updated, the display target data of the customer is updated together. Each user support device obtains display target data of a customer associated with the own device, that is, a customer set in the customer information table, provides an information providing screen to the customer, and displays display target data related to the specific screen. Store in local table.

  This configuration example can be said to be a configuration in which the securities information providing system 10 according to the embodiment is scaled out in accordance with an increase in the number of reference requests. That is, according to the increase in the number of reference requests, first, the number of user support devices is increased. If the cache device becomes a performance bottleneck, the number of cache devices can be increased as appropriate to cope with the increase in the number of reference requests. Further, the configuration of each device may be determined according to business reasons. For example, a plurality of user support devices and / or a plurality of cash devices may be associated with customers of each branch of a securities company.

  According to this configuration example, in addition to the effects described above, data recovery can be efficiently performed when a failure occurs in the cache device. That is, since the copy table is common to each cache device, and the copy data is synchronized with the master data, the cache device that should reconstruct the copy table must obtain the copy data from another cache device. That's fine. Since the cache device holds the copy data on the main memory, the copy data can be acquired at high speed and the copy table can be constructed in a short time. Since the display table is constructed at the time of the customer's first reference request, a faster response can be made to the customer's second and subsequent reference requests.

It is a block diagram of the securities information provision system in an embodiment of the invention. It is a screen figure of a portfolio screen. It is a block diagram which shows the function structure of the database apparatus of FIG. It is a figure which shows the data structure of stock master data. It is a figure which shows the data structure of bond master data. It is a figure which shows the data structure of investment trust master data. It is a block diagram which shows the function structure of the cache apparatus of FIG. It is a figure which shows the data structure of display object data. It is a block diagram which shows the function structure of the customer assistance apparatus of FIG. It is a flowchart which shows the flow of the information provision process in a securities information provision system. It is a flowchart which shows the flow of the data update process in a securities information provision system.

Explanation of symbols

  10 Securities Information Providing System, 100 Database Device, 102 Stock Master Table, 104 Bond Master Table, 106 Investment Trust Master Table, 108 Update Request Receiving Unit, 110 Update Notification Unit, 200 Cash Device, 202 Stock Copy Table, 204 Bond Copy Table, 206 investment trust copy table, 208 display table, 210 update processing unit, 212 first data setting unit, 214 first data providing unit, 216 second data setting unit, 218 second data providing unit, 300 customer support Device, 302 screen ID table, 304 market price table, 306 local table, 308 reference request reception unit, 310 screen determination unit, 312 first screen setting unit, 314 first data acquisition unit, 316 first Screen setting portion, 318 a second data acquisition unit, 320 screen transmission unit, 400 house network, 500 external network, 600 customer terminal, 602 portfolio screen.

Claims (13)

Multiple master tables prepared for each business attribute storing master data,
Among the master data stored in the plurality of master tables, a display table that extracts and stores display target data used on a specific screen provided to the user, and
A reference processing unit for setting display target data stored in the display table to data of the specific screen and providing it to the user when requested by the user to refer to the specific screen;
An information providing apparatus comprising: The reference processing unit includes:
A screen ID table storing the ID of the specific screen;
A screen determination unit that determines whether an ID of a screen requested to be referred to by a user matches an ID stored in the screen ID table;
A screen for setting the display target data stored in the display table to the requested screen data when the screen determining unit determines that the requested screen ID matches the ID of the specific screen. A setting section;
The information providing apparatus according to claim 1, further comprising:   The screen setting unit, when the screen determination unit determines that the requested screen ID does not match the ID of the specific screen, the requested data from the master data stored in the plurality of master tables. The information providing apparatus according to claim 2, wherein display target data used on a screen is extracted and set to the requested screen data.   4. The information according to claim 2, wherein the screen ID table stores IDs of a part of screens determined according to a reference frequency among a plurality of screens provided to a user. 5. Providing device.   In the screen ID table, according to the processing load when the display target data is extracted from the master data stored in the plurality of master tables out of the plurality of screens provided to the user and set in the data of each screen 4. The information providing apparatus according to claim 2, wherein IDs of the determined partial screens are stored.   2. The data setting unit according to claim 1, further comprising: a data setting unit that extracts display target data from the updated master data and stores it in the display table when an update of the master data stored in the master table is detected. 5. The information providing apparatus according to any one of 5. The reference processing unit is configured to set the display target data to the data setting unit when the user is requested to refer to the specific screen and the display target data is not stored in the display table. Request,
The data setting unit, when requested to set the display target data, extracts display target data from master data stored in the plurality of master tables and stores the display target data in the display table. 6. The information providing device according to 6. In the plurality of master tables, master data in units of users is stored in association with individual user IDs,
The display table stores display target data used on a specific screen provided to the individual user among the master data stored in the plurality of master tables.
It further comprises a data setting unit that extracts display target data from the master data associated with the IDs of the individual users among the master data stored in the plurality of master tables and stores the data in the display table. An information providing apparatus according to any one of claims 1 to 5. An information providing method using a computer having a processor and a storage device,
Out of the master data stored in a plurality of master tables prepared for each business attribute, the step of extracting the display target data used in a specific screen provided to the user and storing it in the display table;
When the user is requested to refer to the specific screen, the display target data stored in the display table is set to the data of the specific screen and provided to the user;
The information providing method is characterized in that the processor is executed. A database device for managing data updated from an external device;
A user support device for managing data referred to by a user;
With
The database device includes:
Multiple master tables prepared for each business attribute storing master data,
An update notification unit for notifying the user support device of the updated master data when the master data stored in the plurality of master tables is updated;
Have
The user support device includes:
A plurality of copy tables prepared for each business attribute storing copy data that is a copy of the master data; and
An update processing unit for updating the copy data with the master data notified from the database device;
Among the copy data stored in the plurality of copy tables, a display table in which display target data used in a specific screen provided to the user is extracted and stored;
A reference processing unit for setting display target data stored in the display table to data of the specific screen and providing it to the user when requested by the user to refer to the specific screen;
An information providing system characterized by comprising: A database device for managing data updated from an external device;
A plurality of cache devices for managing data referred to by some of the users, each of which is associated with some of the plurality of users;
A plurality of user support devices that accept reference requests from some of the users, each of which is associated with some of the plurality of users;
With
The database device includes:
A plurality of master tables prepared for each business attribute storing master data of the plurality of users,
An update notification unit for notifying each of the plurality of cache devices of the updated master data when the master data stored in the plurality of master tables is updated;
Have
Each of the plurality of cache devices is
A plurality of copy tables prepared for each business attribute storing copy data that is a copy of the master data; and
An update processing unit for updating the copy data with the master data notified from the database device;
Among the copy data stored in the plurality of copy tables, a display table for extracting and storing display target data used on a specific screen provided to a user associated with the device,
Have
Each of the plurality of user support devices includes:
When the user associated with the own device requests a reference to the specific screen, the display target data of the user is obtained from the display table of the cache device associated with the user, and the specific screen A screen setting part to be set in the data;
A screen transmission unit for providing data of the specific screen to the user;
An information providing system characterized by comprising: Each of the plurality of user support devices further includes a local table storing display target data acquired in the screen setting unit,
The said screen setting part acquires the said display target data of the said user from the said local table, when the display target data of the user who requested | required reference of the said specific screen exists in the said local table. Information providing system described in 1. Each of the plurality of cache devices further includes an update notification unit for notifying the user support device of identification information of the updated display target data when the display target data stored in the display table is updated. ,
The information provision according to claim 12, wherein each of the plurality of user support devices further includes a local table setting unit that deletes display target data specified by the notified identification information from the local table. system.

Images