US Patent Application 18106679. INFORMATION MANAGEMENT APPARATUS, INFORMATION MANAGEMENT METHOD, AND RECORDING MEDIUM simplified abstract

From WikiPatents
Jump to navigation Jump to search

INFORMATION MANAGEMENT APPARATUS, INFORMATION MANAGEMENT METHOD, AND RECORDING MEDIUM

Organization Name

Hitachi, Ltd.

Inventor(s)

Garima Natani of Tokyo (JP)

Satoshi Katsunuma of Tokyo (JP)

Toshihiko Kashiyama of Tokyo (JP)

INFORMATION MANAGEMENT APPARATUS, INFORMATION MANAGEMENT METHOD, AND RECORDING MEDIUM - A simplified explanation of the abstract

This abstract first appeared for US patent application 18106679 titled 'INFORMATION MANAGEMENT APPARATUS, INFORMATION MANAGEMENT METHOD, AND RECORDING MEDIUM

Simplified Explanation

The patent application describes an information management apparatus that reduces the effort required to move data from an OLTP database to an OLAP database.

  • OLTP database: A database used for online transaction processing.
  • OLAP database: A database used for online analytical processing.
  • The apparatus includes a table status update unit that tracks the data stored in both the OLTP and OLAP databases.
  • A policy network learning unit learns the number of federated queries that require querying both databases and the cost of moving data from OLTP to OLAP.
  • A data movement unit controls the movement of data from OLTP to OLAP based on the learning results and the current table status.


Original Abstract Submitted

An information management apparatus is capable of reducing an effort for creating a rule for moving data stored in an OLTP database to an OLAP database, for example. A data movement optimization apparatus includes a table status update unit that acquires a table status in which data is stored for each of an OLTP database and an OLAP database selected from among a plurality of databases, a policy network learning unit that performs learning on the number of federated queries that are processing in which it is necessary to query both the OLTP database and the OLAP database for the table status, and a cost incurred when data is moved from the OLTP database to the OLAP database, and a data movement unit that performs control for moving data from the OLTP database to the OLAP database on the basis of a result of the learning and the table status.

Retrieved from "http://wikipatents.org/index.php?title=US_Patent_Application_18106679._INFORMATION_MANAGEMENT_APPARATUS,_INFORMATION_MANAGEMENT_METHOD,_AND_RECORDING_MEDIUM_simplified_abstract&oldid=12544"