JP2003288355A - Database system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To enable even a beginner to extremely easily use a database, easily read and display data retrieved before at any time without storing the data as an existence table, and perform the optimum classification, arrangement and analysis of the database at every time. <P>SOLUTION: Retrieval objects 8 with optional retrieval condition 8J for a data record R<SB>n</SB>and retrieval icon 8S that is a retrieval processing execution switch set therein are set in the lower layer of a data object 7 with a database 4 stored therein. The retrieval icons 8S are hierarchically tree-displayed below an icon 7S corresponding to the data object 7. When an optional retrieval object 8 is selected by the retrieval icon 8S, and a retrieval processing is executed, the data record R<SB>n</SB>matched to its retrieval condition is extracted every time to form a visual point table. <P>COPYRIGHT: (C)2004,JPO

Description

Detailed Description of the Invention

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention is a table format in which a target data record is extracted from a database in which a large number of data records are stored as an actual table under arbitrary search conditions set in advance and is virtually displayed on a display. Database system.

[0002]

2. Description of the Related Art Generally, when searching for target data in a tabular database system, a standard database language, SQL, is used to set search conditions. This SQL is an interactive language. For example, if you want to extract data from the table A under the condition B, use the syntax "SELECT *""FROM" A """WHEREB". If the computer is made to perform data processing, from the data record recorded in the table "A" specified by the FROM statement,
S data that matches the condition B specified in the WHERE statement
ELECT can be performed.

This WHERE statement is a retrieval conditional expression. For example, for a Salt Lake Winter Olympics speed skating winner, a data record having fields of competition name, gender, player name, country name, record, ranking, and remarks is used as a real table. 500m for speed skating and 1 for women
When extracting a 000-meter medalist or a Japanese prizewinner, the WHERE statement needs to establish the following conditional expression. "WHERE (" Competition name "=" Speed skating 500m 'AND "Gender" = "Men's") OR ("Competition name" = "Speed skating 1000m" AND "Gender" = "Women's)") AND (("Ranking "= <3) OR
(“Country name” = “Japan”)) ”Then, if a computer is made to perform data processing according to this search condition, a desired data record is extracted.

[0004]

By the way, this SQL
Belongs to a relatively easy-to-understand category in computer languages, but nevertheless, when performing the above-mentioned search, not only the AND condition and the OR condition are used as the search WHERE condition, but also the priority is set. Complex conditional expressions must be created using multiple () shown. Therefore, there is a problem that it is extremely difficult to use the database if the user is not skilled in SQL.

That is, even those who know SQL
What is going to be searched from the above-mentioned WHERE statement cannot be read in an instant, let alone for those who do not know SQL, and it is not possible to set the search condition expression by themselves.

Further, when the viewpoint table created by once searching is used later, the same search condition expression is WHE.
Although it is sufficient to enter in the RE sentence, since the WHERE sentence has to be entered as characters, not only is it troublesome to enter, but there are often typos and mistakes in full-width alphanumeric characters. It may happen that the searched data record cannot be searched accurately again.

[0007] Therefore, normally, this viewpoint table is made to be an existing table and newly saved, and by doing so, it is possible to reliably display the previous search results many times. However, since the same data record must be stored redundantly, a problem that a huge memory capacity is required arises. Further, in the case where the sales data is input to the database every moment and the contents are updated like the POS system, the change of the data is not reflected in the newly stored actual table.

[0008] On the other hand, there is also a method of pre-classifying each data record into hierarchically displayed folders to construct a database (see Japanese Patent Laid-Open No. 2000-250798). If this is applied to, for example, the database of the above-mentioned Salt Lake Winter Olympics Speed Skating Winners, for example, "Competition Name Folder"-"Gender Folder" is created from the upper rank, and the "ranking folder" which is the lowest rank Build a database by storing name, country and record data. In this case, each folder is displayed in a hierarchy, so you can select the competition name, then the gender, and specify the ranking. You can search for data such as name and country.

However, in this example, "competition name"-
Since the data can be searched only by a single method of specifying "gender"-"rank" in this order, there is a problem that the search purpose is limited to one. For example,
If you want to list the names of the prize-winner countries, or want to search for the prize-winners by country, or if you have to search by a procedure other than the search procedure that is set for who is the Japanese prize-winner, you will be unable to search. Therefore, the degree of freedom as a database is limited, and when performing such a search, a new database must be rebuilt.

Therefore, the present invention can be used very easily even by a person who is new to a database, and desired desired data can be freely and easily extracted from a huge amount of data without any specialized knowledge such as SQL. (Search), and previously retrieved data can be easily retrieved and displayed at any time without storing it as a real table, which in turn asks whether data is frequently updated or not. Instead, it is a technical issue to be able to perform optimal classification, organization and analysis of the database each time.

[0011]

In order to solve this problem, the invention according to claim 1 uses a database in which a large number of data records are stored in a physical storage device as a real table, by using a preset search condition of 1 In the database system that extracts the above data records and virtually displays them as a viewpoint table on the display, in the lower layer of the data object that extracts all the data of the existing table, the search condition of the data record and the icon that becomes the search processing execution switch Is set, and the icon of the search object is hierarchically displayed as a tree below the icon corresponding to the data object, and any one search object is selected to execute the search process. At this time, if there is no other search object in the direct upper rank, When another search object exists in the direct higher order with the search condition set in the search object, a new search condition is created by combining the individual search conditions with an AND condition, and a data record that matches the search condition is created. It is characterized in that it is provided with a viewpoint table creation / display means for extracting a viewpoint table each time and creating a viewpoint table.

According to the invention of claim 1, the icon of the search object for which the search condition of the data record is set is
Since it is hierarchically displayed in a tree structure, you can see at a glance what you are trying to search for by just looking at the hierarchically displayed icons.

In addition, the search object is set with a desired search condition, and when the search icon is clicked, a search process is executed by the viewpoint table creating / displaying means, and a data record matching the search condition is obtained each time. It is extracted, a viewpoint table is created and displayed on the data display unit. In this case, when another search object exists in the direct higher order, a new search condition is created by combining the individual search conditions with an AND condition, and thus the search condition is narrowed down in the lower layer search objects.

Each time the search icon is clicked, the search is performed under the same search condition and the same viewpoint table is displayed. Therefore, even if the viewpoint table as the search result is not physically stored as a real table, To display the search result again, it is sufficient to click the icon again, and it can be handled exactly as if the data is physically stored. Therefore, the memory capacity can be greatly saved,
In addition, even a person who handles a database for the first time can perform a search process and display a viewpoint table by simply performing the most basic computer operation of clicking an icon, so that anyone can easily handle it. Furthermore, each time the search icon is clicked, the search is executed under the same search conditions each time, so even if the database is updated momentarily as in the POS system, new data is reflected in the viewpoint table. It

According to a second aspect of the present invention, when a plurality of search objects are selected, a new search condition is generated by combining the search conditions generated when each search object is individually selected with an OR condition. , Search processing is executed. Therefore, you can freely combine existing search icons,
The search process can be performed under new search conditions.

According to a third aspect of the present invention, the window opened on the display is divided into left and right, and a search for hierarchically displaying each of the icons in a tree structure on the left side of the data display section for displaying the existence table and the viewpoint table. The tree display is allocated. According to this, since the search tree diagram and the data contents that are the search results are displayed on the left and right, for example, if you click the icon that is highlighted or change to display that it is in use, the data will be displayed. It becomes clear at a glance which search icon corresponds to the viewpoint table displayed on the display unit.

According to a fourth aspect of the present invention, the search condition of each search object or the search condition when executing the search process is to compare the data recorded in any field of the data record with any character string. The search condition display means is composed of one or more condition blocks for extracting the data records, the AND condition is in series, the OR condition is in parallel, and the condition blocks are arranged as a search flowchart.

According to the invention of claim 4, the search condition is SQ.
Instead of a sentence like L, it is shown in the search condition display section as a search flow chart in which AND conditions are serially arranged and OR conditions are arranged in parallel and the condition blocks are arranged. Therefore, even a person who is unfamiliar with the database can Even a beginner who has no knowledge of SQL can easily understand the search condition.

According to the fifth aspect of the present invention, the search flowchart is displayed in the search tree display section divided into the left side and the right side of the window and the search condition display section allocated below the data display section. You can easily check what you are searching for with the search object.

According to the invention of claim 6, the display format of the view table for displaying the data records extracted by the search condition in a table format is set for each of the search objects, so that the view table of the view table is displayed according to the search condition. You can set the format individually and display in the most legible format.

According to a seventh aspect of the present invention, with respect to the data record extracted by selecting the search object, the data recorded in any field is aggregated for each data record having the data of the field serving as the aggregation reference in common. The summary format to be displayed is displayed on the search object. According to this, when the number of cases or other numerical values is more important than the content of the extracted data, the totalized result can be displayed very easily.

According to an eighth aspect of the present invention, by designating an arbitrary field of a data record, one or more sorting objects in which search conditions for individually sorting the data recorded in the field into common data are individually set. Is provided as a search object that is a subordinate search object of an arbitrary object that is a direct higher order selected in advance.

For example, when creating a list for each country from the winners of the Salt Lake Winter Olympics, in SQL, all country names are entered one by one such as "country name" = N'Japan 'as a WHERE sentence. You have to formulate a search formula individually. However, there are many participating countries in the Winter Olympics,
You cannot know which country's player won the prize unless you look over all the data records. That is, when the search condition is unknown as described above, the target data cannot be extracted unless the user is highly skilled in SQL.

On the other hand, according to the invention of claim 8, the sorting object for sorting the data recorded in the designated field for each common data is automatically created as the number of the common data as the search object.

In the above example, only by designating the field in which the country name is recorded, the country name recorded in the field is extracted, and if there are 11 countries, 11 sorting objects are created. Each sort object is set with a search condition that extracts the name of each country, so just by clicking this, the list of prize winners by country that cannot be extracted unless all data records are overlooked It can be easily extracted without setting an expression. As described above, a sorting object can be created for each field, which is extremely convenient when analyzing a huge number of data records stored in the database from various angles by changing the viewpoint.

According to a ninth aspect of the present invention, there is provided a search flowchart diagram in which one or more conditional blocks for comparing data recorded in an arbitrary field of a data record with an arbitrary character string are arranged in series with AND conditions and in parallel with OR conditions. Conditional object creating means for creating a conditional object for which a search condition is set as a subordinate search object of an arbitrary object that is a direct upper system selected in advance.

According to the invention of claim 9, the search condition can be freely set while drawing the search flowchart,
Even a beginner who does not have specialized knowledge such as SQL can easily set desired search conditions.

According to the tenth aspect of the present invention, the search condition set in the directly upper object is directly inherited, and
Since a heading object creating means for creating a heading object capable of setting an arbitrary name as a subordinate search object of an arbitrary object selected in advance is provided, for example, when creating a sorting object,
If the name of the field from which data is to be extracted is added to the upper level as a heading name, it becomes clear at a glance just by looking at the search tree which field of data is sorted.

Further, as in the invention of claim 11, the database is constructed in the server, and the client is provided with the retrieval object, the view table creation display means, the sorting object creation means, the index object creation means and the condition object creation means. For example, when a client is connected to a server via a computer communication network, data processing is performed each time according to the search conditions of the search object created by the client to create a viewpoint table, and the viewpoint table is displayed on the client display. It can be displayed, and a large-scale database can be opened to many users. In addition, each database user can set the optimum object for the client according to the individual purpose of use, and that database can be freely classified and organized for each client, so even if one database is shared by many people You can customize it as your own database.

[0030]

BEST MODE FOR CARRYING OUT THE INVENTION Embodiments of the present invention will be specifically described below with reference to the drawings. FIG. 1 is a conceptual diagram showing a database system according to the present invention, FIG. 2 is an explanatory diagram showing a display example of a search tree display unit, FIG. 3 is a flowchart showing a processing procedure of a viewpoint table creation display means, and FIG. 4 is a classification object creation. 5 is a flowchart showing the processing procedure of the means, FIG. 5 is an explanatory diagram showing the screen display thereof, FIG. 6 is a flowchart showing the processing procedure of the heading object creating means, FIG. 7 is an explanatory diagram showing the screen display thereof, and FIG. 9 is a flowchart showing the processing procedure of the means, FIG. 9 is an explanatory view showing its screen display, FIG. 10 is an explanatory view showing a search flowchart, FIG. 11 is an explanatory view showing a search display format setting means,
FIG. 12 is an explanatory view showing the means for setting the totalization display format, and FIG.
15 is an explanatory diagram showing the screen display, FIG. 16 is an explanatory diagram showing a display example of the actual table of the database, FIGS. 17 to 19 are explanatory diagrams showing a display example of the search result by the sorting object,
FIG. 20 is an explanatory diagram showing a display example of a search result by the condition object, and FIG. 21 is an explanatory diagram showing another embodiment.

The database system 1 of this example is constructed in a stand-alone type computer 2 and stores a large number of data records R _{1 to} Rn as physical tables in a physical storage device 3 such as a hard disk or other memory in advance. One or more data records Rn ... Are extracted under the set arbitrary search conditions and virtually displayed as a viewpoint table in the window 6 opened on the display 5. In addition, for convenience of explanation, as the database 4,
For the Salt Lake Winter Olympics speed skating winners, a data record Rn having seven fields Fn (n = 1 to 7) of competition name, gender, athlete name, country name, record, ranking, and remarks is recorded as an actual table. To use.

The database system 1 includes a database 4, its display format 7F, and an arbitrary search condition 8 for a data record Rn in a lower layer of a data object 7 for extracting all of which an icon 7S serving as a display switch is set.
J and a search icon 8 that serves as a switch for executing the search process
S, its name 8N, and the search object 8 in which the display format 8F of the search result and the total result is set are set.

In the window 6, a search tree display section 6B for hierarchically displaying the search icon 8S of the data record Rn is allocated on the left side of the data display section 6A for displaying the existence table, the viewpoint table and the aggregation processing result, and the data Below the display unit 6A and the search tree display unit 6B, a search condition display unit 6C for displaying the search condition of the search object 8 is allocated.

FIG. 2 shows a display example of the search tree display portion 6B, in which the top object T for managing one or more databases is displayed in the uppermost layer and the data in which the actual table of the database 4 is recorded in the next lower layer. An icon 7S of the object 7 is arranged, and further, a search icon 8S is displayed in a lower layer.

Further, the computer C, when the arbitrary search icon 8S displayed in the search tree display portion 6B is clicked, the data record Rn matching the search condition.
A viewpoint table creation / display unit PR1 for extracting each time to create a viewpoint table is provided.

FIG. 3 is a flow chart showing the viewpoint table creating / displaying means PR1. The processing is started when an arbitrary search object 8S is left-clicked. First, in step STP11, the search icon 8S is clicked. It is determined whether or not there is another search object in the selected direct upper rank.

If there is no other search object in the direct upper layer, the process proceeds to step STP12 to read the search condition 8J set in the search object 8, and if there is another search object in the direct upper layer, step All the search conditions 8J of the target object 8 and the direct higher-ranked search object 8 are moved to STP13.
Is read out and a new search condition combined with the AND condition is generated, then the search condition is registered in step STP14, and the process proceeds to step STP15.

In step STP15, it is determined whether or not another search object 8 is selected. If not, the process proceeds to step STP16, and the search flowchart showing the search condition registered in step STP14 is searched. The data record Rn that matches the search condition is extracted each time in step STP17 as shown in the display 6C, and is displayed in a table format in step STP18.

On the other hand, when another search object is selected in step STP15, the processes of steps STP11 to 18 are repeated for the search object, and in step STP14, a new search condition and an OR condition which have already been registered are added. And the search flowchart is rewritten in step STP16, and in step S
Data record Rn that matches the search condition in TP17
Is extracted and displayed in a table format in step STP18, and the process ends.

The search flow chart displayed in step STP16 is one or more conditions for comparing the data recorded in any field Fn of the data record Rn with any character string to extract the target data record Rn. For blocks 20a to 20f, AND conditions are made serial,
It is displayed in a format in which OR conditions are arranged in parallel.

The search object 8 has a sorting object 9, a heading object 10,
Three types of condition objects 11 can be set.

The sorting object 9 sorts the data recorded in the field Fn into common data by designating arbitrary fields F _{1 to} F ₇ of the data record Rn. FIG. 4 is a flowchart showing the sorting object creating means PR2 for creating this sorting object 9, and FIG. 5 is an explanatory view showing the screen display thereof.

The sorting object creating means PR2 starts processing by right-clicking any icon 7S, 8S. First, in step STP21, the object operation dialog 12 is displayed (see FIG. 5 (a)), then When "New" in the dialog 11 is pointed and "sort" is left-clicked, the process moves to step STP22 and the sort object creation dialog 13 is displayed (Fig. 5 (b)).

In this dialog 13, any field F
If you specify a ₁ to F _7, at step STP23, data recorded in the specified field _F 1 to F ₇ is extracted, which is sorted for each data common. Next, in step STP24, the search condition for searching each of these data is set according to the sorted data, and in step STP25, the sorting object 9 for extracting the data record according to the search condition is set to the number of the common data. Minutes are automatically created, and the icon 9S is displayed below the icon 8S. The name 9N of the icon 9S of each sorting object 9 displays the data content recorded in that field.

[0045] When using a database 4 above, only by specifying the field F ₄ country name has been recorded, country name recorded in the field F ₄ is extracted all, when it had 11 countries, 11 The sorting object 9 is created. Then, even if the country name is not input one by one, the search condition "country name is equal to XXX" is set for extracting each country name for each sorting object 9. Therefore, a list of prize winners by country is displayed by simply clicking on each sorting object 9, and in SQL, a list of prize winners by country that could not be extracted unless all the data records are overlooked and search conditions are set one by one. It can be easily extracted without setting any conditional expression.

In this way, by creating the sorting object 9 for an arbitrary field, it is possible to sort and organize a huge number of data records Rn stored in the database 4 from various angles by changing the viewpoint.

In this case, the search tree display portion 6B
When a large number of sorting object 9 icons are lined up in parallel with each other, it is difficult to distinguish from other search icons 8S in the same layer, and when it is difficult to understand what is sorted when looking around the search tree display portion 6B. There is. Therefore, before creating the sorting object 9, the heading object 1 whose field name is the object name
If 0 is created and the sorting object 9 is created in the lower layer, the sorting object 9 is organized and becomes easier to see.

The heading object 10 does not have a unique search condition, inherits the search condition set in the direct superordinate object 8 as it is, can set a unique name and display format, and can be arbitrarily selected in advance. Created as a search object below the object.

FIG. 6 is a flowchart showing the headline object creating means PR3 for creating the headline object 10, and FIG. 7 is an explanatory view showing its screen display. The heading object creation means PR3 starts execution of processing by right-clicking the icon 7S or 8S and selecting an arbitrary object 7 or 8, and first, step STP.
In 31, the object operation dialog 12 is displayed (see FIG. 7A), and when “New” in the dialog 12 is pointed and “Heading” is left-clicked, the process proceeds to step STP32 and the heading object is displayed. The creation dialog 14 is displayed (FIG. 7B). Here, when the object name is input, the process proceeds to step STP33, and the heading object 10 in which the same existence table or viewpoint table as the objects 7 and 8 is displayed is created in the lower layer of the objects 7 and 8 selected earlier. , The icon 10S is displayed below the icon 7S.

For example, according to the sorting object 9, for Salt Lake Winter Olympics speed skating winners,
When creating a list of prize winners by country, a headline object 10 named "country name", which is a field name in which the country name is recorded, is created, and the headline object 10 is created.
If the sorting object 9 is created in the lower layer of, the viewpoint table displayed by the icon 9S is clearly understood to be data for each country.

On the other hand, the condition object 11 sets the search condition when the desired data record Rn is to be extracted with the arbitrary search condition. FIG. 8 is a flowchart showing the condition object creating means PR4 for creating the condition object 11, and FIG. 9 is an explanatory view showing the screen display.

The conditional object creating means PR4 starts execution of processing by right-clicking any icon 7S, 8S, and first, the object operation dialog 12 is displayed in step STP41 (see FIG. 9A). Next, when "New" in the dialog 12 is pointed and "Condition" is left-clicked, step S
Transition to TP42, Condition object creation dialog 1
5 is displayed (FIG. 9 (b)).

Here, if an object name is entered and the search condition diagram is right-clicked, the process moves to STP43 to display the condition diagram operation dialog 16 (FIG. 9 (b)), and "add AND condition" is displayed first. Alternatively, when "addition of OR condition" is selected, the process moves to step STP44 and the condition setting dialog 17 is displayed (Fig. 9 (c)).

If desired conditions are set according to the dialog, desired search conditions can be set very easily in step STP45. For example, 500m for speed skating and 1000m for girls
When trying to extract the medalist or Japanese prizewinner, first select "Competition name" as the search item according to the condition setting dialog 19 and set "Speed skating 5" as the comparison character string.
If "00m" is input, the comparison method "equal to" is checked, and OK is clicked, a condition block 20a "Competition name is equal to speed skating 500m" is displayed as shown in FIG.

Next, with the condition block 20a left-clicked and inverted, right-click to display the condition diagram operation dialog 16, select "Add AND condition" to display the condition setting dialog 17, and search. Select "Gender" in the item, enter "Men" in the comparison character string, check the comparison method "is equal to", and click OK. As shown in Fig. 10 (b), "Gender is equal to boy" The conditional blocks 20 b “” are displayed in series.

Then, with the condition blocks 20a and 20b reversed, the condition diagram operation dialog 16 is displayed in the same manner, "Add OR condition" is selected to display the condition setting dialog 17, and the search item " Select "Competition name",
If you enter "speed skating 1000m" in the comparison string, check the comparison method "equal to" and click OK, the condition "the competition name is equal to speed skating 1000m" is displayed, as shown in FIG. 10 (c). Block 2
0c is displayed in parallel.

Further, with the condition block 20c reversed, right-click to display the condition diagram operation dialog 16, select "Add AND condition" to display the condition setting dialog 17, and select "Search item". If you select “Gender”, enter “Girl” in the comparison string, check the comparison method “is equal to”, and click OK, the condition “Gender is equal to girl” as shown in FIG. Block 2
0d is displayed in series.

Then, the condition diagram operation dialog 16 is displayed in a state where the condition blocks 20b and 20d are inverted, "Add AND condition" is selected to display the condition setting dialog 17, and "rank" is set in the search item. Select, enter "3" in the comparison string, and compare method "equal to or less than"
If the checkbox is checked and the user clicks OK, the condition blocks 20e of "rank <= 3" are displayed in series as shown in FIG.

Further, the condition diagram operation dialog 16 is displayed with the condition block 20e being inverted, "Add OR condition" is selected to display the condition setting dialog 20, and "Country name" is selected as the search item, "Japan" in the comparison string
10 is input, and the comparison method “is equal to” is checked and OK is clicked, the condition blocks 20f “country name is equal to Japan” are displayed in parallel as shown in FIG.

In this way, the AND conditions are serialized, and the OR
Since the search conditions can be set while drawing the search flow chart in which the conditions are arranged in parallel and the condition blocks 20a to 20f are arranged, anyone who has no language knowledge such as SQL can easily set the search conditions. Also, anyone can easily understand the search conditions by looking at the search flowchart.

Then, when the search object 8 is selected by clicking the search icon 8S, the viewpoint table creating / displaying means PR1 is activated, and from the existence table or viewpoint table displayed by the object in the upper layer of the search object 8, A viewpoint table is created by extracting the data record Rn that matches the search condition each time, and the viewpoint table is displayed on the data display unit 6A. The search condition of the search executed at this time is
Since it is displayed on the search condition display portion 6C, the data display portion 6
It is possible to easily confirm what search result is in the viewpoint table displayed in A.

In addition, for each search object 8, the field Fa serving as the aggregation reference, the other field Fb to be aggregated, and the aggregation method of the data recorded in the other field Fb are designated, thereby performing the aggregation. For each data record Rn in which the data of the standard field Fa is common, a total display format for totaling and displaying the data recorded in the total field Fb can be set.

FIG. 11 shows a search display format setting means.
Right-click the icon 8S of the search object 8 for which the search display format is to be set to display the object operation dialog 12, and left-click “Display format setting” to display the display format setting dialog 18.

Here, by selecting "Search display", "Display" and "Hide" can be set depending on whether or not each field in the display field list is checked, and the display order can be set by dragging each field name. it can.

FIG. 12 shows the means for setting the total display format.
Right-click the icon 8S of the search object 8 for which aggregate data is to be set to display the object operation dialog 12, and left-click "Display format setting" to display the display format setting dialog 18.

Here, if "display of totals" is selected, any field Fa is reversed and "standard of totaling" is selected,
The field Fa is set as the aggregation reference field Fa, and the data of the field Fa is displayed.

Next, when the other field Fb is reversed and "Aggregation target" is selected, it is set as the aggregation target field Fb, and its display content is "number of cases""minimum""maximum""range""total""average". , Etc., the aggregated value will be displayed. Further, if an additional column is set for the totaling reference field and the totaling target field, the totaling result by an arbitrary totaling method can be displayed in the additional column. This additional column, in the additional column creation column,
It is set by entering the number of cases, "minimum", "maximum", "range", "total", and "average" and the additional column name.

For example, when totaling the number of records of the world new, the new Olympics, and the new Japanese, and their ranking, first, according to the condition object creating means PR4, the world new, the new Olympics,
Create a condition object 8 that extracts only the data recorded in Japan Shin, right-click the icon 8 and select the display format setting dialog 18 as shown in FIG. 13 (a).
Is displayed, select "Aggregate display", drag the "Remarks" column that records the world new, Olympic new, and Japanese new from the display field list to a higher position than the "Rank" column, and check only these. After that, display it, and then set "Remarks" to "Cumulation criteria".

Next, as shown in FIG. 13B, when the "rank" is set as the aggregation target, the display content is set to "number of cases", and the display content of the additional column is set to "range", the data display section 6A is displayed.
As shown in Fig. 14, there are 9 new cases in the world, ranking from 1
It can be seen that the second place and the Olympic Shin are one with the second place, and the Japanese new one with one and the place is seven.

Further, as shown in FIG. 13C, "rank" is also set as the aggregation standard, and the display content of the additional column is "number of cases".
When set to, as shown in FIG. 15, in the data display section 6A, the world new has 7 cases, the second has 2 cases, the Olympic new has 2 cases, and the Japan new has 7 cases. It can be seen that it is.

The above is an example of the configuration of the present invention, and its operation will be described below. Excel (Microsoft's trade name) using and other spreadsheet software, for the Salt Lake Winter Olympics speed skating winners, the competition name, gender, player name, country name, record, order, seven fields F ₁ ~ Remarks By creating a table composed of data records Rn having F ₇ and inputting the created table in CSV format, or by directly inputting the data, the database 4 to be the actual table is stored in the physical storage device 3. When stored, the icon 7S of the data object 7 is displayed in the search tree display portion 6B as shown in FIG.

When this database object 9 is clicked, all the data records R _{1 to} Rn of the database 4 recorded as the actual table are displayed on the data display section 6A (see FIG. 16).

Next, when creating the sorting object 9 for extracting data records by country, a heading object 10 is created in the lower layer of the data object 7, and a heading "Country name" is attached to the search icon 10S. Note that the heading object 10 itself inherits the search condition of the object directly above it. However, when the data object 7 is directly above, no search condition is set, so when the heading object 10 is selected, The data of all data objects 7 are displayed.

Then, as shown in FIG.
Fee that "country name" is recorded in the lower layer of object 10
Ludo F_FourCreate a sorting object 9 that specifies
Field F in which "Gender" is recorded_Two
Create a sorting object 9 that specifies
Field F with "player name" recorded at the bottom_ThreeSpecify
The sorting object 9 is created. In addition, one assortment
Set the search object 8 under the object 9
Then, the same floor that has a sibling relationship with the sorting object 9
Search object 8 for all sorting objects 9 in the layer
Is set. As a result, the heading object 10
Field F below_Four11 countries recorded in
The names are extracted, and as shown in FIG.
Object 9 is automatically created and its search icon 9S
Is displayed and below that, field F_TwoRecorded in
The sex is extracted, and the sorting object 9 for two men and women
It will be created automatically and its search icon will be displayed.
Below field F _ThreeThe player name recorded in
Sent out and the corresponding number of sorting objects 9 are automatically created.
The search icon 9S is displayed.

When a search icon 9S for an arbitrary country name (for example, Japan) is clicked, a list of prize-winning players by country is displayed as a viewpoint table on the data display section 6A (see FIG. 17). At this time, the search condition display portion 6C
As a search flowchart of the clicked sorting object 9, the search condition "country name is equal to Japan" is displayed, so that even a beginner can easily confirm the search condition.

If a list of prize winners for Japan and Korea is to be created, a plurality of sorting objects 9 for Japan and Korea are selected at the same time by clicking the respective icons 9S using the "Ctrl key". Easy O
The R condition is generated, and as shown in FIG. 18, a search flow chart in which search blocks 21a and 21b are arranged in parallel such as "country name is equal to Japan" and "country name is equal to Korea" are searched in the search condition display portion 6C. The flow chart is displayed and the viewpoint table is displayed on the data display unit 6A.

Furthermore, when it is desired to know the prize-winning competition name of the Japanese women's prizewinner XXXXX, as shown in FIG.
Click the "+" mark (the "-" mark after clicking) on the left side of the "Japan" icon 9S and "Women" icon 9S and then click the "XXXXX" icon 9S Data record Rn of
The viewpoint table is displayed on the data display portion 6A,
It can be seen that the second prize of 0 m and 5000 m has won.

When the "XXX" icon 9S is clicked, the search conditions of the directly upper search object 9 are combined with the AND condition to perform the search. At this time, the search condition display portion 6C displays " A search flow chart in which search blocks 22a to 22c are arranged in series such as "country name is equal to Japan"-"sex is equal to girl"-"player name is equal to XXX" is displayed, so even a beginner can search. You can easily check the conditions.

Furthermore, "500m for speed skating men
And when trying to extract a data record with an arbitrary search condition such as "a female medalist of 1000 m or a Japanese prizewinner", the condition object 11
To create. As a result, as shown in FIG. 20, the search icon 11S (8S) is displayed on the search tree display portion 6B, and by clicking this search icon 11S, the data record that matches the search condition is extracted, and the data display portion is displayed. It is displayed as a viewpoint table on 6A. At this time,
The search condition display portion 6C displays a search flowchart of the clicked condition object 11, so that even a beginner can easily confirm what kind of search condition is being searched for.

In the above description, the case of using a stand-alone type computer has been described, but the present invention is not limited to this, and the computer in which the database 4 is constructed can be accessed from a plurality of computers in a LAN. Thus, any data record may be extracted.

Further, as shown in FIG. 21, the database 4 is constructed in the server 21 on the computer communication network such as the Internet, and the clients 23 connected to the server 21 via the communication network 22 are search objects. 8, the viewpoint table creating / displaying means PR1, the sorting object creating means PR2, the heading object creating means PR3 and the condition object creating means PR4 may be provided.

In this way, even when connected via the computer communication network 22, the target data record Rn is extracted from the database 4 built in the server 21 and the viewpoint table is extracted, just as in the stand-alone type. It can be displayed on the display 24 just like the stand-alone type.

[0083]

As described above, according to the present invention, the search objects for which the search conditions are set are hierarchically set and the search icons 8S are hierarchically displayed in a tree structure. Just by looking at it, you can see at a glance what you are looking for and how you are going to search, and by performing the most rudimentary computer operation of clicking the search icon, the search will be executed and the viewpoint table will be displayed. The effect is that even a beginner who does not have specialized knowledge of a database can easily handle it. .

Further, each time the icon is clicked, the search process is executed and the viewpoint table is displayed in the data display section. Therefore, a folder in which the viewpoint table as the search result is physically stored as an actual table is set. Even if it does not, it can be handled exactly as if each icon is physically stored, and the memory capacity can be greatly saved.

Further, each time the search object is clicked, the search is executed under the same search condition, so that even if the database is updated momentarily like the POS system, no operation is performed. It is also possible to create a viewpoint table that reflects new data without any need.

Furthermore, since each database user can set the optimum object in the client according to the individual purpose of use and the database can be freely classified and organized for each client, one database can be used by many people. Even when shared, it has the outstanding effect that you can customize it as your own database.

[Brief description of drawings]

FIG. 1 is a conceptual diagram showing a database system according to the present invention.

FIG. 2 is an explanatory diagram showing a display example of a search tree display unit.

FIG. 3 is a flowchart showing a processing procedure of a viewpoint table creation / display means.

FIG. 4 is a flowchart showing a processing procedure of a sorting object creating means.

FIG. 5 is an explanatory diagram showing the screen display.

FIG. 6 is a flowchart showing a processing procedure of a heading object creating means.

FIG. 7 is an explanatory view showing the screen display.

FIG. 8 is a flowchart showing a processing procedure of a condition object creating unit.

FIG. 9 is an explanatory diagram showing the screen display.

FIG. 10 is an explanatory diagram showing a search flowchart.

FIG. 11 is an explanatory diagram showing a search display format setting means.

FIG. 12 is an explanatory diagram showing a means for setting a tabulation display format.

FIG. 13 is an explanatory diagram showing the screen display.

FIG. 14 is an explanatory diagram showing the screen display.

FIG. 15 is an explanatory diagram showing the screen display.

FIG. 16 is an explanatory diagram showing a display example of an actual table of a database.

FIG. 17 is an explanatory diagram showing a display example of a search result by a sorting object.

FIG. 18 is an explanatory diagram showing a display example of a search result by a sorting object.

FIG. 19 is an explanatory diagram showing a display example of a search result by a sorting object.

FIG. 20 is an explanatory diagram showing a display example of search results by a condition object.

FIG. 21 is an explanatory diagram showing another embodiment.

[Explanation of symbols]

1 ... Database system R _{1 to} Rn ... Data record F _{1 to} F ₇ ... Field 3 ... Physical storage device 4 ... Database 5 ... Display 6 ... Window 6A ... Data Display unit 6B ... Search tree display unit 6C. Search condition display unit 7 ... Data object 8 ... Search object 8S, 9S, 10S, 11S ... Search icon 9 ... Sort object 10 ... Heading object 11 ... Condition object

   ─────────────────────────────────────────────────── ─── Continued front page    F term (reference) 5B075 NK54 NR05 PP30 QT06                 5B082 GC02

Claims (11)

[Claims] 1. A database (4) having a large number of data records (Rn) stored as physical tables in a physical storage device (3).
In the database system for extracting one or more data records (Rn) from the above by a preset arbitrary search condition and virtually displaying them as a viewpoint table on the display (5), a data object (7) recording the database (4) A search object (8) in which an arbitrary search condition (8J) of the data record (Rn) and a search icon (8S) which is a search processing execution switch are set in the lower layer of the
Is set, and the search icon (8S) corresponds to the icon (7) corresponding to the data object (7).
When a search object (8) is selected by the search icon (8S) and a search process is executed, another search object (8) is displayed directly below the S). If it does not exist, the search condition set for the search object remains as it is, and if another search object (8) exists in the direct higher order, a new search condition is generated by combining the individual search conditions with an AND condition, and View table creating and displaying means (PR1) for creating a view table by extracting a data record (Rn) matching the search condition each time
A database system characterized by having. 2. When a plurality of search objects (8) are selected by a search icon and a search process is executed, a search condition generated when each of the selected search objects (8) is individually selected is ORed. Create a new search condition that is combined with the condition, and create a data record (R
The database system according to claim 1, further comprising a viewpoint table creating / displaying means (PR1) for extracting n) each time to create a viewpoint table. 3. A window (6) opened on the display (5) is divided into left and right parts, and the icons are hierarchically arranged on the left side of a data display part (6A) for displaying a real table and a viewpoint table. Search tree display (6B)
The database system according to claim 1, wherein the database system is allocated. 4. A search condition generated when one or more search objects (8) is selected and a search process is executed is an arbitrary field (F) of a data record (Rn).
n) is composed of one or more condition blocks (20a to 20f) for comparing the data recorded with an arbitrary character string and extracting a target data record (Rn), AND conditions are serially connected, and OR conditions are parallel. Then, the condition block (20
5. The database system according to claim 1, further comprising search condition display means illustrated as a search flowchart in which a to 20f) are arranged. 5. A search condition display section (6C) showing the search flow chart, a search tree display section (6B) and a data display section (6) assigned to the window (6).
The database system according to claim 4, wherein the database system is assigned to the lower side of A). 6. A display format (8F) for a search result when a data record (Rn) extracted by the search condition is displayed as a viewpoint table for each search object (8). The database system according to any one of 1 to 5. 7. A field (Fa) serving as a counting standard by designating a field (Fa) serving as a counting standard and a counting method of data recorded in an arbitrary field (Fb).
The display format (8F) of the aggregation result for totalizing and displaying the data recorded in the arbitrary field (Fb) for each data record (Rn) having the data of a) is set in the search object (8). The database system according to any one of claims 1 to 6. 8. By specifying an arbitrary field (Fn) of a data record (Rn), the field (Fn)
One or more sorting objects (9) in which the search conditions for individually sorting the data recorded in n) are sorted according to common data are subordinate to the preselected direct superior objects (7, 8). The database system according to any one of claims 1 to 7, further comprising a sorting object creating means (PR2) for creating as a search object of. 9. One or more conditional blocks (20a to 20f) for comparing data recorded in an arbitrary field (Fn) of a data record (Rn) with an arbitrary character string are serially ANDed, and ORed. Condition object creating means for creating a condition object (11) for which a search condition is set by a search flowchart diagram arranged in parallel as a lower search object of an arbitrary object (7, 8) which is a direct upper order selected in advance 9. The database system according to claim 1, comprising (PR4). 10. A heading object (10) that inherits the search condition set in the direct higher-order object (7, 8) as it is and can set an arbitrary name is an arbitrary object (7, 8) selected in advance. 10. The database system according to claim 1, further comprising a heading object creating means (PR3) created as a subordinate search object of 8). 11. The database (4) in a server (21).
Is constructed, and the client (23) connected to the server (21) through the computer communication network (22) is provided with the viewpoint table creation display means (PR1) and the sorting object creation means (PR2). The database system according to any one of claims 1 to 10, further comprising: the heading object creating means (PR3) and the condition object creating means (PR4).