JP5061996B2 - Database search program, search device, and search method - Google Patents

Description

  The present invention relates to a database search technique, and more particularly, to a database search program, a search apparatus, and a search method for narrowing down data from a database that manages data using a table.

  In a computer system, a database is used as a means for efficiently managing data. From the viewpoint of the purpose of use, the database is classified into a “basic database” that mainly handles transaction processing and an “information database” that handles historical data. The core database is used to directly support daily business operations such as bank accounting systems, seat reservation, sales management, and inventory allocation, and handles data that is generated and changed daily. The information database accumulates data that is generated and changed every day as history data using time series as a key. The information database is used to support corporate strategy planning, marketing, management simulation, and the like. In particular, a database constructed mainly by retrieving historical data is called a “data warehouse”. Data warehouses are used to accumulate daily sales information for each customer in the industrial field such as the distribution industry, as well as for marketing and store assortment.

  Currently, relational databases are mainstream. The relational database is a tabular database that manages data by a table. In a relational database, one data (record) is stored in each row of a table. A table is usually composed of a plurality of columns, and data of the same item (attribute) is stored in each column. Therefore, the data of each row of the table is composed of values (attribute values) of one or more items (also called column items).

  When extracting desired data from such a database, “refining search” is usually performed. In order to perform this narrowing search, it is necessary to set a search condition (data extraction condition). The search condition setting is an operation for designating the same value as the item of data to be extracted as the value of one or more items of the record.

Conventionally, a database data refinement search is performed, for example, by the following procedure.
1) A setting condition screen for a column (column item) is displayed.
2) Set an OR condition or AND condition for one or more items on the setting condition screen.
3) The database is searched according to the set condition, and data matching the search condition is displayed on the screen.
4) If the number of extracted data is large, additional conditions are set in the same manner as in 2) above, and the database is searched again.
5) Repeat the process of 4) until the number of extractions reaches an appropriate amount.
6) As a result of the search in the above 4), if the number of extractions is less than expected due to excessive filtering, an OR condition is added on the setting condition screen, and the above processing in 3) is executed again. Alternatively, the screen returns to the previous search result screen (see, for example, Patent Document 1).

Further, as a prior art related to the present invention, a system for narrowing down data using a plurality of conditions from a document database is known (for example, see Patent Document 2).
JP 2006-18647 A Japanese Patent Laid-Open No. 5-28910

  The above-mentioned conventional database refinement search method simply displays the search results on the screen after executing the search, so it is not known whether the refinement will be successful just by setting additional conditions. For the first time, I was able to see if the narrowing was successful.

  For this reason, it was not possible to know appropriate narrowing conditions in advance, and narrowing down could not be performed efficiently. This disadvantage has become a problem because it becomes more prominent as the size of the database increases.

  An object of the present invention is to enable efficient database search.

  According to one aspect of the database search program of the present invention, a user can collectively use a computer to narrow down data from all items of data arranged in each row of the tabular first database. A means A for inputting the selected item, and a type of the value and the number of data having each value for each of the batch selected items input by the means A of the data in the first database, A means B for displaying the type of value and the number of data of each value for each item selected at once, and one of the items in which the type of value and the number of data of each value are displayed by the means B The item specified by the means C or the following means G by searching the means C for designating the value of the item and the second database created by the first database or the following means E. Means D for extracting data having the following: means E for creating a tabular second database in which the data extracted by means D is stored in each row; and means A for the data in the second database Among the items inputted by the above-mentioned means C or the following means G, the type of the value and the number of data of each value are obtained for the non-designated item for which the value has not yet been designated. And means F for displaying the number of data having each value, and means G for designating one item and the value of the item from the items in which the type of value and the number of data of each value are displayed by the means F Each time an item value is designated by the means G, the means D, means E, means F, and means H are sequentially executed, and a function as a database search device is provided.

  According to another aspect of the database search program of the present invention, the computer has not yet been used for a data refinement search from a plurality of items of data stored in each row of the tabular first database. Means A for selecting one item, and the type of the value selected for the item selected in the step of the means of data stored in the first database or the second database created by means E below Means B for obtaining the number of data items of each value and displaying the type of value of the item and the number of data items of each value; means C for designating one value from the item values displayed by the means B; Means D for searching the first database or the second database created by means E to extract data having the value of the item designated by means C , A means E for creating a tabular second database in which the data extracted by the means D is stored in each row, and each time an unspecified item is selected by the means A, the means B, means C, And means F for causing the means D and E to be executed repeatedly.

According to the present invention, when a search item of data is selected when narrowing down a database, the type of value and the number of data having each value are displayed in advance for the selected search item. Further, when data is extracted by executing a search, a set of the extracted data is set as a new database of search bases. Then, based on the data in the database of the new search matrix, the value type of the unspecified search item and the number of data having each value are displayed.

  According to the disclosed program, when searching a database, the type of value and the number of data having each value are displayed in advance for the items used for the search. Therefore, it is possible to efficiently perform a database search.

