Back to EveryPatent.com
United States Patent | 6,052,687 |
Miura ,   et al. | April 18, 2000 |
Preliminarily or according to amendment to a basic table, an intermediate link table indicating a link condition for directly or indirectly linking two optional basic tables is automatically generated by obtaining an indirect link condition for linking basic tables which cannot be directly linked based on a link condition of basic tables which can be directly linked. By only inputting minimal information, a structured query language (SQL) statement is automatically generated according to the input information using the intermediate link table. Thus a relational database can be searched for desired data even when a user does not fully understand the structure of a table or field information in the relational database.
Inventors: | Miura; Iwao (Kawasaki, JP); Sakaki; Youko (Kawasaki, JP) |
Assignee: | Fujitsu Limited (Kawasaki, JP) |
Appl. No.: | 990578 |
Filed: | December 15, 1997 |
Jun 13, 1997[JP] | 9-156197 |
Current U.S. Class: | 707/100; 707/3; 715/506 |
Intern'l Class: | G06F 017/30 |
Field of Search: | 707/1-10,100-104,200-206 395/701,705 710/7,20,21 711/216,148,150 |
5355472 | Oct., 1994 | Lewis | 707/101. |
5519859 | May., 1996 | Grace | 707/3. |
5604899 | Feb., 1997 | Doktor | 707/3. |
5617567 | Apr., 1997 | Doktor | 707/2. |
5652882 | Jul., 1997 | Doktor | 707/201. |
5742806 | Apr., 1998 | Reiner et al. | 707/3. |
Foreign Patent Documents | |||
60-7556 | Jan., 1985 | JP. |