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.
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”;
and
an 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.
2. A computer system as claimed in claim 1 wherein the OLAP adapter maps the query from the OLTP semantic to the OLAP semantic.
3. A computer system as claimed in claim 1 wherein the OLAP adapter maps results of the query from the OLAP semantic to the OLTP semantic.
4. A computer system as claimed in claim 1 further comprising a version indicator stored at the OLTP database server and indicating last completed synchronization between the OLTP database server and the OLAP database server.
5. A computer system as claimed in claim 4 wherein the OLTP application server copies the version indicator into a session state of the client application, and
the client application redirects the query to the OLAP database server when the version indicator stored at the OLTP database server has changed relative to the copy of the version indicator in the client application.
6. A computer implemented method providing access to both an online transaction processing (OLTP) database server and an online analytics processing (OLAP) database server, comprising:
in a client application, 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, said redirecting the query being:
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”;
and
mapping data between OLTP semantics and OLAP semantics.
7. A method as claimed in claim 6 wherein the mapping includes mapping the query from the OLTP semantic to the OLAP semantic.
8. A method as claimed in claim 6 wherein the mapping includes mapping results of the query from the OLAP semantic to the OLTP semantic.
9. A method as claimed in claim 6 further comprising indicating last completed synchronization between the OLTP database server and the OLAP database server.
10. A method as claimed in claim 9 wherein indicating includes storing a version indicator at the OLTP database server; and
the method further comprises:
copying the version indicator into a session state of the client application,
and
redirecting the query to the OLAP database server when the version indicator stored at the OLTP database server has changed relative to the copy of the version indicator in the client application.
11. A computer program product providing access to both an online transaction processing (OLTP) database server and an online analytics processing (OLAP) database server, the computer program product comprising:
a computer readable storage medium having computer readable program code embodied therewith, the computer readable program code including:
computer readable program code configured to receive a query in a client application and redirect 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, said redirecting the query being:
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”;
and
computer readable program code configured to map data between OLTP semantics and OLAP semantics.