JP2016053814A - Data search control program, computer, and data search control method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To suppress a reduction in search accuracy in response to a search request.SOLUTION: As illustrated in Fig. 1(a), a computer 101 acquires a search request 113 issued to a second storage area 112. The computer 101 determines data to be stored in the second storage area 112 from data stored in a first storage area 111 on the basis of the issued search request 113. As illustrated in Fig. 1(b), the computer 101 reads out the determined data from the first storage area 111 at a predetermined cycle and stores the read-out data in the second storage area 112.SELECTED DRAWING: Figure 1

Description

  The present invention relates to a data search control program, a computer, and a data search control method.

  Conventionally, there is a technique for searching data stored in a storage area based on a search request. As related prior art, for example, by referring to items aggregated in an aggregation DB created by extracting specified items from a database (DataBase: DB), the aggregation DB to be searched is specified based on the search condition. Some search for a specified aggregate DB based on a command created based on a search condition.

JP 11-66093 A

  However, according to the prior art, if a search request is issued to the second storage area that stores a part of the data in the first storage area, it is difficult to ensure the search accuracy of the search request. . For example, if the data stored in the second storage area is fixed in advance, the search accuracy may decrease when the tendency of the searched data changes. In addition, it is troublesome if the user specifies data to be stored in the second storage area.

  In one aspect, an object of the present invention is to provide a data search control program, a computer, and a data search control method that can suppress a decrease in search accuracy of a search request.

  According to one aspect of the present invention, a search request issued to a second storage area that stores data read from the first storage area is acquired, and a first request is acquired based on the acquired search request. The data to be stored in the second storage area is determined from the data stored in the storage area, the determined data is read from the first storage area at a predetermined cycle, and the read data is stored in the second storage area. A data search control program, a computer, and a data search control method that are stored in a storage area are proposed.

  According to one aspect of the present invention, it is possible to suppress a decrease in search accuracy of a search request.

