← Back to Patent Explorer
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
📄 Original PDF 🌐 Google Patents 🔄 Sync Now

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 10:33
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

Assigned Categories & Tags

No categories assigned to this patent yet.

Assign Category Tag