JPH02234272A - Data base retrieving system - Google Patents

Abstract

PURPOSE:To allow a user to more easily designate the retrieve condition of a data base by defining the structure of an repeating item, and designating the retrieve condition based on defined structure information. CONSTITUTION:A data base management system (DBMS) consisting of an instruction issuing part 102, an instruction interpreting part 103, a structure defining part 104, a structure information part 105, a condition designating part 106, a condition deciding part 107, and a data display part 108, and a data base 109 to be a retrieve object are possessed. Further the structure information of the repeating item of the data base 109 can be defined, and the retrieve condition can be designated based on the structure information. Thus the user can easily designate the retrieve condition corresponding to the structure of the data base 109.

Description

DETAILED DESCRIPTION OF THE INVENTION [Field of Industrial Application] The present invention relates to a database search system for searching a database using repeated items in a relational DBMS. [Prior Art] In the relational DBMS RDBI, it is possible to express a data structure using repeated items in which one item has multiple values. In RDBI, the value of a repeated item can be expressed using an array. When searching for repeated items, conditions are specified in the following format. (1) Repeated item with array subscript (2) Specify ANY as the subscript of (1) (3) Repeated item without array specification In the format of (2) above, even one arbitrary request satisfies the condition. If so, the conditional expression is true. Further, format (3) is used only for null value search.

As mentioned above, when searching for a repeated item, the conditional expression for the relevant repeated item is valid only for that item.For example, the format of the condition specification for a search that matches array subscripts between repeated items, etc. , was not provided.

[Problem to be solved by the invention]

The above-mentioned conventional technology involves mapping (structuring) values between multiple repeated items in a database using repeated items.
In addition, there was no format for specifying conditions for searches that matched array subscripts between repeated items.

The present invention enables users to
The purpose is to be able to easily specify search conditions that correspond to the structure of the database.

[Means to solve the problem]

In order to achieve the above object, the database search system of the present invention includes, in a relational DBMS, means for displaying information on each item of a target relational database and allowing a user to specify structural information between repeated items; means for storing structural information between repeating items in a database specified by the user, and displaying a screen that allows the user to specify search conditions for the database using the structural information between repeating items when the user searches the database. and means to obtain the search conditions specified by the user, interpret the search conditions specified by the user,
A means for determining a condition of a database record based on structural information between repeated items, and a means for outputting data that matches the condition in the above condition determination are provided.

[Effect]

When a user defines the structure of repeated items, the system displays information about each item in the database and displays a screen for the user to define the structural information. After the user defines the structure information, the system stores it as structure information in the corresponding database. When a user searches a database, the system uses structural information between repeated items to display a screen that allows the user to specify search conditions for the database. When a user specifies a search condition, the system judges the condition of records in the database based on the structure information between repeated items and outputs data that meets the condition.

As a result, the user can structure the repeated items in the database, and when searching the database, specify search conditions through a screen for setting search conditions using the structural information.

〔Example〕

An embodiment of the present invention will be described below with reference to the drawings. FIG. 1 is a block diagram of a system that implements the database search system of the present invention. In the figure, 101 is a data management system (DBMS), 102 is an instruction issuing unit that issues instructions specified by the user, 103 is an instruction interpretation unit, and 104 is an ellipse between repeated items in the database. A structure definition section 105 that defines a structure is a structure information section 106 that stores elliptic structure information between return items defined by the user.
107 is a condition specification section that allows the user to specify search conditions based on structural information between scales; 107 interprets the search conditions specified by the user, searches the database accordingly, and specifies the conditions. A condition determining section 108 is a data display section displaying data matching the conditions, and 109 is a database to be searched. Figure 2 is a diagram showing the configuration of the database to be searched. This database consists of six items: "Bank", "r category", "r year", "deposits J, r loans", and "customer". A single item with the value ``r year'', ``deposits'', ``loans'', ``
The "Customer" item is a repeating item that has multiple values in one record. FIG. 3 is a structure definition screen for defining the structure between return items in the database. In the figure, 301 is a structure definition screen, 302 is a single item display area, and 303 is a repeated item display area. Item 1 to be structured around the repetition of 303
Now let's define the name of the structure. Figure 4 is a block diagram when defining the structure of repeated items in the database. 401 is a structure definition section that defines the structure of a repeating item; 402 is a structure information section that stores structure information of the defined repeating item; 403 is item information obtained from the database; 404 is a structure of the repeating item defined by the user. Information 405 is a database.