Hereinafter, embodiments of the present invention will be described with reference to the drawings.
[Constitution]
{System configuration}
FIG. 1 is an overall configuration diagram of a computer system including a server to which an embodiment of the present invention is applied.

  The computer system shown in FIG. 1 includes a Web server 10, a terminal (user terminal) 20, and a DB server (database server) 30. The Web server 10 and the terminal 20 are communicatively connected via a WAN (Wide Area Network) 40 such as the Internet or VPN (Virtual Private Network). The Web server 10 and the DB server 30 are connected by a network 50 such as a LAN (Local Area Network). This LAN is connected to the WAN 40 via a router (not shown), for example.

  An analysis support tool 11 that is an embodiment of the present invention is mounted on the Web server 10. The analysis support tool 11 is executed by a Web server 10 that is a computer. The terminal 20 uses a communication protocol such as HTTP (Hyper Text Transfer Protocol) to receive a document (file) written in HTML (Hyper Text Markup Language), XML (eXtensible Markup Language), or the like from the Web server 10 ( (Browsing software) 21 is installed.

  The DB server 30 is a server that functions as a DBMS (database management system), and includes a DB (database) 31 and a search engine 32. The DB 31 stores a plurality of tables 311. This DB 31 is managed by the DB server 30. The search engine 32 searches the table 311 in the DB 31 in response to a request (inquiry) from the Web server 10 and extracts data corresponding to the requested condition from the table 311. The DB server 30 returns the data extracted by the search engine 32 to the Web server 10.

  The Web server 10 makes various requests for the database 311 in the DB 31 to the DB server 30 using, for example, CGI (Common Gateway Interface), and receives processing results for the request from the DB server 30. The Web server 10 analyzes and processes the processing result received from the DB server 30 by the analysis support tool 11 and creates an HTML file or the like for transmission to the browser 21.

  The analysis support tool 11 communicates with the browser 21 on the terminal 20 via the WAN 40 and controls the screen display of the browser 21. The analysis support tool 11 creates an HTML file (HTML document) for causing the browser 21 to display a screen for narrowing and searching the database 311 in the DB 31 and a screen for displaying the narrowed search results. Send to. The browser 21 analyzes the HTML file received from the analysis support tool 11 and displays the screen on the terminal 20.

{Hardware configuration of Web server}
FIG. 2 is a diagram illustrating a hardware configuration of the Web server 10.
The Web server 10 includes a CPU (Central Processing Unit) 101, a memory 102, an input device 103, a display device 104, an external storage device 105, and a communication device 106. The CPU 101 and the other devices 102 to 106 are connected to each other by a bus 107.

  The CPU 101 controls each component 102 to 103 of the system to control processing of the entire system. The memory 102 is a semiconductor memory such as a ROM or a RAM, for example. The memory 102 includes a program load area 102a in which software (program) such as the analysis support tool 11 is loaded, a work area (work area) 102b used when the software performs processing, and the like.

  The input device 103 includes a pointing device such as a keyboard and a mouse, and is used for installing and starting a program (software) such as the analysis support tool 11. The software is installed and activated by, for example, a mouse operation. The display device 104 is, for example, a CRT display or a liquid crystal display, and displays a GUI (Graphical User Interface) screen for system management. The external storage device 105 stores an OS (basic software) and programs (software) such as the analysis support tool 11. The external storage device 105 is, for example, an HDD (Hard Disk Drive), a magneto-optical disk device, an optical disk device, or an SDD (Solid State Disk). Programs such as the analysis support tool 11 are loaded from the external storage device 105 into the memory 102 and executed by the CPU 101, thereby executing main processing related to the present invention of the present embodiment. The network connection device 106 is a network connection device used for the Web server 10 to communicate with the terminal 20 or the DB server 30 via the WAN 40 or the network 50, and is a NIC (network for connecting the Web server 10 to the LAN. Interface card). The network connection device 106 is also used for downloading the analysis support tool 11 to the external storage device 31 via the WAN 40 or the network 50. Although not particularly illustrated, the Web server 10 also includes a portable storage medium reading device such as a CD or DVD, and the analysis support tool 11 is installed in a slot for a portable storage medium provided in the main body. The analysis support tool 11 can be downloaded from the portable storage medium to the external storage device 31 by mounting the stored portable storage medium.

{Configuration of analysis support tool 11}
FIG. 3 is a functional block diagram of the analysis support tool 11.
The analysis support tool 11 includes browser control means 11a, browser screen creation means 11b, DB search result analysis means 11c, sub-table creation means 11d, history information creation means 11e, DB server search means 11f, and the like.

The browser control unit 11 a transmits an HTML file to the browser 21 and receives user input data from the browser 21. The browser screen creation unit 11b creates an HTML file in which the content and format of the screen displayed on the terminal 20 by the browser 21 is defined. The DB server search unit 11 f transmits a search request for the table 311 to the DB server 30. Further, the search result of the table 311 is received from the DB server 30. The DB search result analysis unit 11c receives the search result of the table 311 from the DB server search unit 11f, analyzes the contents thereof, and obtains information necessary for the display screen of the browser 21 and information necessary for creating the subtable. get. Here, the sub-table is an intermediate result when the table 311 is narrowed down and is a collection (table) of data extracted up to the present time. The information necessary for the display screen of the browser 21 is the type of the item value as the data extraction condition, the number of each value, and the like. These will be described in detail later by specific examples. The sub table creation unit 11 d creates the sub table based on the data received from the DB search result analysis unit 11 c and stores it in the work area 102 b in the memory 102. Based on the information received from the DB search result analysis unit 11c, the history information creation unit 11e creates history information in the narrow search of the table 311 and stores it in the work area 102b. This history information is composed of, for example, the total number of tables 311 to be subjected to the narrowing search, the number of data extracted by the first, second, third,.

{Configuration of work area 102b}
FIG. 4 is a diagram showing the configuration of the work area 102b.
As shown in FIG. 4, the work area 102b includes a history information storage area 1021b, a narrowed number storage area 1022b, a sub-table storage area 1023b, and a browser screen display data storage area 1024b.

  The history information storage area 1021b is an area in which the history information is written. The narrowed-down number storage area 1022b is an area in which the current number of narrowed-down data (the number of extracted data) is written. The subtable storage area 1023b is an area where the subtable is written each time. The browser screen display data storage area 1024b is an area in which browser screen display data is written. This display data is, for example, an HTML document.

{Example of search condition setting screen}
FIG. 5 shows an example of the search condition setting screen. 5A, 5B, and 5C are diagrams showing the format of the collective condition extraction screen 110 (110A, 110B, 110C) as an example.

  The batch condition extraction screen 110 has a “column item name” field 1101, a “number of cases display” field 1102, and an “extract” button 1103 arranged from above. The column item field 1101 is a field in which “column item name (column item name)” selected by the user of the terminal 20 (hereinafter referred to as a user) is displayed. The number display field 1102 is a field in which the “value” of the column item name set in the column item name field 1101 on the same screen and the “number” of data having the value are displayed as a list. The user designates (selects) “value” as an extraction condition from the number display field 1102. The extraction button 1103 is used to select the extraction condition (search condition) selected on the collective condition extraction screen 110, that is, data in which the value of the column item name displayed in the column item name field 1101 matches the selected “value”. This is a button for instructing execution of extraction (search). The column item is an item of data stored in each row of the table 311 which is a table. Therefore, “column item” and “item” described in this specification have the same meaning.

  In the present embodiment, the browser 21 and the analysis support tool 11 are used to perform a narrowing search from a table 311 in a tabular format stored in the DB 31. In this narrowing search, one “column item” in the table format table 311 is selected via each batch condition extraction screen 110 such as the batch condition extraction screen 110A, the batch condition extraction screen 110B, and the batch condition extraction screen 110C. This is done by selecting (specifying) in order. FIG. 5 shows three collective condition extraction screens, but this is only an example. In the refinement search of this embodiment, the refinement search is continued while sequentially specifying one column item via the collective condition extraction screen until the number of extracted data becomes equal to or less than the desired value. Therefore, the number of collective condition extraction screens required for the narrow search is not necessarily limited to three.

In addition, the collective condition extraction screens 110 (110A, 110B, 110) shown in FIGS.
In C), the number of lines in the number display field 1102 is the same on all the screens. However, in actuality, the number of lines varies depending on the extraction result, and therefore does not necessarily match.

{DB31 configuration example}
FIG. 6 is a diagram illustrating a configuration example of the DB 31.
The DB 31 illustrated in FIG. 6 stores tabular databases such as an order table 311, a price master 312, and a unit price master 313.

  The order table 311 includes column items of “product name”, “order month”, “delivery date”, “unit price (yen)”, “quantity”, and “amount (yen)”. The order month, delivery date, unit price (yen), quantity and amount (yen) are stored for each product A, B,. The amount (yen) is the total amount to be ordered.