FIG. 1 is an explanatory diagram illustrating an operation example of the computer 101. FIG. 2 is an explanatory diagram illustrating a configuration example of the search system 200. FIG. 3 is a block diagram illustrating a hardware configuration example of the DB server 201. FIG. 4 is a block diagram illustrating a hardware configuration example of the user terminal 203. FIG. 5 is a block diagram illustrating a functional configuration example of the DB server 201. FIG. 6 is an explanatory diagram showing an example of the contents stored in the raw data 212. FIG. 7 is an explanatory diagram illustrating an example of a search query. FIG. 8 is an explanatory diagram showing an example of the contents stored in the extraction rule file 511. FIG. 9 is an explanatory diagram (part 1) of a generation example of the extraction rule file 511. FIG. 10 is an explanatory diagram (part 2) of a generation example of the extraction rule file 511. FIG. 11 is an explanatory diagram (part 3) of a generation example of the extraction rule file 511. FIG. 12 is an explanatory diagram showing an example of the contents stored in the integrated summary DB 204 after the extraction rule file 511 is applied. FIG. 13 is an explanatory diagram illustrating an update example of the extraction rule file 511. FIG. 14 is a flowchart illustrating an example of a data capturing process procedure. FIG. 15 is a flowchart illustrating an example of a search control processing procedure.

  Exemplary embodiments of a disclosed data search control program, a computer, and a data search control method will be described below in detail with reference to the drawings.

  FIG. 1 is an explanatory diagram illustrating an operation example of the computer 101. A computer 101 according to the present embodiment is a computer that controls search for data. The computer 101 is a server, for example. The data may be anything, for example, raw data such as computer processing results or log data. Here, the raw data is data that has not been processed at all since it was recorded.

  Here, since raw data is not processed, it becomes a huge amount of data. Therefore, the computer 101 reads out a part of the raw data from the first storage area 111 that stores the raw data at a predetermined cycle and writes it in the second storage area 112. Then, the computer 101 issues a search request to the second storage area 112, and transmits a search result for the search request to the issuer of the search request. The predetermined cycle may be any interval, for example, one day, one week, or one month.

  Here, data stored in the first storage area 111 but not stored in the second storage area 112 may be searched, and it is difficult to ensure the search accuracy of the search request. Specifically, for example, if the data stored in the second storage area 112 is fixed in advance, the search accuracy may decrease when the tendency of the searched data changes. In addition, it is troublesome if the user specifies data to be stored in the second storage area 112.

  Therefore, the computer 101 determines data to be stored in the second storage area 112 based on a search request for the second storage area 112, and stores data to be stored in the second storage area 112 from the first storage area 111. Periodically read out and stored in the second storage area 112. As a result, the computer 101 can suppress the storage amount of the second storage area 112 while storing the data that is in the tendency of the search request in the second storage area 112 and suppressing a decrease in search accuracy.

  A more specific operation will be described with reference to FIG. In FIG. 1, raw data is stored in the first storage area 111. The data format of the raw data may be any format, and is stored in CSV (Comma Separated Values) in the example of FIG. FIG. 1A shows a state in which the operation of a system that generates CSV format raw data has just started. Therefore, it is assumed that the amount of data stored in the first storage area 111 is small, and all the data stored in the first storage area 111 is written in the second storage area 112. Further, in the first storage area 111 and the second storage area 112 shown in FIG. 1A, the rows “A1, A2, A3, A4, A5” and “B1, B2, B3, B4” The line “B5” is stored.

  As shown in FIG. 1A, the computer 101 acquires a search request 113 issued to the second storage area 112. The search request 113 shown in FIG. 1A is a search request for “extracting the third value and the fifth value from the left of each row”. When the search request 113 is received, the computer 101 detects data matching the search request 113 from the second storage area 112 and sends the search result 114 “A3, A5 B3, B5” to the issuer of the search request 113. ". Here, an apparatus that detects data matching the search request and transmits the search result 114 to the issuer of the search request 113 may be a computer other than the computer 101.

  Next, the computer 101 determines data to be stored in the second storage area 112 from the data stored in the first storage area 111 based on the issued search request 113. In the example of FIG. 1, from the search request 113, the computer 101 sends data “third from the left of each row” and “fifth from the left of each row” among the data stored in the first storage area 111. Are determined as data to be stored in the second storage area 112. In the example of FIG. 1A, a frame 115 including data “third from the left of each row” is shown, and a frame 116 including data “fifth from the left of each row” is shown.

  Then, as shown in FIG. 1B, the computer 101 reads the determined data from the first storage area 111 at a predetermined cycle, and stores the read data in the second storage area 112. FIG. 1B shows a state in which a predetermined period has expired after FIG. In the example of FIG. 1B, the computer 101 stores “A3, B3, C3” included in the frame 115 and “A5, B5, C5” included in the frame 116 in the second storage area 112. Remember. Next, an example in which the computer 101 is applied to a DB server is shown in FIG.

  FIG. 2 is an explanatory diagram illustrating a configuration example of the search system 200. The search system 200 includes a DB server 201, an AP (AP application) server 202, a user terminal 203, and an integrated summary DB 204. Further, the DB server 201 is connected to the business system 211-1, the business system 211-2,. The business system 211-1 has raw data 212-1. The business system 211-2 has raw data 212-2. Here, the DB server 201 corresponds to the computer 101 shown in FIG. The raw data 212 corresponds to data stored in the first storage area 111 shown in FIG. The integrated summary DB 204 corresponds to the second storage area 112 shown in FIG.

  Here, the raw data 212 is a value associated with each attribute of the plurality of attributes. Specifically, the raw data 212 is data managed by a relational DB. Hereinafter, an attribute associated with a value is referred to as a “column”. A set of values associated with a column is referred to as a “record”. A data group formed by columns and records is referred to as a “table”. The raw data 212 is managed by one or more tables.

  Here, it is assumed that the business system 211 is a system related to a certain pharmaceutical company. A person belonging to a marketing department of a certain pharmaceutical company uses the search system 200 using the user terminal 203. Hereinafter, a person who uses the search system 200 is simply referred to as a “user”.

  The search system 200 provides a user who uses the user terminal 203 with a service for searching the raw data 212-1, 2,. Here, the raw data 212-1, 2,... Are unprocessed data and have a huge amount of data. Therefore, the search system 200 stores a part of the raw data 212-1, 2,... In the integrated summary DB 204, and the AP server 202 issues a search request to the DB server 201 having the integrated summary DB 204. Since the integrated summary DB 204 stores some data of the raw data 212, it is data managed by the relational DB like the raw data 212. The search request is described in accordance with SQL, which is a query language for the relational DB. Hereinafter, the search request is referred to as a “search query”.

  The DB server 201 receives a search query from the AP server 202, detects data matching the search query from the integrated summary DB 204, and transmits the detected data to the AP server 202 as a search result. Furthermore, the DB server 201 determines data to be stored in the integrated summary DB 204 from the data stored in the raw data 212 based on the search query. Then, the DB server 201 reads the determined data from the raw data 212 at a predetermined cycle, and stores the read data in the integrated summary DB 204.

  The AP server 202 issues a search query to the DB server 201 and receives a search result from the DB server 201. More specifically, upon receiving access from the user terminal 203, the AP server 202 generates screen data and transmits the screen data to the user terminal 203. Here, the screen data is data forming a screen capable of generating a search query.

  For example, the AP server 202 generates screen data having a selection menu for selecting any of a plurality of columns included in the raw data 212 and transmits the screen data to the user terminal 203. The user terminal 203 that has received the screen data forms a screen from the screen data, selects any of a plurality of columns from the selection menu by the user's operation, and transmits the selected column name to the AP server 202. The AP server 202 assembles a search query using the transmitted column name, and issues the assembled search query to the DB server 201.

  The integrated summary DB 204 is a storage area for storing a part of the raw data 212. The integrated summary DB 204 uses a storage area provided by the cloud service. Accordingly, the upper limit of the amount of data that can be stored in the integrated summary DB 204 is determined, or charging according to the data amount of the integrated summary DB 204 occurs, so the search system 200 suppresses the amount of data stored in the integrated summary DB 204. become.

  As described above, the business system 211 is a system related to a certain pharmaceutical company. For example, when the business system 211-1 is a POS (Point of Sale) system introduced in a pharmacy that handles drugs of a certain pharmaceutical company, the raw data 212-1 is a data generated by the POS system. The member number of the person who took the medicine, the product number of the medicine, the start date of the medicine, etc. Further, if the business system 211-2 is, for example, a business system of a pharmaceutical company, the raw data 212-2 is, for example, a drug product number, sales start, allergic components, and the like. A specific example of the raw data 212 will be described with reference to FIG.

  FIG. 3 is a block diagram illustrating a hardware configuration example of the DB server 201. In FIG. 3, the DB server 201 includes a CPU (Central Processing Unit) 301, a ROM (Read Only Memory) 302, and a RAM (Random Access Memory) 303. The DB server 201 includes a disk drive 304 and a disk 305, and a communication interface 306. The CPU 301 to the disk drive 304 and the communication interface 306 are connected by a bus 307, respectively.

  The CPU 301 is an arithmetic processing device that controls the entire DB server 201. The ROM 302 is a nonvolatile memory that stores programs such as a boot program. A RAM 303 is a volatile memory used as a work area for the CPU 301.

  The disk drive 304 is a control device that controls reading and writing of data with respect to the disk 305 according to the control of the CPU 301. As the disk drive 304, for example, a magnetic disk drive, a solid state drive, or the like can be adopted. The disk 305 is a nonvolatile memory that stores data written under the control of the disk drive 304. For example, when the disk drive 304 is a magnetic disk drive, a magnetic disk can be adopted as the disk 305. When the disk drive 304 is a solid state drive, a semiconductor memory formed by a semiconductor element, that is, a so-called semiconductor disk can be used as the disk 305.

  A communication interface 306 controls a network and an internal interface, and is a control device that controls input / output of data from other devices. Specifically, the communication interface 306 is connected to another device via a network through a communication line. As the communication interface 306, for example, a modem or a LAN adapter can be employed.

  When the administrator of the search system 200 directly operates the DB server 201, the DB server 201 may have hardware such as a display, a keyboard, and a mouse. Although not shown in FIG. 3, the AP server 202 also has the same hardware as the DB server 201.

  FIG. 4 is a block diagram illustrating a hardware configuration example of the user terminal 203. The user terminal 203 includes a CPU 401, a ROM 402, and a RAM 403. The user terminal 203 includes a disk drive 404, a disk 405, and a communication interface 406. The user terminal 203 includes a display 407, a keyboard 408, and a mouse 409. Further, the CPU 401 to the disk drive 404 and the communication interface 406 to the mouse 409 are connected by a bus 410, respectively.

  The CPU 401 is an arithmetic processing device that controls the entire user terminal 203. The ROM 402 is a non-volatile memory that stores a program such as a boot program. A RAM 403 is a volatile memory used as a work area for the CPU 401.

  The disk drive 404 is a control device that controls reading and writing of data with respect to the disk 405 according to the control of the CPU 401. As the disk drive 404, for example, a magnetic disk drive, an optical disk drive, a solid state drive, or the like can be adopted. The disk 405 is a non-volatile memory that stores data written under the control of the disk drive 404. For example, when the disk drive 404 is a magnetic disk drive, a magnetic disk can be used as the disk 405. Further, when the disk drive 404 is an optical disk drive, an optical disk can be adopted as the disk 405. When the disk drive 404 is a solid state drive, a semiconductor memory formed by a semiconductor element, that is, a so-called semiconductor disk can be used for the disk 405.

  The communication interface 406 is a control device that controls an internal interface with a network and controls input / output of data from an external device. Specifically, the communication interface 406 is connected to another device via a network through a communication line. As the communication interface 406, for example, a modem or a LAN adapter can be employed.

  The display 407 is a device that displays data such as a document, an image, and function information as well as a mouse cursor, an icon, or a tool box. As the display 407, for example, a cathode ray tube (CRT), a thin film transistor (TFT) liquid crystal display, a plasma display, or the like can be employed.

  The keyboard 408 is a device that has keys for inputting characters, numbers, various instructions, and the like and inputs data. The keyboard 408 may be a touch panel type input pad or a numeric keypad. The mouse 409 is a device for moving a mouse cursor, selecting a range, moving a window, changing a size, and the like. The mouse 409 may be a trackball, a joystick, or the like as long as it has the same function as a pointing device.