Figure 5 is a processing flow diagram when defining the structure of repeated items in a database. First, the user issues a database structure definition command and specifies the target database (501). The system interprets the order (511) and obtains the database item information to be defined (512). Using this item information, a screen for defining the structure between repeated items in the database is generated and displayed (5 1 3). next,
The user defines structural information between repeated items on the structure definition screen (502). The system acquires the specified structure information (514) and stores the information as structure information between repeated items in the corresponding database (51).
5). Figure 6 is a diagram showing the structure of a database in which repeated items are structured. In the 2nd database failure, year r'',
Each repeating item of "Deposits j" and "Loans" is changed to "Statistical information".
It is structured as follows. Figure 7 shows a condition specification screen for specifying search conditions based on the structure information of repeated items. In the figure, 701 is a condition specification screen, 702 is a single item display area, 703 is a structured repeated item display area, and 704 is an unstructured repeated item display area. FIG. 8 is a block diagram of this system for determining database search conditions. In the figure, 801 is a data display section that displays data that matches the conditions, 802 is a condition judgment section that searches the database and judges the conditions, 803 is a condition judgment section regarding a single item of a record, and 804 is a condition judgment section that searches the database and judges the conditions. ,
Condition determination unit for data (structured data) for each element number in a structured repeated item in a record, 80
5 is a database. FIG. 9 is a processing flow diagram of the system for determining search conditions. First, one record is imported from a set of target records (901). If there is a record, (9 0
3) Perform the following processing, and if there is nothing, end the processing (
902). Conditional judgment is performed on the structured repeated item data (structured data) in the corresponding record (9
03). As a result of the condition judgment, if the condition is met, (9
0 5) Do the following, and if it does not match, (9 0
5) Do the following, and if they do not match (906) do the following (904). In (905), structured data that meets the conditions is output. In (906), the presence or absence of structured data is determined, and if there is data, the process returns to (903).
If there is no data, return to (901). FIG. 10 is a processing flow diagram when searching a database. First, the user issues a database search command and points to the target database (1001). The system interprets the command (1011). Obtain elliptical information between repeated items in the database to be searched (1012)
．． Using this structure information, a condition specification screen is generated and displayed (1 0 1 3). Next, the user specifies search conditions on the condition specification screen (1002). The system obtains the specified search conditions (1014). Obtain records from the database and make conditional judgments (1 0
1 5). Output processing is performed for data that meet the conditions (1016). According to this embodiment, it is possible to define structural information of repeated items in a database, and search conditions can be specified based on the structural information, so it is possible to specify database search conditions more easily. [Effects of the Invention] According to the present invention, a user can define the structure of repeated items and specify search conditions based on the defined structure information, making it easier to set search conditions for a database. It is possible to specify.

[Brief explanation of the drawing]

FIG. 1 is a block diagram showing the functional configuration of a database search system according to an embodiment of the present invention, FIG. 2 is a configuration diagram of a database to be searched, and FIG. 3 shows the structure of repeated items. A display diagram of the structure definition screen to be defined, FIG. 4 is a functional block diagram of the system of the embodiment when defining the structure of a repeating item, FIG. 5 is a processing flow diagram when defining the structure of a repeating item, Figure 6 is a configuration diagram of a structured database, Figure 7 is a display diagram of a condition specification screen for specifying purple testing conditions, and Figure 8 is a functional block diagram of an example system for determining search conditions. , FIG. 9 is a processing flow diagram for determining search conditions, and FIG. 10 is a processing flow diagram for searching a database.
: Zo'9 (tl! 107+01 now out of production)
IOs Koshiichi〕Toho Iku +0303 Now 4 Kaibuna 1
06 Article Shiruashi Katsukuni 1e To II 1 E middle denime display J1 Teichikube one person 2 Tsumekuchu 1 hanging old shimatate A Fukocha b Zuyo Ichiken 9■, Shu7 Masabe υ place L Shizuzu t0 dansashi m4 system

Claims (1)

[Claims] 1. In a relational DBMS, information on each item of a target relational database is displayed, and the user is asked to associate values between a plurality of repeated items (
(1) a means for specifying structural information (called structuring); (2) a means for storing structural information between repeated items in a database specified by a user; and (2) a means for storing structural information between repeated items in a database specified by a user; displaying a screen that allows the user to specify search conditions for the database, providing a means for obtaining the search conditions specified by the user, and interpreting the search conditions specified by the user;
A database retrieval system comprising: means for determining a condition for records in a database based on structural information between repeated items; and means for outputting data matching the condition in the condition determination. 2. In the database search system according to claim 1, a database search method characterized in that when a user searches, item information of the database to be searched is acquired and structuring is performed between repeated items. . 3. In the database search system according to claim 1, using structural information between repeated items in the database,
A database search method characterized in that a screen for specifying database search conditions is displayed, conditions are judged for records in the database based on the search conditions specified by the user, and data matching the conditions is output.