[Operation]
{Overview of refined search in this embodiment}
7 to 12 are diagrams for explaining a method for searching a list of desired ordered products from the order table 311 shown in FIG. Specifically, in the examples shown in FIG. 7 to FIG. 11, the data satisfying the condition “a list of orders for products with the delivery date of January 2008 and the earliest order month” from the order table 311 is narrowed down and searched. This is an example of extraction.

  In the case of this data extraction (restriction search), the column items that serve as extraction keys (search keys) are “delivery date” and “order month”, and the value of the delivery date is “2008.01”. Hereinafter, an operation / processing procedure for extracting product data satisfying the above conditions from the order table 311 by a narrowing search will be described with reference to FIGS.

  (1) First, the analysis support tool 11 controls the browser 21 to display the extraction screen 200-1 shown in FIG. In this extraction screen 200-1, all the column items of the order table 311 are displayed in the item list field 120 at the top of the screen.

  (2) The user selects “Delivery” from the item list field 120 of the extraction screen 200-1 as the first search item of the narrow search, and displays the item list as indicated by the arrow mark in FIG. Drag and drop to the lower area of the field 120. By this operation, as shown in FIG. 8, the collective condition extraction screen 110-1 is automatically displayed on the extraction screen 200-2, and “delivery date” is set and displayed in the column item name field 1101-1. The The number display field 1102-1 of the collective condition extraction screen 110-1 displays a list of all delivery date values (year / month) and the number of each value existing in the order table 311 in order of the number of cases. The

  The above processing is performed as follows. When “Delivery date” is set in the column item name field 1101-1 by the drag-and-drop operation, the browser 21 sets “Delivery date” as the first search condition of the refinement search of the order table 311 to the analysis support tool 11. ". The analysis support tool 11 sends the first extraction condition received from the browser 21 to the DB server 30. When the DB server 30 receives “delivery date” as the first extraction condition of the order table 311 from the analysis support tool 11, the search engine 32 searches all the rows of the order table 311 and sets all the values in the “delivery date” field. Extract and count the number of each value. Then, list data of individual values of delivery date and the number of values (number of data) is created. This list data is sent from the DB server 30 to the analysis support tool 11. Based on the number list data, the analysis support tool 11 creates data (first number list display data) to be displayed in the number display field 1102-2 of the extraction screen 200-2 and sends it to the browser 21. . Based on the first number list display data received from the analysis support tool 11, the browser 21 displays a list of number of delivery dates in the number display field 1102-1 of the collective condition extraction screen 110-1 (see FIG. 8).

  (3) The user selects a row (in this case, the second row) in which the value of the column item “delivery date” is “2008.01” from the number display field 1102-1 shown in FIG. Click the Extract button 1103-1. When this click operation is performed, the browser 21 transmits “Delivery value = 2008.01” as the first search condition of the narrow search to the analysis support tool 11. The analysis support tool 11 sends the first search condition received from the browser 21 to the DB server 30. Thereby, the search engine 32 executes a search (first search) of the order table 311 in the DB 31. In this first search, the search engine 32 extracts data in which the value of the delivery date field is “January 2008” from the order table 311. As a result, the search engine 32 extracts three pieces of data (data whose product names are A, B, and C) from the order table 311. The search engine 32 creates a sub-table 300-1 shown in FIG. 9 based on these three pieces of data, and stores it in a memory (not shown) in the DB server 30. The sub-table 300-1 is a database used for the next search of the search engine 32, and is a collection of data narrowed down from the order table 311 by the first search.

  (4) The user selects “order month” from the item list field 120 of the extraction screen 200-3 shown in FIG. Drag and drop to the area. Thus, the collective condition extraction screen 110-2 shown in FIG. 11 is automatically displayed, and “order month” is set and displayed in the column item name field 1101-2. Further, the number display field 1102-3 on the collective condition extraction screen 110-3 includes all the values of “order month” of the data in the order table 311 whose delivery date is “January 2008” and the respective values. Are listed in descending order.

  (5) The user selects the row (first row) “2007.08” with the earliest order month from the number display field 1102-2 of the collective condition extraction screen 110-2, and clicks the extraction button 1103. . By this click operation, the browser 21 transmits “order month value = 2007.08” to the analysis support tool 11 as the second search condition for the narrow search. Upon receiving the second search condition from the browser 21, the analysis support tool 11 sends it to the DB server 30. When the DB server 30 receives the second search condition from the analysis support tool 11, the DB server 30 starts the search engine 32 and passes the second search condition to the search engine 32. The search engine 32 searches the data stored in the data 300-1 created in the above (3), and extracts data in which the value of the “order month” field is “2007.8”. As a result, the search engine 32 extracts data in which the name of the “product name” field is “B” from the sub-table 300-1 shown in FIG. The search engine 32 creates a sub-table (sub-table 300-2 shown in FIG. 11) composed of the one piece of data, and stores it in the memory in the DB server 30. The DB server 30 sends the data extracted by the search engine 32 to the analysis support tool 11. Upon receiving the extracted data from the DB server 30, the analysis support tool 11 creates an HTML document for displaying the extracted data on the browser 21 and sends the HTML document to the browser 21. When the browser 21 receives the HTML document from the analysis support tool 11, the browser 21 displays data (data 1-3) having the product name “B” on the extraction screen 200-4 shown in FIG.

  As described above, the product name “Product with the earliest order date in January 2008 delivery date” is obtained from the order table 311 in the DB 31 by the series of processes (1) to (5). Are extracted by a refined search. 7, 8, 10, and 12, the arrow symbols and the operations 1 to 3 in the extraction screen 200 (200-1 to 200-4) and the rectangular frame surrounding them are images for explaining operations. , Not actually displayed on the screen.

{Processing of analysis support tool 11}
FIG. 13 is a flowchart showing the processing procedure of the analysis support tool 11. The processing procedure of the analysis support tool 11 will be described with reference to FIG. This flowchart includes processing on the browser 21 side.

The flowchart shown in FIG. 13 shows a narrowing search process after a table (table 311) to be subjected to a data narrowing search is selected.
The analysis support tool 11 first displays a list of all items in the narrowed search target table on the browser screen (step S11). From the list display, the user selects items to be used as extraction criteria for the refined search (step S12). Information on the items selected at once is transmitted from the browser 21 to the analysis support tool 11.

  The analysis support tool 11 obtains the above-described narrowed search target table from the DB server 30. Then, the table is analyzed by the DB search result analyzing means 11c, and the value type and the number of values of each value are totalized for each item selected in the batch for the table to be narrowed search. Then, the type of value and the number of values of each value are displayed on the browser screen for each item selected at once (step S13).

  The user selects the first item for setting the extraction condition on the browser screen (step S14). There are two methods for specifying the condition of this selection item: a method of directly specifying a value and a method of setting (specifying) a conditional expression (such as an arithmetic expression).

  Therefore, it is determined whether or not a conditional expression is set (step S15). If no conditional expression is set (step S15, No), the value of the selection item is specified (step S16). On the other hand, if a conditional expression is set (step S15, Yes), the conditional expression and a value used in the conditional expression are set (designated) (step S17).

  Subsequently, it is determined whether or not the user has performed a refined search instruction operation based on the extraction condition specified in step S16 or step S17 on the browser screen (step S18). The process of step S18 is repeated until it is determined that an instruction operation has been performed.

  If it is determined in step S18 that the user has performed an instruction operation for extraction (refinement search) (step S18, Yes), the browser 21 transmits the extraction condition to the analysis support tool 11. When the analysis support tool 11 receives the extraction condition from the browser 21, the DB server search unit 11f requests the DB server 30 to search for data that satisfies the extraction condition, and extracts the data from the narrowed search target table. (Step S19).

  The sub-table creating means 11d of the analysis support tool 11 creates a sub-table composed of the extracted data and stores it in the sub-table storage area 1023b (step S20).

  The DB search result analysis unit 11c of the analysis support tool 11 analyzes the sub-table, and tabulates the value type of the selection item and the number of each value in the sub-table. The history information creation unit 11e creates history information based on the tabulation result of the DB search result analysis unit 11c, and stores it in the history information storage area 1021b (step S21).

The browser screen creation means 11b of the analysis support tool 11 displays the number of narrowed-down items (the number of extracted data) and the above-mentioned selection items (value, number) on the browser screen based on the tabulated result of the DB search result analyzing means 11c. A list of pairs is displayed (step S22).

  Next, it is determined whether or not there is a selection item whose extraction condition is not specified (step S23). If there remains a selection item whose extraction condition is not specified, the process returns to step S14. On the other hand, if there is no selection item whose extraction condition is not specified, the process of this flowchart is terminated.

  In this way, the processing of steps S13 to S22 is performed for all items selected at once in step S12, a narrowing search is performed for the table to be narrowed and searched, and data is extracted from the table. In this case, the data extraction condition in the data search request to the DB server 30 in step S19 is an AND of all the extraction conditions specified so far in step S16 or step S17. In this case, by using the “CREATE VIEW” sentence of SQL that is a database operation language, the table that becomes the search base (table to be narrowed search) can be obtained by the narrowed search up to the previous time in the data extraction in step S19. It is possible to use a “view table (virtual table)” that is a collection of data. This view table is created by the DB server 30, and the analysis support tool 11 can extract data from the view table using a SELECT statement. This view table is equivalent to a sub-table created by the analysis support tool 11. Therefore, the analysis support tool 11 reads all data from the view table created on the DB server 30 using the SELECT statement when displaying a table view screen to be described later, and sends it to the browser 21 based on the data. It is also possible to create an HTML document for displaying the table view screen.

  As described above with reference to FIGS. 6 to 12, the number of data to be extracted decreases each time a narrowing search is performed. Therefore, there may be a case where the number of data falls within a desired number range during the narrowing search. Therefore, in preparation for such a case, a step of determining an instruction to cancel the narrowing search may be added to the flowchart of FIG. 13, and the process may be terminated when an instruction to stop the narrowing search is instructed. A specific example of the processing of the flowchart of FIG. 13 will be described in detail in an embodiment described later.

