US 2014/0156586 A1 · BIG-FAST DATA CONNECTOR BETWEEN IN-MEMORY DATABASE SYSTEM AND DATA WAREHOUSE SYSTEM

Abstract

Embodiments of the present invention include systems and methods for insuring better query consistency between at least two different databases, where one faster database has more up-to-date information than another slower database, and wherein updates are typically applied to the faster database first and then to the slower database. In embodiments, the systems and methods also insure that a query to the slower database is not performed until a set of one or more updates from the faster database have been applied to that slower database.

Claims20

Dependent claims

An in-memory database system that supports fast ingest data transfer between the in-memory database system and a data warehouse system, the in-memory database system comprising:

an in-memory database instance that receives and stores data;
a listener, communicatively coupled to the in-memory database instance, that, responsive to receiving notification that a data event has occurred in the in-memory database instance, selects a queue to which the data event will be sent and sends the data event to the selected queue to be sent to the data warehouse system;
and
the queue system comprising a plurality of queues, each queue comprising a proxy table communicatively coupled to receive the data event from the listener and an associated write-behind listener that determines whether an update condition has been being satisfied for the queue and responsive to an update condition being satisfied, sends the data event to the data warehouse system.

1 more element

Dependencies are inferred from the claim text.

Big-fast data connector between in-memory database system and data warehouse system

Life of this patent

Big-fast data connector between in-memory database system and data warehouse system

Life of this patent

Abstract

Claims20