(Example of functional configuration of DB server 201)
FIG. 5 is a block diagram illustrating a functional configuration example of the DB server 201. The DB server 201 has a control unit 500. The control unit 500 includes an acquisition unit 501, a determination unit 502, a storage unit 503, and an update unit 504. The control unit 500 realizes the functions of the respective units when the CPU 301 executes a program stored in the storage device. Specifically, the storage device is, for example, the ROM 302, the RAM 303, the disk 305, etc. shown in FIG. In addition, the processing result of each unit is stored in a register of the CPU 301, a cache memory of the CPU 301, or the like.

  Further, the DB server 201 can access the raw data 212 and the integrated summary DB 204 via the communication interface 306.

  The acquisition unit 501 acquires a search query 512 issued to the integrated summary DB 204 that stores data read from the raw data 212.

  The determination unit 502 determines data to be stored in the integrated summary DB 204 from the data stored in the raw data 212 based on the search query 512 acquired by the acquisition unit 501. The determination unit 502 may determine the column name specified by the search query 512 as a column name to be stored in the integrated summary DB 204. Specifically, for example, the determination unit 502 determines the column name used in the select phrase of the search query 512 as a column name to be stored in the integrated summary DB 204. The determination unit 502 may determine the column name used in any phrase of the search query 512 as a column name to be stored in the integrated summary DB 204.

  Further, the determination unit 502 determines the column name specified by the search query 512 and the column name set as the primary key among the plurality of column names as column names to be stored in the integrated summary DB 204. A rule for specifying the determined column name may be generated. Hereinafter, the rule is referred to as an “extraction rule file”. In FIG. 5, it is shown as an extraction rule file 511. An example of generating the extraction rule file will be described with reference to FIGS.

  The column name set as the primary key is a column name associated with a value that identifies a set of values associated with each column name. Here, which of the plurality of columns of the table is set as the primary key can be specified by referring to the definition of the table.

  The extraction rule file 511 may store a column name determined as a target to be stored in the integrated summary DB 204, or a column name determined as a target to be stored in the integrated summary DB 204 among a plurality of column names of the raw data 212. Other column names may be stored. In the present embodiment, the extraction rule file 511 stores column names other than the column names determined to be stored in the integrated summary DB 204 among a plurality of column names included in the raw data 212. An example of the contents stored in the extraction rule file 511 will be described with reference to FIG.

  The storage unit 503 reads the data determined by the determination unit 502 from the raw data 212 at a predetermined cycle, and stores the read data in the integrated summary DB 204. The storage unit 503 may read a value corresponding to the column name determined by the determination unit 502 from the raw data 212 at a predetermined cycle, and store the read value in association with the column name in the integrated summary DB 204. .

  The storage unit 503 reads a value corresponding to the column name specified by the extraction rule file 511 from the raw data 212 at a predetermined cycle, and associates the read value with the column name specified by the extraction rule file 511. May be stored in the integrated summary DB 204.

  The acquisition unit 501 may acquire the search query 512 issued to the integrated summary DB 204 and the search result 513 corresponding to the search query 512. Assume that the search result 513 acquired by the acquisition unit 501 indicates that a value corresponding to the column name specified by the search query 512 has not been detected. In this case, the update unit 504 updates the extraction rule file 511 to the extraction rule file 511 that includes the column name specified by the search query 512 in the column name to be stored in the integrated summary DB 204. A specific update example of the extraction rule file 511 will be described with reference to FIG.

  Then, the storage unit 503 reads a value corresponding to the column name specified by the extraction rule file 511 updated by the update unit 504 from the raw data 212 at a predetermined cycle. Next, the storage unit 503 stores the read value in the integrated summary DB 204 in association with the column name specified by the extraction rule file 511.

  Further, when the search query 512 includes outputting data obtained by rounding data detected by the search query 512, the determination unit 502 determines the rounded data as data to be stored in the integrated summary DB 204. Further, when the search query 512 includes outputting a value obtained by rounding a value detected for the column name specified by the search query 512, the determination unit 502 stores the rounded value in the integrated summary DB 204. Determine as the target value. The storage unit 503 reads the determined value from the raw data 212 at a predetermined period, and stores the read value in association with the column name in the integrated summary DB 204. An example of data to be rounded will be described with reference to FIG.

  FIG. 6 is an explanatory diagram showing an example of the contents stored in the raw data 212. The raw data 212 shown in FIG. 6 has six tables: a member master 601, a medication history 602, a product master 603, a product category 604, a product description 605, and a manufacturer 606. The member master 601 shown in FIG. 6 has records 601-1 to 601-3. Similarly, the medication history 602, the product master 603, the product category 604, the product details 605, and the manufacturer 606 shown in FIG. 6 are the records 602-1 to 603, records 603-1 to 603, records 604-1 to 603, respectively. Records 605-1 to 606 and records 606-1 to 606.

  As an example, the member master 601 has a member number column as a primary key, a name column, a sex column, a date of birth column, and an allergy column. Further, the manufacturer 606 has a manufacturer number as a primary key, a company name, a telephone number, an address_prefecture, and an address_city.

  Further, the member master 601 to the manufacturer 606 are data stored in any of the raw data 212-1, 2,. For example, the member master 601 and the medication history 602 are data stored in the raw data 212-1, and the product master 603 to the manufacturer 606 are data stored in the raw data 212-2.

  FIG. 7 is an explanatory diagram illustrating an example of a search query. Search queries 701 to 704 shown in FIG. 7 are issued from the AP server 202.

  The search query 701 is a query that outputs the names column values and gender column values of all records stored in the member master 601. The search query 702 is a query that outputs the values of the company name column and the values of the address_prefecture column of all records stored by the manufacturer 606.

  In addition, the search query 703 externally joins the member master 601 with priority using the member numbers of the member master 601 and the medication history 602, and the name column values of all the joined records and the alias of the age are given. This is a query that outputs a column value and a product name column value. A column to which an alias of age is given is a column associated with a value obtained by dividing a value obtained by subtracting the date of birth column of the member master 601 from the current date by 10,000 and rounded down to the 10th place. It is. Here, “truncate (x, y)” in the search query 703 is a function that outputs a value obtained by truncating x at the position specified by y. Also, “curdate ()” in the search query 703 is a function that outputs the current date.

  The search query 704 is a query that outputs the name column value, gender column value, and allergy column value of all records stored in the member master 601.

  FIG. 8 is an explanatory diagram showing an example of the contents stored in the extraction rule file 511. The extraction rule file 511 includes, as items, an extraction unnecessary column and a rounding rule.

  The extraction unnecessary column is an item indicating a column that is not taken into the integrated summary DB 204 among the tables of the raw data 212. Specifically, for example, in the extraction unnecessary column, a column name that is not taken into the integrated summary DB 204 is stored for each table of the raw data 212. Also, as shown in FIG. 8, “*” stored in the extraction unnecessary column indicates that all the columns of the corresponding table are not captured. Further, if no column name is stored in the corresponding table of the extraction unnecessary column and it is blank, it indicates that all the columns of the corresponding table are fetched.

  The rounding rule is an item indicating a rule when a value obtained by rounding the value of each table of the raw data 212 is taken into the integrated summary DB 204. Details of the rounding rule will be described with reference to FIG.

  Next, an example of the extraction rule file 511 generated when the search queries 701 to 703 are issued will be described with reference to FIGS. An example of the contents stored in the integrated summary DB 204 that has read data according to the extraction rule file 511 after the search query 703 is issued will be described with reference to FIG. Further, referring to FIG. 13, after the data is read into the integrated summary DB 204 according to the extraction rule file 511 after the search query 703 is issued, the extraction rule file 511 that is updated when the search query 704 is issued is read. An example will be described.

  FIG. 9 is an explanatory diagram (part 1) of a generation example of the extraction rule file 511. The DB server 201 acquires the issued search query 701 and determines the column name used in the select phrase of the search query 701 as the target column name to be stored in the integrated summary DB 204. More specifically, the DB server 201 specifies a table used in the from phrase from the search query 701. As shown in FIG. 9, since the search query 701 uses the member master 601 in the from phrase, the DB server 201 identifies the member master 601. Then, the DB server 201 identifies, as the column names to be stored in the integrated summary DB 204, the name column and the sex column used in the select phrase and the member number column that is the primary key in the identified member master 601. decide.

  Next, the DB server 201 extracts a birth date column and an allergy column other than the column names determined as the column names to be stored in the integrated summary DB 204 among the column names of the member master 601, as an extraction rule file Register in column 511, which does not require extraction.

  FIG. 10 is an explanatory diagram (part 2) of a generation example of the extraction rule file 511. FIG. 10 shows a state in which the search query 702 is issued after the search query 701 is issued. The DB server 201 acquires the issued search query 702 and determines the column name used in the select phrase of the search query 702 as the target column name to be stored in the integrated summary DB 204. The specific processing content is the same as in FIG.

  As shown in FIG. 10, the DB server 201 integrates a company name column and an address_prefecture column used in the search query 702 and a manufacturer number column as a primary key among the column names of the manufacturer 606 into an integrated summary. The column name to be stored in the DB 204 is determined. Then, the DB server 201 registers, among the column names of the manufacturer 606, the phone number column and the address_city / town / village column other than the determined column name in the extraction unnecessary column of the extraction rule file 511.

  FIG. 11 is an explanatory diagram (part 3) of a generation example of the extraction rule file 511. FIG. 11 shows a state in which the search query 703 is issued after the search query 702 is issued. The DB server 201 acquires the issued search query 703, extracts the rounding rule used in the select phrase of the search query 703, and registers it in the extraction rule file 511. Here, the rounding rule is a rule including a condition for rounding a column name value. Specifically, the DB server 201 specifies a rounding rule when a function for rounding a value is used in the select clause. As a function for rounding the value, if the value is a numerical value, for example, there are a function for rounding down the value, a function for rounding up the value, and a function for rounding off the value. Alternatively, if the value of the column name is a character string, for example, a function that deletes the right end of the character string.

  As illustrated in FIG. 11, the DB server 201 specifies that there is a rounding rule in the select phrase of the search query 703, and registers the rounding rule in the extraction rule file 511. Specifically, the DB server 201 adds “truncate (((curdate () +0) − (member master.date of birth + 0)) / 10000, −1) as age” to the rounding rule.

  In addition to the rounding rule, the DB server 201 may register in the extraction rule file 511 when a function that combines a plurality of values into one value is used in the select clause. Examples of functions that combine a plurality of values into one value include, for example, a function that calculates an average value of a plurality of values, a function that calculates a total value of a plurality of values, a function that calculates a maximum value among a plurality of values, and a plurality of values Is a function for obtaining the minimum value of. For example, suppose that the medication history 602 forms a primary key with three columns: a member number column, a product number column, and a medication start column. Furthermore, it is assumed that the medication history 602 has a medication tablet number column.

  Then, the AP server 202 obtains, from the medication history 602, the value of the member number column and the value of the column to which the alias of the medication tablet number average value is given as the average value of the number of tablets taken for each member number. Assume that a search query to be output is issued. At this time, the DB server 201 registers, in the extraction rule file 511, a function for obtaining the average value of the number of tablets taken for each member number in the select clause of the issued search query.

  FIG. 12 is an explanatory diagram showing an example of the contents stored in the integrated summary DB 204 after the extraction rule file 511 is applied. The integrated summary DB 204 has two tables, a member master 1101 and a manufacturer 1102. The member master 1101 shown in FIG. 12 has records 1101-1 to 1101-1. Further, the manufacturer 1102 has records 1102-1 to 1102.

  Records 1101-1 to 1101-1 are records having values obtained by removing the values of the birth date column and the allergy column specified as the extraction unnecessary columns of the extraction rule file 511 shown in FIG. is there. Furthermore, the records 1101-1 to 1103 have the value of the age column generated according to the rounding rule of the extraction rule file 511 shown in FIG. Specifically, the DB server 201 sets “runcate (((curdate () +0) − (member master. Date of birth + 0)) / 10000,” described in the rounding rule for the records 601-1 to 601-3. -1) “as age” is executed. As a result of the execution, the DB server 201 stores the value of the age column for each record, which is the execution result, in the integrated summary DB 204 in association with each record.

  When a search query is received after adding a column according to a rounding rule, if the issued search query has a rounding rule, the DB server 201 sets a character string that becomes the rounding rule as a character after “as” in the rounding rule. Replace with a column, that is, a column name given as an alias. In the example of FIG. 12, the DB server 201, for example, says “select ... trancate (((curdate () +0) − (member master. Date of birth + 0)) / 10000, −1) as age,. Assume that a search query is received. At this time, the DB server 201 replaces the search query “select...,...”, And then detects data that matches the search condition of the search query from the integrated summary DB 204 using the replaced search query. Thereby, the DB server 201 can set the column value given as an alias as a search target.

  In addition, the records 1102-1 to 1102-1 to 3 exclude the values of the telephone number column and the address_city column specified as the extraction unnecessary columns of the extraction rule file 511 shown in FIG. A record having a value.

  FIG. 13 is an explanatory diagram illustrating an update example of the extraction rule file 511. FIG. 13 shows a state in which the search query 704 is issued after being read according to the extraction rule file 511 after the search query 703 is issued.

  The DB server 201 acquires the issued search query 704 and a search result corresponding to the search query 704. If the search result is 0, the DB server 201 sets the extraction rule file 511 so that the column name used in the select phrase of the search query 704 is the column name to be stored in the integrated summary DB 204. Update.

  Specifically, for example, in the extraction rule file 511 shown in FIG. 11, the birth date column and the allergy column of the member master 601 are registered in the extraction unnecessary column, so the search query 704 that uses the allergy column is used. The search result for is 0. Therefore, the DB server 201 deletes the allergy column used in the select phrase of the search query 704 registered in the extraction unnecessary column of the extraction rule file 511. As a result, when the next raw data 212 is fetched, the DB server 201 fetches the value of the allergy column of the member master 601.

  Next, a flowchart executed by the DB server 201 will be described with reference to FIGS.

  FIG. 14 is a flowchart illustrating an example of a data capturing process procedure. The data capture process is a process of reading data from the raw data 212 and writing it into the integrated summary DB 204. Further, the data fetching process is executed at a predetermined cycle.

  The DB server 201 deletes all of the integrated summary DB 204 (step S1401). Next, the DB server 201 determines whether there is an extraction rule file 511 (step S1402). When there is the extraction rule file 511 (step S1402: Yes), the DB server 201 acquires the extraction unnecessary column and the rounding rule of the extraction rule file 511 (step S1403). Next, the DB server 201 registers, in the integrated summary DB 204, values of columns other than the columns specified as the extraction unnecessary columns in the extraction rule file 511 from each table of the raw data 212 (step S1404). Then, the DB server 201 registers a value generated from the raw data 212 according to the rounding rule of the extraction rule file 511 in the integrated summary DB 204 (step S1405).

  On the other hand, if no search query has been issued and there is no extraction rule file 511 (step S1402: No), the DB server 201 registers all of the raw data 212 in the integrated summary DB 204 (step S1406).

  After the process of step S1405 or step S1406 is completed, the DB server 201 ends the data import process. By executing the data capture process, the DB server 201 can register only the columns that are easily referred to in the search query in the integrated summary DB 204.

  FIG. 15 is a flowchart illustrating an example of a search control processing procedure. The search control process is a process for a search query issued from the AP server 202. The search control process may be performed every time a search query is received, or may be performed every predetermined period.

  The DB server 201 acquires the issued search query (step S1501). Next, the DB server 201 determines whether or not a rounding rule is set in the extraction rule file 511 (step S1502). When the rounding rule is set in the extraction rule file 511 (step S1502: Yes), the DB server 201 replaces the search query using the rounding rule in the extraction rule file 511 (step S1503).

  After the process of step S1503 is completed or when the rounding rule is not set in the extraction rule file 511 (step S1502: No), the DB server 201 executes a search query (step S1504). Next, the DB server 201 acquires a search result corresponding to the search query (step S1505). After the processing of step S1505 is completed, the DB server 201 transmits the search result corresponding to the search query to the AP server 202.

  Then, the DB server 201 determines whether the search result is 0 (step S1506). When there are one or more search results (step S1506: No), the DB server 201 determines an extraction unnecessary column using the column name used in the select clause of the search query (step S1507). Next, the DB server 201 extracts a rounding rule from the search query (step S1508). Then, the DB server 201 stores the extraction unnecessary column and the rounding rule in the extraction rule file (step S1509).

  On the other hand, when the search result is 0 (step S1506: Yes), the DB server 201 deletes the column name used in the select phrase of the search query from the extraction unnecessary column of the extraction rule file (step S1510). Here, in the process of step S1510, when the column name is deleted, the DB server 201 may notify the AP server 202 that the search result may be one or more due to the next data fetching. . Thus, if the user who viewed the notification operates the user terminal 203 to issue the same search query as the current search query after fetching the next data, the user really wanted to obtain it. Search results can be obtained.

  After the process of step S1509 or step S1510 is completed, the DB server 201 ends the search control process. By executing the search control process, the DB server 201 can update the extraction rule file 511 in accordance with the issued search query.

  As described above, according to the DB server 201, data to be stored in the integrated summary DB 204 is determined based on a search query from the AP server 202, and data stored in the integrated summary DB 204 is periodically read from the raw data 212. Store in the integrated summary DB 204. As a result, the search system 200 can suppress the storage amount of the integrated summary DB 204 while storing data in the integrated summary DB 204 to suppress a decrease in search accuracy. Further, since the DB server 201 determines the data to be extracted from the search query issued from the AP server 202, it can create a rule for creating the integrated summary DB 204 without human intervention.

  Further, according to the DB server 201, the column name specified by the search query is determined as the column name to be stored in the integrated summary DB 204, and the value corresponding to the column name read from the raw data 212 is associated with the column name. In addition, it may be stored in the integrated summary DB 204. Thus, the search system 200 can reduce the amount of data stored in the integrated summary DB 204 while maintaining the search accuracy even if the raw data 212 is a relational DB.

  Also, according to the DB server 201, the column name specified by the search query and the column name set in the primary key are determined as the column names to be stored in the integrated summary DB 204, and the determined column name is specified. The extraction rule file 511 to be generated may be generated. As a result, the DB server 201 uses the column name set as the primary key as the column name to be stored in the integrated summary DB 204, so that each record of the integrated summary DB 204 can be prevented from being uniquely identified. .

  Further, according to the DB server 201, if the search result for the search query to the integrated summary DB 204 is 0, the column name specified by the search query is set as the column name to be stored in the integrated summary DB 204. The extraction rule file 511 may be updated. As a result, the DB server 201 can save the data that has not been taken in once, and can improve the search accuracy.

  Further, according to the DB server 201, when the search query includes outputting data obtained by rounding data detected by the search query, the rounded data is determined as data to be stored in the integrated summary DB 204. Also good. Thereby, since the data amount of the rounded data is smaller than the original data, the DB server 201 can reduce the data amount stored in the integrated summary DB 204 while maintaining the search accuracy. Further, the DB server 201 can apply the rounded data as an object to be stored even if the raw data 212 is not a relational DB.

  The data search control method described in this embodiment can be realized by executing a program prepared in advance on a computer such as a personal computer or a workstation. This data retrieval control program is recorded on a computer-readable recording medium such as a hard disk, a flexible disk, a CD-ROM (Compact Disc-Read Only Memory), a DVD (Digital Versatile Disk), and is read from the recording medium by the computer. Is executed by. The data search control program may be distributed via a network such as the Internet.

  The following additional notes are disclosed with respect to the embodiment described above.