[Example]
Specific examples of the present invention will be described.
Here, an example will be described in which desired data is extracted from the order condition master table by a narrow search. FIG. 14 is a diagram showing a table view screen 2000 that displays all data (all records) of the ordering condition master table that is a data extraction target of the present embodiment. On the table view screen 2000, all data in the ordering condition master table can be viewed. In the table view screen 2000, all data (all records) in the ordering condition master table are record numbers. They are displayed in the order of (Rec No), and the contents of all data can be confirmed by scrolling.

  The total number of data (total number of records) in the order condition master table of this embodiment is 173999. When extracting desired data from the order condition master table, the order condition master table is selected from a table selection screen (not shown). Then, an “ordering condition master table” extraction screen 2100-1 (hereinafter, abbreviated as extraction screen 2100-1) shown in FIG. 15 is displayed.

  The extraction screen 2100-1 mainly includes an item list field 2110 provided at the upper stage of the screen and a condition setting field 2120 provided at the lower stage thereof. On the right side of the item list field 2110, a display switching check box group 2150 and a work button group 2160 are provided. Since the display switching check box group 2150 and the work button group 2160 are not the main part of the present invention, detailed description thereof will be omitted.

  In the item list field 2110, all items (column items) of the order condition master table are displayed. This display corresponds to the processing in step S11 in the flowchart of FIG. When an arbitrary item displayed in the item list field 2110 is moved into the condition setting field 2120 by a drag and drop operation, the extraction screen 2100-1 is changed to an extraction screen 2100-2 shown in FIG. In the extraction screen 2100-2, a condition setting box 2130 for the item is automatically displayed on the left end side of the condition setting field 2120. At this time, the item moved from the item list field 2110 to the conditional expression setting field 2132 by the drag and drop operation is hidden in the item list field 2120. The operation for displaying these condition setting boxes 2130 corresponds to the processing in step S12 in the flowchart of FIG.

  The condition setting box 2130 includes an item name field 2131, a conditional expression setting field 2132, a display condition field 2133, an extraction method selection tab 2134, a data selection field 2135, and an extraction button 2136.

  The data selection field 2135 is a field that displays the attribute value of an item (hereinafter referred to as item value) and the number of data having the item value on the same line. The display form of the data selection field 2135 can be selected by checking (attaching) three check boxes provided in the display condition field 2133, which are “value order”, “number order”, and “not subject to extraction”. It has become. For example, if the “value order” check box is checked, the values are displayed in descending order, and if the “number order” check box is checked, the items are displayed in order from the largest number. A line number is displayed on the right side of each line in the data selection field 2135. This line number is displayed only for the line for which a value is set. In this example, even if the item data is other than a value such as “name”, it is referred to as “value” for convenience. Therefore, item data is also referred to as item value. In the data selection field 2135, the number of lines displayed in the data selection field 2135 is displayed above the line number. This number of lines is equal to the number of types of field values. The above display of the data selection field 2135 corresponds to the process of step S13 in the flowchart of FIG.

In the following, an operation method and associated screen transition when extracting data satisfying all of the following extraction conditions from the order condition master table by narrowing search will be described.
[Extraction condition]: From the order condition master table, the order classification of the order person condition information of the sales person who has the largest number of sales persons belonging to the sales department section code “68” has the order classification “ Data corresponding to B ″ and whose application start date is “after April 2006” is extracted.

  In the above extraction condition, the items to be narrowed down are “purchasing department code”, “purchasing person code”, “ordering category”, and “application start date”, and the value of the purchasing department code is “68”. ", The order classification symbol is" B ".

  (1) The above four search target items are dragged and dropped to the condition setting field 2120 from the item list field 2110 of the initial display state extraction screen 2100-1 shown in FIG. 15 (processing of step S12 in the flowchart of FIG. 13) Fall under). Here, the drag-and-drop operation is performed in the order of purchasing department code, purchasing person code, order category, and application start date. As a result of these series of drag and drop operations, as shown in FIG. 17, in the condition setting field 2120 of the extraction screen 2100-3, a condition setting box 2130-1 for the department in charge of purchasing in order from the left side of the screen. , A condition setting box 2130-2 for purchaser code, a condition setting box 2130-3 for order classification, and a condition setting box 2130-4 for application start date are displayed (processing in step S13 in the flowchart of FIG. 13). Fall under). In the extraction screen 2100-3 shown in FIG. 17, since the check box 2133-2 in the display condition field 2133 of the condition setting box 2130-2 for the purchaser code is checked, in the data selection field 2135. The purchaser code values are displayed in order of increasing number of cases. This is because “the person in charge with the largest number of cases in charge” is one of the extraction conditions. A check box in the display condition field 2133 of the condition setting box 2130 other than the purchaser code is not checked. For this reason, in the display condition field 2133 of the other condition setting box 2130, rows composed of “item values” and “the number of data having the item values” are displayed in the order of record numbers. In this example, all four items are selected at a time in the initial stage of the narrowing search, but the narrowing search may be performed while sequentially selecting each item.

  The extraction screen 2100-3 shown in FIG. 17 is, for example, an SQL in which the analysis support tool 11 generates a view table (virtual table) having the above four selection items as columns from the order condition master table for the DB server 30. Created by sending a CREATE VIEW statement. More specifically, when receiving the CREATE VIEW statement, the DB server 30 generates a view table (first view table) having the above four selection items as columns from the order condition master table. Next, the analysis support tool 11 sends a SELECT statement for selecting all data in the first view table to the DB server 30. In response to this, the DB server 30 returns all data of the first view table to the analysis support tool 11. The analysis support tool 11 stores these data in the sub-table storage area 1023b of the work area 102b of the memory 102. Then, the data is analyzed, an HTML document for displaying the extraction screen 2100-3 on the browser 21 is created, and the HTML document is transmitted to the browser 21. Thereby, the browser 21 displays the extraction screen 2100-3 on the screen of the terminal 20. The subsequent display of the extraction screen 2100 in this embodiment is performed by the series of processes described above. It should be noted that the same processing is possible even if only the SELECT statement is used without using the CREATE VIEW statement. However, in this embodiment, the table view screen 2000 is displayed in order to confirm each narrowed search result, so that the processing is faster when the CREATE VIEW statement is used, and the user of the terminal 20 Response speed is improved.

  (2) On the extraction screen 2100-3 shown in FIG. 17, scroll the data selection field 21135-1 of the condition setting box 2130-1 for the section in charge of purchasing as shown in the extraction screen 2100-4 shown in FIG. The purchasing department code “68” is displayed in the condition setting box 2130-1 for the purchasing department code. In the purchasing department code condition setting box 2130-1, the number of data (in this case, 33181) in which the purchasing department code is set to “68” is displayed together with the purchasing department code “68”. In the data selection field 2135-1, a purchase department section code whose value is “68” is selected (the above processing corresponds to the processing of steps S14 → S15 → S16 in the flowchart of FIG. 13). Then, the extraction button 2136-1 is clicked (corresponding to step S18 in the flowchart of FIG. 13, Yes).

  Accordingly, the browser 21 sends “purchasing department code = 68” to the analysis support tool 11 of the Web server 10 as the first extraction condition for the narrow search. Upon receiving the first extraction condition, the analysis support tool 11 requests the DB server 30 to extract data (record) having “purchasing department code = 68” from the ordering condition master table. Send. Upon receiving the request, the DB server 30 searches the order condition master table in the DB 31 by the search engine 32 and extracts 33168 items of data from the order condition master table (corresponding to step S19 in the flowchart of FIG. 13). ). Then, the extracted data is sent to the Web server 10. The analysis support tool 11 of the Web server 10 creates a sub-table (first sub-table) composed of the data based on 33168 pieces of data received from the DB server 30, and stores it in the sub-table storage area. 1023b (corresponding to step S20 in the flowchart of FIG. 13). The analysis support tool 11 further creates history information (first history information) based on the number of data items extracted this time and stores it in the history information storage area 1021b (step S21 in the flowchart of FIG. 13). Applicable to processing). In this way, the data of the order condition master table is narrowed down to 33168 cases.

  The above processing is performed by, for example, an SQL CREATE VIEW statement and a SELECT statement. In this case, the analysis support tool 11 creates a CREATE VIEW statement for creating a second view table composed only of data from the first view table whose purchase section code is “68”. 30 to cause the DB server 30 to generate a second view table. Next, the analysis support tool 11 sends a SELECT statement for selecting all data in the second view table to the DB server 30. As a result, the DB server 30 returns all data in the second view table to the analysis support tool 11. The analysis support tool 11 creates a first sub-table based on the data received from the DB server 30, and stores it in the sub-table storage area 1023b.

  In addition, in the extraction screen 2100-4 illustrated in FIG. Therefore, in the data selection field 2135-2 of the condition setting box 2130-2, the value of the person in charge of purchase and the number of cases of each value are displayed in the order of record numbers.

  (3) The analysis support tool 11 changes the display of the browser 21 of the terminal 20 from FIG. 18 to FIG. As shown in FIG. 19, on the extraction screen 2100-5 displayed by the browser 21, the display forms of the condition setting boxes 2130-1 to 2130-4 are changed. That is, only the purchase department code “68” and the number of data items “333181” in which the code is set are displayed in the data selection field 215-1 of the condition setting box 2130-1 for the purchase department code. In addition, the display of the data selection field 2135 (2135-2 to 2135-4) in the condition setting boxes 2130-2 to 2130-4 also changes to contents related to the 33181 data. That is, in each row of the data selection field 2135, the type of value and the number of values of each value of “purchaser person code”, “ordering category”, and “application start date” of the 33181 narrowed-down data are displayed. .

  The extraction screen 2100-5 is displayed as follows. The analysis support tool 11 creates an HTML document for causing the browser 21 to display the extraction screen 2100-5 shown in FIG. 19 based on the first sub-table. The Web server 10 transmits the HTML document to the browser 21 by the browser control unit 11a. The browser 21 analyzes the HTML document received from the Web server 10 and displays the extraction screen 2100-5 on the screen of the terminal 20.

  As described above, the first extraction condition that the value of the section in charge of purchasing is “68” narrows down the data in the ordering condition master table to 33181. And according to this data extraction result, the display of each data selection field 2135 of "purchaser person code", "ordering category", and "application start date" changes to the contents related to 33181 items of data. Specifically, as shown in FIG. 19, the type of “purchaser code” of the above 33181 data is “25”, the value of “order category” is “4”, “application start date” "Is changed to a display indicating that the value type is" 783 ", and each value and the number of cases are also displayed. As described above, the number of types can be known from the display of the number of rows.

  When the “table view” tab 2141 is selected on the extraction screen 2100-5 shown in FIG. 19, the browser 21 sends the operation information to the Web server 10. The analysis support tool 11 of the Web server 10 receives the operation information from the browser control unit 11a, and stores the first subtable stored in the subtable storage area 1023b and the history information storage area 1021b. The table view screen 2200-1 shown in FIG. 20 is displayed on the browser 21 based on the history information (corresponding to step S22 in the flowchart of FIG. 13). This display is performed based on the HTML document created by the browser screen creation means 11b of the analysis support tool 11. The browser screen creation unit 11b creates an HTML document for the browser 21 to display the table view screen 2200-2 based on the first sub-table and the first history information. This HTML document is transmitted to the browser 21 by the browser control means 11a. The browser 21 analyzes the HTML document received from the Web server 10 and displays the table view screen 2200 on the screen of the terminal 20.

  The table view screen 2200-1 includes a data display area 2210 and a narrowed search history display area 2220. In the data display area 2210, the contents of the 33181 narrowed-down data are displayed in the form of a table in the order of record numbers. Each row in the table corresponds to each data. Further, in the refinement search history display area 2220 provided on the left side of the data display area 2210, the refinement search history is displayed in order from the first data number. That is, the total number of data items “1739999” in the ordering condition master table is displayed at the top, and then the number of data items “33181” extracted by the current narrowing search is displayed. As described above, the table view screen 2000 displays a list of data extracted from the ordering condition master table up to now and the process of narrowing search up to the present. Therefore, the user of the terminal 20 can know the contents of all the data extracted up to now and the process of the refined search so far by referring to the table view screen 2000 displayed on the browser 21.

   (4) Subsequently, a narrowing search based on the person in charge of purchase is performed (corresponding to the processing of step S23, Yes → S14 in the flowchart of FIG. 13). Since the extraction condition of the purchaser code is “employee who has the most number of persons in charge”, first, in the extraction screen 2100-5 shown in FIG. 19, the number of cases in the purchaser code condition setting box 2130-2 is checked. Check the box. As a result, the screen of the browser 21 changes to an extraction screen 2100-6 shown in FIG. In the data selection field 21352-2 of the condition setting box 2130-2 for the purchaser code on the extraction screen 2100-6, values of the purchaser code are displayed in order of the number of cases.

  Therefore, in this case, the purchaser code “221” displayed in the first line is selected as an extraction target (corresponding to the process of step S16 in the flowchart of FIG. 13), and the extraction button 2136-2 is clicked ( This corresponds to step S17 in the flowchart of FIG. 13, Yes).

