JP2006164127A - Data retrieval system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To provide a data retrieval system, which allows users to interactively and easily customize desired formats from each of predefined schemas (reference items), and can store and manage configuration information within a database for every user. <P>SOLUTION: An information processing apparatus stores data in a database and displays the stored data using an input/output interface. The retrieval requirement input interface has a management means, which is provided with a display function for each schema information and contents information stored in the database, a contents display and selection function and a display function for information related to an option input interface. The information processing apparatus has a creation part for a database access language SQL based on specified retrieval requirements and a database part, which stores and manages data, and includes a group of data tables stored with each schema contents information data. <P>COPYRIGHT: (C)2006,JPO&NCIPI

Description

  The present invention relates to a data search system for searching a relational database type database.

  Conventionally, in a data search system using a database, in order to realize a search in a desired format while the management items and data desired by the user have changed, the interface application has to be modified and changed. . In such a background, there is a method of providing an interface that can be customized by a user and generates a search expression in a desired format, such as the “database device” disclosed in Patent Document 1. The data items to be selected by the user did not present information that can be determined as to which input interface was used for input. Therefore, when performing user customization, the decision to select as a search item can only be inferred from the name of the item, or the system administrator or database administrator can be queried or determined based on the material. However, since it is impossible to accurately determine from which input interface the desired data has been input, it has been impossible to realize an efficient customized search by the user.

JP-A-8-241337

  The present invention solves the above-mentioned problems, and a user can customize a desired format interactively and easily from each pre-defined schema (reference item). An object of the present invention is to provide a data search system capable of holding and managing information in a database for each user. At this time, the input interface through which the object is input at the time of setting the search item can be presented as related information, and the efficiency of user customization in the data search for the database is improved.

  The present invention relates to an information processing apparatus that accumulates data in a database and displays the accumulated data using an input / output interface. The search condition input interface includes a schema information and content information display function on the database, and a content display. In a database unit that has a management function having a selection function and a function for displaying information related to an input interface of a selection target item, has a database access language SQL creation unit based on a designated search condition, and stores and manages data It includes a data table group for holding each schema content information data.

  According to the present invention, it is possible to customize a database search interface in a format desired by a user, and further, a user can select a registered screen information from a menu display section list and use a search screen. In addition, it is possible to share the setting information among users. When selecting a search item when implementing the above customization function, it is possible to display related information from which input interface the target item is input, and the user can select the search item arbitrarily A typical data search system can be provided.

  Embodiments of the present invention will be described below with reference to the accompanying drawings.

  FIG. 1 is a diagram showing a configuration of an information processing apparatus according to an embodiment of the present invention.

  The display unit 1 displays a plurality of windows on the display screen, and the displayed window has an area for displaying search data and the like. The input unit 2 is a device such as a keyboard for inputting information data such as search information. The mouse 3 is a device that instructs buttons and items displayed on the display unit 1.

  The application program 4, for example, as in the order management system, procurement information such as the number of man-hours such as the status of each construction and the results (man-hours, amount) for each worker, the results of arrangement of materials and parts (ordering party, inspection amount), This is an interface for the user to display aggregate values such as monthly reports and daily reports from a database in which financial information is centrally managed, and is a program for setting search conditions and displaying search result data.

  The input / output interface 5 is a processing unit that has an input field on the display screen and transfers input data such as search period information transferred from the input unit 2 to the data control unit 6. The input / output interface 5 is searched based on a menu unit 51 that displays the set screen information as a screen selection menu, a screen setting editing unit 52 that easily realizes settings for each user in an interactive format, and input search conditions. A search screen unit 53 for displaying search data and an input unit related information management unit 54 for managing related information at the time of input of a selection target item are included.

  The menu unit 51 includes a screen information display unit 511 that displays screen information set for each user in a list format and helps the user select an information setting screen together with a remark display.

  The screen setting editing unit 52 registers a schema information display unit 521 that displays a list of target items for realizing the setting for screen information in an interactive format and the setting information selected in the interactive format in the database unit 8. And the setting information sharing function unit 523 that allows the screen information set for each user to be reused between application users.

  The search screen unit 53 is a functional unit for displaying extracted data and outputting a file based on a search condition input via the input / output interface 5 with respect to a financial data aggregate value or the like desired by the user. And a search information setting unit 532 as an interface for setting search conditions.

  The input unit related information management unit 54 includes a related information screen unit 541 that performs management such as display / registration of input unit related information for a target item set by the user.

  The database inquiry function unit 7 creates a database search request language SQL based on input information such as search conditions passed from the input unit 2 via the input / output interface 5, and performs a data search process on the database unit 8. A processing unit that requests creation processing and update processing. The data control unit 6 processes the data passed through the database inquiry function unit 7 into a designated display format.

  The database unit 8 accumulates data collected from each device. Further, target data is extracted from the accumulated data based on the search request delivered via the database inquiry function unit 7. The database unit 8 includes a screen setting information report table group 81, a data table group 82, and an input unit related management table group 83.

  The screen setting information table group 81 is a table composed of screen setting information for each schema of accumulated data. The data table group 82 is a table group for managing data stored by the data input application program 9. The input unit related management table group 83 is a table group for managing interface related information at the time of input of search target items.