(Supplementary note 1)
Obtaining a search request issued to the second storage area for storing data read from the first storage area;
Based on the obtained search request, determine data to be stored in the second storage area from data stored in the first storage area,
The determined data is read out from the first storage area at a predetermined cycle, and the read data is stored in the second storage area.
A data search control program characterized by causing a process to be executed.

(Appendix 2) The data stored in the first storage area is a value associated with each attribute of a plurality of attributes,
The determining process is as follows:
Determining an attribute specified in the search request as an attribute to be stored in the second storage area;
The storing process is:
A value corresponding to the determined attribute is read from the first storage area at the predetermined cycle, and the read value is stored in the second storage area in association with the attribute. The data search control program described in 1.

(Supplementary note 3)
Of the plurality of attributes, an attribute specified by the search request and an attribute associated with a value for identifying a set of values associated with each attribute are stored in the second storage area. Generate a rule that identifies the attribute as a target attribute,
The storing process is:
A value corresponding to the attribute specified by the generated rule is read out from the first storage area at the predetermined cycle, and the read value is associated with the attribute specified by the rule in the second storage area The data search control program according to appendix 2, wherein the data search control program is stored in

(Supplementary note 4)
A search request issued to the second storage area that stores a value read according to the rule and an attribute specified by the rule in association with each other, and a search result corresponding to the search request are acquired. ,
When the acquired search result indicates that a value corresponding to the attribute specified in the search request is not detected, the rule stores the attribute specified in the search request in the second storage area. Update to the rules included in the target attribute,
A value corresponding to the attribute specified by the updated rule is read out from the first storage area at the predetermined cycle, and the read value is associated with the attribute specified by the rule in the second storage area Remember
4. The data search control program according to appendix 3, wherein the process is executed.

