×

Computer method and system for combining OLTP database and OLAP database environments

  • US 8,170,981 B1
  • Filed: 12/08/2010
  • Issued: 05/01/2012
  • Est. Priority Date: 12/08/2010
  • Status: Active Grant
First Claim
Patent Images

1. A computer system providing access to both an online transaction processing (OLTP) database server and an online analytics processing (OLAP) database server, comprising:

  • a client application adapted for receiving a query and redirecting the query to the OLTP database server or to the OLAP database server according to (a) mode of operation of the client application and (b) synchronization status of the OLAP database server, the client application redirecting the query;

    to the OLTP database server when the mode of operation is other than a read-only operation or the synchronization status is “

    unsynchronized” and

    to the OLAP database server when the mode of operation is a read-only operation and the synchronization status is “

    synchronized”

    ;

    andan OLTP application server comprising an OLTP adapter and an OLAP adapter, the OLAP adapter comprising a mapping component adapted to map data between OLTP semantics and OLAP semantics.

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