COMPUTER METHOD AND SYSTEM FOR COMBINING OLTP DATABASE AND OLAP DATABASE ENVIRONMENTS

摘要

A computer system provides access to both an online transaction processing (OLTP) database server and an online analytics processing (OLAP) database server. The computer system includes a client application adapted to receive a query. According to (a) mode of operation (e.g., read or update) of the client application and (b) synchronization status of the OLAP database server, the client application redirects the query to the OLTP database server or to the OLAP database server. The client application redirects 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”. The client application redirects the query to the OLAP database server when the mode of operation is a read-only operation and the synchronization status is “synchronized”. The computer system further includes an OLTP application server (e.g., Enovia V6) comprising an OLTP adapter and an OLAP adapter. The OLAP adapter is formed of a mapping component adapted to map data between OLTP semantics and OLAP semantics.