(Supplementary note 5)
When outputting the data obtained by rounding the data detected by the search request is included in the search request, the rounded data is determined as data to be stored in the second storage area. The data search control program according to appendix 1.

(Additional remark 6) The process to determine is as follows.
When the search request includes outputting a value obtained by rounding the value detected for the attribute specified in the search request, the value to be stored in the second storage area Determined as
The storing process is:
Any one of appendices 2 to 4, wherein the determined value is read from the first storage area at the predetermined cycle, and the read value is stored in the second storage area in association with the attribute. A data search control program according to any one of the above.

(Appendix 7) Obtaining a search request issued to the second storage area for storing data read from the first storage area,
Based on the obtained search request, determine data to be stored in the second storage area from data stored in the first storage area,
The determined data is read out from the first storage area at a predetermined cycle, and the read data is stored in the second storage area.
A computer comprising a control unit.

(Appendix 8) The computer
Obtaining a search request issued to the second storage area for storing data read from the first storage area;
Based on the obtained search request, determine data to be stored in the second storage area from data stored in the first storage area,
The determined data is read out from the first storage area at a predetermined cycle, and the read data is stored in the second storage area.
A data search control method characterized by executing processing.

101 Computer 111 First Storage Area 112 Second Storage Area 200 Search System 201 DB Server 202 AP Server 203 User Terminal 204 Integrated Summary DB
211 Business System 212 Raw Data 500 Control Unit 501 Acquisition Unit 502 Determination Unit 503 Storage Unit 504 Update Unit 511 Extraction Rule File

