Heterogeneous database processing archetypes for hybrid system

Patent metadata

Field	Value
Publication number	US-10095733-B2
Application number	US-201414508816-A
Country	US
Kind code	B2
Filing date	Oct 7, 2014
Priority date	Oct 7, 2014
Publication date	Oct 9, 2018
Grant date	Oct 9, 2018

Abstract

A database processing system can support applications of an online transaction processing (OLTP) archetype and of an online analytical processing (OLAP) archetype. Hybrid archetypes can also be supported to implement hybrid scenarios. Requests for services are routed to an appropriate engine for fulfillment. User interface assets can be served by a shared infrastructure. Seamless navigation from one archetype to another can be supported in an insight-to-action scenario.

First claim

What is claimed is:

1. A method implemented at least in part by a computer, the method comprising:
receiving a processing request, at a request dispatcher, from a client-side shell supporting heterogeneous archetypes of client application programs comprising a transactional application archetype and an analytical application archetype;
based on whether the processing request is for transactional processing or analytical processing, choosing between directing the processing request to a transactional engine configured to perform at least one transactional operation on a database, and directing the processing request to an analytical engine configured to perform at least one analytical operation on the same database, wherein the transactional engine comprises a first service executing on a first server and the analytical engine comprises a second service executing on a second server, wherein directing the processing request to the transactional engine comprises sending the processing request from the request dispatcher to the first service executing on the first server over a computer network, and directing the processing request to the analytical engine comprises sending the processing request from the from the request dispatcher to the second service executing on the second server over the computer network;
receiving requests for a plurality of user interface assets from the client-side shell at the request dispatcher, wherein the plurality of assets comprise a user interface asset for transactional processing and another user interface asset for analytical processing;
retrieving the plurality of user interface assets from a user interface server storing user interface assets shared between transactional application archetype client applications and analytical application archetype client applications, wherein the retrieved plurality of user interface assets enable the client-side shell to send requests, including the processing request, for transactional processing and analytical processing; and
sending the user interface asset to the client-side shell.

2. The method of claim 1 , further comprising:
in response to the processing request, sending a result of the at least one transactional operation back to the client-side shell or sending a result of the at least one analytical operation back to the client-side shell.

3. The method of claim 1 wherein:
the processing request is for analytical processing; and
a result of the at least one analytical operation is presented by a client application program of the analytical application archetype; and
the method further comprises:
receiving a second processing request from a client application program of the transactional application archetype after seamlessly transitioning from a user interface of the client application program of the analytical application archetype to a user interface of the client application program of the transactional application archetype, wherein the second processing request comprises transactional processing on a result of the at least one analytical operation.

4. The method of claim 1 wherein:
the client-side shell further supports a search application archetype;
the method further comprising:
receiving a second processing request from a client program hosted by the client-side shell for search processing; and
directing the second processing request to a search engine configured to perform at least one search operation via the database.

5. A system comprising:
a client computing device comprising one or more processors and one or more computer-readable non-transitory media comprising a client-executable shell supporting heterogeneous archetypes of client application programs comprising a transactional application archetype and an analytical application archetype that, when executed by the one or more processors, cause the client computing device to:
send processing requests for online transaction processing to a server-side transactional engine service running on a first server, wherein the server-side transactional engine is configured to perform online transaction processing on a database,
send processing requests for online analytical processing to a separate server-side analytical engine service running on a second server, wherein the server-side analytical engine is configured to perform online analytical processing on the same database,
send requests for user interface assets to a separate frontend server,
receive the user interface assets from the separate frontend server, and
use the user interface assets to send the processing requests for online transaction processing and to send the processing requests for online analytical processing; and

the frontend server, comprising a plurality of user interface assets, wherein the user interface assets comprise user interface assets for online transaction processing user interfaces presented in the client-executable shell and user interface assets for online analytical processing user interfaces presented in the client-executable shell.

6. The system of claim 5 wherein the frontend server is configured to provide both the user interface assets for online transaction processing user interfaces and the user interface assets for online analytical processing user interfaces using a shared infrastructure.

7. The system of claim 5 wherein:
a given processing request is routed between the server-side transactional engine or the server-side analytical engine via an indication in the given processing request.

8. The system of claim 5 wherein:
the client-executable shell directs requests across heterogeneous archetypes to a same entry point.

9. The system of claim 5 further comprising:
a content server storing the client application programs configured to provide the client application programs upon request of the client-executable shell.

10. The system of claim 5 further comprising:
a client application program of the transactional application archetype; and
a client application program of the analytical application archetype;
wherein the client-executable shell supports seamless navigation from a user interface of the client application program of the transactional application archetype to a user interface of the client application program of the analytical application archetype to perform transaction processing on data shown in an analytical setting.

11. The system of claim 10 wherein:
the client application program of the transactional application archetype and the client application program of the analytical application archetype are integrated into a single, hybrid client application.

12. The system of claim 5 further comprising:
the server-side transactional engine supporting online transaction processing on the database and configured to provide online transaction processing as a service; and
the server-side analytical engine supporting online analytical processing on the same database and configured to provide online analytical processing as a service.

13. The system of claim 5 wherein:
the client-executable shell supports consistent navigation and personalization across the heterogeneous archetypes.

14. The system of claim 5 further comprising:
a dispatcher configured to accept incoming requests comprising the requests for online transaction processing and the requests for online analytical processing, and further configured to selectively direct the incoming processing requests between the server-side transactional engine and the server-side analytical engine.

15. The system of claim 14 wherein:
the incoming processing requests are dir

Assignees

• Brunswig Frank
• Bohle Holger
• Cherdron Markus
• Hammerich Reiner
• Lingg Alexander
• Richstein Hans Juergen
• Stein Tobias
• Tielsch Gregor
• Walterthum Luc
• Sap Se

Inventors

• Brunswig Frank
• Bohle Holger
• Cherdron Markus
• Hammerich Reiner
• Lingg Alexander
• Richstein Hans-Juergen
• Stein Tobias
• Tielsch Gregor
• Walterthum Luc

Classifications

• G06F16/245 Primary

  Query processing · CPC title

• G06F16/2456

  Join operations · CPC title

• G06F16/24568

  Data stream processing; Continuous queries · CPC title

• G06F16/28

  Databases characterised by their database models, e.g. relational or object models · CPC title

• G06F16/2471

  Distributed queries · CPC title