US 10,242,075 B2Granted

Database apparatus, database management method performed in database apparatus and storing the same

AssigneeLG Cns Co., Ltd.

InventorsUi Jin Lim, Sung Jun Jung, Jeong Min Ju

Life of this patent

Estimating the term…

Abstract

A database apparatus may include a database unit configured to store first and second data groups being classified based on a data attribute, a first caching unit associated with the first data group and including a first cache architecture and a second caching unit associated with the second data group and including a second cache architecture.

Claims12

Dependent claims

A database system comprising:

a database configured to store first and second data groups classified based on a data attribute;
a memory that includes a first cache and a second cache, the first cache being associated with the first data group, and including a first cache architecture, the second cache associated with the second data group, and including a second cache architecture;
a receiving device to receive a database query from a user;
and
a control device separate from the database and the memory, wherein the first cache and the second cache are connected to the database through the control device, wherein the control device is a machine, the control device configured to:
receive, at the control device, the database query from the receiving device,
analyze, at the control device, the received database query, and
transmit, from the control device, a query result to the database, the first cache or the second cache, wherein the query result is based on the analyzed database query,
wherein the control device to analyze a query predicate of the database query and the control device to transmit the analyzed database query to the first cache when a corresponding table is associated with the first data group, wherein the control device to transmit the analyzed database query to the second cache when a corresponding table is associated with the second data group, wherein the control device to transmit the analyzed database query to the database when a corresponding table is associated with the database,
wherein the first cache to interpret the transmitted database query and to search a cache mapping table at the first cache to determine effectiveness of the query result for the database query when the interpreted database query is searched in the cache mapping table, wherein the cache mapping table at the first cache includes information of a version of a query result,
wherein the first cache to determine a version of the query result when the interpreted database query is searched in the cache mapping table, and the first cache to provide the query result when the determined version corresponds to a latest version,
wherein when the determined version does not correspond to a latest version, the first cache to determine the version of the query result when the interpreted database query is searched in the cache mapping table to obtain the query result from the database, and
wherein the first cache to update the cache mapping table at the first cache based on a cache key and the query result obtained from the database,
wherein when the interpreted database query is not searched in the cache mapping table, the first cache is to be inputted the query result by the user for the interpreted database query through the database, the query result inputted by the user through the database is directly provided to the user or is provided to the user through the first cache after being updated in the first cache.

11 more elements

A database management method to be performed at a database apparatus that includes a control device, the method comprising:

receiving, at the control device, a database query from a user;
analyzing, at the control device, the database query;
and
providing, from the control device, a query result to a database unit, a first caching unit associated with a first data group or a second caching unit associated with a second data group based on the analyzed database query, wherein the query result is based on the analyzed database query, wherein a query predicate of the database query to be analyzed by the control device and the analyzed database query to be provided from the control device to the first caching unit when a corresponding table is associated with the first data group, wherein the analyzed database query to be provided from the control device to the second caching unit when a corresponding table is associated with the second data group, wherein the analyzed database query to be provided from the control device to the second caching unit when a corresponding table is associated with the database, wherein the first caching unit to interpret the database query and to search a cache mapping table at the first caching unit to determine effectiveness of the query result for the database query when the interpreted database query is searched in the cache mapping table, wherein the cache mapping table includes information of a version of a query result,
wherein the first caching unit to determine a version of the query result when the interpreted database query is searched in the cache mapping table, and the first caching unit to provide the query result when the determined version corresponds to a latest version,
wherein when the determined version does not correspond to a latest version, the first caching unit to determine the version of the query result when the interpreted database query is searched in the cache mapping table to obtain the query result from the database unit, and
wherein the first caching unit to update the cache mapping table at the first caching unit based on a cache key and the query result obtained from the database unit,
wherein when the interpreted database query is not searched in the cache mapping table, the first cache unit is to be inputted the query result by the user for the interpreted database query through the database unit, the query result inputted by the user through the database unit is directly provided to the user or is provided to the user through the first cache unit after being updated in the first cache unit.

5 more elements

A machine-readable non-transitory medium storing a computer program for a database management method to be performed in a database apparatus, the machine-readable non-transitory medium having stored thereon machine-executable instructions for:

receiving, at a control device, a database query from a user;
analyzing, at the control device, the database query;
and
providing, from the control device, a query result to a database unit, a first caching unit associated with a first data group or a second caching unit associated with a second data group based on the analyzed database query, wherein the query result is based on the analyzed database query, wherein a query predicate of the database query to be analyzed by the control device and the analyzed database query to be provided from the control device to the first caching unit when a corresponding table is associated with the first data group, wherein the analyzed database query to be provided from the control device to the second caching unit when a corresponding table is associated with the second data group, wherein the analyzed database query to be provided from the control device to the second caching unit when a corresponding table is associated with the database, wherein the first caching unit to interpret the database query and to search a cache mapping table at the first caching unit to determine effectiveness of the query result for the database query when the interpreted database query is searched in the cache mapping table, wherein the cache mapping table includes information of a version of a query result,
wherein the first caching unit to determine a version of the query result when the interpreted database query is searched in the cache mapping table, and the first caching unit to provide the query result when the determined version corresponds to a latest version,
wherein when the determined version does not correspond to a latest version, the first caching unit to determine the version of the query result when the interpreted database query is searched in the cache mapping table to obtain the query result from the database unit, and
wherein the first caching unit to update the cache mapping table at the first caching unit based on a cache key and the query result obtained from the database unit,
wherein when the interpreted database query is not searched in the cache mapping table, the first cache unit is to be inputted the query result by the user for the interpreted database query through the database unit, the query result inputted by the user through the database unit is directly provided to the user or is provided to the user through the first cache unit after being updated in the first cache unit.

5 more elements

Dependencies are inferred from the claim text.

patentgrep

Loading patent…

Abstract

A database system comprising:

a database configured to store first and second data groups classified based on a data attribute;
a memory that includes a first cache and a second cache, the first cache being associated with the first data group, and including a first cache architecture, the second cache associated with the second data group, and including a second cache architecture;
a receiving device to receive a database query from a user;
and
a control device separate from the database and the memory, wherein the first cache and the second cache are connected to the database through the control device, wherein the control device is a machine, the control device configured to:
receive, at the control device, the database query from the receiving device,
analyze, at the control device, the received database query, and
transmit, from the control device, a query result to the database, the first cache or the second cache, wherein the query result is based on the analyzed database query,
wherein the control device to analyze a query predicate of the database query and the control device to transmit the analyzed database query to the first cache when a corresponding table is associated with the first data group, wherein the control device to transmit the analyzed database query to the second cache when a corresponding table is associated with the second data group, wherein the control device to transmit the analyzed database query to the database when a corresponding table is associated with the database,
wherein the first cache to interpret the transmitted database query and to search a cache mapping table at the first cache to determine effectiveness of the query result for the database query when the interpreted database query is searched in the cache mapping table, wherein the cache mapping table at the first cache includes information of a version of a query result,
wherein the first cache to determine a version of the query result when the interpreted database query is searched in the cache mapping table, and the first cache to provide the query result when the determined version corresponds to a latest version,
wherein when the determined version does not correspond to a latest version, the first cache to determine the version of the query result when the interpreted database query is searched in the cache mapping table to obtain the query result from the database, and
wherein the first cache to update the cache mapping table at the first cache based on a cache key and the query result obtained from the database,
wherein when the interpreted database query is not searched in the cache mapping table, the first cache is to be inputted the query result by the user for the interpreted database query through the database, the query result inputted by the user through the database is directly provided to the user or is provided to the user through the first cache after being updated in the first cache.

11 more elements