The browser 21 sends “purchaser code = 221” as the second extraction condition to the browser control unit 11 a of the analysis support tool 11 of the Web server 10.
The DB server search means 11f of the analysis support tool 11 extracts only the data in which the purchasing section code is set to “221” from the data stored in the second view table, and only the extracted data. A CREATE VIEW statement for generating a third view table composed of the following is sent to the DB server 30. The DB server 30 uses the CREATE
When the VIEW statement is received, the third view table is generated and saved. Next, the DB server search unit 11f sends a SELECT statement for selecting all data in the third view table to the DB server 30 to the DB server 30. The DB server 30 then sends the SELECT statement to the third view table. Get all the data in As a result, only data satisfying both the first extraction condition and the second extraction condition is extracted from the order condition master table (corresponding to the process of step S19 in the flowchart of FIG. 13).

  Subsequently, the DB search result analysis unit 11c and the sub table creation unit 11d create a second sub table composed of the extracted data and store it in the sub table storage area 1023b (the flowchart of FIG. 9). Corresponds to the process of step S20). Also, the second history information is created based on the number of the extracted data and stored in the history information storage area 1021b (step S21 in the flowchart of FIG. 13). Subsequently, the analysis support tool 11 displays the extraction screen 2100-7 shown in FIG. 22 on the screen of the browser 21 by the browser screen creation means 11b and the browser control means 11a (step S22 in the flowchart of FIG. 13).

  In the extraction screen 2100-7 shown in FIG. 22, the selected purchaser code “221” and the number of cases “16242” are displayed in the data selection field 21352-2 of the condition setting box 2130-2 of the purchaser code. Is done. In addition, the number display in the data selection field 21135-1 in the condition setting box 2130-1 of the purchasing department code also changes from “33181” to “16242”. Thereby, the user of the terminal 20 knows that the data (records) in the order condition master table can be narrowed down to 16242 by performing a narrowing search with the purchasing department section code “221” this time. Can do. In addition, the display of the data selection fields 2135-3 and 2135-4 of the order setting condition setting box 2130-3 and the application start date condition setting box 2130-4 is also in accordance with the extracted 16242 items of data. Automatically changes. Three types of order category values are displayed in the data selection field 2135 of the order category condition setting box 2130-3, and the data selection field 2135-4 of the data selection field 2135-4 of the condition setting box 2130-4 of the application start date is displayed. 4 displays 223 types of application start date values. As can be seen by comparing the extraction screens 2100-6 and 2100-7 in FIGS. 21 and 22, the order category values are narrowed down from four types to three types, and the application start date values are changed from 783 types to 223. It is narrowed down to the type. As described above, in this embodiment, when the purchaser section code and purchaser code are narrowed down in order, items that have not been narrowed down are automatically narrowed down. This is because every time the analysis support tool 11 performs a refinement search, a subtable composed of the refined data is created, and all the contents displayed in the condition setting field 2120 are based on the contents of the subtable. This is because the screen of the browser 21 is controlled so that the display of the data selection field 2135 of the condition setting box 2130 is changed.

  Similar to the operation described in (3) above, by selecting and operating the table view tab 2141 on the extraction screen 2100 shown in FIG. 22, the contents of all the data extracted up to now can be examined. In this case, the table view tab 2141 is selected on the extraction screen 2100-7 shown in FIG. Then, a table view screen 2000-2 shown in FIG. 23 is displayed on the screen of the terminal 20.

In the table view screen 2000-2, the extracted 16242 pieces of data are displayed in the data display area 2210. In the refinement search history display area 2220, the number (size) of data extracted in each process of refinement search of “purchasing department code” → “purchaser person code” is displayed in the order of retrieval.
These displays are executed by the analysis support tool 11 controlling the browser 21 by the processing described above.