Claims (7)

On the computer,
Obtaining a search request issued to the second storage area for storing data read from the first storage area;
Based on the obtained search request, determine data to be stored in the second storage area from data stored in the first storage area,
The determined data is read out from the first storage area at a predetermined cycle, and the read data is stored in the second storage area.
A data search control program characterized by causing a process to be executed. The data stored in the first storage area is a value associated with each attribute of the plurality of attributes,
The determining process is as follows:
Determining an attribute specified in the search request as an attribute to be stored in the second storage area;
The storing process is:
The value corresponding to the determined attribute is read from the first storage area at the predetermined cycle, and the read value is stored in the second storage area in association with the attribute. The data search control program according to 1. The determining process is as follows:
Of the plurality of attributes, an attribute specified by the search request and an attribute associated with a value for identifying a set of values associated with each attribute are stored in the second storage area. Generate a rule that identifies the attribute as a target attribute,
The storing process is:
A value corresponding to the attribute specified by the generated rule is read out from the first storage area at the predetermined cycle, and the read value is associated with the attribute specified by the rule in the second storage area The data search control program according to claim 2, wherein the data search control program is stored in the data search program. In the computer,
A search request issued to the second storage area that stores a value read according to the rule and an attribute specified by the rule in association with each other, and a search result corresponding to the search request are acquired. ,
When the acquired search result indicates that a value corresponding to the attribute specified in the search request is not detected, the rule stores the attribute specified in the search request in the second storage area. Update to the rules included in the target attribute,
A value corresponding to the attribute specified by the updated rule is read out from the first storage area at the predetermined cycle, and the read value is associated with the attribute specified by the rule in the second storage area Remember
The data search control program according to claim 3, wherein the process is executed. The determining process is as follows:
When outputting the data obtained by rounding the data detected by the search request is included in the search request, the rounded data is determined as data to be stored in the second storage area. The data search control program according to claim 1. Obtaining a search request issued to the second storage area for storing data read from the first storage area;
Based on the obtained search request, determine data to be stored in the second storage area from data stored in the first storage area,
The determined data is read out from the first storage area at a predetermined cycle, and the read data is stored in the second storage area.
A computer comprising a control unit. Computer
Obtaining a search request issued to the second storage area for storing data read from the first storage area;
Based on the obtained search request, determine data to be stored in the second storage area from data stored in the first storage area,
The determined data is read out from the first storage area at a predetermined cycle, and the read data is stored in the second storage area.
A data search control method characterized by executing processing.

Images