JP2006172139A - Data hierarchical display system in explorer format, database system and program - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a data hierarchical display system in an explorer format capable of easily and quickly grasping the entire retrieval result, a local state and an outline by visualizing retrieval result information extracted by retrieving a database and displaying the retrieval result information and to provide a database system and a program. <P>SOLUTION: The database system has a database 1, a control server 2 and terminals 3, the terminal 3 has a retrieval condition setting means for setting a retrieval condition of the database 1, and the control server 2 has a retrieving means for retrieving the database 1 according to the retrieval condition set by the terminal 3, and a data hierarchical display means for displaying retrieval result information obtained by retrieving the database 1 by the retrieving means hierarchically in an explorer format on a display part 3a of the terminal 3. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to an explorer-format data hierarchy display method, a database system, and a program, and more particularly, an explorer-format data hierarchy display that can visualize and display search result information extracted by database search. The present invention relates to a method, a database system, and a program.

  Due to the recent spread of computer systems due to lower prices, the emergence of highly reliable software, and the demand for more efficient social systems, various information is being put online and used. For example, in business activities, various business data such as store sales status, work-in-progress status, process and schedule progress status, product management information, and customer information are processed by a computer system. Data warehouse systems have been actively used in order to effectively utilize these various business data for other purposes such as a survey of product sales trends and customer preference analysis.

  FIG. 7 is a block diagram schematically showing a configuration of a general data warehouse system. As shown in FIG. 7, a general data warehouse includes a database 50 that stores and stores data, a server 51 that manages the database 50, and a client 52. The client 52 processes the server 51. The server 51 is configured to receive information obtained by searching / extracting the database 50 by the server 51. The server 51 and the client 52 are connected via a network 53 such as the Internet.

  FIG. 8 is an explanatory diagram for explaining a display example of data acquired by a conventional data warehouse. As the data display, for example, a list such as a one-dimensional table (see FIG. 8A) or a two-dimensional table combining the one-dimensional tables (see FIG. 8B) is used (hereinafter referred to as conventional). Example 1).

  Japanese Patent Laid-Open No. 10-283235 discloses a screen corresponding to a user's operation on an explorer screen showing a hierarchical structure of a database when a database of a server arranged on a network (Web) is referred to by a plurality of clients. Has been proposed (hereinafter, referred to as Conventional Example 2).

Japanese Patent Laid-Open No. 10-283235

  In Conventional Example 1, the search result information extracted by searching the database is simply listed for each item, and it is difficult to instantly grasp the entire search result and the local situation and summary. There is.

In addition, when developing a conventional information system, the data display screen (expression) must be created individually by craftsmen,
1) Advanced visual representation of data (information) is difficult,
2) Takes time and cost,
3) Data display screens (representations) are different and there is no uniformity.
4) User operations are different, and there is no standardity.
There are issues such as.

  In Conventional Example 2, the files in the database are simply drawn in an explorer-type hierarchical structure and displayed as they are on the display unit of the client. As in the present invention, the files dynamically change for each database search result. There is no disclosure about the displayed points, and there is no indication that suggests that.

  The present invention has been made in order to solve the above-mentioned problems, and the search result information extracted by searching the database is visualized (visualized) in an explorer format to display the entire search result and local information. An object of the present invention is to provide an explorer-type data hierarchy display method, database system, and program capable of easily and quickly grasping the situation and outline.

  The explorer format data hierarchy display method of the present invention comprises a search means for searching a database, and a data hierarchy display means for hierarchically displaying the search result information searched for the database by the search means on the display section in the explorer format. It is characterized by having.

  You may further have the detailed data display means to display each detailed data information corresponding to the said search result information on the said display part.

  You may further have a hierarchy structure setting / change means for setting / changing the hierarchy structure displayed by the data hierarchy display means.

  The database system of the present invention includes a database for storing and storing data, a control server for controlling and managing the database, and a terminal having a display unit, and the control server and the terminal are connected via a network. In the database system, the terminal has search condition setting means for setting a search condition for the database, and the control server includes search means for searching the database according to the search condition set by the terminal, Data hierarchy display means for displaying the search result information searched for the database by the search means in a hierarchical manner on the display unit of the terminal in an explorer format.

  The terminal may further include hierarchical structure setting / changing means for setting / changing a hierarchical structure displayed by the data hierarchy display means.

  The program of the present invention is characterized by causing a computer to execute a process of searching a database and a process of displaying search result information obtained by searching the database hierarchically on a display unit in an explorer format.