(5) Next, further narrowing down by “order classification”. This narrowing will be described with reference to FIG. The extraction screen 2100-8 shown in FIG. 24 is the same as the extraction screen 2100-7 shown in FIG. As described above, the order category extraction condition is “B”. On the first line of the data selection field 2135-3 of the condition setting box 2130-3 for the order category on the extraction screen 2100-8, the order category value “B” and the number of cases “14117” are displayed. That is, so far, 14117 records (data) have been extracted from the order condition master table.

  In the extraction screen 2100-8 shown in FIG. 24, “B” is selected in the data selection field 2135-3 of the order setting condition setting box 2130-3 (corresponding to the process of step S14 in the flowchart of FIG. 13), and then Then, the extraction button 2136-3 is clicked (corresponding to step S15 in the flowchart of FIG. 13).

  By this click operation, the third narrowing search for the order condition master table is executed. The extraction condition (third extraction condition) in this narrowing search is “order category =“ B ””.

  When the click operation is performed, the DB server search unit 11 f of the analysis support tool 11 extracts “data with the order classification set to“ B ”from the third view table” to the DB server 30. , “CREATE VIEW statement for generating a fourth view table composed of the data” is sent. Thereby, the DB server 30 generates and stores the fourth view table.

  Next, the DB server search unit 11 f of the analysis support tool 11 sends a SELECT statement for selecting all data in the fourth view table to the DB server 30. Thereby, the DB server 30 returns all the data of the fourth view table to the DB server search unit 11f. As a result, the analysis support tool 11 acquires data satisfying all of the first extraction condition, the second extraction condition, and the third extraction condition from the order condition master table. The DB search result analysis unit 11c and the sub table creation unit 11d of the analysis support tool 11 create a third sub table composed of data received from the DB server 30, and store it in the sub table storage area 1023b. (Step S20 in the flowchart of FIG. 13). The history information creating unit 11e creates history information based on the number of data extracted this time, and stores it in the history information storage area 1021b (step S21 in the flowchart of FIG. 13). The browser screen creation means 11b creates an HTML document for causing the browser 21 to display the extraction screen 2100-9 shown in FIG. 25 based on the third sub-table. The browser control unit 11a transmits the HTML document to the browser 21. The browser 21 analyzes the HTML document received from the Web server 10 and displays the extraction screen 2100-9 shown in FIG. 25 on the screen of the terminal 20 (step 22 in the flowchart of FIG. 13).

  As shown in FIG. 25, the contents displayed in the data selection field 2135 of all the condition setting boxes 2130 of the purchase department section code, purchase person code, order classification, and application start date on the extraction screen 2100-9 are the above-mentioned refined search. The content changes accordingly. In the data selection field 2135 of the condition setting box 2130 for the purchase department code and purchase person code, the display of the number of cases changes to “14117”. In the data selection field 2135-3 of the order setting condition setting box 2130-3, only the value “B” that is the extraction condition of the narrowing search and the number of data having the value are displayed. In addition, in the data selection field 2135-4 of the condition setting box 2130-4 of the application start date, 14117 cases where the purchasing department code is “6”, the purchasing department code is “221”, and the order classification is “B”. The number of types of application start date “143” and the number of values of each of these 143 types are displayed in the order of the value of the application start date.

