Remote materialization of low velocity data

Abstract

A system includes reception of a client query identifying data stored by a remote data source, generation of a remote query of the remote data source based on the client query, determination of a cache name based on the remote query, determination of whether the remote data source comprises a cache associated with the cache name and, if it is determined that the remote data source comprises a valid cache associated with the cache name, instruction of the remote data source to read the data of the cache, and reception of the data of the cache from the remote data source.

Description

BACKGROUND[0001]Conventional database management systems provide stored data to client applications upon request. The data may be stored in local disks and / or local volatile memory (e.g., Random Access Memory) in order to enable fast access thereto. Some database management systems are also capable of pulling data from remote (and typically large-scale) data sources. Systems are desired to interact with such remote data sources in order to efficiently provide the remote data to client applications.BRIEF DESCRIPTION OF THE DRAWINGS[0002]FIG. 1 is a block diagram of a system according to some embodiments.[0003]FIG. 2 is a flow diagram of a process according to some embodiments.[0004]FIG. 3 is a block diagram of a system according to some embodiments.[0005]FIG. 4 is a detailed block diagram of a system according to some embodiments.[0006]FIG. 5 is a block diagram of an apparatus according to some embodiments.DETAILED DESCRIPTION[0007]The following description is provided to enable any ...

AI Technical Summary

Benefits of technology

The patent describes a system that allows a data server to efficiently provide data to client applications by interacting with remote data sources. The system includes a data server, client, and remote data source. The data server receives queries from the client and provides results based on data stored in local disks and volatile memory. The remote data source may be a structured-query language (SQL) relational database, a multi-dimensional database, an eXtendable Markup Language (XML) document, or any other data storage system. The system may also include a distributed file system, such as Apache Hadoop, for retrieving data from remote sources. The technical effect of the patent is to enable faster and more efficient interaction with remote data sources to provide data to client applications.

Problems solved by technology

However, as the cache ages, the likelihood that its data no longer reflects the current data of the remote data source 130 increases.

Images