According to the present invention, it is possible to realize visualization (visualization) of data by displaying the search result information arbitrarily extracted by searching the database in a hierarchical manner in a standard (uniformly) explorer format, The entire search result and the local situation and summary are easy to understand, and can be easily and quickly grasped. In addition, you can process and edit the data that is arbitrarily searched and extracted,
As a result, the development efficiency of the information system can be greatly improved, the cost can be greatly reduced (about 2/3), and standard production of the information system becomes possible. In addition, user operations are also standardized (uniformized).

  Also, in the present invention, unlike the conventional example 2, the explorer-format data hierarchical structure is dynamically changed and displayed for each search result of the database, so that the overall and local status and outline are grasped for each search result. be able to.

  Hereinafter, embodiments of the present invention will be described with reference to the drawings. FIG. 1 is a block diagram for explaining the configuration of the first exemplary embodiment of the present invention.

  As shown in FIG. 1, a database system using the explorer-type data hierarchy display system of the present invention (this technique is called “Date Explorer”) includes a database 1 for storing and storing data, A control server 2 that controls and manages the database 1 and a terminal (client) 3 including a display unit 3 a such as a monitor are connected. The control server 2 and the terminal 3 are connected via a network 4.

  As the database 1 and the control server 2, an information processing apparatus such as a workstation server is used.

  In response to a request from the terminal 3, the control server 2 has a connection layer 2a for connecting to the target database 1, and logic for storing all control and setting logic related to dataized business logic and various services. A layer 2b, and a presentation layer 2c that converts and generates data acquired from the database 1 based on control (setting) data acquired from the logic layer 2b and transmits the data to the requested terminal 3.

  In the connection layer 2a of the control server 2, the connection information to the target database 1 is recorded and stored. In the logic layer 2b, it becomes easy to develop a new system or change specifications / operations by converting the data into logic, and the maintenance can be performed only by changing the data (property) with no programming.

  The control server 2 includes search means for searching the database 1, and data hierarchy display means for displaying the search result information searched for the database 1 by the search means in a hierarchical manner on the display unit 3a in an explorer format.

  The terminal 3 is an information processing device such as a personal computer, a television, a portable terminal, and a mobile phone having a communication network connection function, for example, an input device such as a keyboard and a mouse, an output device such as a display and a printer, and the network 4. Via a communication device for transmitting and receiving information. The terminal 3 may belong to another communication network such as a LAN (Local Area Network).

  The terminal 3 includes search condition setting means for setting search conditions of the database 1 and hierarchical structure setting / changing means for setting / changing the hierarchical structure displayed by the data hierarchy display means of the control server 2.