When the table view tab 2141 is clicked on the extraction screen 2100-9 shown in FIG. 25, the table view screen 2200-3 shown in FIG.

  In this table view screen 2200-3, all contents of 14117 data (records) extracted by the narrowed-down search so far can be browsed. In the refinement search history display area 2220 of the table view screen 2000-3, the process of refinement in the refinement search up to the current stage is displayed.

  The table view screen 2200-3 is displayed by the third subtable stored in the subtable storage area 1023b by the browser screen creation means 11b of the analysis support tool 11 and the history information stored in the history information storage area 1021b. This is executed by the browser 21 analyzing an HTML document created based on the above. The browser 21 receives the HTML document from the browser control unit 11 a of the analysis support tool 11.

  (6) The item of the fourth extraction condition (the last extraction condition in this example) is “application start date”. As described above, the extraction condition of the application start date is “after April 2006”. Therefore, in this case, in the extraction screen 2100-9 shown in FIG. 25, the “direct input” tab of the extraction method selection tab 2134 is clicked (step S14 → S15, Yes in the flowchart of FIG. 13), as shown in FIG. The “direct input” area 2136-4 is displayed on the extraction screen 2100-10. This direct input area 2136-4 is displayed in front of the upper part of the data selection field 2135-4. Here, “20060401” representing April 1, 2006 is input to the direct input area 2136. Then, “Result> = x” is selected from the pull-down menu of the conditional expression setting field 2132-4 (step S17 in the flowchart in FIG. 13), and the extraction button 2136-4 is clicked (step S18 in the flowchart in FIG. 13).

  By this click operation, the DB server search unit 11f of the analysis support tool 11 extracts the data in which “the“ application start date ”is set to April 2006 or later” from the fourth view table, and the extracted data A CREATE VIEW statement for generating a fifth view table composed of the following is sent to the DB server 30. As a result, the search engine 32 of the DB server 30 sets the value of the “application start date” item from the fifth view table. Is extracted as “20060401” or more, and a fifth view table is generated based on the extracted data. Next, the DB server search unit 11 f of the analysis support tool 11 sends a SELECT statement for extracting all data from the fifth view table to the DB server 30. Thereby, the DB server 30 returns all data of the fifth view table to the DB server search unit 11f (step S19 in the flowchart of FIG. 13). The sub table creation unit 11d of the analysis support tool 11 receives all the data of the fifth view table from the DB server search unit 11f, and creates a fourth sub table based on the received data. And it is preserve | saved in the subtable storage area 1023b (step S20 of the flowchart of FIG. 13). The history information creation means 11e of the analysis support tool 11 checks the number of data in the fourth subtable, adds the number of data to the history information storage area 1021b, and updates the history information in the history information storage area 1021b. (Step S21 in the flowchart of FIG. 13).

  The DB search result analysis unit 11c of the analysis support tool 11 analyzes the fourth subtable stored in the subtable storage area 1023b, and “application start date” item of each data in the fourth subtable. Investigate the value of, and count the type of value and the number of each value. The browser screen creation unit 11b creates an HTML document of the extraction screen 2100 to be displayed on the screen of the browser 21 based on the aggregation result acquired by the DB search result analysis unit 11c, and transmits it to the browser 21. The browser 21 analyzes the HTML document received from the Web server 10 and displays the extraction screen 2100-11 shown in FIG. 28 on the display of the terminal 20 (step S22 in the flowchart of FIG. 13).

  As shown in FIG. 28, the data selection field 2135-4 of the condition setting box 2130-4 on the application start date of the extraction screen 2100-11 displays a list of 69 types of values and the number of each value. In addition, the display of the number of items in the data selection field 2135 for each of the purchase department code, purchase person code, order classification, and application start date changes from “14117” to “5202”. The number of “5202” is the number of data narrowed down by the extraction condition of the application start date. Therefore, the user of the browser 21 can know that the number of data finally extracted is 5202.

  When the table view tab 2141 is clicked on the extraction screen 2100-11 shown in FIG. 28, the analysis support tool 11 displays the table view screen 2000 shown in FIG. 29 on the browser 21 based on the fourth sub-table. All items of the finally extracted data are displayed in the data display area 2210 of the table view screen 2000, and the data of the newly extracted data based on the extraction condition of the application start date is newly displayed in the narrowed search history display area 2220. The number “5202” is added.

  As described above, from the data of 173999 items in the order condition master table, {"purchaser section code = 68" AND "purchaser section code = 221" AND "order category = B" AND "application start date is 2006 By the narrowing search with the extraction condition “from April”, 5242 data could be extracted.

  In the case of the present embodiment, the analysis support tool 11 mounted on the Web server 10 sends an HTML document to the browser 21 mounted on the terminal 20, whereby an extraction screen 2100 and a table are displayed on the screen of the terminal 20 to the browser 21. A view screen 2200 or the like is displayed. Therefore, the processing load on the terminal 20 is small, and the extraction screen 2100 and the table view screen 2200 are displayed on the screen of the terminal 20 at high speed with a quick response. Further, by adopting a system configuration in which the Web server 10 and the terminal 20 are connected via the Internet, it is possible to perform a narrowing search of the data database (table) anytime and anywhere as long as the Internet connection environment is in place. In addition, the items of data (records) used in the refined search can be freely selected by the user from the terminal 20, and the search conditions (extraction conditions) of the items can be individually set for each item. The database can be narrowed and searched from various viewpoints. Each time a narrow search is performed for one item of data, the value of the item and the number of data having the value are displayed as a pair, so that the narrow search can be performed efficiently. This effect is particularly noticeable in a narrow search of a large amount of large-scale database, and it becomes possible to easily find valuable information embedded in a large amount of data.

  In the above embodiment, the present invention is applied to a client / server model system. However, the present invention is not limited to the system form, and can be applied to various forms of a computer system. For example, by implementing on a stand-alone computer, it becomes possible to narrow down the database in the stand-alone computer.

Regarding the above embodiment, the following additional notes are disclosed.
(Appendix 1)
Computer
Means A for inputting items collectively selected by a user for use in data narrowing down from all items of data arranged in each row of the first database in a tabular format;
For each item selected at once by the means A of the data in the first database, the type of value and the number of data having each value are obtained, and the value of the value for each item selected at once is acquired. Means B for displaying the type and the number of data of each value;
Means C for designating the value of one item from among the items in which the type of value and the number of data of each value are displayed by the means B;
Means D for searching the first database or the second database created by means E below, and extracting data having item values designated by means C or means G;
Means E for creating a tabular second database in which the data extracted by the means D is stored in each row;
Among the items input by the means A of the data in the second database, the type of value and the number of data of each value for an unspecified item whose value has not yet been specified by the means C or the means G below. Means F for acquiring and displaying the type of value and the number of data having each value for the unspecified item;
A means G for designating one item and the value of the item from the items in which the type of value and the number of data of each value are displayed by the means F;
Means H for repeatedly executing the means D, means E, means F and means G each time an item value is designated by the means G;
A program for functioning as a database search device having
(Appendix 2)
Computer
Means A for selecting one item that has not yet been used in the data refinement search from a plurality of items of data stored in each row of the first database in the table format;
For the item selected in the step of the means of the data stored in the first database or the second database created by means E described below, the type of value and the number of data items of each value are acquired, Means B for displaying the value type of the item and the number of data of each value;
Means C for designating one value among the values of the items displayed by the means B;
Means D for searching the first database or the second database created by means E below to extract data having the value of the item specified by means C;
Means E for creating a tabular second database in which the data extracted by the means D is stored in each row;
Means F for repeatedly executing the means B, means C, means D and means E each time an unspecified item is selected by the means A;
A program for causing a database to function as a database search device.
(Appendix 3)
A program according to appendix 1 or 2,
Computer
further,
Means for storing the number of data extracted in each search in the storage means as history information;
It functions as a database search device.
(Appendix 4)
The program described in Appendix 3,
Computer
further,
Based on the history information stored in the storage means, means for displaying the number of data extracted in each search,
It functions as a database search device.
(Appendix 5)
A program according to any one of appendices 1 to 4,
Computer
further,
Means for storing the second database in a storage means;
It functions as a database search device.
(Appendix 6)
The program according to any one of appendices 1 to 5,
Computer
further,
Means for displaying data of the second database;
It functions as a database search device.
(Appendix 7)
A batch selection means for batch-selecting items to be used for narrowing down data from all items of data arranged in each row of the first database in a tabular format;
For each item selected by the batch selection means, the value type and the number of data having each value are acquired, and for each item selected in batch, the value type and the number of data of each value are displayed. First display means;
A first designating unit for designating a value of one item from among the items in which the type of value and the number of data of each value are displayed by the first display unit;
Data extraction for searching the first database or the second database created by the following database creation means to extract data having item values designated by the first designation means or the second designation means below Means,
Database creation means for creating a tabular second database in which the data extracted by the data extraction means is stored in each row;
Of the items selected by the batch selection means of the data in the second database created by the second database creation means, the value is still set by the first designation means or the second designation means described below. Second display means for acquiring the type of value and the number of data of each value for an unspecified item not specified, and displaying the type of the value and the number of data having each value for the unspecified item;
A second designation unit for designating one item and a value of the item from among the items in which the type of value and the number of data of each value are displayed by the second display unit;
Each time an item value is designated by the second designation means, the data extraction means, the database creation means, the second display means, and the second designation means are controlled, and a series of processes by these means is performed. A control means for repeatedly executing
A database search apparatus characterized by comprising:
(Appendix 8)
Unspecified item selection means for selecting one item that has not yet been used in the data refinement search from a plurality of items of data stored in each row of the first database in the tabular format;
For the item selected by the unspecified item selection means of the data stored in the first database or the second database created by the following database creation means, the value type and the number of data of each value are obtained. First display means for displaying the value type of the item and the number of data of each value;
Designating means for designating one value from the values of the items displayed by the first display means;
Data extraction means for searching the first database or the second database created by the database creation means described below, and extracting data having the value of the item designated by the designation means;
Database creation means for creating a tabular second database in which the data extracted by the data extraction means is stored in each row;
Each time an item is selected by the unspecified item selection means, the first display means, the designation means, the database creation means, and the data extraction means are controlled, and a series of processing is repeatedly executed on these means. Control means for causing
A database search apparatus characterized by comprising:
(Appendix 9)
(A) a step of collectively selecting items to be used for narrowing down data from all items of data arranged in each row of the first database in a tabular format;
(B) For each item selected in the step (a) of the data in the first database, the type of the value and the number of data having each value are acquired, and for each item selected in a batch Displaying the type of the value and the number of data for each value;
(C) a step of designating a value of one item from each item in which the type of value and the number of data items of each value are displayed in the step (b);
(D) Search the first database or the second database created in the step (e) below, and extract data having the item value specified in the step (c) or (g) below And steps to
(E) creating a tabular second database in which the data extracted in step (d) is stored in each row;
(F) Among the items selected in the step (a) of the data in the second database, the items that have not been specified yet in the step (c) or (g) Obtaining the type of value and the number of data of each value, and displaying the type of value and the number of data having each value for the unspecified item;
(G) Specifying one item and the value of the item from the items in which the type of value and the number of data items of each value are displayed in the step (f),
(H) Each time an item value is specified in the step (g), the step of repeating the steps (d) to (g) is performed.
Search method of database having
(Appendix 10)
(A) selecting one item that has not yet been used for a data refinement search from a plurality of items of data stored in each row of the first database in a tabular format;
(B) For the item selected in the step (a) of the data stored in the first database or the second database created in the step (e) below, the value type and each value Obtaining the number of data items, and displaying the type of value of the item and the number of data items of each value;
(C) designating one value among the values of the items displayed in the step (b);
(D) searching the first database or the second database created in the step (e) below to extract data having the value of the item specified in the step (c);
(E) creating a tabular second database in which the data extracted in step (d) is stored in each row;
(F) Every time an unspecified item is selected in the step (a), a step of repeatedly executing the processes of the steps (b) to (e);
Search method of database having

1 is an overall configuration diagram of a computer system including a server to which an embodiment of the present invention is applied. It is a figure which shows the hardware constitutions of a Web server. It is a functional block diagram of an analysis support tool. It is a figure which shows the structure of a work area. It is a figure which shows an example of a search condition setting screen. It is a figure which shows the structural example of DB (database) of FIG. FIG. 7 is a diagram (part 1) illustrating a method for searching a list of desired ordered products from the order table 311 illustrated in FIG. 6; FIG. 7 is a diagram (part 2) illustrating a method for searching a list of desired ordered products from the order table 311 illustrated in FIG. 6; FIG. 7 is a diagram (No. 3) for explaining a method when a list of desired ordered products is searched from the order table 311 shown in FIG. 6; FIG. 7 is a diagram (No. 4) illustrating a method when a list of desired ordered products is searched from the order table 311 illustrated in FIG. 6. FIG. 7 is a diagram (No. 5) illustrating a method when a list of desired ordered products is searched from the order table 311 illustrated in FIG. 6. FIG. 7 is a diagram (No. 4) illustrating a method when a list of desired ordered products is searched from the order table 311 illustrated in FIG. 6. It is a flowchart which shows the process sequence of an analysis assistance tool. It is a figure which shows the table view screen which displays all the data (all records) of the order condition master table used as the data extraction object of the Example of this invention. It is a figure which shows the extraction screen of the order condition master table displayed when the order condition master table is selected from the table selection screen. It is a figure which shows the structure of the condition setting box displayed in a conditional expression setting field, when "request source code" is moved into a condition setting field by drag & drop operation from the item list field of an ordering condition master table. . The above four condition settings displayed in the condition setting field of the extraction screen by dragging and dropping the four search target items to the condition setting field from the item list field of the extraction screen in the initial display state shown in FIG. It is a figure which shows the display form of a box. In the extraction screen shown in FIG. 17, the data selection field of the condition setting box for the purchaser section code is scrolled to display the purchaser section code whose value is “68” in the condition setting box for the purchaser code. FIG. It is a figure which shows the display state of the extraction screen after clicking the extraction button after selecting the purchase charge section code whose value is "68" in the data selection field of the purchase charge section code. FIG. 20 is a diagram showing a table view screen displayed on the browser 21 when the “table view” tab is selected on the extraction screen shown in FIG. 19. FIG. 20 is a diagram showing an extraction screen displayed on the browser when the number of cases check box in the condition setting box of the purchaser code is checked in the extraction screen shown in FIG. 19. Extraction displayed when the purchaser code displayed in the first row of the data selection field in the condition setting box for the purchaser code in the extraction screen shown in FIG. 21 is selected as an extraction target and the extraction button is clicked. It is a figure which shows a screen. It is a figure which shows the table view screen displayed by selection operation of the table view tab of the extraction screen shown in FIG. FIG. 23 is a diagram for explaining an operation method for performing a narrowing search by specifying a value of an order category using a data selection field of an order category condition setting box on the extraction screen illustrated in FIG. 22. FIG. 25 is a diagram showing an extraction screen displayed when a narrowing search is performed by order classification in the extraction screen shown in FIG. 24. It is a figure which shows the table view screen displayed by clicking a table view tab in the extraction screen shown in FIG. It is a figure which shows the "direct input" area displayed when the "direct input" tab of the extraction method selection tab is clicked on the extraction screen shown in FIG. It is a figure which shows the data number etc. which were finally extracted from the order condition master table by refinement search. It is a figure which shows a part of data finally extracted from the order condition master table by refinement search.

Explanation of symbols

DESCRIPTION OF SYMBOLS 10 Web server 11 Analysis support tool 11a Browser control means 11b Browser screen creation means 11c DB search result analysis means 11d Subtable creation means 11e History information creation means 11f DB server search means 101 CPU
102 Memory 102a Program load area 102b Work area 1021b History information storage area 1022b Narrowed number storage area 1023b Sub-table storage area 1024b Browser screen display data storage area 103 Input device 104 Display device 105 External storage device 106 Network connection device 107 Bus 110 ( 110A, 100B, 110C) Collective condition extraction screen 1101 Column item name field 1102 Number display field 1103 Extraction button 2100 (2100-1 to 2100-11) Ordering condition master table extraction screen 2110 Item list field 2120 Condition setting field 2130 Condition setting Box 2131 Item name field 2132 Conditional expression setting field 2133 Display condition field 2134 Extraction method selection Tab 2135 data selection field 2136 extraction button 2200 (2200-1～2200-4) table view screen 2210 data display area 2220 narrowing-down search history display area

Claims (8)

Computer
Means A for inputting items collectively selected by a user for use in data narrowing down from all items of data arranged in each row of the first database in a tabular format;
For each item selected at once by the means A of the data in the first database, the type of value and the number of data having each value are obtained, and the value of the value for each item selected at once is acquired. Means B for displaying the type and the number of data of each value;
Means C for designating the value of one item from among the items in which the type of value and the number of data of each value are displayed by the means B;
Means D for searching the first database or the second database created by means E below, and extracting data having item values designated by means C or means G;
Means E for creating a tabular second database in which the data extracted by the means D is stored in each row;
Among the items input by the means A of the data in the second database, the type of value and the number of data of each value for an unspecified item whose value has not yet been specified by the means C or the means G below. Means F for acquiring and displaying the type of value and the number of data having each value for the unspecified item;
A means G for designating one item and the value of the item from the items in which the type of value and the number of data of each value are displayed by the means F;
Means H for repeatedly executing the means D, means E, means F and means G each time an item value is designated by the means G;
A program for causing a database to function as a database search device. Computer
Means A for selecting one item that has not yet been used in the data refinement search from a plurality of items of data stored in each row of the first database in the table format;
For the item selected in the step of the means of the data stored in the first database or the second database created by means E described below, the type of value and the number of data items of each value are acquired, Means B for displaying the value type of the item and the number of data of each value;
Means C for designating one value among the values of the items displayed by the means B;
Means D for searching the first database or the second database created by means E below to extract data having the value of the item specified by means C;
Means E for creating a tabular second database in which the data extracted by the means D is stored in each row;
Means F for repeatedly executing the means B, means C, means D and means E each time an unspecified item is selected by the means A;
A program for causing a database to function as a database search device. A program according to claim 1 or 2,
Computer
further,
Means for storing the number of data extracted in each search in the storage means as history information;
It functions as a database search device. The program according to claim 3,
Computer
further,
Based on the history information stored in the storage means, means for displaying the number of data extracted in each search,
It functions as a database search device. A program according to any one of claims 1 to 4,
Computer
further,
Means for storing the second database in a storage means;
It functions as a database search device. A program according to any one of claims 1 to 5,
Computer
further,
Means for displaying data of the second database;
It functions as a database search device. A batch selection means for batch-selecting items to be used for narrowing down data from all items of data arranged in each row of the first database in a tabular format;
For each item selected by the batch selection means, the value type and the number of data having each value are acquired, and for each item selected in batch, the value type and the number of data of each value are displayed. First display means;
A first designating unit for designating a value of one item from among the items in which the type of value and the number of data of each value are displayed by the first display unit;
Data extraction for searching the first database or the second database created by the following database creation means to extract data having item values designated by the first designation means or the second designation means below Means,
Database creation means for creating a tabular second database in which the data extracted by the data extraction means is stored in each row;
Of the items selected by the batch selection means of the data in the second database created by the second database creation means, the value is still set by the first designation means or the second designation means described below. Second display means for acquiring the type of value and the number of data of each value for an unspecified item not specified, and displaying the type of the value and the number of data having each value for the unspecified item;
A second designation unit for designating one item and a value of the item from among the items in which the type of value and the number of data of each value are displayed by the second display unit;
Each time an item value is designated by the second designation means, the data extraction means, the database creation means, the second display means, and the second designation means are controlled, and a series of processes by these means is performed. A control means for repeatedly executing
A database search apparatus characterized by comprising: (A) a step of collectively selecting items to be used for narrowing down data from all items of data arranged in each row of the first database in a tabular format;
(B) For each item selected in the step (a) of the data in the first database, the type of the value and the number of data having each value are acquired, and for each item selected in a batch Displaying the type of the value and the number of data for each value;
(C) a step of designating a value of one item from each item in which the type of value and the number of data items of each value are displayed in the step (b);
(D) Search the first database or the second database created in the step (e) below, and extract data having the item value specified in the step (c) or (g) below And steps to
(E) creating a tabular second database in which the data extracted in step (d) is stored in each row;
(F) Among the items selected in the step (a) of the data in the second database, the items that have not been specified yet in the step (c) or (g) Obtaining the type of value and the number of data of each value, and displaying the type of value and the number of data having each value for the unspecified item;
(G) Specifying one item and the value of the item from the items in which the type of value and the number of data items of each value are displayed in the step (f),
(H) Each time an item value is specified in (g), a step of repeatedly executing the steps (d) to (g);
Search method of database having