Patent US5734889A successfully refreshed from Google Patents.
US5734889A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for retrieving data and inputting retrieved data to spreadsheet including descriptive sentence input means and natural language interface means
Assignee: NEC Corp
•
Filing: 1996-01-18
•
Granted: 1998-03-31
•
Expires: 2016-01-18
Abstract
Abstract A method and apparatus for retrieving data on a database and inputting the retrieved data to an electronic spreadsheet so as to record the data thereon includes inputting, through an input apparatus by a natural language, a descriptive sentence relating to the data to be recorded in the spreadsheet. The input descriptive sentence is processed by a natural language interface to generate a retrieval formula for retrieval on the database. A retrieval result extractor executes data retrieval on the database by the retrieval formula, eliminates unnecessary accompanying data from results of the retrieval, and inputs the thus obtained table data to the spreadsheet so as to record the data therein.
Inventors
- 👤 Tomoharu Yamaguchi
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-31 15:48
CPC Classifications
G; G06; G06F; G06F40/00; G06F40/10; G06F40/166; G06F40/177; G06F40/18
Claims Analysis
Total Claims: 17
Claim 1
Independent Claim
134 words
A data retrieving device for retrieving a set of data on a database and inputting the retrieved data to an electronic spreadsheet having a table means for recording the data in a tabulated form, comprising: descriptive sentence input means for inputting by a natural language a descriptive sentence relating to the data to be reformed as data to be recorded in the table means; natural language interface means for converting the input descriptive sentence into a retrieval formula for retrieving the data on the database; and retrieval result extraction means for executing the data retrieval on the database by the retrieval formula using correspondence information between the descriptive sentence and the table means to extract from the database a reformed data in a tabulated form, and recording the reformed data in the table means.
Claim 2
Dependent Claim
134 words
A data retrieving device for retrieving a set of data on a database and inputting the retrieved data to an electronic spreadsheet having a table means for recording the data in a tabulated form, comprising: descriptive sentence input means for inputting by a natural language a descriptive sentence relating to the data to be reformed as data to be recorded in the table means; natural language interface means for converting the input descriptive sentence into a retrieval formula for retrieving the data on the database; and retrieval result extraction means for executing the data retrieval on the database by the retrieval formula using correspondence information between the descriptive sentence and the table means to extract from the database a reformed data in a tabulated form, and recording the reformed data in the table means.
Claim 3
Dependent Claim
88 words
The data retrieving device as claimed in claim 1, wherein the table means includes a predetermined title section having one or more recorded titles corresponding to the data to be recorded in the table means, further comprising: descriptive sentence generation means for generating a descriptive sentence relating to the data to be recorded in the table means by inputting the recorded title or titles and by combining the input titles, the descriptive sentence generated by the descriptive sentence generation means being input to the natural language interface means.
Claim 4
Dependent Claim
83 words
The data retrieving device as claimed in claim 1, further comprising: descriptive sentence record means for recording one or more descriptive sentences corresponding to a set of data recorded in the table means; and descriptive sentence synthesization means for generating a synthetic descriptive sentence by inputting the descriptive sentence or sentences recorded in the descriptive sentence record means and by combining the input sentences, the synthetic descriptive sentence generated by the descriptive sentence synthesization means being input to the natural language interface means.
Claim 5
Dependent Claim
129 words
A data retrieving method for retrieving a set of data on a database and inputting the retrieved data to an electronic spreadsheet having a formatted table for recording the data, comprising: a descriptive sentence acquisition step for acquiring by a natural language a descriptive sentence relating to the data to be reformed as data to be recorded in the table; a natural language interface step for converting the acquired descriptive sentence into a retrieval formula for retrieving the data on the database; and a retrieval result extraction step for executing the retrieval on the database by the retrieval formula using correspondence information between the descriptive sentence and the table to extract from the database a reformed data in a tabulated form, and recording the reformed data in the table.
Claim 6
Dependent Claim
129 words
A data retrieving method for retrieving a set of data on a database and inputting the retrieved data to an electronic spreadsheet having a formatted table for recording the data, comprising: a descriptive sentence acquisition step for acquiring by a natural language a descriptive sentence relating to the data to be reformed as data to be recorded in the table; a natural language interface step for converting the acquired descriptive sentence into a retrieval formula for retrieving the data on the database; and a retrieval result extraction step for executing the retrieval on the database by the retrieval formula using correspondence information between the descriptive sentence and the table to extract from the database a reformed data in a tabulated form, and recording the reformed data in the table.
Claim 7
Dependent Claim
30 words
The data retrieving method as claimed in claim 4, wherein the descriptive sentence acquisition step comprises a descriptive sentence input step for inputting the descriptive sentence through an input means.
Claim 8
Dependent Claim
54 words
The data retrieving method as claimed in claim 4, wherein the descriptive sentence acquisition step comprises: a title information reading step for reading title information recorded in a title section provided in the table; and a descriptive sentence generation step for generating a descriptive sentence relating to the data from the read title information.
Claim 9
Dependent Claim
28 words
The data retrieving method as claimed in claim 4, wherein the title information comprises a title name, and address information concerning the record address of the title name.
Claim 10
Dependent Claim
50 words
The data retrieving method as claimed in claim 4, wherein the descriptive sentence acquisition step comprises: a descriptive sentence record step for temporarily storing a plurality of descriptive sentences; and a descriptive sentence synthesization step for reading the stored descriptive sentences and synthesizing them to generate a single descriptive sentence.
Claim 11
Dependent Claim
29 words
The data retrieving method as claimed in claim 8, wherein the descriptive sentence record process step includes an input step for inputting the descriptive sentences by an input means.
Claim 12
Dependent Claim
37 words
The data retrieving method as claimed in claim 8, wherein the descriptive sentence record step includes a reading step for reading a set of title names as the descriptive sentences from the title section of the table.
Claim 13
Dependent Claim
71 words
The data retrieving method as claimed in claim 4, wherein the descriptive sentence acquisition step comprises steps of: a descriptive sentence input step for inputting the descriptive sentence through an input means; a title information reading step for reading title information recorded in a title section provided in the table; and a descriptive sentence generation step for generating a second descriptive sentence relating to the data from the read title information.
Claim 14
Dependent Claim
31 words
The data retrieving method as claimed in claim 11, wherein the retrieval result extraction step comprises retrieving data on said database satisfying both said descriptive sentence and said second descriptive sentence.
Claim 15
Dependent Claim
184 words
A data retrieving device for retrieving a set of data on a database and inputting the retrieved data to an electronic spreadsheet having a table means for recording the data in a tabulated form, comprising: natural language interface means for converting an input descriptive sentence into a retrieval formula for retrieving the data on the database; and retrieval result extraction means for executing the data retrieval on the database by the retrieval formula using correspondence information between the descriptive sentence and the table means to extract from the database a reformed data in the tabulated form, and recording the reformed data in the table means, wherein the table means includes a predetermined title section having one or more recorded titles corresponding to the data to be recorded in the table means, further comprising: descriptive sentence generation means for generating a descriptive sentence relating to the data to be recorded in the table means by inputting the recorded title or titles and by combining the input titles, the descriptive sentence generated by the descriptive sentence generation means being input to the natural language interface means.
Claim 16
Dependent Claim
184 words
A data retrieving device for retrieving a set of data on a database and inputting the retrieved data to an electronic spreadsheet having a table means for recording the data in a tabulated form, comprising: natural language interface means for converting an input descriptive sentence into a retrieval formula for retrieving the data on the database; and retrieval result extraction means for executing the data retrieval on the database by the retrieval formula using correspondence information between the descriptive sentence and the table means to extract from the database a reformed data in the tabulated form, and recording the reformed data in the table means, wherein the table means includes a predetermined title section having one or more recorded titles corresponding to the data to be recorded in the table means, further comprising: descriptive sentence generation means for generating a descriptive sentence relating to the data to be recorded in the table means by inputting the recorded title or titles and by combining the input titles, the descriptive sentence generated by the descriptive sentence generation means being input to the natural language interface means.
Claim 17
Dependent Claim
45 words
The data retrieving device as claimed in claim 13, wherein said natural language interface means further comprises a comparing means for comparing said input descriptive sentence and said descriptive sentence, said retrieval formula comprising information satisfying both said input descriptive sentence and said descriptive sentence.
References Cited (Backward Citations)
US4885694A
Cited
US5038316A
Cited
JPH0430254A
Cited
JPH04220767A
Cited
US5303375A
Cited
JPH0554078A
Cited
JPH0554067A
Cited
JPH06195392A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-03-30 | 2001-09-29 | 2002-03-31 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-03-30 | 2005-09-29 | 2006-03-31 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-03-30 | 2009-09-29 | 2010-03-31 | $7700.00 | Window Closed / Lapsed |