Data retrieval apparatus, data retrieval program, and data retrieval method

• US 10,146,844 B2
• Filed: 02/21/2014
• Issued: 12/04/2018
• Est. Priority Date: 04/25/2013
• Status: Active Grant

• Current Assignee: DENSO Corporation
• Original Assignee: DENSO Corporation
• Inventors: Ogasawara, Akihiro
• Primary Examiner(s): Phillips, III, Albert M
• Application Number:
  US14/784,436
• Publication Number:
  US 20170206254A1
• Time in Patent Office: 1,747 Days
• CPC Class Codes: G06F 16/254 Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses

Abstract

A data retrieval apparatus comprises: a local database which links data for retrieval with content attribute data and stores same; a data for retrieval extraction processing unit which extracts the data for retrieval from a medium; an attribute data retrieval processing unit which retrieves the attribute data corresponding to the data for retrieval from the local database; and a data for retrieval storage processing unit which stores the data for retrieval if the attribute data corresponding to the data for retrieval is not present in the local database.

Claims

1. A data retrieval apparatus comprising:

a local database that stores data for retrieval and attribute data of a content, the data for retrieval being in association with the attribute data of the content;

a temporary storage region that temporarily stores the data for retrieval in a predetermined case;

a controller that is configured to

extract the data for retrieval from a medium inserted from an outside;

retrieve the attribute data corresponding to the data for retrieval extracted from the local database;

store the data for retrieval to the temporary storage region, as the predetermined case, when the attribute data corresponding to the data for retrieval extracted is not present in the local database; and

a user-specific database that is configured to associate and store (i) the attribute data retrieved by the controller and (ii) the data for retrieval used at a time of retrieving the attribute data,

wherein;

the data for retrieval at least includes table of contents (TOC) data of the medium;

when the local database is updated,

the controller is configured to again retrieve the attribute data corresponding to the data for retrieval stored in the temporary storage region, from the local database updated; and

when the medium is inserted from the outside,

the controller is configured to retrieve the attribute data corresponding to the data for retrieval extracted by the controller, from the user-specific database before retrieval of the local database, and

when the medium is inserted from the outside and also when the controller retrieves the attribute data corresponding to the data for retrieval extracted by the controller, from the user-specific database and also when the attribute data corresponding to the data for retrieval extracted by the controller is not present in the user-specific database,

the controller is configured to retrieve from the local database,

(i) the attribute data corresponding to the TOC data included in the data for retrieval extracted by the controller,

(ii) the attribute data corresponding to a different data other than the TOC data included in the data for retrieval in a case where the attribute data corresponding to the TOC data is not present in the local database, and

(iii) the attribute data corresponding to a further different data other than the TOC data and the different data included in the data for retrieval in a case where the attribute data corresponding to the different data is not present in the local database.

2. The data retrieval apparatus according to claim 1, wherein:

when the attribute data retrieval portion is connected to an external database storing the data for retrieval and the attribute data, the data for retrieval being in association with the attribute data,

the attribute data retrieval portion re-retrieves the attribute data corresponding to the data for retrieval stored in the retrieval data storage portion, from the external database.

3. The data retrieval apparatus according to claim 1, wherein the TOC data includes at least one of:

data indicating a content recorded on the medium, file structure data indicating file structures of the various types of media, and waveform data indicating waveforms of sounds included in the various types of media.

4. The data retrieval apparatus according to claim 1, wherein the TOC data includes each of:

data indicating a content recorded on the medium, file structure data indicating file structures of the various types of media, and waveform data indicating waveforms of sounds included in the various types of media.

5. A non-transitory tangible storage medium storing a data retrieval program operating in a data retrieval apparatus including a local database that stores data for retrieval and attribute data of a content and a temporary storage region that temporarily stores the data for retrieval in a predetermined case, the data for retrieval being in association with the attribute data of the content, the data retrieval program performing:

extracting the data for retrieval from a medium inserted from an outside, the data for retrieval at least including table of contents (TOC) data of the medium;

retrieving the attribute data corresponding to the data for retrieval extracted from the local database;

storing the data for retrieval to the temporary storage region, as the predetermined case, when the attribute data corresponding to the data for retrieval is not present in the local database;

associating and storing to a user-specific database, the attribute data retrieved and the data for retrieval used at a time of retrieving the attribute data;

retrieving again the attribute data corresponding to the data for retrieval stored in the temporary storage region from the local database when the local database is updated; and

when the medium is inserted from the outside,

retrieving the attribute data corresponding to the extracted data for retrieval from the user-specific database before retrieval of the local database, and

when the medium is inserted from the outside and also when the attributed data that corresponds to the extracted data for retrieval is retrieved from the user-specific database and also

when the attribute data corresponding to the extracted data for retrieval is not present in the user-specific database, retrieving from the local database;

(i) the attribute data corresponding to the TOC data included in the extracted data for retrieval,

(ii) the attribute data corresponding to a different data other than the TOC data included in the data for retrieval in a case where the attribute data corresponding to the TOC data is not present in the local database, and

(iii) the attribute data corresponding to a further different data other than the TOC data and the different data included in the data for retrieval in a case where the attribute data corresponding to the different data is not present in the local database.

6. A data retrieval method performed by a data retrieval apparatus including a local database that stores data for retrieval and attribute data of a content and a temporary storage region that temporarily stores the data for retrieval in a predetermined case, the data for retrieval being in association with the attribute data of the content, the data retrieval method comprising:

extracting the data for retrieval from a medium inserted from an outside, the data for retrieval at least including table of contents (TOC) data of the medium;

retrieving the attribute data corresponding to the data for retrieval extracted from the local database;

storing the data for retrieval to the temporary storage region, as the predetermined case, when the attribute data corresponding to the data for retrieval is not present in the local database;

associating and storing to a user-specific database, the attribute data retrieved and the data for retrieval used at a time of retrieving the attribute data;

retrieving again the attribute data corresponding to the data for retrieval stored in the temporary storage region from the local database when the local database is updated; and

when the medium is inserted from the outside,

retrieving the attribute data corresponding to the extracted data for retrieval from the user-specific database before retrieval of the local database, and

when the medium is inserted from the outside and also when the attributed data that corresponds to the extracted data for retrieval is retrieved from the user-specific database and also

when the attribute data corresponding to the extracted data for retrieval is not present in the user-specific database, retrieving from the local database;

(i) the attribute data corresponding to the TOC data included in the extracted data for retrieval,

(ii) the attribute data corresponding to a different data other than the TOC data included in the data for retrieval in a case where the attribute data corresponding to the TOC data is not present in the local database, and

(iii) the attribute data corresponding to a further different data other than the TOC data and the different data included in the data for retrieval in a case where the attribute data corresponding to the different data is not present in the local database.