×

System and method of combined database system

  • US 9,223,848 B2
  • Filed: 10/29/2012
  • Issued: 12/29/2015
  • Est. Priority Date: 10/31/2011
  • Status: Active Grant
First Claim
Patent Images

1. A database system, comprising:

  • an online transaction processing (OLTP) database;

    a warehouse database comprising a short term storage area and a long term record storage area; and

    an application server comprising a processor coupled to a memory, wherein the application server is configured to manage coordination between the OLTP database and the warehouse database by at least;

    periodically duplicating and storing to the short term area of the warehouse database, using an ETL (Extract, Transform, Load) process, all data that has recently been added or changed in the OLTP database, wherein the duplicating and storing is performed at a rate selected in such a way so that during the duplicating and storing at least a predetermined percentage of database queries can be handled by the warehouse database without use of the OLTP database, andafter a predetermined amount of time from when the data is duplicated and stored to the warehouse database, moving the duplicated data from the short term area of the warehouse database to the long term area of the warehouse database and removing from the OLTP database the recently added or changed data;

    wherein the application server is configured such that the OLTP database does not store data which is not also stored in the warehouse database, except for data recently added or changed in the OLTP database which has not yet been duplicated and stored to the warehouse database.

View all claims
  • 3 Assignments
Timeline View
Assignment View
    ×
    ×