The information processing device is a general information processing device (ROM
The hardware configuration of a CPU, a RAM, a storage device such as a hard disk drive) that executes each process based on the program read from the program.

  FIG. 2 is a search screen on the data reference system used as an example of the present invention.

  Table items and column items constituting the database query language SQL are displayed in the condition setting unit and the result display unit. The search condition can arbitrarily set an operator and a comparison value in the search information setting unit. Further, when a “search” button is instructed, a search event occurs, SQL is dynamically generated according to each specified condition (display item, search condition, etc.), and the database inquiry function unit 7 via the data control unit 6. Performs a data search process on the data table group 82 in the database unit 8 and displays the search result on the screen in the result display area by the search data display unit.

  FIG. 3 is a diagram showing a screen setting editing unit for editing the screen setting information constituting FIG. 2 (search screen unit).

  It has a reference item setting unit for setting reference items constituting a result display area to be searched, and a search item setting unit for setting search condition items constituting a condition setting unit. A selection candidate is instructed from the selection list display section at the left end. The selection list display section includes a display area for the target column in the database, a display area for items that are publicly registered in advance, and a display area for items that are publicly registered for each user. The “add” and “delete” buttons are instructed from the item group listed as the selection candidates, and the target item is selected as the selection item. By instructing the “Register” button, the selection items are accumulated for each user and each screen via the data control unit 6 in the screen setting information table group 81 included in the database unit 8.

  FIG. 4 is a diagram showing a table configuration of the screen setting information table group 81 included in the database unit 8.

  The search condition target and the search display target item that are managed in advance are stored and managed as management data for each column on the management table. The items (display setting, search condition setting) selected by the screen setting editing unit in FIG. 3 are accumulated and managed for each user and for each setting screen. In addition, for each item, a determination flag as to whether or not to be a totaling target is held.

  FIG. 5 is a diagram showing a related information screen unit 541 included in the input unit related information management unit 54. For the selection target item of the screen setting, the input interface related information registered by selecting the target is displayed. In addition, it is possible to register input interface related information for a target selection item.

  FIG. 6 is a diagram showing a table configuration of the input unit related management table group 83 included in the database unit 8. The input interface related information is managed for each screen setting selection target data. Data to be managed includes link information to related information files (document files, image files, etc.) and text information as remarks.

  FIG. 7 is a view showing a menu screen for displaying the screen setting information registered in FIG. 3 in a list format. As the display contents, public registration data to be disclosed to all users and registration data for each login user to the application are displayed. The user can display / use the search screen section based on the screen setting information by instructing and selecting data displayed in the list format.

It is a block diagram which shows the basic composition of this invention. It is a figure which shows the search result display screen in embodiment of this invention. It is a figure which shows the screen setting information edit screen in embodiment of this invention. It is a figure which shows the table data of the screen setting information in embodiment of this invention. It is a figure which shows the related information screen part in embodiment of this invention. It is a figure which shows the input part related management table data in embodiment of this invention. It is a figure which shows the menu display screen of the setting screen information in embodiment of this invention.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Display part 2 Input part 3 Mouse 4 Application program 5 Input / output interface 51 Input / output interface 511 Screen information display part 52 Screen setting edit part 521 Schema information display part 522 Screen information setting part 523 Setting information sharing function part 53 Search screen part 531 Search data display section 532 Search information setting section 54 Input section related information management section 541 Related information screen section 55 Search screen creation section 6 Data control section 7 Database inquiry function section 8 Database section 81 Screen setting information table group 82 Data table group 83 Input Department related management table group 9 Data input application

Claims (3)

In a data search system with a data input / output interface,
A data search system characterized by managing a data input interface and related information of data.   Generation means for generating a search expression for searching a database, management means for managing related information of the input interface of the selection target data item in the generation means, and registration for registering a plurality of search expressions for searching the database And a selection means for selecting one search expression from a plurality of search expressions registered by the registration means, and an execution means for executing the search expression selected by the selection means. Data retrieval system.   1 comprising a generation means for generating a plurality of search expressions for searching a database, a management means for managing related information of the input interface of the selection target data item in the generation means, and a plurality of search conditions for searching the database. A registration unit for registering a plurality of sets of search condition groups, a selection unit for selecting one search condition group from a plurality of search condition groups registered by the registration unit, and a search expression selected by the selection unit And a data retrieval system comprising:

Images