The network 4 is, for example, the Internet (TCP / IP (Transmission Control
Protocol / Internet Protocol).

  FIG. 2 is a flowchart for explaining the operation of the first exemplary embodiment of the present invention.

  First, as advance preparation (step S1), the relevant information of the database 1 is registered in the control server 2 so that the target database 1 can be used with a simple operation (for example, one click), and the connection from the terminal 3 is performed. • Make access possible.

  Specifically, the database 1 uses a local table or, if necessary, the link server function of the database 1 to join tables of different databases 1 to create a view as a data source. Keep it. Further, various information of the target database 1 (for example, the IP address, physical name, login user ID, password, data source name, item name, etc. of the database 1) is registered in the connection layer 2a of the control server 2. Furthermore, necessary setting data such as default values and security for each user is input and set in the logic layer 2b of the control server 2.

  When this pre-preparation is completed, the user can receive the database service simply by clicking the menu (hyperlink) displayed on the display unit 3a of the terminal 3 with a mouse or the like.

  When the user uses the database 1, the user accesses the site of the control server 2 through the network 4 from the terminal 3. At that time, input of an ID such as a member number and a handle name and a password is requested (step S2).

  Next, the control server 2 performs authentication based on the ID and password input by the terminal 3 (step S3), and if permitted, continues to the next step.

  Next, the search condition of the database 1 is set by the terminal 3 (step S4), and a search request is transmitted to the control server 2 (step S5).

  Next, the control server 2 receives the search request from the terminal 3 (step S6), and searches the database 1 according to the search condition of the search request (step S7).

  Next, the control server 2 converts and creates the search result information so that it can be hierarchically displayed on the display unit 3a of the terminal 3 in the explorer format (step S8), and transmits it to the terminal 3 (step S9). .

  Next, the terminal 3 receives the search result information from the control server 2 (step S10) and displays it on the display unit 3a (step S11).

  3-5 is explanatory drawing for demonstrating an example of the screen displayed on the display part 3a of the terminal 3. FIG.

  As shown in FIG. 3, on the display unit 3a of the terminal 3, the first frame 5 displayed for setting the search condition of the database 1 and the search result information of the database 1 are hierarchically displayed in an explorer format. A second frame 6; a third frame 7 for displaying individual detailed data information corresponding to the search result information; and a fourth frame 8 for setting a hierarchical structure displayed by the second frame 6. And are displayed separately.

  In the first frame 5, search conditions for the user to search and extract data are set. Search patterns that are frequently used may be registered and searched. Further, when displaying the search results hierarchically, the tree display is selected, and when displaying the search results in a list format, the list display is selected.

  In the second frame 6, search results are grouped for each arbitrarily set item and displayed in a tree hierarchy in an explorer format. This explorer format data hierarchical structure is dynamically changed and displayed for each database search result. For each item in each layer, the number of hits corresponding to the search is displayed. Further, by clicking each item or icon, detailed information is displayed in the third frame 7.

  For example, “36/1194” may be displayed for each item in each layer (where 36 indicates the number of search hits for each item, and 1194 is set in the “aggregation item” of the fourth frame 8. (For example, sales amount, inventory quantity, etc.) By this, it is possible to grasp how much data corresponding to the items of each layer is present.

  In the third frame 7, detailed information (including visualized information) linked to the second frame 6 is displayed. In the example of FIG. 3, when the icon 6 a is clicked to select “model XYZ” in the second frame 6, shipping information regarding “model XYZ” is displayed in the third frame 7.

  In the fourth frame 8, items and display settings of each hierarchy of the tree can be appropriately set or changed. By changing the setting of each hierarchy as appropriate, the hierarchical structure and display method of the tree of the second frame 6 are changed.

  FIG. 4 is an explanatory diagram showing an example in which work progress data is retrieved and extracted and displayed. FIG. 4A is an example in which search result information of work progress status is hierarchically displayed in an explorer format, and the total value (number of search hits) of items in each layer is displayed. Further, by clicking each item or icon, detailed information is displayed in the third frame 7.

  FIG. 4B is an example in which detailed data information corresponding to the search result information in FIG. For example, by clicking on the number portion of the request slip number, more detailed data can be displayed. FIG. 4C is an example in which the progress status of a work process or a schedule (schedule) is visualized.

  FIG. 5 is an explanatory diagram showing an example in which an in-process status is displayed as an alarm as information visualization. The screen in FIG. 5 is displayed by selecting the alarm button 9 in FIG. By this display, for example, data such as one day before the scheduled shipping date, immediately before the bottom of the inventory can be extracted, and the user can be alerted. Clicking on the number portion allows more detailed data to be displayed, and allows processing such as data input and correction.

  Furthermore, the database system of the present invention may have the following functions.

  (1) A function capable of referring to related history data and data of different databases.

  (2) A function of uploading and displaying related document data and image data in association with the management number (key).

  (3) Function to edit / edit data arbitrarily searched / extracted. With this function, information in the database 1 can be easily changed, deleted, added, etc., and the information in the database 1 can be appropriately reflected in the latest information.

  (4) Arbitrary search / extraction by all items or any combination thereof, all items or any combination thereof under the conditions specified in “Extraction condition designation (eg designation by“ customer name ”)” A function that can output a list, a one-dimensional table, a two-dimensional table, and a situation / contrast table. In addition, you may enable the self-made by the user of a routine work.

  (5) A function that allows detailed security (restriction, permission, filter) settings for each group or user for data editing, reference, and display.

(6) A function that can be performed by no programming such as logic data conversion. This function facilitates operations, system specifications, operation changes, and maintenance, and allows a large number of excellent business management systems to be built easily in a low cost, low skill, and short term.

  (7) A function for establishing a community between other departments (other companies) by linking with the mail function (for example, associating the number of work in progress with a reminder by mail).

  FIG. 6 is a block diagram for explaining the configuration of the second exemplary embodiment of the present invention. The second embodiment of the present invention relates to a program 10 that causes a computer to execute the processing of the control server 2 according to the first embodiment described above. The program 10 may be recorded on a recording medium such as a magnetic disk such as an FD, an optical disk such as a CD-ROM, a semiconductor memory, or may be downloaded via a communication network.

  The present invention is not limited to the above-described embodiments, and various modifications can be made within the scope of the technical matters described in the claims. For example, the screen displayed on the display unit 3a of the terminal 3 is an example, and the present invention is not limited to this.

  The present invention visualizes management and analysis of, for example, sales status of products and services, status of work in progress, shipping status, progress status of processes and schedules, product management information, customer information, company organization information, management status, etc. (Visualization) can be performed efficiently at low cost, and can be applied not only to large companies but also to business management systems and business management systems of small and medium-sized companies.

It is a block diagram for demonstrating the structure of the 1st Example of this invention.

It is a flowchart for demonstrating the operation | movement of the 1st Example of this invention.

It is explanatory drawing for demonstrating an example of the screen displayed on the display part of a terminal.

(A)-(C) are explanatory drawings for demonstrating an example of the screen displayed on the display part of a terminal.

It is explanatory drawing for demonstrating an example of the screen displayed on the display part of a terminal.

It is a block diagram for demonstrating the structure of the 2nd Example of this invention.

1 is a block diagram schematically showing a configuration of a general data warehouse system.

(A) And (B) is explanatory drawing for demonstrating the example of a display of the data acquired by the conventional data warehouse.

Explanation of symbols

1: Database 2: Control server 3: Terminal 4: Network 5: First frame 6: Second frame 7: Third frame 8: Fourth frame 9: Alarm button 10: Program

Claims (6)

A search means for searching the database;
Data hierarchy display means for displaying search result information obtained by searching the database by the search means in a hierarchical manner on the display unit in an explorer format;
An explorer-type data hierarchy display system characterized by comprising:   The explorer-type data hierarchy display method according to claim 1, further comprising detailed data display means for displaying individual detailed data information corresponding to the search result information on the display unit.   3. The explorer-type data hierarchy display system according to claim 1, further comprising hierarchical structure setting change means for setting / changing a hierarchical structure displayed by the data hierarchy display means. In a database system having a database for storing and storing data, a control server for controlling and managing the database, and a terminal having a display unit, and the control server and the terminal are connected via a network,
The terminal has a search condition setting means for setting a search condition for a database,
The control server displays search means for searching the database according to a search condition set by the terminal, and search result information searched for the database by the search means in a hierarchical manner on the display unit of the terminal in an explorer format. Data hierarchy display means,
A database system characterized by that.   5. The database system according to claim 4, wherein the terminal further includes hierarchical structure setting change means for setting / changing a hierarchical structure displayed by the data hierarchy display means. The process of searching the database;
Processing for displaying the search result information obtained by searching the database in a hierarchical manner in an explorer format;
A program that causes a computer to execute.

Images