Login| Sign Up| Help| Contact|

Patent Searching and Data


Title:
USE HISTORY REGISTRATION DEVICE AND DATABASE RETRIEVAL- TYPE AUTOMATIC GENERATION DEVICE
Document Type and Number:
Japanese Patent JP2001290836
Kind Code:
A
Abstract:

To automatically retrieve a record which is useful to a user from a database according to the past use history of the user and to present it.

A storage part 209 holds conditional expressions by subsets for deciding in which subset one item value is included and and also holds cumulative frequencies by the subsets when a set of values which are possibly the values of items of a database table 200 is divided into the subsets by the items. A history registration device 205 receives a record for history update, determines in which subset of an item the item vale is included by the items of the record according to the conditional expression, and increases the value of the cumulative frequency corresponding to the subset including the item value by one. A retrieval expression automatic generation device 206 automatically generates an SQL retrieval statement while taking the cumulative frequencies, etc., by the item values recorded in the storage part 209 into consideration and presents records including item values selected frequently in the past.


Inventors:
SHIMAZU HIDEO
Application Number:
JP2000111909A
Publication Date:
October 19, 2001
Filing Date:
April 07, 2000
Export Citation:
Click for automatic bibliography generation   Help
Assignee:
NEC CORP
International Classes:
G06F17/30; (IPC1-7): G06F17/30
Attorney, Agent or Firm:
Sakai Hiromi